PREVIEW / futures_1hour / 2010-12-23
file: by_date/futures_1hour/2010/2010-12-23.parquet size: 39 KB rows: 1,161
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-23 00:00:00 | ES | Futures | 1242.33 | 1242.58 | 1241.84 | 1242.08 | 1403.0 |
| 2010-12-23 01:00:00 | ES | Futures | 1242.08 | 1242.58 | 1241.84 | 1242.33 | 1047.0 |
| 2010-12-23 02:00:00 | ES | Futures | 1242.58 | 1242.83 | 1241.84 | 1242.08 | 3721.0 |
| 2010-12-23 03:00:00 | ES | Futures | 1242.08 | 1242.33 | 1240.6 | 1241.09 | 13278.0 |
| 2010-12-23 04:00:00 | ES | Futures | 1241.09 | 1241.34 | 1240.6 | 1240.6 | 4938.0 |
| 2010-12-23 05:00:00 | ES | Futures | 1240.85 | 1241.84 | 1240.6 | 1241.34 | 5350.0 |
| 2010-12-23 06:00:00 | ES | Futures | 1241.34 | 1241.59 | 1240.35 | 1240.35 | 4412.0 |
| 2010-12-23 07:00:00 | ES | Futures | 1240.35 | 1241.34 | 1240.35 | 1240.6 | 6898.0 |
| 2010-12-23 08:00:00 | ES | Futures | 1240.35 | 1240.85 | 1238.62 | 1239.86 | 27186.0 |
| 2010-12-23 09:00:00 | ES | Futures | 1240.1 | 1241.34 | 1239.36 | 1240.85 | 63605.0 |
| 2010-12-23 10:00:00 | ES | Futures | 1240.6 | 1241.09 | 1238.62 | 1239.61 | 89633.0 |
| 2010-12-23 11:00:00 | ES | Futures | 1239.61 | 1240.85 | 1239.11 | 1239.61 | 67826.0 |
| 2010-12-23 12:00:00 | ES | Futures | 1239.86 | 1239.86 | 1238.62 | 1239.11 | 32819.0 |
| 2010-12-23 13:00:00 | ES | Futures | 1239.11 | 1240.1 | 1238.87 | 1239.11 | 32087.0 |
| 2010-12-23 14:00:00 | ES | Futures | 1239.11 | 1239.36 | 1236.39 | 1238.13 | 77744.0 |
| 2010-12-23 15:00:00 | ES | Futures | 1238.13 | 1239.86 | 1237.63 | 1239.36 | 94777.0 |
| 2010-12-23 16:00:00 | ES | Futures | 1239.36 | 1240.35 | 1239.36 | 1239.86 | 46549.0 |
| 2010-12-23 00:00:00 | NQ | Futures | 2569.23 | 2569.8 | 2568.94 | 2569.23 | 55.0 |
| 2010-12-23 01:00:00 | NQ | Futures | 2568.65 | 2570.09 | 2568.65 | 2569.51 | 45.0 |
| 2010-12-23 02:00:00 | NQ | Futures | 2569.8 | 2570.09 | 2568.08 | 2568.08 | 178.0 |
| 2010-12-23 03:00:00 | NQ | Futures | 2568.37 | 2569.23 | 2566.36 | 2567.22 | 875.0 |
| 2010-12-23 04:00:00 | NQ | Futures | 2567.51 | 2567.79 | 2566.07 | 2566.93 | 447.0 |
| 2010-12-23 05:00:00 | NQ | Futures | 2566.93 | 2567.79 | 2566.36 | 2567.79 | 293.0 |
| 2010-12-23 06:00:00 | NQ | Futures | 2567.79 | 2567.79 | 2561.48 | 2561.76 | 2700.0 |
| 2010-12-23 07:00:00 | NQ | Futures | 2562.05 | 2564.06 | 2562.05 | 2562.34 | 1042.0 |
| 2010-12-23 08:00:00 | NQ | Futures | 2562.34 | 2562.91 | 2557.46 | 2561.48 | 4660.0 |
| 2010-12-23 09:00:00 | NQ | Futures | 2561.48 | 2565.5 | 2559.76 | 2562.05 | 14690.0 |
| 2010-12-23 10:00:00 | NQ | Futures | 2562.05 | 2563.77 | 2553.15 | 2555.74 | 17309.0 |
| 2010-12-23 11:00:00 | NQ | Futures | 2556.02 | 2560.04 | 2555.74 | 2557.46 | 11787.0 |
| 2010-12-23 12:00:00 | NQ | Futures | 2557.17 | 2558.61 | 2554.88 | 2557.46 | 7033.0 |
| 2010-12-23 13:00:00 | NQ | Futures | 2557.75 | 2559.76 | 2557.46 | 2557.75 | 4410.0 |
| 2010-12-23 14:00:00 | NQ | Futures | 2557.75 | 2558.32 | 2554.59 | 2557.17 | 6605.0 |
| 2010-12-23 15:00:00 | NQ | Futures | 2557.17 | 2559.76 | 2556.31 | 2559.18 | 11056.0 |
| 2010-12-23 16:00:00 | NQ | Futures | 2559.47 | 2562.91 | 2559.47 | 2561.76 | 3702.0 |
| 2010-12-23 00:00:00 | YM | Futures | 11018.3 | 11021.2 | 11017.4 | 11018.3 | 46.0 |
| 2010-12-23 01:00:00 | YM | Futures | 11017.4 | 11021.2 | 11017.4 | 11021.2 | 35.0 |
| 2010-12-23 02:00:00 | YM | Futures | 11020.2 | 11023.1 | 11014.5 | 11015.5 | 209.0 |
| 2010-12-23 03:00:00 | YM | Futures | 11016.4 | 11019.3 | 11008.8 | 11012.6 | 512.0 |
| 2010-12-23 04:00:00 | YM | Futures | 11012.6 | 11013.5 | 11008.8 | 11011.6 | 205.0 |
| 2010-12-23 05:00:00 | YM | Futures | 11011.6 | 11016.4 | 11010.7 | 11015.5 | 255.0 |
| 2010-12-23 06:00:00 | YM | Futures | 11015.5 | 11015.5 | 11007.8 | 11007.8 | 107.0 |
| 2010-12-23 07:00:00 | YM | Futures | 11007.8 | 11013.5 | 11007.8 | 11009.7 | 214.0 |
| 2010-12-23 08:00:00 | YM | Futures | 11009.7 | 11009.7 | 10994.4 | 11006.8 | 1534.0 |
| 2010-12-23 09:00:00 | YM | Futures | 11007.8 | 11026.0 | 11003.0 | 11024.1 | 4090.0 |
| 2010-12-23 10:00:00 | YM | Futures | 11023.1 | 11027.9 | 11013.5 | 11022.2 | 5186.0 |
| 2010-12-23 11:00:00 | YM | Futures | 11022.2 | 11033.7 | 11018.3 | 11020.2 | 4562.0 |
| 2010-12-23 12:00:00 | YM | Futures | 11020.2 | 11022.2 | 11013.5 | 11017.4 | 2528.0 |
| 2010-12-23 13:00:00 | YM | Futures | 11017.4 | 11025.0 | 11016.4 | 11019.3 | 1454.0 |
| 2010-12-23 14:00:00 | YM | Futures | 11019.3 | 11022.2 | 10994.4 | 11011.6 | 5522.0 |
| 2010-12-23 15:00:00 | YM | Futures | 11011.6 | 11029.8 | 11005.9 | 11026.9 | 4478.0 |
> showing 50 of 1,161 rows — these rows as CSV