PREVIEW / futures_1hour / 2024-05-27
file: by_date/futures_1hour/2024/2024-05-27.parquet size: 50 KB rows: 1,583
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-05-27 00:00:00 | ES | Futures | 5642.04 | 5643.9 | 5641.51 | 5643.9 | 997.0 |
| 2024-05-27 01:00:00 | ES | Futures | 5643.9 | 5646.29 | 5643.64 | 5646.02 | 2281.0 |
| 2024-05-27 02:00:00 | ES | Futures | 5646.29 | 5648.94 | 5644.17 | 5648.15 | 3929.0 |
| 2024-05-27 03:00:00 | ES | Futures | 5647.88 | 5648.41 | 5643.9 | 5645.76 | 4696.0 |
| 2024-05-27 04:00:00 | ES | Futures | 5646.02 | 5646.55 | 5642.31 | 5644.96 | 3114.0 |
| 2024-05-27 05:00:00 | ES | Futures | 5644.96 | 5646.55 | 5644.17 | 5644.7 | 3049.0 |
| 2024-05-27 06:00:00 | ES | Futures | 5644.96 | 5646.82 | 5644.43 | 5645.76 | 2851.0 |
| 2024-05-27 07:00:00 | ES | Futures | 5645.76 | 5647.08 | 5644.96 | 5646.55 | 1990.0 |
| 2024-05-27 08:00:00 | ES | Futures | 5646.55 | 5648.41 | 5643.9 | 5643.9 | 5147.0 |
| 2024-05-27 09:00:00 | ES | Futures | 5643.9 | 5651.06 | 5643.9 | 5645.76 | 10936.0 |
| 2024-05-27 10:00:00 | ES | Futures | 5645.76 | 5653.72 | 5643.9 | 5652.66 | 12353.0 |
| 2024-05-27 11:00:00 | ES | Futures | 5652.39 | 5657.7 | 5652.13 | 5657.43 | 9770.0 |
| 2024-05-27 12:00:00 | ES | Futures | 5657.43 | 5661.15 | 5656.1 | 5660.35 | 7477.0 |
| 2024-05-27 18:00:00 | ES | Futures | 5660.61 | 5661.41 | 5651.06 | 5655.04 | 6498.0 |
| 2024-05-27 19:00:00 | ES | Futures | 5655.04 | 5655.31 | 5651.59 | 5651.86 | 1894.0 |
| 2024-05-27 20:00:00 | ES | Futures | 5651.86 | 5652.92 | 5648.94 | 5650.27 | 5794.0 |
| 2024-05-27 21:00:00 | ES | Futures | 5650.0 | 5653.72 | 5649.74 | 5652.92 | 4861.0 |
| 2024-05-27 22:00:00 | ES | Futures | 5653.19 | 5654.25 | 5652.39 | 5653.72 | 2816.0 |
| 2024-05-27 23:00:00 | ES | Futures | 5653.72 | 5656.37 | 5653.19 | 5655.57 | 3054.0 |
| 2024-05-27 00:00:00 | NQ | Futures | 20170.61 | 20182.11 | 20167.93 | 20181.84 | 1046.0 |
| 2024-05-27 01:00:00 | NQ | Futures | 20181.31 | 20190.94 | 20179.97 | 20188.26 | 1621.0 |
| 2024-05-27 02:00:00 | NQ | Futures | 20187.99 | 20211.53 | 20179.97 | 20208.06 | 3036.0 |
| 2024-05-27 03:00:00 | NQ | Futures | 20207.79 | 20209.13 | 20189.6 | 20194.95 | 2906.0 |
| 2024-05-27 04:00:00 | NQ | Futures | 20195.75 | 20202.71 | 20183.98 | 20196.55 | 2179.0 |
| 2024-05-27 05:00:00 | NQ | Futures | 20197.62 | 20207.25 | 20190.13 | 20190.67 | 2326.0 |
| 2024-05-27 06:00:00 | NQ | Futures | 20190.4 | 20203.78 | 20187.46 | 20195.75 | 2068.0 |
| 2024-05-27 07:00:00 | NQ | Futures | 20195.48 | 20203.51 | 20192.27 | 20200.3 | 1452.0 |
| 2024-05-27 08:00:00 | NQ | Futures | 20200.3 | 20205.38 | 20190.13 | 20190.4 | 2742.0 |
| 2024-05-27 09:00:00 | NQ | Futures | 20190.13 | 20235.07 | 20189.06 | 20205.65 | 10178.0 |
| 2024-05-27 10:00:00 | NQ | Futures | 20206.18 | 20238.82 | 20197.62 | 20234.54 | 10597.0 |
| 2024-05-27 11:00:00 | NQ | Futures | 20234.27 | 20267.44 | 20233.47 | 20265.3 | 11193.0 |
| 2024-05-27 12:00:00 | NQ | Futures | 20265.04 | 20283.23 | 20259.15 | 20277.61 | 8405.0 |
| 2024-05-27 18:00:00 | NQ | Futures | 20277.34 | 20281.89 | 20228.39 | 20240.69 | 6882.0 |
| 2024-05-27 19:00:00 | NQ | Futures | 20240.69 | 20247.65 | 20228.12 | 20231.6 | 2520.0 |
| 2024-05-27 20:00:00 | NQ | Futures | 20231.6 | 20232.13 | 20207.25 | 20220.9 | 5418.0 |
| 2024-05-27 21:00:00 | NQ | Futures | 20220.36 | 20240.69 | 20216.35 | 20235.61 | 3868.0 |
| 2024-05-27 22:00:00 | NQ | Futures | 20235.61 | 20243.1 | 20232.93 | 20241.49 | 1802.0 |
| 2024-05-27 23:00:00 | NQ | Futures | 20240.96 | 20254.6 | 20237.48 | 20252.46 | 2133.0 |
| 2024-05-27 00:00:00 | YM | Futures | 41533.8 | 41543.4 | 41528.5 | 41541.2 | 201.0 |
| 2024-05-27 01:00:00 | YM | Futures | 41541.2 | 41566.7 | 41541.2 | 41565.6 | 430.0 |
| 2024-05-27 02:00:00 | YM | Futures | 41567.8 | 41572.0 | 41528.5 | 41539.1 | 1218.0 |
| 2024-05-27 03:00:00 | YM | Futures | 41539.1 | 41554.0 | 41522.1 | 41539.1 | 689.0 |
| 2024-05-27 04:00:00 | YM | Futures | 41539.1 | 41550.8 | 41517.9 | 41520.0 | 670.0 |
| 2024-05-27 05:00:00 | YM | Futures | 41520.0 | 41542.3 | 41512.6 | 41538.0 | 919.0 |
| 2024-05-27 06:00:00 | YM | Futures | 41538.0 | 41558.2 | 41535.9 | 41555.0 | 653.0 |
| 2024-05-27 07:00:00 | YM | Futures | 41554.0 | 41560.3 | 41531.7 | 41535.9 | 429.0 |
| 2024-05-27 08:00:00 | YM | Futures | 41535.9 | 41558.2 | 41528.5 | 41528.5 | 623.0 |
| 2024-05-27 09:00:00 | YM | Futures | 41528.5 | 41565.6 | 41517.9 | 41522.1 | 2518.0 |
| 2024-05-27 10:00:00 | YM | Futures | 41521.1 | 41591.1 | 41518.9 | 41581.6 | 2592.0 |
| 2024-05-27 11:00:00 | YM | Futures | 41581.6 | 41594.3 | 41561.4 | 41594.3 | 1895.0 |
> showing 50 of 1,583 rows — these rows as CSV