PREVIEW / futures_1hour / 2021-02-24
file: by_date/futures_1hour/2021/2021-02-24.parquet size: 65 KB rows: 1,950
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-24 00:00:00 | ES | Futures | 4346.4 | 4347.52 | 4333.77 | 4334.05 | 21643.0 |
| 2021-02-24 01:00:00 | ES | Futures | 4334.05 | 4337.7 | 4324.23 | 4332.09 | 22767.0 |
| 2021-02-24 02:00:00 | ES | Futures | 4332.09 | 4345.28 | 4331.8 | 4342.19 | 20712.0 |
| 2021-02-24 03:00:00 | ES | Futures | 4341.91 | 4353.14 | 4338.54 | 4352.01 | 30097.0 |
| 2021-02-24 04:00:00 | ES | Futures | 4352.01 | 4362.12 | 4349.49 | 4359.87 | 28749.0 |
| 2021-02-24 05:00:00 | ES | Futures | 4360.15 | 4364.92 | 4355.1 | 4359.03 | 22605.0 |
| 2021-02-24 06:00:00 | ES | Futures | 4359.03 | 4360.99 | 4353.7 | 4355.1 | 20247.0 |
| 2021-02-24 07:00:00 | ES | Futures | 4355.1 | 4374.47 | 4354.54 | 4371.1 | 39998.0 |
| 2021-02-24 08:00:00 | ES | Futures | 4370.82 | 4371.94 | 4336.58 | 4341.91 | 89101.0 |
| 2021-02-24 09:00:00 | ES | Futures | 4341.91 | 4349.77 | 4329.84 | 4341.07 | 349214.0 |
| 2021-02-24 10:00:00 | ES | Futures | 4341.07 | 4366.33 | 4328.44 | 4363.24 | 290178.0 |
| 2021-02-24 11:00:00 | ES | Futures | 4363.24 | 4382.61 | 4362.12 | 4381.2 | 186463.0 |
| 2021-02-24 12:00:00 | ES | Futures | 4381.2 | 4395.8 | 4380.92 | 4387.66 | 129429.0 |
| 2021-02-24 13:00:00 | ES | Futures | 4387.66 | 4405.9 | 4384.01 | 4404.5 | 157621.0 |
| 2021-02-24 14:00:00 | ES | Futures | 4404.5 | 4406.18 | 4392.99 | 4394.67 | 116981.0 |
| 2021-02-24 15:00:00 | ES | Futures | 4394.67 | 4407.3 | 4393.55 | 4401.41 | 191572.0 |
| 2021-02-24 16:00:00 | ES | Futures | 4401.69 | 4409.55 | 4400.85 | 4404.78 | 64397.0 |
| 2021-02-24 18:00:00 | ES | Futures | 4404.78 | 4417.13 | 4401.97 | 4415.44 | 11236.0 |
| 2021-02-24 19:00:00 | ES | Futures | 4415.72 | 4416.0 | 4408.15 | 4411.51 | 12944.0 |
| 2021-02-24 20:00:00 | ES | Futures | 4411.23 | 4413.2 | 4403.37 | 4404.5 | 21826.0 |
| 2021-02-24 21:00:00 | ES | Futures | 4404.5 | 4411.23 | 4402.81 | 4408.15 | 10253.0 |
| 2021-02-24 22:00:00 | ES | Futures | 4408.15 | 4412.92 | 4407.02 | 4411.51 | 6864.0 |
| 2021-02-24 23:00:00 | ES | Futures | 4411.79 | 4416.29 | 4410.39 | 4413.2 | 5415.0 |
| 2021-02-24 00:00:00 | NQ | Futures | 15233.77 | 15237.24 | 15130.44 | 15152.43 | 13597.0 |
| 2021-02-24 01:00:00 | NQ | Futures | 15152.43 | 15159.38 | 15081.81 | 15118.28 | 9871.0 |
| 2021-02-24 02:00:00 | NQ | Futures | 15119.44 | 15231.45 | 15115.39 | 15205.4 | 11189.0 |
| 2021-02-24 03:00:00 | NQ | Futures | 15205.69 | 15263.58 | 15190.64 | 15259.53 | 13783.0 |
| 2021-02-24 04:00:00 | NQ | Futures | 15258.95 | 15322.62 | 15248.53 | 15293.1 | 13366.0 |
| 2021-02-24 05:00:00 | NQ | Futures | 15293.39 | 15333.62 | 15263.29 | 15300.34 | 13086.0 |
| 2021-02-24 06:00:00 | NQ | Futures | 15300.34 | 15311.04 | 15237.53 | 15256.34 | 9915.0 |
| 2021-02-24 07:00:00 | NQ | Futures | 15254.89 | 15392.66 | 15253.45 | 15375.3 | 19645.0 |
| 2021-02-24 08:00:00 | NQ | Futures | 15375.3 | 15386.01 | 15113.65 | 15150.12 | 42931.0 |
| 2021-02-24 09:00:00 | NQ | Futures | 15150.12 | 15190.93 | 15052.87 | 15087.31 | 118403.0 |
| 2021-02-24 10:00:00 | NQ | Futures | 15087.6 | 15186.88 | 15001.93 | 15172.98 | 98528.0 |
| 2021-02-24 11:00:00 | NQ | Futures | 15172.98 | 15278.92 | 15155.91 | 15263.58 | 53807.0 |
| 2021-02-24 12:00:00 | NQ | Futures | 15263.29 | 15344.33 | 15263.29 | 15290.49 | 41319.0 |
| 2021-02-24 13:00:00 | NQ | Futures | 15290.78 | 15359.67 | 15248.82 | 15343.17 | 42783.0 |
| 2021-02-24 14:00:00 | NQ | Futures | 15343.17 | 15352.72 | 15291.65 | 15322.04 | 33900.0 |
| 2021-02-24 15:00:00 | NQ | Futures | 15322.33 | 15408.29 | 15311.33 | 15392.38 | 48624.0 |
| 2021-02-24 16:00:00 | NQ | Futures | 15392.38 | 15437.24 | 15383.4 | 15414.08 | 11644.0 |
| 2021-02-24 18:00:00 | NQ | Futures | 15403.37 | 15444.47 | 15380.51 | 15430.29 | 6618.0 |
| 2021-02-24 19:00:00 | NQ | Futures | 15430.29 | 15437.53 | 15403.66 | 15414.95 | 9522.0 |
| 2021-02-24 20:00:00 | NQ | Futures | 15414.37 | 15426.53 | 15368.06 | 15379.35 | 15025.0 |
| 2021-02-24 21:00:00 | NQ | Futures | 15378.77 | 15416.98 | 15372.69 | 15401.06 | 6879.0 |
| 2021-02-24 22:00:00 | NQ | Futures | 15401.06 | 15425.95 | 15390.64 | 15420.16 | 8869.0 |
| 2021-02-24 23:00:00 | NQ | Futures | 15420.16 | 15441.87 | 15412.06 | 15430.87 | 3112.0 |
| 2021-02-24 00:00:00 | YM | Futures | 34862.0 | 34864.2 | 34799.9 | 34799.9 | 4799.0 |
| 2021-02-24 01:00:00 | YM | Futures | 34799.9 | 34824.3 | 34742.2 | 34793.2 | 5103.0 |
| 2021-02-24 02:00:00 | YM | Futures | 34791.0 | 34858.7 | 34791.0 | 34848.7 | 5068.0 |
| 2021-02-24 03:00:00 | YM | Futures | 34849.8 | 34914.1 | 34824.3 | 34909.7 | 6745.0 |
> showing 50 of 1,950 rows — these rows as CSV