PREVIEW / futures_1hour / 2019-02-15
file: by_date/futures_1hour/2019/2019-02-15.parquet size: 48 KB rows: 1,429
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 |
|---|---|---|---|---|---|---|---|
| 2019-02-15 00:00:00 | ES | Futures | 2969.51 | 2970.05 | 2967.06 | 2969.23 | 6882.0 |
| 2019-02-15 01:00:00 | ES | Futures | 2969.23 | 2970.59 | 2967.33 | 2968.42 | 4241.0 |
| 2019-02-15 02:00:00 | ES | Futures | 2968.15 | 2970.05 | 2964.62 | 2966.25 | 12422.0 |
| 2019-02-15 03:00:00 | ES | Futures | 2966.25 | 2972.49 | 2966.25 | 2970.32 | 23301.0 |
| 2019-02-15 04:00:00 | ES | Futures | 2970.05 | 2977.11 | 2970.05 | 2976.57 | 16833.0 |
| 2019-02-15 05:00:00 | ES | Futures | 2976.57 | 2984.44 | 2973.58 | 2982.0 | 28388.0 |
| 2019-02-15 06:00:00 | ES | Futures | 2981.73 | 2986.62 | 2981.73 | 2982.0 | 20074.0 |
| 2019-02-15 07:00:00 | ES | Futures | 2981.73 | 2989.6 | 2981.73 | 2989.33 | 26811.0 |
| 2019-02-15 08:00:00 | ES | Futures | 2989.06 | 2994.76 | 2985.26 | 2992.59 | 46821.0 |
| 2019-02-15 09:00:00 | ES | Futures | 2992.59 | 3010.51 | 2992.05 | 3006.17 | 325353.0 |
| 2019-02-15 10:00:00 | ES | Futures | 3006.17 | 3012.42 | 3002.1 | 3005.63 | 281905.0 |
| 2019-02-15 11:00:00 | ES | Futures | 3005.63 | 3010.24 | 3001.55 | 3007.8 | 155795.0 |
| 2019-02-15 12:00:00 | ES | Futures | 3007.8 | 3009.97 | 3005.63 | 3006.71 | 81139.0 |
| 2019-02-15 13:00:00 | ES | Futures | 3006.71 | 3008.07 | 3002.91 | 3005.35 | 55806.0 |
| 2019-02-15 14:00:00 | ES | Futures | 3005.08 | 3011.33 | 3005.08 | 3010.24 | 57515.0 |
| 2019-02-15 15:00:00 | ES | Futures | 3010.51 | 3015.4 | 3005.35 | 3015.4 | 172737.0 |
| 2019-02-15 16:00:00 | ES | Futures | 3015.4 | 3018.39 | 3014.32 | 3017.58 | 73278.0 |
| 2019-02-15 00:00:00 | NQ | Futures | 8170.78 | 8171.37 | 8158.8 | 8165.52 | 2754.0 |
| 2019-02-15 01:00:00 | NQ | Futures | 8165.82 | 8169.91 | 8157.34 | 8162.02 | 2231.0 |
| 2019-02-15 02:00:00 | NQ | Futures | 8162.31 | 8168.74 | 8152.37 | 8158.8 | 4646.0 |
| 2019-02-15 03:00:00 | NQ | Futures | 8158.8 | 8183.05 | 8158.51 | 8175.75 | 6454.0 |
| 2019-02-15 04:00:00 | NQ | Futures | 8176.04 | 8192.4 | 8175.46 | 8190.94 | 5387.0 |
| 2019-02-15 05:00:00 | NQ | Futures | 8190.36 | 8214.03 | 8183.64 | 8208.77 | 7741.0 |
| 2019-02-15 06:00:00 | NQ | Futures | 8208.47 | 8223.08 | 8207.6 | 8208.47 | 8118.0 |
| 2019-02-15 07:00:00 | NQ | Futures | 8208.18 | 8232.14 | 8206.14 | 8230.39 | 13908.0 |
| 2019-02-15 08:00:00 | NQ | Futures | 8230.39 | 8252.01 | 8219.87 | 8245.0 | 15556.0 |
| 2019-02-15 09:00:00 | NQ | Futures | 8245.0 | 8292.63 | 8225.42 | 8235.94 | 87372.0 |
| 2019-02-15 10:00:00 | NQ | Futures | 8235.36 | 8268.08 | 8223.96 | 8235.94 | 79685.0 |
| 2019-02-15 11:00:00 | NQ | Futures | 8236.23 | 8250.55 | 8211.1 | 8224.84 | 52297.0 |
| 2019-02-15 12:00:00 | NQ | Futures | 8225.13 | 8238.86 | 8219.58 | 8225.71 | 27383.0 |
| 2019-02-15 13:00:00 | NQ | Futures | 8225.71 | 8230.1 | 8216.95 | 8226.59 | 19074.0 |
| 2019-02-15 14:00:00 | NQ | Futures | 8226.59 | 8243.83 | 8226.01 | 8240.91 | 23277.0 |
| 2019-02-15 15:00:00 | NQ | Futures | 8240.91 | 8252.01 | 8228.05 | 8251.13 | 40675.0 |
| 2019-02-15 16:00:00 | NQ | Futures | 8251.13 | 8260.19 | 8248.21 | 8256.69 | 9874.0 |
| 2019-02-15 00:00:00 | YM | Futures | 27505.3 | 27509.6 | 27481.4 | 27502.0 | 2094.0 |
| 2019-02-15 01:00:00 | YM | Futures | 27503.1 | 27514.0 | 27483.6 | 27489.0 | 1528.0 |
| 2019-02-15 02:00:00 | YM | Futures | 27487.9 | 27501.0 | 27441.2 | 27459.7 | 4104.0 |
| 2019-02-15 03:00:00 | YM | Futures | 27458.6 | 27519.4 | 27457.5 | 27501.0 | 5124.0 |
| 2019-02-15 04:00:00 | YM | Futures | 27499.9 | 27566.1 | 27498.8 | 27562.8 | 4788.0 |
| 2019-02-15 05:00:00 | YM | Futures | 27562.8 | 27635.6 | 27542.2 | 27619.3 | 6313.0 |
| 2019-02-15 06:00:00 | YM | Futures | 27619.3 | 27666.0 | 27619.3 | 27620.4 | 5579.0 |
| 2019-02-15 07:00:00 | YM | Futures | 27622.6 | 27694.2 | 27620.4 | 27691.0 | 5673.0 |
| 2019-02-15 08:00:00 | YM | Futures | 27689.9 | 27732.2 | 27646.4 | 27711.6 | 8148.0 |
| 2019-02-15 09:00:00 | YM | Futures | 27712.7 | 27942.8 | 27704.0 | 27925.5 | 40590.0 |
| 2019-02-15 10:00:00 | YM | Futures | 27926.5 | 28015.6 | 27903.7 | 27954.8 | 36940.0 |
| 2019-02-15 11:00:00 | YM | Futures | 27954.8 | 28019.9 | 27930.9 | 28009.1 | 22536.0 |
| 2019-02-15 12:00:00 | YM | Futures | 28010.1 | 28024.3 | 27974.3 | 27990.6 | 12181.0 |
| 2019-02-15 13:00:00 | YM | Futures | 27990.6 | 28003.6 | 27950.4 | 27985.2 | 8955.0 |
| 2019-02-15 14:00:00 | YM | Futures | 27984.1 | 28051.4 | 27983.0 | 28036.2 | 10808.0 |
| 2019-02-15 15:00:00 | YM | Futures | 28035.1 | 28098.1 | 27994.9 | 28095.9 | 20942.0 |
> showing 50 of 1,429 rows — these rows as CSV