PREVIEW / futures_1hour / 2010-12-06
file: by_date/futures_1hour/2010/2010-12-06.parquet size: 46 KB rows: 1,400
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-06 00:00:00 | ES | Futures | 1205.77 | 1206.02 | 1204.05 | 1204.3 | 2442.0 |
| 2010-12-06 01:00:00 | ES | Futures | 1204.54 | 1205.77 | 1204.05 | 1205.28 | 4014.0 |
| 2010-12-06 02:00:00 | ES | Futures | 1205.28 | 1207.01 | 1204.54 | 1204.79 | 10427.0 |
| 2010-12-06 03:00:00 | ES | Futures | 1204.79 | 1206.02 | 1201.09 | 1201.34 | 29724.0 |
| 2010-12-06 04:00:00 | ES | Futures | 1201.09 | 1203.06 | 1200.85 | 1202.32 | 20423.0 |
| 2010-12-06 05:00:00 | ES | Futures | 1202.08 | 1203.8 | 1199.12 | 1199.37 | 23470.0 |
| 2010-12-06 06:00:00 | ES | Futures | 1199.61 | 1202.57 | 1199.37 | 1201.58 | 24060.0 |
| 2010-12-06 07:00:00 | ES | Futures | 1201.58 | 1204.05 | 1201.58 | 1203.31 | 21235.0 |
| 2010-12-06 08:00:00 | ES | Futures | 1203.06 | 1203.31 | 1200.35 | 1202.82 | 37872.0 |
| 2010-12-06 09:00:00 | ES | Futures | 1202.57 | 1205.53 | 1202.08 | 1203.56 | 158872.0 |
| 2010-12-06 10:00:00 | ES | Futures | 1203.56 | 1207.01 | 1203.56 | 1204.54 | 223604.0 |
| 2010-12-06 11:00:00 | ES | Futures | 1204.54 | 1206.02 | 1202.82 | 1204.05 | 173221.0 |
| 2010-12-06 12:00:00 | ES | Futures | 1204.3 | 1205.04 | 1203.06 | 1204.79 | 110469.0 |
| 2010-12-06 13:00:00 | ES | Futures | 1205.04 | 1206.76 | 1204.3 | 1206.02 | 88840.0 |
| 2010-12-06 14:00:00 | ES | Futures | 1206.27 | 1207.5 | 1205.28 | 1206.76 | 88214.0 |
| 2010-12-06 15:00:00 | ES | Futures | 1207.01 | 1208.24 | 1205.04 | 1205.04 | 175352.0 |
| 2010-12-06 16:00:00 | ES | Futures | 1205.04 | 1205.77 | 1204.05 | 1204.05 | 54471.0 |
| 2010-12-06 17:00:00 | ES | Futures | 1204.3 | 1204.3 | 1202.57 | 1202.82 | 6460.0 |
| 2010-12-06 18:00:00 | ES | Futures | 1203.8 | 1205.77 | 1202.57 | 1205.04 | 17237.0 |
| 2010-12-06 19:00:00 | ES | Futures | 1205.04 | 1206.27 | 1204.79 | 1206.02 | 8193.0 |
| 2010-12-06 20:00:00 | ES | Futures | 1206.02 | 1206.27 | 1201.83 | 1202.32 | 9027.0 |
| 2010-12-06 21:00:00 | ES | Futures | 1202.57 | 1206.76 | 1202.32 | 1206.02 | 9239.0 |
| 2010-12-06 22:00:00 | ES | Futures | 1206.02 | 1207.5 | 1205.53 | 1207.5 | 5984.0 |
| 2010-12-06 23:00:00 | ES | Futures | 1207.25 | 1207.99 | 1207.01 | 1207.5 | 3599.0 |
| 2010-12-06 00:00:00 | NQ | Futures | 2510.97 | 2511.54 | 2507.53 | 2508.1 | 127.0 |
| 2010-12-06 01:00:00 | NQ | Futures | 2508.1 | 2510.11 | 2507.53 | 2510.11 | 245.0 |
| 2010-12-06 02:00:00 | NQ | Futures | 2509.82 | 2513.27 | 2508.68 | 2509.25 | 499.0 |
| 2010-12-06 03:00:00 | NQ | Futures | 2509.25 | 2511.83 | 2501.5 | 2501.79 | 1956.0 |
| 2010-12-06 04:00:00 | NQ | Futures | 2501.79 | 2505.23 | 2501.5 | 2504.09 | 1257.0 |
| 2010-12-06 05:00:00 | NQ | Futures | 2504.09 | 2506.95 | 2498.63 | 2498.92 | 1342.0 |
| 2010-12-06 06:00:00 | NQ | Futures | 2498.35 | 2505.52 | 2498.35 | 2503.51 | 1847.0 |
| 2010-12-06 07:00:00 | NQ | Futures | 2503.51 | 2508.68 | 2503.51 | 2507.24 | 1037.0 |
| 2010-12-06 08:00:00 | NQ | Futures | 2507.24 | 2509.54 | 2503.51 | 2508.39 | 3165.0 |
| 2010-12-06 09:00:00 | NQ | Futures | 2508.68 | 2516.42 | 2506.67 | 2510.4 | 33020.0 |
| 2010-12-06 10:00:00 | NQ | Futures | 2510.68 | 2517.0 | 2508.96 | 2510.97 | 27112.0 |
| 2010-12-06 11:00:00 | NQ | Futures | 2510.68 | 2513.27 | 2504.95 | 2508.1 | 26308.0 |
| 2010-12-06 12:00:00 | NQ | Futures | 2508.1 | 2509.82 | 2505.81 | 2508.68 | 16420.0 |
| 2010-12-06 13:00:00 | NQ | Futures | 2508.96 | 2512.98 | 2507.53 | 2511.83 | 14194.0 |
| 2010-12-06 14:00:00 | NQ | Futures | 2511.83 | 2515.27 | 2509.54 | 2512.69 | 14079.0 |
| 2010-12-06 15:00:00 | NQ | Futures | 2512.98 | 2517.57 | 2510.97 | 2512.12 | 23433.0 |
| 2010-12-06 16:00:00 | NQ | Futures | 2512.12 | 2514.7 | 2509.54 | 2511.54 | 4932.0 |
| 2010-12-06 17:00:00 | NQ | Futures | 2511.54 | 2511.54 | 2508.1 | 2508.1 | 200.0 |
| 2010-12-06 18:00:00 | NQ | Futures | 2512.98 | 2515.56 | 2508.68 | 2514.41 | 848.0 |
| 2010-12-06 19:00:00 | NQ | Futures | 2514.41 | 2516.13 | 2513.84 | 2516.13 | 221.0 |
| 2010-12-06 20:00:00 | NQ | Futures | 2515.56 | 2516.13 | 2508.68 | 2509.25 | 346.0 |
| 2010-12-06 21:00:00 | NQ | Futures | 2509.25 | 2518.14 | 2509.25 | 2517.28 | 563.0 |
| 2010-12-06 22:00:00 | NQ | Futures | 2517.28 | 2519.0 | 2515.85 | 2518.72 | 421.0 |
| 2010-12-06 23:00:00 | NQ | Futures | 2518.43 | 2520.44 | 2518.14 | 2519.58 | 237.0 |
| 2010-12-06 00:00:00 | YM | Futures | 10826.8 | 10829.7 | 10814.5 | 10819.2 | 169.0 |
| 2010-12-06 01:00:00 | YM | Futures | 10817.3 | 10825.9 | 10813.5 | 10824.0 | 107.0 |
> showing 50 of 1,400 rows — these rows as CSV