PREVIEW / futures_1hour / 2024-04-15
file: by_date/futures_1hour/2024/2024-04-15.parquet size: 69 KB rows: 2,095
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-04-15 00:00:00 | ES | Futures | 5497.99 | 5503.82 | 5497.19 | 5503.56 | 5838.0 |
| 2024-04-15 01:00:00 | ES | Futures | 5503.56 | 5507.54 | 5502.76 | 5506.48 | 8870.0 |
| 2024-04-15 02:00:00 | ES | Futures | 5506.21 | 5511.52 | 5503.03 | 5507.27 | 15275.0 |
| 2024-04-15 03:00:00 | ES | Futures | 5507.27 | 5516.56 | 5503.03 | 5513.91 | 30894.0 |
| 2024-04-15 04:00:00 | ES | Futures | 5513.64 | 5515.23 | 5508.6 | 5509.66 | 24099.0 |
| 2024-04-15 05:00:00 | ES | Futures | 5509.93 | 5515.23 | 5503.82 | 5507.27 | 20025.0 |
| 2024-04-15 06:00:00 | ES | Futures | 5507.54 | 5511.52 | 5504.36 | 5506.21 | 14722.0 |
| 2024-04-15 07:00:00 | ES | Futures | 5506.21 | 5516.03 | 5505.42 | 5513.64 | 27274.0 |
| 2024-04-15 08:00:00 | ES | Futures | 5513.64 | 5530.88 | 5507.01 | 5525.84 | 79272.0 |
| 2024-04-15 09:00:00 | ES | Futures | 5525.58 | 5532.21 | 5520.01 | 5527.7 | 206976.0 |
| 2024-04-15 10:00:00 | ES | Futures | 5527.7 | 5529.56 | 5486.05 | 5486.85 | 327543.0 |
| 2024-04-15 11:00:00 | ES | Futures | 5486.85 | 5502.76 | 5483.4 | 5499.85 | 170764.0 |
| 2024-04-15 12:00:00 | ES | Futures | 5499.58 | 5502.76 | 5469.07 | 5475.17 | 145667.0 |
| 2024-04-15 13:00:00 | ES | Futures | 5475.17 | 5480.74 | 5420.52 | 5435.64 | 327825.0 |
| 2024-04-15 14:00:00 | ES | Futures | 5435.91 | 5437.24 | 5414.69 | 5422.38 | 233811.0 |
| 2024-04-15 15:00:00 | ES | Futures | 5422.11 | 5424.24 | 5405.67 | 5415.48 | 323624.0 |
| 2024-04-15 16:00:00 | ES | Futures | 5415.48 | 5416.54 | 5405.93 | 5413.09 | 87196.0 |
| 2024-04-15 18:00:00 | ES | Futures | 5413.36 | 5418.66 | 5413.36 | 5417.6 | 10097.0 |
| 2024-04-15 19:00:00 | ES | Futures | 5417.6 | 5417.87 | 5406.2 | 5414.95 | 10919.0 |
| 2024-04-15 20:00:00 | ES | Futures | 5415.22 | 5420.26 | 5413.62 | 5414.95 | 14080.0 |
| 2024-04-15 21:00:00 | ES | Futures | 5414.95 | 5416.01 | 5407.26 | 5412.3 | 12945.0 |
| 2024-04-15 22:00:00 | ES | Futures | 5412.3 | 5413.36 | 5392.14 | 5403.81 | 23342.0 |
| 2024-04-15 23:00:00 | ES | Futures | 5403.81 | 5405.13 | 5397.97 | 5404.87 | 7850.0 |
| 2024-04-15 00:00:00 | NQ | Futures | 19507.46 | 19529.67 | 19503.99 | 19526.46 | 2682.0 |
| 2024-04-15 01:00:00 | NQ | Futures | 19526.72 | 19541.7 | 19520.3 | 19535.82 | 4404.0 |
| 2024-04-15 02:00:00 | NQ | Futures | 19536.09 | 19555.61 | 19520.84 | 19539.3 | 6545.0 |
| 2024-04-15 03:00:00 | NQ | Futures | 19539.56 | 19570.33 | 19518.43 | 19559.89 | 10797.0 |
| 2024-04-15 04:00:00 | NQ | Futures | 19559.36 | 19568.19 | 19544.38 | 19555.88 | 9628.0 |
| 2024-04-15 05:00:00 | NQ | Futures | 19556.68 | 19576.48 | 19537.42 | 19550.53 | 8809.0 |
| 2024-04-15 06:00:00 | NQ | Futures | 19549.73 | 19568.45 | 19544.65 | 19555.61 | 6669.0 |
| 2024-04-15 07:00:00 | NQ | Futures | 19555.88 | 19578.89 | 19543.04 | 19572.73 | 10462.0 |
| 2024-04-15 08:00:00 | NQ | Futures | 19572.73 | 19632.39 | 19548.66 | 19614.47 | 29708.0 |
| 2024-04-15 09:00:00 | NQ | Futures | 19614.73 | 19635.6 | 19539.3 | 19586.11 | 90107.0 |
| 2024-04-15 10:00:00 | NQ | Futures | 19586.11 | 19609.38 | 19443.0 | 19444.07 | 123164.0 |
| 2024-04-15 11:00:00 | NQ | Futures | 19444.33 | 19498.9 | 19429.89 | 19485.8 | 62788.0 |
| 2024-04-15 12:00:00 | NQ | Futures | 19485.8 | 19502.92 | 19350.17 | 19377.19 | 65589.0 |
| 2024-04-15 13:00:00 | NQ | Futures | 19377.46 | 19401.0 | 19128.41 | 19177.63 | 126960.0 |
| 2024-04-15 14:00:00 | NQ | Futures | 19178.17 | 19194.48 | 19118.25 | 19138.31 | 78721.0 |
| 2024-04-15 15:00:00 | NQ | Futures | 19138.04 | 19158.64 | 19090.69 | 19127.88 | 88360.0 |
| 2024-04-15 16:00:00 | NQ | Futures | 19127.88 | 19135.37 | 19093.64 | 19126.54 | 18344.0 |
| 2024-04-15 18:00:00 | NQ | Futures | 19130.82 | 19143.93 | 19125.47 | 19133.49 | 4786.0 |
| 2024-04-15 19:00:00 | NQ | Futures | 19133.76 | 19135.1 | 19095.51 | 19121.99 | 6670.0 |
| 2024-04-15 20:00:00 | NQ | Futures | 19123.33 | 19146.6 | 19117.98 | 19133.23 | 6936.0 |
| 2024-04-15 21:00:00 | NQ | Futures | 19133.23 | 19136.97 | 19107.01 | 19123.33 | 5385.0 |
| 2024-04-15 22:00:00 | NQ | Futures | 19123.86 | 19128.14 | 19041.74 | 19084.54 | 11450.0 |
| 2024-04-15 23:00:00 | NQ | Futures | 19084.81 | 19097.11 | 19066.88 | 19096.04 | 5191.0 |
| 2024-04-15 00:00:00 | YM | Futures | 40684.4 | 40723.7 | 40680.2 | 40716.3 | 889.0 |
| 2024-04-15 01:00:00 | YM | Futures | 40718.4 | 40756.6 | 40718.4 | 40747.1 | 1636.0 |
| 2024-04-15 02:00:00 | YM | Futures | 40749.2 | 40776.8 | 40722.7 | 40739.6 | 2320.0 |
| 2024-04-15 03:00:00 | YM | Futures | 40739.6 | 40799.1 | 40722.7 | 40789.5 | 3595.0 |
> showing 50 of 2,095 rows — these rows as CSV