PREVIEW / futures_1hour / 2024-08-12
file: by_date/futures_1hour/2024/2024-08-12.parquet size: 66 KB rows: 2,072
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-08-12 00:00:00 | ES | Futures | 5630.23 | 5634.95 | 5627.87 | 5633.9 | 2377.0 |
| 2024-08-12 01:00:00 | ES | Futures | 5633.9 | 5636.26 | 5632.07 | 5634.95 | 2891.0 |
| 2024-08-12 02:00:00 | ES | Futures | 5635.21 | 5636.26 | 5628.14 | 5631.54 | 4718.0 |
| 2024-08-12 03:00:00 | ES | Futures | 5631.81 | 5644.39 | 5627.09 | 5643.6 | 13450.0 |
| 2024-08-12 04:00:00 | ES | Futures | 5643.34 | 5645.96 | 5632.33 | 5633.38 | 7765.0 |
| 2024-08-12 05:00:00 | ES | Futures | 5633.12 | 5640.2 | 5632.07 | 5636.52 | 7022.0 |
| 2024-08-12 06:00:00 | ES | Futures | 5636.52 | 5643.6 | 5633.64 | 5642.29 | 5535.0 |
| 2024-08-12 07:00:00 | ES | Futures | 5642.55 | 5649.63 | 5639.93 | 5647.01 | 11944.0 |
| 2024-08-12 08:00:00 | ES | Futures | 5646.75 | 5651.73 | 5642.03 | 5643.87 | 13903.0 |
| 2024-08-12 09:00:00 | ES | Futures | 5643.6 | 5646.49 | 5607.95 | 5612.93 | 144206.0 |
| 2024-08-12 10:00:00 | ES | Futures | 5612.93 | 5654.61 | 5610.57 | 5653.57 | 175104.0 |
| 2024-08-12 11:00:00 | ES | Futures | 5653.83 | 5659.33 | 5617.91 | 5649.37 | 200755.0 |
| 2024-08-12 12:00:00 | ES | Futures | 5649.37 | 5652.52 | 5627.09 | 5627.61 | 113941.0 |
| 2024-08-12 13:00:00 | ES | Futures | 5627.61 | 5643.08 | 5616.86 | 5623.42 | 113375.0 |
| 2024-08-12 14:00:00 | ES | Futures | 5623.68 | 5632.59 | 5621.58 | 5632.07 | 74207.0 |
| 2024-08-12 15:00:00 | ES | Futures | 5632.33 | 5634.17 | 5616.86 | 5633.12 | 180767.0 |
| 2024-08-12 16:00:00 | ES | Futures | 5632.85 | 5635.48 | 5626.82 | 5628.92 | 51811.0 |
| 2024-08-12 18:00:00 | ES | Futures | 5633.9 | 5635.21 | 5630.23 | 5631.81 | 4870.0 |
| 2024-08-12 19:00:00 | ES | Futures | 5632.07 | 5637.31 | 5629.97 | 5633.9 | 3718.0 |
| 2024-08-12 20:00:00 | ES | Futures | 5633.9 | 5640.46 | 5628.66 | 5637.05 | 7368.0 |
| 2024-08-12 21:00:00 | ES | Futures | 5637.31 | 5637.84 | 5629.71 | 5633.38 | 5728.0 |
| 2024-08-12 22:00:00 | ES | Futures | 5633.38 | 5638.1 | 5633.12 | 5638.1 | 2919.0 |
| 2024-08-12 23:00:00 | ES | Futures | 5638.1 | 5642.29 | 5636.0 | 5636.52 | 5839.0 |
| 2024-08-12 00:00:00 | NQ | Futures | 19679.1 | 19695.47 | 19658.51 | 19689.93 | 1774.0 |
| 2024-08-12 01:00:00 | NQ | Futures | 19689.13 | 19702.33 | 19677.26 | 19688.61 | 2089.0 |
| 2024-08-12 02:00:00 | NQ | Futures | 19689.13 | 19697.85 | 19651.91 | 19668.54 | 3894.0 |
| 2024-08-12 03:00:00 | NQ | Futures | 19669.86 | 19736.12 | 19642.94 | 19723.72 | 7851.0 |
| 2024-08-12 04:00:00 | NQ | Futures | 19722.92 | 19733.48 | 19670.13 | 19676.2 | 4936.0 |
| 2024-08-12 05:00:00 | NQ | Futures | 19674.88 | 19706.82 | 19668.02 | 19694.41 | 3405.0 |
| 2024-08-12 06:00:00 | NQ | Futures | 19694.68 | 19716.33 | 19675.41 | 19706.03 | 3191.0 |
| 2024-08-12 07:00:00 | NQ | Futures | 19707.09 | 19728.2 | 19682.8 | 19707.88 | 6004.0 |
| 2024-08-12 08:00:00 | NQ | Futures | 19709.73 | 19739.03 | 19694.15 | 19703.65 | 7582.0 |
| 2024-08-12 09:00:00 | NQ | Futures | 19703.65 | 19716.85 | 19559.52 | 19577.21 | 67380.0 |
| 2024-08-12 10:00:00 | NQ | Futures | 19577.73 | 19791.56 | 19567.44 | 19774.93 | 78656.0 |
| 2024-08-12 11:00:00 | NQ | Futures | 19775.46 | 19814.79 | 19615.22 | 19767.01 | 74567.0 |
| 2024-08-12 12:00:00 | NQ | Futures | 19766.75 | 19779.42 | 19662.21 | 19664.06 | 44041.0 |
| 2024-08-12 13:00:00 | NQ | Futures | 19664.32 | 19735.33 | 19625.52 | 19659.57 | 39741.0 |
| 2024-08-12 14:00:00 | NQ | Futures | 19659.83 | 19692.3 | 19638.19 | 19689.93 | 29872.0 |
| 2024-08-12 15:00:00 | NQ | Futures | 19690.45 | 19694.15 | 19620.76 | 19688.08 | 50884.0 |
| 2024-08-12 16:00:00 | NQ | Futures | 19688.61 | 19702.6 | 19658.78 | 19668.02 | 14210.0 |
| 2024-08-12 18:00:00 | NQ | Futures | 19691.25 | 19695.47 | 19670.39 | 19682.01 | 2077.0 |
| 2024-08-12 19:00:00 | NQ | Futures | 19683.33 | 19712.89 | 19674.35 | 19698.11 | 1768.0 |
| 2024-08-12 20:00:00 | NQ | Futures | 19697.58 | 19732.69 | 19679.37 | 19717.91 | 3291.0 |
| 2024-08-12 21:00:00 | NQ | Futures | 19718.17 | 19720.55 | 19681.74 | 19696.79 | 3083.0 |
| 2024-08-12 22:00:00 | NQ | Futures | 19696.26 | 19722.66 | 19695.47 | 19721.87 | 1795.0 |
| 2024-08-12 23:00:00 | NQ | Futures | 19722.66 | 19736.39 | 19709.46 | 19714.21 | 2611.0 |
| 2024-08-12 00:00:00 | YM | Futures | 41617.2 | 41647.7 | 41612.0 | 41638.2 | 321.0 |
| 2024-08-12 01:00:00 | YM | Futures | 41638.2 | 41656.1 | 41628.8 | 41646.6 | 395.0 |
| 2024-08-12 02:00:00 | YM | Futures | 41646.6 | 41655.1 | 41605.7 | 41626.7 | 958.0 |
| 2024-08-12 03:00:00 | YM | Futures | 41628.8 | 41691.8 | 41609.9 | 41679.2 | 1691.0 |
> showing 50 of 2,072 rows — these rows as CSV