PREVIEW / futures_30min / 2010-12-12
file: by_date/futures_30min/2010/2010-12-12.parquet size: 19 KB rows: 473
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-12 18:00:00 | ES | Futures | 1224.51 | 1225.25 | 1221.3 | 1222.54 | 2541.0 |
| 2010-12-12 18:30:00 | ES | Futures | 1222.78 | 1222.78 | 1220.56 | 1221.3 | 1586.0 |
| 2010-12-12 19:00:00 | ES | Futures | 1221.55 | 1222.29 | 1221.3 | 1222.29 | 462.0 |
| 2010-12-12 19:30:00 | ES | Futures | 1222.54 | 1223.03 | 1221.8 | 1221.8 | 442.0 |
| 2010-12-12 20:00:00 | ES | Futures | 1222.04 | 1222.78 | 1220.32 | 1220.32 | 838.0 |
| 2010-12-12 20:30:00 | ES | Futures | 1220.56 | 1223.27 | 1219.33 | 1223.03 | 3397.0 |
| 2010-12-12 21:00:00 | ES | Futures | 1222.78 | 1223.27 | 1222.29 | 1222.29 | 529.0 |
| 2010-12-12 21:30:00 | ES | Futures | 1222.54 | 1223.52 | 1222.29 | 1222.78 | 428.0 |
| 2010-12-12 22:00:00 | ES | Futures | 1222.78 | 1223.52 | 1222.29 | 1223.27 | 451.0 |
| 2010-12-12 22:30:00 | ES | Futures | 1223.03 | 1223.52 | 1222.54 | 1222.78 | 475.0 |
| 2010-12-12 23:00:00 | ES | Futures | 1223.27 | 1223.27 | 1222.29 | 1222.78 | 199.0 |
| 2010-12-12 23:30:00 | ES | Futures | 1222.78 | 1223.03 | 1221.8 | 1221.8 | 641.0 |
| 2010-12-12 18:00:00 | NQ | Futures | 2545.11 | 2563.76 | 2539.66 | 2542.53 | 213.0 |
| 2010-12-12 18:30:00 | NQ | Futures | 2541.96 | 2541.96 | 2537.37 | 2538.51 | 82.0 |
| 2010-12-12 19:00:00 | NQ | Futures | 2539.66 | 2542.24 | 2539.09 | 2541.96 | 77.0 |
| 2010-12-12 19:30:00 | NQ | Futures | 2542.82 | 2543.1 | 2542.53 | 2543.1 | 12.0 |
| 2010-12-12 20:00:00 | NQ | Futures | 2541.96 | 2544.54 | 2540.81 | 2540.81 | 89.0 |
| 2010-12-12 20:30:00 | NQ | Futures | 2540.23 | 2545.69 | 2538.8 | 2545.4 | 36.0 |
| 2010-12-12 21:00:00 | NQ | Futures | 2545.11 | 2545.4 | 2543.68 | 2543.68 | 56.0 |
| 2010-12-12 21:30:00 | NQ | Futures | 2543.1 | 2545.4 | 2543.1 | 2544.83 | 32.0 |
| 2010-12-12 22:00:00 | NQ | Futures | 2543.96 | 2545.4 | 2543.39 | 2545.4 | 43.0 |
| 2010-12-12 22:30:00 | NQ | Futures | 2544.83 | 2545.4 | 2544.25 | 2545.4 | 14.0 |
| 2010-12-12 23:00:00 | NQ | Futures | 2543.68 | 2544.25 | 2543.68 | 2543.96 | 5.0 |
| 2010-12-12 23:30:00 | NQ | Futures | 2543.96 | 2544.54 | 2541.96 | 2541.96 | 31.0 |
| 2010-12-12 18:00:00 | YM | Futures | 10876.6 | 10883.3 | 10850.7 | 10859.3 | 116.0 |
| 2010-12-12 18:30:00 | YM | Futures | 10858.4 | 10859.3 | 10838.3 | 10845.0 | 81.0 |
| 2010-12-12 19:00:00 | YM | Futures | 10847.8 | 10856.5 | 10847.8 | 10856.5 | 44.0 |
| 2010-12-12 19:30:00 | YM | Futures | 10857.4 | 10862.2 | 10854.5 | 10856.5 | 187.0 |
| 2010-12-12 20:00:00 | YM | Futures | 10857.4 | 10864.1 | 10843.1 | 10844.0 | 124.0 |
| 2010-12-12 20:30:00 | YM | Futures | 10845.0 | 10865.1 | 10838.3 | 10865.1 | 150.0 |
| 2010-12-12 21:00:00 | YM | Futures | 10865.1 | 10865.1 | 10859.3 | 10860.3 | 45.0 |
| 2010-12-12 21:30:00 | YM | Futures | 10860.3 | 10867.0 | 10860.3 | 10864.1 | 37.0 |
| 2010-12-12 22:00:00 | YM | Futures | 10864.1 | 10867.0 | 10858.4 | 10866.0 | 86.0 |
| 2010-12-12 22:30:00 | YM | Futures | 10867.0 | 10869.9 | 10860.3 | 10868.0 | 51.0 |
| 2010-12-12 23:00:00 | YM | Futures | 10865.1 | 10866.0 | 10860.3 | 10865.1 | 29.0 |
| 2010-12-12 23:30:00 | YM | Futures | 10865.1 | 10866.0 | 10855.5 | 10856.5 | 39.0 |
| 2010-12-12 18:00:00 | CL | Futures | 163.63 | 164.12 | 163.37 | 163.39 | 627.0 |
| 2010-12-12 18:30:00 | CL | Futures | 163.44 | 163.54 | 163.18 | 163.24 | 447.0 |
| 2010-12-12 19:00:00 | CL | Futures | 163.26 | 163.61 | 163.24 | 163.59 | 361.0 |
| 2010-12-12 19:30:00 | CL | Futures | 163.59 | 163.8 | 163.57 | 163.61 | 411.0 |
| 2010-12-12 20:00:00 | CL | Futures | 163.61 | 163.91 | 163.57 | 163.67 | 554.0 |
| 2010-12-12 20:30:00 | CL | Futures | 163.67 | 163.95 | 163.63 | 163.93 | 319.0 |
| 2010-12-12 21:00:00 | CL | Futures | 163.93 | 164.23 | 163.93 | 164.19 | 553.0 |
| 2010-12-12 21:30:00 | CL | Futures | 164.17 | 164.53 | 164.17 | 164.45 | 666.0 |
| 2010-12-12 22:00:00 | CL | Futures | 164.45 | 164.71 | 164.36 | 164.69 | 601.0 |
| 2010-12-12 22:30:00 | CL | Futures | 164.68 | 164.71 | 164.38 | 164.41 | 380.0 |
| 2010-12-12 23:00:00 | CL | Futures | 164.45 | 164.45 | 164.17 | 164.21 | 521.0 |
| 2010-12-12 23:30:00 | CL | Futures | 164.23 | 164.34 | 164.17 | 164.23 | 390.0 |
| 2010-12-12 18:00:00 | GC | Futures | 1934.6 | 1935.3 | 1932.6 | 1933.3 | 709.0 |
| 2010-12-12 18:30:00 | GC | Futures | 1933.4 | 1935.1 | 1928.7 | 1929.7 | 836.0 |
> showing 50 of 473 rows — these rows as CSV