PREVIEW / futures_30min / 2010-03-16
file: by_date/futures_30min/2010/2010-03-16.parquet size: 67 KB rows: 2,489
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-03-16 00:00:00 | ES | Futures | 1120.94 | 1121.43 | 1120.69 | 1120.94 | 1562.0 |
| 2010-03-16 00:30:00 | ES | Futures | 1120.94 | 1121.67 | 1120.69 | 1121.43 | 409.0 |
| 2010-03-16 01:00:00 | ES | Futures | 1121.43 | 1121.67 | 1120.94 | 1121.18 | 773.0 |
| 2010-03-16 01:30:00 | ES | Futures | 1121.18 | 1121.43 | 1121.18 | 1121.43 | 187.0 |
| 2010-03-16 02:00:00 | ES | Futures | 1121.18 | 1121.18 | 1120.45 | 1120.94 | 1282.0 |
| 2010-03-16 02:30:00 | ES | Futures | 1120.94 | 1121.92 | 1120.94 | 1121.18 | 944.0 |
| 2010-03-16 03:00:00 | ES | Futures | 1121.18 | 1121.43 | 1120.69 | 1120.94 | 2311.0 |
| 2010-03-16 03:30:00 | ES | Futures | 1120.94 | 1120.94 | 1119.47 | 1119.72 | 5857.0 |
| 2010-03-16 04:00:00 | ES | Futures | 1119.72 | 1120.45 | 1118.98 | 1120.45 | 9784.0 |
| 2010-03-16 04:30:00 | ES | Futures | 1120.45 | 1121.43 | 1120.21 | 1121.18 | 4712.0 |
| 2010-03-16 05:00:00 | ES | Futures | 1121.18 | 1121.92 | 1120.94 | 1121.18 | 3683.0 |
| 2010-03-16 05:30:00 | ES | Futures | 1121.18 | 1122.65 | 1121.18 | 1121.92 | 5217.0 |
| 2010-03-16 06:00:00 | ES | Futures | 1121.92 | 1122.65 | 1121.18 | 1121.43 | 6845.0 |
| 2010-03-16 06:30:00 | ES | Futures | 1121.43 | 1123.14 | 1121.18 | 1122.89 | 6411.0 |
| 2010-03-16 07:00:00 | ES | Futures | 1122.65 | 1123.14 | 1122.16 | 1122.65 | 5776.0 |
| 2010-03-16 07:30:00 | ES | Futures | 1122.65 | 1123.14 | 1121.67 | 1121.92 | 6486.0 |
| 2010-03-16 08:00:00 | ES | Futures | 1121.92 | 1122.65 | 1121.18 | 1121.43 | 8829.0 |
| 2010-03-16 08:30:00 | ES | Futures | 1121.43 | 1123.38 | 1121.18 | 1122.16 | 22006.0 |
| 2010-03-16 09:00:00 | ES | Futures | 1122.16 | 1123.87 | 1122.16 | 1123.38 | 60923.0 |
| 2010-03-16 09:30:00 | ES | Futures | 1123.14 | 1123.38 | 1119.96 | 1122.16 | 144613.0 |
| 2010-03-16 10:00:00 | ES | Futures | 1121.92 | 1123.14 | 1121.18 | 1122.89 | 89374.0 |
| 2010-03-16 10:30:00 | ES | Futures | 1122.89 | 1126.32 | 1122.41 | 1125.83 | 156274.0 |
| 2010-03-16 11:00:00 | ES | Futures | 1125.58 | 1127.29 | 1124.85 | 1126.07 | 128464.0 |
| 2010-03-16 11:30:00 | ES | Futures | 1126.07 | 1126.81 | 1125.34 | 1125.83 | 70128.0 |
| 2010-03-16 12:00:00 | ES | Futures | 1125.83 | 1126.32 | 1124.85 | 1125.58 | 58345.0 |
| 2010-03-16 12:30:00 | ES | Futures | 1125.58 | 1126.07 | 1124.36 | 1124.85 | 39052.0 |
| 2010-03-16 13:00:00 | ES | Futures | 1124.85 | 1125.34 | 1124.36 | 1124.85 | 18451.0 |
| 2010-03-16 13:30:00 | ES | Futures | 1124.61 | 1124.85 | 1123.63 | 1124.61 | 35471.0 |
| 2010-03-16 14:00:00 | ES | Futures | 1124.36 | 1128.27 | 1123.14 | 1127.29 | 166954.0 |
| 2010-03-16 14:30:00 | ES | Futures | 1127.29 | 1127.29 | 1122.89 | 1126.56 | 162367.0 |
| 2010-03-16 15:00:00 | ES | Futures | 1126.81 | 1128.52 | 1125.58 | 1127.78 | 128337.0 |
| 2010-03-16 15:30:00 | ES | Futures | 1128.03 | 1129.98 | 1127.05 | 1129.0 | 199741.0 |
| 2010-03-16 16:00:00 | ES | Futures | 1129.0 | 1129.49 | 1128.52 | 1129.25 | 82968.0 |
| 2010-03-16 16:30:00 | ES | Futures | 1129.0 | 1129.25 | 1128.27 | 1128.76 | 5571.0 |
| 2010-03-16 17:00:00 | ES | Futures | 1128.76 | 1129.25 | 1128.76 | 1128.76 | 1512.0 |
| 2010-03-16 18:00:00 | ES | Futures | 1128.76 | 1129.25 | 1128.76 | 1129.0 | 1305.0 |
| 2010-03-16 18:30:00 | ES | Futures | 1129.0 | 1129.25 | 1128.76 | 1128.76 | 558.0 |
| 2010-03-16 19:00:00 | ES | Futures | 1128.76 | 1129.25 | 1128.76 | 1129.0 | 866.0 |
| 2010-03-16 19:30:00 | ES | Futures | 1129.25 | 1129.25 | 1128.52 | 1129.0 | 1380.0 |
| 2010-03-16 20:00:00 | ES | Futures | 1128.76 | 1129.25 | 1128.76 | 1129.0 | 1164.0 |
| 2010-03-16 20:30:00 | ES | Futures | 1129.25 | 1129.49 | 1129.0 | 1129.25 | 653.0 |
| 2010-03-16 21:00:00 | ES | Futures | 1129.0 | 1129.25 | 1128.76 | 1129.0 | 586.0 |
| 2010-03-16 21:30:00 | ES | Futures | 1129.0 | 1129.25 | 1128.52 | 1128.52 | 944.0 |
| 2010-03-16 22:00:00 | ES | Futures | 1128.76 | 1129.0 | 1128.52 | 1128.76 | 1129.0 |
| 2010-03-16 22:30:00 | ES | Futures | 1128.76 | 1129.0 | 1128.52 | 1128.76 | 373.0 |
| 2010-03-16 23:00:00 | ES | Futures | 1128.76 | 1129.25 | 1128.76 | 1129.25 | 855.0 |
| 2010-03-16 23:30:00 | ES | Futures | 1129.25 | 1131.45 | 1129.0 | 1130.47 | 3727.0 |
| 2010-03-16 00:00:00 | NQ | Futures | 2197.05 | 2198.48 | 2197.05 | 2197.62 | 119.0 |
| 2010-03-16 00:30:00 | NQ | Futures | 2197.62 | 2198.48 | 2197.62 | 2198.2 | 22.0 |
| 2010-03-16 01:00:00 | NQ | Futures | 2198.2 | 2198.2 | 2197.91 | 2198.2 | 28.0 |
> showing 50 of 2,489 rows — these rows as CSV