PREVIEW / futures_1hour / 2022-12-02
file: by_date/futures_1hour/2022/2022-12-02.parquet size: 56 KB rows: 1,628
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-12-02 00:00:00 | ES | Futures | 4593.46 | 4595.71 | 4592.05 | 4595.15 | 8920.0 |
| 2022-12-02 01:00:00 | ES | Futures | 4595.15 | 4596.56 | 4594.58 | 4595.43 | 5333.0 |
| 2022-12-02 02:00:00 | ES | Futures | 4595.71 | 4598.81 | 4594.58 | 4595.15 | 10381.0 |
| 2022-12-02 03:00:00 | ES | Futures | 4595.15 | 4600.22 | 4591.76 | 4599.09 | 18961.0 |
| 2022-12-02 04:00:00 | ES | Futures | 4599.09 | 4603.32 | 4595.43 | 4603.32 | 13979.0 |
| 2022-12-02 05:00:00 | ES | Futures | 4603.04 | 4605.58 | 4599.66 | 4602.76 | 12645.0 |
| 2022-12-02 06:00:00 | ES | Futures | 4602.48 | 4602.48 | 4595.15 | 4597.68 | 8279.0 |
| 2022-12-02 07:00:00 | ES | Futures | 4597.68 | 4601.91 | 4592.05 | 4601.35 | 15223.0 |
| 2022-12-02 08:00:00 | ES | Futures | 4601.35 | 4605.58 | 4517.91 | 4539.61 | 196288.0 |
| 2022-12-02 09:00:00 | ES | Futures | 4539.61 | 4564.14 | 4524.11 | 4552.58 | 272182.0 |
| 2022-12-02 10:00:00 | ES | Futures | 4552.58 | 4576.26 | 4547.23 | 4563.29 | 286393.0 |
| 2022-12-02 11:00:00 | ES | Futures | 4563.58 | 4587.82 | 4558.22 | 4578.8 | 216184.0 |
| 2022-12-02 12:00:00 | ES | Futures | 4579.08 | 4589.23 | 4570.34 | 4571.75 | 130415.0 |
| 2022-12-02 13:00:00 | ES | Futures | 4571.75 | 4579.36 | 4566.68 | 4577.11 | 97460.0 |
| 2022-12-02 14:00:00 | ES | Futures | 4576.82 | 4593.46 | 4568.37 | 4591.76 | 122959.0 |
| 2022-12-02 15:00:00 | ES | Futures | 4591.76 | 4606.71 | 4583.31 | 4595.15 | 260607.0 |
| 2022-12-02 16:00:00 | ES | Futures | 4595.43 | 4595.71 | 4583.87 | 4585.56 | 49179.0 |
| 2022-12-02 00:00:00 | NQ | Futures | 13819.8 | 13823.25 | 13807.16 | 13817.5 | 2896.0 |
| 2022-12-02 01:00:00 | NQ | Futures | 13817.5 | 13822.39 | 13813.48 | 13816.93 | 1641.0 |
| 2022-12-02 02:00:00 | NQ | Futures | 13817.5 | 13831.01 | 13815.49 | 13819.23 | 3738.0 |
| 2022-12-02 03:00:00 | NQ | Futures | 13818.36 | 13847.67 | 13810.32 | 13846.52 | 7666.0 |
| 2022-12-02 04:00:00 | NQ | Futures | 13845.66 | 13858.88 | 13826.41 | 13857.15 | 5858.0 |
| 2022-12-02 05:00:00 | NQ | Futures | 13856.29 | 13862.32 | 13845.95 | 13855.14 | 4787.0 |
| 2022-12-02 06:00:00 | NQ | Futures | 13854.85 | 13854.85 | 13830.43 | 13838.48 | 3851.0 |
| 2022-12-02 07:00:00 | NQ | Futures | 13838.76 | 13856.58 | 13818.36 | 13856.0 | 7238.0 |
| 2022-12-02 08:00:00 | NQ | Futures | 13855.43 | 13869.51 | 13493.4 | 13589.65 | 70347.0 |
| 2022-12-02 09:00:00 | NQ | Futures | 13589.65 | 13694.53 | 13550.0 | 13646.54 | 102912.0 |
| 2022-12-02 10:00:00 | NQ | Futures | 13647.12 | 13737.34 | 13620.97 | 13681.02 | 86806.0 |
| 2022-12-02 11:00:00 | NQ | Futures | 13681.31 | 13766.93 | 13652.29 | 13726.13 | 60292.0 |
| 2022-12-02 12:00:00 | NQ | Futures | 13726.71 | 13768.66 | 13694.24 | 13702.57 | 41175.0 |
| 2022-12-02 13:00:00 | NQ | Futures | 13702.57 | 13729.87 | 13672.98 | 13718.37 | 32671.0 |
| 2022-12-02 14:00:00 | NQ | Futures | 13718.66 | 13780.72 | 13691.65 | 13778.14 | 39588.0 |
| 2022-12-02 15:00:00 | NQ | Futures | 13778.43 | 13846.23 | 13758.03 | 13807.45 | 78906.0 |
| 2022-12-02 16:00:00 | NQ | Futures | 13807.45 | 13808.31 | 13765.21 | 13767.51 | 12529.0 |
| 2022-12-02 00:00:00 | YM | Futures | 38582.4 | 38603.7 | 38574.5 | 38598.1 | 1088.0 |
| 2022-12-02 01:00:00 | YM | Futures | 38599.2 | 38608.2 | 38593.6 | 38602.6 | 883.0 |
| 2022-12-02 02:00:00 | YM | Futures | 38602.6 | 38623.9 | 38588.0 | 38590.2 | 1544.0 |
| 2022-12-02 03:00:00 | YM | Futures | 38591.4 | 38613.8 | 38556.6 | 38603.7 | 2811.0 |
| 2022-12-02 04:00:00 | YM | Futures | 38600.3 | 38629.5 | 38579.0 | 38627.3 | 2294.0 |
| 2022-12-02 05:00:00 | YM | Futures | 38626.2 | 38646.4 | 38600.3 | 38623.9 | 1992.0 |
| 2022-12-02 06:00:00 | YM | Futures | 38623.9 | 38623.9 | 38568.9 | 38582.4 | 1518.0 |
| 2022-12-02 07:00:00 | YM | Futures | 38583.5 | 38614.9 | 38547.6 | 38599.2 | 2070.0 |
| 2022-12-02 08:00:00 | YM | Futures | 38599.2 | 38623.9 | 38083.0 | 38208.7 | 22748.0 |
| 2022-12-02 09:00:00 | YM | Futures | 38207.6 | 38430.9 | 38098.7 | 38324.3 | 45060.0 |
| 2022-12-02 10:00:00 | YM | Futures | 38324.3 | 38516.2 | 38291.7 | 38434.3 | 35929.0 |
| 2022-12-02 11:00:00 | YM | Futures | 38433.1 | 38617.2 | 38399.5 | 38558.8 | 24499.0 |
| 2022-12-02 12:00:00 | YM | Futures | 38558.8 | 38607.1 | 38493.7 | 38501.6 | 13015.0 |
| 2022-12-02 13:00:00 | YM | Futures | 38502.7 | 38548.7 | 38476.9 | 38526.3 | 10997.0 |
| 2022-12-02 14:00:00 | YM | Futures | 38526.3 | 38672.2 | 38466.8 | 38658.7 | 12423.0 |
| 2022-12-02 15:00:00 | YM | Futures | 38658.7 | 38748.5 | 38588.0 | 38674.4 | 26423.0 |
> showing 50 of 1,628 rows — these rows as CSV