PREVIEW / futures_1hour / 2017-11-10
file: by_date/futures_1hour/2017/2017-11-10.parquet size: 45 KB rows: 1,341
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-10 00:00:00 | ES | Futures | 2828.32 | 2829.42 | 2828.05 | 2828.87 | 4825.0 |
| 2017-11-10 01:00:00 | ES | Futures | 2828.6 | 2828.87 | 2823.4 | 2823.67 | 10099.0 |
| 2017-11-10 02:00:00 | ES | Futures | 2823.4 | 2824.77 | 2822.58 | 2823.12 | 17684.0 |
| 2017-11-10 03:00:00 | ES | Futures | 2823.12 | 2825.31 | 2818.2 | 2819.84 | 44754.0 |
| 2017-11-10 04:00:00 | ES | Futures | 2819.84 | 2820.66 | 2813.82 | 2814.37 | 47752.0 |
| 2017-11-10 05:00:00 | ES | Futures | 2814.64 | 2818.47 | 2814.64 | 2817.65 | 23612.0 |
| 2017-11-10 06:00:00 | ES | Futures | 2817.65 | 2819.02 | 2815.74 | 2816.83 | 20250.0 |
| 2017-11-10 07:00:00 | ES | Futures | 2816.56 | 2819.57 | 2815.19 | 2818.75 | 24765.0 |
| 2017-11-10 08:00:00 | ES | Futures | 2818.75 | 2821.21 | 2818.47 | 2820.12 | 30689.0 |
| 2017-11-10 09:00:00 | ES | Futures | 2819.84 | 2822.3 | 2817.93 | 2819.29 | 182229.0 |
| 2017-11-10 10:00:00 | ES | Futures | 2819.29 | 2822.03 | 2815.47 | 2819.57 | 200959.0 |
| 2017-11-10 11:00:00 | ES | Futures | 2819.84 | 2821.21 | 2817.11 | 2820.66 | 115332.0 |
| 2017-11-10 12:00:00 | ES | Futures | 2820.66 | 2822.3 | 2819.02 | 2819.29 | 60892.0 |
| 2017-11-10 13:00:00 | ES | Futures | 2819.57 | 2821.76 | 2818.47 | 2820.94 | 55109.0 |
| 2017-11-10 14:00:00 | ES | Futures | 2820.94 | 2824.77 | 2820.66 | 2824.49 | 65601.0 |
| 2017-11-10 15:00:00 | ES | Futures | 2824.22 | 2825.04 | 2822.58 | 2823.4 | 149144.0 |
| 2017-11-10 16:00:00 | ES | Futures | 2823.67 | 2823.95 | 2821.48 | 2822.03 | 82059.0 |
| 2017-11-10 00:00:00 | NQ | Futures | 7516.9 | 7519.88 | 7515.12 | 7518.09 | 1111.0 |
| 2017-11-10 01:00:00 | NQ | Futures | 7518.39 | 7518.39 | 7502.03 | 7502.63 | 2275.0 |
| 2017-11-10 02:00:00 | NQ | Futures | 7502.63 | 7507.98 | 7499.06 | 7505.9 | 3066.0 |
| 2017-11-10 03:00:00 | NQ | Futures | 7505.6 | 7512.44 | 7490.43 | 7498.17 | 4905.0 |
| 2017-11-10 04:00:00 | NQ | Futures | 7498.17 | 7502.33 | 7472.29 | 7474.97 | 9145.0 |
| 2017-11-10 05:00:00 | NQ | Futures | 7474.97 | 7485.97 | 7474.97 | 7485.67 | 3521.0 |
| 2017-11-10 06:00:00 | NQ | Futures | 7485.67 | 7488.65 | 7481.81 | 7486.86 | 3140.0 |
| 2017-11-10 07:00:00 | NQ | Futures | 7486.57 | 7496.68 | 7480.92 | 7495.79 | 4043.0 |
| 2017-11-10 08:00:00 | NQ | Futures | 7495.79 | 7499.36 | 7490.43 | 7493.7 | 6633.0 |
| 2017-11-10 09:00:00 | NQ | Futures | 7493.7 | 7502.63 | 7483.0 | 7492.22 | 46819.0 |
| 2017-11-10 10:00:00 | NQ | Futures | 7491.92 | 7496.98 | 7475.56 | 7491.33 | 50586.0 |
| 2017-11-10 11:00:00 | NQ | Futures | 7491.62 | 7495.79 | 7481.51 | 7494.3 | 29271.0 |
| 2017-11-10 12:00:00 | NQ | Futures | 7494.3 | 7505.6 | 7490.73 | 7491.62 | 18392.0 |
| 2017-11-10 13:00:00 | NQ | Futures | 7491.92 | 7502.33 | 7488.95 | 7499.36 | 18234.0 |
| 2017-11-10 14:00:00 | NQ | Futures | 7499.36 | 7510.36 | 7499.06 | 7508.58 | 17556.0 |
| 2017-11-10 15:00:00 | NQ | Futures | 7508.28 | 7511.85 | 7501.14 | 7505.6 | 28838.0 |
| 2017-11-10 16:00:00 | NQ | Futures | 7505.3 | 7508.87 | 7502.03 | 7503.82 | 7584.0 |
| 2017-11-10 00:00:00 | YM | Futures | 25488.8 | 25502.9 | 25487.7 | 25500.8 | 1299.0 |
| 2017-11-10 01:00:00 | YM | Futures | 25499.7 | 25500.8 | 25455.1 | 25459.4 | 2116.0 |
| 2017-11-10 02:00:00 | YM | Futures | 25459.4 | 25473.6 | 25454.0 | 25459.4 | 2902.0 |
| 2017-11-10 03:00:00 | YM | Futures | 25459.4 | 25476.8 | 25420.3 | 25432.2 | 5233.0 |
| 2017-11-10 04:00:00 | YM | Futures | 25432.2 | 25440.9 | 25384.4 | 25388.7 | 6002.0 |
| 2017-11-10 05:00:00 | YM | Futures | 25389.8 | 25426.8 | 25387.6 | 25417.0 | 2893.0 |
| 2017-11-10 06:00:00 | YM | Futures | 25417.0 | 25429.0 | 25402.9 | 25414.8 | 2360.0 |
| 2017-11-10 07:00:00 | YM | Futures | 25414.8 | 25431.1 | 25399.6 | 25425.7 | 2700.0 |
| 2017-11-10 08:00:00 | YM | Futures | 25426.8 | 25454.0 | 25422.4 | 25445.3 | 4301.0 |
| 2017-11-10 09:00:00 | YM | Futures | 25444.2 | 25462.7 | 25408.3 | 25425.7 | 19710.0 |
| 2017-11-10 10:00:00 | YM | Futures | 25424.6 | 25449.6 | 25399.6 | 25427.9 | 16809.0 |
| 2017-11-10 11:00:00 | YM | Futures | 25427.9 | 25436.6 | 25402.9 | 25430.1 | 8942.0 |
| 2017-11-10 12:00:00 | YM | Futures | 25430.1 | 25434.4 | 25408.3 | 25409.4 | 5130.0 |
| 2017-11-10 13:00:00 | YM | Futures | 25408.3 | 25427.9 | 25401.8 | 25417.0 | 5551.0 |
| 2017-11-10 14:00:00 | YM | Futures | 25418.1 | 25447.5 | 25417.0 | 25445.3 | 6731.0 |
| 2017-11-10 15:00:00 | YM | Futures | 25445.3 | 25447.5 | 25430.1 | 25435.5 | 9412.0 |
> showing 50 of 1,341 rows — these rows as CSV