PREVIEW / futures_1hour / 2024-08-06
file: by_date/futures_1hour/2024/2024-08-06.parquet size: 73 KB rows: 2,149
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-08-06 00:00:00 | ES | Futures | 5554.21 | 5558.4 | 5543.46 | 5547.13 | 7053.0 |
| 2024-08-06 01:00:00 | ES | Futures | 5546.86 | 5557.09 | 5525.89 | 5549.22 | 15285.0 |
| 2024-08-06 02:00:00 | ES | Futures | 5548.96 | 5554.73 | 5524.84 | 5530.87 | 18730.0 |
| 2024-08-06 03:00:00 | ES | Futures | 5531.14 | 5541.1 | 5518.03 | 5523.79 | 28033.0 |
| 2024-08-06 04:00:00 | ES | Futures | 5523.79 | 5527.99 | 5502.03 | 5512.26 | 26581.0 |
| 2024-08-06 05:00:00 | ES | Futures | 5512.52 | 5512.52 | 5481.85 | 5493.91 | 29669.0 |
| 2024-08-06 06:00:00 | ES | Futures | 5493.65 | 5522.75 | 5487.35 | 5517.5 | 28706.0 |
| 2024-08-06 07:00:00 | ES | Futures | 5517.5 | 5532.71 | 5503.08 | 5514.09 | 36791.0 |
| 2024-08-06 08:00:00 | ES | Futures | 5514.62 | 5515.93 | 5488.14 | 5492.86 | 57718.0 |
| 2024-08-06 09:00:00 | ES | Futures | 5492.6 | 5524.58 | 5475.82 | 5518.29 | 248011.0 |
| 2024-08-06 10:00:00 | ES | Futures | 5518.03 | 5567.31 | 5510.69 | 5554.99 | 322622.0 |
| 2024-08-06 11:00:00 | ES | Futures | 5554.99 | 5561.81 | 5523.27 | 5560.5 | 209264.0 |
| 2024-08-06 12:00:00 | ES | Futures | 5560.76 | 5583.57 | 5556.3 | 5578.85 | 149495.0 |
| 2024-08-06 13:00:00 | ES | Futures | 5579.11 | 5587.5 | 5572.82 | 5581.73 | 118215.0 |
| 2024-08-06 14:00:00 | ES | Futures | 5581.99 | 5601.92 | 5570.98 | 5577.28 | 132805.0 |
| 2024-08-06 15:00:00 | ES | Futures | 5577.01 | 5579.37 | 5518.55 | 5520.91 | 416053.0 |
| 2024-08-06 16:00:00 | ES | Futures | 5520.91 | 5536.64 | 5493.12 | 5504.39 | 125296.0 |
| 2024-08-06 18:00:00 | ES | Futures | 5496.53 | 5518.81 | 5491.02 | 5505.97 | 20906.0 |
| 2024-08-06 19:00:00 | ES | Futures | 5506.23 | 5511.21 | 5495.22 | 5498.63 | 9791.0 |
| 2024-08-06 20:00:00 | ES | Futures | 5498.63 | 5525.11 | 5497.32 | 5519.86 | 17397.0 |
| 2024-08-06 21:00:00 | ES | Futures | 5520.39 | 5547.13 | 5515.14 | 5545.29 | 25547.0 |
| 2024-08-06 22:00:00 | ES | Futures | 5545.29 | 5562.33 | 5539.26 | 5555.78 | 19072.0 |
| 2024-08-06 23:00:00 | ES | Futures | 5556.04 | 5572.03 | 5555.25 | 5567.58 | 16447.0 |
| 2024-08-06 00:00:00 | NQ | Futures | 19421.19 | 19433.07 | 19343.32 | 19359.16 | 4029.0 |
| 2024-08-06 01:00:00 | NQ | Futures | 19357.84 | 19403.51 | 19251.72 | 19370.51 | 8935.0 |
| 2024-08-06 02:00:00 | NQ | Futures | 19368.13 | 19393.47 | 19265.44 | 19296.06 | 8349.0 |
| 2024-08-06 03:00:00 | NQ | Futures | 19296.06 | 19339.09 | 19240.1 | 19272.83 | 9500.0 |
| 2024-08-06 04:00:00 | NQ | Futures | 19270.19 | 19291.58 | 19140.84 | 19186.51 | 12913.0 |
| 2024-08-06 05:00:00 | NQ | Futures | 19183.34 | 19185.46 | 19024.16 | 19099.4 | 14483.0 |
| 2024-08-06 06:00:00 | NQ | Futures | 19099.4 | 19205.52 | 19063.5 | 19186.51 | 9392.0 |
| 2024-08-06 07:00:00 | NQ | Futures | 19187.04 | 19274.68 | 19137.94 | 19205.78 | 11649.0 |
| 2024-08-06 08:00:00 | NQ | Futures | 19207.1 | 19219.77 | 19062.18 | 19094.38 | 19711.0 |
| 2024-08-06 09:00:00 | NQ | Futures | 19093.85 | 19190.47 | 18970.84 | 19155.36 | 83425.0 |
| 2024-08-06 10:00:00 | NQ | Futures | 19156.95 | 19366.55 | 19114.71 | 19325.1 | 113366.0 |
| 2024-08-06 11:00:00 | NQ | Futures | 19325.37 | 19376.05 | 19198.92 | 19368.13 | 73733.0 |
| 2024-08-06 12:00:00 | NQ | Futures | 19367.87 | 19478.48 | 19340.41 | 19456.83 | 48577.0 |
| 2024-08-06 13:00:00 | NQ | Futures | 19457.89 | 19481.38 | 19407.2 | 19449.44 | 43138.0 |
| 2024-08-06 14:00:00 | NQ | Futures | 19450.23 | 19517.02 | 19413.27 | 19415.12 | 40818.0 |
| 2024-08-06 15:00:00 | NQ | Futures | 19415.12 | 19421.46 | 19180.7 | 19187.3 | 96837.0 |
| 2024-08-06 16:00:00 | NQ | Futures | 19187.04 | 19294.75 | 19079.34 | 19111.28 | 34338.0 |
| 2024-08-06 18:00:00 | NQ | Futures | 19041.59 | 19155.1 | 19038.68 | 19109.96 | 9616.0 |
| 2024-08-06 19:00:00 | NQ | Futures | 19110.49 | 19140.84 | 19055.05 | 19065.61 | 5643.0 |
| 2024-08-06 20:00:00 | NQ | Futures | 19064.29 | 19211.59 | 19057.42 | 19183.08 | 8282.0 |
| 2024-08-06 21:00:00 | NQ | Futures | 19182.02 | 19340.68 | 19157.21 | 19312.96 | 12166.0 |
| 2024-08-06 22:00:00 | NQ | Futures | 19311.9 | 19405.35 | 19271.78 | 19376.32 | 9008.0 |
| 2024-08-06 23:00:00 | NQ | Futures | 19378.16 | 19444.95 | 19373.15 | 19412.75 | 5076.0 |
| 2024-08-06 00:00:00 | YM | Futures | 41219.0 | 41233.7 | 41167.5 | 41190.6 | 901.0 |
| 2024-08-06 01:00:00 | YM | Futures | 41190.6 | 41267.3 | 41084.5 | 41239.0 | 2737.0 |
| 2024-08-06 02:00:00 | YM | Futures | 41235.8 | 41260.0 | 41066.6 | 41083.5 | 4094.0 |
| 2024-08-06 03:00:00 | YM | Futures | 41084.5 | 41148.6 | 40992.0 | 41045.6 | 4310.0 |
> showing 50 of 2,149 rows — these rows as CSV