PREVIEW / futures_30min / 2011-02-25
file: by_date/futures_30min/2011/2011-02-25.parquet size: 61 KB rows: 2,075
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-02-25 00:00:00 | ES | Futures | 1294.29 | 1295.03 | 1294.04 | 1294.79 | 1157.0 |
| 2011-02-25 00:30:00 | ES | Futures | 1294.79 | 1295.28 | 1294.54 | 1294.79 | 1554.0 |
| 2011-02-25 01:00:00 | ES | Futures | 1294.79 | 1295.03 | 1293.8 | 1294.29 | 2443.0 |
| 2011-02-25 01:30:00 | ES | Futures | 1294.29 | 1294.79 | 1294.04 | 1294.54 | 2527.0 |
| 2011-02-25 02:00:00 | ES | Futures | 1294.29 | 1295.28 | 1294.04 | 1294.29 | 7460.0 |
| 2011-02-25 02:30:00 | ES | Futures | 1294.29 | 1294.79 | 1292.31 | 1293.8 | 9766.0 |
| 2011-02-25 03:00:00 | ES | Futures | 1293.55 | 1294.04 | 1291.82 | 1293.3 | 16481.0 |
| 2011-02-25 03:30:00 | ES | Futures | 1293.3 | 1294.79 | 1292.56 | 1294.54 | 9392.0 |
| 2011-02-25 04:00:00 | ES | Futures | 1294.29 | 1296.77 | 1294.29 | 1296.77 | 23361.0 |
| 2011-02-25 04:30:00 | ES | Futures | 1296.52 | 1296.77 | 1295.78 | 1296.02 | 11794.0 |
| 2011-02-25 05:00:00 | ES | Futures | 1296.02 | 1296.52 | 1294.54 | 1295.78 | 8294.0 |
| 2011-02-25 05:30:00 | ES | Futures | 1295.78 | 1297.26 | 1295.78 | 1296.52 | 9073.0 |
| 2011-02-25 06:00:00 | ES | Futures | 1296.77 | 1298.25 | 1296.02 | 1298.0 | 11944.0 |
| 2011-02-25 06:30:00 | ES | Futures | 1298.0 | 1298.25 | 1297.26 | 1297.76 | 12333.0 |
| 2011-02-25 07:00:00 | ES | Futures | 1297.51 | 1299.73 | 1297.51 | 1298.99 | 24392.0 |
| 2011-02-25 07:30:00 | ES | Futures | 1299.24 | 1299.24 | 1296.52 | 1296.77 | 15794.0 |
| 2011-02-25 08:00:00 | ES | Futures | 1296.77 | 1298.99 | 1296.52 | 1298.0 | 20038.0 |
| 2011-02-25 08:30:00 | ES | Futures | 1298.25 | 1298.5 | 1295.53 | 1298.0 | 43054.0 |
| 2011-02-25 09:00:00 | ES | Futures | 1298.25 | 1298.25 | 1296.02 | 1297.01 | 35594.0 |
| 2011-02-25 09:30:00 | ES | Futures | 1297.01 | 1301.47 | 1296.27 | 1301.22 | 231266.0 |
| 2011-02-25 10:00:00 | ES | Futures | 1301.22 | 1303.94 | 1300.97 | 1301.96 | 199356.0 |
| 2011-02-25 10:30:00 | ES | Futures | 1301.71 | 1304.44 | 1301.22 | 1303.45 | 118978.0 |
| 2011-02-25 11:00:00 | ES | Futures | 1303.45 | 1303.94 | 1300.48 | 1300.72 | 127427.0 |
| 2011-02-25 11:30:00 | ES | Futures | 1300.72 | 1301.71 | 1298.74 | 1300.72 | 125424.0 |
| 2011-02-25 12:00:00 | ES | Futures | 1300.48 | 1303.2 | 1300.23 | 1302.95 | 51357.0 |
| 2011-02-25 12:30:00 | ES | Futures | 1302.95 | 1303.94 | 1302.21 | 1303.45 | 49326.0 |
| 2011-02-25 13:00:00 | ES | Futures | 1303.45 | 1305.92 | 1302.95 | 1305.18 | 82729.0 |
| 2011-02-25 13:30:00 | ES | Futures | 1305.43 | 1306.17 | 1303.94 | 1304.68 | 70197.0 |
| 2011-02-25 14:00:00 | ES | Futures | 1304.68 | 1306.41 | 1303.69 | 1305.18 | 78289.0 |
| 2011-02-25 14:30:00 | ES | Futures | 1305.18 | 1306.17 | 1304.19 | 1305.43 | 46404.0 |
| 2011-02-25 15:00:00 | ES | Futures | 1305.43 | 1305.92 | 1303.94 | 1304.68 | 47927.0 |
| 2011-02-25 15:30:00 | ES | Futures | 1304.93 | 1305.92 | 1303.45 | 1305.43 | 165485.0 |
| 2011-02-25 16:00:00 | ES | Futures | 1305.18 | 1305.67 | 1304.44 | 1305.18 | 103694.0 |
| 2011-02-25 00:00:00 | NQ | Futures | 2659.36 | 2660.79 | 2659.36 | 2660.5 | 145.0 |
| 2011-02-25 00:30:00 | NQ | Futures | 2660.79 | 2663.95 | 2660.79 | 2663.37 | 397.0 |
| 2011-02-25 01:00:00 | NQ | Futures | 2663.66 | 2663.66 | 2660.5 | 2661.36 | 99.0 |
| 2011-02-25 01:30:00 | NQ | Futures | 2661.94 | 2663.09 | 2661.94 | 2662.51 | 73.0 |
| 2011-02-25 02:00:00 | NQ | Futures | 2662.51 | 2663.95 | 2660.79 | 2661.36 | 555.0 |
| 2011-02-25 02:30:00 | NQ | Futures | 2661.65 | 2663.66 | 2659.64 | 2662.8 | 1165.0 |
| 2011-02-25 03:00:00 | NQ | Futures | 2662.8 | 2663.09 | 2659.07 | 2662.23 | 1727.0 |
| 2011-02-25 03:30:00 | NQ | Futures | 2662.23 | 2665.38 | 2661.36 | 2665.1 | 1461.0 |
| 2011-02-25 04:00:00 | NQ | Futures | 2665.1 | 2668.25 | 2664.81 | 2667.68 | 1256.0 |
| 2011-02-25 04:30:00 | NQ | Futures | 2667.68 | 2668.54 | 2666.53 | 2667.39 | 704.0 |
| 2011-02-25 05:00:00 | NQ | Futures | 2667.39 | 2667.97 | 2664.52 | 2667.68 | 670.0 |
| 2011-02-25 05:30:00 | NQ | Futures | 2667.68 | 2671.12 | 2667.68 | 2668.25 | 1522.0 |
| 2011-02-25 06:00:00 | NQ | Futures | 2668.54 | 2671.12 | 2667.11 | 2670.84 | 755.0 |
| 2011-02-25 06:30:00 | NQ | Futures | 2670.84 | 2671.12 | 2668.83 | 2669.69 | 783.0 |
| 2011-02-25 07:00:00 | NQ | Futures | 2669.69 | 2672.56 | 2669.4 | 2671.99 | 1703.0 |
| 2011-02-25 07:30:00 | NQ | Futures | 2671.99 | 2672.56 | 2668.83 | 2669.11 | 1079.0 |
| 2011-02-25 08:00:00 | NQ | Futures | 2669.4 | 2672.56 | 2669.4 | 2670.84 | 1847.0 |
> showing 50 of 2,075 rows — these rows as CSV