PREVIEW / futures_1hour / 2024-09-26
file: by_date/futures_1hour/2024/2024-09-26.parquet size: 69 KB rows: 2,138
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-09-26 00:00:00 | ES | Futures | 6026.91 | 6028.99 | 6024.84 | 6028.47 | 5090.0 |
| 2024-09-26 01:00:00 | ES | Futures | 6028.73 | 6038.07 | 6026.13 | 6036.77 | 13219.0 |
| 2024-09-26 02:00:00 | ES | Futures | 6036.77 | 6044.82 | 6036.51 | 6042.48 | 18878.0 |
| 2024-09-26 03:00:00 | ES | Futures | 6042.74 | 6048.71 | 6039.63 | 6047.41 | 18307.0 |
| 2024-09-26 04:00:00 | ES | Futures | 6047.41 | 6050.01 | 6044.04 | 6046.9 | 17525.0 |
| 2024-09-26 05:00:00 | ES | Futures | 6046.9 | 6048.45 | 6043.0 | 6045.86 | 10555.0 |
| 2024-09-26 06:00:00 | ES | Futures | 6045.6 | 6050.27 | 6044.3 | 6050.01 | 9102.0 |
| 2024-09-26 07:00:00 | ES | Futures | 6050.27 | 6050.53 | 6044.3 | 6045.08 | 16208.0 |
| 2024-09-26 08:00:00 | ES | Futures | 6045.34 | 6050.53 | 6041.19 | 6048.19 | 38504.0 |
| 2024-09-26 09:00:00 | ES | Futures | 6048.19 | 6052.09 | 6032.62 | 6037.29 | 168052.0 |
| 2024-09-26 10:00:00 | ES | Futures | 6037.29 | 6043.52 | 6010.56 | 6012.64 | 255908.0 |
| 2024-09-26 11:00:00 | ES | Futures | 6012.9 | 6026.65 | 6009.0 | 6024.84 | 165604.0 |
| 2024-09-26 12:00:00 | ES | Futures | 6024.84 | 6025.1 | 6008.23 | 6010.82 | 110834.0 |
| 2024-09-26 13:00:00 | ES | Futures | 6010.56 | 6018.09 | 5998.36 | 6015.75 | 114718.0 |
| 2024-09-26 14:00:00 | ES | Futures | 6016.01 | 6028.21 | 6016.01 | 6023.02 | 92048.0 |
| 2024-09-26 15:00:00 | ES | Futures | 6023.28 | 6029.51 | 6018.87 | 6024.06 | 143626.0 |
| 2024-09-26 16:00:00 | ES | Futures | 6024.32 | 6027.43 | 6023.02 | 6024.84 | 36252.0 |
| 2024-09-26 18:00:00 | ES | Futures | 6025.35 | 6033.4 | 6024.84 | 6029.77 | 6216.0 |
| 2024-09-26 19:00:00 | ES | Futures | 6029.77 | 6030.8 | 6023.54 | 6026.13 | 4698.0 |
| 2024-09-26 20:00:00 | ES | Futures | 6026.39 | 6027.17 | 6019.9 | 6025.61 | 8894.0 |
| 2024-09-26 21:00:00 | ES | Futures | 6025.61 | 6026.65 | 6017.83 | 6018.35 | 9586.0 |
| 2024-09-26 22:00:00 | ES | Futures | 6018.61 | 6020.94 | 6016.79 | 6019.39 | 7048.0 |
| 2024-09-26 23:00:00 | ES | Futures | 6019.13 | 6023.8 | 6017.31 | 6023.02 | 5170.0 |
| 2024-09-26 00:00:00 | NQ | Futures | 21253.13 | 21270.62 | 21243.22 | 21268.53 | 3475.0 |
| 2024-09-26 01:00:00 | NQ | Futures | 21269.05 | 21312.88 | 21252.61 | 21309.75 | 6786.0 |
| 2024-09-26 02:00:00 | NQ | Futures | 21308.97 | 21358.28 | 21308.97 | 21349.93 | 8881.0 |
| 2024-09-26 03:00:00 | NQ | Futures | 21351.76 | 21394.55 | 21343.67 | 21377.07 | 10075.0 |
| 2024-09-26 04:00:00 | NQ | Futures | 21377.85 | 21382.81 | 21348.11 | 21360.63 | 8277.0 |
| 2024-09-26 05:00:00 | NQ | Futures | 21360.37 | 21371.07 | 21343.15 | 21362.72 | 5439.0 |
| 2024-09-26 06:00:00 | NQ | Futures | 21361.67 | 21392.98 | 21353.85 | 21391.16 | 5153.0 |
| 2024-09-26 07:00:00 | NQ | Futures | 21392.2 | 21399.77 | 21370.55 | 21378.37 | 7792.0 |
| 2024-09-26 08:00:00 | NQ | Futures | 21379.68 | 21418.29 | 21355.67 | 21412.55 | 17347.0 |
| 2024-09-26 09:00:00 | NQ | Futures | 21412.81 | 21434.47 | 21295.66 | 21318.88 | 75513.0 |
| 2024-09-26 10:00:00 | NQ | Futures | 21319.67 | 21329.06 | 21087.72 | 21096.85 | 93381.0 |
| 2024-09-26 11:00:00 | NQ | Futures | 21096.85 | 21211.65 | 21069.19 | 21208.52 | 68314.0 |
| 2024-09-26 12:00:00 | NQ | Futures | 21208.52 | 21208.78 | 21110.94 | 21136.25 | 38555.0 |
| 2024-09-26 13:00:00 | NQ | Futures | 21135.72 | 21176.17 | 21070.24 | 21159.21 | 40970.0 |
| 2024-09-26 14:00:00 | NQ | Futures | 21158.95 | 21238.52 | 21158.95 | 21227.04 | 37798.0 |
| 2024-09-26 15:00:00 | NQ | Futures | 21226.78 | 21251.31 | 21208.52 | 21228.87 | 40922.0 |
| 2024-09-26 16:00:00 | NQ | Futures | 21228.87 | 21249.48 | 21223.65 | 21233.83 | 9607.0 |
| 2024-09-26 18:00:00 | NQ | Futures | 21233.04 | 21271.4 | 21231.48 | 21254.18 | 4111.0 |
| 2024-09-26 19:00:00 | NQ | Futures | 21254.7 | 21256.0 | 21216.87 | 21231.74 | 3302.0 |
| 2024-09-26 20:00:00 | NQ | Futures | 21232.26 | 21233.31 | 21190.78 | 21223.65 | 4722.0 |
| 2024-09-26 21:00:00 | NQ | Futures | 21223.13 | 21229.91 | 21182.69 | 21185.56 | 4029.0 |
| 2024-09-26 22:00:00 | NQ | Futures | 21185.82 | 21195.47 | 21170.16 | 21181.64 | 4065.0 |
| 2024-09-26 23:00:00 | NQ | Futures | 21181.64 | 21210.87 | 21164.69 | 21206.43 | 3254.0 |
| 2024-09-26 00:00:00 | YM | Futures | 44102.9 | 44106.0 | 44092.5 | 44100.8 | 492.0 |
| 2024-09-26 01:00:00 | YM | Futures | 44100.8 | 44151.8 | 44088.3 | 44143.5 | 1142.0 |
| 2024-09-26 02:00:00 | YM | Futures | 44143.5 | 44182.0 | 44142.5 | 44158.1 | 1911.0 |
| 2024-09-26 03:00:00 | YM | Futures | 44159.1 | 44183.1 | 44132.1 | 44178.9 | 1903.0 |
> showing 50 of 2,138 rows — these rows as CSV