PREVIEW / futures_1hour / 2022-03-07
file: by_date/futures_1hour/2022/2022-03-07.parquet size: 71 KB rows: 2,077
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 |
|---|---|---|---|---|---|---|---|
| 2022-03-07 00:00:00 | ES | Futures | 4837.05 | 4856.28 | 4827.43 | 4832.81 | 18654.0 |
| 2022-03-07 01:00:00 | ES | Futures | 4832.24 | 4841.29 | 4822.62 | 4839.88 | 11728.0 |
| 2022-03-07 02:00:00 | ES | Futures | 4839.88 | 4848.92 | 4809.33 | 4814.71 | 22844.0 |
| 2022-03-07 03:00:00 | ES | Futures | 4814.42 | 4831.67 | 4794.06 | 4817.82 | 50194.0 |
| 2022-03-07 04:00:00 | ES | Futures | 4817.82 | 4833.65 | 4808.77 | 4820.36 | 29373.0 |
| 2022-03-07 05:00:00 | ES | Futures | 4820.64 | 4828.56 | 4812.44 | 4813.29 | 20258.0 |
| 2022-03-07 06:00:00 | ES | Futures | 4813.29 | 4837.05 | 4801.98 | 4835.35 | 39369.0 |
| 2022-03-07 07:00:00 | ES | Futures | 4835.07 | 4873.53 | 4834.78 | 4853.73 | 61837.0 |
| 2022-03-07 08:00:00 | ES | Futures | 4854.02 | 4881.73 | 4848.64 | 4876.92 | 53526.0 |
| 2022-03-07 09:00:00 | ES | Futures | 4877.2 | 4892.76 | 4842.7 | 4842.7 | 184521.0 |
| 2022-03-07 10:00:00 | ES | Futures | 4842.7 | 4853.17 | 4811.31 | 4817.25 | 205669.0 |
| 2022-03-07 11:00:00 | ES | Futures | 4817.25 | 4836.2 | 4800.28 | 4801.7 | 167489.0 |
| 2022-03-07 12:00:00 | ES | Futures | 4801.41 | 4804.81 | 4779.07 | 4788.69 | 178766.0 |
| 2022-03-07 13:00:00 | ES | Futures | 4788.41 | 4803.68 | 4777.09 | 4784.73 | 147625.0 |
| 2022-03-07 14:00:00 | ES | Futures | 4784.45 | 4799.43 | 4768.89 | 4774.27 | 121077.0 |
| 2022-03-07 15:00:00 | ES | Futures | 4774.27 | 4777.94 | 4747.68 | 4748.81 | 291422.0 |
| 2022-03-07 16:00:00 | ES | Futures | 4748.81 | 4752.49 | 4734.39 | 4735.24 | 83872.0 |
| 2022-03-07 18:00:00 | ES | Futures | 4735.8 | 4742.59 | 4729.58 | 4735.52 | 14753.0 |
| 2022-03-07 19:00:00 | ES | Futures | 4735.8 | 4747.96 | 4734.96 | 4743.72 | 15018.0 |
| 2022-03-07 20:00:00 | ES | Futures | 4743.72 | 4769.17 | 4741.74 | 4765.78 | 25162.0 |
| 2022-03-07 21:00:00 | ES | Futures | 4765.78 | 4768.04 | 4748.53 | 4749.94 | 13885.0 |
| 2022-03-07 22:00:00 | ES | Futures | 4749.38 | 4755.32 | 4743.72 | 4747.68 | 10045.0 |
| 2022-03-07 23:00:00 | ES | Futures | 4747.68 | 4748.25 | 4737.22 | 4740.05 | 7790.0 |
| 2022-03-07 00:00:00 | NQ | Futures | 15785.47 | 15848.07 | 15757.65 | 15767.79 | 7862.0 |
| 2022-03-07 01:00:00 | NQ | Futures | 15766.34 | 15795.9 | 15735.33 | 15794.75 | 4386.0 |
| 2022-03-07 02:00:00 | NQ | Futures | 15793.3 | 15811.55 | 15702.29 | 15721.13 | 9508.0 |
| 2022-03-07 03:00:00 | NQ | Futures | 15721.42 | 15796.77 | 15705.48 | 15767.5 | 23636.0 |
| 2022-03-07 04:00:00 | NQ | Futures | 15767.21 | 15826.62 | 15734.75 | 15772.14 | 14966.0 |
| 2022-03-07 05:00:00 | NQ | Futures | 15772.43 | 15808.66 | 15752.43 | 15755.91 | 9324.0 |
| 2022-03-07 06:00:00 | NQ | Futures | 15755.62 | 15831.55 | 15728.38 | 15829.23 | 14180.0 |
| 2022-03-07 07:00:00 | NQ | Futures | 15828.36 | 15969.5 | 15826.05 | 15895.6 | 27441.0 |
| 2022-03-07 08:00:00 | NQ | Futures | 15896.18 | 15996.46 | 15886.33 | 15982.55 | 22416.0 |
| 2022-03-07 09:00:00 | NQ | Futures | 15983.42 | 16090.36 | 15851.26 | 15851.84 | 89509.0 |
| 2022-03-07 10:00:00 | NQ | Futures | 15850.97 | 15875.02 | 15697.66 | 15724.9 | 87376.0 |
| 2022-03-07 11:00:00 | NQ | Futures | 15724.61 | 15816.48 | 15708.09 | 15716.78 | 65691.0 |
| 2022-03-07 12:00:00 | NQ | Futures | 15714.76 | 15754.17 | 15645.2 | 15673.89 | 60370.0 |
| 2022-03-07 13:00:00 | NQ | Futures | 15673.02 | 15724.9 | 15605.2 | 15623.75 | 57107.0 |
| 2022-03-07 14:00:00 | NQ | Futures | 15623.17 | 15677.37 | 15544.34 | 15557.38 | 44433.0 |
| 2022-03-07 15:00:00 | NQ | Futures | 15557.38 | 15573.03 | 15434.21 | 15441.75 | 79839.0 |
| 2022-03-07 16:00:00 | NQ | Futures | 15441.75 | 15452.47 | 15377.7 | 15383.49 | 22959.0 |
| 2022-03-07 18:00:00 | NQ | Futures | 15398.57 | 15406.68 | 15360.6 | 15382.63 | 6281.0 |
| 2022-03-07 19:00:00 | NQ | Futures | 15383.78 | 15435.66 | 15376.83 | 15408.13 | 7207.0 |
| 2022-03-07 20:00:00 | NQ | Futures | 15407.26 | 15511.01 | 15406.68 | 15475.08 | 11104.0 |
| 2022-03-07 21:00:00 | NQ | Futures | 15477.4 | 15487.54 | 15424.07 | 15428.71 | 6256.0 |
| 2022-03-07 22:00:00 | NQ | Futures | 15426.39 | 15442.04 | 15403.49 | 15426.39 | 4754.0 |
| 2022-03-07 23:00:00 | NQ | Futures | 15426.1 | 15431.02 | 15378.86 | 15389.29 | 4766.0 |
| 2022-03-07 00:00:00 | YM | Futures | 37377.6 | 37514.7 | 37315.8 | 37361.9 | 2926.0 |
| 2022-03-07 01:00:00 | YM | Futures | 37356.2 | 37415.8 | 37295.6 | 37409.1 | 1403.0 |
| 2022-03-07 02:00:00 | YM | Futures | 37407.9 | 37484.4 | 37192.2 | 37214.6 | 6097.0 |
| 2022-03-07 03:00:00 | YM | Futures | 37215.8 | 37329.3 | 36997.7 | 37194.4 | 13119.0 |
> showing 50 of 2,077 rows — these rows as CSV