PREVIEW / futures_30min / 2011-06-29
file: by_date/futures_30min/2011/2011-06-29.parquet size: 78 KB rows: 2,763
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-06-29 00:00:00 | ES | Futures | 1289.18 | 1289.18 | 1288.43 | 1288.68 | 1655.0 |
| 2011-06-29 00:30:00 | ES | Futures | 1288.68 | 1289.43 | 1288.43 | 1288.68 | 1377.0 |
| 2011-06-29 01:00:00 | ES | Futures | 1288.93 | 1289.18 | 1288.43 | 1288.68 | 1388.0 |
| 2011-06-29 01:30:00 | ES | Futures | 1288.93 | 1289.93 | 1288.43 | 1288.68 | 3064.0 |
| 2011-06-29 02:00:00 | ES | Futures | 1288.93 | 1290.42 | 1288.68 | 1289.93 | 5392.0 |
| 2011-06-29 02:30:00 | ES | Futures | 1290.17 | 1291.17 | 1289.43 | 1291.17 | 7343.0 |
| 2011-06-29 03:00:00 | ES | Futures | 1291.17 | 1293.42 | 1290.67 | 1291.92 | 26452.0 |
| 2011-06-29 03:30:00 | ES | Futures | 1291.67 | 1293.17 | 1291.42 | 1293.17 | 13098.0 |
| 2011-06-29 04:00:00 | ES | Futures | 1293.17 | 1295.91 | 1291.67 | 1295.41 | 27940.0 |
| 2011-06-29 04:30:00 | ES | Futures | 1295.41 | 1295.66 | 1292.92 | 1293.42 | 11918.0 |
| 2011-06-29 05:00:00 | ES | Futures | 1293.42 | 1294.91 | 1293.17 | 1294.41 | 9641.0 |
| 2011-06-29 05:30:00 | ES | Futures | 1294.17 | 1296.91 | 1293.92 | 1295.91 | 14479.0 |
| 2011-06-29 06:00:00 | ES | Futures | 1295.91 | 1296.91 | 1293.92 | 1294.17 | 16957.0 |
| 2011-06-29 06:30:00 | ES | Futures | 1294.17 | 1299.9 | 1293.92 | 1298.65 | 39548.0 |
| 2011-06-29 07:00:00 | ES | Futures | 1298.9 | 1301.15 | 1298.41 | 1300.15 | 34770.0 |
| 2011-06-29 07:30:00 | ES | Futures | 1300.15 | 1300.65 | 1297.16 | 1297.66 | 28255.0 |
| 2011-06-29 08:00:00 | ES | Futures | 1297.66 | 1298.9 | 1297.41 | 1298.16 | 20941.0 |
| 2011-06-29 08:30:00 | ES | Futures | 1298.16 | 1300.4 | 1293.42 | 1298.41 | 85040.0 |
| 2011-06-29 09:00:00 | ES | Futures | 1298.41 | 1301.15 | 1292.92 | 1294.41 | 140664.0 |
| 2011-06-29 09:30:00 | ES | Futures | 1294.41 | 1296.16 | 1291.42 | 1293.92 | 252466.0 |
| 2011-06-29 10:00:00 | ES | Futures | 1293.92 | 1294.66 | 1289.68 | 1293.67 | 191109.0 |
| 2011-06-29 10:30:00 | ES | Futures | 1293.67 | 1298.65 | 1293.17 | 1298.41 | 191068.0 |
| 2011-06-29 11:00:00 | ES | Futures | 1298.41 | 1300.15 | 1297.66 | 1298.9 | 169252.0 |
| 2011-06-29 11:30:00 | ES | Futures | 1298.9 | 1299.65 | 1297.41 | 1299.4 | 96836.0 |
| 2011-06-29 12:00:00 | ES | Futures | 1299.4 | 1300.9 | 1298.65 | 1299.4 | 72686.0 |
| 2011-06-29 12:30:00 | ES | Futures | 1299.4 | 1300.15 | 1298.9 | 1299.4 | 41863.0 |
| 2011-06-29 13:00:00 | ES | Futures | 1299.15 | 1301.9 | 1298.65 | 1300.15 | 85303.0 |
| 2011-06-29 13:30:00 | ES | Futures | 1299.9 | 1301.15 | 1298.16 | 1298.65 | 58432.0 |
| 2011-06-29 14:00:00 | ES | Futures | 1298.65 | 1299.4 | 1294.41 | 1295.66 | 148852.0 |
| 2011-06-29 14:30:00 | ES | Futures | 1295.66 | 1297.41 | 1293.92 | 1297.16 | 146202.0 |
| 2011-06-29 15:00:00 | ES | Futures | 1297.16 | 1300.15 | 1296.41 | 1298.9 | 156107.0 |
| 2011-06-29 15:30:00 | ES | Futures | 1299.15 | 1301.4 | 1298.41 | 1300.15 | 220569.0 |
| 2011-06-29 16:00:00 | ES | Futures | 1300.15 | 1302.4 | 1299.9 | 1301.4 | 121455.0 |
| 2011-06-29 16:30:00 | ES | Futures | 1300.9 | 1301.4 | 1300.4 | 1300.9 | 6917.0 |
| 2011-06-29 17:00:00 | ES | Futures | 1300.9 | 1301.15 | 1300.4 | 1300.9 | 1152.0 |
| 2011-06-29 18:00:00 | ES | Futures | 1300.9 | 1301.9 | 1300.65 | 1301.4 | 3605.0 |
| 2011-06-29 18:30:00 | ES | Futures | 1301.4 | 1301.9 | 1300.9 | 1301.4 | 1394.0 |
| 2011-06-29 19:00:00 | ES | Futures | 1301.15 | 1302.15 | 1301.15 | 1301.4 | 1524.0 |
| 2011-06-29 19:30:00 | ES | Futures | 1301.4 | 1301.9 | 1301.15 | 1301.4 | 1221.0 |
| 2011-06-29 20:00:00 | ES | Futures | 1301.15 | 1301.65 | 1300.15 | 1300.15 | 2473.0 |
| 2011-06-29 20:30:00 | ES | Futures | 1300.15 | 1300.65 | 1299.9 | 1300.4 | 1615.0 |
| 2011-06-29 21:00:00 | ES | Futures | 1300.65 | 1300.9 | 1299.15 | 1299.15 | 4377.0 |
| 2011-06-29 21:30:00 | ES | Futures | 1299.4 | 1299.9 | 1299.15 | 1299.4 | 1678.0 |
| 2011-06-29 22:00:00 | ES | Futures | 1299.65 | 1302.15 | 1299.4 | 1301.65 | 3924.0 |
| 2011-06-29 22:30:00 | ES | Futures | 1301.65 | 1303.89 | 1301.65 | 1303.39 | 8366.0 |
| 2011-06-29 23:00:00 | ES | Futures | 1303.39 | 1304.14 | 1303.14 | 1303.39 | 3626.0 |
| 2011-06-29 23:30:00 | ES | Futures | 1303.14 | 1304.14 | 1303.14 | 1303.64 | 1748.0 |
| 2011-06-29 00:00:00 | NQ | Futures | 2625.57 | 2625.57 | 2624.99 | 2624.99 | 41.0 |
| 2011-06-29 00:30:00 | NQ | Futures | 2624.99 | 2626.15 | 2624.42 | 2624.42 | 86.0 |
| 2011-06-29 01:00:00 | NQ | Futures | 2624.71 | 2625.57 | 2624.42 | 2625.57 | 41.0 |
> showing 50 of 2,763 rows — these rows as CSV