PREVIEW / futures_1hour / 2022-04-25
file: by_date/futures_1hour/2022/2022-04-25.parquet size: 71 KB rows: 2,113
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-04-25 00:00:00 | ES | Futures | 4813.67 | 4814.8 | 4802.89 | 4805.45 | 6566.0 |
| 2022-04-25 01:00:00 | ES | Futures | 4805.45 | 4815.65 | 4799.21 | 4799.49 | 11980.0 |
| 2022-04-25 02:00:00 | ES | Futures | 4799.78 | 4806.01 | 4785.32 | 4788.44 | 22880.0 |
| 2022-04-25 03:00:00 | ES | Futures | 4788.44 | 4820.47 | 4782.77 | 4797.23 | 37009.0 |
| 2022-04-25 04:00:00 | ES | Futures | 4797.51 | 4812.25 | 4783.62 | 4790.14 | 27461.0 |
| 2022-04-25 05:00:00 | ES | Futures | 4789.86 | 4803.74 | 4783.05 | 4794.67 | 25889.0 |
| 2022-04-25 06:00:00 | ES | Futures | 4794.67 | 4802.33 | 4790.14 | 4799.21 | 22861.0 |
| 2022-04-25 07:00:00 | ES | Futures | 4799.21 | 4809.98 | 4786.74 | 4800.91 | 47219.0 |
| 2022-04-25 08:00:00 | ES | Futures | 4801.19 | 4823.59 | 4794.11 | 4821.88 | 56967.0 |
| 2022-04-25 09:00:00 | ES | Futures | 4821.6 | 4823.59 | 4773.42 | 4773.7 | 287493.0 |
| 2022-04-25 10:00:00 | ES | Futures | 4773.42 | 4820.18 | 4770.02 | 4778.24 | 348539.0 |
| 2022-04-25 11:00:00 | ES | Futures | 4778.24 | 4795.24 | 4756.41 | 4767.18 | 253636.0 |
| 2022-04-25 12:00:00 | ES | Futures | 4767.18 | 4807.43 | 4760.09 | 4793.26 | 208068.0 |
| 2022-04-25 13:00:00 | ES | Futures | 4793.26 | 4812.81 | 4780.79 | 4798.08 | 162254.0 |
| 2022-04-25 14:00:00 | ES | Futures | 4798.08 | 4846.83 | 4789.57 | 4832.66 | 206116.0 |
| 2022-04-25 15:00:00 | ES | Futures | 4832.37 | 4869.22 | 4813.38 | 4867.24 | 345256.0 |
| 2022-04-25 16:00:00 | ES | Futures | 4867.24 | 4871.2 | 4861.57 | 4868.65 | 55116.0 |
| 2022-04-25 18:00:00 | ES | Futures | 4868.37 | 4868.37 | 4861.85 | 4866.38 | 4923.0 |
| 2022-04-25 19:00:00 | ES | Futures | 4866.67 | 4868.65 | 4863.55 | 4864.68 | 4348.0 |
| 2022-04-25 20:00:00 | ES | Futures | 4864.4 | 4868.65 | 4861.28 | 4868.09 | 6665.0 |
| 2022-04-25 21:00:00 | ES | Futures | 4868.09 | 4872.05 | 4864.4 | 4866.67 | 9967.0 |
| 2022-04-25 22:00:00 | ES | Futures | 4866.67 | 4874.89 | 4865.53 | 4874.32 | 7064.0 |
| 2022-04-25 23:00:00 | ES | Futures | 4874.32 | 4879.14 | 4874.04 | 4877.72 | 8189.0 |
| 2022-04-25 00:00:00 | NQ | Futures | 15433.05 | 15436.24 | 15388.4 | 15400.57 | 3427.0 |
| 2022-04-25 01:00:00 | NQ | Futures | 15400.86 | 15439.14 | 15367.81 | 15372.16 | 7066.0 |
| 2022-04-25 02:00:00 | NQ | Futures | 15371.29 | 15402.02 | 15316.48 | 15329.82 | 13102.0 |
| 2022-04-25 03:00:00 | NQ | Futures | 15330.98 | 15469.59 | 15310.68 | 15377.96 | 18423.0 |
| 2022-04-25 04:00:00 | NQ | Futures | 15378.54 | 15429.57 | 15329.53 | 15359.98 | 11932.0 |
| 2022-04-25 05:00:00 | NQ | Futures | 15357.95 | 15405.79 | 15324.89 | 15366.65 | 9987.0 |
| 2022-04-25 06:00:00 | NQ | Futures | 15366.07 | 15394.2 | 15342.58 | 15371.0 | 8210.0 |
| 2022-04-25 07:00:00 | NQ | Futures | 15370.13 | 15386.66 | 15292.12 | 15366.36 | 19809.0 |
| 2022-04-25 08:00:00 | NQ | Futures | 15367.52 | 15453.64 | 15337.07 | 15446.68 | 21346.0 |
| 2022-04-25 09:00:00 | NQ | Futures | 15445.52 | 15503.52 | 15352.44 | 15368.39 | 100700.0 |
| 2022-04-25 10:00:00 | NQ | Futures | 15367.81 | 15620.09 | 15363.17 | 15458.86 | 116809.0 |
| 2022-04-25 11:00:00 | NQ | Futures | 15459.73 | 15512.51 | 15357.37 | 15388.11 | 77510.0 |
| 2022-04-25 12:00:00 | NQ | Futures | 15388.4 | 15552.81 | 15359.98 | 15475.39 | 64693.0 |
| 2022-04-25 13:00:00 | NQ | Futures | 15475.39 | 15561.22 | 15433.34 | 15486.41 | 48956.0 |
| 2022-04-25 14:00:00 | NQ | Futures | 15486.7 | 15650.24 | 15454.22 | 15585.29 | 59830.0 |
| 2022-04-25 15:00:00 | NQ | Futures | 15584.13 | 15708.82 | 15482.64 | 15694.32 | 92415.0 |
| 2022-04-25 16:00:00 | NQ | Futures | 15694.61 | 15716.36 | 15672.57 | 15691.13 | 18321.0 |
| 2022-04-25 18:00:00 | NQ | Futures | 15685.91 | 15693.45 | 15667.64 | 15687.94 | 3023.0 |
| 2022-04-25 19:00:00 | NQ | Futures | 15688.52 | 15701.28 | 15680.98 | 15687.07 | 2401.0 |
| 2022-04-25 20:00:00 | NQ | Futures | 15686.49 | 15702.44 | 15667.64 | 15698.96 | 2857.0 |
| 2022-04-25 21:00:00 | NQ | Futures | 15699.83 | 15715.49 | 15683.59 | 15695.77 | 3533.0 |
| 2022-04-25 22:00:00 | NQ | Futures | 15693.45 | 15735.79 | 15687.07 | 15730.28 | 3364.0 |
| 2022-04-25 23:00:00 | NQ | Futures | 15730.28 | 15755.79 | 15728.54 | 15742.75 | 3692.0 |
| 2022-04-25 00:00:00 | YM | Futures | 37815.2 | 37825.3 | 37748.7 | 37766.7 | 1360.0 |
| 2022-04-25 01:00:00 | YM | Futures | 37766.7 | 37838.9 | 37730.6 | 37734.0 | 2398.0 |
| 2022-04-25 02:00:00 | YM | Futures | 37732.9 | 37776.9 | 37634.8 | 37655.1 | 5748.0 |
| 2022-04-25 03:00:00 | YM | Futures | 37655.1 | 37868.2 | 37614.5 | 37710.3 | 14243.0 |
> showing 50 of 2,113 rows — these rows as CSV