PREVIEW / futures_1hour / 2022-06-02
file: by_date/futures_1hour/2022/2022-06-02.parquet size: 63 KB rows: 1,931
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-06-02 00:00:00 | ES | Futures | 4647.85 | 4652.95 | 4646.15 | 4651.82 | 4281.0 |
| 2022-06-02 01:00:00 | ES | Futures | 4651.82 | 4653.52 | 4639.92 | 4649.27 | 9451.0 |
| 2022-06-02 02:00:00 | ES | Futures | 4649.27 | 4657.49 | 4646.15 | 4656.92 | 9211.0 |
| 2022-06-02 03:00:00 | ES | Futures | 4656.92 | 4666.56 | 4655.79 | 4659.19 | 18145.0 |
| 2022-06-02 04:00:00 | ES | Futures | 4659.47 | 4671.94 | 4654.94 | 4665.43 | 16905.0 |
| 2022-06-02 05:00:00 | ES | Futures | 4665.14 | 4673.08 | 4658.62 | 4665.99 | 11166.0 |
| 2022-06-02 06:00:00 | ES | Futures | 4665.99 | 4676.2 | 4660.32 | 4674.5 | 9798.0 |
| 2022-06-02 07:00:00 | ES | Futures | 4674.5 | 4675.06 | 4667.69 | 4671.66 | 10846.0 |
| 2022-06-02 08:00:00 | ES | Futures | 4671.94 | 4673.93 | 4660.32 | 4661.17 | 28344.0 |
| 2022-06-02 09:00:00 | ES | Futures | 4661.17 | 4664.86 | 4620.08 | 4630.28 | 224624.0 |
| 2022-06-02 10:00:00 | ES | Futures | 4630.0 | 4657.49 | 4616.96 | 4647.85 | 261747.0 |
| 2022-06-02 11:00:00 | ES | Futures | 4647.85 | 4689.23 | 4645.87 | 4677.05 | 175184.0 |
| 2022-06-02 12:00:00 | ES | Futures | 4677.33 | 4703.97 | 4674.21 | 4699.72 | 118809.0 |
| 2022-06-02 13:00:00 | ES | Futures | 4700.01 | 4710.49 | 4692.07 | 4708.23 | 104530.0 |
| 2022-06-02 14:00:00 | ES | Futures | 4708.23 | 4717.01 | 4703.41 | 4704.26 | 106667.0 |
| 2022-06-02 15:00:00 | ES | Futures | 4704.26 | 4735.15 | 4703.12 | 4734.3 | 232671.0 |
| 2022-06-02 16:00:00 | ES | Futures | 4734.3 | 4737.99 | 4727.22 | 4736.57 | 71034.0 |
| 2022-06-02 18:00:00 | ES | Futures | 4736.57 | 4749.32 | 4736.29 | 4739.97 | 11074.0 |
| 2022-06-02 19:00:00 | ES | Futures | 4740.25 | 4745.36 | 4739.69 | 4741.1 | 6071.0 |
| 2022-06-02 20:00:00 | ES | Futures | 4741.1 | 4743.94 | 4733.45 | 4734.02 | 14061.0 |
| 2022-06-02 21:00:00 | ES | Futures | 4734.02 | 4741.39 | 4733.45 | 4739.4 | 8038.0 |
| 2022-06-02 22:00:00 | ES | Futures | 4739.69 | 4740.54 | 4735.15 | 4737.14 | 5366.0 |
| 2022-06-02 23:00:00 | ES | Futures | 4736.85 | 4737.7 | 4733.45 | 4734.87 | 4524.0 |
| 2022-06-02 00:00:00 | NQ | Futures | 14568.64 | 14579.37 | 14559.07 | 14574.15 | 1562.0 |
| 2022-06-02 01:00:00 | NQ | Futures | 14575.02 | 14581.11 | 14531.81 | 14562.26 | 4862.0 |
| 2022-06-02 02:00:00 | NQ | Futures | 14561.68 | 14602.56 | 14549.79 | 14597.63 | 4562.0 |
| 2022-06-02 03:00:00 | NQ | Futures | 14597.92 | 14650.41 | 14588.35 | 14621.7 | 10400.0 |
| 2022-06-02 04:00:00 | NQ | Futures | 14621.41 | 14668.68 | 14596.76 | 14634.46 | 8887.0 |
| 2022-06-02 05:00:00 | NQ | Futures | 14633.88 | 14665.78 | 14611.26 | 14639.1 | 6539.0 |
| 2022-06-02 06:00:00 | NQ | Futures | 14639.1 | 14679.12 | 14617.06 | 14669.26 | 6512.0 |
| 2022-06-02 07:00:00 | NQ | Futures | 14669.26 | 14671.29 | 14637.36 | 14656.21 | 7189.0 |
| 2022-06-02 08:00:00 | NQ | Futures | 14655.63 | 14665.78 | 14596.76 | 14600.53 | 17975.0 |
| 2022-06-02 09:00:00 | NQ | Futures | 14600.82 | 14616.48 | 14432.06 | 14534.71 | 102244.0 |
| 2022-06-02 10:00:00 | NQ | Futures | 14535.58 | 14652.44 | 14494.98 | 14614.45 | 97432.0 |
| 2022-06-02 11:00:00 | NQ | Futures | 14615.32 | 14767.56 | 14603.43 | 14721.74 | 74224.0 |
| 2022-06-02 12:00:00 | NQ | Futures | 14723.48 | 14847.59 | 14712.75 | 14831.35 | 57479.0 |
| 2022-06-02 13:00:00 | NQ | Futures | 14831.93 | 14885.87 | 14804.39 | 14882.97 | 47464.0 |
| 2022-06-02 14:00:00 | NQ | Futures | 14883.55 | 14924.44 | 14865.86 | 14869.63 | 48494.0 |
| 2022-06-02 15:00:00 | NQ | Futures | 14870.21 | 14961.84 | 14856.29 | 14956.04 | 71816.0 |
| 2022-06-02 16:00:00 | NQ | Futures | 14956.04 | 14967.06 | 14927.92 | 14958.94 | 17361.0 |
| 2022-06-02 18:00:00 | NQ | Futures | 14958.07 | 15015.2 | 14957.2 | 14982.43 | 5825.0 |
| 2022-06-02 19:00:00 | NQ | Futures | 14982.43 | 15000.99 | 14980.69 | 14988.52 | 2980.0 |
| 2022-06-02 20:00:00 | NQ | Futures | 14986.78 | 14993.74 | 14948.5 | 14953.43 | 5376.0 |
| 2022-06-02 21:00:00 | NQ | Futures | 14952.27 | 14978.66 | 14945.89 | 14973.15 | 4125.0 |
| 2022-06-02 22:00:00 | NQ | Futures | 14973.44 | 14978.37 | 14954.01 | 14960.1 | 2679.0 |
| 2022-06-02 23:00:00 | NQ | Futures | 14960.68 | 14967.64 | 14948.5 | 14952.27 | 2881.0 |
| 2022-06-02 00:00:00 | YM | Futures | 36957.3 | 36992.2 | 36944.9 | 36982.1 | 714.0 |
| 2022-06-02 01:00:00 | YM | Futures | 36984.3 | 36995.6 | 36900.9 | 36969.7 | 1379.0 |
| 2022-06-02 02:00:00 | YM | Futures | 36967.4 | 37026.1 | 36955.0 | 37019.3 | 1470.0 |
| 2022-06-02 03:00:00 | YM | Futures | 37020.4 | 37073.4 | 37005.8 | 37021.5 | 3198.0 |
> showing 50 of 1,931 rows — these rows as CSV