PREVIEW / futures_30min / 2010-08-03
file: by_date/futures_30min/2010/2010-08-03.parquet size: 69 KB rows: 2,574
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-08-03 00:00:00 | ES | Futures | 1098.81 | 1099.3 | 1098.32 | 1098.32 | 687.0 |
| 2010-08-03 00:30:00 | ES | Futures | 1098.32 | 1099.05 | 1098.07 | 1098.81 | 1000.0 |
| 2010-08-03 01:00:00 | ES | Futures | 1098.81 | 1100.04 | 1098.81 | 1099.3 | 2153.0 |
| 2010-08-03 01:30:00 | ES | Futures | 1099.3 | 1099.79 | 1098.07 | 1098.32 | 3513.0 |
| 2010-08-03 02:00:00 | ES | Futures | 1098.32 | 1099.79 | 1098.07 | 1099.55 | 3303.0 |
| 2010-08-03 02:30:00 | ES | Futures | 1099.55 | 1100.28 | 1098.32 | 1098.32 | 5206.0 |
| 2010-08-03 03:00:00 | ES | Futures | 1098.56 | 1098.81 | 1097.09 | 1097.58 | 14361.0 |
| 2010-08-03 03:30:00 | ES | Futures | 1097.58 | 1098.07 | 1096.11 | 1097.83 | 14418.0 |
| 2010-08-03 04:00:00 | ES | Futures | 1098.07 | 1099.79 | 1097.58 | 1099.3 | 12235.0 |
| 2010-08-03 04:30:00 | ES | Futures | 1099.05 | 1099.55 | 1097.83 | 1099.05 | 6001.0 |
| 2010-08-03 05:00:00 | ES | Futures | 1098.81 | 1099.3 | 1098.32 | 1099.3 | 3353.0 |
| 2010-08-03 05:30:00 | ES | Futures | 1099.05 | 1100.77 | 1098.81 | 1099.55 | 9285.0 |
| 2010-08-03 06:00:00 | ES | Futures | 1099.79 | 1101.26 | 1099.55 | 1101.02 | 5969.0 |
| 2010-08-03 06:30:00 | ES | Futures | 1100.77 | 1101.02 | 1099.3 | 1099.55 | 7486.0 |
| 2010-08-03 07:00:00 | ES | Futures | 1099.55 | 1100.04 | 1097.09 | 1097.83 | 15800.0 |
| 2010-08-03 07:30:00 | ES | Futures | 1097.83 | 1099.55 | 1097.58 | 1099.3 | 14177.0 |
| 2010-08-03 08:00:00 | ES | Futures | 1099.3 | 1100.28 | 1098.81 | 1099.05 | 12900.0 |
| 2010-08-03 08:30:00 | ES | Futures | 1098.81 | 1100.77 | 1097.58 | 1100.04 | 28021.0 |
| 2010-08-03 09:00:00 | ES | Futures | 1100.28 | 1100.28 | 1098.07 | 1098.81 | 19155.0 |
| 2010-08-03 09:30:00 | ES | Futures | 1099.05 | 1099.79 | 1094.88 | 1095.62 | 173982.0 |
| 2010-08-03 10:00:00 | ES | Futures | 1095.86 | 1096.11 | 1092.67 | 1094.88 | 171334.0 |
| 2010-08-03 10:30:00 | ES | Futures | 1095.13 | 1099.55 | 1094.39 | 1099.05 | 131766.0 |
| 2010-08-03 11:00:00 | ES | Futures | 1099.05 | 1100.28 | 1097.58 | 1098.56 | 86731.0 |
| 2010-08-03 11:30:00 | ES | Futures | 1098.56 | 1102.0 | 1098.56 | 1099.79 | 88045.0 |
| 2010-08-03 12:00:00 | ES | Futures | 1100.04 | 1100.04 | 1095.62 | 1096.11 | 101973.0 |
| 2010-08-03 12:30:00 | ES | Futures | 1096.11 | 1098.56 | 1096.11 | 1097.58 | 51973.0 |
| 2010-08-03 13:00:00 | ES | Futures | 1097.34 | 1098.07 | 1095.37 | 1097.34 | 53101.0 |
| 2010-08-03 13:30:00 | ES | Futures | 1097.34 | 1098.56 | 1096.85 | 1097.58 | 47286.0 |
| 2010-08-03 14:00:00 | ES | Futures | 1097.58 | 1099.3 | 1096.85 | 1099.3 | 42834.0 |
| 2010-08-03 14:30:00 | ES | Futures | 1099.3 | 1099.3 | 1097.09 | 1098.07 | 51722.0 |
| 2010-08-03 15:00:00 | ES | Futures | 1098.32 | 1098.56 | 1095.62 | 1096.36 | 62972.0 |
| 2010-08-03 15:30:00 | ES | Futures | 1096.36 | 1097.34 | 1093.9 | 1096.11 | 143455.0 |
| 2010-08-03 16:00:00 | ES | Futures | 1096.36 | 1098.07 | 1095.86 | 1097.58 | 76257.0 |
| 2010-08-03 16:30:00 | ES | Futures | 1097.34 | 1098.32 | 1096.85 | 1098.07 | 4468.0 |
| 2010-08-03 17:00:00 | ES | Futures | 1098.32 | 1098.32 | 1097.58 | 1098.07 | 1213.0 |
| 2010-08-03 18:00:00 | ES | Futures | 1098.07 | 1098.07 | 1097.34 | 1097.58 | 701.0 |
| 2010-08-03 18:30:00 | ES | Futures | 1097.58 | 1097.83 | 1097.09 | 1097.34 | 518.0 |
| 2010-08-03 19:00:00 | ES | Futures | 1097.09 | 1097.58 | 1097.09 | 1097.58 | 375.0 |
| 2010-08-03 19:30:00 | ES | Futures | 1097.58 | 1097.83 | 1097.34 | 1097.58 | 821.0 |
| 2010-08-03 20:00:00 | ES | Futures | 1097.58 | 1097.83 | 1096.6 | 1096.85 | 3228.0 |
| 2010-08-03 20:30:00 | ES | Futures | 1096.6 | 1097.34 | 1095.86 | 1096.36 | 3046.0 |
| 2010-08-03 21:00:00 | ES | Futures | 1096.36 | 1097.58 | 1096.36 | 1097.34 | 2589.0 |
| 2010-08-03 21:30:00 | ES | Futures | 1097.34 | 1098.32 | 1097.09 | 1098.07 | 2261.0 |
| 2010-08-03 22:00:00 | ES | Futures | 1098.07 | 1098.56 | 1097.34 | 1097.83 | 2280.0 |
| 2010-08-03 22:30:00 | ES | Futures | 1097.83 | 1097.83 | 1096.85 | 1097.58 | 950.0 |
| 2010-08-03 23:00:00 | ES | Futures | 1097.34 | 1097.58 | 1096.6 | 1097.34 | 1698.0 |
| 2010-08-03 23:30:00 | ES | Futures | 1097.09 | 1097.34 | 1095.62 | 1095.86 | 2933.0 |
| 2010-08-03 00:00:00 | NQ | Futures | 2168.73 | 2169.02 | 2167.59 | 2167.59 | 45.0 |
| 2010-08-03 00:30:00 | NQ | Futures | 2167.87 | 2169.02 | 2167.01 | 2167.87 | 88.0 |
| 2010-08-03 01:00:00 | NQ | Futures | 2167.87 | 2170.16 | 2167.87 | 2168.45 | 63.0 |
> showing 50 of 2,574 rows — these rows as CSV