# xSQL Financial Samples

> As explained in the `samples/xsql/scripts/financial/readme.txt` file, the SQL sample files `*.sql` in this directory are designed to demonstrate the use of various SQL analytics functions on sequences (time-series) using xSQL. They can be run by starting xSQL with the following commands:

>         cd eXtremeDB/samples/xsql/scripts/financial

>         ..\..\..\..\target\bin\xsql -i

> ## Command files

> To facilitate running the sample scripts, the following command files are provided:

> ### xslq.bat (xsql.sh)

> This command file launches xSQL with an argument list. It is provided to avoid the necessity to typing the long command line above. For example the following command line launches xSQL in interactive mode, creating a database of size 100Mb and running the scirpt file `quote.sql`:

>         xsql -i -size 100m -f quote.sql

> ### x.bat (x.sh)

> This command file is provided to run query examples in script files `x1.sql` thru `x15.sql` that demonstrate practical queries using sequences:

>         x 15

> ### f.bat (f.sh)

> This command file is provided to run simple statistical queries in script files `f1.sql` thru `f5.sql`:

>         f 5

> ### g.bat (g.sh)

> This command file is provided to run simple statistical queries in script files `g6.sql` thru `g11.sql`:

>         g 11