PREVIEW / futures_30min / 2014-04-13
file: by_date/futures_30min/2014/2014-04-13.parquet size: 20 KB rows: 521
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 |
|---|---|---|---|---|---|---|---|
| 2014-04-13 18:00:00 | ES | Futures | 1875.86 | 1878.2 | 1873.79 | 1874.05 | 16791.0 |
| 2014-04-13 18:30:00 | ES | Futures | 1874.05 | 1875.6 | 1873.01 | 1875.35 | 5102.0 |
| 2014-04-13 19:00:00 | ES | Futures | 1875.6 | 1876.64 | 1874.83 | 1875.35 | 2715.0 |
| 2014-04-13 19:30:00 | ES | Futures | 1875.6 | 1877.68 | 1875.35 | 1877.42 | 3443.0 |
| 2014-04-13 20:00:00 | ES | Futures | 1877.16 | 1881.06 | 1877.16 | 1879.76 | 7847.0 |
| 2014-04-13 20:30:00 | ES | Futures | 1879.76 | 1880.54 | 1876.9 | 1877.16 | 4682.0 |
| 2014-04-13 21:00:00 | ES | Futures | 1877.16 | 1878.98 | 1876.64 | 1878.46 | 2936.0 |
| 2014-04-13 21:30:00 | ES | Futures | 1878.46 | 1881.06 | 1877.68 | 1880.54 | 4430.0 |
| 2014-04-13 22:00:00 | ES | Futures | 1880.54 | 1881.06 | 1878.2 | 1878.98 | 3566.0 |
| 2014-04-13 22:30:00 | ES | Futures | 1878.98 | 1880.02 | 1877.68 | 1878.46 | 2551.0 |
| 2014-04-13 23:00:00 | ES | Futures | 1878.46 | 1879.24 | 1878.2 | 1878.98 | 1206.0 |
| 2014-04-13 23:30:00 | ES | Futures | 1879.24 | 1879.24 | 1877.68 | 1878.46 | 1391.0 |
| 2014-04-13 18:00:00 | NQ | Futures | 4002.27 | 4002.56 | 3991.49 | 3992.37 | 1803.0 |
| 2014-04-13 18:30:00 | NQ | Futures | 3992.37 | 3997.32 | 3990.04 | 3997.03 | 670.0 |
| 2014-04-13 19:00:00 | NQ | Futures | 3996.44 | 3999.94 | 3995.57 | 3996.73 | 417.0 |
| 2014-04-13 19:30:00 | NQ | Futures | 3997.03 | 4003.72 | 3996.44 | 4002.27 | 600.0 |
| 2014-04-13 20:00:00 | NQ | Futures | 4002.85 | 4011.88 | 4002.85 | 4009.55 | 1221.0 |
| 2014-04-13 20:30:00 | NQ | Futures | 4009.55 | 4010.42 | 3998.77 | 3999.36 | 1515.0 |
| 2014-04-13 21:00:00 | NQ | Futures | 3999.65 | 4004.89 | 3999.06 | 4003.43 | 507.0 |
| 2014-04-13 21:30:00 | NQ | Futures | 4003.43 | 4008.97 | 4001.98 | 4008.67 | 778.0 |
| 2014-04-13 22:00:00 | NQ | Futures | 4008.67 | 4009.26 | 4004.31 | 4006.05 | 764.0 |
| 2014-04-13 22:30:00 | NQ | Futures | 4006.05 | 4009.26 | 4002.85 | 4004.6 | 441.0 |
| 2014-04-13 23:00:00 | NQ | Futures | 4004.89 | 4006.93 | 4003.43 | 4006.64 | 272.0 |
| 2014-04-13 23:30:00 | NQ | Futures | 4006.93 | 4007.22 | 4004.02 | 4005.76 | 250.0 |
| 2014-04-13 18:00:00 | YM | Futures | 16423.2 | 16424.2 | 16355.2 | 16393.3 | 1409.0 |
| 2014-04-13 18:30:00 | YM | Futures | 16392.3 | 16407.7 | 16387.1 | 16406.7 | 506.0 |
| 2014-04-13 19:00:00 | YM | Futures | 16407.7 | 16414.9 | 16399.5 | 16400.5 | 484.0 |
| 2014-04-13 19:30:00 | YM | Futures | 16402.6 | 16417.0 | 16398.5 | 16416.0 | 544.0 |
| 2014-04-13 20:00:00 | YM | Futures | 16413.9 | 16444.8 | 16413.9 | 16434.5 | 1009.0 |
| 2014-04-13 20:30:00 | YM | Futures | 16434.5 | 16443.8 | 16413.9 | 16416.0 | 675.0 |
| 2014-04-13 21:00:00 | YM | Futures | 16416.0 | 16430.4 | 16413.9 | 16426.3 | 460.0 |
| 2014-04-13 21:30:00 | YM | Futures | 16426.3 | 16442.7 | 16419.1 | 16441.7 | 428.0 |
| 2014-04-13 22:00:00 | YM | Futures | 16441.7 | 16442.7 | 16424.2 | 16427.3 | 444.0 |
| 2014-04-13 22:30:00 | YM | Futures | 16430.4 | 16436.6 | 16421.1 | 16424.2 | 275.0 |
| 2014-04-13 23:00:00 | YM | Futures | 16423.2 | 16431.4 | 16423.2 | 16430.4 | 171.0 |
| 2014-04-13 23:30:00 | YM | Futures | 16431.4 | 16431.4 | 16423.2 | 16427.3 | 291.0 |
| 2014-04-13 18:00:00 | CL | Futures | 163.94 | 165.05 | 163.94 | 165.0 | 408.0 |
| 2014-04-13 18:30:00 | CL | Futures | 164.98 | 165.24 | 164.95 | 165.11 | 165.0 |
| 2014-04-13 19:00:00 | CL | Futures | 165.13 | 165.16 | 164.98 | 165.06 | 71.0 |
| 2014-04-13 19:30:00 | CL | Futures | 165.05 | 165.17 | 164.98 | 165.14 | 46.0 |
| 2014-04-13 20:00:00 | CL | Futures | 165.14 | 165.29 | 165.14 | 165.29 | 81.0 |
| 2014-04-13 20:30:00 | CL | Futures | 165.27 | 165.57 | 165.25 | 165.46 | 251.0 |
| 2014-04-13 21:00:00 | CL | Futures | 165.43 | 165.53 | 165.37 | 165.51 | 141.0 |
| 2014-04-13 21:30:00 | CL | Futures | 165.51 | 165.51 | 165.43 | 165.46 | 50.0 |
| 2014-04-13 22:00:00 | CL | Futures | 165.46 | 165.56 | 165.41 | 165.56 | 38.0 |
| 2014-04-13 22:30:00 | CL | Futures | 165.54 | 165.54 | 165.4 | 165.43 | 58.0 |
| 2014-04-13 23:00:00 | CL | Futures | 165.48 | 165.59 | 165.4 | 165.56 | 105.0 |
| 2014-04-13 23:30:00 | CL | Futures | 165.57 | 165.57 | 165.46 | 165.49 | 50.0 |
| 2014-04-13 18:00:00 | GC | Futures | 1809.6 | 1818.7 | 1807.4 | 1818.5 | 3858.0 |
| 2014-04-13 18:30:00 | GC | Futures | 1818.7 | 1820.0 | 1816.9 | 1819.1 | 1023.0 |
> showing 50 of 521 rows — these rows as CSV