PREVIEW / futures_1hour / 2024-07-03
file: by_date/futures_1hour/2024/2024-07-03.parquet size: 64 KB rows: 1,978
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-03 00:00:00 | ES | Futures | 5832.1 | 5834.98 | 5831.84 | 5834.46 | 2370.0 |
| 2024-07-03 01:00:00 | ES | Futures | 5834.46 | 5834.72 | 5832.36 | 5833.67 | 4809.0 |
| 2024-07-03 02:00:00 | ES | Futures | 5833.93 | 5837.08 | 5833.67 | 5835.51 | 9010.0 |
| 2024-07-03 03:00:00 | ES | Futures | 5835.77 | 5839.44 | 5833.93 | 5836.03 | 11805.0 |
| 2024-07-03 04:00:00 | ES | Futures | 5836.29 | 5843.37 | 5834.72 | 5840.23 | 13914.0 |
| 2024-07-03 05:00:00 | ES | Futures | 5840.23 | 5842.32 | 5839.44 | 5841.27 | 8433.0 |
| 2024-07-03 06:00:00 | ES | Futures | 5841.27 | 5842.59 | 5839.7 | 5840.49 | 8657.0 |
| 2024-07-03 07:00:00 | ES | Futures | 5840.75 | 5842.32 | 5837.08 | 5839.7 | 13066.0 |
| 2024-07-03 08:00:00 | ES | Futures | 5839.44 | 5840.49 | 5830.53 | 5831.84 | 34647.0 |
| 2024-07-03 09:00:00 | ES | Futures | 5831.84 | 5845.73 | 5831.31 | 5845.21 | 111086.0 |
| 2024-07-03 10:00:00 | ES | Futures | 5845.21 | 5851.5 | 5837.6 | 5847.04 | 160977.0 |
| 2024-07-03 11:00:00 | ES | Futures | 5847.3 | 5854.12 | 5843.37 | 5852.55 | 116722.0 |
| 2024-07-03 12:00:00 | ES | Futures | 5852.55 | 5868.02 | 5852.02 | 5863.03 | 178654.0 |
| 2024-07-03 13:00:00 | ES | Futures | 5863.3 | 5864.61 | 5861.2 | 5863.03 | 33724.0 |
| 2024-07-03 18:00:00 | ES | Futures | 5863.03 | 5863.82 | 5858.05 | 5861.46 | 4517.0 |
| 2024-07-03 19:00:00 | ES | Futures | 5861.46 | 5864.35 | 5861.46 | 5862.77 | 2034.0 |
| 2024-07-03 20:00:00 | ES | Futures | 5862.77 | 5863.82 | 5860.68 | 5861.99 | 2449.0 |
| 2024-07-03 21:00:00 | ES | Futures | 5861.72 | 5864.35 | 5860.68 | 5861.46 | 2660.0 |
| 2024-07-03 22:00:00 | ES | Futures | 5861.2 | 5862.25 | 5859.89 | 5860.68 | 2345.0 |
| 2024-07-03 23:00:00 | ES | Futures | 5860.94 | 5862.51 | 5859.63 | 5860.94 | 1244.0 |
| 2024-07-03 00:00:00 | NQ | Futures | 21367.54 | 21378.36 | 21366.48 | 21376.51 | 1212.0 |
| 2024-07-03 01:00:00 | NQ | Futures | 21376.78 | 21381.79 | 21373.87 | 21380.47 | 2267.0 |
| 2024-07-03 02:00:00 | NQ | Futures | 21380.21 | 21396.57 | 21372.29 | 21375.98 | 5501.0 |
| 2024-07-03 03:00:00 | NQ | Futures | 21376.51 | 21388.39 | 21365.95 | 21373.61 | 6171.0 |
| 2024-07-03 04:00:00 | NQ | Futures | 21373.34 | 21418.22 | 21365.69 | 21399.74 | 8448.0 |
| 2024-07-03 05:00:00 | NQ | Futures | 21400.53 | 21412.41 | 21388.39 | 21404.76 | 5335.0 |
| 2024-07-03 06:00:00 | NQ | Futures | 21403.7 | 21405.02 | 21389.45 | 21389.71 | 3887.0 |
| 2024-07-03 07:00:00 | NQ | Futures | 21389.97 | 21397.1 | 21369.91 | 21383.11 | 6713.0 |
| 2024-07-03 08:00:00 | NQ | Futures | 21382.32 | 21389.71 | 21335.07 | 21349.85 | 18179.0 |
| 2024-07-03 09:00:00 | NQ | Futures | 21349.85 | 21418.48 | 21337.18 | 21408.19 | 76826.0 |
| 2024-07-03 10:00:00 | NQ | Futures | 21409.24 | 21457.29 | 21367.27 | 21449.11 | 90910.0 |
| 2024-07-03 11:00:00 | NQ | Futures | 21449.37 | 21522.49 | 21427.46 | 21519.33 | 68550.0 |
| 2024-07-03 12:00:00 | NQ | Futures | 21519.06 | 21565.79 | 21509.03 | 21556.28 | 69850.0 |
| 2024-07-03 13:00:00 | NQ | Futures | 21556.28 | 21578.19 | 21546.78 | 21561.56 | 11067.0 |
| 2024-07-03 18:00:00 | NQ | Futures | 21561.3 | 21562.62 | 21530.68 | 21540.18 | 2870.0 |
| 2024-07-03 19:00:00 | NQ | Futures | 21539.92 | 21552.85 | 21538.86 | 21543.88 | 1106.0 |
| 2024-07-03 20:00:00 | NQ | Futures | 21544.14 | 21550.74 | 21537.8 | 21545.99 | 1681.0 |
| 2024-07-03 21:00:00 | NQ | Futures | 21545.46 | 21559.19 | 21538.86 | 21548.36 | 1761.0 |
| 2024-07-03 22:00:00 | NQ | Futures | 21548.1 | 21551.53 | 21541.76 | 21545.46 | 1117.0 |
| 2024-07-03 23:00:00 | NQ | Futures | 21545.46 | 21549.68 | 21539.92 | 21544.67 | 999.0 |
| 2024-07-03 00:00:00 | YM | Futures | 41653.0 | 41671.9 | 41650.9 | 41664.5 | 436.0 |
| 2024-07-03 01:00:00 | YM | Futures | 41664.5 | 41666.6 | 41649.8 | 41656.1 | 769.0 |
| 2024-07-03 02:00:00 | YM | Futures | 41657.2 | 41699.2 | 41656.1 | 41693.9 | 1500.0 |
| 2024-07-03 03:00:00 | YM | Futures | 41695.0 | 41740.2 | 41678.2 | 41721.2 | 1762.0 |
| 2024-07-03 04:00:00 | YM | Futures | 41720.2 | 41751.7 | 41707.6 | 41742.3 | 2340.0 |
| 2024-07-03 05:00:00 | YM | Futures | 41742.3 | 41759.1 | 41738.1 | 41753.8 | 1200.0 |
| 2024-07-03 06:00:00 | YM | Futures | 41752.8 | 41771.7 | 41746.5 | 41754.9 | 1154.0 |
| 2024-07-03 07:00:00 | YM | Futures | 41755.9 | 41762.2 | 41724.4 | 41732.8 | 1778.0 |
| 2024-07-03 08:00:00 | YM | Futures | 41733.9 | 41738.1 | 41666.6 | 41682.4 | 3120.0 |
| 2024-07-03 09:00:00 | YM | Futures | 41681.3 | 41780.1 | 41643.5 | 41713.9 | 18849.0 |
> showing 50 of 1,978 rows — these rows as CSV