PREVIEW / futures_1hour / 2010-11-10
file: by_date/futures_1hour/2010/2010-11-10.parquet size: 49 KB rows: 1,456
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-10 00:00:00 | ES | Futures | 1193.2 | 1195.42 | 1192.46 | 1195.18 | 5016.0 |
| 2010-11-10 01:00:00 | ES | Futures | 1195.18 | 1195.67 | 1194.68 | 1195.18 | 3947.0 |
| 2010-11-10 02:00:00 | ES | Futures | 1195.18 | 1195.92 | 1194.19 | 1194.93 | 12556.0 |
| 2010-11-10 03:00:00 | ES | Futures | 1195.18 | 1195.92 | 1193.45 | 1194.44 | 28833.0 |
| 2010-11-10 04:00:00 | ES | Futures | 1194.19 | 1195.67 | 1193.7 | 1194.93 | 19216.0 |
| 2010-11-10 05:00:00 | ES | Futures | 1194.93 | 1195.67 | 1192.71 | 1193.45 | 25410.0 |
| 2010-11-10 06:00:00 | ES | Futures | 1193.45 | 1195.18 | 1192.96 | 1194.44 | 29926.0 |
| 2010-11-10 07:00:00 | ES | Futures | 1194.68 | 1195.18 | 1191.97 | 1192.22 | 38217.0 |
| 2010-11-10 08:00:00 | ES | Futures | 1192.46 | 1196.41 | 1190.99 | 1194.93 | 90596.0 |
| 2010-11-10 09:00:00 | ES | Futures | 1194.93 | 1195.92 | 1187.29 | 1188.27 | 349414.0 |
| 2010-11-10 10:00:00 | ES | Futures | 1188.27 | 1190.25 | 1184.82 | 1189.26 | 507955.0 |
| 2010-11-10 11:00:00 | ES | Futures | 1189.01 | 1194.68 | 1187.29 | 1194.19 | 332702.0 |
| 2010-11-10 12:00:00 | ES | Futures | 1193.94 | 1195.18 | 1191.48 | 1192.71 | 171099.0 |
| 2010-11-10 13:00:00 | ES | Futures | 1192.96 | 1197.64 | 1190.25 | 1195.67 | 248180.0 |
| 2010-11-10 14:00:00 | ES | Futures | 1195.67 | 1199.86 | 1195.67 | 1197.89 | 235652.0 |
| 2010-11-10 15:00:00 | ES | Futures | 1198.13 | 1199.12 | 1195.92 | 1198.63 | 226841.0 |
| 2010-11-10 16:00:00 | ES | Futures | 1198.63 | 1199.12 | 1192.96 | 1193.2 | 119698.0 |
| 2010-11-10 17:00:00 | ES | Futures | 1193.2 | 1193.2 | 1189.01 | 1189.26 | 18722.0 |
| 2010-11-10 18:00:00 | ES | Futures | 1189.51 | 1192.46 | 1189.51 | 1191.97 | 18644.0 |
| 2010-11-10 19:00:00 | ES | Futures | 1192.22 | 1192.22 | 1190.0 | 1191.48 | 12411.0 |
| 2010-11-10 20:00:00 | ES | Futures | 1191.48 | 1193.45 | 1191.23 | 1192.46 | 8059.0 |
| 2010-11-10 21:00:00 | ES | Futures | 1192.46 | 1193.94 | 1192.22 | 1193.7 | 6527.0 |
| 2010-11-10 22:00:00 | ES | Futures | 1193.7 | 1195.18 | 1193.45 | 1194.44 | 6372.0 |
| 2010-11-10 23:00:00 | ES | Futures | 1194.44 | 1194.68 | 1193.45 | 1193.94 | 2786.0 |
| 2010-11-10 00:00:00 | NQ | Futures | 2495.48 | 2500.36 | 2494.9 | 2499.21 | 501.0 |
| 2010-11-10 01:00:00 | NQ | Futures | 2498.63 | 2501.22 | 2498.63 | 2500.64 | 430.0 |
| 2010-11-10 02:00:00 | NQ | Futures | 2500.64 | 2502.36 | 2499.21 | 2500.07 | 1704.0 |
| 2010-11-10 03:00:00 | NQ | Futures | 2499.78 | 2502.94 | 2498.35 | 2499.21 | 2940.0 |
| 2010-11-10 04:00:00 | NQ | Futures | 2499.21 | 2502.08 | 2498.35 | 2500.93 | 1117.0 |
| 2010-11-10 05:00:00 | NQ | Futures | 2500.93 | 2501.79 | 2497.2 | 2498.63 | 1463.0 |
| 2010-11-10 06:00:00 | NQ | Futures | 2498.35 | 2500.07 | 2497.49 | 2498.63 | 2298.0 |
| 2010-11-10 07:00:00 | NQ | Futures | 2498.63 | 2500.36 | 2493.76 | 2494.62 | 2505.0 |
| 2010-11-10 08:00:00 | NQ | Futures | 2494.9 | 2504.37 | 2493.47 | 2500.93 | 7777.0 |
| 2010-11-10 09:00:00 | NQ | Futures | 2500.64 | 2502.36 | 2480.85 | 2485.44 | 49040.0 |
| 2010-11-10 10:00:00 | NQ | Futures | 2485.44 | 2486.87 | 2478.84 | 2486.3 | 51843.0 |
| 2010-11-10 11:00:00 | NQ | Futures | 2486.58 | 2501.79 | 2484.86 | 2500.93 | 36909.0 |
| 2010-11-10 12:00:00 | NQ | Futures | 2500.64 | 2503.22 | 2496.34 | 2498.92 | 24785.0 |
| 2010-11-10 13:00:00 | NQ | Futures | 2499.21 | 2506.95 | 2493.18 | 2503.22 | 33347.0 |
| 2010-11-10 14:00:00 | NQ | Futures | 2503.22 | 2510.11 | 2503.22 | 2507.53 | 31728.0 |
| 2010-11-10 15:00:00 | NQ | Futures | 2507.81 | 2508.96 | 2503.22 | 2506.95 | 31043.0 |
| 2010-11-10 16:00:00 | NQ | Futures | 2506.95 | 2508.39 | 2486.58 | 2488.02 | 17365.0 |
| 2010-11-10 17:00:00 | NQ | Futures | 2487.44 | 2488.02 | 2469.94 | 2471.09 | 5653.0 |
| 2010-11-10 18:00:00 | NQ | Futures | 2471.95 | 2476.54 | 2470.8 | 2476.54 | 1723.0 |
| 2010-11-10 19:00:00 | NQ | Futures | 2476.54 | 2476.83 | 2473.1 | 2475.11 | 733.0 |
| 2010-11-10 20:00:00 | NQ | Futures | 2475.11 | 2478.55 | 2473.96 | 2477.4 | 902.0 |
| 2010-11-10 21:00:00 | NQ | Futures | 2477.12 | 2478.26 | 2476.26 | 2477.69 | 711.0 |
| 2010-11-10 22:00:00 | NQ | Futures | 2477.98 | 2481.13 | 2477.98 | 2480.27 | 378.0 |
| 2010-11-10 23:00:00 | NQ | Futures | 2480.56 | 2480.56 | 2477.69 | 2479.41 | 258.0 |
| 2010-11-10 00:00:00 | YM | Futures | 10768.7 | 10788.7 | 10763.0 | 10785.9 | 372.0 |
| 2010-11-10 01:00:00 | YM | Futures | 10785.9 | 10790.7 | 10783.0 | 10785.9 | 175.0 |
> showing 50 of 1,456 rows — these rows as CSV