PREVIEW / futures_1hour / 2024-10-16
file: by_date/futures_1hour/2024/2024-10-16.parquet size: 66 KB rows: 2,084
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 |
|---|---|---|---|---|---|---|---|
| 2024-10-16 00:00:00 | ES | Futures | 6091.53 | 6092.57 | 6090.24 | 6091.53 | 2242.0 |
| 2024-10-16 01:00:00 | ES | Futures | 6091.53 | 6091.79 | 6088.16 | 6090.5 | 4404.0 |
| 2024-10-16 02:00:00 | ES | Futures | 6090.5 | 6090.5 | 6085.56 | 6087.64 | 7349.0 |
| 2024-10-16 03:00:00 | ES | Futures | 6087.64 | 6089.72 | 6078.82 | 6088.94 | 15204.0 |
| 2024-10-16 04:00:00 | ES | Futures | 6089.2 | 6089.98 | 6082.45 | 6085.82 | 11071.0 |
| 2024-10-16 05:00:00 | ES | Futures | 6085.82 | 6089.72 | 6084.27 | 6088.42 | 6677.0 |
| 2024-10-16 06:00:00 | ES | Futures | 6088.42 | 6088.94 | 6085.3 | 6088.94 | 5554.0 |
| 2024-10-16 07:00:00 | ES | Futures | 6088.94 | 6092.57 | 6087.12 | 6091.53 | 12209.0 |
| 2024-10-16 08:00:00 | ES | Futures | 6091.53 | 6092.31 | 6085.56 | 6086.6 | 17389.0 |
| 2024-10-16 09:00:00 | ES | Futures | 6086.6 | 6090.24 | 6076.22 | 6078.3 | 124460.0 |
| 2024-10-16 10:00:00 | ES | Futures | 6078.3 | 6099.32 | 6077.26 | 6088.42 | 163996.0 |
| 2024-10-16 11:00:00 | ES | Futures | 6088.42 | 6096.72 | 6084.79 | 6089.98 | 89766.0 |
| 2024-10-16 12:00:00 | ES | Futures | 6089.72 | 6102.17 | 6089.46 | 6101.91 | 58091.0 |
| 2024-10-16 13:00:00 | ES | Futures | 6102.17 | 6105.29 | 6096.98 | 6104.51 | 66234.0 |
| 2024-10-16 14:00:00 | ES | Futures | 6104.77 | 6117.23 | 6102.95 | 6112.81 | 82484.0 |
| 2024-10-16 15:00:00 | ES | Futures | 6112.81 | 6115.15 | 6108.92 | 6110.22 | 138473.0 |
| 2024-10-16 16:00:00 | ES | Futures | 6110.22 | 6111.26 | 6106.85 | 6107.88 | 52896.0 |
| 2024-10-16 18:00:00 | ES | Futures | 6106.85 | 6108.92 | 6104.51 | 6106.07 | 4168.0 |
| 2024-10-16 19:00:00 | ES | Futures | 6106.33 | 6106.59 | 6102.17 | 6102.95 | 2139.0 |
| 2024-10-16 20:00:00 | ES | Futures | 6102.69 | 6105.29 | 6096.72 | 6102.69 | 7068.0 |
| 2024-10-16 21:00:00 | ES | Futures | 6102.69 | 6104.77 | 6098.8 | 6102.43 | 4737.0 |
| 2024-10-16 22:00:00 | ES | Futures | 6102.43 | 6103.47 | 6094.91 | 6099.58 | 5600.0 |
| 2024-10-16 23:00:00 | ES | Futures | 6099.58 | 6101.14 | 6097.76 | 6098.02 | 2588.0 |
| 2024-10-16 00:00:00 | NQ | Futures | 21277.66 | 21286.01 | 21272.7 | 21280.01 | 1782.0 |
| 2024-10-16 01:00:00 | NQ | Futures | 21280.53 | 21288.88 | 21265.4 | 21282.1 | 3287.0 |
| 2024-10-16 02:00:00 | NQ | Futures | 21281.84 | 21283.92 | 21254.44 | 21266.7 | 4359.0 |
| 2024-10-16 03:00:00 | NQ | Futures | 21267.22 | 21283.4 | 21217.39 | 21280.01 | 8642.0 |
| 2024-10-16 04:00:00 | NQ | Futures | 21279.75 | 21282.36 | 21223.65 | 21248.7 | 7909.0 |
| 2024-10-16 05:00:00 | NQ | Futures | 21248.18 | 21272.7 | 21239.05 | 21253.4 | 5711.0 |
| 2024-10-16 06:00:00 | NQ | Futures | 21253.4 | 21257.83 | 21237.22 | 21250.79 | 2811.0 |
| 2024-10-16 07:00:00 | NQ | Futures | 21254.44 | 21275.83 | 21245.31 | 21264.88 | 4633.0 |
| 2024-10-16 08:00:00 | NQ | Futures | 21264.62 | 21268.01 | 21229.13 | 21239.05 | 7997.0 |
| 2024-10-16 09:00:00 | NQ | Futures | 21238.78 | 21267.75 | 21097.63 | 21106.5 | 73402.0 |
| 2024-10-16 10:00:00 | NQ | Futures | 21107.02 | 21237.48 | 21088.24 | 21158.42 | 83715.0 |
| 2024-10-16 11:00:00 | NQ | Futures | 21158.68 | 21216.87 | 21148.77 | 21159.99 | 43942.0 |
| 2024-10-16 12:00:00 | NQ | Futures | 21159.99 | 21225.48 | 21154.77 | 21222.87 | 30392.0 |
| 2024-10-16 13:00:00 | NQ | Futures | 21223.13 | 21236.96 | 21189.47 | 21224.96 | 29559.0 |
| 2024-10-16 14:00:00 | NQ | Futures | 21224.7 | 21268.79 | 21204.87 | 21250.79 | 32484.0 |
| 2024-10-16 15:00:00 | NQ | Futures | 21250.79 | 21259.4 | 21218.69 | 21234.35 | 40119.0 |
| 2024-10-16 16:00:00 | NQ | Futures | 21234.61 | 21236.7 | 21205.65 | 21215.3 | 11790.0 |
| 2024-10-16 18:00:00 | NQ | Futures | 21215.3 | 21223.13 | 21205.65 | 21217.65 | 2243.0 |
| 2024-10-16 19:00:00 | NQ | Futures | 21216.61 | 21218.43 | 21197.3 | 21200.69 | 1766.0 |
| 2024-10-16 20:00:00 | NQ | Futures | 21199.91 | 21214.0 | 21161.82 | 21200.69 | 4851.0 |
| 2024-10-16 21:00:00 | NQ | Futures | 21201.47 | 21212.43 | 21181.12 | 21205.65 | 2928.0 |
| 2024-10-16 22:00:00 | NQ | Futures | 21205.13 | 21211.65 | 21164.95 | 21191.56 | 3414.0 |
| 2024-10-16 23:00:00 | NQ | Futures | 21191.04 | 21198.08 | 21178.77 | 21183.47 | 1762.0 |
| 2024-10-16 00:00:00 | YM | Futures | 44765.9 | 44770.0 | 44754.4 | 44757.6 | 163.0 |
| 2024-10-16 01:00:00 | YM | Futures | 44759.6 | 44760.7 | 44741.9 | 44754.4 | 389.0 |
| 2024-10-16 02:00:00 | YM | Futures | 44752.3 | 44752.3 | 44727.4 | 44731.5 | 911.0 |
| 2024-10-16 03:00:00 | YM | Futures | 44733.6 | 44759.6 | 44686.8 | 44746.1 | 2056.0 |
> showing 50 of 2,084 rows — these rows as CSV