PREVIEW / futures_30min / 2008-04-28
file: by_date/futures_30min/2008/2008-04-28.parquet size: 62 KB rows: 2,209
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-28 00:00:00 | ES | Futures | 1301.36 | 1301.83 | 1299.04 | 1299.27 | 504.0 |
| 2008-04-28 00:30:00 | ES | Futures | 1299.27 | 1299.27 | 1298.34 | 1298.8 | 760.0 |
| 2008-04-28 01:00:00 | ES | Futures | 1298.8 | 1301.36 | 1297.87 | 1300.43 | 1135.0 |
| 2008-04-28 01:30:00 | ES | Futures | 1300.43 | 1301.13 | 1299.5 | 1300.43 | 462.0 |
| 2008-04-28 02:00:00 | ES | Futures | 1300.43 | 1302.99 | 1299.97 | 1302.29 | 2062.0 |
| 2008-04-28 02:30:00 | ES | Futures | 1302.29 | 1304.16 | 1302.29 | 1302.76 | 4092.0 |
| 2008-04-28 03:00:00 | ES | Futures | 1302.76 | 1306.25 | 1301.13 | 1304.62 | 12503.0 |
| 2008-04-28 03:30:00 | ES | Futures | 1304.39 | 1305.32 | 1303.23 | 1303.46 | 6016.0 |
| 2008-04-28 04:00:00 | ES | Futures | 1303.46 | 1303.69 | 1302.06 | 1302.76 | 2976.0 |
| 2008-04-28 04:30:00 | ES | Futures | 1302.76 | 1304.39 | 1302.06 | 1303.69 | 3006.0 |
| 2008-04-28 05:00:00 | ES | Futures | 1303.92 | 1305.32 | 1302.99 | 1304.39 | 2519.0 |
| 2008-04-28 05:30:00 | ES | Futures | 1304.16 | 1305.55 | 1303.92 | 1305.32 | 3035.0 |
| 2008-04-28 06:00:00 | ES | Futures | 1305.55 | 1308.35 | 1305.32 | 1306.49 | 9248.0 |
| 2008-04-28 06:30:00 | ES | Futures | 1306.49 | 1308.35 | 1306.25 | 1306.95 | 4488.0 |
| 2008-04-28 07:00:00 | ES | Futures | 1307.18 | 1307.65 | 1306.02 | 1306.25 | 7858.0 |
| 2008-04-28 07:30:00 | ES | Futures | 1306.25 | 1306.49 | 1304.86 | 1305.09 | 6921.0 |
| 2008-04-28 08:00:00 | ES | Futures | 1305.32 | 1306.02 | 1304.16 | 1304.86 | 15368.0 |
| 2008-04-28 08:30:00 | ES | Futures | 1304.86 | 1306.72 | 1302.53 | 1302.99 | 28018.0 |
| 2008-04-28 09:00:00 | ES | Futures | 1302.99 | 1304.39 | 1302.06 | 1304.16 | 18754.0 |
| 2008-04-28 09:30:00 | ES | Futures | 1304.39 | 1305.32 | 1299.5 | 1302.76 | 149694.0 |
| 2008-04-28 10:00:00 | ES | Futures | 1302.53 | 1305.32 | 1300.2 | 1303.92 | 118774.0 |
| 2008-04-28 10:30:00 | ES | Futures | 1303.92 | 1306.49 | 1303.46 | 1305.32 | 86781.0 |
| 2008-04-28 11:00:00 | ES | Futures | 1305.55 | 1305.79 | 1301.13 | 1302.53 | 75946.0 |
| 2008-04-28 11:30:00 | ES | Futures | 1302.53 | 1304.62 | 1301.83 | 1303.23 | 46448.0 |
| 2008-04-28 12:00:00 | ES | Futures | 1303.23 | 1306.02 | 1302.99 | 1305.79 | 45193.0 |
| 2008-04-28 12:30:00 | ES | Futures | 1306.02 | 1306.72 | 1304.16 | 1304.62 | 45596.0 |
| 2008-04-28 13:00:00 | ES | Futures | 1304.39 | 1306.25 | 1304.16 | 1305.55 | 51537.0 |
| 2008-04-28 13:30:00 | ES | Futures | 1305.79 | 1307.42 | 1305.32 | 1306.72 | 53987.0 |
| 2008-04-28 14:00:00 | ES | Futures | 1306.72 | 1307.65 | 1304.86 | 1305.09 | 50994.0 |
| 2008-04-28 14:30:00 | ES | Futures | 1305.09 | 1307.18 | 1304.39 | 1305.55 | 44754.0 |
| 2008-04-28 15:00:00 | ES | Futures | 1305.55 | 1307.65 | 1303.46 | 1303.92 | 71963.0 |
| 2008-04-28 15:30:00 | ES | Futures | 1303.92 | 1304.16 | 1299.5 | 1301.83 | 128414.0 |
| 2008-04-28 16:00:00 | ES | Futures | 1301.83 | 1302.29 | 1301.13 | 1301.36 | 45081.0 |
| 2008-04-28 16:30:00 | ES | Futures | 1301.36 | 1302.29 | 1300.9 | 1302.06 | 4028.0 |
| 2008-04-28 17:00:00 | ES | Futures | 1301.83 | 1302.06 | 1300.9 | 1301.6 | 1965.0 |
| 2008-04-28 18:00:00 | ES | Futures | 1301.83 | 1302.53 | 1301.13 | 1302.53 | 1243.0 |
| 2008-04-28 18:30:00 | ES | Futures | 1302.53 | 1302.76 | 1302.06 | 1302.53 | 333.0 |
| 2008-04-28 19:00:00 | ES | Futures | 1302.53 | 1302.76 | 1302.29 | 1302.29 | 353.0 |
| 2008-04-28 19:30:00 | ES | Futures | 1302.29 | 1302.53 | 1301.83 | 1301.83 | 242.0 |
| 2008-04-28 20:00:00 | ES | Futures | 1302.06 | 1302.76 | 1301.83 | 1302.53 | 400.0 |
| 2008-04-28 20:30:00 | ES | Futures | 1302.53 | 1302.76 | 1301.13 | 1301.6 | 641.0 |
| 2008-04-28 21:00:00 | ES | Futures | 1301.13 | 1301.83 | 1301.13 | 1301.6 | 195.0 |
| 2008-04-28 21:30:00 | ES | Futures | 1301.36 | 1301.6 | 1300.9 | 1301.36 | 734.0 |
| 2008-04-28 22:00:00 | ES | Futures | 1301.36 | 1302.06 | 1301.13 | 1301.6 | 333.0 |
| 2008-04-28 22:30:00 | ES | Futures | 1301.36 | 1302.29 | 1301.13 | 1302.06 | 288.0 |
| 2008-04-28 23:00:00 | ES | Futures | 1302.06 | 1302.29 | 1301.6 | 1301.83 | 236.0 |
| 2008-04-28 23:30:00 | ES | Futures | 1301.6 | 1302.29 | 1301.6 | 1301.83 | 151.0 |
| 2008-04-28 00:00:00 | NQ | Futures | 2174.67 | 2174.67 | 2172.12 | 2172.12 | 35.0 |
| 2008-04-28 00:30:00 | NQ | Futures | 2172.69 | 2174.67 | 2170.71 | 2170.71 | 87.0 |
| 2008-04-28 01:00:00 | NQ | Futures | 2170.99 | 2172.69 | 2170.71 | 2172.69 | 24.0 |
> showing 50 of 2,209 rows — these rows as CSV