PREVIEW / futures_1hour / 2024-11-20
file: by_date/futures_1hour/2024/2024-11-20.parquet size: 67 KB rows: 2,079
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-11-20 00:00:00 | ES | Futures | 6174.32 | 6175.62 | 6171.21 | 6173.28 | 4170.0 |
| 2024-11-20 01:00:00 | ES | Futures | 6173.54 | 6182.11 | 6172.76 | 6180.81 | 7791.0 |
| 2024-11-20 02:00:00 | ES | Futures | 6180.55 | 6183.15 | 6174.06 | 6180.03 | 9739.0 |
| 2024-11-20 03:00:00 | ES | Futures | 6180.03 | 6184.7 | 6176.4 | 6176.92 | 15720.0 |
| 2024-11-20 04:00:00 | ES | Futures | 6176.92 | 6183.4 | 6173.28 | 6176.14 | 11294.0 |
| 2024-11-20 05:00:00 | ES | Futures | 6175.88 | 6176.4 | 6164.98 | 6170.43 | 12727.0 |
| 2024-11-20 06:00:00 | ES | Futures | 6170.43 | 6175.36 | 6167.05 | 6171.21 | 14915.0 |
| 2024-11-20 07:00:00 | ES | Futures | 6171.21 | 6179.25 | 6170.43 | 6178.21 | 12069.0 |
| 2024-11-20 08:00:00 | ES | Futures | 6178.21 | 6180.81 | 6169.39 | 6171.47 | 19171.0 |
| 2024-11-20 09:00:00 | ES | Futures | 6171.21 | 6171.47 | 6133.58 | 6133.84 | 195306.0 |
| 2024-11-20 10:00:00 | ES | Futures | 6133.58 | 6141.62 | 6103.99 | 6133.32 | 290295.0 |
| 2024-11-20 11:00:00 | ES | Futures | 6133.32 | 6147.85 | 6113.85 | 6143.18 | 202034.0 |
| 2024-11-20 12:00:00 | ES | Futures | 6143.18 | 6146.81 | 6120.08 | 6130.2 | 146523.0 |
| 2024-11-20 13:00:00 | ES | Futures | 6130.2 | 6136.95 | 6120.34 | 6126.83 | 102901.0 |
| 2024-11-20 14:00:00 | ES | Futures | 6126.83 | 6139.03 | 6121.12 | 6134.35 | 90898.0 |
| 2024-11-20 15:00:00 | ES | Futures | 6134.35 | 6169.13 | 6131.24 | 6165.5 | 231796.0 |
| 2024-11-20 16:00:00 | ES | Futures | 6165.76 | 6170.69 | 6136.17 | 6166.02 | 101004.0 |
| 2024-11-20 18:00:00 | ES | Futures | 6163.42 | 6168.87 | 6153.56 | 6166.28 | 10122.0 |
| 2024-11-20 19:00:00 | ES | Futures | 6166.54 | 6168.09 | 6143.44 | 6143.96 | 12043.0 |
| 2024-11-20 20:00:00 | ES | Futures | 6144.22 | 6148.89 | 6136.43 | 6139.03 | 10315.0 |
| 2024-11-20 21:00:00 | ES | Futures | 6139.29 | 6146.55 | 6138.51 | 6143.18 | 6536.0 |
| 2024-11-20 22:00:00 | ES | Futures | 6143.44 | 6151.22 | 6143.44 | 6145.25 | 6214.0 |
| 2024-11-20 23:00:00 | ES | Futures | 6145.51 | 6150.96 | 6141.62 | 6149.67 | 4136.0 |
| 2024-11-20 00:00:00 | NQ | Futures | 21710.51 | 21713.91 | 21692.51 | 21703.73 | 2727.0 |
| 2024-11-20 01:00:00 | NQ | Futures | 21704.25 | 21749.91 | 21701.64 | 21740.0 | 6081.0 |
| 2024-11-20 02:00:00 | NQ | Futures | 21739.48 | 21750.17 | 21709.47 | 21734.52 | 6921.0 |
| 2024-11-20 03:00:00 | NQ | Futures | 21734.26 | 21753.04 | 21702.16 | 21702.69 | 9300.0 |
| 2024-11-20 04:00:00 | NQ | Futures | 21703.21 | 21738.17 | 21690.16 | 21702.43 | 7464.0 |
| 2024-11-20 05:00:00 | NQ | Futures | 21702.16 | 21707.38 | 21658.85 | 21688.6 | 8348.0 |
| 2024-11-20 06:00:00 | NQ | Futures | 21688.6 | 21712.34 | 21677.64 | 21700.86 | 7590.0 |
| 2024-11-20 07:00:00 | NQ | Futures | 21701.38 | 21732.17 | 21695.9 | 21728.52 | 7021.0 |
| 2024-11-20 08:00:00 | NQ | Futures | 21728.78 | 21739.21 | 21692.51 | 21700.6 | 9035.0 |
| 2024-11-20 09:00:00 | NQ | Futures | 21700.34 | 21700.86 | 21512.74 | 21513.79 | 84058.0 |
| 2024-11-20 10:00:00 | NQ | Futures | 21513.79 | 21546.14 | 21370.81 | 21527.61 | 119569.0 |
| 2024-11-20 11:00:00 | NQ | Futures | 21526.83 | 21612.93 | 21444.91 | 21592.06 | 81478.0 |
| 2024-11-20 12:00:00 | NQ | Futures | 21591.54 | 21611.89 | 21478.3 | 21506.74 | 53997.0 |
| 2024-11-20 13:00:00 | NQ | Futures | 21507.52 | 21532.57 | 21453.78 | 21488.48 | 39093.0 |
| 2024-11-20 14:00:00 | NQ | Futures | 21487.7 | 21527.61 | 21455.34 | 21508.57 | 34159.0 |
| 2024-11-20 15:00:00 | NQ | Futures | 21508.57 | 21670.86 | 21493.44 | 21656.77 | 68945.0 |
| 2024-11-20 16:00:00 | NQ | Futures | 21657.55 | 21693.55 | 21495.52 | 21643.98 | 33590.0 |
| 2024-11-20 18:00:00 | NQ | Futures | 21643.2 | 21668.51 | 21590.49 | 21658.33 | 7581.0 |
| 2024-11-20 19:00:00 | NQ | Futures | 21659.64 | 21664.59 | 21545.88 | 21550.84 | 8975.0 |
| 2024-11-20 20:00:00 | NQ | Futures | 21552.14 | 21576.14 | 21520.31 | 21531.79 | 7666.0 |
| 2024-11-20 21:00:00 | NQ | Futures | 21531.79 | 21561.79 | 21528.4 | 21549.01 | 5063.0 |
| 2024-11-20 22:00:00 | NQ | Futures | 21549.79 | 21591.8 | 21549.79 | 21556.32 | 4826.0 |
| 2024-11-20 23:00:00 | NQ | Futures | 21555.53 | 21586.06 | 21538.83 | 21579.8 | 3460.0 |
| 2024-11-20 00:00:00 | YM | Futures | 45259.2 | 45266.5 | 45237.3 | 45250.9 | 430.0 |
| 2024-11-20 01:00:00 | YM | Futures | 45247.7 | 45315.4 | 45247.7 | 45296.7 | 1170.0 |
| 2024-11-20 02:00:00 | YM | Futures | 45296.7 | 45325.8 | 45251.9 | 45300.8 | 1656.0 |
| 2024-11-20 03:00:00 | YM | Futures | 45302.9 | 45330.0 | 45277.9 | 45286.3 | 2054.0 |
> showing 50 of 2,079 rows — these rows as CSV