PREVIEW / futures_1hour / 2021-05-21
file: by_date/futures_1hour/2021/2021-05-21.parquet size: 53 KB rows: 1,584
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 |
|---|---|---|---|---|---|---|---|
| 2021-05-21 00:00:00 | ES | Futures | 4673.64 | 4679.83 | 4671.96 | 4678.42 | 4529.0 |
| 2021-05-21 01:00:00 | ES | Futures | 4678.42 | 4682.07 | 4674.49 | 4676.73 | 5900.0 |
| 2021-05-21 02:00:00 | ES | Futures | 4677.02 | 4681.51 | 4676.73 | 4678.98 | 5093.0 |
| 2021-05-21 03:00:00 | ES | Futures | 4678.7 | 4685.16 | 4675.89 | 4677.3 | 17005.0 |
| 2021-05-21 04:00:00 | ES | Futures | 4677.02 | 4679.26 | 4670.55 | 4676.73 | 12605.0 |
| 2021-05-21 05:00:00 | ES | Futures | 4676.73 | 4684.32 | 4676.73 | 4680.39 | 10922.0 |
| 2021-05-21 06:00:00 | ES | Futures | 4680.39 | 4686.01 | 4678.42 | 4679.83 | 10573.0 |
| 2021-05-21 07:00:00 | ES | Futures | 4679.54 | 4690.22 | 4679.54 | 4688.54 | 16940.0 |
| 2021-05-21 08:00:00 | ES | Futures | 4688.82 | 4689.38 | 4683.76 | 4684.88 | 20956.0 |
| 2021-05-21 09:00:00 | ES | Futures | 4684.88 | 4703.15 | 4683.48 | 4703.15 | 178160.0 |
| 2021-05-21 10:00:00 | ES | Futures | 4703.15 | 4703.43 | 4682.35 | 4690.5 | 241116.0 |
| 2021-05-21 11:00:00 | ES | Futures | 4690.22 | 4692.75 | 4676.73 | 4677.86 | 147292.0 |
| 2021-05-21 12:00:00 | ES | Futures | 4677.86 | 4681.23 | 4660.72 | 4665.78 | 155460.0 |
| 2021-05-21 13:00:00 | ES | Futures | 4665.78 | 4678.14 | 4664.93 | 4675.33 | 102257.0 |
| 2021-05-21 14:00:00 | ES | Futures | 4675.61 | 4680.39 | 4666.62 | 4675.61 | 123718.0 |
| 2021-05-21 15:00:00 | ES | Futures | 4675.33 | 4681.23 | 4664.09 | 4666.9 | 246140.0 |
| 2021-05-21 16:00:00 | ES | Futures | 4666.9 | 4672.8 | 4666.06 | 4672.8 | 72602.0 |
| 2021-05-21 00:00:00 | NQ | Futures | 15634.77 | 15660.54 | 15628.98 | 15648.38 | 4044.0 |
| 2021-05-21 01:00:00 | NQ | Futures | 15648.09 | 15672.41 | 15632.75 | 15641.14 | 3616.0 |
| 2021-05-21 02:00:00 | NQ | Futures | 15641.72 | 15661.98 | 15640.27 | 15654.46 | 3176.0 |
| 2021-05-21 03:00:00 | NQ | Futures | 15653.3 | 15679.64 | 15633.32 | 15659.67 | 7735.0 |
| 2021-05-21 04:00:00 | NQ | Futures | 15659.38 | 15666.33 | 15636.51 | 15652.72 | 5340.0 |
| 2021-05-21 05:00:00 | NQ | Futures | 15653.01 | 15670.09 | 15647.51 | 15651.27 | 4082.0 |
| 2021-05-21 06:00:00 | NQ | Futures | 15650.69 | 15663.72 | 15642.3 | 15645.77 | 3864.0 |
| 2021-05-21 07:00:00 | NQ | Futures | 15646.35 | 15689.2 | 15646.35 | 15679.93 | 7435.0 |
| 2021-05-21 08:00:00 | NQ | Futures | 15680.51 | 15684.28 | 15650.12 | 15661.12 | 9675.0 |
| 2021-05-21 09:00:00 | NQ | Futures | 15660.54 | 15713.8 | 15614.8 | 15682.25 | 68947.0 |
| 2021-05-21 10:00:00 | NQ | Futures | 15682.54 | 15688.91 | 15567.61 | 15600.32 | 82036.0 |
| 2021-05-21 11:00:00 | NQ | Futures | 15600.9 | 15615.95 | 15534.03 | 15539.82 | 60118.0 |
| 2021-05-21 12:00:00 | NQ | Futures | 15540.11 | 15564.42 | 15514.92 | 15542.42 | 47784.0 |
| 2021-05-21 13:00:00 | NQ | Futures | 15542.42 | 15578.9 | 15525.05 | 15568.77 | 27385.0 |
| 2021-05-21 14:00:00 | NQ | Futures | 15569.06 | 15589.61 | 15532.29 | 15565.87 | 29120.0 |
| 2021-05-21 15:00:00 | NQ | Futures | 15566.16 | 15582.08 | 15512.03 | 15527.37 | 48989.0 |
| 2021-05-21 16:00:00 | NQ | Futures | 15527.08 | 15541.26 | 15522.16 | 15533.16 | 9176.0 |
| 2021-05-21 00:00:00 | YM | Futures | 37938.9 | 37994.6 | 37925.5 | 37981.2 | 1179.0 |
| 2021-05-21 01:00:00 | YM | Futures | 37983.4 | 38006.8 | 37953.4 | 37969.0 | 1442.0 |
| 2021-05-21 02:00:00 | YM | Futures | 37970.1 | 38007.9 | 37970.1 | 37972.3 | 1537.0 |
| 2021-05-21 03:00:00 | YM | Futures | 37971.2 | 38024.6 | 37941.1 | 37950.0 | 3829.0 |
| 2021-05-21 04:00:00 | YM | Futures | 37948.9 | 37967.8 | 37896.6 | 37956.7 | 2981.0 |
| 2021-05-21 05:00:00 | YM | Futures | 37956.7 | 38030.2 | 37956.7 | 38000.1 | 3839.0 |
| 2021-05-21 06:00:00 | YM | Futures | 38002.4 | 38059.2 | 37985.7 | 37999.0 | 3140.0 |
| 2021-05-21 07:00:00 | YM | Futures | 38001.3 | 38090.4 | 38000.1 | 38073.7 | 4182.0 |
| 2021-05-21 08:00:00 | YM | Futures | 38074.8 | 38080.3 | 38046.9 | 38060.3 | 2987.0 |
| 2021-05-21 09:00:00 | YM | Futures | 38060.3 | 38284.2 | 38032.4 | 38259.7 | 23932.0 |
| 2021-05-21 10:00:00 | YM | Futures | 38258.5 | 38260.8 | 38139.4 | 38204.0 | 18433.0 |
| 2021-05-21 11:00:00 | YM | Futures | 38204.0 | 38227.4 | 38128.2 | 38152.7 | 11011.0 |
| 2021-05-21 12:00:00 | YM | Futures | 38152.7 | 38167.2 | 37965.6 | 37995.7 | 13776.0 |
| 2021-05-21 13:00:00 | YM | Futures | 37994.6 | 38089.2 | 37985.7 | 38071.4 | 8138.0 |
| 2021-05-21 14:00:00 | YM | Futures | 38072.5 | 38110.4 | 38026.9 | 38090.4 | 9220.0 |
| 2021-05-21 15:00:00 | YM | Futures | 38089.2 | 38151.6 | 38028.0 | 38050.3 | 16808.0 |
> showing 50 of 1,584 rows — these rows as CSV