PREVIEW / futures_1hour / 2024-03-28
file: by_date/futures_1hour/2024/2024-03-28.parquet size: 55 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-03-28 00:00:00 | ES | Futures | 5629.31 | 5631.96 | 5628.78 | 5630.9 | 2954.0 |
| 2024-03-28 01:00:00 | ES | Futures | 5631.17 | 5633.02 | 5629.84 | 5632.23 | 5697.0 |
| 2024-03-28 02:00:00 | ES | Futures | 5632.23 | 5632.23 | 5628.51 | 5629.57 | 3970.0 |
| 2024-03-28 03:00:00 | ES | Futures | 5629.57 | 5630.37 | 5627.19 | 5629.84 | 6685.0 |
| 2024-03-28 04:00:00 | ES | Futures | 5629.84 | 5631.43 | 5627.19 | 5628.78 | 12664.0 |
| 2024-03-28 05:00:00 | ES | Futures | 5628.78 | 5631.7 | 5625.33 | 5627.98 | 11311.0 |
| 2024-03-28 06:00:00 | ES | Futures | 5627.98 | 5633.02 | 5627.72 | 5629.57 | 9737.0 |
| 2024-03-28 07:00:00 | ES | Futures | 5629.57 | 5632.49 | 5626.39 | 5630.37 | 13956.0 |
| 2024-03-28 08:00:00 | ES | Futures | 5630.37 | 5637.53 | 5627.72 | 5633.29 | 33415.0 |
| 2024-03-28 09:00:00 | ES | Futures | 5633.55 | 5639.66 | 5629.57 | 5634.88 | 121916.0 |
| 2024-03-28 10:00:00 | ES | Futures | 5634.88 | 5640.19 | 5631.96 | 5637.53 | 122044.0 |
| 2024-03-28 11:00:00 | ES | Futures | 5637.53 | 5641.51 | 5634.88 | 5639.92 | 96687.0 |
| 2024-03-28 12:00:00 | ES | Futures | 5639.92 | 5639.92 | 5632.49 | 5634.88 | 86457.0 |
| 2024-03-28 13:00:00 | ES | Futures | 5634.88 | 5635.94 | 5629.57 | 5634.08 | 76299.0 |
| 2024-03-28 14:00:00 | ES | Futures | 5634.08 | 5643.37 | 5629.84 | 5641.78 | 87600.0 |
| 2024-03-28 15:00:00 | ES | Futures | 5641.78 | 5646.55 | 5627.72 | 5629.84 | 308305.0 |
| 2024-03-28 16:00:00 | ES | Futures | 5630.11 | 5633.02 | 5626.39 | 5628.78 | 90358.0 |
| 2024-03-28 00:00:00 | NQ | Futures | 19788.61 | 19800.92 | 19787.27 | 19796.37 | 1412.0 |
| 2024-03-28 01:00:00 | NQ | Futures | 19796.37 | 19805.46 | 19789.68 | 19799.04 | 2468.0 |
| 2024-03-28 02:00:00 | NQ | Futures | 19800.11 | 19800.11 | 19781.66 | 19790.75 | 2566.0 |
| 2024-03-28 03:00:00 | NQ | Futures | 19790.22 | 19805.46 | 19776.84 | 19800.65 | 4475.0 |
| 2024-03-28 04:00:00 | NQ | Futures | 19801.18 | 19811.08 | 19772.29 | 19776.04 | 7573.0 |
| 2024-03-28 05:00:00 | NQ | Futures | 19775.5 | 19787.81 | 19751.69 | 19772.83 | 7417.0 |
| 2024-03-28 06:00:00 | NQ | Futures | 19772.83 | 19802.25 | 19772.03 | 19783.26 | 6672.0 |
| 2024-03-28 07:00:00 | NQ | Futures | 19782.99 | 19798.24 | 19768.01 | 19785.94 | 6635.0 |
| 2024-03-28 08:00:00 | NQ | Futures | 19786.47 | 19824.99 | 19767.48 | 19794.5 | 20577.0 |
| 2024-03-28 09:00:00 | NQ | Futures | 19794.5 | 19834.89 | 19749.55 | 19809.21 | 81468.0 |
| 2024-03-28 10:00:00 | NQ | Futures | 19810.28 | 19836.76 | 19770.15 | 19801.45 | 75619.0 |
| 2024-03-28 11:00:00 | NQ | Futures | 19801.72 | 19815.63 | 19782.46 | 19812.95 | 49508.0 |
| 2024-03-28 12:00:00 | NQ | Futures | 19813.22 | 19814.56 | 19765.61 | 19776.31 | 45012.0 |
| 2024-03-28 13:00:00 | NQ | Futures | 19776.31 | 19777.64 | 19746.08 | 19762.66 | 35610.0 |
| 2024-03-28 14:00:00 | NQ | Futures | 19762.4 | 19801.99 | 19740.46 | 19793.96 | 42021.0 |
| 2024-03-28 15:00:00 | NQ | Futures | 19793.96 | 19806.8 | 19750.09 | 19755.71 | 76492.0 |
| 2024-03-28 16:00:00 | NQ | Futures | 19755.17 | 19769.89 | 19739.12 | 19757.85 | 19076.0 |
| 2024-03-28 00:00:00 | YM | Futures | 42582.8 | 42599.7 | 42578.5 | 42595.5 | 680.0 |
| 2024-03-28 01:00:00 | YM | Futures | 42594.4 | 42605.1 | 42588.1 | 42600.8 | 624.0 |
| 2024-03-28 02:00:00 | YM | Futures | 42600.8 | 42602.9 | 42583.8 | 42592.3 | 454.0 |
| 2024-03-28 03:00:00 | YM | Futures | 42593.4 | 42597.6 | 42569.0 | 42577.4 | 1318.0 |
| 2024-03-28 04:00:00 | YM | Futures | 42577.4 | 42634.8 | 42566.8 | 42614.6 | 2240.0 |
| 2024-03-28 05:00:00 | YM | Futures | 42615.7 | 42632.7 | 42600.8 | 42611.4 | 1641.0 |
| 2024-03-28 06:00:00 | YM | Futures | 42611.4 | 42634.8 | 42601.9 | 42613.5 | 1795.0 |
| 2024-03-28 07:00:00 | YM | Futures | 42613.5 | 42624.2 | 42589.1 | 42623.1 | 1633.0 |
| 2024-03-28 08:00:00 | YM | Futures | 42622.0 | 42667.7 | 42618.9 | 42662.4 | 4012.0 |
| 2024-03-28 09:00:00 | YM | Futures | 42662.4 | 42717.6 | 42611.4 | 42629.5 | 18090.0 |
| 2024-03-28 10:00:00 | YM | Futures | 42630.5 | 42660.3 | 42574.3 | 42615.7 | 12079.0 |
| 2024-03-28 11:00:00 | YM | Futures | 42615.7 | 42659.2 | 42572.1 | 42650.7 | 7912.0 |
| 2024-03-28 12:00:00 | YM | Futures | 42650.7 | 42663.4 | 42613.5 | 42638.0 | 6681.0 |
| 2024-03-28 13:00:00 | YM | Futures | 42635.8 | 42646.5 | 42592.3 | 42645.4 | 5520.0 |
| 2024-03-28 14:00:00 | YM | Futures | 42646.5 | 42687.9 | 42594.4 | 42680.4 | 7665.0 |
| 2024-03-28 15:00:00 | YM | Futures | 42680.4 | 42722.9 | 42618.9 | 42633.7 | 18694.0 |
> showing 50 of 1,678 rows — these rows as CSV