PREVIEW / futures_1hour / 2008-05-12
file: by_date/futures_1hour/2008/2008-05-12.parquet size: 42 KB rows: 1,212
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-05-12 00:00:00 | ES | Futures | 1296.71 | 1296.94 | 1296.01 | 1296.71 | 321.0 |
| 2008-05-12 01:00:00 | ES | Futures | 1296.94 | 1297.17 | 1296.01 | 1296.47 | 485.0 |
| 2008-05-12 02:00:00 | ES | Futures | 1296.47 | 1296.71 | 1296.01 | 1296.24 | 2215.0 |
| 2008-05-12 03:00:00 | ES | Futures | 1296.47 | 1298.34 | 1296.24 | 1297.87 | 11745.0 |
| 2008-05-12 04:00:00 | ES | Futures | 1298.1 | 1298.57 | 1297.41 | 1298.34 | 3747.0 |
| 2008-05-12 05:00:00 | ES | Futures | 1298.34 | 1298.57 | 1295.78 | 1296.01 | 6585.0 |
| 2008-05-12 06:00:00 | ES | Futures | 1295.78 | 1296.94 | 1294.84 | 1296.71 | 6955.0 |
| 2008-05-12 07:00:00 | ES | Futures | 1296.71 | 1298.8 | 1296.47 | 1296.94 | 12842.0 |
| 2008-05-12 08:00:00 | ES | Futures | 1296.94 | 1297.17 | 1294.15 | 1295.31 | 30015.0 |
| 2008-05-12 09:00:00 | ES | Futures | 1295.08 | 1297.41 | 1292.98 | 1293.68 | 159975.0 |
| 2008-05-12 10:00:00 | ES | Futures | 1293.91 | 1299.97 | 1291.12 | 1298.8 | 299430.0 |
| 2008-05-12 11:00:00 | ES | Futures | 1298.8 | 1302.29 | 1297.87 | 1302.06 | 201804.0 |
| 2008-05-12 12:00:00 | ES | Futures | 1302.06 | 1304.39 | 1301.13 | 1302.76 | 146735.0 |
| 2008-05-12 13:00:00 | ES | Futures | 1302.76 | 1302.99 | 1299.27 | 1301.13 | 145834.0 |
| 2008-05-12 14:00:00 | ES | Futures | 1301.13 | 1308.35 | 1300.2 | 1306.72 | 216870.0 |
| 2008-05-12 15:00:00 | ES | Futures | 1306.72 | 1308.35 | 1305.09 | 1307.88 | 237947.0 |
| 2008-05-12 16:00:00 | ES | Futures | 1307.65 | 1308.58 | 1306.95 | 1308.12 | 78665.0 |
| 2008-05-12 17:00:00 | ES | Futures | 1307.88 | 1308.12 | 1306.72 | 1307.65 | 1758.0 |
| 2008-05-12 18:00:00 | ES | Futures | 1307.42 | 1307.88 | 1307.18 | 1307.65 | 765.0 |
| 2008-05-12 19:00:00 | ES | Futures | 1307.88 | 1309.28 | 1307.65 | 1308.35 | 1604.0 |
| 2008-05-12 20:00:00 | ES | Futures | 1308.58 | 1309.98 | 1307.18 | 1309.51 | 2896.0 |
| 2008-05-12 21:00:00 | ES | Futures | 1309.75 | 1309.98 | 1308.12 | 1308.35 | 2243.0 |
| 2008-05-12 22:00:00 | ES | Futures | 1308.58 | 1309.51 | 1307.18 | 1307.88 | 1435.0 |
| 2008-05-12 23:00:00 | ES | Futures | 1308.12 | 1309.05 | 1307.88 | 1308.58 | 597.0 |
| 2008-05-12 00:00:00 | NQ | Futures | 2226.43 | 2226.99 | 2225.58 | 2226.43 | 48.0 |
| 2008-05-12 01:00:00 | NQ | Futures | 2226.43 | 2227.28 | 2225.58 | 2225.86 | 59.0 |
| 2008-05-12 02:00:00 | NQ | Futures | 2225.86 | 2226.71 | 2225.01 | 2225.58 | 98.0 |
| 2008-05-12 03:00:00 | NQ | Futures | 2226.43 | 2229.54 | 2226.43 | 2228.69 | 399.0 |
| 2008-05-12 04:00:00 | NQ | Futures | 2228.12 | 2229.54 | 2228.12 | 2228.97 | 239.0 |
| 2008-05-12 05:00:00 | NQ | Futures | 2229.26 | 2229.82 | 2222.75 | 2223.6 | 708.0 |
| 2008-05-12 06:00:00 | NQ | Futures | 2223.88 | 2224.45 | 2221.9 | 2223.88 | 345.0 |
| 2008-05-12 07:00:00 | NQ | Futures | 2224.16 | 2228.41 | 2224.16 | 2225.3 | 627.0 |
| 2008-05-12 08:00:00 | NQ | Futures | 2224.73 | 2225.86 | 2221.62 | 2223.6 | 2453.0 |
| 2008-05-12 09:00:00 | NQ | Futures | 2223.03 | 2229.26 | 2221.9 | 2225.58 | 27670.0 |
| 2008-05-12 10:00:00 | NQ | Futures | 2225.86 | 2241.42 | 2220.49 | 2238.59 | 55204.0 |
| 2008-05-12 11:00:00 | NQ | Futures | 2238.87 | 2249.62 | 2235.48 | 2248.2 | 37946.0 |
| 2008-05-12 12:00:00 | NQ | Futures | 2248.2 | 2254.43 | 2246.51 | 2252.45 | 25694.0 |
| 2008-05-12 13:00:00 | NQ | Futures | 2252.45 | 2253.01 | 2243.68 | 2248.2 | 22296.0 |
| 2008-05-12 14:00:00 | NQ | Futures | 2248.49 | 2266.59 | 2247.64 | 2262.91 | 49586.0 |
| 2008-05-12 15:00:00 | NQ | Futures | 2262.63 | 2265.46 | 2259.24 | 2262.63 | 43435.0 |
| 2008-05-12 16:00:00 | NQ | Futures | 2262.35 | 2264.61 | 2258.67 | 2261.5 | 13997.0 |
| 2008-05-12 17:00:00 | NQ | Futures | 2261.5 | 2262.06 | 2259.52 | 2260.93 | 130.0 |
| 2008-05-12 18:00:00 | NQ | Futures | 2261.21 | 2262.06 | 2259.8 | 2260.37 | 122.0 |
| 2008-05-12 19:00:00 | NQ | Futures | 2261.21 | 2262.91 | 2260.37 | 2262.35 | 144.0 |
| 2008-05-12 20:00:00 | NQ | Futures | 2262.35 | 2263.76 | 2259.24 | 2263.76 | 99.0 |
| 2008-05-12 21:00:00 | NQ | Futures | 2263.19 | 2264.61 | 2260.93 | 2261.5 | 164.0 |
| 2008-05-12 22:00:00 | NQ | Futures | 2261.78 | 2263.19 | 2260.37 | 2261.78 | 224.0 |
| 2008-05-12 23:00:00 | NQ | Futures | 2262.35 | 2262.63 | 2260.93 | 2260.93 | 21.0 |
| 2008-05-12 00:00:00 | YM | Futures | 11603.5 | 11606.2 | 11600.8 | 11604.4 | 79.0 |
| 2008-05-12 01:00:00 | YM | Futures | 11605.3 | 11607.1 | 11600.8 | 11603.5 | 79.0 |
> showing 50 of 1,212 rows — these rows as CSV