PREVIEW / futures_1hour / 2024-08-16
file: by_date/futures_1hour/2024/2024-08-16.parquet size: 57 KB rows: 1,676
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-16 00:00:00 | ES | Futures | 5847.83 | 5847.83 | 5843.37 | 5845.73 | 3427.0 |
| 2024-08-16 01:00:00 | ES | Futures | 5845.73 | 5853.33 | 5845.47 | 5851.76 | 4707.0 |
| 2024-08-16 02:00:00 | ES | Futures | 5851.76 | 5854.91 | 5850.98 | 5852.29 | 6527.0 |
| 2024-08-16 03:00:00 | ES | Futures | 5852.02 | 5853.07 | 5843.63 | 5845.73 | 14872.0 |
| 2024-08-16 04:00:00 | ES | Futures | 5845.99 | 5849.93 | 5840.49 | 5844.42 | 11887.0 |
| 2024-08-16 05:00:00 | ES | Futures | 5844.42 | 5847.83 | 5840.49 | 5841.54 | 20737.0 |
| 2024-08-16 06:00:00 | ES | Futures | 5841.8 | 5841.8 | 5830.0 | 5834.98 | 23935.0 |
| 2024-08-16 07:00:00 | ES | Futures | 5834.98 | 5836.03 | 5827.64 | 5828.17 | 20147.0 |
| 2024-08-16 08:00:00 | ES | Futures | 5828.43 | 5831.31 | 5805.88 | 5812.17 | 59313.0 |
| 2024-08-16 09:00:00 | ES | Futures | 5811.91 | 5832.36 | 5811.13 | 5827.64 | 172135.0 |
| 2024-08-16 10:00:00 | ES | Futures | 5828.43 | 5842.85 | 5821.87 | 5827.38 | 160116.0 |
| 2024-08-16 11:00:00 | ES | Futures | 5827.38 | 5842.06 | 5825.28 | 5840.23 | 96475.0 |
| 2024-08-16 12:00:00 | ES | Futures | 5840.23 | 5858.05 | 5838.13 | 5855.69 | 95472.0 |
| 2024-08-16 13:00:00 | ES | Futures | 5855.96 | 5856.74 | 5847.04 | 5853.33 | 74856.0 |
| 2024-08-16 14:00:00 | ES | Futures | 5853.33 | 5854.91 | 5845.21 | 5853.33 | 65047.0 |
| 2024-08-16 15:00:00 | ES | Futures | 5853.33 | 5854.91 | 5842.32 | 5849.66 | 141697.0 |
| 2024-08-16 16:00:00 | ES | Futures | 5849.66 | 5853.86 | 5847.83 | 5851.76 | 41350.0 |
| 2024-08-16 00:00:00 | NQ | Futures | 20731.87 | 20733.71 | 20708.9 | 20718.4 | 2187.0 |
| 2024-08-16 01:00:00 | NQ | Futures | 20717.87 | 20766.98 | 20717.08 | 20759.58 | 3747.0 |
| 2024-08-16 02:00:00 | NQ | Futures | 20760.11 | 20783.87 | 20756.42 | 20770.14 | 4920.0 |
| 2024-08-16 03:00:00 | NQ | Futures | 20770.14 | 20778.33 | 20727.11 | 20732.13 | 8145.0 |
| 2024-08-16 04:00:00 | NQ | Futures | 20732.66 | 20749.82 | 20701.51 | 20723.68 | 6782.0 |
| 2024-08-16 05:00:00 | NQ | Futures | 20723.42 | 20741.37 | 20709.43 | 20717.08 | 6101.0 |
| 2024-08-16 06:00:00 | NQ | Futures | 20716.29 | 20717.08 | 20667.19 | 20690.95 | 7646.0 |
| 2024-08-16 07:00:00 | NQ | Futures | 20690.68 | 20696.76 | 20642.64 | 20646.86 | 8624.0 |
| 2024-08-16 08:00:00 | NQ | Futures | 20647.13 | 20660.06 | 20535.2 | 20568.72 | 26639.0 |
| 2024-08-16 09:00:00 | NQ | Futures | 20568.2 | 20627.06 | 20551.04 | 20588.52 | 75896.0 |
| 2024-08-16 10:00:00 | NQ | Futures | 20584.83 | 20686.99 | 20578.23 | 20611.49 | 82811.0 |
| 2024-08-16 11:00:00 | NQ | Futures | 20612.02 | 20679.33 | 20585.36 | 20670.62 | 48095.0 |
| 2024-08-16 12:00:00 | NQ | Futures | 20670.09 | 20760.38 | 20658.48 | 20750.61 | 40193.0 |
| 2024-08-16 13:00:00 | NQ | Futures | 20751.4 | 20754.83 | 20699.92 | 20726.06 | 30574.0 |
| 2024-08-16 14:00:00 | NQ | Futures | 20726.59 | 20727.11 | 20686.2 | 20720.25 | 25723.0 |
| 2024-08-16 15:00:00 | NQ | Futures | 20720.78 | 20722.63 | 20666.93 | 20699.92 | 40435.0 |
| 2024-08-16 16:00:00 | NQ | Futures | 20700.19 | 20719.72 | 20694.64 | 20700.45 | 9930.0 |
| 2024-08-16 00:00:00 | YM | Futures | 42816.1 | 42819.3 | 42795.1 | 42811.9 | 534.0 |
| 2024-08-16 01:00:00 | YM | Futures | 42813.0 | 42841.3 | 42809.8 | 42829.8 | 753.0 |
| 2024-08-16 02:00:00 | YM | Futures | 42829.8 | 42849.7 | 42820.3 | 42825.6 | 1298.0 |
| 2024-08-16 03:00:00 | YM | Futures | 42824.5 | 42834.0 | 42787.7 | 42811.9 | 1667.0 |
| 2024-08-16 04:00:00 | YM | Futures | 42811.9 | 42832.9 | 42781.4 | 42790.9 | 1606.0 |
| 2024-08-16 05:00:00 | YM | Futures | 42790.9 | 42811.9 | 42773.0 | 42778.3 | 2321.0 |
| 2024-08-16 06:00:00 | YM | Futures | 42778.3 | 42778.3 | 42714.2 | 42743.6 | 2831.0 |
| 2024-08-16 07:00:00 | YM | Futures | 42743.6 | 42746.8 | 42693.2 | 42707.9 | 2854.0 |
| 2024-08-16 08:00:00 | YM | Futures | 42707.9 | 42722.6 | 42602.8 | 42630.1 | 5332.0 |
| 2024-08-16 09:00:00 | YM | Futures | 42629.1 | 42766.7 | 42623.8 | 42721.5 | 17636.0 |
| 2024-08-16 10:00:00 | YM | Futures | 42723.6 | 42823.5 | 42623.8 | 42702.6 | 15874.0 |
| 2024-08-16 11:00:00 | YM | Futures | 42702.6 | 42810.9 | 42698.4 | 42797.2 | 8938.0 |
| 2024-08-16 12:00:00 | YM | Futures | 42796.1 | 42915.9 | 42789.8 | 42898.1 | 8424.0 |
| 2024-08-16 13:00:00 | YM | Futures | 42899.1 | 42904.4 | 42845.5 | 42889.7 | 5916.0 |
| 2024-08-16 14:00:00 | YM | Futures | 42889.7 | 42925.4 | 42840.3 | 42915.9 | 6387.0 |
| 2024-08-16 15:00:00 | YM | Futures | 42915.9 | 42928.5 | 42839.2 | 42858.1 | 9449.0 |
> showing 50 of 1,676 rows — these rows as CSV