PREVIEW / futures_1hour / 2024-05-17
file: by_date/futures_1hour/2024/2024-05-17.parquet size: 57 KB rows: 1,678
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-17 00:00:00 | ES | Futures | 5644.17 | 5646.02 | 5643.37 | 5645.76 | 2108.0 |
| 2024-05-17 01:00:00 | ES | Futures | 5645.76 | 5646.82 | 5644.43 | 5646.29 | 3609.0 |
| 2024-05-17 02:00:00 | ES | Futures | 5646.55 | 5649.74 | 5646.29 | 5646.82 | 6866.0 |
| 2024-05-17 03:00:00 | ES | Futures | 5646.82 | 5648.94 | 5644.7 | 5645.23 | 11068.0 |
| 2024-05-17 04:00:00 | ES | Futures | 5645.23 | 5645.76 | 5638.33 | 5640.98 | 13729.0 |
| 2024-05-17 05:00:00 | ES | Futures | 5641.25 | 5647.08 | 5640.98 | 5644.17 | 11440.0 |
| 2024-05-17 06:00:00 | ES | Futures | 5644.43 | 5646.29 | 5641.78 | 5646.29 | 8402.0 |
| 2024-05-17 07:00:00 | ES | Futures | 5646.29 | 5649.74 | 5643.64 | 5647.62 | 11483.0 |
| 2024-05-17 08:00:00 | ES | Futures | 5647.35 | 5651.86 | 5646.02 | 5651.59 | 22340.0 |
| 2024-05-17 09:00:00 | ES | Futures | 5651.59 | 5651.86 | 5640.98 | 5645.49 | 133482.0 |
| 2024-05-17 10:00:00 | ES | Futures | 5645.49 | 5651.33 | 5641.25 | 5649.47 | 119618.0 |
| 2024-05-17 11:00:00 | ES | Futures | 5649.21 | 5649.47 | 5640.19 | 5646.29 | 106226.0 |
| 2024-05-17 12:00:00 | ES | Futures | 5646.29 | 5648.68 | 5637.8 | 5646.02 | 84750.0 |
| 2024-05-17 13:00:00 | ES | Futures | 5646.02 | 5647.35 | 5642.84 | 5645.23 | 64585.0 |
| 2024-05-17 14:00:00 | ES | Futures | 5645.49 | 5647.88 | 5630.37 | 5646.29 | 151316.0 |
| 2024-05-17 15:00:00 | ES | Futures | 5646.55 | 5654.78 | 5644.17 | 5653.72 | 171697.0 |
| 2024-05-17 16:00:00 | ES | Futures | 5653.45 | 5654.25 | 5649.74 | 5653.72 | 40910.0 |
| 2024-05-17 00:00:00 | NQ | Futures | 19956.6 | 19966.23 | 19952.06 | 19965.16 | 1473.0 |
| 2024-05-17 01:00:00 | NQ | Futures | 19964.9 | 19971.85 | 19960.08 | 19969.98 | 2425.0 |
| 2024-05-17 02:00:00 | NQ | Futures | 19970.51 | 19982.02 | 19963.56 | 19964.09 | 4005.0 |
| 2024-05-17 03:00:00 | NQ | Futures | 19964.36 | 19970.25 | 19949.11 | 19953.13 | 5907.0 |
| 2024-05-17 04:00:00 | NQ | Futures | 19952.86 | 19954.46 | 19920.49 | 19939.75 | 8636.0 |
| 2024-05-17 05:00:00 | NQ | Futures | 19939.75 | 19966.5 | 19939.48 | 19960.62 | 6378.0 |
| 2024-05-17 06:00:00 | NQ | Futures | 19960.62 | 19973.99 | 19952.06 | 19973.72 | 4961.0 |
| 2024-05-17 07:00:00 | NQ | Futures | 19973.99 | 19984.96 | 19961.15 | 19975.86 | 6647.0 |
| 2024-05-17 08:00:00 | NQ | Futures | 19976.13 | 19995.12 | 19969.71 | 19992.45 | 9588.0 |
| 2024-05-17 09:00:00 | NQ | Futures | 19992.98 | 19993.52 | 19924.24 | 19943.5 | 79251.0 |
| 2024-05-17 10:00:00 | NQ | Futures | 19943.5 | 19984.69 | 19925.84 | 19972.12 | 69087.0 |
| 2024-05-17 11:00:00 | NQ | Futures | 19971.85 | 19972.92 | 19925.31 | 19960.08 | 58136.0 |
| 2024-05-17 12:00:00 | NQ | Futures | 19959.81 | 19967.57 | 19910.59 | 19945.64 | 42679.0 |
| 2024-05-17 13:00:00 | NQ | Futures | 19945.9 | 19945.9 | 19912.2 | 19918.62 | 32510.0 |
| 2024-05-17 14:00:00 | NQ | Futures | 19918.88 | 19926.38 | 19843.45 | 19920.76 | 64550.0 |
| 2024-05-17 15:00:00 | NQ | Futures | 19921.29 | 19948.31 | 19911.66 | 19943.5 | 58496.0 |
| 2024-05-17 16:00:00 | NQ | Futures | 19943.23 | 19944.83 | 19924.5 | 19938.41 | 11735.0 |
| 2024-05-17 00:00:00 | YM | Futures | 42453.2 | 42459.6 | 42450.0 | 42457.5 | 352.0 |
| 2024-05-17 01:00:00 | YM | Futures | 42457.5 | 42463.8 | 42450.0 | 42460.7 | 529.0 |
| 2024-05-17 02:00:00 | YM | Futures | 42461.7 | 42488.3 | 42457.5 | 42470.2 | 1313.0 |
| 2024-05-17 03:00:00 | YM | Futures | 42471.3 | 42494.6 | 42462.8 | 42462.8 | 1428.0 |
| 2024-05-17 04:00:00 | YM | Futures | 42462.8 | 42466.0 | 42420.3 | 42442.6 | 2104.0 |
| 2024-05-17 05:00:00 | YM | Futures | 42443.7 | 42478.7 | 42442.6 | 42461.7 | 1739.0 |
| 2024-05-17 06:00:00 | YM | Futures | 42460.7 | 42475.5 | 42451.1 | 42473.4 | 1074.0 |
| 2024-05-17 07:00:00 | YM | Futures | 42472.3 | 42507.4 | 42453.2 | 42488.3 | 1372.0 |
| 2024-05-17 08:00:00 | YM | Futures | 42487.2 | 42507.4 | 42474.5 | 42503.1 | 1865.0 |
| 2024-05-17 09:00:00 | YM | Futures | 42505.3 | 42540.3 | 42439.4 | 42520.1 | 15505.0 |
| 2024-05-17 10:00:00 | YM | Futures | 42518.0 | 42535.0 | 42484.0 | 42516.9 | 10120.0 |
| 2024-05-17 11:00:00 | YM | Futures | 42516.9 | 42518.0 | 42457.5 | 42499.9 | 7571.0 |
| 2024-05-17 12:00:00 | YM | Futures | 42498.9 | 42537.1 | 42483.0 | 42535.0 | 6075.0 |
| 2024-05-17 13:00:00 | YM | Futures | 42535.0 | 42559.4 | 42516.9 | 42539.2 | 6326.0 |
| 2024-05-17 14:00:00 | YM | Futures | 42540.3 | 42569.0 | 42453.2 | 42554.1 | 10050.0 |
| 2024-05-17 15:00:00 | YM | Futures | 42554.1 | 42624.2 | 42537.1 | 42615.7 | 12850.0 |
> showing 50 of 1,678 rows — these rows as CSV