PREVIEW / futures_1hour / 2022-05-31
file: by_date/futures_1hour/2022/2022-05-31.parquet size: 67 KB rows: 2,049
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-05-31 00:00:00 | ES | Futures | 4721.55 | 4726.08 | 4719.0 | 4722.96 | 3681.0 |
| 2022-05-31 01:00:00 | ES | Futures | 4723.25 | 4727.22 | 4718.15 | 4719.0 | 8644.0 |
| 2022-05-31 02:00:00 | ES | Futures | 4719.0 | 4721.83 | 4698.02 | 4703.69 | 20353.0 |
| 2022-05-31 03:00:00 | ES | Futures | 4703.41 | 4705.67 | 4687.53 | 4693.77 | 29217.0 |
| 2022-05-31 04:00:00 | ES | Futures | 4694.05 | 4722.68 | 4693.2 | 4712.76 | 30935.0 |
| 2022-05-31 05:00:00 | ES | Futures | 4713.04 | 4713.04 | 4672.8 | 4681.58 | 37502.0 |
| 2022-05-31 06:00:00 | ES | Futures | 4681.87 | 4698.87 | 4673.93 | 4689.23 | 24145.0 |
| 2022-05-31 07:00:00 | ES | Futures | 4689.52 | 4703.97 | 4684.98 | 4690.65 | 23224.0 |
| 2022-05-31 08:00:00 | ES | Futures | 4690.94 | 4691.79 | 4673.65 | 4675.06 | 36679.0 |
| 2022-05-31 09:00:00 | ES | Futures | 4674.78 | 4697.74 | 4654.09 | 4664.86 | 198779.0 |
| 2022-05-31 10:00:00 | ES | Futures | 4664.58 | 4690.94 | 4651.54 | 4684.42 | 255985.0 |
| 2022-05-31 11:00:00 | ES | Futures | 4684.7 | 4707.09 | 4665.43 | 4703.69 | 194225.0 |
| 2022-05-31 12:00:00 | ES | Futures | 4703.69 | 4717.01 | 4690.94 | 4710.21 | 156214.0 |
| 2022-05-31 13:00:00 | ES | Futures | 4710.21 | 4723.53 | 4692.64 | 4722.11 | 137938.0 |
| 2022-05-31 14:00:00 | ES | Futures | 4722.11 | 4725.23 | 4676.76 | 4686.12 | 175195.0 |
| 2022-05-31 15:00:00 | ES | Futures | 4685.83 | 4711.34 | 4674.78 | 4684.98 | 455608.0 |
| 2022-05-31 16:00:00 | ES | Futures | 4684.98 | 4688.38 | 4674.78 | 4684.98 | 83466.0 |
| 2022-05-31 18:00:00 | ES | Futures | 4692.07 | 4698.02 | 4685.55 | 4696.89 | 8897.0 |
| 2022-05-31 19:00:00 | ES | Futures | 4697.17 | 4703.97 | 4692.92 | 4703.12 | 7675.0 |
| 2022-05-31 20:00:00 | ES | Futures | 4703.12 | 4707.94 | 4702.84 | 4704.82 | 9280.0 |
| 2022-05-31 21:00:00 | ES | Futures | 4705.11 | 4712.76 | 4703.41 | 4708.79 | 11333.0 |
| 2022-05-31 22:00:00 | ES | Futures | 4708.79 | 4709.93 | 4700.01 | 4700.57 | 7257.0 |
| 2022-05-31 23:00:00 | ES | Futures | 4700.57 | 4701.99 | 4696.89 | 4700.86 | 5468.0 |
| 2022-05-31 00:00:00 | NQ | Futures | 14791.92 | 14808.16 | 14774.81 | 14791.34 | 3428.0 |
| 2022-05-31 01:00:00 | NQ | Futures | 14791.05 | 14806.13 | 14773.07 | 14775.1 | 5032.0 |
| 2022-05-31 02:00:00 | NQ | Futures | 14776.55 | 14783.8 | 14690.72 | 14725.22 | 11658.0 |
| 2022-05-31 03:00:00 | NQ | Futures | 14724.06 | 14737.11 | 14651.28 | 14675.93 | 16040.0 |
| 2022-05-31 04:00:00 | NQ | Futures | 14676.22 | 14789.89 | 14676.22 | 14753.06 | 15787.0 |
| 2022-05-31 05:00:00 | NQ | Futures | 14751.9 | 14753.64 | 14634.17 | 14662.59 | 18055.0 |
| 2022-05-31 06:00:00 | NQ | Futures | 14662.59 | 14714.49 | 14632.72 | 14682.6 | 11545.0 |
| 2022-05-31 07:00:00 | NQ | Futures | 14683.47 | 14738.27 | 14682.6 | 14702.02 | 11662.0 |
| 2022-05-31 08:00:00 | NQ | Futures | 14702.02 | 14706.66 | 14608.65 | 14621.99 | 21495.0 |
| 2022-05-31 09:00:00 | NQ | Futures | 14622.86 | 14716.81 | 14522.82 | 14558.2 | 83773.0 |
| 2022-05-31 10:00:00 | NQ | Futures | 14559.65 | 14668.68 | 14475.55 | 14638.81 | 98261.0 |
| 2022-05-31 11:00:00 | NQ | Futures | 14639.68 | 14756.83 | 14574.15 | 14742.33 | 70218.0 |
| 2022-05-31 12:00:00 | NQ | Futures | 14742.62 | 14795.69 | 14685.79 | 14767.85 | 65427.0 |
| 2022-05-31 13:00:00 | NQ | Futures | 14768.14 | 14803.52 | 14683.18 | 14798.59 | 52991.0 |
| 2022-05-31 14:00:00 | NQ | Futures | 14797.72 | 14810.19 | 14616.77 | 14651.57 | 57223.0 |
| 2022-05-31 15:00:00 | NQ | Futures | 14651.86 | 14782.06 | 14621.99 | 14667.23 | 86299.0 |
| 2022-05-31 16:00:00 | NQ | Futures | 14667.23 | 14694.78 | 14653.31 | 14676.51 | 19775.0 |
| 2022-05-31 18:00:00 | NQ | Futures | 14687.24 | 14726.09 | 14679.99 | 14724.06 | 4528.0 |
| 2022-05-31 19:00:00 | NQ | Futures | 14723.77 | 14742.91 | 14711.59 | 14735.95 | 3297.0 |
| 2022-05-31 20:00:00 | NQ | Futures | 14736.24 | 14751.61 | 14724.93 | 14729.57 | 3633.0 |
| 2022-05-31 21:00:00 | NQ | Futures | 14727.25 | 14760.02 | 14722.32 | 14743.49 | 4104.0 |
| 2022-05-31 22:00:00 | NQ | Futures | 14742.91 | 14743.2 | 14702.89 | 14706.95 | 3132.0 |
| 2022-05-31 23:00:00 | NQ | Futures | 14706.95 | 14714.49 | 14686.66 | 14709.85 | 3314.0 |
| 2022-05-31 00:00:00 | YM | Futures | 37401.5 | 37429.6 | 37390.2 | 37422.9 | 847.0 |
| 2022-05-31 01:00:00 | YM | Futures | 37427.4 | 37456.7 | 37394.7 | 37402.6 | 1537.0 |
| 2022-05-31 02:00:00 | YM | Futures | 37402.6 | 37425.1 | 37272.9 | 37294.4 | 3272.0 |
| 2022-05-31 03:00:00 | YM | Futures | 37293.2 | 37310.1 | 37203.0 | 37242.5 | 4088.0 |
> showing 50 of 2,049 rows — these rows as CSV