PREVIEW / futures_30min / 2008-04-29
file: by_date/futures_30min/2008/2008-04-29.parquet size: 65 KB rows: 2,246
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-29 00:00:00 | ES | Futures | 1301.6 | 1302.06 | 1301.6 | 1301.83 | 92.0 |
| 2008-04-29 00:30:00 | ES | Futures | 1301.83 | 1301.83 | 1301.36 | 1301.36 | 253.0 |
| 2008-04-29 01:00:00 | ES | Futures | 1301.36 | 1302.06 | 1301.36 | 1301.6 | 184.0 |
| 2008-04-29 01:30:00 | ES | Futures | 1301.6 | 1302.53 | 1301.6 | 1302.53 | 431.0 |
| 2008-04-29 02:00:00 | ES | Futures | 1302.53 | 1302.99 | 1300.66 | 1300.9 | 2206.0 |
| 2008-04-29 02:30:00 | ES | Futures | 1300.66 | 1300.9 | 1298.57 | 1299.27 | 3637.0 |
| 2008-04-29 03:00:00 | ES | Futures | 1299.27 | 1300.66 | 1299.27 | 1300.66 | 6338.0 |
| 2008-04-29 03:30:00 | ES | Futures | 1300.9 | 1301.36 | 1299.73 | 1300.9 | 7117.0 |
| 2008-04-29 04:00:00 | ES | Futures | 1300.9 | 1302.29 | 1300.2 | 1300.66 | 5609.0 |
| 2008-04-29 04:30:00 | ES | Futures | 1300.43 | 1301.83 | 1299.27 | 1299.5 | 4788.0 |
| 2008-04-29 05:00:00 | ES | Futures | 1299.27 | 1300.2 | 1298.8 | 1299.97 | 3644.0 |
| 2008-04-29 05:30:00 | ES | Futures | 1299.73 | 1299.97 | 1298.57 | 1298.57 | 2986.0 |
| 2008-04-29 06:00:00 | ES | Futures | 1298.57 | 1299.04 | 1297.87 | 1298.57 | 5680.0 |
| 2008-04-29 06:30:00 | ES | Futures | 1298.34 | 1299.5 | 1298.34 | 1298.57 | 3567.0 |
| 2008-04-29 07:00:00 | ES | Futures | 1298.57 | 1299.97 | 1298.1 | 1299.97 | 7771.0 |
| 2008-04-29 07:30:00 | ES | Futures | 1299.73 | 1300.43 | 1298.34 | 1298.57 | 9101.0 |
| 2008-04-29 08:00:00 | ES | Futures | 1298.57 | 1300.9 | 1298.1 | 1300.43 | 25801.0 |
| 2008-04-29 08:30:00 | ES | Futures | 1300.66 | 1301.6 | 1299.5 | 1300.2 | 10852.0 |
| 2008-04-29 09:00:00 | ES | Futures | 1299.97 | 1300.2 | 1298.8 | 1299.27 | 20707.0 |
| 2008-04-29 09:30:00 | ES | Futures | 1299.27 | 1302.29 | 1297.64 | 1299.04 | 150502.0 |
| 2008-04-29 10:00:00 | ES | Futures | 1298.8 | 1300.9 | 1293.45 | 1294.15 | 175759.0 |
| 2008-04-29 10:30:00 | ES | Futures | 1294.15 | 1295.31 | 1291.82 | 1293.45 | 140503.0 |
| 2008-04-29 11:00:00 | ES | Futures | 1293.45 | 1296.01 | 1292.52 | 1295.78 | 82349.0 |
| 2008-04-29 11:30:00 | ES | Futures | 1295.54 | 1296.24 | 1293.91 | 1294.61 | 64285.0 |
| 2008-04-29 12:00:00 | ES | Futures | 1294.38 | 1296.94 | 1293.45 | 1296.47 | 60974.0 |
| 2008-04-29 12:30:00 | ES | Futures | 1296.47 | 1297.41 | 1295.31 | 1295.54 | 68114.0 |
| 2008-04-29 13:00:00 | ES | Futures | 1295.78 | 1298.34 | 1294.84 | 1297.64 | 77978.0 |
| 2008-04-29 13:30:00 | ES | Futures | 1297.41 | 1299.73 | 1296.94 | 1297.87 | 89742.0 |
| 2008-04-29 14:00:00 | ES | Futures | 1297.87 | 1299.04 | 1296.24 | 1297.87 | 65684.0 |
| 2008-04-29 14:30:00 | ES | Futures | 1298.1 | 1301.36 | 1296.94 | 1300.66 | 87525.0 |
| 2008-04-29 15:00:00 | ES | Futures | 1300.9 | 1301.36 | 1297.41 | 1297.41 | 79308.0 |
| 2008-04-29 15:30:00 | ES | Futures | 1297.41 | 1298.8 | 1295.31 | 1296.24 | 116579.0 |
| 2008-04-29 16:00:00 | ES | Futures | 1296.24 | 1296.94 | 1295.31 | 1295.54 | 51544.0 |
| 2008-04-29 16:30:00 | ES | Futures | 1292.75 | 1294.38 | 1292.52 | 1294.38 | 8005.0 |
| 2008-04-29 17:00:00 | ES | Futures | 1294.15 | 1294.38 | 1293.68 | 1294.15 | 1357.0 |
| 2008-04-29 18:00:00 | ES | Futures | 1294.38 | 1294.84 | 1293.91 | 1294.38 | 555.0 |
| 2008-04-29 18:30:00 | ES | Futures | 1294.61 | 1296.01 | 1294.61 | 1295.54 | 1261.0 |
| 2008-04-29 19:00:00 | ES | Futures | 1295.54 | 1295.78 | 1294.61 | 1294.84 | 559.0 |
| 2008-04-29 19:30:00 | ES | Futures | 1294.61 | 1295.54 | 1294.38 | 1295.08 | 427.0 |
| 2008-04-29 20:00:00 | ES | Futures | 1295.08 | 1296.71 | 1295.08 | 1296.24 | 1206.0 |
| 2008-04-29 20:30:00 | ES | Futures | 1296.47 | 1297.41 | 1296.47 | 1297.41 | 739.0 |
| 2008-04-29 21:00:00 | ES | Futures | 1297.41 | 1298.1 | 1296.71 | 1297.64 | 1504.0 |
| 2008-04-29 21:30:00 | ES | Futures | 1297.87 | 1298.1 | 1297.41 | 1297.87 | 605.0 |
| 2008-04-29 22:00:00 | ES | Futures | 1298.1 | 1298.34 | 1297.87 | 1298.1 | 785.0 |
| 2008-04-29 22:30:00 | ES | Futures | 1298.1 | 1298.8 | 1297.87 | 1298.34 | 870.0 |
| 2008-04-29 23:00:00 | ES | Futures | 1298.57 | 1298.8 | 1298.1 | 1298.57 | 415.0 |
| 2008-04-29 23:30:00 | ES | Futures | 1298.57 | 1299.04 | 1298.1 | 1298.8 | 723.0 |
| 2008-04-29 00:00:00 | NQ | Futures | 2180.04 | 2180.04 | 2178.91 | 2178.91 | 6.0 |
| 2008-04-29 00:30:00 | NQ | Futures | 2178.91 | 2180.04 | 2178.63 | 2180.04 | 3.0 |
| 2008-04-29 01:00:00 | NQ | Futures | 2179.19 | 2179.48 | 2178.91 | 2179.48 | 13.0 |
> showing 50 of 2,246 rows — these rows as CSV