PREVIEW / futures_1hour / 2024-08-19
file: by_date/futures_1hour/2024/2024-08-19.parquet size: 67 KB rows: 2,084
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-19 00:00:00 | ES | Futures | 5857.53 | 5858.05 | 5847.04 | 5850.71 | 6417.0 |
| 2024-08-19 01:00:00 | ES | Futures | 5850.45 | 5853.6 | 5845.21 | 5847.04 | 7558.0 |
| 2024-08-19 02:00:00 | ES | Futures | 5846.52 | 5848.88 | 5841.8 | 5842.32 | 8277.0 |
| 2024-08-19 03:00:00 | ES | Futures | 5842.59 | 5850.19 | 5842.32 | 5846.52 | 8609.0 |
| 2024-08-19 04:00:00 | ES | Futures | 5846.52 | 5848.88 | 5836.03 | 5848.35 | 12703.0 |
| 2024-08-19 05:00:00 | ES | Futures | 5848.62 | 5849.14 | 5843.11 | 5847.3 | 8604.0 |
| 2024-08-19 06:00:00 | ES | Futures | 5847.3 | 5852.55 | 5846.52 | 5847.04 | 8401.0 |
| 2024-08-19 07:00:00 | ES | Futures | 5846.78 | 5853.6 | 5846.52 | 5851.24 | 7152.0 |
| 2024-08-19 08:00:00 | ES | Futures | 5851.5 | 5856.74 | 5851.24 | 5854.91 | 12966.0 |
| 2024-08-19 09:00:00 | ES | Futures | 5854.91 | 5862.51 | 5851.76 | 5856.48 | 105954.0 |
| 2024-08-19 10:00:00 | ES | Futures | 5856.48 | 5874.83 | 5844.68 | 5873.0 | 162893.0 |
| 2024-08-19 11:00:00 | ES | Futures | 5873.0 | 5878.24 | 5865.39 | 5869.85 | 100914.0 |
| 2024-08-19 12:00:00 | ES | Futures | 5870.11 | 5883.22 | 5866.7 | 5881.39 | 68739.0 |
| 2024-08-19 13:00:00 | ES | Futures | 5881.39 | 5884.01 | 5877.19 | 5883.75 | 52125.0 |
| 2024-08-19 14:00:00 | ES | Futures | 5883.75 | 5893.71 | 5881.65 | 5890.3 | 76857.0 |
| 2024-08-19 15:00:00 | ES | Futures | 5890.3 | 5905.24 | 5886.37 | 5904.98 | 171653.0 |
| 2024-08-19 16:00:00 | ES | Futures | 5904.98 | 5905.77 | 5897.64 | 5898.95 | 65075.0 |
| 2024-08-19 18:00:00 | ES | Futures | 5903.41 | 5907.34 | 5900.79 | 5903.93 | 6567.0 |
| 2024-08-19 19:00:00 | ES | Futures | 5903.93 | 5904.98 | 5901.57 | 5902.36 | 2606.0 |
| 2024-08-19 20:00:00 | ES | Futures | 5902.62 | 5903.93 | 5901.31 | 5903.41 | 3314.0 |
| 2024-08-19 21:00:00 | ES | Futures | 5903.41 | 5906.03 | 5899.48 | 5906.03 | 4898.0 |
| 2024-08-19 22:00:00 | ES | Futures | 5906.03 | 5911.27 | 5904.72 | 5910.75 | 4923.0 |
| 2024-08-19 23:00:00 | ES | Futures | 5910.49 | 5910.49 | 5902.62 | 5903.41 | 3604.0 |
| 2024-08-19 00:00:00 | NQ | Futures | 20745.06 | 20746.91 | 20688.31 | 20704.94 | 4393.0 |
| 2024-08-19 01:00:00 | NQ | Futures | 20704.94 | 20718.93 | 20672.73 | 20680.39 | 3963.0 |
| 2024-08-19 02:00:00 | NQ | Futures | 20683.29 | 20693.32 | 20657.16 | 20670.36 | 4173.0 |
| 2024-08-19 03:00:00 | NQ | Futures | 20672.21 | 20703.62 | 20655.57 | 20680.13 | 5672.0 |
| 2024-08-19 04:00:00 | NQ | Futures | 20679.07 | 20686.99 | 20617.3 | 20666.66 | 9293.0 |
| 2024-08-19 05:00:00 | NQ | Futures | 20667.45 | 20680.39 | 20634.46 | 20673.79 | 5180.0 |
| 2024-08-19 06:00:00 | NQ | Futures | 20673.53 | 20702.56 | 20670.62 | 20674.32 | 5677.0 |
| 2024-08-19 07:00:00 | NQ | Futures | 20674.05 | 20715.76 | 20673.0 | 20706.79 | 4948.0 |
| 2024-08-19 08:00:00 | NQ | Futures | 20707.32 | 20733.98 | 20703.09 | 20719.46 | 7875.0 |
| 2024-08-19 09:00:00 | NQ | Futures | 20719.72 | 20737.15 | 20637.62 | 20683.29 | 67711.0 |
| 2024-08-19 10:00:00 | NQ | Futures | 20683.56 | 20761.7 | 20621.26 | 20754.04 | 77837.0 |
| 2024-08-19 11:00:00 | NQ | Futures | 20754.3 | 20780.7 | 20715.5 | 20736.35 | 42497.0 |
| 2024-08-19 12:00:00 | NQ | Futures | 20737.41 | 20801.56 | 20717.61 | 20794.17 | 30194.0 |
| 2024-08-19 13:00:00 | NQ | Futures | 20793.9 | 20825.84 | 20774.37 | 20824.26 | 26950.0 |
| 2024-08-19 14:00:00 | NQ | Futures | 20824.79 | 20892.9 | 20821.88 | 20875.47 | 34839.0 |
| 2024-08-19 15:00:00 | NQ | Futures | 20875.47 | 20972.09 | 20860.95 | 20970.77 | 56589.0 |
| 2024-08-19 16:00:00 | NQ | Futures | 20970.77 | 20983.18 | 20942.0 | 20963.91 | 17755.0 |
| 2024-08-19 18:00:00 | NQ | Futures | 20968.39 | 20995.06 | 20968.39 | 20978.95 | 3173.0 |
| 2024-08-19 19:00:00 | NQ | Futures | 20980.01 | 20987.66 | 20968.39 | 20970.77 | 1669.0 |
| 2024-08-19 20:00:00 | NQ | Futures | 20972.35 | 20981.86 | 20968.39 | 20977.37 | 2212.0 |
| 2024-08-19 21:00:00 | NQ | Futures | 20976.58 | 21001.13 | 20954.93 | 20999.81 | 4315.0 |
| 2024-08-19 22:00:00 | NQ | Futures | 21000.07 | 21028.32 | 20993.74 | 21026.21 | 3857.0 |
| 2024-08-19 23:00:00 | NQ | Futures | 21025.41 | 21025.41 | 20980.01 | 20988.46 | 3406.0 |
| 2024-08-19 00:00:00 | YM | Futures | 42883.4 | 42884.4 | 42847.6 | 42860.2 | 801.0 |
| 2024-08-19 01:00:00 | YM | Futures | 42862.3 | 42873.9 | 42840.3 | 42846.6 | 893.0 |
| 2024-08-19 02:00:00 | YM | Futures | 42845.5 | 42852.9 | 42807.7 | 42817.2 | 1160.0 |
| 2024-08-19 03:00:00 | YM | Futures | 42816.1 | 42863.4 | 42813.0 | 42835.0 | 1019.0 |
> showing 50 of 2,084 rows — these rows as CSV