PREVIEW / futures_1hour / 2022-08-02
file: by_date/futures_1hour/2022/2022-08-02.parquet size: 70 KB rows: 2,061
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-08-02 00:00:00 | ES | Futures | 4650.18 | 4651.32 | 4647.35 | 4649.62 | 3375.0 |
| 2022-08-02 01:00:00 | ES | Futures | 4649.33 | 4653.02 | 4643.95 | 4645.94 | 6310.0 |
| 2022-08-02 02:00:00 | ES | Futures | 4645.94 | 4651.32 | 4644.52 | 4647.07 | 8834.0 |
| 2022-08-02 03:00:00 | ES | Futures | 4647.07 | 4649.33 | 4632.06 | 4643.95 | 26905.0 |
| 2022-08-02 04:00:00 | ES | Futures | 4644.24 | 4647.35 | 4634.89 | 4638.57 | 17219.0 |
| 2022-08-02 05:00:00 | ES | Futures | 4638.29 | 4641.97 | 4632.62 | 4632.91 | 12202.0 |
| 2022-08-02 06:00:00 | ES | Futures | 4632.91 | 4635.74 | 4626.96 | 4633.19 | 21986.0 |
| 2022-08-02 07:00:00 | ES | Futures | 4633.19 | 4644.24 | 4632.62 | 4639.7 | 26406.0 |
| 2022-08-02 08:00:00 | ES | Futures | 4639.99 | 4643.39 | 4634.32 | 4640.27 | 29079.0 |
| 2022-08-02 09:00:00 | ES | Futures | 4640.55 | 4656.98 | 4633.47 | 4643.95 | 237367.0 |
| 2022-08-02 10:00:00 | ES | Futures | 4643.95 | 4675.68 | 4623.56 | 4665.48 | 341400.0 |
| 2022-08-02 11:00:00 | ES | Futures | 4665.48 | 4672.28 | 4653.87 | 4667.75 | 191346.0 |
| 2022-08-02 12:00:00 | ES | Futures | 4668.03 | 4694.38 | 4665.76 | 4689.84 | 161510.0 |
| 2022-08-02 13:00:00 | ES | Futures | 4689.84 | 4690.41 | 4646.79 | 4653.87 | 207983.0 |
| 2022-08-02 14:00:00 | ES | Futures | 4654.15 | 4669.45 | 4649.62 | 4654.15 | 194903.0 |
| 2022-08-02 15:00:00 | ES | Futures | 4654.15 | 4659.82 | 4636.59 | 4638.85 | 250747.0 |
| 2022-08-02 16:00:00 | ES | Futures | 4639.14 | 4643.39 | 4633.47 | 4641.4 | 59112.0 |
| 2022-08-02 18:00:00 | ES | Futures | 4642.25 | 4648.49 | 4641.12 | 4644.52 | 8406.0 |
| 2022-08-02 19:00:00 | ES | Futures | 4644.24 | 4646.79 | 4637.44 | 4638.29 | 5336.0 |
| 2022-08-02 20:00:00 | ES | Futures | 4638.0 | 4642.82 | 4628.09 | 4634.04 | 12724.0 |
| 2022-08-02 21:00:00 | ES | Futures | 4634.04 | 4645.94 | 4633.47 | 4643.39 | 10801.0 |
| 2022-08-02 22:00:00 | ES | Futures | 4643.67 | 4648.77 | 4641.12 | 4644.8 | 7972.0 |
| 2022-08-02 23:00:00 | ES | Futures | 4645.09 | 4647.35 | 4642.82 | 4644.8 | 6183.0 |
| 2022-08-02 00:00:00 | NQ | Futures | 14936.59 | 14939.78 | 14923.0 | 14931.68 | 1744.0 |
| 2022-08-02 01:00:00 | NQ | Futures | 14931.1 | 14946.72 | 14916.64 | 14924.45 | 3070.0 |
| 2022-08-02 02:00:00 | NQ | Futures | 14924.73 | 14946.43 | 14920.69 | 14925.6 | 3477.0 |
| 2022-08-02 03:00:00 | NQ | Futures | 14925.02 | 14936.3 | 14859.66 | 14900.73 | 12309.0 |
| 2022-08-02 04:00:00 | NQ | Futures | 14901.02 | 14911.43 | 14864.28 | 14877.01 | 9420.0 |
| 2022-08-02 05:00:00 | NQ | Futures | 14877.01 | 14890.6 | 14840.86 | 14843.46 | 6164.0 |
| 2022-08-02 06:00:00 | NQ | Futures | 14842.59 | 14862.84 | 14826.1 | 14859.08 | 8233.0 |
| 2022-08-02 07:00:00 | NQ | Futures | 14859.08 | 14903.33 | 14857.34 | 14878.46 | 10469.0 |
| 2022-08-02 08:00:00 | NQ | Futures | 14879.61 | 14895.52 | 14843.17 | 14869.2 | 12824.0 |
| 2022-08-02 09:00:00 | NQ | Futures | 14869.78 | 14990.39 | 14862.55 | 14939.2 | 93445.0 |
| 2022-08-02 10:00:00 | NQ | Futures | 14939.2 | 15041.88 | 14832.18 | 15003.99 | 112464.0 |
| 2022-08-02 11:00:00 | NQ | Futures | 15003.99 | 15035.51 | 14949.32 | 15018.45 | 65642.0 |
| 2022-08-02 12:00:00 | NQ | Futures | 15018.74 | 15152.66 | 15009.77 | 15126.33 | 73709.0 |
| 2022-08-02 13:00:00 | NQ | Futures | 15126.62 | 15129.52 | 14928.49 | 14960.89 | 82294.0 |
| 2022-08-02 14:00:00 | NQ | Futures | 14960.6 | 15041.01 | 14941.51 | 14990.1 | 68420.0 |
| 2022-08-02 15:00:00 | NQ | Futures | 14990.1 | 15017.29 | 14947.58 | 14950.77 | 68992.0 |
| 2022-08-02 16:00:00 | NQ | Futures | 14950.19 | 14960.02 | 14909.12 | 14948.16 | 14833.0 |
| 2022-08-02 18:00:00 | NQ | Futures | 14949.03 | 14964.94 | 14935.15 | 14949.32 | 3640.0 |
| 2022-08-02 19:00:00 | NQ | Futures | 14949.61 | 14962.05 | 14927.05 | 14928.49 | 3277.0 |
| 2022-08-02 20:00:00 | NQ | Futures | 14927.92 | 14947.87 | 14886.84 | 14909.69 | 6063.0 |
| 2022-08-02 21:00:00 | NQ | Futures | 14910.85 | 14950.19 | 14908.25 | 14937.17 | 5139.0 |
| 2022-08-02 22:00:00 | NQ | Futures | 14938.04 | 14962.34 | 14930.81 | 14944.11 | 3897.0 |
| 2022-08-02 23:00:00 | NQ | Futures | 14944.98 | 14960.31 | 14944.4 | 14956.84 | 3233.0 |
| 2022-08-02 00:00:00 | YM | Futures | 36861.9 | 36873.1 | 36848.3 | 36870.9 | 1214.0 |
| 2022-08-02 01:00:00 | YM | Futures | 36870.9 | 36894.6 | 36825.7 | 36837.0 | 1171.0 |
| 2022-08-02 02:00:00 | YM | Futures | 36838.2 | 36877.7 | 36828.0 | 36846.1 | 1736.0 |
| 2022-08-02 03:00:00 | YM | Futures | 36846.1 | 36864.1 | 36755.8 | 36835.9 | 6594.0 |
> showing 50 of 2,061 rows — these rows as CSV