PREVIEW / futures_30min / 2011-04-14
file: by_date/futures_30min/2011/2011-04-14.parquet size: 78 KB rows: 2,765
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 |
|---|---|---|---|---|---|---|---|
| 2011-04-14 00:00:00 | ES | Futures | 1300.53 | 1300.53 | 1299.54 | 1300.29 | 850.0 |
| 2011-04-14 00:30:00 | ES | Futures | 1300.04 | 1301.28 | 1299.79 | 1301.28 | 1303.0 |
| 2011-04-14 01:00:00 | ES | Futures | 1301.03 | 1302.27 | 1300.78 | 1302.27 | 3293.0 |
| 2011-04-14 01:30:00 | ES | Futures | 1302.27 | 1302.52 | 1301.03 | 1302.02 | 2972.0 |
| 2011-04-14 02:00:00 | ES | Futures | 1302.02 | 1302.02 | 1300.53 | 1301.28 | 3383.0 |
| 2011-04-14 02:30:00 | ES | Futures | 1301.28 | 1301.28 | 1298.79 | 1299.54 | 4870.0 |
| 2011-04-14 03:00:00 | ES | Futures | 1299.29 | 1300.04 | 1298.3 | 1298.3 | 13260.0 |
| 2011-04-14 03:30:00 | ES | Futures | 1298.3 | 1299.29 | 1297.3 | 1298.3 | 16449.0 |
| 2011-04-14 04:00:00 | ES | Futures | 1298.3 | 1298.79 | 1297.3 | 1298.3 | 8532.0 |
| 2011-04-14 04:30:00 | ES | Futures | 1298.3 | 1299.79 | 1297.55 | 1297.8 | 9402.0 |
| 2011-04-14 05:00:00 | ES | Futures | 1297.8 | 1298.55 | 1297.3 | 1297.3 | 5939.0 |
| 2011-04-14 05:30:00 | ES | Futures | 1297.3 | 1297.8 | 1293.58 | 1293.58 | 31099.0 |
| 2011-04-14 06:00:00 | ES | Futures | 1293.83 | 1295.07 | 1293.33 | 1294.32 | 17950.0 |
| 2011-04-14 06:30:00 | ES | Futures | 1294.32 | 1295.32 | 1293.58 | 1293.83 | 10280.0 |
| 2011-04-14 07:00:00 | ES | Futures | 1293.83 | 1294.82 | 1292.83 | 1294.32 | 18412.0 |
| 2011-04-14 07:30:00 | ES | Futures | 1294.32 | 1295.81 | 1294.07 | 1295.57 | 12641.0 |
| 2011-04-14 08:00:00 | ES | Futures | 1295.32 | 1296.31 | 1294.57 | 1295.07 | 19434.0 |
| 2011-04-14 08:30:00 | ES | Futures | 1294.82 | 1295.32 | 1291.59 | 1293.58 | 68249.0 |
| 2011-04-14 09:00:00 | ES | Futures | 1293.58 | 1294.82 | 1292.34 | 1294.32 | 28288.0 |
| 2011-04-14 09:30:00 | ES | Futures | 1294.57 | 1296.06 | 1290.1 | 1293.83 | 303220.0 |
| 2011-04-14 10:00:00 | ES | Futures | 1293.83 | 1298.55 | 1293.33 | 1298.3 | 208270.0 |
| 2011-04-14 10:30:00 | ES | Futures | 1298.05 | 1300.04 | 1297.06 | 1297.55 | 163976.0 |
| 2011-04-14 11:00:00 | ES | Futures | 1297.55 | 1299.04 | 1295.81 | 1296.56 | 140962.0 |
| 2011-04-14 11:30:00 | ES | Futures | 1296.81 | 1298.05 | 1295.07 | 1297.8 | 106466.0 |
| 2011-04-14 12:00:00 | ES | Futures | 1297.55 | 1300.04 | 1297.06 | 1300.04 | 85491.0 |
| 2011-04-14 12:30:00 | ES | Futures | 1299.79 | 1301.28 | 1299.54 | 1300.53 | 49115.0 |
| 2011-04-14 13:00:00 | ES | Futures | 1300.78 | 1301.53 | 1298.79 | 1299.54 | 65790.0 |
| 2011-04-14 13:30:00 | ES | Futures | 1299.79 | 1300.53 | 1297.8 | 1298.05 | 44029.0 |
| 2011-04-14 14:00:00 | ES | Futures | 1298.05 | 1301.28 | 1297.8 | 1300.04 | 45788.0 |
| 2011-04-14 14:30:00 | ES | Futures | 1300.29 | 1302.02 | 1299.29 | 1301.28 | 71548.0 |
| 2011-04-14 15:00:00 | ES | Futures | 1301.28 | 1305.01 | 1300.78 | 1304.51 | 163615.0 |
| 2011-04-14 15:30:00 | ES | Futures | 1304.26 | 1304.76 | 1302.27 | 1303.02 | 144750.0 |
| 2011-04-14 16:00:00 | ES | Futures | 1303.02 | 1303.52 | 1301.03 | 1302.52 | 103107.0 |
| 2011-04-14 16:30:00 | ES | Futures | 1302.27 | 1302.52 | 1301.53 | 1302.27 | 8003.0 |
| 2011-04-14 17:00:00 | ES | Futures | 1302.27 | 1303.52 | 1302.02 | 1303.27 | 2401.0 |
| 2011-04-14 18:00:00 | ES | Futures | 1303.02 | 1304.26 | 1302.77 | 1303.76 | 1977.0 |
| 2011-04-14 18:30:00 | ES | Futures | 1303.76 | 1304.51 | 1302.77 | 1303.52 | 2529.0 |
| 2011-04-14 19:00:00 | ES | Futures | 1303.27 | 1303.76 | 1302.77 | 1303.52 | 894.0 |
| 2011-04-14 19:30:00 | ES | Futures | 1303.52 | 1305.01 | 1303.27 | 1304.76 | 2185.0 |
| 2011-04-14 20:00:00 | ES | Futures | 1304.51 | 1304.76 | 1302.77 | 1303.27 | 2837.0 |
| 2011-04-14 20:30:00 | ES | Futures | 1303.27 | 1303.52 | 1301.78 | 1302.77 | 2892.0 |
| 2011-04-14 21:00:00 | ES | Futures | 1302.52 | 1303.52 | 1301.53 | 1301.53 | 3446.0 |
| 2011-04-14 21:30:00 | ES | Futures | 1301.53 | 1302.77 | 1301.03 | 1302.27 | 2659.0 |
| 2011-04-14 22:00:00 | ES | Futures | 1302.27 | 1303.76 | 1302.27 | 1302.77 | 4783.0 |
| 2011-04-14 22:30:00 | ES | Futures | 1302.77 | 1303.27 | 1301.78 | 1302.27 | 1961.0 |
| 2011-04-14 23:00:00 | ES | Futures | 1302.52 | 1302.52 | 1300.53 | 1300.53 | 2484.0 |
| 2011-04-14 23:30:00 | ES | Futures | 1300.53 | 1301.28 | 1300.29 | 1300.78 | 2715.0 |
| 2011-04-14 00:00:00 | NQ | Futures | 2652.49 | 2652.49 | 2650.48 | 2651.05 | 176.0 |
| 2011-04-14 00:30:00 | NQ | Futures | 2651.34 | 2653.35 | 2650.19 | 2653.35 | 130.0 |
| 2011-04-14 01:00:00 | NQ | Futures | 2653.06 | 2654.5 | 2653.06 | 2654.21 | 369.0 |
> showing 50 of 2,765 rows — these rows as CSV