PREVIEW / futures_1hour / 2024-07-26
file: by_date/futures_1hour/2024/2024-07-26.parquet size: 56 KB rows: 1,668
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-26 00:00:00 | ES | Futures | 5727.5 | 5733.26 | 5725.92 | 5732.21 | 4051.0 |
| 2024-07-26 01:00:00 | ES | Futures | 5732.21 | 5735.1 | 5725.4 | 5725.92 | 7330.0 |
| 2024-07-26 02:00:00 | ES | Futures | 5725.92 | 5734.84 | 5725.4 | 5728.81 | 9539.0 |
| 2024-07-26 03:00:00 | ES | Futures | 5729.07 | 5741.13 | 5727.23 | 5740.87 | 22949.0 |
| 2024-07-26 04:00:00 | ES | Futures | 5741.13 | 5755.02 | 5738.51 | 5754.76 | 20979.0 |
| 2024-07-26 05:00:00 | ES | Futures | 5754.5 | 5754.76 | 5746.9 | 5748.73 | 14930.0 |
| 2024-07-26 06:00:00 | ES | Futures | 5748.73 | 5753.71 | 5745.85 | 5747.16 | 10654.0 |
| 2024-07-26 07:00:00 | ES | Futures | 5747.16 | 5755.02 | 5743.49 | 5755.02 | 16453.0 |
| 2024-07-26 08:00:00 | ES | Futures | 5754.76 | 5760.0 | 5744.54 | 5747.94 | 44165.0 |
| 2024-07-26 09:00:00 | ES | Futures | 5748.21 | 5753.97 | 5736.15 | 5750.83 | 210229.0 |
| 2024-07-26 10:00:00 | ES | Futures | 5751.35 | 5769.44 | 5737.98 | 5756.86 | 334047.0 |
| 2024-07-26 11:00:00 | ES | Futures | 5756.86 | 5773.11 | 5749.78 | 5771.8 | 199409.0 |
| 2024-07-26 12:00:00 | ES | Futures | 5772.06 | 5793.82 | 5770.75 | 5792.51 | 178197.0 |
| 2024-07-26 13:00:00 | ES | Futures | 5792.51 | 5797.23 | 5763.15 | 5772.85 | 212798.0 |
| 2024-07-26 14:00:00 | ES | Futures | 5773.11 | 5778.36 | 5756.33 | 5758.69 | 158309.0 |
| 2024-07-26 15:00:00 | ES | Futures | 5758.69 | 5774.42 | 5749.26 | 5766.82 | 348095.0 |
| 2024-07-26 16:00:00 | ES | Futures | 5766.56 | 5770.23 | 5763.15 | 5766.82 | 57398.0 |
| 2024-07-26 00:00:00 | NQ | Futures | 20140.28 | 20176.18 | 20131.57 | 20173.28 | 3103.0 |
| 2024-07-26 01:00:00 | NQ | Futures | 20173.28 | 20184.89 | 20131.31 | 20133.15 | 4077.0 |
| 2024-07-26 02:00:00 | NQ | Futures | 20133.15 | 20183.05 | 20130.78 | 20156.38 | 6547.0 |
| 2024-07-26 03:00:00 | NQ | Futures | 20155.06 | 20224.76 | 20152.16 | 20218.16 | 11008.0 |
| 2024-07-26 04:00:00 | NQ | Futures | 20217.63 | 20296.29 | 20201.79 | 20295.5 | 12392.0 |
| 2024-07-26 05:00:00 | NQ | Futures | 20294.71 | 20297.09 | 20252.47 | 20266.2 | 8140.0 |
| 2024-07-26 06:00:00 | NQ | Futures | 20266.73 | 20275.18 | 20235.31 | 20240.07 | 6945.0 |
| 2024-07-26 07:00:00 | NQ | Futures | 20240.33 | 20289.43 | 20225.81 | 20287.85 | 8412.0 |
| 2024-07-26 08:00:00 | NQ | Futures | 20286.79 | 20312.4 | 20231.09 | 20250.36 | 21610.0 |
| 2024-07-26 09:00:00 | NQ | Futures | 20251.42 | 20256.96 | 20126.55 | 20199.15 | 93692.0 |
| 2024-07-26 10:00:00 | NQ | Futures | 20199.94 | 20265.67 | 20105.17 | 20197.83 | 119892.0 |
| 2024-07-26 11:00:00 | NQ | Futures | 20197.57 | 20267.78 | 20158.23 | 20258.02 | 72375.0 |
| 2024-07-26 12:00:00 | NQ | Futures | 20258.28 | 20368.36 | 20249.83 | 20354.9 | 63702.0 |
| 2024-07-26 13:00:00 | NQ | Futures | 20355.16 | 20377.07 | 20219.48 | 20267.78 | 73251.0 |
| 2024-07-26 14:00:00 | NQ | Futures | 20268.84 | 20296.82 | 20187.01 | 20199.94 | 49646.0 |
| 2024-07-26 15:00:00 | NQ | Futures | 20199.68 | 20264.62 | 20172.49 | 20247.46 | 90227.0 |
| 2024-07-26 16:00:00 | NQ | Futures | 20247.46 | 20263.56 | 20238.75 | 20248.25 | 16279.0 |
| 2024-07-26 00:00:00 | YM | Futures | 42376.9 | 42397.9 | 42369.5 | 42387.4 | 276.0 |
| 2024-07-26 01:00:00 | YM | Futures | 42388.5 | 42402.1 | 42351.7 | 42353.8 | 556.0 |
| 2024-07-26 02:00:00 | YM | Futures | 42353.8 | 42390.6 | 42345.4 | 42352.7 | 1207.0 |
| 2024-07-26 03:00:00 | YM | Futures | 42355.9 | 42423.1 | 42332.8 | 42420.0 | 1873.0 |
| 2024-07-26 04:00:00 | YM | Futures | 42421.0 | 42449.4 | 42405.3 | 42445.2 | 2247.0 |
| 2024-07-26 05:00:00 | YM | Futures | 42444.1 | 42454.7 | 42410.5 | 42423.1 | 1328.0 |
| 2024-07-26 06:00:00 | YM | Futures | 42423.1 | 42494.6 | 42418.9 | 42487.2 | 1813.0 |
| 2024-07-26 07:00:00 | YM | Futures | 42487.2 | 42526.1 | 42463.1 | 42524.0 | 1991.0 |
| 2024-07-26 08:00:00 | YM | Futures | 42524.0 | 42551.3 | 42445.2 | 42479.9 | 4116.0 |
| 2024-07-26 09:00:00 | YM | Futures | 42482.0 | 42826.6 | 42442.0 | 42778.3 | 26398.0 |
| 2024-07-26 10:00:00 | YM | Futures | 42773.0 | 42903.3 | 42678.5 | 42850.8 | 28951.0 |
| 2024-07-26 11:00:00 | YM | Futures | 42850.8 | 42971.6 | 42797.2 | 42963.2 | 15557.0 |
| 2024-07-26 12:00:00 | YM | Futures | 42965.3 | 43063.0 | 42902.3 | 43058.8 | 14033.0 |
| 2024-07-26 13:00:00 | YM | Futures | 43058.8 | 43074.6 | 42857.1 | 42922.2 | 14374.0 |
| 2024-07-26 14:00:00 | YM | Futures | 42920.1 | 42972.7 | 42851.8 | 42873.9 | 9384.0 |
| 2024-07-26 15:00:00 | YM | Futures | 42871.8 | 42972.7 | 42808.8 | 42904.4 | 19955.0 |
> showing 50 of 1,668 rows — these rows as CSV