PREVIEW / futures_1hour / 2017-08-11
file: by_date/futures_1hour/2017/2017-08-11.parquet size: 45 KB rows: 1,334
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-08-11 00:00:00 | ES | Futures | 2662.6 | 2663.14 | 2662.05 | 2662.05 | 3035.0 |
| 2017-08-11 01:00:00 | ES | Futures | 2662.32 | 2663.42 | 2661.23 | 2662.87 | 4983.0 |
| 2017-08-11 02:00:00 | ES | Futures | 2663.14 | 2665.6 | 2662.87 | 2664.24 | 18032.0 |
| 2017-08-11 03:00:00 | ES | Futures | 2664.51 | 2665.6 | 2662.32 | 2663.42 | 30990.0 |
| 2017-08-11 04:00:00 | ES | Futures | 2663.14 | 2663.69 | 2657.68 | 2660.68 | 47242.0 |
| 2017-08-11 05:00:00 | ES | Futures | 2660.68 | 2662.05 | 2658.22 | 2660.68 | 29838.0 |
| 2017-08-11 06:00:00 | ES | Futures | 2660.96 | 2662.32 | 2659.86 | 2660.14 | 24086.0 |
| 2017-08-11 07:00:00 | ES | Futures | 2660.41 | 2662.05 | 2657.13 | 2660.41 | 40523.0 |
| 2017-08-11 08:00:00 | ES | Futures | 2660.41 | 2669.98 | 2659.59 | 2668.06 | 98551.0 |
| 2017-08-11 09:00:00 | ES | Futures | 2667.79 | 2672.98 | 2663.42 | 2668.06 | 285909.0 |
| 2017-08-11 10:00:00 | ES | Futures | 2667.79 | 2674.9 | 2666.42 | 2672.71 | 218605.0 |
| 2017-08-11 11:00:00 | ES | Futures | 2672.71 | 2672.98 | 2666.15 | 2668.88 | 153589.0 |
| 2017-08-11 12:00:00 | ES | Futures | 2668.88 | 2671.89 | 2668.06 | 2669.7 | 87746.0 |
| 2017-08-11 13:00:00 | ES | Futures | 2669.7 | 2672.16 | 2668.88 | 2670.8 | 73914.0 |
| 2017-08-11 14:00:00 | ES | Futures | 2670.8 | 2673.8 | 2664.51 | 2665.6 | 127072.0 |
| 2017-08-11 15:00:00 | ES | Futures | 2665.33 | 2670.52 | 2663.42 | 2667.52 | 259295.0 |
| 2017-08-11 16:00:00 | ES | Futures | 2667.24 | 2668.61 | 2666.42 | 2668.61 | 86635.0 |
| 2017-08-11 00:00:00 | NQ | Futures | 6874.78 | 6879.24 | 6871.8 | 6871.8 | 899.0 |
| 2017-08-11 01:00:00 | NQ | Futures | 6872.4 | 6878.65 | 6869.72 | 6876.56 | 1086.0 |
| 2017-08-11 02:00:00 | NQ | Futures | 6876.56 | 6889.67 | 6876.56 | 6886.39 | 3235.0 |
| 2017-08-11 03:00:00 | NQ | Futures | 6886.09 | 6892.05 | 6880.44 | 6882.82 | 4610.0 |
| 2017-08-11 04:00:00 | NQ | Futures | 6883.12 | 6886.69 | 6861.38 | 6872.69 | 7277.0 |
| 2017-08-11 05:00:00 | NQ | Futures | 6872.69 | 6881.03 | 6864.95 | 6875.67 | 4093.0 |
| 2017-08-11 06:00:00 | NQ | Futures | 6875.67 | 6884.01 | 6873.29 | 6875.08 | 4221.0 |
| 2017-08-11 07:00:00 | NQ | Futures | 6875.37 | 6881.63 | 6867.04 | 6875.37 | 5080.0 |
| 2017-08-11 08:00:00 | NQ | Futures | 6875.08 | 6903.36 | 6870.61 | 6901.58 | 18361.0 |
| 2017-08-11 09:00:00 | NQ | Futures | 6901.58 | 6922.72 | 6888.18 | 6921.23 | 77726.0 |
| 2017-08-11 10:00:00 | NQ | Futures | 6921.23 | 6946.54 | 6913.78 | 6936.71 | 66511.0 |
| 2017-08-11 11:00:00 | NQ | Futures | 6937.01 | 6939.99 | 6916.17 | 6930.76 | 42691.0 |
| 2017-08-11 12:00:00 | NQ | Futures | 6930.76 | 6951.9 | 6928.67 | 6945.35 | 27138.0 |
| 2017-08-11 13:00:00 | NQ | Futures | 6945.05 | 6954.58 | 6940.28 | 6950.71 | 25395.0 |
| 2017-08-11 14:00:00 | NQ | Futures | 6950.71 | 6962.32 | 6934.33 | 6937.6 | 36374.0 |
| 2017-08-11 15:00:00 | NQ | Futures | 6937.9 | 6952.49 | 6930.16 | 6946.83 | 49068.0 |
| 2017-08-11 16:00:00 | NQ | Futures | 6946.54 | 6955.47 | 6944.45 | 6952.19 | 8428.0 |
| 2017-08-11 00:00:00 | YM | Futures | 23751.8 | 23757.2 | 23751.8 | 23753.9 | 496.0 |
| 2017-08-11 01:00:00 | YM | Futures | 23755.0 | 23764.8 | 23749.6 | 23760.5 | 713.0 |
| 2017-08-11 02:00:00 | YM | Futures | 23760.5 | 23785.5 | 23759.4 | 23772.4 | 2235.0 |
| 2017-08-11 03:00:00 | YM | Futures | 23771.4 | 23780.1 | 23757.2 | 23764.8 | 2966.0 |
| 2017-08-11 04:00:00 | YM | Futures | 23764.8 | 23765.9 | 23718.0 | 23740.9 | 5014.0 |
| 2017-08-11 05:00:00 | YM | Futures | 23739.8 | 23753.9 | 23726.7 | 23745.2 | 2476.0 |
| 2017-08-11 06:00:00 | YM | Futures | 23745.2 | 23755.0 | 23737.6 | 23742.0 | 1582.0 |
| 2017-08-11 07:00:00 | YM | Futures | 23742.0 | 23752.9 | 23723.5 | 23738.7 | 2837.0 |
| 2017-08-11 08:00:00 | YM | Futures | 23738.7 | 23793.1 | 23737.6 | 23779.0 | 9320.0 |
| 2017-08-11 09:00:00 | YM | Futures | 23777.9 | 23813.8 | 23753.9 | 23784.4 | 29030.0 |
| 2017-08-11 10:00:00 | YM | Futures | 23784.4 | 23820.3 | 23775.7 | 23800.7 | 18046.0 |
| 2017-08-11 11:00:00 | YM | Futures | 23799.7 | 23808.4 | 23768.1 | 23786.6 | 13901.0 |
| 2017-08-11 12:00:00 | YM | Futures | 23785.5 | 23805.1 | 23775.7 | 23793.1 | 7640.0 |
| 2017-08-11 13:00:00 | YM | Futures | 23793.1 | 23809.5 | 23786.6 | 23797.5 | 6191.0 |
| 2017-08-11 14:00:00 | YM | Futures | 23797.5 | 23812.7 | 23751.8 | 23755.0 | 11668.0 |
| 2017-08-11 15:00:00 | YM | Futures | 23755.0 | 23793.1 | 23745.2 | 23765.9 | 19337.0 |
> showing 50 of 1,334 rows — these rows as CSV