PREVIEW / futures_30min / 2010-01-04
file: by_date/futures_30min/2010/2010-01-04.parquet size: 71 KB rows: 2,511
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-01-04 00:00:00 | ES | Futures | 1084.69 | 1084.93 | 1084.2 | 1084.45 | 788.0 |
| 2010-01-04 00:30:00 | ES | Futures | 1084.69 | 1085.18 | 1084.2 | 1084.69 | 1018.0 |
| 2010-01-04 01:00:00 | ES | Futures | 1084.69 | 1084.93 | 1084.2 | 1084.45 | 483.0 |
| 2010-01-04 01:30:00 | ES | Futures | 1084.45 | 1084.69 | 1083.96 | 1084.45 | 934.0 |
| 2010-01-04 02:00:00 | ES | Futures | 1084.69 | 1087.85 | 1084.45 | 1087.37 | 8758.0 |
| 2010-01-04 02:30:00 | ES | Futures | 1087.61 | 1087.85 | 1086.39 | 1086.64 | 4056.0 |
| 2010-01-04 03:00:00 | ES | Futures | 1086.88 | 1089.56 | 1086.39 | 1087.37 | 18587.0 |
| 2010-01-04 03:30:00 | ES | Futures | 1087.12 | 1088.83 | 1087.12 | 1088.58 | 8358.0 |
| 2010-01-04 04:00:00 | ES | Futures | 1088.34 | 1088.83 | 1087.37 | 1087.61 | 9323.0 |
| 2010-01-04 04:30:00 | ES | Futures | 1087.85 | 1088.1 | 1087.37 | 1087.85 | 6210.0 |
| 2010-01-04 05:00:00 | ES | Futures | 1088.1 | 1088.34 | 1087.61 | 1088.1 | 5405.0 |
| 2010-01-04 05:30:00 | ES | Futures | 1088.34 | 1088.34 | 1087.37 | 1088.34 | 5856.0 |
| 2010-01-04 06:00:00 | ES | Futures | 1088.34 | 1088.34 | 1087.61 | 1087.85 | 3366.0 |
| 2010-01-04 06:30:00 | ES | Futures | 1088.1 | 1088.34 | 1087.37 | 1087.85 | 5493.0 |
| 2010-01-04 07:00:00 | ES | Futures | 1087.85 | 1088.1 | 1087.37 | 1087.61 | 6205.0 |
| 2010-01-04 07:30:00 | ES | Futures | 1087.85 | 1087.85 | 1087.12 | 1087.37 | 9598.0 |
| 2010-01-04 08:00:00 | ES | Futures | 1087.37 | 1087.37 | 1086.64 | 1087.12 | 12800.0 |
| 2010-01-04 08:30:00 | ES | Futures | 1086.88 | 1088.83 | 1086.88 | 1088.83 | 20741.0 |
| 2010-01-04 09:00:00 | ES | Futures | 1088.83 | 1090.29 | 1088.58 | 1089.31 | 33855.0 |
| 2010-01-04 09:30:00 | ES | Futures | 1089.31 | 1094.91 | 1089.07 | 1094.18 | 198701.0 |
| 2010-01-04 10:00:00 | ES | Futures | 1094.18 | 1096.61 | 1092.96 | 1096.12 | 124016.0 |
| 2010-01-04 10:30:00 | ES | Futures | 1096.12 | 1097.83 | 1096.12 | 1096.37 | 95673.0 |
| 2010-01-04 11:00:00 | ES | Futures | 1096.37 | 1098.31 | 1096.37 | 1097.83 | 54304.0 |
| 2010-01-04 11:30:00 | ES | Futures | 1097.58 | 1099.29 | 1097.58 | 1098.07 | 66964.0 |
| 2010-01-04 12:00:00 | ES | Futures | 1098.31 | 1098.56 | 1097.83 | 1098.31 | 36934.0 |
| 2010-01-04 12:30:00 | ES | Futures | 1098.56 | 1099.04 | 1098.07 | 1098.56 | 52779.0 |
| 2010-01-04 13:00:00 | ES | Futures | 1098.8 | 1099.29 | 1098.07 | 1099.04 | 44030.0 |
| 2010-01-04 13:30:00 | ES | Futures | 1098.8 | 1099.29 | 1097.1 | 1097.34 | 51002.0 |
| 2010-01-04 14:00:00 | ES | Futures | 1097.34 | 1097.83 | 1097.1 | 1097.58 | 27830.0 |
| 2010-01-04 14:30:00 | ES | Futures | 1097.34 | 1099.29 | 1097.34 | 1098.07 | 52793.0 |
| 2010-01-04 15:00:00 | ES | Futures | 1098.31 | 1099.04 | 1097.58 | 1098.07 | 55165.0 |
| 2010-01-04 15:30:00 | ES | Futures | 1098.07 | 1098.56 | 1097.1 | 1098.31 | 152725.0 |
| 2010-01-04 16:00:00 | ES | Futures | 1098.56 | 1098.56 | 1097.83 | 1098.31 | 85509.0 |
| 2010-01-04 16:30:00 | ES | Futures | 1098.07 | 1098.31 | 1097.83 | 1098.07 | 2663.0 |
| 2010-01-04 17:00:00 | ES | Futures | 1098.07 | 1098.31 | 1097.58 | 1097.83 | 2812.0 |
| 2010-01-04 18:00:00 | ES | Futures | 1097.83 | 1098.07 | 1097.1 | 1097.58 | 1967.0 |
| 2010-01-04 18:30:00 | ES | Futures | 1097.58 | 1098.07 | 1096.85 | 1097.83 | 2219.0 |
| 2010-01-04 19:00:00 | ES | Futures | 1098.07 | 1098.07 | 1097.1 | 1097.58 | 1320.0 |
| 2010-01-04 19:30:00 | ES | Futures | 1097.58 | 1097.58 | 1096.61 | 1097.1 | 2402.0 |
| 2010-01-04 20:00:00 | ES | Futures | 1097.34 | 1097.34 | 1096.85 | 1097.1 | 705.0 |
| 2010-01-04 20:30:00 | ES | Futures | 1097.34 | 1097.34 | 1096.85 | 1097.1 | 834.0 |
| 2010-01-04 21:00:00 | ES | Futures | 1097.34 | 1097.34 | 1096.85 | 1097.1 | 523.0 |
| 2010-01-04 21:30:00 | ES | Futures | 1097.34 | 1097.83 | 1097.1 | 1097.58 | 862.0 |
| 2010-01-04 22:00:00 | ES | Futures | 1097.58 | 1098.07 | 1097.1 | 1097.83 | 2541.0 |
| 2010-01-04 22:30:00 | ES | Futures | 1097.83 | 1098.31 | 1097.58 | 1097.83 | 1151.0 |
| 2010-01-04 23:00:00 | ES | Futures | 1097.83 | 1098.31 | 1097.58 | 1097.58 | 1734.0 |
| 2010-01-04 23:30:00 | ES | Futures | 1097.58 | 1098.07 | 1097.34 | 1097.34 | 1282.0 |
| 2010-01-04 00:00:00 | NQ | Futures | 2135.65 | 2135.65 | 2135.08 | 2135.08 | 118.0 |
| 2010-01-04 00:30:00 | NQ | Futures | 2135.36 | 2136.51 | 2135.08 | 2135.36 | 96.0 |
| 2010-01-04 01:00:00 | NQ | Futures | 2135.36 | 2136.22 | 2135.36 | 2135.65 | 57.0 |
> showing 50 of 2,511 rows — these rows as CSV