PREVIEW / futures_30min / 2010-11-14
file: by_date/futures_30min/2010/2010-11-14.parquet size: 21 KB rows: 505
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-11-14 18:00:00 | ES | Futures | 1178.66 | 1180.39 | 1178.17 | 1180.14 | 9486.0 |
| 2010-11-14 18:30:00 | ES | Futures | 1179.89 | 1180.88 | 1179.4 | 1180.39 | 2673.0 |
| 2010-11-14 19:00:00 | ES | Futures | 1180.14 | 1181.13 | 1179.65 | 1180.39 | 3663.0 |
| 2010-11-14 19:30:00 | ES | Futures | 1180.39 | 1181.87 | 1180.14 | 1181.37 | 2520.0 |
| 2010-11-14 20:00:00 | ES | Futures | 1181.37 | 1182.11 | 1180.88 | 1182.11 | 2853.0 |
| 2010-11-14 20:30:00 | ES | Futures | 1182.11 | 1183.35 | 1181.87 | 1182.36 | 6456.0 |
| 2010-11-14 21:00:00 | ES | Futures | 1182.11 | 1182.36 | 1180.14 | 1180.39 | 5029.0 |
| 2010-11-14 21:30:00 | ES | Futures | 1180.63 | 1181.62 | 1180.14 | 1180.63 | 2131.0 |
| 2010-11-14 22:00:00 | ES | Futures | 1180.63 | 1181.13 | 1178.91 | 1179.15 | 2521.0 |
| 2010-11-14 22:30:00 | ES | Futures | 1179.4 | 1179.65 | 1178.42 | 1178.91 | 5170.0 |
| 2010-11-14 23:00:00 | ES | Futures | 1178.66 | 1180.14 | 1178.42 | 1180.14 | 2070.0 |
| 2010-11-14 23:30:00 | ES | Futures | 1180.14 | 1181.37 | 1179.89 | 1181.13 | 1918.0 |
| 2010-11-14 18:00:00 | NQ | Futures | 2449.0 | 2452.44 | 2447.85 | 2452.16 | 712.0 |
| 2010-11-14 18:30:00 | NQ | Futures | 2451.87 | 2453.88 | 2451.58 | 2452.73 | 181.0 |
| 2010-11-14 19:00:00 | NQ | Futures | 2452.16 | 2454.16 | 2451.58 | 2453.02 | 308.0 |
| 2010-11-14 19:30:00 | NQ | Futures | 2453.3 | 2456.46 | 2453.3 | 2455.02 | 506.0 |
| 2010-11-14 20:00:00 | NQ | Futures | 2455.02 | 2456.75 | 2454.16 | 2456.17 | 244.0 |
| 2010-11-14 20:30:00 | NQ | Futures | 2456.17 | 2458.47 | 2456.17 | 2457.03 | 315.0 |
| 2010-11-14 21:00:00 | NQ | Futures | 2456.75 | 2457.03 | 2454.16 | 2454.45 | 1114.0 |
| 2010-11-14 21:30:00 | NQ | Futures | 2455.02 | 2456.17 | 2453.59 | 2454.16 | 161.0 |
| 2010-11-14 22:00:00 | NQ | Futures | 2454.16 | 2454.45 | 2452.16 | 2452.44 | 619.0 |
| 2010-11-14 22:30:00 | NQ | Futures | 2452.73 | 2453.88 | 2451.01 | 2451.87 | 408.0 |
| 2010-11-14 23:00:00 | NQ | Futures | 2452.16 | 2453.88 | 2451.58 | 2453.59 | 134.0 |
| 2010-11-14 23:30:00 | NQ | Futures | 2453.59 | 2455.89 | 2453.59 | 2455.89 | 147.0 |
| 2010-11-14 18:00:00 | YM | Futures | 10622.0 | 10638.2 | 10621.1 | 10634.4 | 241.0 |
| 2010-11-14 18:30:00 | YM | Futures | 10632.5 | 10639.2 | 10629.7 | 10633.5 | 75.0 |
| 2010-11-14 19:00:00 | YM | Futures | 10633.5 | 10643.0 | 10628.7 | 10633.5 | 163.0 |
| 2010-11-14 19:30:00 | YM | Futures | 10635.4 | 10648.7 | 10635.4 | 10644.0 | 126.0 |
| 2010-11-14 20:00:00 | YM | Futures | 10643.0 | 10650.6 | 10642.1 | 10648.7 | 71.0 |
| 2010-11-14 20:30:00 | YM | Futures | 10649.7 | 10658.2 | 10647.8 | 10648.7 | 292.0 |
| 2010-11-14 21:00:00 | YM | Futures | 10648.7 | 10650.6 | 10633.5 | 10633.5 | 251.0 |
| 2010-11-14 21:30:00 | YM | Futures | 10635.4 | 10644.9 | 10634.4 | 10639.2 | 155.0 |
| 2010-11-14 22:00:00 | YM | Futures | 10638.2 | 10640.1 | 10624.9 | 10625.9 | 128.0 |
| 2010-11-14 22:30:00 | YM | Futures | 10626.8 | 10629.7 | 10619.2 | 10624.9 | 249.0 |
| 2010-11-14 23:00:00 | YM | Futures | 10624.9 | 10631.6 | 10616.3 | 10631.6 | 309.0 |
| 2010-11-14 23:30:00 | YM | Futures | 10631.6 | 10640.1 | 10630.6 | 10639.2 | 157.0 |
| 2010-11-14 18:00:00 | CL | Futures | 159.04 | 159.66 | 159.02 | 159.38 | 421.0 |
| 2010-11-14 18:30:00 | CL | Futures | 159.45 | 159.64 | 159.34 | 159.38 | 191.0 |
| 2010-11-14 19:00:00 | CL | Futures | 159.36 | 160.01 | 159.36 | 159.93 | 131.0 |
| 2010-11-14 19:30:00 | CL | Futures | 159.95 | 160.2 | 159.93 | 160.01 | 196.0 |
| 2010-11-14 20:00:00 | CL | Futures | 160.01 | 160.23 | 159.97 | 160.2 | 247.0 |
| 2010-11-14 20:30:00 | CL | Futures | 160.21 | 160.27 | 160.08 | 160.27 | 162.0 |
| 2010-11-14 21:00:00 | CL | Futures | 160.29 | 160.33 | 159.82 | 159.9 | 242.0 |
| 2010-11-14 21:30:00 | CL | Futures | 159.88 | 160.23 | 159.86 | 160.23 | 140.0 |
| 2010-11-14 22:00:00 | CL | Futures | 160.23 | 160.23 | 159.77 | 159.77 | 196.0 |
| 2010-11-14 22:30:00 | CL | Futures | 159.77 | 159.77 | 159.32 | 159.39 | 177.0 |
| 2010-11-14 23:00:00 | CL | Futures | 159.39 | 159.41 | 159.28 | 159.36 | 126.0 |
| 2010-11-14 23:30:00 | CL | Futures | 159.47 | 159.66 | 159.47 | 159.62 | 165.0 |
| 2010-11-14 18:00:00 | GC | Futures | 1918.1 | 1918.1 | 1914.3 | 1916.7 | 1306.0 |
| 2010-11-14 18:30:00 | GC | Futures | 1916.7 | 1917.2 | 1914.0 | 1916.5 | 896.0 |
> showing 50 of 505 rows — these rows as CSV