PREVIEW / futures_1hour / 2022-03-25
file: by_date/futures_1hour/2022/2022-03-25.parquet size: 56 KB rows: 1,611
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-03-25 00:00:00 | ES | Futures | 5116.66 | 5132.82 | 5115.81 | 5129.42 | 5734.0 |
| 2022-03-25 01:00:00 | ES | Futures | 5129.13 | 5129.13 | 5119.5 | 5121.76 | 6132.0 |
| 2022-03-25 02:00:00 | ES | Futures | 5122.33 | 5126.58 | 5121.2 | 5126.02 | 4447.0 |
| 2022-03-25 03:00:00 | ES | Futures | 5125.73 | 5126.02 | 5117.23 | 5122.9 | 7702.0 |
| 2022-03-25 04:00:00 | ES | Futures | 5122.9 | 5124.03 | 5102.21 | 5111.84 | 16837.0 |
| 2022-03-25 05:00:00 | ES | Futures | 5111.84 | 5118.93 | 5104.76 | 5118.65 | 13710.0 |
| 2022-03-25 06:00:00 | ES | Futures | 5118.65 | 5127.43 | 5116.66 | 5127.15 | 11235.0 |
| 2022-03-25 07:00:00 | ES | Futures | 5127.15 | 5137.92 | 5120.91 | 5134.8 | 20893.0 |
| 2022-03-25 08:00:00 | ES | Futures | 5134.8 | 5135.94 | 5129.42 | 5133.67 | 19044.0 |
| 2022-03-25 09:00:00 | ES | Futures | 5133.67 | 5133.67 | 5115.25 | 5122.33 | 146637.0 |
| 2022-03-25 10:00:00 | ES | Futures | 5122.33 | 5146.14 | 5117.23 | 5138.49 | 155901.0 |
| 2022-03-25 11:00:00 | ES | Futures | 5138.77 | 5141.04 | 5094.27 | 5103.91 | 193286.0 |
| 2022-03-25 12:00:00 | ES | Futures | 5104.19 | 5117.8 | 5100.22 | 5112.98 | 113585.0 |
| 2022-03-25 13:00:00 | ES | Futures | 5112.98 | 5128.57 | 5107.03 | 5127.72 | 93048.0 |
| 2022-03-25 14:00:00 | ES | Futures | 5127.72 | 5137.35 | 5125.17 | 5133.67 | 84142.0 |
| 2022-03-25 15:00:00 | ES | Futures | 5133.95 | 5144.72 | 5109.29 | 5142.74 | 202969.0 |
| 2022-03-25 16:00:00 | ES | Futures | 5143.02 | 5143.59 | 5138.49 | 5142.74 | 54989.0 |
| 2022-03-25 00:00:00 | NQ | Futures | 17107.37 | 17182.76 | 17106.5 | 17170.29 | 4734.0 |
| 2022-03-25 01:00:00 | NQ | Futures | 17169.13 | 17172.9 | 17130.57 | 17142.45 | 4281.0 |
| 2022-03-25 02:00:00 | NQ | Futures | 17141.58 | 17160.14 | 17137.53 | 17159.85 | 2195.0 |
| 2022-03-25 03:00:00 | NQ | Futures | 17158.4 | 17159.27 | 17121.29 | 17149.7 | 3507.0 |
| 2022-03-25 04:00:00 | NQ | Futures | 17149.41 | 17151.44 | 17042.7 | 17085.91 | 11174.0 |
| 2022-03-25 05:00:00 | NQ | Futures | 17086.2 | 17127.67 | 17058.94 | 17123.32 | 8220.0 |
| 2022-03-25 06:00:00 | NQ | Futures | 17122.16 | 17164.49 | 17116.36 | 17159.56 | 6529.0 |
| 2022-03-25 07:00:00 | NQ | Futures | 17159.56 | 17213.5 | 17140.71 | 17198.42 | 10597.0 |
| 2022-03-25 08:00:00 | NQ | Futures | 17198.42 | 17207.99 | 17165.07 | 17182.18 | 9656.0 |
| 2022-03-25 09:00:00 | NQ | Futures | 17181.89 | 17182.47 | 17060.1 | 17074.02 | 73475.0 |
| 2022-03-25 10:00:00 | NQ | Futures | 17074.89 | 17175.8 | 17043.86 | 17104.76 | 81249.0 |
| 2022-03-25 11:00:00 | NQ | Futures | 17105.34 | 17117.52 | 16902.65 | 16939.76 | 86707.0 |
| 2022-03-25 12:00:00 | NQ | Futures | 16939.76 | 17013.42 | 16915.11 | 16985.87 | 53769.0 |
| 2022-03-25 13:00:00 | NQ | Futures | 16985.87 | 17070.54 | 16957.74 | 17068.8 | 45794.0 |
| 2022-03-25 14:00:00 | NQ | Futures | 17069.38 | 17107.37 | 17054.3 | 17095.19 | 40188.0 |
| 2022-03-25 15:00:00 | NQ | Futures | 17095.19 | 17119.26 | 16965.86 | 17114.62 | 68046.0 |
| 2022-03-25 16:00:00 | NQ | Futures | 17115.2 | 17118.1 | 17100.41 | 17111.43 | 13153.0 |
| 2022-03-25 00:00:00 | YM | Futures | 39030.4 | 39128.5 | 39025.9 | 39107.1 | 1278.0 |
| 2022-03-25 01:00:00 | YM | Futures | 39106.0 | 39108.2 | 39040.6 | 39063.1 | 1318.0 |
| 2022-03-25 02:00:00 | YM | Futures | 39057.5 | 39087.9 | 39051.9 | 39086.8 | 731.0 |
| 2022-03-25 03:00:00 | YM | Futures | 39087.9 | 39087.9 | 39021.4 | 39060.9 | 1296.0 |
| 2022-03-25 04:00:00 | YM | Futures | 39058.6 | 39077.8 | 38949.3 | 39003.4 | 3303.0 |
| 2022-03-25 05:00:00 | YM | Futures | 39003.4 | 39049.6 | 38956.0 | 39037.2 | 3542.0 |
| 2022-03-25 06:00:00 | YM | Futures | 39039.5 | 39086.8 | 39018.0 | 39086.8 | 2553.0 |
| 2022-03-25 07:00:00 | YM | Futures | 39084.6 | 39142.1 | 39029.3 | 39122.9 | 3594.0 |
| 2022-03-25 08:00:00 | YM | Futures | 39124.0 | 39128.5 | 39089.1 | 39111.6 | 2327.0 |
| 2022-03-25 09:00:00 | YM | Futures | 39109.4 | 39137.5 | 39051.9 | 39103.7 | 16040.0 |
| 2022-03-25 10:00:00 | YM | Futures | 39104.8 | 39277.3 | 39093.6 | 39228.9 | 16793.0 |
| 2022-03-25 11:00:00 | YM | Futures | 39228.9 | 39241.3 | 38917.7 | 38979.7 | 20879.0 |
| 2022-03-25 12:00:00 | YM | Futures | 38980.8 | 39049.6 | 38957.2 | 39013.5 | 10023.0 |
| 2022-03-25 13:00:00 | YM | Futures | 39014.7 | 39099.2 | 38970.7 | 39087.9 | 8230.0 |
| 2022-03-25 14:00:00 | YM | Futures | 39090.2 | 39133.0 | 39072.2 | 39109.4 | 7049.0 |
| 2022-03-25 15:00:00 | YM | Futures | 39111.6 | 39195.0 | 38954.9 | 39183.8 | 14006.0 |
> showing 50 of 1,611 rows — these rows as CSV