PREVIEW / futures_1hour / 2022-08-24
file: by_date/futures_1hour/2022/2022-08-24.parquet size: 66 KB rows: 2,008
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 |
|---|---|---|---|---|---|---|---|
| 2022-08-24 00:00:00 | ES | Futures | 4663.78 | 4675.11 | 4660.95 | 4673.98 | 6081.0 |
| 2022-08-24 01:00:00 | ES | Futures | 4673.7 | 4676.25 | 4670.86 | 4673.7 | 5266.0 |
| 2022-08-24 02:00:00 | ES | Futures | 4673.98 | 4679.08 | 4668.6 | 4673.7 | 7789.0 |
| 2022-08-24 03:00:00 | ES | Futures | 4673.7 | 4681.91 | 4657.83 | 4667.18 | 24056.0 |
| 2022-08-24 04:00:00 | ES | Futures | 4667.18 | 4685.88 | 4665.76 | 4683.61 | 17726.0 |
| 2022-08-24 05:00:00 | ES | Futures | 4683.89 | 4685.88 | 4675.4 | 4676.81 | 8037.0 |
| 2022-08-24 06:00:00 | ES | Futures | 4676.81 | 4681.06 | 4673.98 | 4675.68 | 10006.0 |
| 2022-08-24 07:00:00 | ES | Futures | 4675.68 | 4690.69 | 4674.83 | 4688.71 | 14797.0 |
| 2022-08-24 08:00:00 | ES | Futures | 4688.43 | 4693.24 | 4678.23 | 4683.89 | 32074.0 |
| 2022-08-24 09:00:00 | ES | Futures | 4683.61 | 4684.18 | 4669.73 | 4679.65 | 152721.0 |
| 2022-08-24 10:00:00 | ES | Futures | 4679.65 | 4694.94 | 4674.83 | 4688.43 | 226549.0 |
| 2022-08-24 11:00:00 | ES | Futures | 4688.43 | 4711.94 | 4687.58 | 4707.12 | 180353.0 |
| 2022-08-24 12:00:00 | ES | Futures | 4707.12 | 4710.52 | 4685.31 | 4688.43 | 132675.0 |
| 2022-08-24 13:00:00 | ES | Futures | 4688.43 | 4693.81 | 4681.91 | 4688.71 | 95988.0 |
| 2022-08-24 14:00:00 | ES | Futures | 4688.43 | 4692.96 | 4684.46 | 4691.83 | 90643.0 |
| 2022-08-24 15:00:00 | ES | Futures | 4691.83 | 4704.86 | 4690.41 | 4695.22 | 192185.0 |
| 2022-08-24 16:00:00 | ES | Futures | 4695.22 | 4702.59 | 4693.24 | 4701.74 | 53079.0 |
| 2022-08-24 18:00:00 | ES | Futures | 4700.89 | 4703.16 | 4698.91 | 4700.04 | 3687.0 |
| 2022-08-24 19:00:00 | ES | Futures | 4700.04 | 4701.74 | 4695.79 | 4697.21 | 3641.0 |
| 2022-08-24 20:00:00 | ES | Futures | 4697.49 | 4707.12 | 4694.38 | 4705.99 | 9583.0 |
| 2022-08-24 21:00:00 | ES | Futures | 4705.99 | 4710.52 | 4704.86 | 4707.69 | 7926.0 |
| 2022-08-24 22:00:00 | ES | Futures | 4707.69 | 4710.24 | 4705.71 | 4707.69 | 5250.0 |
| 2022-08-24 23:00:00 | ES | Futures | 4707.97 | 4709.96 | 4705.42 | 4707.12 | 3778.0 |
| 2022-08-24 00:00:00 | NQ | Futures | 14859.95 | 14902.17 | 14846.06 | 14894.65 | 3782.0 |
| 2022-08-24 01:00:00 | NQ | Futures | 14894.94 | 14911.43 | 14885.69 | 14898.7 | 3773.0 |
| 2022-08-24 02:00:00 | NQ | Futures | 14898.7 | 14923.87 | 14882.22 | 14903.62 | 5493.0 |
| 2022-08-24 03:00:00 | NQ | Futures | 14904.2 | 14933.12 | 14838.83 | 14878.17 | 13377.0 |
| 2022-08-24 04:00:00 | NQ | Futures | 14878.75 | 14946.72 | 14872.09 | 14936.02 | 9866.0 |
| 2022-08-24 05:00:00 | NQ | Futures | 14936.59 | 14944.4 | 14903.62 | 14909.41 | 5823.0 |
| 2022-08-24 06:00:00 | NQ | Futures | 14909.41 | 14922.42 | 14892.05 | 14897.84 | 5486.0 |
| 2022-08-24 07:00:00 | NQ | Futures | 14898.99 | 14961.18 | 14894.65 | 14952.5 | 8467.0 |
| 2022-08-24 08:00:00 | NQ | Futures | 14952.21 | 14968.7 | 14913.74 | 14931.68 | 15051.0 |
| 2022-08-24 09:00:00 | NQ | Futures | 14931.68 | 14941.22 | 14868.62 | 14929.65 | 66204.0 |
| 2022-08-24 10:00:00 | NQ | Futures | 14929.94 | 14988.66 | 14897.84 | 14961.47 | 78167.0 |
| 2022-08-24 11:00:00 | NQ | Futures | 14962.05 | 15045.64 | 14953.08 | 15029.15 | 60836.0 |
| 2022-08-24 12:00:00 | NQ | Futures | 15029.44 | 15053.45 | 14962.05 | 14976.8 | 49771.0 |
| 2022-08-24 13:00:00 | NQ | Futures | 14977.09 | 14997.04 | 14936.59 | 14969.57 | 43251.0 |
| 2022-08-24 14:00:00 | NQ | Futures | 14969.28 | 14986.05 | 14941.22 | 14970.15 | 38152.0 |
| 2022-08-24 15:00:00 | NQ | Futures | 14970.72 | 15007.46 | 14954.53 | 14964.36 | 54710.0 |
| 2022-08-24 16:00:00 | NQ | Futures | 14964.65 | 14999.94 | 14952.79 | 14989.52 | 15455.0 |
| 2022-08-24 18:00:00 | NQ | Futures | 14975.64 | 14990.39 | 14971.01 | 14974.48 | 2034.0 |
| 2022-08-24 19:00:00 | NQ | Futures | 14975.06 | 14981.71 | 14960.02 | 14964.65 | 1904.0 |
| 2022-08-24 20:00:00 | NQ | Futures | 14964.65 | 15002.54 | 14953.66 | 14998.49 | 3938.0 |
| 2022-08-24 21:00:00 | NQ | Futures | 14998.49 | 15016.42 | 14993.0 | 15007.75 | 3937.0 |
| 2022-08-24 22:00:00 | NQ | Futures | 15009.19 | 15014.69 | 15000.23 | 15005.43 | 2382.0 |
| 2022-08-24 23:00:00 | NQ | Futures | 15005.14 | 15012.95 | 14994.15 | 14999.07 | 2294.0 |
| 2022-08-24 00:00:00 | YM | Futures | 37000.6 | 37083.0 | 36980.3 | 37074.0 | 1564.0 |
| 2022-08-24 01:00:00 | YM | Futures | 37076.2 | 37085.3 | 37051.4 | 37067.2 | 955.0 |
| 2022-08-24 02:00:00 | YM | Futures | 37067.2 | 37101.1 | 37033.4 | 37063.8 | 1920.0 |
| 2022-08-24 03:00:00 | YM | Futures | 37065.0 | 37124.8 | 36956.6 | 37023.2 | 6540.0 |
> showing 50 of 2,008 rows — these rows as CSV