PREVIEW / futures_30min / 2013-11-17
file: by_date/futures_30min/2013/2013-11-17.parquet size: 19 KB rows: 483
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2013-11-17 18:00:00 | ES | Futures | 1850.61 | 1851.64 | 1850.35 | 1851.64 | 5160.0 |
| 2013-11-17 18:30:00 | ES | Futures | 1851.64 | 1851.9 | 1850.09 | 1850.09 | 1906.0 |
| 2013-11-17 19:00:00 | ES | Futures | 1850.09 | 1850.61 | 1848.54 | 1849.58 | 4053.0 |
| 2013-11-17 19:30:00 | ES | Futures | 1849.32 | 1849.58 | 1848.8 | 1849.06 | 2129.0 |
| 2013-11-17 20:00:00 | ES | Futures | 1849.06 | 1849.58 | 1848.54 | 1849.06 | 2110.0 |
| 2013-11-17 20:30:00 | ES | Futures | 1849.06 | 1849.58 | 1849.06 | 1849.32 | 1457.0 |
| 2013-11-17 21:00:00 | ES | Futures | 1849.58 | 1849.58 | 1848.54 | 1849.32 | 1292.0 |
| 2013-11-17 21:30:00 | ES | Futures | 1849.06 | 1849.58 | 1848.8 | 1849.06 | 911.0 |
| 2013-11-17 22:00:00 | ES | Futures | 1849.06 | 1849.58 | 1848.8 | 1849.32 | 1570.0 |
| 2013-11-17 22:30:00 | ES | Futures | 1849.32 | 1849.83 | 1848.29 | 1848.54 | 3272.0 |
| 2013-11-17 23:00:00 | ES | Futures | 1848.8 | 1849.06 | 1847.77 | 1849.06 | 3462.0 |
| 2013-11-17 23:30:00 | ES | Futures | 1848.8 | 1849.32 | 1848.29 | 1849.32 | 1449.0 |
| 2013-11-17 18:00:00 | NQ | Futures | 3969.05 | 3973.12 | 3968.47 | 3972.83 | 537.0 |
| 2013-11-17 18:30:00 | NQ | Futures | 3973.12 | 3973.7 | 3970.21 | 3970.21 | 269.0 |
| 2013-11-17 19:00:00 | NQ | Futures | 3970.21 | 3970.5 | 3966.73 | 3968.47 | 496.0 |
| 2013-11-17 19:30:00 | NQ | Futures | 3968.76 | 3968.76 | 3966.73 | 3967.6 | 246.0 |
| 2013-11-17 20:00:00 | NQ | Futures | 3967.6 | 3968.47 | 3966.44 | 3967.6 | 148.0 |
| 2013-11-17 20:30:00 | NQ | Futures | 3967.89 | 3969.05 | 3967.6 | 3968.47 | 220.0 |
| 2013-11-17 21:00:00 | NQ | Futures | 3968.18 | 3969.05 | 3967.02 | 3968.18 | 148.0 |
| 2013-11-17 21:30:00 | NQ | Futures | 3968.18 | 3968.76 | 3967.6 | 3967.89 | 125.0 |
| 2013-11-17 22:00:00 | NQ | Futures | 3967.89 | 3969.34 | 3967.31 | 3968.76 | 210.0 |
| 2013-11-17 22:30:00 | NQ | Futures | 3968.47 | 3970.21 | 3966.73 | 3967.31 | 476.0 |
| 2013-11-17 23:00:00 | NQ | Futures | 3967.31 | 3967.89 | 3965.28 | 3967.89 | 449.0 |
| 2013-11-17 23:30:00 | NQ | Futures | 3967.6 | 3968.18 | 3966.15 | 3967.89 | 148.0 |
| 2013-11-17 18:00:00 | YM | Futures | 16251.1 | 16261.3 | 16251.1 | 16258.3 | 363.0 |
| 2013-11-17 18:30:00 | YM | Futures | 16258.3 | 16261.3 | 16250.1 | 16250.1 | 151.0 |
| 2013-11-17 19:00:00 | YM | Futures | 16251.1 | 16253.1 | 16241.9 | 16244.0 | 711.0 |
| 2013-11-17 19:30:00 | YM | Futures | 16248.0 | 16248.0 | 16240.9 | 16242.9 | 391.0 |
| 2013-11-17 20:00:00 | YM | Futures | 16242.9 | 16246.0 | 16239.9 | 16244.0 | 395.0 |
| 2013-11-17 20:30:00 | YM | Futures | 16245.0 | 16249.1 | 16242.9 | 16248.0 | 375.0 |
| 2013-11-17 21:00:00 | YM | Futures | 16248.0 | 16249.1 | 16240.9 | 16246.0 | 335.0 |
| 2013-11-17 21:30:00 | YM | Futures | 16246.0 | 16248.0 | 16242.9 | 16244.0 | 234.0 |
| 2013-11-17 22:00:00 | YM | Futures | 16242.9 | 16248.0 | 16240.9 | 16248.0 | 242.0 |
| 2013-11-17 22:30:00 | YM | Futures | 16247.0 | 16250.1 | 16239.9 | 16240.9 | 473.0 |
| 2013-11-17 23:00:00 | YM | Futures | 16240.9 | 16244.0 | 16235.8 | 16244.0 | 542.0 |
| 2013-11-17 23:30:00 | YM | Futures | 16244.0 | 16245.0 | 16237.8 | 16245.0 | 405.0 |
| 2013-11-17 18:00:00 | CL | Futures | 149.22 | 149.33 | 149.07 | 149.1 | 367.0 |
| 2013-11-17 18:30:00 | CL | Futures | 149.14 | 149.19 | 149.14 | 149.18 | 44.0 |
| 2013-11-17 19:00:00 | CL | Futures | 149.16 | 149.18 | 148.81 | 148.83 | 376.0 |
| 2013-11-17 19:30:00 | CL | Futures | 148.83 | 148.91 | 148.78 | 148.89 | 145.0 |
| 2013-11-17 20:00:00 | CL | Futures | 148.91 | 149.0 | 148.86 | 148.99 | 159.0 |
| 2013-11-17 20:30:00 | CL | Futures | 148.97 | 149.03 | 148.92 | 148.99 | 128.0 |
| 2013-11-17 21:00:00 | CL | Futures | 148.97 | 149.03 | 148.95 | 148.99 | 72.0 |
| 2013-11-17 21:30:00 | CL | Futures | 148.99 | 149.02 | 148.88 | 148.89 | 123.0 |
| 2013-11-17 22:00:00 | CL | Futures | 148.95 | 149.0 | 148.91 | 148.95 | 55.0 |
| 2013-11-17 22:30:00 | CL | Futures | 148.95 | 149.05 | 148.92 | 149.02 | 90.0 |
| 2013-11-17 23:00:00 | CL | Futures | 149.02 | 149.03 | 148.91 | 148.91 | 60.0 |
| 2013-11-17 23:30:00 | CL | Futures | 148.89 | 148.91 | 148.67 | 148.8 | 253.0 |
| 2013-11-17 18:00:00 | GC | Futures | 1766.8 | 1767.1 | 1765.0 | 1765.0 | 458.0 |
| 2013-11-17 18:30:00 | GC | Futures | 1765.0 | 1767.2 | 1764.7 | 1764.7 | 316.0 |
> showing 50 of 483 rows — these rows as CSV