PREVIEW / futures_1hour / 2024-07-04
file: by_date/futures_1hour/2024/2024-07-04.parquet size: 50 KB rows: 1,619
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-07-04 00:00:00 | ES | Futures | 5861.2 | 5861.99 | 5860.41 | 5861.72 | 1233.0 |
| 2024-07-04 01:00:00 | ES | Futures | 5861.72 | 5863.82 | 5860.68 | 5863.56 | 2321.0 |
| 2024-07-04 02:00:00 | ES | Futures | 5863.3 | 5865.39 | 5861.2 | 5863.56 | 4359.0 |
| 2024-07-04 03:00:00 | ES | Futures | 5863.56 | 5866.18 | 5861.99 | 5865.92 | 6520.0 |
| 2024-07-04 04:00:00 | ES | Futures | 5865.92 | 5866.44 | 5863.82 | 5865.39 | 6426.0 |
| 2024-07-04 05:00:00 | ES | Futures | 5865.39 | 5867.23 | 5864.87 | 5866.18 | 4355.0 |
| 2024-07-04 06:00:00 | ES | Futures | 5865.92 | 5868.02 | 5864.61 | 5866.44 | 3397.0 |
| 2024-07-04 07:00:00 | ES | Futures | 5866.7 | 5868.02 | 5866.18 | 5866.97 | 4657.0 |
| 2024-07-04 08:00:00 | ES | Futures | 5866.7 | 5868.54 | 5866.44 | 5868.54 | 3477.0 |
| 2024-07-04 09:00:00 | ES | Futures | 5868.54 | 5869.33 | 5860.41 | 5860.41 | 13839.0 |
| 2024-07-04 10:00:00 | ES | Futures | 5860.68 | 5861.2 | 5857.0 | 5859.1 | 14920.0 |
| 2024-07-04 11:00:00 | ES | Futures | 5859.1 | 5861.99 | 5858.84 | 5860.94 | 8807.0 |
| 2024-07-04 12:00:00 | ES | Futures | 5860.68 | 5860.94 | 5858.58 | 5860.41 | 3154.0 |
| 2024-07-04 18:00:00 | ES | Futures | 5859.63 | 5861.46 | 5858.05 | 5859.36 | 2795.0 |
| 2024-07-04 19:00:00 | ES | Futures | 5859.63 | 5861.99 | 5859.36 | 5860.15 | 1453.0 |
| 2024-07-04 20:00:00 | ES | Futures | 5860.15 | 5865.39 | 5860.15 | 5863.56 | 4241.0 |
| 2024-07-04 21:00:00 | ES | Futures | 5863.56 | 5864.35 | 5862.51 | 5863.56 | 2340.0 |
| 2024-07-04 22:00:00 | ES | Futures | 5863.56 | 5864.87 | 5862.51 | 5864.35 | 2717.0 |
| 2024-07-04 23:00:00 | ES | Futures | 5864.35 | 5865.92 | 5863.3 | 5865.39 | 2782.0 |
| 2024-07-04 00:00:00 | NQ | Futures | 21545.2 | 21548.36 | 21538.07 | 21543.35 | 1162.0 |
| 2024-07-04 01:00:00 | NQ | Futures | 21543.08 | 21549.95 | 21537.01 | 21549.16 | 1236.0 |
| 2024-07-04 02:00:00 | NQ | Futures | 21549.16 | 21551.27 | 21541.76 | 21547.31 | 1783.0 |
| 2024-07-04 03:00:00 | NQ | Futures | 21547.04 | 21551.53 | 21538.86 | 21547.84 | 2817.0 |
| 2024-07-04 04:00:00 | NQ | Futures | 21548.63 | 21549.16 | 21537.54 | 21539.92 | 2621.0 |
| 2024-07-04 05:00:00 | NQ | Futures | 21540.44 | 21547.04 | 21536.75 | 21543.08 | 1772.0 |
| 2024-07-04 06:00:00 | NQ | Futures | 21543.08 | 21548.63 | 21538.86 | 21544.14 | 1483.0 |
| 2024-07-04 07:00:00 | NQ | Futures | 21544.4 | 21547.84 | 21543.35 | 21545.2 | 1346.0 |
| 2024-07-04 08:00:00 | NQ | Futures | 21545.2 | 21549.95 | 21542.82 | 21547.84 | 1245.0 |
| 2024-07-04 09:00:00 | NQ | Futures | 21548.36 | 21551.53 | 21522.23 | 21524.87 | 7512.0 |
| 2024-07-04 10:00:00 | NQ | Futures | 21524.87 | 21526.98 | 21509.03 | 21515.1 | 9463.0 |
| 2024-07-04 11:00:00 | NQ | Futures | 21515.37 | 21534.37 | 21514.57 | 21526.45 | 6937.0 |
| 2024-07-04 12:00:00 | NQ | Futures | 21526.19 | 21528.56 | 21513.25 | 21521.17 | 3783.0 |
| 2024-07-04 18:00:00 | NQ | Futures | 21521.17 | 21531.2 | 21499.79 | 21524.61 | 2416.0 |
| 2024-07-04 19:00:00 | NQ | Futures | 21524.87 | 21537.54 | 21523.55 | 21530.94 | 1573.0 |
| 2024-07-04 20:00:00 | NQ | Futures | 21531.47 | 21551.53 | 21531.47 | 21545.72 | 2985.0 |
| 2024-07-04 21:00:00 | NQ | Futures | 21545.46 | 21552.59 | 21542.82 | 21548.36 | 1547.0 |
| 2024-07-04 22:00:00 | NQ | Futures | 21548.36 | 21554.44 | 21541.76 | 21549.95 | 1514.0 |
| 2024-07-04 23:00:00 | NQ | Futures | 21550.21 | 21561.03 | 21544.67 | 21555.23 | 2157.0 |
| 2024-07-04 00:00:00 | YM | Futures | 41641.4 | 41650.9 | 41637.2 | 41649.8 | 254.0 |
| 2024-07-04 01:00:00 | YM | Futures | 41648.7 | 41663.5 | 41642.4 | 41662.4 | 416.0 |
| 2024-07-04 02:00:00 | YM | Futures | 41661.4 | 41671.9 | 41631.9 | 41665.6 | 894.0 |
| 2024-07-04 03:00:00 | YM | Futures | 41667.7 | 41701.3 | 41657.2 | 41700.2 | 1334.0 |
| 2024-07-04 04:00:00 | YM | Futures | 41701.3 | 41733.9 | 41700.2 | 41722.3 | 1289.0 |
| 2024-07-04 05:00:00 | YM | Futures | 41723.4 | 41738.1 | 41718.1 | 41722.3 | 689.0 |
| 2024-07-04 06:00:00 | YM | Futures | 41723.4 | 41748.6 | 41716.0 | 41743.3 | 511.0 |
| 2024-07-04 07:00:00 | YM | Futures | 41745.4 | 41763.3 | 41739.1 | 41749.6 | 876.0 |
| 2024-07-04 08:00:00 | YM | Futures | 41749.6 | 41775.9 | 41748.6 | 41775.9 | 1100.0 |
| 2024-07-04 09:00:00 | YM | Futures | 41775.9 | 41799.0 | 41671.9 | 41672.9 | 4038.0 |
| 2024-07-04 10:00:00 | YM | Futures | 41674.0 | 41681.3 | 41639.3 | 41668.7 | 2379.0 |
| 2024-07-04 11:00:00 | YM | Futures | 41669.8 | 41707.6 | 41666.6 | 41702.3 | 1838.0 |
> showing 50 of 1,619 rows — these rows as CSV