PREVIEW / futures_1hour / 2017-11-22
file: by_date/futures_1hour/2017/2017-11-22.parquet size: 53 KB rows: 1,626
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 |
|---|---|---|---|---|---|---|---|
| 2017-11-22 00:00:00 | ES | Futures | 2841.73 | 2842.27 | 2841.18 | 2841.18 | 1665.0 |
| 2017-11-22 01:00:00 | ES | Futures | 2841.18 | 2843.37 | 2841.18 | 2843.09 | 4200.0 |
| 2017-11-22 02:00:00 | ES | Futures | 2842.82 | 2843.64 | 2841.18 | 2842.27 | 10654.0 |
| 2017-11-22 03:00:00 | ES | Futures | 2842.27 | 2843.37 | 2841.45 | 2842.0 | 17698.0 |
| 2017-11-22 04:00:00 | ES | Futures | 2841.73 | 2842.55 | 2840.91 | 2842.0 | 10726.0 |
| 2017-11-22 05:00:00 | ES | Futures | 2842.27 | 2842.82 | 2840.63 | 2841.73 | 10931.0 |
| 2017-11-22 06:00:00 | ES | Futures | 2841.45 | 2842.55 | 2841.18 | 2842.27 | 10274.0 |
| 2017-11-22 07:00:00 | ES | Futures | 2842.0 | 2845.01 | 2842.0 | 2844.74 | 19165.0 |
| 2017-11-22 08:00:00 | ES | Futures | 2844.74 | 2845.01 | 2841.73 | 2842.82 | 22340.0 |
| 2017-11-22 09:00:00 | ES | Futures | 2842.82 | 2844.74 | 2841.73 | 2842.55 | 109054.0 |
| 2017-11-22 10:00:00 | ES | Futures | 2842.55 | 2843.37 | 2839.26 | 2842.27 | 112025.0 |
| 2017-11-22 11:00:00 | ES | Futures | 2842.55 | 2842.82 | 2839.26 | 2840.36 | 82465.0 |
| 2017-11-22 12:00:00 | ES | Futures | 2840.09 | 2840.63 | 2838.44 | 2840.36 | 48125.0 |
| 2017-11-22 13:00:00 | ES | Futures | 2840.09 | 2840.91 | 2838.17 | 2840.63 | 41107.0 |
| 2017-11-22 14:00:00 | ES | Futures | 2840.36 | 2842.55 | 2840.36 | 2841.45 | 53765.0 |
| 2017-11-22 15:00:00 | ES | Futures | 2841.18 | 2842.55 | 2839.81 | 2840.09 | 94965.0 |
| 2017-11-22 16:00:00 | ES | Futures | 2840.36 | 2840.36 | 2837.08 | 2837.9 | 55210.0 |
| 2017-11-22 18:00:00 | ES | Futures | 2837.62 | 2838.99 | 2837.35 | 2838.72 | 2527.0 |
| 2017-11-22 19:00:00 | ES | Futures | 2838.72 | 2838.99 | 2837.9 | 2838.72 | 1498.0 |
| 2017-11-22 20:00:00 | ES | Futures | 2838.72 | 2838.99 | 2837.35 | 2838.44 | 2777.0 |
| 2017-11-22 21:00:00 | ES | Futures | 2838.44 | 2838.72 | 2837.62 | 2838.17 | 1827.0 |
| 2017-11-22 22:00:00 | ES | Futures | 2838.17 | 2838.44 | 2837.9 | 2838.44 | 1459.0 |
| 2017-11-22 23:00:00 | ES | Futures | 2838.17 | 2839.26 | 2838.17 | 2838.99 | 1069.0 |
| 2017-11-22 00:00:00 | NQ | Futures | 7593.34 | 7594.53 | 7592.15 | 7593.04 | 738.0 |
| 2017-11-22 01:00:00 | NQ | Futures | 7592.74 | 7596.02 | 7591.85 | 7595.42 | 880.0 |
| 2017-11-22 02:00:00 | NQ | Futures | 7595.42 | 7596.91 | 7591.26 | 7593.64 | 1527.0 |
| 2017-11-22 03:00:00 | NQ | Futures | 7593.64 | 7595.42 | 7590.66 | 7590.96 | 2382.0 |
| 2017-11-22 04:00:00 | NQ | Futures | 7590.96 | 7591.85 | 7586.8 | 7590.07 | 2303.0 |
| 2017-11-22 05:00:00 | NQ | Futures | 7590.37 | 7592.15 | 7585.01 | 7587.69 | 1940.0 |
| 2017-11-22 06:00:00 | NQ | Futures | 7587.99 | 7594.23 | 7585.9 | 7593.04 | 2257.0 |
| 2017-11-22 07:00:00 | NQ | Futures | 7593.64 | 7605.53 | 7593.64 | 7604.94 | 4639.0 |
| 2017-11-22 08:00:00 | NQ | Futures | 7604.64 | 7604.94 | 7593.93 | 7596.91 | 5476.0 |
| 2017-11-22 09:00:00 | NQ | Futures | 7596.91 | 7605.24 | 7584.42 | 7591.55 | 38653.0 |
| 2017-11-22 10:00:00 | NQ | Futures | 7591.55 | 7599.29 | 7585.31 | 7595.72 | 33376.0 |
| 2017-11-22 11:00:00 | NQ | Futures | 7596.02 | 7601.07 | 7586.8 | 7595.12 | 23020.0 |
| 2017-11-22 12:00:00 | NQ | Futures | 7595.42 | 7598.69 | 7592.15 | 7598.69 | 13553.0 |
| 2017-11-22 13:00:00 | NQ | Futures | 7598.4 | 7598.99 | 7592.15 | 7597.21 | 8594.0 |
| 2017-11-22 14:00:00 | NQ | Futures | 7597.21 | 7608.21 | 7596.91 | 7603.45 | 16597.0 |
| 2017-11-22 15:00:00 | NQ | Futures | 7603.45 | 7604.94 | 7597.5 | 7601.07 | 18649.0 |
| 2017-11-22 16:00:00 | NQ | Futures | 7600.77 | 7602.26 | 7598.1 | 7598.4 | 5963.0 |
| 2017-11-22 18:00:00 | NQ | Futures | 7599.88 | 7603.15 | 7597.8 | 7602.26 | 577.0 |
| 2017-11-22 19:00:00 | NQ | Futures | 7602.56 | 7603.75 | 7600.18 | 7603.45 | 506.0 |
| 2017-11-22 20:00:00 | NQ | Futures | 7603.45 | 7603.75 | 7598.99 | 7602.26 | 858.0 |
| 2017-11-22 21:00:00 | NQ | Futures | 7601.96 | 7602.56 | 7599.29 | 7600.18 | 482.0 |
| 2017-11-22 22:00:00 | NQ | Futures | 7600.77 | 7604.05 | 7600.48 | 7602.26 | 751.0 |
| 2017-11-22 23:00:00 | NQ | Futures | 7602.26 | 7604.94 | 7602.26 | 7604.34 | 236.0 |
| 2017-11-22 00:00:00 | YM | Futures | 25632.4 | 25635.6 | 25624.8 | 25626.9 | 609.0 |
| 2017-11-22 01:00:00 | YM | Futures | 25625.8 | 25642.2 | 25625.8 | 25638.9 | 889.0 |
| 2017-11-22 02:00:00 | YM | Futures | 25638.9 | 25647.6 | 25629.1 | 25633.5 | 1758.0 |
| 2017-11-22 03:00:00 | YM | Futures | 25633.5 | 25643.2 | 25626.9 | 25630.2 | 2273.0 |
> showing 50 of 1,626 rows — these rows as CSV