PREVIEW / futures_1hour / 2024-09-03
file: by_date/futures_1hour/2024/2024-09-03.parquet size: 68 KB rows: 2,059
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-09-03 00:00:00 | ES | Futures | 5928.05 | 5928.31 | 5925.43 | 5926.48 | 2145.0 |
| 2024-09-03 01:00:00 | ES | Futures | 5926.48 | 5930.67 | 5926.48 | 5930.67 | 4783.0 |
| 2024-09-03 02:00:00 | ES | Futures | 5930.67 | 5932.25 | 5921.5 | 5930.67 | 6948.0 |
| 2024-09-03 03:00:00 | ES | Futures | 5930.41 | 5941.95 | 5930.41 | 5937.75 | 10833.0 |
| 2024-09-03 04:00:00 | ES | Futures | 5938.01 | 5940.11 | 5913.63 | 5913.89 | 17076.0 |
| 2024-09-03 05:00:00 | ES | Futures | 5913.89 | 5917.04 | 5901.83 | 5903.67 | 28123.0 |
| 2024-09-03 06:00:00 | ES | Futures | 5903.67 | 5910.49 | 5900.26 | 5908.39 | 17831.0 |
| 2024-09-03 07:00:00 | ES | Futures | 5908.65 | 5910.22 | 5901.05 | 5906.29 | 17976.0 |
| 2024-09-03 08:00:00 | ES | Futures | 5906.29 | 5911.01 | 5901.57 | 5902.1 | 24177.0 |
| 2024-09-03 09:00:00 | ES | Futures | 5901.83 | 5907.08 | 5875.62 | 5885.32 | 206536.0 |
| 2024-09-03 10:00:00 | ES | Futures | 5885.32 | 5885.32 | 5843.63 | 5846.52 | 294497.0 |
| 2024-09-03 11:00:00 | ES | Futures | 5846.78 | 5863.82 | 5844.42 | 5849.14 | 177488.0 |
| 2024-09-03 12:00:00 | ES | Futures | 5849.14 | 5859.1 | 5839.96 | 5841.54 | 127906.0 |
| 2024-09-03 13:00:00 | ES | Futures | 5841.54 | 5852.02 | 5834.72 | 5835.51 | 118884.0 |
| 2024-09-03 14:00:00 | ES | Futures | 5835.51 | 5836.56 | 5816.37 | 5818.2 | 155217.0 |
| 2024-09-03 15:00:00 | ES | Futures | 5817.94 | 5823.45 | 5785.17 | 5812.96 | 373593.0 |
| 2024-09-03 16:00:00 | ES | Futures | 5812.96 | 5816.89 | 5801.43 | 5807.98 | 84288.0 |
| 2024-09-03 18:00:00 | ES | Futures | 5807.98 | 5810.6 | 5798.54 | 5803.52 | 10547.0 |
| 2024-09-03 19:00:00 | ES | Futures | 5803.52 | 5806.41 | 5796.71 | 5801.95 | 7558.0 |
| 2024-09-03 20:00:00 | ES | Futures | 5801.69 | 5807.98 | 5776.78 | 5778.88 | 23585.0 |
| 2024-09-03 21:00:00 | ES | Futures | 5778.88 | 5796.18 | 5775.47 | 5787.79 | 23710.0 |
| 2024-09-03 22:00:00 | ES | Futures | 5787.53 | 5794.87 | 5783.6 | 5787.01 | 12288.0 |
| 2024-09-03 23:00:00 | ES | Futures | 5787.01 | 5791.2 | 5779.67 | 5783.07 | 7989.0 |
| 2024-09-03 00:00:00 | NQ | Futures | 20655.84 | 20658.74 | 20642.64 | 20647.13 | 1706.0 |
| 2024-09-03 01:00:00 | NQ | Futures | 20647.39 | 20665.87 | 20638.68 | 20661.38 | 2960.0 |
| 2024-09-03 02:00:00 | NQ | Futures | 20661.38 | 20671.15 | 20610.7 | 20666.66 | 5119.0 |
| 2024-09-03 03:00:00 | NQ | Futures | 20665.87 | 20743.48 | 20665.61 | 20711.28 | 8049.0 |
| 2024-09-03 04:00:00 | NQ | Futures | 20711.01 | 20729.75 | 20586.94 | 20588.79 | 12155.0 |
| 2024-09-03 05:00:00 | NQ | Futures | 20589.58 | 20605.15 | 20533.09 | 20557.37 | 14476.0 |
| 2024-09-03 06:00:00 | NQ | Futures | 20557.9 | 20600.93 | 20541.8 | 20590.11 | 8871.0 |
| 2024-09-03 07:00:00 | NQ | Futures | 20590.64 | 20602.78 | 20546.02 | 20585.36 | 8571.0 |
| 2024-09-03 08:00:00 | NQ | Futures | 20586.41 | 20614.13 | 20566.08 | 20568.46 | 11844.0 |
| 2024-09-03 09:00:00 | NQ | Futures | 20568.2 | 20600.93 | 20412.18 | 20449.67 | 91166.0 |
| 2024-09-03 10:00:00 | NQ | Futures | 20449.67 | 20470.26 | 20229.51 | 20234.52 | 104965.0 |
| 2024-09-03 11:00:00 | NQ | Futures | 20234.26 | 20309.76 | 20213.67 | 20219.21 | 63439.0 |
| 2024-09-03 12:00:00 | NQ | Futures | 20219.21 | 20279.14 | 20202.32 | 20209.44 | 43727.0 |
| 2024-09-03 13:00:00 | NQ | Futures | 20209.71 | 20251.42 | 20171.69 | 20176.71 | 44701.0 |
| 2024-09-03 14:00:00 | NQ | Futures | 20177.5 | 20182.52 | 20094.88 | 20110.19 | 50701.0 |
| 2024-09-03 15:00:00 | NQ | Futures | 20109.92 | 20138.7 | 19968.69 | 20075.61 | 92410.0 |
| 2024-09-03 16:00:00 | NQ | Futures | 20075.34 | 20102.53 | 20030.73 | 20051.85 | 24862.0 |
| 2024-09-03 18:00:00 | NQ | Futures | 20056.07 | 20068.74 | 20006.71 | 20024.39 | 6372.0 |
| 2024-09-03 19:00:00 | NQ | Futures | 20024.92 | 20037.06 | 19992.71 | 20017.79 | 5519.0 |
| 2024-09-03 20:00:00 | NQ | Futures | 20018.32 | 20044.72 | 19896.89 | 19905.34 | 10939.0 |
| 2024-09-03 21:00:00 | NQ | Futures | 19905.34 | 19992.45 | 19878.67 | 19943.09 | 12001.0 |
| 2024-09-03 22:00:00 | NQ | Futures | 19944.67 | 19992.45 | 19933.85 | 19950.74 | 6699.0 |
| 2024-09-03 23:00:00 | NQ | Futures | 19951.27 | 19976.35 | 19919.33 | 19937.54 | 4243.0 |
| 2024-09-03 00:00:00 | YM | Futures | 43691.4 | 43691.4 | 43674.6 | 43677.7 | 344.0 |
| 2024-09-03 01:00:00 | YM | Futures | 43676.7 | 43705.0 | 43676.7 | 43704.0 | 705.0 |
| 2024-09-03 02:00:00 | YM | Futures | 43702.9 | 43717.6 | 43668.2 | 43698.7 | 1144.0 |
| 2024-09-03 03:00:00 | YM | Futures | 43697.7 | 43734.4 | 43697.7 | 43726.0 | 1594.0 |
> showing 50 of 2,059 rows — these rows as CSV