PREVIEW / futures_1hour / 2024-06-21
file: by_date/futures_1hour/2024/2024-06-21.parquet size: 55 KB rows: 1,652
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-06-21 00:00:00 | ES | Futures | 5815.06 | 5818.2 | 5814.8 | 5817.94 | 2149.0 |
| 2024-06-21 01:00:00 | ES | Futures | 5817.94 | 5819.78 | 5817.16 | 5818.99 | 3480.0 |
| 2024-06-21 02:00:00 | ES | Futures | 5818.99 | 5820.83 | 5816.37 | 5816.63 | 6887.0 |
| 2024-06-21 03:00:00 | ES | Futures | 5816.63 | 5817.16 | 5803.26 | 5807.19 | 18761.0 |
| 2024-06-21 04:00:00 | ES | Futures | 5807.19 | 5809.29 | 5795.4 | 5800.64 | 22167.0 |
| 2024-06-21 05:00:00 | ES | Futures | 5800.64 | 5808.24 | 5798.02 | 5805.88 | 17020.0 |
| 2024-06-21 06:00:00 | ES | Futures | 5805.62 | 5809.29 | 5800.38 | 5807.19 | 12727.0 |
| 2024-06-21 07:00:00 | ES | Futures | 5807.19 | 5813.22 | 5802.74 | 5803.79 | 17857.0 |
| 2024-06-21 08:00:00 | ES | Futures | 5803.52 | 5811.13 | 5799.85 | 5810.34 | 31149.0 |
| 2024-06-21 09:00:00 | ES | Futures | 5810.34 | 5813.49 | 5787.53 | 5796.44 | 216114.0 |
| 2024-06-21 10:00:00 | ES | Futures | 5796.71 | 5807.72 | 5795.92 | 5806.93 | 178052.0 |
| 2024-06-21 11:00:00 | ES | Futures | 5806.93 | 5814.27 | 5797.76 | 5814.01 | 140436.0 |
| 2024-06-21 12:00:00 | ES | Futures | 5814.01 | 5815.58 | 5802.74 | 5803.79 | 95509.0 |
| 2024-06-21 13:00:00 | ES | Futures | 5803.79 | 5806.93 | 5793.04 | 5797.23 | 105146.0 |
| 2024-06-21 14:00:00 | ES | Futures | 5797.49 | 5805.88 | 5795.13 | 5801.43 | 88479.0 |
| 2024-06-21 15:00:00 | ES | Futures | 5801.43 | 5811.39 | 5799.07 | 5799.33 | 197046.0 |
| 2024-06-21 16:00:00 | ES | Futures | 5799.07 | 5808.5 | 5798.54 | 5805.88 | 63149.0 |
| 2024-06-21 00:00:00 | NQ | Futures | 21175.36 | 21191.72 | 21171.13 | 21189.88 | 2037.0 |
| 2024-06-21 01:00:00 | NQ | Futures | 21189.88 | 21199.91 | 21186.18 | 21196.21 | 2611.0 |
| 2024-06-21 02:00:00 | NQ | Futures | 21195.68 | 21209.41 | 21185.12 | 21191.2 | 4490.0 |
| 2024-06-21 03:00:00 | NQ | Futures | 21191.72 | 21193.57 | 21122.82 | 21148.96 | 11266.0 |
| 2024-06-21 04:00:00 | NQ | Futures | 21148.69 | 21157.14 | 21063.43 | 21092.73 | 16400.0 |
| 2024-06-21 05:00:00 | NQ | Futures | 21091.67 | 21136.81 | 21083.75 | 21127.05 | 8955.0 |
| 2024-06-21 06:00:00 | NQ | Futures | 21126.52 | 21149.75 | 21100.91 | 21136.29 | 8360.0 |
| 2024-06-21 07:00:00 | NQ | Futures | 21136.81 | 21164.27 | 21108.04 | 21112.26 | 10065.0 |
| 2024-06-21 08:00:00 | NQ | Futures | 21111.21 | 21159.52 | 21095.9 | 21152.39 | 17154.0 |
| 2024-06-21 09:00:00 | NQ | Futures | 21152.13 | 21166.64 | 21028.05 | 21069.76 | 98912.0 |
| 2024-06-21 10:00:00 | NQ | Futures | 21069.5 | 21131.27 | 21058.41 | 21129.42 | 88966.0 |
| 2024-06-21 11:00:00 | NQ | Futures | 21129.42 | 21190.4 | 21092.73 | 21189.88 | 67757.0 |
| 2024-06-21 12:00:00 | NQ | Futures | 21189.88 | 21195.42 | 21108.83 | 21115.7 | 56184.0 |
| 2024-06-21 13:00:00 | NQ | Futures | 21115.17 | 21132.06 | 21063.16 | 21077.68 | 48943.0 |
| 2024-06-21 14:00:00 | NQ | Futures | 21077.42 | 21121.24 | 21072.67 | 21100.65 | 38035.0 |
| 2024-06-21 15:00:00 | NQ | Futures | 21100.65 | 21133.91 | 21090.62 | 21092.2 | 62876.0 |
| 2024-06-21 16:00:00 | NQ | Futures | 21092.73 | 21131.27 | 21090.88 | 21128.9 | 13531.0 |
| 2024-06-21 00:00:00 | YM | Futures | 41584.7 | 41594.1 | 41582.6 | 41594.1 | 279.0 |
| 2024-06-21 01:00:00 | YM | Futures | 41593.1 | 41607.8 | 41592.0 | 41599.4 | 1029.0 |
| 2024-06-21 02:00:00 | YM | Futures | 41599.4 | 41599.4 | 41565.7 | 41565.7 | 1300.0 |
| 2024-06-21 03:00:00 | YM | Futures | 41564.7 | 41568.9 | 41488.0 | 41499.5 | 2797.0 |
| 2024-06-21 04:00:00 | YM | Futures | 41500.6 | 41557.3 | 41492.2 | 41539.5 | 3834.0 |
| 2024-06-21 05:00:00 | YM | Futures | 41537.4 | 41555.2 | 41510.1 | 41533.2 | 2044.0 |
| 2024-06-21 06:00:00 | YM | Futures | 41534.2 | 41558.4 | 41506.9 | 41548.9 | 2102.0 |
| 2024-06-21 07:00:00 | YM | Futures | 41552.1 | 41592.0 | 41546.8 | 41552.1 | 2381.0 |
| 2024-06-21 08:00:00 | YM | Futures | 41553.1 | 41569.9 | 41478.5 | 41565.7 | 4995.0 |
| 2024-06-21 09:00:00 | YM | Futures | 41566.8 | 41651.9 | 41483.8 | 41604.6 | 26166.0 |
| 2024-06-21 10:00:00 | YM | Futures | 41599.4 | 41700.2 | 41586.8 | 41609.9 | 17234.0 |
| 2024-06-21 11:00:00 | YM | Futures | 41606.7 | 41634.0 | 41505.8 | 41543.7 | 12383.0 |
| 2024-06-21 12:00:00 | YM | Futures | 41544.7 | 41606.7 | 41520.6 | 41575.2 | 8661.0 |
| 2024-06-21 13:00:00 | YM | Futures | 41575.2 | 41595.2 | 41532.1 | 41567.8 | 7311.0 |
| 2024-06-21 14:00:00 | YM | Futures | 41567.8 | 41622.5 | 41542.6 | 41569.9 | 7183.0 |
| 2024-06-21 15:00:00 | YM | Futures | 41569.9 | 41628.8 | 41564.7 | 41567.8 | 11809.0 |
> showing 50 of 1,652 rows — these rows as CSV