PREVIEW / futures_1hour / 2010-11-05
file: by_date/futures_1hour/2010/2010-11-05.parquet size: 40 KB rows: 1,150
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-05 00:00:00 | ES | Futures | 1199.61 | 1200.11 | 1199.12 | 1199.86 | 2428.0 |
| 2010-11-05 01:00:00 | ES | Futures | 1199.86 | 1200.11 | 1199.12 | 1199.37 | 2840.0 |
| 2010-11-05 02:00:00 | ES | Futures | 1199.61 | 1200.6 | 1199.37 | 1199.86 | 3790.0 |
| 2010-11-05 03:00:00 | ES | Futures | 1199.86 | 1201.34 | 1199.61 | 1200.35 | 10545.0 |
| 2010-11-05 04:00:00 | ES | Futures | 1200.6 | 1201.58 | 1198.13 | 1199.12 | 37415.0 |
| 2010-11-05 05:00:00 | ES | Futures | 1199.12 | 1199.61 | 1197.89 | 1198.38 | 30590.0 |
| 2010-11-05 06:00:00 | ES | Futures | 1198.38 | 1198.87 | 1195.42 | 1195.67 | 52659.0 |
| 2010-11-05 07:00:00 | ES | Futures | 1195.92 | 1198.87 | 1195.42 | 1197.89 | 48707.0 |
| 2010-11-05 08:00:00 | ES | Futures | 1198.13 | 1205.04 | 1197.15 | 1202.08 | 183608.0 |
| 2010-11-05 09:00:00 | ES | Futures | 1201.83 | 1204.05 | 1199.86 | 1202.82 | 261142.0 |
| 2010-11-05 10:00:00 | ES | Futures | 1202.57 | 1207.25 | 1201.34 | 1205.77 | 367022.0 |
| 2010-11-05 11:00:00 | ES | Futures | 1206.02 | 1206.51 | 1200.6 | 1201.09 | 277582.0 |
| 2010-11-05 12:00:00 | ES | Futures | 1201.09 | 1203.8 | 1200.11 | 1202.82 | 201715.0 |
| 2010-11-05 13:00:00 | ES | Futures | 1203.06 | 1204.54 | 1202.82 | 1203.8 | 69099.0 |
| 2010-11-05 14:00:00 | ES | Futures | 1203.8 | 1204.05 | 1200.11 | 1201.58 | 131630.0 |
| 2010-11-05 15:00:00 | ES | Futures | 1201.58 | 1206.27 | 1200.35 | 1205.28 | 269986.0 |
| 2010-11-05 16:00:00 | ES | Futures | 1205.28 | 1206.27 | 1204.05 | 1205.04 | 113870.0 |
| 2010-11-05 00:00:00 | NQ | Futures | 2501.79 | 2503.51 | 2501.79 | 2502.94 | 192.0 |
| 2010-11-05 01:00:00 | NQ | Futures | 2503.22 | 2503.51 | 2502.65 | 2503.22 | 109.0 |
| 2010-11-05 02:00:00 | NQ | Futures | 2503.22 | 2503.8 | 2502.08 | 2502.94 | 273.0 |
| 2010-11-05 03:00:00 | NQ | Futures | 2502.08 | 2506.38 | 2502.08 | 2504.95 | 705.0 |
| 2010-11-05 04:00:00 | NQ | Futures | 2504.66 | 2506.38 | 2500.36 | 2502.08 | 1394.0 |
| 2010-11-05 05:00:00 | NQ | Futures | 2502.36 | 2504.09 | 2501.22 | 2502.36 | 1038.0 |
| 2010-11-05 06:00:00 | NQ | Futures | 2502.08 | 2503.22 | 2498.06 | 2498.35 | 2137.0 |
| 2010-11-05 07:00:00 | NQ | Futures | 2498.06 | 2504.09 | 2498.06 | 2503.22 | 1662.0 |
| 2010-11-05 08:00:00 | NQ | Futures | 2503.22 | 2514.41 | 2498.92 | 2504.95 | 16532.0 |
| 2010-11-05 09:00:00 | NQ | Futures | 2505.23 | 2509.54 | 2500.07 | 2504.66 | 47138.0 |
| 2010-11-05 10:00:00 | NQ | Futures | 2504.95 | 2511.83 | 2502.36 | 2507.53 | 44908.0 |
| 2010-11-05 11:00:00 | NQ | Futures | 2507.81 | 2508.39 | 2499.21 | 2499.78 | 30152.0 |
| 2010-11-05 12:00:00 | NQ | Futures | 2499.49 | 2506.09 | 2498.35 | 2504.66 | 30029.0 |
| 2010-11-05 13:00:00 | NQ | Futures | 2504.66 | 2508.1 | 2504.66 | 2505.81 | 14570.0 |
| 2010-11-05 14:00:00 | NQ | Futures | 2505.81 | 2506.67 | 2497.77 | 2502.36 | 22448.0 |
| 2010-11-05 15:00:00 | NQ | Futures | 2502.36 | 2506.38 | 2498.35 | 2504.66 | 33912.0 |
| 2010-11-05 16:00:00 | NQ | Futures | 2504.66 | 2509.82 | 2504.66 | 2506.95 | 9074.0 |
| 2010-11-05 00:00:00 | YM | Futures | 10844.9 | 10847.8 | 10839.2 | 10844.0 | 277.0 |
| 2010-11-05 01:00:00 | YM | Futures | 10844.9 | 10844.9 | 10836.4 | 10839.2 | 144.0 |
| 2010-11-05 02:00:00 | YM | Futures | 10839.2 | 10844.9 | 10839.2 | 10839.2 | 220.0 |
| 2010-11-05 03:00:00 | YM | Futures | 10840.2 | 10850.7 | 10837.3 | 10844.0 | 390.0 |
| 2010-11-05 04:00:00 | YM | Futures | 10844.0 | 10852.6 | 10825.9 | 10831.6 | 1132.0 |
| 2010-11-05 05:00:00 | YM | Futures | 10832.6 | 10836.4 | 10825.9 | 10829.7 | 530.0 |
| 2010-11-05 06:00:00 | YM | Futures | 10827.8 | 10831.6 | 10807.8 | 10809.7 | 1365.0 |
| 2010-11-05 07:00:00 | YM | Futures | 10808.8 | 10832.6 | 10808.8 | 10823.0 | 1611.0 |
| 2010-11-05 08:00:00 | YM | Futures | 10824.0 | 10888.8 | 10821.1 | 10854.5 | 8195.0 |
| 2010-11-05 09:00:00 | YM | Futures | 10855.4 | 10865.0 | 10827.8 | 10835.4 | 16463.0 |
| 2010-11-05 10:00:00 | YM | Futures | 10836.4 | 10865.9 | 10824.9 | 10853.5 | 15715.0 |
| 2010-11-05 11:00:00 | YM | Futures | 10853.5 | 10858.3 | 10818.3 | 10820.2 | 12389.0 |
| 2010-11-05 12:00:00 | YM | Futures | 10819.2 | 10839.2 | 10812.6 | 10831.6 | 12615.0 |
| 2010-11-05 13:00:00 | YM | Futures | 10832.6 | 10844.9 | 10831.6 | 10836.4 | 4369.0 |
| 2010-11-05 14:00:00 | YM | Futures | 10836.4 | 10837.3 | 10810.7 | 10819.2 | 10064.0 |
| 2010-11-05 15:00:00 | YM | Futures | 10819.2 | 10861.1 | 10811.6 | 10856.4 | 15003.0 |
> showing 50 of 1,150 rows — these rows as CSV