PREVIEW / futures_1hour / 2008-05-14
file: by_date/futures_1hour/2008/2008-05-14.parquet size: 41 KB rows: 1,221
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-14 00:00:00 | ES | Futures | 1306.02 | 1306.72 | 1305.79 | 1306.72 | 467.0 |
| 2008-05-14 01:00:00 | ES | Futures | 1306.49 | 1307.42 | 1306.25 | 1307.42 | 688.0 |
| 2008-05-14 02:00:00 | ES | Futures | 1307.42 | 1309.51 | 1306.49 | 1309.28 | 4597.0 |
| 2008-05-14 03:00:00 | ES | Futures | 1309.28 | 1310.91 | 1308.58 | 1308.81 | 11527.0 |
| 2008-05-14 04:00:00 | ES | Futures | 1308.81 | 1310.21 | 1308.58 | 1309.51 | 4910.0 |
| 2008-05-14 05:00:00 | ES | Futures | 1309.51 | 1309.98 | 1307.42 | 1307.88 | 10104.0 |
| 2008-05-14 06:00:00 | ES | Futures | 1307.65 | 1307.88 | 1305.09 | 1307.65 | 11888.0 |
| 2008-05-14 07:00:00 | ES | Futures | 1307.42 | 1307.65 | 1302.76 | 1306.25 | 26153.0 |
| 2008-05-14 08:00:00 | ES | Futures | 1306.49 | 1315.33 | 1305.32 | 1313.7 | 97092.0 |
| 2008-05-14 09:00:00 | ES | Futures | 1313.94 | 1318.83 | 1312.54 | 1317.2 | 242685.0 |
| 2008-05-14 10:00:00 | ES | Futures | 1316.96 | 1320.22 | 1315.8 | 1318.13 | 270339.0 |
| 2008-05-14 11:00:00 | ES | Futures | 1318.36 | 1319.99 | 1316.5 | 1318.83 | 161259.0 |
| 2008-05-14 12:00:00 | ES | Futures | 1318.83 | 1320.46 | 1317.9 | 1319.29 | 92676.0 |
| 2008-05-14 13:00:00 | ES | Futures | 1319.53 | 1323.95 | 1319.06 | 1322.32 | 181027.0 |
| 2008-05-14 14:00:00 | ES | Futures | 1322.55 | 1323.25 | 1319.99 | 1320.46 | 151124.0 |
| 2008-05-14 15:00:00 | ES | Futures | 1320.46 | 1320.92 | 1311.14 | 1312.07 | 370572.0 |
| 2008-05-14 16:00:00 | ES | Futures | 1312.31 | 1313.7 | 1308.58 | 1310.21 | 88895.0 |
| 2008-05-14 17:00:00 | ES | Futures | 1310.44 | 1310.91 | 1310.21 | 1310.21 | 966.0 |
| 2008-05-14 18:00:00 | ES | Futures | 1310.21 | 1311.38 | 1309.98 | 1310.91 | 1660.0 |
| 2008-05-14 19:00:00 | ES | Futures | 1310.91 | 1311.61 | 1310.21 | 1310.68 | 655.0 |
| 2008-05-14 20:00:00 | ES | Futures | 1310.68 | 1311.84 | 1310.44 | 1311.61 | 1863.0 |
| 2008-05-14 21:00:00 | ES | Futures | 1311.61 | 1312.07 | 1310.68 | 1310.68 | 1213.0 |
| 2008-05-14 22:00:00 | ES | Futures | 1310.68 | 1311.14 | 1310.21 | 1310.68 | 966.0 |
| 2008-05-14 23:00:00 | ES | Futures | 1310.68 | 1311.38 | 1310.21 | 1311.14 | 897.0 |
| 2008-05-14 00:00:00 | NQ | Futures | 2266.59 | 2267.15 | 2266.31 | 2266.87 | 8.0 |
| 2008-05-14 01:00:00 | NQ | Futures | 2267.15 | 2267.44 | 2266.02 | 2266.02 | 56.0 |
| 2008-05-14 02:00:00 | NQ | Futures | 2266.31 | 2270.27 | 2266.02 | 2270.27 | 315.0 |
| 2008-05-14 03:00:00 | NQ | Futures | 2270.27 | 2272.81 | 2269.98 | 2270.27 | 660.0 |
| 2008-05-14 04:00:00 | NQ | Futures | 2270.55 | 2273.38 | 2269.98 | 2272.53 | 553.0 |
| 2008-05-14 05:00:00 | NQ | Futures | 2272.81 | 2272.81 | 2265.74 | 2267.15 | 868.0 |
| 2008-05-14 06:00:00 | NQ | Futures | 2266.87 | 2268.57 | 2264.89 | 2268.29 | 487.0 |
| 2008-05-14 07:00:00 | NQ | Futures | 2268.29 | 2268.29 | 2262.35 | 2264.89 | 1603.0 |
| 2008-05-14 08:00:00 | NQ | Futures | 2265.17 | 2280.45 | 2264.33 | 2278.18 | 8880.0 |
| 2008-05-14 09:00:00 | NQ | Futures | 2277.9 | 2289.78 | 2274.51 | 2287.8 | 45840.0 |
| 2008-05-14 10:00:00 | NQ | Futures | 2288.08 | 2297.42 | 2285.82 | 2291.76 | 62328.0 |
| 2008-05-14 11:00:00 | NQ | Futures | 2291.76 | 2292.61 | 2284.69 | 2288.65 | 31425.0 |
| 2008-05-14 12:00:00 | NQ | Futures | 2288.65 | 2293.46 | 2285.82 | 2288.65 | 20386.0 |
| 2008-05-14 13:00:00 | NQ | Futures | 2288.65 | 2299.68 | 2288.37 | 2296.85 | 32567.0 |
| 2008-05-14 14:00:00 | NQ | Futures | 2296.85 | 2299.68 | 2287.24 | 2287.8 | 43895.0 |
| 2008-05-14 15:00:00 | NQ | Futures | 2288.08 | 2288.08 | 2258.95 | 2261.5 | 91338.0 |
| 2008-05-14 16:00:00 | NQ | Futures | 2261.5 | 2262.63 | 2257.54 | 2259.8 | 13989.0 |
| 2008-05-14 17:00:00 | NQ | Futures | 2260.08 | 2260.93 | 2259.24 | 2259.52 | 256.0 |
| 2008-05-14 18:00:00 | NQ | Futures | 2260.08 | 2260.37 | 2258.95 | 2258.95 | 160.0 |
| 2008-05-14 19:00:00 | NQ | Futures | 2260.08 | 2260.08 | 2258.39 | 2259.52 | 189.0 |
| 2008-05-14 20:00:00 | NQ | Futures | 2259.24 | 2260.93 | 2258.67 | 2260.93 | 276.0 |
| 2008-05-14 21:00:00 | NQ | Futures | 2260.93 | 2261.78 | 2259.52 | 2259.52 | 113.0 |
| 2008-05-14 22:00:00 | NQ | Futures | 2259.8 | 2260.37 | 2258.95 | 2258.95 | 60.0 |
| 2008-05-14 23:00:00 | NQ | Futures | 2260.08 | 2260.37 | 2258.95 | 2260.37 | 94.0 |
| 2008-05-14 00:00:00 | YM | Futures | 11638.9 | 11643.5 | 11636.2 | 11640.7 | 67.0 |
| 2008-05-14 01:00:00 | YM | Futures | 11639.8 | 11649.8 | 11639.8 | 11647.1 | 155.0 |
> showing 50 of 1,221 rows — these rows as CSV