PREVIEW / futures_1hour / 2010-12-29
file: by_date/futures_1hour/2010/2010-12-29.parquet size: 45 KB rows: 1,411
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-29 00:00:00 | ES | Futures | 1241.84 | 1242.33 | 1241.59 | 1242.08 | 1195.0 |
| 2010-12-29 01:00:00 | ES | Futures | 1242.08 | 1242.58 | 1242.08 | 1242.58 | 564.0 |
| 2010-12-29 02:00:00 | ES | Futures | 1242.33 | 1243.07 | 1242.33 | 1242.58 | 2771.0 |
| 2010-12-29 03:00:00 | ES | Futures | 1242.58 | 1244.06 | 1242.58 | 1243.82 | 8680.0 |
| 2010-12-29 04:00:00 | ES | Futures | 1243.82 | 1244.06 | 1242.58 | 1243.07 | 4318.0 |
| 2010-12-29 05:00:00 | ES | Futures | 1242.83 | 1244.06 | 1242.83 | 1244.06 | 4738.0 |
| 2010-12-29 06:00:00 | ES | Futures | 1244.06 | 1244.06 | 1242.58 | 1242.58 | 5011.0 |
| 2010-12-29 07:00:00 | ES | Futures | 1242.58 | 1243.07 | 1241.84 | 1242.33 | 6881.0 |
| 2010-12-29 08:00:00 | ES | Futures | 1242.33 | 1243.32 | 1241.84 | 1243.32 | 10132.0 |
| 2010-12-29 09:00:00 | ES | Futures | 1243.32 | 1244.06 | 1242.58 | 1243.57 | 72168.0 |
| 2010-12-29 10:00:00 | ES | Futures | 1243.57 | 1244.81 | 1243.57 | 1243.57 | 69895.0 |
| 2010-12-29 11:00:00 | ES | Futures | 1243.57 | 1244.31 | 1243.07 | 1243.82 | 68078.0 |
| 2010-12-29 12:00:00 | ES | Futures | 1243.82 | 1245.05 | 1243.82 | 1244.56 | 48760.0 |
| 2010-12-29 13:00:00 | ES | Futures | 1244.56 | 1245.55 | 1244.56 | 1245.05 | 43940.0 |
| 2010-12-29 14:00:00 | ES | Futures | 1245.05 | 1245.55 | 1244.56 | 1244.81 | 31664.0 |
| 2010-12-29 15:00:00 | ES | Futures | 1244.81 | 1245.55 | 1242.58 | 1242.83 | 139280.0 |
| 2010-12-29 16:00:00 | ES | Futures | 1242.58 | 1243.82 | 1242.08 | 1243.07 | 61482.0 |
| 2010-12-29 17:00:00 | ES | Futures | 1243.07 | 1243.82 | 1243.07 | 1243.57 | 914.0 |
| 2010-12-29 18:00:00 | ES | Futures | 1243.57 | 1243.82 | 1242.83 | 1243.57 | 1346.0 |
| 2010-12-29 19:00:00 | ES | Futures | 1243.32 | 1243.82 | 1242.33 | 1242.58 | 1799.0 |
| 2010-12-29 20:00:00 | ES | Futures | 1242.58 | 1243.07 | 1241.34 | 1241.84 | 3832.0 |
| 2010-12-29 21:00:00 | ES | Futures | 1241.59 | 1242.33 | 1241.34 | 1242.08 | 1342.0 |
| 2010-12-29 22:00:00 | ES | Futures | 1242.33 | 1243.07 | 1241.84 | 1242.83 | 1840.0 |
| 2010-12-29 23:00:00 | ES | Futures | 1242.83 | 1242.83 | 1242.08 | 1242.08 | 362.0 |
| 2010-12-29 00:00:00 | NQ | Futures | 2559.18 | 2559.47 | 2558.03 | 2558.89 | 86.0 |
| 2010-12-29 01:00:00 | NQ | Futures | 2558.61 | 2559.18 | 2558.32 | 2558.89 | 46.0 |
| 2010-12-29 02:00:00 | NQ | Futures | 2558.89 | 2559.47 | 2558.32 | 2559.18 | 203.0 |
| 2010-12-29 03:00:00 | NQ | Futures | 2559.47 | 2560.04 | 2558.61 | 2560.04 | 1099.0 |
| 2010-12-29 04:00:00 | NQ | Futures | 2560.04 | 2561.48 | 2558.89 | 2558.89 | 670.0 |
| 2010-12-29 05:00:00 | NQ | Futures | 2558.89 | 2562.05 | 2558.89 | 2562.05 | 368.0 |
| 2010-12-29 06:00:00 | NQ | Futures | 2562.05 | 2564.92 | 2561.19 | 2561.48 | 1203.0 |
| 2010-12-29 07:00:00 | NQ | Futures | 2561.48 | 2562.34 | 2560.04 | 2561.48 | 766.0 |
| 2010-12-29 08:00:00 | NQ | Futures | 2561.19 | 2562.34 | 2559.76 | 2562.34 | 860.0 |
| 2010-12-29 09:00:00 | NQ | Futures | 2562.34 | 2564.06 | 2559.18 | 2561.76 | 10265.0 |
| 2010-12-29 10:00:00 | NQ | Futures | 2561.76 | 2566.93 | 2561.76 | 2564.92 | 12018.0 |
| 2010-12-29 11:00:00 | NQ | Futures | 2565.21 | 2566.07 | 2560.62 | 2561.76 | 8950.0 |
| 2010-12-29 12:00:00 | NQ | Futures | 2562.05 | 2565.78 | 2562.05 | 2565.21 | 5349.0 |
| 2010-12-29 13:00:00 | NQ | Futures | 2564.92 | 2566.07 | 2563.77 | 2564.35 | 4483.0 |
| 2010-12-29 14:00:00 | NQ | Futures | 2564.06 | 2565.78 | 2563.2 | 2563.77 | 3748.0 |
| 2010-12-29 15:00:00 | NQ | Futures | 2564.06 | 2565.78 | 2560.62 | 2561.48 | 9994.0 |
| 2010-12-29 16:00:00 | NQ | Futures | 2561.76 | 2562.05 | 2558.32 | 2559.76 | 4158.0 |
| 2010-12-29 17:00:00 | NQ | Futures | 2559.76 | 2560.9 | 2559.47 | 2560.62 | 60.0 |
| 2010-12-29 18:00:00 | NQ | Futures | 2560.9 | 2561.48 | 2560.04 | 2561.19 | 130.0 |
| 2010-12-29 19:00:00 | NQ | Futures | 2561.19 | 2561.48 | 2559.18 | 2560.04 | 202.0 |
| 2010-12-29 20:00:00 | NQ | Futures | 2560.04 | 2560.33 | 2558.89 | 2559.76 | 235.0 |
| 2010-12-29 21:00:00 | NQ | Futures | 2559.76 | 2562.34 | 2559.18 | 2561.19 | 494.0 |
| 2010-12-29 22:00:00 | NQ | Futures | 2560.9 | 2563.49 | 2560.62 | 2562.34 | 274.0 |
| 2010-12-29 23:00:00 | NQ | Futures | 2562.05 | 2562.05 | 2560.62 | 2560.9 | 50.0 |
| 2010-12-29 00:00:00 | YM | Futures | 11026.9 | 11027.9 | 11026.0 | 11027.9 | 25.0 |
| 2010-12-29 01:00:00 | YM | Futures | 11028.9 | 11033.7 | 11027.9 | 11033.7 | 42.0 |
> showing 50 of 1,411 rows — these rows as CSV