PREVIEW / futures_1hour / 2022-04-29
file: by_date/futures_1hour/2022/2022-04-29.parquet size: 59 KB rows: 1,674
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-29 00:00:00 | ES | Futures | 4836.62 | 4839.74 | 4834.07 | 4838.61 | 4207.0 |
| 2022-04-29 01:00:00 | ES | Futures | 4838.32 | 4846.26 | 4836.62 | 4841.44 | 11344.0 |
| 2022-04-29 02:00:00 | ES | Futures | 4841.44 | 4852.21 | 4836.91 | 4841.73 | 14418.0 |
| 2022-04-29 03:00:00 | ES | Futures | 4841.73 | 4846.26 | 4828.4 | 4838.89 | 19902.0 |
| 2022-04-29 04:00:00 | ES | Futures | 4839.17 | 4844.56 | 4829.82 | 4832.66 | 21564.0 |
| 2022-04-29 05:00:00 | ES | Futures | 4832.37 | 4832.66 | 4818.2 | 4821.88 | 18474.0 |
| 2022-04-29 06:00:00 | ES | Futures | 4821.88 | 4828.69 | 4808.56 | 4811.68 | 17522.0 |
| 2022-04-29 07:00:00 | ES | Futures | 4812.25 | 4816.5 | 4802.89 | 4807.15 | 25649.0 |
| 2022-04-29 08:00:00 | ES | Futures | 4807.15 | 4824.15 | 4804.59 | 4809.13 | 55218.0 |
| 2022-04-29 09:00:00 | ES | Futures | 4809.41 | 4836.06 | 4795.81 | 4834.07 | 214992.0 |
| 2022-04-29 10:00:00 | ES | Futures | 4834.07 | 4835.77 | 4768.6 | 4777.95 | 270621.0 |
| 2022-04-29 11:00:00 | ES | Futures | 4777.67 | 4793.54 | 4764.91 | 4774.83 | 175621.0 |
| 2022-04-29 12:00:00 | ES | Futures | 4774.55 | 4775.97 | 4737.42 | 4742.8 | 156574.0 |
| 2022-04-29 13:00:00 | ES | Futures | 4742.8 | 4766.9 | 4740.82 | 4742.8 | 126148.0 |
| 2022-04-29 14:00:00 | ES | Futures | 4742.52 | 4747.34 | 4710.78 | 4720.13 | 173649.0 |
| 2022-04-29 15:00:00 | ES | Futures | 4720.13 | 4720.98 | 4669.68 | 4679.88 | 545243.0 |
| 2022-04-29 16:00:00 | ES | Futures | 4679.88 | 4696.89 | 4678.46 | 4690.37 | 115717.0 |
| 2022-04-29 00:00:00 | NQ | Futures | 15464.66 | 15488.73 | 15453.35 | 15482.64 | 3014.0 |
| 2022-04-29 01:00:00 | NQ | Futures | 15482.35 | 15536.86 | 15480.9 | 15504.68 | 7088.0 |
| 2022-04-29 02:00:00 | NQ | Futures | 15504.68 | 15566.44 | 15486.7 | 15513.95 | 8346.0 |
| 2022-04-29 03:00:00 | NQ | Futures | 15512.51 | 15526.42 | 15451.61 | 15499.75 | 11667.0 |
| 2022-04-29 04:00:00 | NQ | Futures | 15500.04 | 15532.51 | 15456.54 | 15483.8 | 9819.0 |
| 2022-04-29 05:00:00 | NQ | Futures | 15483.8 | 15492.79 | 15431.02 | 15445.52 | 8441.0 |
| 2022-04-29 06:00:00 | NQ | Futures | 15446.39 | 15473.07 | 15406.08 | 15422.61 | 9340.0 |
| 2022-04-29 07:00:00 | NQ | Futures | 15422.9 | 15436.82 | 15367.52 | 15387.53 | 13389.0 |
| 2022-04-29 08:00:00 | NQ | Futures | 15387.24 | 15466.11 | 15380.57 | 15406.37 | 21943.0 |
| 2022-04-29 09:00:00 | NQ | Futures | 15407.53 | 15580.94 | 15341.71 | 15570.5 | 105273.0 |
| 2022-04-29 10:00:00 | NQ | Futures | 15569.05 | 15577.46 | 15272.41 | 15321.7 | 104647.0 |
| 2022-04-29 11:00:00 | NQ | Futures | 15322.28 | 15374.48 | 15257.91 | 15278.79 | 65455.0 |
| 2022-04-29 12:00:00 | NQ | Futures | 15278.21 | 15288.93 | 15147.14 | 15164.82 | 55351.0 |
| 2022-04-29 13:00:00 | NQ | Futures | 15164.53 | 15237.61 | 15138.73 | 15142.5 | 49609.0 |
| 2022-04-29 14:00:00 | NQ | Futures | 15141.92 | 15163.38 | 15027.09 | 15065.07 | 60380.0 |
| 2022-04-29 15:00:00 | NQ | Futures | 15065.94 | 15078.7 | 14883.55 | 14910.81 | 116226.0 |
| 2022-04-29 16:00:00 | NQ | Futures | 14910.81 | 14973.73 | 14904.72 | 14951.69 | 28987.0 |
| 2022-04-29 00:00:00 | YM | Futures | 38141.0 | 38157.9 | 38122.9 | 38148.9 | 1091.0 |
| 2022-04-29 01:00:00 | YM | Futures | 38146.6 | 38186.1 | 38127.5 | 38159.0 | 2829.0 |
| 2022-04-29 02:00:00 | YM | Futures | 38161.3 | 38219.9 | 38128.6 | 38154.5 | 2203.0 |
| 2022-04-29 03:00:00 | YM | Futures | 38150.0 | 38187.2 | 38062.1 | 38142.1 | 5356.0 |
| 2022-04-29 04:00:00 | YM | Futures | 38141.0 | 38156.8 | 38049.7 | 38065.5 | 5727.0 |
| 2022-04-29 05:00:00 | YM | Futures | 38064.3 | 38066.6 | 37971.9 | 38002.3 | 2832.0 |
| 2022-04-29 06:00:00 | YM | Futures | 38003.4 | 38039.5 | 37913.3 | 37938.1 | 3732.0 |
| 2022-04-29 07:00:00 | YM | Futures | 37934.7 | 37993.3 | 37921.2 | 37957.2 | 4181.0 |
| 2022-04-29 08:00:00 | YM | Futures | 37958.4 | 38060.9 | 37944.8 | 37974.1 | 7037.0 |
| 2022-04-29 09:00:00 | YM | Futures | 37973.0 | 38145.5 | 37890.7 | 38126.3 | 28249.0 |
| 2022-04-29 10:00:00 | YM | Futures | 38132.0 | 38145.5 | 37659.6 | 37723.9 | 29026.0 |
| 2022-04-29 11:00:00 | YM | Futures | 37721.6 | 37840.0 | 37635.9 | 37726.1 | 16718.0 |
| 2022-04-29 12:00:00 | YM | Futures | 37723.9 | 37730.6 | 37451.1 | 37498.4 | 16412.0 |
| 2022-04-29 13:00:00 | YM | Futures | 37496.1 | 37677.6 | 37474.7 | 37527.7 | 12307.0 |
| 2022-04-29 14:00:00 | YM | Futures | 37527.7 | 37562.7 | 37332.7 | 37390.2 | 13984.0 |
| 2022-04-29 15:00:00 | YM | Futures | 37391.3 | 37400.3 | 36999.0 | 37073.4 | 31226.0 |
> showing 50 of 1,674 rows — these rows as CSV