PREVIEW / futures_1hour / 2019-02-12
file: by_date/futures_1hour/2019/2019-02-12.parquet size: 55 KB rows: 1,765
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-12 00:00:00 | ES | Futures | 2957.28 | 2957.28 | 2955.11 | 2955.93 | 4508.0 |
| 2019-02-12 01:00:00 | ES | Futures | 2955.93 | 2958.37 | 2955.65 | 2957.28 | 5639.0 |
| 2019-02-12 02:00:00 | ES | Futures | 2957.28 | 2960.54 | 2956.2 | 2959.73 | 10489.0 |
| 2019-02-12 03:00:00 | ES | Futures | 2959.73 | 2962.17 | 2957.83 | 2960.27 | 20369.0 |
| 2019-02-12 04:00:00 | ES | Futures | 2960.27 | 2961.36 | 2957.28 | 2958.37 | 12917.0 |
| 2019-02-12 05:00:00 | ES | Futures | 2958.64 | 2962.72 | 2958.1 | 2961.63 | 12027.0 |
| 2019-02-12 06:00:00 | ES | Futures | 2961.9 | 2963.8 | 2960.81 | 2963.8 | 11729.0 |
| 2019-02-12 07:00:00 | ES | Futures | 2963.8 | 2965.98 | 2962.17 | 2962.44 | 22388.0 |
| 2019-02-12 08:00:00 | ES | Futures | 2962.44 | 2964.07 | 2961.36 | 2961.36 | 24767.0 |
| 2019-02-12 09:00:00 | ES | Futures | 2961.63 | 2970.05 | 2961.36 | 2968.69 | 178421.0 |
| 2019-02-12 10:00:00 | ES | Futures | 2968.69 | 2975.48 | 2965.43 | 2974.67 | 206723.0 |
| 2019-02-12 11:00:00 | ES | Futures | 2974.39 | 2980.91 | 2974.39 | 2980.37 | 156664.0 |
| 2019-02-12 12:00:00 | ES | Futures | 2980.37 | 2981.73 | 2975.21 | 2978.2 | 110539.0 |
| 2019-02-12 13:00:00 | ES | Futures | 2978.2 | 2985.26 | 2977.38 | 2984.71 | 89273.0 |
| 2019-02-12 14:00:00 | ES | Futures | 2984.99 | 2985.26 | 2980.91 | 2981.46 | 86248.0 |
| 2019-02-12 15:00:00 | ES | Futures | 2981.18 | 2984.44 | 2978.2 | 2980.91 | 172377.0 |
| 2019-02-12 16:00:00 | ES | Futures | 2980.91 | 2983.63 | 2978.74 | 2981.73 | 67857.0 |
| 2019-02-12 18:00:00 | ES | Futures | 2980.37 | 2984.71 | 2979.55 | 2984.17 | 8144.0 |
| 2019-02-12 19:00:00 | ES | Futures | 2984.17 | 2993.68 | 2983.08 | 2987.97 | 24564.0 |
| 2019-02-12 20:00:00 | ES | Futures | 2987.7 | 2992.59 | 2987.7 | 2991.5 | 16273.0 |
| 2019-02-12 21:00:00 | ES | Futures | 2991.23 | 2992.59 | 2989.6 | 2989.87 | 6935.0 |
| 2019-02-12 22:00:00 | ES | Futures | 2989.87 | 2992.86 | 2989.87 | 2991.78 | 5929.0 |
| 2019-02-12 23:00:00 | ES | Futures | 2992.05 | 2992.32 | 2990.42 | 2990.96 | 3058.0 |
| 2019-02-12 00:00:00 | NQ | Futures | 8129.29 | 8129.58 | 8124.03 | 8127.83 | 1983.0 |
| 2019-02-12 01:00:00 | NQ | Futures | 8127.54 | 8137.47 | 8126.66 | 8133.38 | 2328.0 |
| 2019-02-12 02:00:00 | NQ | Futures | 8133.67 | 8145.07 | 8130.46 | 8143.02 | 3927.0 |
| 2019-02-12 03:00:00 | NQ | Futures | 8143.32 | 8150.04 | 8137.47 | 8143.32 | 7970.0 |
| 2019-02-12 04:00:00 | NQ | Futures | 8143.61 | 8144.78 | 8132.51 | 8136.01 | 4318.0 |
| 2019-02-12 05:00:00 | NQ | Futures | 8136.6 | 8152.08 | 8136.6 | 8148.28 | 5070.0 |
| 2019-02-12 06:00:00 | NQ | Futures | 8148.58 | 8152.96 | 8144.78 | 8152.08 | 5971.0 |
| 2019-02-12 07:00:00 | NQ | Futures | 8151.79 | 8157.63 | 8146.53 | 8146.82 | 6804.0 |
| 2019-02-12 08:00:00 | NQ | Futures | 8147.12 | 8149.45 | 8138.06 | 8138.93 | 9239.0 |
| 2019-02-12 09:00:00 | NQ | Futures | 8138.93 | 8167.86 | 8127.54 | 8161.14 | 58257.0 |
| 2019-02-12 10:00:00 | NQ | Futures | 8161.14 | 8196.2 | 8160.85 | 8193.87 | 63230.0 |
| 2019-02-12 11:00:00 | NQ | Futures | 8193.87 | 8202.34 | 8188.61 | 8197.37 | 40113.0 |
| 2019-02-12 12:00:00 | NQ | Futures | 8197.37 | 8202.05 | 8185.98 | 8191.53 | 28622.0 |
| 2019-02-12 13:00:00 | NQ | Futures | 8191.82 | 8208.18 | 8188.9 | 8206.43 | 23795.0 |
| 2019-02-12 14:00:00 | NQ | Futures | 8206.72 | 8212.27 | 8196.79 | 8198.25 | 24294.0 |
| 2019-02-12 15:00:00 | NQ | Futures | 8197.96 | 8214.61 | 8196.5 | 8203.22 | 37365.0 |
| 2019-02-12 16:00:00 | NQ | Futures | 8203.22 | 8208.77 | 8195.62 | 8205.26 | 11527.0 |
| 2019-02-12 18:00:00 | NQ | Futures | 8201.46 | 8212.57 | 8196.79 | 8211.4 | 2698.0 |
| 2019-02-12 19:00:00 | NQ | Futures | 8211.69 | 8237.11 | 8209.06 | 8227.76 | 7788.0 |
| 2019-02-12 20:00:00 | NQ | Futures | 8227.47 | 8242.08 | 8227.47 | 8236.23 | 5657.0 |
| 2019-02-12 21:00:00 | NQ | Futures | 8236.53 | 8240.03 | 8231.27 | 8234.19 | 2653.0 |
| 2019-02-12 22:00:00 | NQ | Futures | 8234.19 | 8244.71 | 8233.6 | 8241.49 | 2720.0 |
| 2019-02-12 23:00:00 | NQ | Futures | 8241.49 | 8242.66 | 8237.99 | 8239.74 | 1214.0 |
| 2019-02-12 00:00:00 | YM | Futures | 27312.0 | 27312.0 | 27287.1 | 27295.8 | 1445.0 |
| 2019-02-12 01:00:00 | YM | Futures | 27294.7 | 27319.6 | 27293.6 | 27308.8 | 1527.0 |
| 2019-02-12 02:00:00 | YM | Futures | 27308.8 | 27334.8 | 27289.2 | 27331.6 | 2967.0 |
| 2019-02-12 03:00:00 | YM | Futures | 27330.5 | 27346.8 | 27318.6 | 27338.1 | 4439.0 |
> showing 50 of 1,765 rows — these rows as CSV