PREVIEW / futures_1hour / 2022-10-26
file: by_date/futures_1hour/2022/2022-10-26.parquet size: 70 KB rows: 2,103
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-10-26 00:00:00 | ES | Futures | 4325.38 | 4328.19 | 4323.68 | 4324.81 | 3497.0 |
| 2022-10-26 01:00:00 | ES | Futures | 4324.53 | 4328.19 | 4320.02 | 4320.58 | 8640.0 |
| 2022-10-26 02:00:00 | ES | Futures | 4320.58 | 4329.04 | 4318.89 | 4323.4 | 15721.0 |
| 2022-10-26 03:00:00 | ES | Futures | 4323.4 | 4337.5 | 4321.99 | 4334.11 | 30308.0 |
| 2022-10-26 04:00:00 | ES | Futures | 4334.11 | 4345.11 | 4332.7 | 4343.13 | 27853.0 |
| 2022-10-26 05:00:00 | ES | Futures | 4342.85 | 4342.85 | 4328.76 | 4329.04 | 18550.0 |
| 2022-10-26 06:00:00 | ES | Futures | 4329.04 | 4339.19 | 4325.09 | 4337.21 | 18936.0 |
| 2022-10-26 07:00:00 | ES | Futures | 4337.21 | 4345.67 | 4327.63 | 4331.01 | 36213.0 |
| 2022-10-26 08:00:00 | ES | Futures | 4331.01 | 4337.78 | 4320.3 | 4327.63 | 47291.0 |
| 2022-10-26 09:00:00 | ES | Futures | 4327.63 | 4344.26 | 4323.4 | 4327.63 | 264761.0 |
| 2022-10-26 10:00:00 | ES | Futures | 4328.19 | 4376.12 | 4328.19 | 4365.97 | 374497.0 |
| 2022-10-26 11:00:00 | ES | Futures | 4365.69 | 4394.72 | 4365.69 | 4385.98 | 222524.0 |
| 2022-10-26 12:00:00 | ES | Futures | 4385.7 | 4390.77 | 4354.69 | 4358.07 | 167725.0 |
| 2022-10-26 13:00:00 | ES | Futures | 4358.07 | 4359.2 | 4339.47 | 4351.31 | 202463.0 |
| 2022-10-26 14:00:00 | ES | Futures | 4351.59 | 4358.07 | 4331.01 | 4335.81 | 156814.0 |
| 2022-10-26 15:00:00 | ES | Futures | 4335.81 | 4343.13 | 4325.66 | 4332.14 | 258147.0 |
| 2022-10-26 16:00:00 | ES | Futures | 4332.14 | 4349.9 | 4330.45 | 4345.39 | 87239.0 |
| 2022-10-26 18:00:00 | ES | Futures | 4334.68 | 4344.83 | 4332.14 | 4343.7 | 10228.0 |
| 2022-10-26 19:00:00 | ES | Futures | 4343.7 | 4355.54 | 4343.7 | 4353.28 | 11247.0 |
| 2022-10-26 20:00:00 | ES | Futures | 4353.0 | 4361.46 | 4345.95 | 4349.34 | 16114.0 |
| 2022-10-26 21:00:00 | ES | Futures | 4349.34 | 4358.07 | 4348.21 | 4352.72 | 13544.0 |
| 2022-10-26 22:00:00 | ES | Futures | 4352.44 | 4352.72 | 4341.73 | 4345.95 | 11376.0 |
| 2022-10-26 23:00:00 | ES | Futures | 4346.24 | 4354.41 | 4346.24 | 4354.41 | 8637.0 |
| 2022-10-26 00:00:00 | NQ | Futures | 13209.81 | 13220.73 | 13203.49 | 13208.37 | 2055.0 |
| 2022-10-26 01:00:00 | NQ | Futures | 13206.65 | 13219.29 | 13189.41 | 13195.15 | 4203.0 |
| 2022-10-26 02:00:00 | NQ | Futures | 13194.58 | 13227.33 | 13190.27 | 13210.1 | 6934.0 |
| 2022-10-26 03:00:00 | NQ | Futures | 13210.38 | 13263.82 | 13205.79 | 13252.91 | 16420.0 |
| 2022-10-26 04:00:00 | NQ | Futures | 13253.77 | 13295.72 | 13252.04 | 13284.8 | 15268.0 |
| 2022-10-26 05:00:00 | NQ | Futures | 13284.23 | 13284.23 | 13227.33 | 13237.97 | 10873.0 |
| 2022-10-26 06:00:00 | NQ | Futures | 13237.68 | 13263.54 | 13222.45 | 13255.78 | 10500.0 |
| 2022-10-26 07:00:00 | NQ | Futures | 13255.49 | 13281.06 | 13219.58 | 13235.09 | 15275.0 |
| 2022-10-26 08:00:00 | NQ | Futures | 13234.23 | 13249.46 | 13192.86 | 13224.75 | 20802.0 |
| 2022-10-26 09:00:00 | NQ | Futures | 13224.75 | 13251.47 | 13139.99 | 13197.17 | 101928.0 |
| 2022-10-26 10:00:00 | NQ | Futures | 13197.45 | 13394.85 | 13197.45 | 13337.67 | 121511.0 |
| 2022-10-26 11:00:00 | NQ | Futures | 13337.67 | 13450.87 | 13337.38 | 13408.06 | 79108.0 |
| 2022-10-26 12:00:00 | NQ | Futures | 13408.06 | 13423.58 | 13270.15 | 13281.93 | 62444.0 |
| 2022-10-26 13:00:00 | NQ | Futures | 13281.64 | 13281.64 | 13185.1 | 13245.44 | 73599.0 |
| 2022-10-26 14:00:00 | NQ | Futures | 13245.15 | 13266.7 | 13169.58 | 13193.72 | 54047.0 |
| 2022-10-26 15:00:00 | NQ | Futures | 13193.14 | 13199.75 | 13145.16 | 13162.97 | 75564.0 |
| 2022-10-26 16:00:00 | NQ | Futures | 13162.97 | 13260.09 | 13119.3 | 13187.4 | 47875.0 |
| 2022-10-26 18:00:00 | NQ | Futures | 13122.46 | 13175.62 | 13120.45 | 13175.62 | 7511.0 |
| 2022-10-26 19:00:00 | NQ | Futures | 13175.04 | 13223.89 | 13173.6 | 13214.98 | 6870.0 |
| 2022-10-26 20:00:00 | NQ | Futures | 13214.69 | 13260.09 | 13191.13 | 13207.22 | 9953.0 |
| 2022-10-26 21:00:00 | NQ | Futures | 13206.65 | 13237.39 | 13203.2 | 13223.02 | 7628.0 |
| 2022-10-26 22:00:00 | NQ | Futures | 13222.74 | 13224.17 | 13172.74 | 13191.13 | 5128.0 |
| 2022-10-26 23:00:00 | NQ | Futures | 13191.42 | 13216.99 | 13190.27 | 13215.27 | 3225.0 |
| 2022-10-26 00:00:00 | YM | Futures | 35693.8 | 35714.0 | 35683.7 | 35685.9 | 446.0 |
| 2022-10-26 01:00:00 | YM | Futures | 35683.7 | 35710.6 | 35654.5 | 35657.9 | 1356.0 |
| 2022-10-26 02:00:00 | YM | Futures | 35656.7 | 35719.6 | 35646.6 | 35679.2 | 2514.0 |
| 2022-10-26 03:00:00 | YM | Futures | 35680.3 | 35771.2 | 35655.6 | 35748.8 | 4193.0 |
> showing 50 of 2,103 rows — these rows as CSV