PREVIEW / futures_1hour / 2010-12-27
file: by_date/futures_1hour/2010/2010-12-27.parquet size: 42 KB rows: 1,287
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-27 00:00:00 | ES | Futures | 1237.63 | 1237.88 | 1237.14 | 1237.63 | 1071.0 |
| 2010-12-27 01:00:00 | ES | Futures | 1237.38 | 1237.88 | 1236.64 | 1237.63 | 1537.0 |
| 2010-12-27 02:00:00 | ES | Futures | 1237.63 | 1238.13 | 1236.64 | 1237.38 | 2975.0 |
| 2010-12-27 03:00:00 | ES | Futures | 1237.38 | 1237.38 | 1232.68 | 1234.66 | 21530.0 |
| 2010-12-27 04:00:00 | ES | Futures | 1234.66 | 1235.16 | 1234.17 | 1234.91 | 2819.0 |
| 2010-12-27 05:00:00 | ES | Futures | 1234.91 | 1235.4 | 1234.41 | 1235.4 | 2036.0 |
| 2010-12-27 06:00:00 | ES | Futures | 1235.4 | 1237.14 | 1235.16 | 1235.65 | 6441.0 |
| 2010-12-27 07:00:00 | ES | Futures | 1235.65 | 1236.15 | 1233.67 | 1233.92 | 6688.0 |
| 2010-12-27 08:00:00 | ES | Futures | 1234.17 | 1235.4 | 1233.92 | 1235.16 | 9404.0 |
| 2010-12-27 09:00:00 | ES | Futures | 1235.16 | 1236.15 | 1234.17 | 1235.65 | 74030.0 |
| 2010-12-27 10:00:00 | ES | Futures | 1235.65 | 1238.13 | 1235.16 | 1237.14 | 80727.0 |
| 2010-12-27 11:00:00 | ES | Futures | 1237.38 | 1237.88 | 1236.89 | 1237.63 | 63857.0 |
| 2010-12-27 12:00:00 | ES | Futures | 1237.38 | 1238.62 | 1237.38 | 1238.13 | 31587.0 |
| 2010-12-27 13:00:00 | ES | Futures | 1238.37 | 1240.85 | 1238.13 | 1240.6 | 90113.0 |
| 2010-12-27 14:00:00 | ES | Futures | 1240.85 | 1241.09 | 1239.86 | 1240.1 | 35840.0 |
| 2010-12-27 15:00:00 | ES | Futures | 1240.1 | 1241.34 | 1239.86 | 1240.1 | 70242.0 |
| 2010-12-27 16:00:00 | ES | Futures | 1240.1 | 1240.85 | 1239.86 | 1240.35 | 54073.0 |
| 2010-12-27 17:00:00 | ES | Futures | 1240.35 | 1240.85 | 1240.35 | 1240.6 | 376.0 |
| 2010-12-27 18:00:00 | ES | Futures | 1240.6 | 1240.85 | 1240.35 | 1240.85 | 1326.0 |
| 2010-12-27 19:00:00 | ES | Futures | 1240.85 | 1241.59 | 1240.6 | 1241.09 | 2161.0 |
| 2010-12-27 20:00:00 | ES | Futures | 1241.34 | 1241.84 | 1241.09 | 1241.34 | 2080.0 |
| 2010-12-27 21:00:00 | ES | Futures | 1241.59 | 1241.84 | 1241.09 | 1241.59 | 1125.0 |
| 2010-12-27 22:00:00 | ES | Futures | 1241.34 | 1241.59 | 1241.09 | 1241.59 | 705.0 |
| 2010-12-27 23:00:00 | ES | Futures | 1241.59 | 1241.59 | 1241.09 | 1241.34 | 769.0 |
| 2010-12-27 00:00:00 | NQ | Futures | 2557.75 | 2558.32 | 2557.75 | 2558.03 | 54.0 |
| 2010-12-27 01:00:00 | NQ | Futures | 2558.32 | 2558.61 | 2556.31 | 2558.03 | 155.0 |
| 2010-12-27 02:00:00 | NQ | Futures | 2557.75 | 2558.32 | 2556.6 | 2557.46 | 238.0 |
| 2010-12-27 03:00:00 | NQ | Futures | 2557.17 | 2557.17 | 2548.85 | 2552.01 | 2247.0 |
| 2010-12-27 04:00:00 | NQ | Futures | 2551.14 | 2552.87 | 2550.86 | 2552.01 | 430.0 |
| 2010-12-27 05:00:00 | NQ | Futures | 2552.01 | 2553.73 | 2551.43 | 2553.73 | 178.0 |
| 2010-12-27 06:00:00 | NQ | Futures | 2553.44 | 2560.04 | 2553.44 | 2556.89 | 1779.0 |
| 2010-12-27 07:00:00 | NQ | Futures | 2556.6 | 2557.17 | 2551.43 | 2552.29 | 1395.0 |
| 2010-12-27 08:00:00 | NQ | Futures | 2552.29 | 2554.3 | 2552.29 | 2553.15 | 1083.0 |
| 2010-12-27 09:00:00 | NQ | Futures | 2553.44 | 2554.88 | 2534.21 | 2535.36 | 32966.0 |
| 2010-12-27 10:00:00 | NQ | Futures | 2535.36 | 2543.97 | 2534.78 | 2541.1 | 19261.0 |
| 2010-12-27 11:00:00 | NQ | Futures | 2540.81 | 2544.26 | 2540.81 | 2543.97 | 10144.0 |
| 2010-12-27 12:00:00 | NQ | Futures | 2543.97 | 2549.14 | 2543.39 | 2548.56 | 11867.0 |
| 2010-12-27 13:00:00 | NQ | Futures | 2548.85 | 2564.92 | 2548.27 | 2563.2 | 28369.0 |
| 2010-12-27 14:00:00 | NQ | Futures | 2563.2 | 2563.49 | 2561.48 | 2562.34 | 7482.0 |
| 2010-12-27 15:00:00 | NQ | Futures | 2562.34 | 2563.77 | 2560.04 | 2560.04 | 12599.0 |
| 2010-12-27 16:00:00 | NQ | Futures | 2560.04 | 2561.76 | 2558.89 | 2560.62 | 6081.0 |
| 2010-12-27 17:00:00 | NQ | Futures | 2560.33 | 2560.62 | 2559.76 | 2559.76 | 55.0 |
| 2010-12-27 18:00:00 | NQ | Futures | 2560.33 | 2566.07 | 2559.76 | 2563.2 | 355.0 |
| 2010-12-27 19:00:00 | NQ | Futures | 2562.91 | 2564.06 | 2562.91 | 2563.77 | 200.0 |
| 2010-12-27 20:00:00 | NQ | Futures | 2563.49 | 2565.21 | 2563.2 | 2563.49 | 226.0 |
| 2010-12-27 21:00:00 | NQ | Futures | 2563.49 | 2564.35 | 2563.2 | 2563.49 | 90.0 |
| 2010-12-27 22:00:00 | NQ | Futures | 2563.77 | 2565.5 | 2563.2 | 2564.06 | 173.0 |
| 2010-12-27 23:00:00 | NQ | Futures | 2564.06 | 2564.35 | 2563.49 | 2564.06 | 44.0 |
| 2010-12-27 00:00:00 | YM | Futures | 11011.6 | 11015.5 | 11011.6 | 11014.5 | 82.0 |
| 2010-12-27 01:00:00 | YM | Futures | 11014.5 | 11019.3 | 11008.8 | 11016.4 | 284.0 |
> showing 50 of 1,287 rows — these rows as CSV