PREVIEW / futures_1hour / 2010-12-22
file: by_date/futures_1hour/2010/2010-12-22.parquet size: 45 KB rows: 1,406
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-22 00:00:00 | ES | Futures | 1236.89 | 1237.14 | 1236.15 | 1236.64 | 2067.0 |
| 2010-12-22 01:00:00 | ES | Futures | 1236.39 | 1236.89 | 1236.15 | 1236.64 | 1032.0 |
| 2010-12-22 02:00:00 | ES | Futures | 1236.64 | 1237.88 | 1236.64 | 1237.38 | 3267.0 |
| 2010-12-22 03:00:00 | ES | Futures | 1237.63 | 1238.13 | 1236.39 | 1236.89 | 7850.0 |
| 2010-12-22 04:00:00 | ES | Futures | 1236.89 | 1237.88 | 1236.39 | 1237.38 | 6739.0 |
| 2010-12-22 05:00:00 | ES | Futures | 1237.38 | 1238.13 | 1237.38 | 1237.88 | 5101.0 |
| 2010-12-22 06:00:00 | ES | Futures | 1237.63 | 1238.37 | 1237.38 | 1237.63 | 6594.0 |
| 2010-12-22 07:00:00 | ES | Futures | 1237.63 | 1238.37 | 1237.63 | 1237.88 | 8978.0 |
| 2010-12-22 08:00:00 | ES | Futures | 1237.88 | 1239.36 | 1237.14 | 1237.88 | 30260.0 |
| 2010-12-22 09:00:00 | ES | Futures | 1237.88 | 1239.11 | 1237.63 | 1238.62 | 98244.0 |
| 2010-12-22 10:00:00 | ES | Futures | 1238.62 | 1239.86 | 1237.88 | 1239.86 | 110564.0 |
| 2010-12-22 11:00:00 | ES | Futures | 1239.86 | 1240.6 | 1239.11 | 1240.35 | 55285.0 |
| 2010-12-22 12:00:00 | ES | Futures | 1240.1 | 1241.84 | 1240.1 | 1241.34 | 57129.0 |
| 2010-12-22 13:00:00 | ES | Futures | 1241.34 | 1241.34 | 1238.87 | 1239.61 | 56636.0 |
| 2010-12-22 14:00:00 | ES | Futures | 1239.61 | 1240.35 | 1239.36 | 1240.1 | 39593.0 |
| 2010-12-22 15:00:00 | ES | Futures | 1240.35 | 1241.84 | 1239.86 | 1241.34 | 93332.0 |
| 2010-12-22 16:00:00 | ES | Futures | 1241.34 | 1242.08 | 1240.85 | 1241.59 | 65495.0 |
| 2010-12-22 17:00:00 | ES | Futures | 1241.59 | 1241.59 | 1241.34 | 1241.34 | 581.0 |
| 2010-12-22 18:00:00 | ES | Futures | 1241.34 | 1241.59 | 1240.85 | 1241.34 | 1521.0 |
| 2010-12-22 19:00:00 | ES | Futures | 1241.34 | 1241.59 | 1240.85 | 1241.09 | 964.0 |
| 2010-12-22 20:00:00 | ES | Futures | 1241.09 | 1242.33 | 1240.85 | 1242.33 | 2964.0 |
| 2010-12-22 21:00:00 | ES | Futures | 1242.33 | 1242.58 | 1241.34 | 1242.08 | 4770.0 |
| 2010-12-22 22:00:00 | ES | Futures | 1242.08 | 1242.33 | 1241.84 | 1242.33 | 2680.0 |
| 2010-12-22 23:00:00 | ES | Futures | 1242.33 | 1242.58 | 1241.84 | 1242.58 | 2042.0 |
| 2010-12-22 00:00:00 | NQ | Futures | 2562.91 | 2562.91 | 2561.48 | 2561.76 | 114.0 |
| 2010-12-22 01:00:00 | NQ | Futures | 2561.76 | 2562.34 | 2561.48 | 2561.76 | 116.0 |
| 2010-12-22 02:00:00 | NQ | Futures | 2562.05 | 2564.06 | 2561.48 | 2563.49 | 284.0 |
| 2010-12-22 03:00:00 | NQ | Futures | 2563.2 | 2564.63 | 2562.05 | 2562.63 | 731.0 |
| 2010-12-22 04:00:00 | NQ | Futures | 2562.63 | 2563.77 | 2561.76 | 2563.49 | 633.0 |
| 2010-12-22 05:00:00 | NQ | Futures | 2563.49 | 2564.63 | 2562.91 | 2563.77 | 582.0 |
| 2010-12-22 06:00:00 | NQ | Futures | 2563.77 | 2564.63 | 2563.49 | 2563.77 | 915.0 |
| 2010-12-22 07:00:00 | NQ | Futures | 2563.77 | 2565.21 | 2563.77 | 2564.63 | 762.0 |
| 2010-12-22 08:00:00 | NQ | Futures | 2564.63 | 2566.64 | 2562.63 | 2563.49 | 3644.0 |
| 2010-12-22 09:00:00 | NQ | Futures | 2563.49 | 2567.22 | 2562.34 | 2564.06 | 15057.0 |
| 2010-12-22 10:00:00 | NQ | Futures | 2564.06 | 2565.5 | 2561.48 | 2564.63 | 14292.0 |
| 2010-12-22 11:00:00 | NQ | Futures | 2564.63 | 2569.23 | 2564.35 | 2566.64 | 9300.0 |
| 2010-12-22 12:00:00 | NQ | Futures | 2566.64 | 2569.51 | 2564.06 | 2565.5 | 8664.0 |
| 2010-12-22 13:00:00 | NQ | Futures | 2565.5 | 2566.64 | 2562.05 | 2562.91 | 6709.0 |
| 2010-12-22 14:00:00 | NQ | Futures | 2562.91 | 2565.78 | 2562.91 | 2565.5 | 5737.0 |
| 2010-12-22 15:00:00 | NQ | Futures | 2565.5 | 2568.37 | 2564.35 | 2565.5 | 14262.0 |
| 2010-12-22 16:00:00 | NQ | Futures | 2565.5 | 2569.8 | 2565.21 | 2567.51 | 5449.0 |
| 2010-12-22 17:00:00 | NQ | Futures | 2567.22 | 2567.79 | 2566.93 | 2567.22 | 83.0 |
| 2010-12-22 18:00:00 | NQ | Futures | 2567.51 | 2568.37 | 2566.93 | 2567.79 | 43.0 |
| 2010-12-22 19:00:00 | NQ | Futures | 2568.08 | 2568.37 | 2566.64 | 2566.64 | 174.0 |
| 2010-12-22 20:00:00 | NQ | Futures | 2566.93 | 2569.8 | 2566.93 | 2569.8 | 285.0 |
| 2010-12-22 21:00:00 | NQ | Futures | 2570.09 | 2570.66 | 2568.37 | 2569.8 | 151.0 |
| 2010-12-22 22:00:00 | NQ | Futures | 2569.51 | 2570.09 | 2568.65 | 2569.51 | 52.0 |
| 2010-12-22 23:00:00 | NQ | Futures | 2569.51 | 2570.38 | 2569.51 | 2569.51 | 108.0 |
| 2010-12-22 00:00:00 | YM | Futures | 10984.8 | 10986.7 | 10974.3 | 10976.2 | 226.0 |
| 2010-12-22 01:00:00 | YM | Futures | 10975.2 | 10981.0 | 10974.3 | 10978.1 | 107.0 |
> showing 50 of 1,406 rows — these rows as CSV