PREVIEW / futures_30min / 2008-04-25
file: by_date/futures_30min/2008/2008-04-25.parquet size: 58 KB rows: 1,856
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-25 00:00:00 | ES | Futures | 1292.52 | 1293.45 | 1291.12 | 1292.98 | 1501.0 |
| 2008-04-25 00:30:00 | ES | Futures | 1292.75 | 1292.98 | 1290.65 | 1291.58 | 916.0 |
| 2008-04-25 01:00:00 | ES | Futures | 1291.82 | 1292.52 | 1291.35 | 1292.05 | 196.0 |
| 2008-04-25 01:30:00 | ES | Futures | 1292.28 | 1293.68 | 1291.82 | 1293.21 | 851.0 |
| 2008-04-25 02:00:00 | ES | Futures | 1293.45 | 1294.61 | 1291.82 | 1294.38 | 2340.0 |
| 2008-04-25 02:30:00 | ES | Futures | 1294.61 | 1294.84 | 1292.75 | 1294.61 | 2742.0 |
| 2008-04-25 03:00:00 | ES | Futures | 1294.38 | 1296.47 | 1293.68 | 1294.15 | 9941.0 |
| 2008-04-25 03:30:00 | ES | Futures | 1293.91 | 1296.94 | 1293.21 | 1296.71 | 7596.0 |
| 2008-04-25 04:00:00 | ES | Futures | 1296.71 | 1297.17 | 1295.08 | 1296.24 | 6854.0 |
| 2008-04-25 04:30:00 | ES | Futures | 1296.24 | 1297.41 | 1296.01 | 1296.71 | 5433.0 |
| 2008-04-25 05:00:00 | ES | Futures | 1296.71 | 1297.64 | 1296.24 | 1297.17 | 5380.0 |
| 2008-04-25 05:30:00 | ES | Futures | 1297.17 | 1298.34 | 1296.71 | 1296.94 | 5700.0 |
| 2008-04-25 06:00:00 | ES | Futures | 1296.94 | 1298.1 | 1296.71 | 1297.41 | 5219.0 |
| 2008-04-25 06:30:00 | ES | Futures | 1297.41 | 1298.34 | 1296.47 | 1296.47 | 5364.0 |
| 2008-04-25 07:00:00 | ES | Futures | 1296.47 | 1296.94 | 1294.38 | 1296.71 | 9421.0 |
| 2008-04-25 07:30:00 | ES | Futures | 1296.47 | 1299.97 | 1296.47 | 1299.5 | 13315.0 |
| 2008-04-25 08:00:00 | ES | Futures | 1299.5 | 1299.73 | 1297.17 | 1297.17 | 15814.0 |
| 2008-04-25 08:30:00 | ES | Futures | 1297.17 | 1300.2 | 1297.17 | 1298.57 | 19276.0 |
| 2008-04-25 09:00:00 | ES | Futures | 1298.8 | 1302.06 | 1298.34 | 1300.2 | 32362.0 |
| 2008-04-25 09:30:00 | ES | Futures | 1300.2 | 1301.13 | 1294.84 | 1295.08 | 151347.0 |
| 2008-04-25 10:00:00 | ES | Futures | 1295.31 | 1297.41 | 1292.28 | 1296.24 | 147841.0 |
| 2008-04-25 10:30:00 | ES | Futures | 1296.01 | 1298.1 | 1292.05 | 1295.31 | 140559.0 |
| 2008-04-25 11:00:00 | ES | Futures | 1295.31 | 1296.24 | 1285.76 | 1288.32 | 169618.0 |
| 2008-04-25 11:30:00 | ES | Futures | 1288.56 | 1292.98 | 1288.32 | 1292.28 | 101141.0 |
| 2008-04-25 12:00:00 | ES | Futures | 1292.28 | 1293.91 | 1290.65 | 1292.05 | 44953.0 |
| 2008-04-25 12:30:00 | ES | Futures | 1292.05 | 1294.15 | 1290.19 | 1291.82 | 48700.0 |
| 2008-04-25 13:00:00 | ES | Futures | 1291.58 | 1292.98 | 1290.19 | 1291.12 | 34567.0 |
| 2008-04-25 13:30:00 | ES | Futures | 1291.35 | 1295.31 | 1289.26 | 1295.08 | 54136.0 |
| 2008-04-25 14:00:00 | ES | Futures | 1294.84 | 1296.47 | 1294.15 | 1295.78 | 58773.0 |
| 2008-04-25 14:30:00 | ES | Futures | 1295.78 | 1297.64 | 1294.84 | 1297.41 | 53602.0 |
| 2008-04-25 15:00:00 | ES | Futures | 1297.41 | 1304.62 | 1296.71 | 1302.53 | 163179.0 |
| 2008-04-25 15:30:00 | ES | Futures | 1302.53 | 1304.16 | 1299.73 | 1303.23 | 153870.0 |
| 2008-04-25 16:00:00 | ES | Futures | 1303.23 | 1303.92 | 1300.66 | 1301.6 | 72101.0 |
| 2008-04-25 00:00:00 | NQ | Futures | 2169.86 | 2171.56 | 2168.45 | 2169.86 | 169.0 |
| 2008-04-25 00:30:00 | NQ | Futures | 2169.58 | 2169.58 | 2167.03 | 2168.45 | 219.0 |
| 2008-04-25 01:00:00 | NQ | Futures | 2167.03 | 2169.01 | 2167.03 | 2169.01 | 51.0 |
| 2008-04-25 01:30:00 | NQ | Futures | 2168.73 | 2173.26 | 2168.73 | 2173.26 | 421.0 |
| 2008-04-25 02:00:00 | NQ | Futures | 2173.26 | 2176.37 | 2172.12 | 2176.08 | 331.0 |
| 2008-04-25 02:30:00 | NQ | Futures | 2176.08 | 2176.37 | 2174.39 | 2176.08 | 170.0 |
| 2008-04-25 03:00:00 | NQ | Futures | 2176.37 | 2178.06 | 2174.67 | 2174.67 | 644.0 |
| 2008-04-25 03:30:00 | NQ | Futures | 2174.67 | 2181.74 | 2173.54 | 2180.61 | 1084.0 |
| 2008-04-25 04:00:00 | NQ | Futures | 2180.89 | 2182.02 | 2178.06 | 2179.76 | 808.0 |
| 2008-04-25 04:30:00 | NQ | Futures | 2179.76 | 2181.46 | 2178.35 | 2181.17 | 369.0 |
| 2008-04-25 05:00:00 | NQ | Futures | 2180.89 | 2182.59 | 2179.48 | 2181.46 | 360.0 |
| 2008-04-25 05:30:00 | NQ | Futures | 2181.46 | 2183.44 | 2180.04 | 2180.61 | 405.0 |
| 2008-04-25 06:00:00 | NQ | Futures | 2180.89 | 2182.31 | 2180.04 | 2181.46 | 286.0 |
| 2008-04-25 06:30:00 | NQ | Futures | 2181.74 | 2183.44 | 2180.61 | 2181.17 | 441.0 |
| 2008-04-25 07:00:00 | NQ | Futures | 2181.17 | 2181.74 | 2177.78 | 2180.89 | 809.0 |
| 2008-04-25 07:30:00 | NQ | Futures | 2180.61 | 2187.68 | 2179.48 | 2187.11 | 1680.0 |
| 2008-04-25 08:00:00 | NQ | Futures | 2186.55 | 2186.55 | 2181.74 | 2182.02 | 1752.0 |
> showing 50 of 1,856 rows — these rows as CSV