PREVIEW / futures_1hour / 2021-08-10
file: by_date/futures_1hour/2021/2021-08-10.parquet size: 61 KB rows: 1,939
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 |
|---|---|---|---|---|---|---|---|
| 2021-08-10 00:00:00 | ES | Futures | 4976.97 | 4979.5 | 4976.4 | 4979.22 | 2575.0 |
| 2021-08-10 01:00:00 | ES | Futures | 4978.94 | 4982.03 | 4978.37 | 4979.78 | 5031.0 |
| 2021-08-10 02:00:00 | ES | Futures | 4980.06 | 4981.75 | 4978.37 | 4980.63 | 4768.0 |
| 2021-08-10 03:00:00 | ES | Futures | 4980.91 | 4986.82 | 4979.5 | 4984.57 | 12726.0 |
| 2021-08-10 04:00:00 | ES | Futures | 4984.85 | 4986.54 | 4982.6 | 4984.57 | 12201.0 |
| 2021-08-10 05:00:00 | ES | Futures | 4984.85 | 4984.85 | 4982.88 | 4983.44 | 6171.0 |
| 2021-08-10 06:00:00 | ES | Futures | 4983.72 | 4984.85 | 4982.32 | 4983.72 | 5832.0 |
| 2021-08-10 07:00:00 | ES | Futures | 4983.44 | 4985.98 | 4983.44 | 4985.13 | 7906.0 |
| 2021-08-10 08:00:00 | ES | Futures | 4985.13 | 4986.54 | 4984.29 | 4985.98 | 11276.0 |
| 2021-08-10 09:00:00 | ES | Futures | 4985.69 | 4994.14 | 4985.13 | 4992.73 | 107424.0 |
| 2021-08-10 10:00:00 | ES | Futures | 4992.73 | 4998.93 | 4980.91 | 4986.26 | 229823.0 |
| 2021-08-10 11:00:00 | ES | Futures | 4986.26 | 4994.42 | 4981.47 | 4994.42 | 126294.0 |
| 2021-08-10 12:00:00 | ES | Futures | 4994.42 | 4997.52 | 4991.04 | 4992.73 | 69128.0 |
| 2021-08-10 13:00:00 | ES | Futures | 4993.02 | 4993.86 | 4988.23 | 4993.3 | 64722.0 |
| 2021-08-10 14:00:00 | ES | Futures | 4993.3 | 4994.99 | 4987.1 | 4992.17 | 76733.0 |
| 2021-08-10 15:00:00 | ES | Futures | 4992.17 | 4992.73 | 4985.13 | 4989.92 | 116574.0 |
| 2021-08-10 16:00:00 | ES | Futures | 4989.92 | 4990.2 | 4985.69 | 4989.07 | 27121.0 |
| 2021-08-10 18:00:00 | ES | Futures | 4988.79 | 4989.92 | 4986.82 | 4987.1 | 3484.0 |
| 2021-08-10 19:00:00 | ES | Futures | 4987.1 | 4987.95 | 4985.69 | 4987.1 | 3437.0 |
| 2021-08-10 20:00:00 | ES | Futures | 4987.1 | 4989.92 | 4984.01 | 4984.29 | 5913.0 |
| 2021-08-10 21:00:00 | ES | Futures | 4984.29 | 4986.82 | 4982.32 | 4986.54 | 7011.0 |
| 2021-08-10 22:00:00 | ES | Futures | 4986.82 | 4988.51 | 4985.98 | 4987.67 | 4165.0 |
| 2021-08-10 23:00:00 | ES | Futures | 4987.67 | 4988.23 | 4985.13 | 4985.98 | 2756.0 |
| 2021-08-10 00:00:00 | NQ | Futures | 17502.83 | 17506.02 | 17499.36 | 17505.15 | 1062.0 |
| 2021-08-10 01:00:00 | NQ | Futures | 17504.86 | 17521.37 | 17503.99 | 17513.55 | 2809.0 |
| 2021-08-10 02:00:00 | NQ | Futures | 17513.26 | 17521.08 | 17506.02 | 17519.63 | 2278.0 |
| 2021-08-10 03:00:00 | NQ | Futures | 17519.63 | 17543.97 | 17516.16 | 17542.23 | 5885.0 |
| 2021-08-10 04:00:00 | NQ | Futures | 17541.94 | 17553.53 | 17528.61 | 17537.01 | 4895.0 |
| 2021-08-10 05:00:00 | NQ | Futures | 17536.72 | 17552.37 | 17534.99 | 17547.44 | 3373.0 |
| 2021-08-10 06:00:00 | NQ | Futures | 17547.73 | 17550.34 | 17537.59 | 17543.97 | 2850.0 |
| 2021-08-10 07:00:00 | NQ | Futures | 17543.39 | 17555.26 | 17539.62 | 17548.02 | 4086.0 |
| 2021-08-10 08:00:00 | NQ | Futures | 17547.73 | 17554.39 | 17540.2 | 17541.36 | 4999.0 |
| 2021-08-10 09:00:00 | NQ | Futures | 17541.07 | 17559.03 | 17516.16 | 17551.79 | 65973.0 |
| 2021-08-10 10:00:00 | NQ | Futures | 17551.5 | 17563.09 | 17388.41 | 17422.01 | 122225.0 |
| 2021-08-10 11:00:00 | NQ | Futures | 17422.01 | 17448.37 | 17374.5 | 17433.89 | 71061.0 |
| 2021-08-10 12:00:00 | NQ | Futures | 17433.89 | 17480.53 | 17432.73 | 17444.9 | 42543.0 |
| 2021-08-10 13:00:00 | NQ | Futures | 17444.9 | 17459.38 | 17422.88 | 17444.03 | 31481.0 |
| 2021-08-10 14:00:00 | NQ | Futures | 17443.74 | 17447.5 | 17404.63 | 17442.0 | 35532.0 |
| 2021-08-10 15:00:00 | NQ | Futures | 17441.71 | 17446.92 | 17409.84 | 17434.47 | 45296.0 |
| 2021-08-10 16:00:00 | NQ | Futures | 17434.47 | 17436.49 | 17423.75 | 17436.49 | 7388.0 |
| 2021-08-10 18:00:00 | NQ | Futures | 17433.02 | 17433.89 | 17420.27 | 17421.72 | 1879.0 |
| 2021-08-10 19:00:00 | NQ | Futures | 17422.01 | 17426.36 | 17419.11 | 17422.01 | 1370.0 |
| 2021-08-10 20:00:00 | NQ | Futures | 17421.72 | 17434.18 | 17412.16 | 17414.77 | 3155.0 |
| 2021-08-10 21:00:00 | NQ | Futures | 17413.9 | 17430.7 | 17407.53 | 17428.96 | 3567.0 |
| 2021-08-10 22:00:00 | NQ | Futures | 17429.83 | 17437.65 | 17427.51 | 17435.34 | 2105.0 |
| 2021-08-10 23:00:00 | NQ | Futures | 17435.34 | 17437.36 | 17425.78 | 17428.96 | 1447.0 |
| 2021-08-10 00:00:00 | YM | Futures | 39035.7 | 39058.0 | 39027.8 | 39054.7 | 634.0 |
| 2021-08-10 01:00:00 | YM | Futures | 39054.7 | 39081.5 | 39044.6 | 39059.1 | 962.0 |
| 2021-08-10 02:00:00 | YM | Futures | 39059.1 | 39073.7 | 39050.2 | 39062.5 | 1242.0 |
| 2021-08-10 03:00:00 | YM | Futures | 39063.6 | 39108.3 | 39048.0 | 39080.4 | 2757.0 |
> showing 50 of 1,939 rows — these rows as CSV