PREVIEW / futures_1hour / 2021-03-02
file: by_date/futures_1hour/2021/2021-03-02.parquet size: 63 KB rows: 1,919
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-03-02 00:00:00 | ES | Futures | 4360.71 | 4361.56 | 4352.01 | 4357.06 | 12632.0 |
| 2021-03-02 01:00:00 | ES | Futures | 4357.06 | 4368.57 | 4354.26 | 4362.4 | 11106.0 |
| 2021-03-02 02:00:00 | ES | Futures | 4362.4 | 4365.48 | 4350.89 | 4351.73 | 14363.0 |
| 2021-03-02 03:00:00 | ES | Futures | 4351.45 | 4366.05 | 4345.0 | 4345.56 | 32840.0 |
| 2021-03-02 04:00:00 | ES | Futures | 4345.56 | 4359.03 | 4340.51 | 4354.54 | 38901.0 |
| 2021-03-02 05:00:00 | ES | Futures | 4354.54 | 4363.52 | 4351.17 | 4361.27 | 21232.0 |
| 2021-03-02 06:00:00 | ES | Futures | 4360.99 | 4368.01 | 4359.59 | 4364.36 | 20516.0 |
| 2021-03-02 07:00:00 | ES | Futures | 4364.36 | 4375.03 | 4364.08 | 4373.9 | 24897.0 |
| 2021-03-02 08:00:00 | ES | Futures | 4373.62 | 4375.03 | 4365.2 | 4371.94 | 29373.0 |
| 2021-03-02 09:00:00 | ES | Futures | 4371.94 | 4382.32 | 4360.99 | 4373.34 | 205995.0 |
| 2021-03-02 10:00:00 | ES | Futures | 4373.34 | 4378.11 | 4348.08 | 4360.15 | 250390.0 |
| 2021-03-02 11:00:00 | ES | Futures | 4359.87 | 4363.24 | 4342.75 | 4353.42 | 205626.0 |
| 2021-03-02 12:00:00 | ES | Futures | 4353.14 | 4370.82 | 4349.77 | 4366.05 | 120301.0 |
| 2021-03-02 13:00:00 | ES | Futures | 4366.05 | 4378.4 | 4365.77 | 4372.78 | 93723.0 |
| 2021-03-02 14:00:00 | ES | Futures | 4372.5 | 4375.87 | 4360.43 | 4370.26 | 135735.0 |
| 2021-03-02 15:00:00 | ES | Futures | 4370.26 | 4373.9 | 4339.66 | 4342.75 | 249093.0 |
| 2021-03-02 16:00:00 | ES | Futures | 4342.47 | 4349.77 | 4339.94 | 4341.07 | 54986.0 |
| 2021-03-02 18:00:00 | ES | Futures | 4341.91 | 4354.82 | 4341.63 | 4352.29 | 11843.0 |
| 2021-03-02 19:00:00 | ES | Futures | 4352.29 | 4358.19 | 4350.05 | 4355.38 | 13911.0 |
| 2021-03-02 20:00:00 | ES | Futures | 4355.38 | 4355.66 | 4343.87 | 4349.49 | 16757.0 |
| 2021-03-02 21:00:00 | ES | Futures | 4349.49 | 4357.91 | 4348.08 | 4356.78 | 9150.0 |
| 2021-03-02 22:00:00 | ES | Futures | 4356.5 | 4359.59 | 4354.54 | 4356.5 | 7175.0 |
| 2021-03-02 23:00:00 | ES | Futures | 4356.5 | 4360.15 | 4356.22 | 4358.75 | 5606.0 |
| 2021-03-02 00:00:00 | NQ | Futures | 15328.12 | 15331.88 | 15290.21 | 15305.83 | 5783.0 |
| 2021-03-02 01:00:00 | NQ | Futures | 15305.26 | 15358.22 | 15297.44 | 15326.38 | 7215.0 |
| 2021-03-02 02:00:00 | NQ | Futures | 15326.67 | 15338.83 | 15268.21 | 15271.1 | 9035.0 |
| 2021-03-02 03:00:00 | NQ | Futures | 15270.52 | 15334.49 | 15243.03 | 15250.84 | 15367.0 |
| 2021-03-02 04:00:00 | NQ | Futures | 15251.71 | 15302.94 | 15237.82 | 15280.08 | 11916.0 |
| 2021-03-02 05:00:00 | NQ | Futures | 15280.94 | 15325.23 | 15263.58 | 15314.81 | 8444.0 |
| 2021-03-02 06:00:00 | NQ | Futures | 15313.94 | 15335.94 | 15304.39 | 15317.12 | 6805.0 |
| 2021-03-02 07:00:00 | NQ | Futures | 15317.12 | 15369.51 | 15315.39 | 15368.06 | 8616.0 |
| 2021-03-02 08:00:00 | NQ | Futures | 15368.06 | 15377.04 | 15320.6 | 15353.59 | 14067.0 |
| 2021-03-02 09:00:00 | NQ | Futures | 15353.59 | 15401.35 | 15258.08 | 15304.1 | 77119.0 |
| 2021-03-02 10:00:00 | NQ | Futures | 15303.81 | 15338.25 | 15204.53 | 15254.03 | 87636.0 |
| 2021-03-02 11:00:00 | NQ | Futures | 15253.74 | 15282.97 | 15164.3 | 15211.77 | 71684.0 |
| 2021-03-02 12:00:00 | NQ | Futures | 15211.77 | 15275.44 | 15191.22 | 15244.76 | 42343.0 |
| 2021-03-02 13:00:00 | NQ | Futures | 15245.05 | 15296.28 | 15238.98 | 15265.6 | 35067.0 |
| 2021-03-02 14:00:00 | NQ | Futures | 15265.31 | 15289.34 | 15200.77 | 15243.61 | 42974.0 |
| 2021-03-02 15:00:00 | NQ | Futures | 15243.61 | 15266.18 | 15106.42 | 15117.99 | 61946.0 |
| 2021-03-02 16:00:00 | NQ | Futures | 15118.28 | 15146.65 | 15106.42 | 15113.94 | 11174.0 |
| 2021-03-02 18:00:00 | NQ | Futures | 15121.47 | 15172.41 | 15115.97 | 15159.67 | 5442.0 |
| 2021-03-02 19:00:00 | NQ | Futures | 15160.25 | 15198.17 | 15151.86 | 15184.85 | 8825.0 |
| 2021-03-02 20:00:00 | NQ | Futures | 15184.56 | 15185.14 | 15127.83 | 15159.38 | 10611.0 |
| 2021-03-02 21:00:00 | NQ | Futures | 15159.67 | 15199.9 | 15153.3 | 15195.27 | 5155.0 |
| 2021-03-02 22:00:00 | NQ | Futures | 15194.98 | 15213.22 | 15194.4 | 15206.56 | 4540.0 |
| 2021-03-02 23:00:00 | NQ | Futures | 15205.98 | 15217.27 | 15203.09 | 15211.48 | 2963.0 |
| 2021-03-02 00:00:00 | YM | Futures | 34835.4 | 34840.9 | 34774.4 | 34815.4 | 2315.0 |
| 2021-03-02 01:00:00 | YM | Futures | 34815.4 | 34904.2 | 34791.0 | 34860.9 | 2851.0 |
| 2021-03-02 02:00:00 | YM | Futures | 34860.9 | 34878.6 | 34786.6 | 34795.5 | 3165.0 |
| 2021-03-02 03:00:00 | YM | Futures | 34795.5 | 34883.1 | 34744.4 | 34751.1 | 7237.0 |
> showing 50 of 1,919 rows — these rows as CSV