PREVIEW / futures_1hour / 2024-08-02
file: by_date/futures_1hour/2024/2024-08-02.parquet size: 61 KB rows: 1,719
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-02 00:00:00 | ES | Futures | 5707.31 | 5708.62 | 5699.97 | 5703.38 | 7779.0 |
| 2024-08-02 01:00:00 | ES | Futures | 5703.38 | 5709.93 | 5696.56 | 5701.02 | 11677.0 |
| 2024-08-02 02:00:00 | ES | Futures | 5701.28 | 5704.16 | 5686.6 | 5687.12 | 28384.0 |
| 2024-08-02 03:00:00 | ES | Futures | 5687.12 | 5697.35 | 5675.85 | 5695.51 | 44357.0 |
| 2024-08-02 04:00:00 | ES | Futures | 5695.51 | 5697.61 | 5682.14 | 5695.77 | 26937.0 |
| 2024-08-02 05:00:00 | ES | Futures | 5695.51 | 5696.3 | 5679.0 | 5680.57 | 18742.0 |
| 2024-08-02 06:00:00 | ES | Futures | 5680.31 | 5690.01 | 5672.18 | 5682.93 | 29182.0 |
| 2024-08-02 07:00:00 | ES | Futures | 5682.93 | 5687.91 | 5676.9 | 5679.78 | 25323.0 |
| 2024-08-02 08:00:00 | ES | Futures | 5679.78 | 5699.18 | 5638.1 | 5655.4 | 170237.0 |
| 2024-08-02 09:00:00 | ES | Futures | 5655.14 | 5680.83 | 5648.06 | 5650.68 | 388802.0 |
| 2024-08-02 10:00:00 | ES | Futures | 5650.68 | 5659.33 | 5595.89 | 5598.51 | 584006.0 |
| 2024-08-02 11:00:00 | ES | Futures | 5598.51 | 5635.74 | 5591.17 | 5628.92 | 431310.0 |
| 2024-08-02 12:00:00 | ES | Futures | 5628.92 | 5643.6 | 5612.14 | 5618.96 | 306183.0 |
| 2024-08-02 13:00:00 | ES | Futures | 5618.96 | 5627.61 | 5602.18 | 5608.47 | 227840.0 |
| 2024-08-02 14:00:00 | ES | Futures | 5608.21 | 5631.81 | 5601.13 | 5615.55 | 208371.0 |
| 2024-08-02 15:00:00 | ES | Futures | 5615.55 | 5640.2 | 5611.36 | 5637.84 | 404947.0 |
| 2024-08-02 16:00:00 | ES | Futures | 5638.1 | 5638.36 | 5617.65 | 5618.7 | 104562.0 |
| 2024-08-02 00:00:00 | NQ | Futures | 19841.45 | 19846.73 | 19792.88 | 19812.94 | 2543.0 |
| 2024-08-02 01:00:00 | NQ | Futures | 19816.64 | 19854.39 | 19791.56 | 19814.53 | 4674.0 |
| 2024-08-02 02:00:00 | NQ | Futures | 19814.53 | 19833.53 | 19742.72 | 19749.85 | 10645.0 |
| 2024-08-02 03:00:00 | NQ | Futures | 19749.59 | 19798.42 | 19683.86 | 19797.63 | 16151.0 |
| 2024-08-02 04:00:00 | NQ | Futures | 19797.1 | 19811.62 | 19717.38 | 19777.57 | 11322.0 |
| 2024-08-02 05:00:00 | NQ | Futures | 19777.04 | 19779.68 | 19700.49 | 19728.2 | 8264.0 |
| 2024-08-02 06:00:00 | NQ | Futures | 19728.73 | 19788.66 | 19688.08 | 19758.56 | 12846.0 |
| 2024-08-02 07:00:00 | NQ | Futures | 19759.88 | 19782.58 | 19713.42 | 19718.96 | 10444.0 |
| 2024-08-02 08:00:00 | NQ | Futures | 19718.17 | 19810.83 | 19543.68 | 19624.2 | 52837.0 |
| 2024-08-02 09:00:00 | NQ | Futures | 19623.93 | 19810.3 | 19579.05 | 19613.9 | 120334.0 |
| 2024-08-02 10:00:00 | NQ | Futures | 19615.75 | 19662.21 | 19414.07 | 19455.77 | 141629.0 |
| 2024-08-02 11:00:00 | NQ | Futures | 19456.3 | 19671.98 | 19433.86 | 19634.23 | 100149.0 |
| 2024-08-02 12:00:00 | NQ | Futures | 19633.43 | 19675.14 | 19515.96 | 19543.15 | 75728.0 |
| 2024-08-02 13:00:00 | NQ | Futures | 19542.89 | 19597.27 | 19476.63 | 19526.26 | 52493.0 |
| 2024-08-02 14:00:00 | NQ | Futures | 19526.52 | 19627.89 | 19484.02 | 19534.97 | 53468.0 |
| 2024-08-02 15:00:00 | NQ | Futures | 19536.82 | 19619.71 | 19493.52 | 19598.85 | 81816.0 |
| 2024-08-02 16:00:00 | NQ | Futures | 19599.91 | 19604.4 | 19535.76 | 19548.7 | 16002.0 |
| 2024-08-02 00:00:00 | YM | Futures | 42390.6 | 42395.8 | 42352.7 | 42365.3 | 823.0 |
| 2024-08-02 01:00:00 | YM | Futures | 42371.6 | 42404.2 | 42326.5 | 42347.5 | 1270.0 |
| 2024-08-02 02:00:00 | YM | Futures | 42349.6 | 42376.9 | 42263.4 | 42267.6 | 3225.0 |
| 2024-08-02 03:00:00 | YM | Futures | 42266.6 | 42353.8 | 42223.5 | 42302.3 | 4425.0 |
| 2024-08-02 04:00:00 | YM | Futures | 42300.2 | 42359.0 | 42273.9 | 42353.8 | 3405.0 |
| 2024-08-02 05:00:00 | YM | Futures | 42351.7 | 42354.8 | 42214.0 | 42215.1 | 2101.0 |
| 2024-08-02 06:00:00 | YM | Futures | 42216.1 | 42238.2 | 42148.9 | 42175.2 | 3141.0 |
| 2024-08-02 07:00:00 | YM | Futures | 42177.3 | 42250.8 | 42155.2 | 42238.2 | 3045.0 |
| 2024-08-02 08:00:00 | YM | Futures | 42240.3 | 42353.8 | 41974.5 | 42064.8 | 13204.0 |
| 2024-08-02 09:00:00 | YM | Futures | 42063.8 | 42278.1 | 42019.7 | 42079.5 | 32540.0 |
| 2024-08-02 10:00:00 | YM | Futures | 42078.5 | 42158.4 | 41624.6 | 41660.3 | 40284.0 |
| 2024-08-02 11:00:00 | YM | Futures | 41660.3 | 41724.4 | 41522.7 | 41684.5 | 24988.0 |
| 2024-08-02 12:00:00 | YM | Futures | 41683.4 | 41830.5 | 41662.4 | 41744.4 | 17426.0 |
| 2024-08-02 13:00:00 | YM | Futures | 41745.4 | 41766.4 | 41605.7 | 41631.9 | 11609.0 |
| 2024-08-02 14:00:00 | YM | Futures | 41629.8 | 41798.0 | 41582.6 | 41751.7 | 10863.0 |
| 2024-08-02 15:00:00 | YM | Futures | 41752.8 | 41916.7 | 41721.2 | 41899.9 | 21231.0 |
> showing 50 of 1,719 rows — these rows as CSV