PREVIEW / futures_1hour / 2010-12-21
file: by_date/futures_1hour/2010/2010-12-21.parquet size: 44 KB rows: 1,416
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-21 00:00:00 | ES | Futures | 1232.19 | 1232.93 | 1232.19 | 1232.43 | 1636.0 |
| 2010-12-21 01:00:00 | ES | Futures | 1232.43 | 1233.92 | 1232.43 | 1233.67 | 3240.0 |
| 2010-12-21 02:00:00 | ES | Futures | 1233.67 | 1234.17 | 1233.42 | 1233.92 | 5556.0 |
| 2010-12-21 03:00:00 | ES | Futures | 1233.67 | 1233.92 | 1232.19 | 1232.93 | 21807.0 |
| 2010-12-21 04:00:00 | ES | Futures | 1232.93 | 1233.42 | 1232.43 | 1233.18 | 6659.0 |
| 2010-12-21 05:00:00 | ES | Futures | 1232.93 | 1233.18 | 1231.94 | 1232.93 | 5625.0 |
| 2010-12-21 06:00:00 | ES | Futures | 1232.93 | 1232.93 | 1231.94 | 1232.93 | 4640.0 |
| 2010-12-21 07:00:00 | ES | Futures | 1232.68 | 1233.18 | 1232.19 | 1232.93 | 7563.0 |
| 2010-12-21 08:00:00 | ES | Futures | 1232.93 | 1234.66 | 1232.68 | 1233.67 | 29318.0 |
| 2010-12-21 09:00:00 | ES | Futures | 1233.92 | 1235.16 | 1232.43 | 1233.92 | 124184.0 |
| 2010-12-21 10:00:00 | ES | Futures | 1233.92 | 1235.9 | 1233.18 | 1235.16 | 170373.0 |
| 2010-12-21 11:00:00 | ES | Futures | 1235.16 | 1236.15 | 1234.41 | 1235.16 | 107090.0 |
| 2010-12-21 12:00:00 | ES | Futures | 1235.16 | 1237.14 | 1235.16 | 1237.14 | 95887.0 |
| 2010-12-21 13:00:00 | ES | Futures | 1237.14 | 1237.14 | 1235.9 | 1236.64 | 63310.0 |
| 2010-12-21 14:00:00 | ES | Futures | 1236.39 | 1236.89 | 1235.9 | 1236.64 | 49117.0 |
| 2010-12-21 15:00:00 | ES | Futures | 1236.64 | 1238.37 | 1236.15 | 1236.89 | 150595.0 |
| 2010-12-21 16:00:00 | ES | Futures | 1236.89 | 1238.13 | 1236.39 | 1237.14 | 72562.0 |
| 2010-12-21 17:00:00 | ES | Futures | 1237.14 | 1237.63 | 1236.89 | 1237.14 | 1679.0 |
| 2010-12-21 18:00:00 | ES | Futures | 1237.63 | 1237.63 | 1236.39 | 1236.64 | 3280.0 |
| 2010-12-21 19:00:00 | ES | Futures | 1236.39 | 1237.38 | 1236.15 | 1236.89 | 1763.0 |
| 2010-12-21 20:00:00 | ES | Futures | 1237.14 | 1237.38 | 1236.15 | 1236.64 | 1571.0 |
| 2010-12-21 21:00:00 | ES | Futures | 1236.39 | 1237.14 | 1236.39 | 1236.64 | 1588.0 |
| 2010-12-21 22:00:00 | ES | Futures | 1236.64 | 1237.38 | 1236.39 | 1236.89 | 1279.0 |
| 2010-12-21 23:00:00 | ES | Futures | 1236.64 | 1237.14 | 1236.39 | 1236.89 | 1188.0 |
| 2010-12-21 00:00:00 | NQ | Futures | 2556.6 | 2557.17 | 2556.02 | 2556.02 | 46.0 |
| 2010-12-21 01:00:00 | NQ | Futures | 2556.6 | 2558.89 | 2556.31 | 2558.61 | 127.0 |
| 2010-12-21 02:00:00 | NQ | Futures | 2558.61 | 2559.47 | 2558.03 | 2558.89 | 301.0 |
| 2010-12-21 03:00:00 | NQ | Futures | 2558.89 | 2559.18 | 2554.3 | 2556.02 | 2322.0 |
| 2010-12-21 04:00:00 | NQ | Futures | 2556.31 | 2556.89 | 2554.3 | 2556.02 | 870.0 |
| 2010-12-21 05:00:00 | NQ | Futures | 2555.74 | 2556.6 | 2554.88 | 2556.02 | 383.0 |
| 2010-12-21 06:00:00 | NQ | Futures | 2556.31 | 2556.6 | 2554.3 | 2555.45 | 447.0 |
| 2010-12-21 07:00:00 | NQ | Futures | 2555.16 | 2556.89 | 2554.59 | 2556.89 | 758.0 |
| 2010-12-21 08:00:00 | NQ | Futures | 2556.89 | 2560.04 | 2556.31 | 2558.03 | 2328.0 |
| 2010-12-21 09:00:00 | NQ | Futures | 2557.75 | 2562.91 | 2553.73 | 2558.32 | 18342.0 |
| 2010-12-21 10:00:00 | NQ | Futures | 2558.32 | 2562.63 | 2557.46 | 2561.19 | 14110.0 |
| 2010-12-21 11:00:00 | NQ | Futures | 2561.48 | 2562.91 | 2559.76 | 2560.9 | 9840.0 |
| 2010-12-21 12:00:00 | NQ | Futures | 2560.9 | 2565.5 | 2560.9 | 2564.92 | 10141.0 |
| 2010-12-21 13:00:00 | NQ | Futures | 2565.21 | 2565.78 | 2563.2 | 2564.35 | 7896.0 |
| 2010-12-21 14:00:00 | NQ | Futures | 2564.35 | 2565.21 | 2562.91 | 2563.49 | 8192.0 |
| 2010-12-21 15:00:00 | NQ | Futures | 2563.77 | 2565.78 | 2562.05 | 2565.5 | 18803.0 |
| 2010-12-21 16:00:00 | NQ | Futures | 2565.5 | 2568.37 | 2560.62 | 2562.34 | 8306.0 |
| 2010-12-21 17:00:00 | NQ | Futures | 2562.63 | 2563.49 | 2561.76 | 2563.49 | 129.0 |
| 2010-12-21 18:00:00 | NQ | Futures | 2562.63 | 2562.63 | 2561.19 | 2561.19 | 245.0 |
| 2010-12-21 19:00:00 | NQ | Futures | 2561.48 | 2563.77 | 2561.48 | 2563.2 | 142.0 |
| 2010-12-21 20:00:00 | NQ | Futures | 2563.2 | 2563.2 | 2561.76 | 2562.05 | 139.0 |
| 2010-12-21 21:00:00 | NQ | Futures | 2562.05 | 2563.49 | 2562.05 | 2562.63 | 101.0 |
| 2010-12-21 22:00:00 | NQ | Futures | 2562.34 | 2564.06 | 2561.76 | 2562.63 | 97.0 |
| 2010-12-21 23:00:00 | NQ | Futures | 2562.91 | 2563.2 | 2562.05 | 2562.91 | 47.0 |
| 2010-12-21 00:00:00 | YM | Futures | 10954.2 | 10960.9 | 10954.2 | 10959.9 | 91.0 |
| 2010-12-21 01:00:00 | YM | Futures | 10959.9 | 10965.7 | 10959.9 | 10965.7 | 257.0 |
> showing 50 of 1,416 rows — these rows as CSV