PREVIEW / futures_1hour / 2021-02-02
file: by_date/futures_1hour/2021/2021-02-02.parquet size: 64 KB rows: 1,953
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-02-02 00:00:00 | ES | Futures | 4249.29 | 4254.62 | 4247.32 | 4254.62 | 8493.0 |
| 2021-02-02 01:00:00 | ES | Futures | 4254.62 | 4255.18 | 4245.92 | 4249.85 | 7162.0 |
| 2021-02-02 02:00:00 | ES | Futures | 4249.57 | 4250.41 | 4244.8 | 4249.01 | 8890.0 |
| 2021-02-02 03:00:00 | ES | Futures | 4248.73 | 4263.88 | 4245.36 | 4258.27 | 27177.0 |
| 2021-02-02 04:00:00 | ES | Futures | 4258.27 | 4268.66 | 4256.59 | 4265.57 | 22257.0 |
| 2021-02-02 05:00:00 | ES | Futures | 4265.57 | 4270.62 | 4261.36 | 4267.53 | 16206.0 |
| 2021-02-02 06:00:00 | ES | Futures | 4267.25 | 4269.22 | 4258.55 | 4258.55 | 16326.0 |
| 2021-02-02 07:00:00 | ES | Futures | 4258.55 | 4265.29 | 4257.99 | 4260.8 | 15789.0 |
| 2021-02-02 08:00:00 | ES | Futures | 4260.8 | 4266.97 | 4259.95 | 4265.29 | 25797.0 |
| 2021-02-02 09:00:00 | ES | Futures | 4265.29 | 4283.53 | 4260.8 | 4279.6 | 200640.0 |
| 2021-02-02 10:00:00 | ES | Futures | 4279.88 | 4298.69 | 4279.6 | 4293.07 | 260376.0 |
| 2021-02-02 11:00:00 | ES | Futures | 4293.07 | 4304.86 | 4291.67 | 4304.02 | 131563.0 |
| 2021-02-02 12:00:00 | ES | Futures | 4304.02 | 4306.26 | 4298.13 | 4303.74 | 92020.0 |
| 2021-02-02 13:00:00 | ES | Futures | 4303.74 | 4304.58 | 4295.04 | 4299.81 | 79738.0 |
| 2021-02-02 14:00:00 | ES | Futures | 4299.53 | 4305.42 | 4297.84 | 4304.86 | 71323.0 |
| 2021-02-02 15:00:00 | ES | Futures | 4304.86 | 4305.14 | 4284.93 | 4286.9 | 227312.0 |
| 2021-02-02 16:00:00 | ES | Futures | 4286.9 | 4298.41 | 4281.57 | 4297.84 | 92253.0 |
| 2021-02-02 18:00:00 | ES | Futures | 4299.25 | 4304.02 | 4294.2 | 4298.41 | 10925.0 |
| 2021-02-02 19:00:00 | ES | Futures | 4298.41 | 4310.19 | 4294.76 | 4307.11 | 16101.0 |
| 2021-02-02 20:00:00 | ES | Futures | 4307.11 | 4307.39 | 4297.56 | 4301.21 | 14968.0 |
| 2021-02-02 21:00:00 | ES | Futures | 4301.21 | 4303.74 | 4294.2 | 4301.49 | 9179.0 |
| 2021-02-02 22:00:00 | ES | Futures | 4301.21 | 4301.77 | 4295.6 | 4297.28 | 6068.0 |
| 2021-02-02 23:00:00 | ES | Futures | 4297.0 | 4302.62 | 4296.44 | 4301.49 | 4563.0 |
| 2021-02-02 00:00:00 | NQ | Futures | 15425.08 | 15433.76 | 15401.93 | 15432.32 | 5501.0 |
| 2021-02-02 01:00:00 | NQ | Futures | 15433.19 | 15439.26 | 15406.85 | 15425.66 | 3437.0 |
| 2021-02-02 02:00:00 | NQ | Futures | 15425.66 | 15425.66 | 15399.32 | 15411.77 | 6597.0 |
| 2021-02-02 03:00:00 | NQ | Futures | 15410.9 | 15471.68 | 15399.9 | 15437.82 | 12055.0 |
| 2021-02-02 04:00:00 | NQ | Futures | 15438.4 | 15488.76 | 15429.71 | 15474.57 | 9886.0 |
| 2021-02-02 05:00:00 | NQ | Futures | 15474.57 | 15485.28 | 15458.37 | 15470.81 | 5830.0 |
| 2021-02-02 06:00:00 | NQ | Futures | 15470.23 | 15473.13 | 15433.76 | 15434.63 | 5685.0 |
| 2021-02-02 07:00:00 | NQ | Futures | 15434.05 | 15460.97 | 15427.98 | 15440.71 | 6553.0 |
| 2021-02-02 08:00:00 | NQ | Futures | 15441.58 | 15467.63 | 15438.4 | 15459.52 | 14753.0 |
| 2021-02-02 09:00:00 | NQ | Futures | 15459.23 | 15540.57 | 15432.03 | 15492.23 | 71117.0 |
| 2021-02-02 10:00:00 | NQ | Futures | 15492.23 | 15557.06 | 15477.18 | 15530.72 | 78220.0 |
| 2021-02-02 11:00:00 | NQ | Futures | 15530.72 | 15581.67 | 15507.86 | 15579.06 | 46952.0 |
| 2021-02-02 12:00:00 | NQ | Futures | 15579.35 | 15596.14 | 15569.22 | 15583.4 | 35981.0 |
| 2021-02-02 13:00:00 | NQ | Futures | 15583.98 | 15612.06 | 15544.04 | 15596.43 | 33602.0 |
| 2021-02-02 14:00:00 | NQ | Futures | 15596.72 | 15621.9 | 15583.69 | 15616.4 | 27648.0 |
| 2021-02-02 15:00:00 | NQ | Futures | 15616.11 | 15616.4 | 15561.4 | 15569.8 | 53810.0 |
| 2021-02-02 16:00:00 | NQ | Futures | 15570.09 | 15640.71 | 15522.91 | 15627.11 | 27454.0 |
| 2021-02-02 18:00:00 | NQ | Futures | 15636.37 | 15641.0 | 15606.85 | 15616.11 | 4779.0 |
| 2021-02-02 19:00:00 | NQ | Futures | 15616.69 | 15668.5 | 15601.35 | 15661.26 | 6786.0 |
| 2021-02-02 20:00:00 | NQ | Futures | 15662.13 | 15663.29 | 15621.9 | 15641.87 | 5783.0 |
| 2021-02-02 21:00:00 | NQ | Futures | 15641.87 | 15656.63 | 15617.84 | 15643.31 | 4867.0 |
| 2021-02-02 22:00:00 | NQ | Futures | 15642.74 | 15646.21 | 15630.0 | 15640.13 | 2865.0 |
| 2021-02-02 23:00:00 | NQ | Futures | 15638.97 | 15660.97 | 15637.24 | 15649.39 | 2562.0 |
| 2021-02-02 00:00:00 | YM | Futures | 33556.5 | 33607.5 | 33548.7 | 33605.3 | 1910.0 |
| 2021-02-02 01:00:00 | YM | Futures | 33606.4 | 33615.3 | 33537.6 | 33558.7 | 1936.0 |
| 2021-02-02 02:00:00 | YM | Futures | 33559.8 | 33567.6 | 33521.0 | 33554.3 | 2450.0 |
| 2021-02-02 03:00:00 | YM | Futures | 33554.3 | 33666.3 | 33532.1 | 33643.0 | 5164.0 |
> showing 50 of 1,953 rows — these rows as CSV