PREVIEW / futures_30min / 2024-07-04
file: by_date/futures_30min/2024/2024-07-04.parquet size: 77 KB rows: 3,051
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.46 | 730.0 |
| 2024-07-04 00:30:00 | ES | Futures | 5861.72 | 5861.99 | 5860.68 | 5861.72 | 503.0 |
| 2024-07-04 01:00:00 | ES | Futures | 5861.72 | 5862.25 | 5860.68 | 5861.99 | 835.0 |
| 2024-07-04 01:30:00 | ES | Futures | 5861.99 | 5863.82 | 5861.72 | 5863.56 | 1486.0 |
| 2024-07-04 02:00:00 | ES | Futures | 5863.3 | 5863.56 | 5861.2 | 5861.46 | 2135.0 |
| 2024-07-04 02:30:00 | ES | Futures | 5861.46 | 5865.39 | 5861.46 | 5863.56 | 2224.0 |
| 2024-07-04 03:00:00 | ES | Futures | 5863.56 | 5865.66 | 5863.03 | 5863.56 | 3530.0 |
| 2024-07-04 03:30:00 | ES | Futures | 5863.56 | 5866.18 | 5861.99 | 5865.92 | 2990.0 |
| 2024-07-04 04:00:00 | ES | Futures | 5865.92 | 5866.44 | 5864.08 | 5866.18 | 3441.0 |
| 2024-07-04 04:30:00 | ES | Futures | 5865.92 | 5866.18 | 5863.82 | 5865.39 | 2985.0 |
| 2024-07-04 05:00:00 | ES | Futures | 5865.39 | 5867.23 | 5864.87 | 5866.44 | 2679.0 |
| 2024-07-04 05:30:00 | ES | Futures | 5866.44 | 5867.23 | 5865.39 | 5866.18 | 1676.0 |
| 2024-07-04 06:00:00 | ES | Futures | 5865.92 | 5866.18 | 5864.87 | 5864.87 | 1199.0 |
| 2024-07-04 06:30:00 | ES | Futures | 5865.13 | 5868.02 | 5864.61 | 5866.44 | 2198.0 |
| 2024-07-04 07:00:00 | ES | Futures | 5866.7 | 5868.02 | 5866.18 | 5866.97 | 2363.0 |
| 2024-07-04 07:30:00 | ES | Futures | 5866.7 | 5868.02 | 5866.7 | 5866.97 | 2294.0 |
| 2024-07-04 08:00:00 | ES | Futures | 5866.7 | 5867.75 | 5866.44 | 5867.49 | 1651.0 |
| 2024-07-04 08:30:00 | ES | Futures | 5867.49 | 5868.54 | 5866.97 | 5868.54 | 1826.0 |
| 2024-07-04 09:00:00 | ES | Futures | 5868.54 | 5869.33 | 5867.23 | 5867.49 | 3298.0 |
| 2024-07-04 09:30:00 | ES | Futures | 5867.49 | 5867.75 | 5860.41 | 5860.41 | 10541.0 |
| 2024-07-04 10:00:00 | ES | Futures | 5860.68 | 5861.2 | 5857.0 | 5858.05 | 8820.0 |
| 2024-07-04 10:30:00 | ES | Futures | 5858.05 | 5859.36 | 5857.0 | 5859.1 | 6100.0 |
| 2024-07-04 11:00:00 | ES | Futures | 5859.1 | 5861.99 | 5858.84 | 5860.94 | 6297.0 |
| 2024-07-04 11:30:00 | ES | Futures | 5860.94 | 5861.72 | 5860.15 | 5860.94 | 2510.0 |
| 2024-07-04 12:00:00 | ES | Futures | 5860.68 | 5860.94 | 5858.58 | 5859.1 | 1539.0 |
| 2024-07-04 12:30:00 | ES | Futures | 5859.36 | 5860.41 | 5858.84 | 5860.41 | 1615.0 |
| 2024-07-04 18:00:00 | ES | Futures | 5859.63 | 5861.46 | 5858.05 | 5859.36 | 2310.0 |
| 2024-07-04 18:30:00 | ES | Futures | 5859.63 | 5860.41 | 5858.84 | 5859.36 | 485.0 |
| 2024-07-04 19:00:00 | ES | Futures | 5859.63 | 5861.46 | 5859.36 | 5861.46 | 714.0 |
| 2024-07-04 19:30:00 | ES | Futures | 5861.2 | 5861.99 | 5859.89 | 5860.15 | 739.0 |
| 2024-07-04 20:00:00 | ES | Futures | 5860.15 | 5862.77 | 5860.15 | 5862.25 | 2029.0 |
| 2024-07-04 20:30:00 | ES | Futures | 5862.25 | 5865.39 | 5861.99 | 5863.56 | 2212.0 |
| 2024-07-04 21:00:00 | ES | Futures | 5863.56 | 5864.35 | 5862.77 | 5863.3 | 1255.0 |
| 2024-07-04 21:30:00 | ES | Futures | 5863.3 | 5864.35 | 5862.51 | 5863.56 | 1085.0 |
| 2024-07-04 22:00:00 | ES | Futures | 5863.56 | 5864.61 | 5862.51 | 5864.61 | 1466.0 |
| 2024-07-04 22:30:00 | ES | Futures | 5864.35 | 5864.87 | 5863.3 | 5864.35 | 1251.0 |
| 2024-07-04 23:00:00 | ES | Futures | 5864.35 | 5865.13 | 5863.3 | 5865.13 | 1511.0 |
| 2024-07-04 23:30:00 | ES | Futures | 5865.13 | 5865.92 | 5864.61 | 5865.39 | 1271.0 |
| 2024-07-04 00:00:00 | NQ | Futures | 21545.2 | 21548.36 | 21541.76 | 21544.67 | 553.0 |
| 2024-07-04 00:30:00 | NQ | Futures | 21545.72 | 21546.52 | 21538.07 | 21543.35 | 609.0 |
| 2024-07-04 01:00:00 | NQ | Futures | 21543.08 | 21545.99 | 21537.01 | 21544.4 | 596.0 |
| 2024-07-04 01:30:00 | NQ | Futures | 21544.14 | 21549.95 | 21540.44 | 21549.16 | 640.0 |
| 2024-07-04 02:00:00 | NQ | Futures | 21549.16 | 21550.21 | 21541.76 | 21544.14 | 980.0 |
| 2024-07-04 02:30:00 | NQ | Futures | 21544.14 | 21551.27 | 21543.08 | 21547.31 | 803.0 |
| 2024-07-04 03:00:00 | NQ | Futures | 21547.04 | 21551.53 | 21542.29 | 21544.4 | 1382.0 |
| 2024-07-04 03:30:00 | NQ | Futures | 21545.46 | 21549.42 | 21538.86 | 21547.84 | 1435.0 |
| 2024-07-04 04:00:00 | NQ | Futures | 21548.63 | 21549.16 | 21537.8 | 21545.72 | 1365.0 |
| 2024-07-04 04:30:00 | NQ | Futures | 21545.46 | 21545.99 | 21537.54 | 21539.92 | 1256.0 |
| 2024-07-04 05:00:00 | NQ | Futures | 21540.44 | 21544.67 | 21536.75 | 21541.24 | 979.0 |
| 2024-07-04 05:30:00 | NQ | Futures | 21541.24 | 21547.04 | 21539.12 | 21543.08 | 793.0 |
> showing 50 of 3,051 rows — these rows as CSV