PREVIEW / futures_1hour / 2024-10-24
file: by_date/futures_1hour/2024/2024-10-24.parquet size: 66 KB rows: 2,085
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-24 00:00:00 | ES | Futures | 6072.33 | 6073.37 | 6069.99 | 6072.33 | 2773.0 |
| 2024-10-24 01:00:00 | ES | Futures | 6072.33 | 6073.11 | 6069.47 | 6072.33 | 3375.0 |
| 2024-10-24 02:00:00 | ES | Futures | 6072.07 | 6077.52 | 6072.07 | 6072.33 | 5804.0 |
| 2024-10-24 03:00:00 | ES | Futures | 6072.59 | 6086.6 | 6071.81 | 6085.05 | 14542.0 |
| 2024-10-24 04:00:00 | ES | Futures | 6085.05 | 6090.24 | 6081.15 | 6085.3 | 14137.0 |
| 2024-10-24 05:00:00 | ES | Futures | 6085.3 | 6087.64 | 6083.49 | 6085.3 | 6543.0 |
| 2024-10-24 06:00:00 | ES | Futures | 6085.56 | 6089.72 | 6083.75 | 6085.3 | 7824.0 |
| 2024-10-24 07:00:00 | ES | Futures | 6085.3 | 6092.05 | 6084.27 | 6091.01 | 13403.0 |
| 2024-10-24 08:00:00 | ES | Futures | 6091.27 | 6093.61 | 6084.53 | 6086.08 | 24281.0 |
| 2024-10-24 09:00:00 | ES | Futures | 6086.08 | 6090.24 | 6065.32 | 6073.89 | 135516.0 |
| 2024-10-24 10:00:00 | ES | Futures | 6073.63 | 6079.6 | 6064.8 | 6067.66 | 168480.0 |
| 2024-10-24 11:00:00 | ES | Futures | 6067.66 | 6073.89 | 6049.23 | 6059.61 | 151261.0 |
| 2024-10-24 12:00:00 | ES | Futures | 6059.61 | 6069.99 | 6044.3 | 6068.7 | 137031.0 |
| 2024-10-24 13:00:00 | ES | Futures | 6068.7 | 6075.96 | 6063.76 | 6064.54 | 90959.0 |
| 2024-10-24 14:00:00 | ES | Futures | 6064.8 | 6073.63 | 6060.13 | 6067.92 | 82899.0 |
| 2024-10-24 15:00:00 | ES | Futures | 6067.66 | 6079.34 | 6062.21 | 6071.81 | 173979.0 |
| 2024-10-24 16:00:00 | ES | Futures | 6072.07 | 6079.85 | 6070.51 | 6075.7 | 51308.0 |
| 2024-10-24 18:00:00 | ES | Futures | 6076.22 | 6077.52 | 6071.81 | 6073.37 | 4355.0 |
| 2024-10-24 19:00:00 | ES | Futures | 6073.37 | 6073.63 | 6069.73 | 6073.37 | 3824.0 |
| 2024-10-24 20:00:00 | ES | Futures | 6073.63 | 6077.0 | 6070.77 | 6075.96 | 5712.0 |
| 2024-10-24 21:00:00 | ES | Futures | 6075.7 | 6078.56 | 6074.15 | 6074.4 | 4516.0 |
| 2024-10-24 22:00:00 | ES | Futures | 6074.4 | 6077.26 | 6073.63 | 6075.18 | 3040.0 |
| 2024-10-24 23:00:00 | ES | Futures | 6075.44 | 6075.96 | 6069.21 | 6069.73 | 3994.0 |
| 2024-10-24 00:00:00 | NQ | Futures | 21206.95 | 21213.48 | 21197.04 | 21209.56 | 1942.0 |
| 2024-10-24 01:00:00 | NQ | Futures | 21210.35 | 21216.87 | 21192.6 | 21211.13 | 2018.0 |
| 2024-10-24 02:00:00 | NQ | Futures | 21210.08 | 21229.91 | 21202.0 | 21204.87 | 3837.0 |
| 2024-10-24 03:00:00 | NQ | Futures | 21205.39 | 21277.92 | 21201.21 | 21270.36 | 8259.0 |
| 2024-10-24 04:00:00 | NQ | Futures | 21271.66 | 21292.27 | 21240.87 | 21262.27 | 7393.0 |
| 2024-10-24 05:00:00 | NQ | Futures | 21262.01 | 21273.23 | 21251.83 | 21266.44 | 3729.0 |
| 2024-10-24 06:00:00 | NQ | Futures | 21266.7 | 21284.71 | 21258.87 | 21267.75 | 4337.0 |
| 2024-10-24 07:00:00 | NQ | Futures | 21268.27 | 21311.06 | 21259.4 | 21306.36 | 7172.0 |
| 2024-10-24 08:00:00 | NQ | Futures | 21306.36 | 21320.19 | 21265.66 | 21272.44 | 14455.0 |
| 2024-10-24 09:00:00 | NQ | Futures | 21272.7 | 21296.71 | 21182.17 | 21224.7 | 68583.0 |
| 2024-10-24 10:00:00 | NQ | Futures | 21225.22 | 21268.01 | 21192.08 | 21203.3 | 77335.0 |
| 2024-10-24 11:00:00 | NQ | Futures | 21203.56 | 21256.79 | 21148.51 | 21214.78 | 56699.0 |
| 2024-10-24 12:00:00 | NQ | Futures | 21215.3 | 21254.44 | 21146.16 | 21245.83 | 51299.0 |
| 2024-10-24 13:00:00 | NQ | Futures | 21246.09 | 21278.97 | 21228.87 | 21232.52 | 35265.0 |
| 2024-10-24 14:00:00 | NQ | Futures | 21233.31 | 21273.23 | 21214.52 | 21257.57 | 30190.0 |
| 2024-10-24 15:00:00 | NQ | Futures | 21257.05 | 21299.32 | 21232.0 | 21269.83 | 49322.0 |
| 2024-10-24 16:00:00 | NQ | Futures | 21269.57 | 21304.53 | 21260.7 | 21281.05 | 12510.0 |
| 2024-10-24 18:00:00 | NQ | Futures | 21278.44 | 21290.45 | 21264.35 | 21269.05 | 1408.0 |
| 2024-10-24 19:00:00 | NQ | Futures | 21269.05 | 21271.4 | 21252.87 | 21270.36 | 1937.0 |
| 2024-10-24 20:00:00 | NQ | Futures | 21271.4 | 21294.36 | 21261.48 | 21288.1 | 2909.0 |
| 2024-10-24 21:00:00 | NQ | Futures | 21287.05 | 21303.75 | 21285.23 | 21287.84 | 2746.0 |
| 2024-10-24 22:00:00 | NQ | Futures | 21286.79 | 21301.66 | 21283.66 | 21288.36 | 2236.0 |
| 2024-10-24 23:00:00 | NQ | Futures | 21288.62 | 21291.23 | 21260.18 | 21264.35 | 2636.0 |
| 2024-10-24 00:00:00 | YM | Futures | 44412.0 | 44420.3 | 44405.8 | 44411.0 | 386.0 |
| 2024-10-24 01:00:00 | YM | Futures | 44411.0 | 44412.0 | 44398.5 | 44403.7 | 393.0 |
| 2024-10-24 02:00:00 | YM | Futures | 44401.6 | 44442.2 | 44400.6 | 44406.8 | 991.0 |
| 2024-10-24 03:00:00 | YM | Futures | 44409.9 | 44489.0 | 44406.8 | 44472.4 | 2439.0 |
> showing 50 of 2,085 rows — these rows as CSV