PREVIEW / futures_30min / 2019-03-07
file: by_date/futures_30min/2019/2019-03-07.parquet size: 89 KB rows: 3,273
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-03-07 00:00:00 | ES | Futures | 3005.63 | 3005.63 | 3004.0 | 3004.27 | 2563.0 |
| 2019-03-07 00:30:00 | ES | Futures | 3004.54 | 3005.35 | 3004.0 | 3004.27 | 2775.0 |
| 2019-03-07 01:00:00 | ES | Futures | 3004.54 | 3005.35 | 3004.0 | 3004.54 | 2747.0 |
| 2019-03-07 01:30:00 | ES | Futures | 3004.54 | 3005.35 | 3004.0 | 3004.27 | 1838.0 |
| 2019-03-07 02:00:00 | ES | Futures | 3004.27 | 3004.81 | 3000.74 | 3000.74 | 8908.0 |
| 2019-03-07 02:30:00 | ES | Futures | 3000.74 | 3002.37 | 2999.92 | 3002.1 | 6961.0 |
| 2019-03-07 03:00:00 | ES | Futures | 3001.82 | 3003.73 | 3001.01 | 3001.01 | 14049.0 |
| 2019-03-07 03:30:00 | ES | Futures | 3001.01 | 3003.45 | 3001.01 | 3003.18 | 6942.0 |
| 2019-03-07 04:00:00 | ES | Futures | 3003.18 | 3004.0 | 3002.37 | 3002.91 | 5771.0 |
| 2019-03-07 04:30:00 | ES | Futures | 3002.91 | 3004.27 | 3002.91 | 3002.91 | 4818.0 |
| 2019-03-07 05:00:00 | ES | Futures | 3002.91 | 3004.81 | 3002.1 | 3003.73 | 5700.0 |
| 2019-03-07 05:30:00 | ES | Futures | 3003.73 | 3004.54 | 3002.91 | 3004.54 | 4292.0 |
| 2019-03-07 06:00:00 | ES | Futures | 3004.54 | 3005.35 | 3003.18 | 3005.08 | 4814.0 |
| 2019-03-07 06:30:00 | ES | Futures | 3004.81 | 3005.08 | 3002.1 | 3002.91 | 4311.0 |
| 2019-03-07 07:00:00 | ES | Futures | 3002.91 | 3006.98 | 3002.64 | 3006.17 | 8395.0 |
| 2019-03-07 07:30:00 | ES | Futures | 3006.17 | 3012.69 | 3005.35 | 3012.42 | 17394.0 |
| 2019-03-07 08:00:00 | ES | Futures | 3012.42 | 3015.13 | 3010.24 | 3014.05 | 24789.0 |
| 2019-03-07 08:30:00 | ES | Futures | 3014.05 | 3015.95 | 3007.26 | 3008.34 | 30704.0 |
| 2019-03-07 09:00:00 | ES | Futures | 3008.34 | 3011.06 | 3004.54 | 3005.35 | 30349.0 |
| 2019-03-07 09:30:00 | ES | Futures | 3005.08 | 3006.71 | 2982.27 | 2988.24 | 256090.0 |
| 2019-03-07 10:00:00 | ES | Futures | 2988.24 | 2989.33 | 2978.47 | 2985.8 | 142008.0 |
| 2019-03-07 10:30:00 | ES | Futures | 2986.07 | 2990.69 | 2981.46 | 2988.24 | 110374.0 |
| 2019-03-07 11:00:00 | ES | Futures | 2988.24 | 2989.87 | 2983.36 | 2989.06 | 91637.0 |
| 2019-03-07 11:30:00 | ES | Futures | 2988.79 | 2995.03 | 2988.79 | 2990.96 | 79592.0 |
| 2019-03-07 12:00:00 | ES | Futures | 2990.69 | 2993.13 | 2988.24 | 2991.23 | 64408.0 |
| 2019-03-07 12:30:00 | ES | Futures | 2991.23 | 2999.65 | 2986.07 | 2998.02 | 93302.0 |
| 2019-03-07 13:00:00 | ES | Futures | 2997.75 | 2998.57 | 2993.95 | 2995.58 | 45529.0 |
| 2019-03-07 13:30:00 | ES | Futures | 2995.58 | 2995.85 | 2990.42 | 2990.96 | 39898.0 |
| 2019-03-07 14:00:00 | ES | Futures | 2991.23 | 2993.13 | 2984.17 | 2987.16 | 50258.0 |
| 2019-03-07 14:30:00 | ES | Futures | 2987.16 | 2987.97 | 2977.11 | 2979.01 | 79781.0 |
| 2019-03-07 15:00:00 | ES | Futures | 2979.01 | 2984.71 | 2974.94 | 2979.01 | 92236.0 |
| 2019-03-07 15:30:00 | ES | Futures | 2979.01 | 2987.43 | 2978.74 | 2986.34 | 134683.0 |
| 2019-03-07 16:00:00 | ES | Futures | 2986.34 | 2988.79 | 2986.07 | 2987.43 | 43180.0 |
| 2019-03-07 16:30:00 | ES | Futures | 2987.16 | 2988.24 | 2986.34 | 2986.89 | 5053.0 |
| 2019-03-07 18:00:00 | ES | Futures | 2986.34 | 2986.89 | 2985.26 | 2986.34 | 2707.0 |
| 2019-03-07 18:30:00 | ES | Futures | 2986.34 | 2988.79 | 2986.07 | 2988.79 | 2344.0 |
| 2019-03-07 19:00:00 | ES | Futures | 2988.52 | 2989.06 | 2984.71 | 2986.62 | 4498.0 |
| 2019-03-07 19:30:00 | ES | Futures | 2986.62 | 2987.43 | 2982.27 | 2982.27 | 4077.0 |
| 2019-03-07 20:00:00 | ES | Futures | 2982.27 | 2983.36 | 2980.91 | 2981.46 | 4599.0 |
| 2019-03-07 20:30:00 | ES | Futures | 2981.73 | 2985.53 | 2980.1 | 2985.26 | 5397.0 |
| 2019-03-07 21:00:00 | ES | Futures | 2985.26 | 2987.16 | 2983.08 | 2986.89 | 4456.0 |
| 2019-03-07 21:30:00 | ES | Futures | 2987.16 | 2987.97 | 2985.53 | 2985.8 | 3011.0 |
| 2019-03-07 22:00:00 | ES | Futures | 2985.8 | 2986.62 | 2982.27 | 2984.17 | 5225.0 |
| 2019-03-07 22:30:00 | ES | Futures | 2983.9 | 2984.99 | 2982.27 | 2982.81 | 2320.0 |
| 2019-03-07 23:00:00 | ES | Futures | 2982.81 | 2983.08 | 2979.28 | 2979.28 | 3341.0 |
| 2019-03-07 23:30:00 | ES | Futures | 2979.28 | 2981.73 | 2979.01 | 2980.64 | 2136.0 |
| 2019-03-07 00:00:00 | NQ | Futures | 8297.59 | 8297.59 | 8292.63 | 8294.09 | 993.0 |
| 2019-03-07 00:30:00 | NQ | Futures | 8293.79 | 8296.13 | 8292.04 | 8293.21 | 1093.0 |
| 2019-03-07 01:00:00 | NQ | Futures | 8293.21 | 8295.55 | 8290.29 | 8294.38 | 1155.0 |
| 2019-03-07 01:30:00 | NQ | Futures | 8294.09 | 8296.13 | 8292.63 | 8293.21 | 881.0 |
> showing 50 of 3,273 rows — these rows as CSV