PREVIEW / futures_1hour / 2024-08-13
file: by_date/futures_1hour/2024/2024-08-13.parquet size: 68 KB rows: 2,085
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-13 00:00:00 | ES | Futures | 5636.52 | 5642.55 | 5636.52 | 5641.24 | 2258.0 |
| 2024-08-13 01:00:00 | ES | Futures | 5641.24 | 5644.91 | 5639.93 | 5643.08 | 4646.0 |
| 2024-08-13 02:00:00 | ES | Futures | 5643.08 | 5650.68 | 5638.88 | 5650.68 | 5784.0 |
| 2024-08-13 03:00:00 | ES | Futures | 5650.68 | 5664.58 | 5649.37 | 5657.76 | 17509.0 |
| 2024-08-13 04:00:00 | ES | Futures | 5657.5 | 5659.33 | 5649.37 | 5652.52 | 8824.0 |
| 2024-08-13 05:00:00 | ES | Futures | 5652.25 | 5658.55 | 5648.06 | 5653.57 | 8132.0 |
| 2024-08-13 06:00:00 | ES | Futures | 5653.83 | 5654.35 | 5631.54 | 5633.38 | 17800.0 |
| 2024-08-13 07:00:00 | ES | Futures | 5633.38 | 5646.22 | 5631.81 | 5646.22 | 13760.0 |
| 2024-08-13 08:00:00 | ES | Futures | 5646.22 | 5672.44 | 5645.44 | 5666.15 | 60460.0 |
| 2024-08-13 09:00:00 | ES | Futures | 5666.15 | 5686.86 | 5656.71 | 5679.78 | 173057.0 |
| 2024-08-13 10:00:00 | ES | Futures | 5679.78 | 5687.65 | 5664.31 | 5685.81 | 178275.0 |
| 2024-08-13 11:00:00 | ES | Futures | 5685.55 | 5695.77 | 5683.45 | 5692.63 | 93842.0 |
| 2024-08-13 12:00:00 | ES | Futures | 5692.89 | 5715.44 | 5689.74 | 5714.39 | 116427.0 |
| 2024-08-13 13:00:00 | ES | Futures | 5714.13 | 5714.39 | 5697.61 | 5710.98 | 98915.0 |
| 2024-08-13 14:00:00 | ES | Futures | 5710.98 | 5718.84 | 5706.0 | 5718.06 | 78710.0 |
| 2024-08-13 15:00:00 | ES | Futures | 5718.32 | 5726.97 | 5709.93 | 5724.35 | 219763.0 |
| 2024-08-13 16:00:00 | ES | Futures | 5724.09 | 5724.87 | 5718.32 | 5720.94 | 68515.0 |
| 2024-08-13 18:00:00 | ES | Futures | 5723.04 | 5725.4 | 5718.32 | 5721.2 | 5152.0 |
| 2024-08-13 19:00:00 | ES | Futures | 5720.94 | 5724.87 | 5720.16 | 5723.3 | 2805.0 |
| 2024-08-13 20:00:00 | ES | Futures | 5723.04 | 5724.61 | 5718.84 | 5721.99 | 5291.0 |
| 2024-08-13 21:00:00 | ES | Futures | 5721.73 | 5728.28 | 5720.42 | 5726.71 | 6925.0 |
| 2024-08-13 22:00:00 | ES | Futures | 5726.71 | 5726.97 | 5717.27 | 5721.73 | 11691.0 |
| 2024-08-13 23:00:00 | ES | Futures | 5721.99 | 5725.14 | 5721.47 | 5723.3 | 4326.0 |
| 2024-08-13 00:00:00 | NQ | Futures | 19714.48 | 19742.72 | 19714.21 | 19739.29 | 2570.0 |
| 2024-08-13 01:00:00 | NQ | Futures | 19738.76 | 19758.03 | 19731.11 | 19753.28 | 3718.0 |
| 2024-08-13 02:00:00 | NQ | Futures | 19752.49 | 19793.14 | 19733.75 | 19791.82 | 4665.0 |
| 2024-08-13 03:00:00 | NQ | Futures | 19792.35 | 19869.7 | 19787.34 | 19827.2 | 12134.0 |
| 2024-08-13 04:00:00 | NQ | Futures | 19826.93 | 19831.16 | 19783.11 | 19794.46 | 7375.0 |
| 2024-08-13 05:00:00 | NQ | Futures | 19794.73 | 19812.94 | 19775.99 | 19791.56 | 5079.0 |
| 2024-08-13 06:00:00 | NQ | Futures | 19791.56 | 19793.67 | 19690.45 | 19701.01 | 11098.0 |
| 2024-08-13 07:00:00 | NQ | Futures | 19701.54 | 19760.15 | 19691.51 | 19759.09 | 8243.0 |
| 2024-08-13 08:00:00 | NQ | Futures | 19759.35 | 19877.88 | 19756.45 | 19867.32 | 27647.0 |
| 2024-08-13 09:00:00 | NQ | Futures | 19867.59 | 19969.22 | 19842.24 | 19956.29 | 71659.0 |
| 2024-08-13 10:00:00 | NQ | Futures | 19956.29 | 20011.46 | 19910.62 | 20000.37 | 71182.0 |
| 2024-08-13 11:00:00 | NQ | Futures | 20000.37 | 20060.03 | 19992.45 | 20042.34 | 45865.0 |
| 2024-08-13 12:00:00 | NQ | Futures | 20042.87 | 20141.86 | 20026.77 | 20140.54 | 51530.0 |
| 2024-08-13 13:00:00 | NQ | Futures | 20140.54 | 20155.06 | 20069.53 | 20123.39 | 43944.0 |
| 2024-08-13 14:00:00 | NQ | Futures | 20123.91 | 20152.16 | 20102.27 | 20149.52 | 29872.0 |
| 2024-08-13 15:00:00 | NQ | Futures | 20149.78 | 20181.46 | 20096.72 | 20169.58 | 60078.0 |
| 2024-08-13 16:00:00 | NQ | Futures | 20169.58 | 20192.02 | 20148.73 | 20167.47 | 18618.0 |
| 2024-08-13 18:00:00 | NQ | Futures | 20167.47 | 20197.83 | 20154.54 | 20166.15 | 3684.0 |
| 2024-08-13 19:00:00 | NQ | Futures | 20165.89 | 20190.97 | 20160.87 | 20185.95 | 2356.0 |
| 2024-08-13 20:00:00 | NQ | Futures | 20186.48 | 20193.08 | 20160.08 | 20176.71 | 3980.0 |
| 2024-08-13 21:00:00 | NQ | Futures | 20176.71 | 20224.49 | 20168.79 | 20214.99 | 5449.0 |
| 2024-08-13 22:00:00 | NQ | Futures | 20215.25 | 20218.95 | 20148.99 | 20168.53 | 6951.0 |
| 2024-08-13 23:00:00 | NQ | Futures | 20169.85 | 20188.85 | 20162.98 | 20177.24 | 2991.0 |
| 2024-08-13 00:00:00 | YM | Futures | 41542.6 | 41568.9 | 41541.6 | 41562.6 | 380.0 |
| 2024-08-13 01:00:00 | YM | Futures | 41562.6 | 41577.3 | 41539.5 | 41557.3 | 986.0 |
| 2024-08-13 02:00:00 | YM | Futures | 41557.3 | 41600.4 | 41532.1 | 41587.8 | 1214.0 |
| 2024-08-13 03:00:00 | YM | Futures | 41589.9 | 41651.9 | 41584.7 | 41622.5 | 1826.0 |
> showing 50 of 2,085 rows — these rows as CSV