PREVIEW / futures_1hour / 2024-11-22
file: by_date/futures_1hour/2024/2024-11-22.parquet size: 56 KB rows: 1,652
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-22 00:00:00 | ES | Futures | 6196.38 | 6197.68 | 6187.56 | 6188.08 | 5696.0 |
| 2024-11-22 01:00:00 | ES | Futures | 6188.08 | 6199.75 | 6187.82 | 6196.9 | 7484.0 |
| 2024-11-22 02:00:00 | ES | Futures | 6196.64 | 6203.65 | 6194.56 | 6197.94 | 7610.0 |
| 2024-11-22 03:00:00 | ES | Futures | 6198.2 | 6203.13 | 6193.53 | 6196.9 | 14865.0 |
| 2024-11-22 04:00:00 | ES | Futures | 6196.9 | 6197.42 | 6167.57 | 6183.66 | 38969.0 |
| 2024-11-22 05:00:00 | ES | Futures | 6183.66 | 6184.18 | 6167.05 | 6179.77 | 21200.0 |
| 2024-11-22 06:00:00 | ES | Futures | 6179.77 | 6187.56 | 6174.32 | 6186.52 | 12691.0 |
| 2024-11-22 07:00:00 | ES | Futures | 6186.26 | 6195.08 | 6186.26 | 6194.3 | 16890.0 |
| 2024-11-22 08:00:00 | ES | Futures | 6194.3 | 6198.72 | 6189.63 | 6192.49 | 23838.0 |
| 2024-11-22 09:00:00 | ES | Futures | 6192.49 | 6221.55 | 6190.15 | 6219.48 | 196383.0 |
| 2024-11-22 10:00:00 | ES | Futures | 6218.96 | 6220.26 | 6189.89 | 6217.66 | 285825.0 |
| 2024-11-22 11:00:00 | ES | Futures | 6217.92 | 6218.96 | 6196.12 | 6209.62 | 177342.0 |
| 2024-11-22 12:00:00 | ES | Futures | 6209.88 | 6218.96 | 6205.98 | 6217.14 | 123276.0 |
| 2024-11-22 13:00:00 | ES | Futures | 6217.14 | 6221.81 | 6208.58 | 6214.03 | 105269.0 |
| 2024-11-22 14:00:00 | ES | Futures | 6214.03 | 6216.1 | 6200.79 | 6213.77 | 108514.0 |
| 2024-11-22 15:00:00 | ES | Futures | 6213.77 | 6221.04 | 6200.27 | 6214.03 | 216263.0 |
| 2024-11-22 16:00:00 | ES | Futures | 6214.03 | 6219.48 | 6212.47 | 6219.22 | 55017.0 |
| 2024-11-22 00:00:00 | NQ | Futures | 21718.08 | 21726.43 | 21668.25 | 21671.64 | 5235.0 |
| 2024-11-22 01:00:00 | NQ | Futures | 21672.16 | 21722.52 | 21668.77 | 21709.21 | 4120.0 |
| 2024-11-22 02:00:00 | NQ | Futures | 21708.69 | 21736.87 | 21694.6 | 21719.39 | 4940.0 |
| 2024-11-22 03:00:00 | NQ | Futures | 21720.43 | 21740.26 | 21691.47 | 21714.95 | 8769.0 |
| 2024-11-22 04:00:00 | NQ | Futures | 21714.95 | 21716.78 | 21597.02 | 21663.03 | 19092.0 |
| 2024-11-22 05:00:00 | NQ | Futures | 21664.33 | 21665.9 | 21596.5 | 21646.33 | 10461.0 |
| 2024-11-22 06:00:00 | NQ | Futures | 21646.59 | 21681.29 | 21625.46 | 21677.64 | 7255.0 |
| 2024-11-22 07:00:00 | NQ | Futures | 21676.86 | 21710.51 | 21674.51 | 21704.25 | 8651.0 |
| 2024-11-22 08:00:00 | NQ | Futures | 21705.04 | 21724.34 | 21682.6 | 21690.95 | 12399.0 |
| 2024-11-22 09:00:00 | NQ | Futures | 21691.73 | 21784.09 | 21677.12 | 21765.31 | 76751.0 |
| 2024-11-22 10:00:00 | NQ | Futures | 21763.22 | 21765.83 | 21626.76 | 21752.26 | 100310.0 |
| 2024-11-22 11:00:00 | NQ | Futures | 21752.52 | 21757.48 | 21648.68 | 21721.47 | 69967.0 |
| 2024-11-22 12:00:00 | NQ | Futures | 21722.26 | 21775.48 | 21705.3 | 21765.04 | 44935.0 |
| 2024-11-22 13:00:00 | NQ | Futures | 21765.04 | 21791.4 | 21734.52 | 21756.7 | 37092.0 |
| 2024-11-22 14:00:00 | NQ | Futures | 21757.22 | 21764.52 | 21703.21 | 21756.7 | 31023.0 |
| 2024-11-22 15:00:00 | NQ | Futures | 21756.96 | 21779.4 | 21709.73 | 21757.22 | 52553.0 |
| 2024-11-22 16:00:00 | NQ | Futures | 21757.22 | 21791.14 | 21749.65 | 21790.09 | 15146.0 |
| 2024-11-22 00:00:00 | YM | Futures | 45784.8 | 45790.0 | 45744.2 | 45746.3 | 785.0 |
| 2024-11-22 01:00:00 | YM | Futures | 45746.3 | 45805.6 | 45742.1 | 45783.7 | 947.0 |
| 2024-11-22 02:00:00 | YM | Futures | 45782.7 | 45847.2 | 45779.6 | 45796.2 | 1405.0 |
| 2024-11-22 03:00:00 | YM | Futures | 45796.2 | 45841.0 | 45781.7 | 45805.6 | 2351.0 |
| 2024-11-22 04:00:00 | YM | Futures | 45804.5 | 45804.5 | 45603.7 | 45709.8 | 6454.0 |
| 2024-11-22 05:00:00 | YM | Futures | 45710.9 | 45718.2 | 45614.1 | 45699.4 | 3192.0 |
| 2024-11-22 06:00:00 | YM | Futures | 45698.4 | 45743.1 | 45644.3 | 45740.0 | 1988.0 |
| 2024-11-22 07:00:00 | YM | Futures | 45740.0 | 45825.4 | 45733.8 | 45815.0 | 2238.0 |
| 2024-11-22 08:00:00 | YM | Futures | 45818.1 | 45846.2 | 45778.5 | 45804.5 | 2996.0 |
| 2024-11-22 09:00:00 | YM | Futures | 45804.5 | 46115.7 | 45790.0 | 46096.0 | 23526.0 |
| 2024-11-22 10:00:00 | YM | Futures | 46093.9 | 46112.6 | 45896.1 | 46066.8 | 19890.0 |
| 2024-11-22 11:00:00 | YM | Futures | 46068.9 | 46076.2 | 45943.0 | 46068.9 | 9917.0 |
| 2024-11-22 12:00:00 | YM | Futures | 46069.9 | 46161.5 | 46041.8 | 46132.4 | 9853.0 |
| 2024-11-22 13:00:00 | YM | Futures | 46131.3 | 46171.9 | 46097.0 | 46135.5 | 6339.0 |
| 2024-11-22 14:00:00 | YM | Futures | 46134.5 | 46188.6 | 46059.5 | 46160.5 | 7062.0 |
| 2024-11-22 15:00:00 | YM | Futures | 46159.4 | 46247.9 | 46066.8 | 46196.9 | 14978.0 |
> showing 50 of 1,652 rows — these rows as CSV