PREVIEW / futures_1hour / 2010-12-17
file: by_date/futures_1hour/2010/2010-12-17.parquet size: 39 KB rows: 1,163
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-17 00:00:00 | ES | Futures | 1225.01 | 1225.75 | 1224.02 | 1225.75 | 3251.0 |
| 2010-12-17 01:00:00 | ES | Futures | 1225.75 | 1226.0 | 1225.01 | 1225.26 | 2789.0 |
| 2010-12-17 02:00:00 | ES | Futures | 1225.26 | 1226.25 | 1224.76 | 1225.75 | 8640.0 |
| 2010-12-17 03:00:00 | ES | Futures | 1226.0 | 1226.5 | 1224.52 | 1225.75 | 18962.0 |
| 2010-12-17 04:00:00 | ES | Futures | 1225.51 | 1226.74 | 1225.51 | 1226.74 | 10063.0 |
| 2010-12-17 05:00:00 | ES | Futures | 1226.74 | 1227.24 | 1224.02 | 1224.76 | 17642.0 |
| 2010-12-17 06:00:00 | ES | Futures | 1224.76 | 1225.51 | 1224.02 | 1224.52 | 11776.0 |
| 2010-12-17 07:00:00 | ES | Futures | 1224.52 | 1226.0 | 1222.78 | 1225.51 | 23900.0 |
| 2010-12-17 08:00:00 | ES | Futures | 1225.75 | 1226.0 | 1224.02 | 1225.26 | 33637.0 |
| 2010-12-17 09:00:00 | ES | Futures | 1225.26 | 1226.5 | 1222.78 | 1224.27 | 216546.0 |
| 2010-12-17 10:00:00 | ES | Futures | 1224.02 | 1225.01 | 1221.79 | 1223.77 | 229970.0 |
| 2010-12-17 11:00:00 | ES | Futures | 1223.77 | 1225.26 | 1223.03 | 1224.27 | 121275.0 |
| 2010-12-17 12:00:00 | ES | Futures | 1224.27 | 1225.51 | 1224.27 | 1225.01 | 52211.0 |
| 2010-12-17 13:00:00 | ES | Futures | 1225.26 | 1228.23 | 1225.01 | 1227.73 | 93183.0 |
| 2010-12-17 14:00:00 | ES | Futures | 1227.73 | 1228.23 | 1226.99 | 1227.73 | 53651.0 |
| 2010-12-17 15:00:00 | ES | Futures | 1227.98 | 1228.23 | 1224.76 | 1226.99 | 280479.0 |
| 2010-12-17 16:00:00 | ES | Futures | 1226.99 | 1227.49 | 1224.76 | 1225.75 | 104842.0 |
| 2010-12-17 00:00:00 | NQ | Futures | 2547.99 | 2548.56 | 2546.26 | 2547.99 | 327.0 |
| 2010-12-17 01:00:00 | NQ | Futures | 2547.99 | 2548.56 | 2546.26 | 2547.13 | 431.0 |
| 2010-12-17 02:00:00 | NQ | Futures | 2547.41 | 2548.56 | 2546.55 | 2547.99 | 660.0 |
| 2010-12-17 03:00:00 | NQ | Futures | 2548.27 | 2548.56 | 2545.4 | 2546.26 | 1954.0 |
| 2010-12-17 04:00:00 | NQ | Futures | 2546.26 | 2547.41 | 2545.98 | 2547.41 | 1195.0 |
| 2010-12-17 05:00:00 | NQ | Futures | 2547.41 | 2548.27 | 2543.68 | 2544.54 | 1553.0 |
| 2010-12-17 06:00:00 | NQ | Futures | 2544.54 | 2545.4 | 2543.68 | 2544.83 | 2604.0 |
| 2010-12-17 07:00:00 | NQ | Futures | 2544.83 | 2547.41 | 2543.39 | 2546.26 | 3953.0 |
| 2010-12-17 08:00:00 | NQ | Futures | 2545.98 | 2548.27 | 2544.54 | 2548.27 | 5082.0 |
| 2010-12-17 09:00:00 | NQ | Futures | 2548.27 | 2551.43 | 2545.4 | 2547.7 | 30383.0 |
| 2010-12-17 10:00:00 | NQ | Futures | 2547.7 | 2550.28 | 2543.97 | 2547.99 | 23191.0 |
| 2010-12-17 11:00:00 | NQ | Futures | 2548.27 | 2552.87 | 2547.41 | 2551.14 | 14978.0 |
| 2010-12-17 12:00:00 | NQ | Futures | 2551.14 | 2552.58 | 2550.28 | 2551.72 | 6566.0 |
| 2010-12-17 13:00:00 | NQ | Futures | 2551.72 | 2556.31 | 2551.72 | 2554.88 | 11052.0 |
| 2010-12-17 14:00:00 | NQ | Futures | 2554.88 | 2555.45 | 2552.29 | 2553.15 | 7933.0 |
| 2010-12-17 15:00:00 | NQ | Futures | 2553.15 | 2554.01 | 2545.98 | 2548.85 | 29671.0 |
| 2010-12-17 16:00:00 | NQ | Futures | 2548.85 | 2548.85 | 2539.95 | 2540.81 | 11877.0 |
| 2010-12-17 00:00:00 | YM | Futures | 10941.7 | 10952.2 | 10937.9 | 10952.2 | 219.0 |
| 2010-12-17 01:00:00 | YM | Futures | 10950.3 | 10953.2 | 10947.5 | 10949.4 | 156.0 |
| 2010-12-17 02:00:00 | YM | Futures | 10950.3 | 10955.1 | 10944.6 | 10953.2 | 322.0 |
| 2010-12-17 03:00:00 | YM | Futures | 10954.2 | 10956.1 | 10944.6 | 10952.2 | 911.0 |
| 2010-12-17 04:00:00 | YM | Futures | 10954.2 | 10961.8 | 10952.2 | 10959.9 | 425.0 |
| 2010-12-17 05:00:00 | YM | Futures | 10959.9 | 10963.7 | 10940.7 | 10945.5 | 664.0 |
| 2010-12-17 06:00:00 | YM | Futures | 10945.5 | 10948.4 | 10937.9 | 10943.6 | 382.0 |
| 2010-12-17 07:00:00 | YM | Futures | 10942.7 | 10956.1 | 10932.1 | 10952.2 | 1254.0 |
| 2010-12-17 08:00:00 | YM | Futures | 10951.3 | 10956.1 | 10943.6 | 10951.3 | 1116.0 |
| 2010-12-17 09:00:00 | YM | Futures | 10952.2 | 10957.0 | 10921.6 | 10930.2 | 10457.0 |
| 2010-12-17 10:00:00 | YM | Futures | 10931.2 | 10936.0 | 10907.2 | 10924.5 | 12616.0 |
| 2010-12-17 11:00:00 | YM | Futures | 10924.5 | 10937.9 | 10918.7 | 10929.3 | 5756.0 |
| 2010-12-17 12:00:00 | YM | Futures | 10930.2 | 10936.0 | 10925.4 | 10934.0 | 3252.0 |
| 2010-12-17 13:00:00 | YM | Futures | 10934.0 | 10956.1 | 10933.1 | 10952.2 | 5145.0 |
| 2010-12-17 14:00:00 | YM | Futures | 10951.3 | 10956.1 | 10948.4 | 10952.2 | 3391.0 |
| 2010-12-17 15:00:00 | YM | Futures | 10952.2 | 10956.1 | 10935.0 | 10952.2 | 10694.0 |
> showing 50 of 1,163 rows — these rows as CSV