PREVIEW / futures_1hour / 2021-10-15
file: by_date/futures_1hour/2021/2021-10-15.parquet size: 54 KB rows: 1,617
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-10-15 00:00:00 | ES | Futures | 5015.76 | 5020.84 | 5014.07 | 5019.15 | 6431.0 |
| 2021-10-15 01:00:00 | ES | Futures | 5019.15 | 5020.84 | 5016.89 | 5019.99 | 5742.0 |
| 2021-10-15 02:00:00 | ES | Futures | 5020.28 | 5022.25 | 5012.94 | 5017.17 | 10337.0 |
| 2021-10-15 03:00:00 | ES | Futures | 5017.17 | 5018.3 | 5007.86 | 5013.79 | 22547.0 |
| 2021-10-15 04:00:00 | ES | Futures | 5013.5 | 5018.58 | 5012.94 | 5014.35 | 12299.0 |
| 2021-10-15 05:00:00 | ES | Futures | 5014.35 | 5016.33 | 5010.12 | 5015.48 | 14522.0 |
| 2021-10-15 06:00:00 | ES | Futures | 5015.48 | 5020.56 | 5014.35 | 5014.63 | 13182.0 |
| 2021-10-15 07:00:00 | ES | Futures | 5014.63 | 5021.41 | 5014.35 | 5018.58 | 18111.0 |
| 2021-10-15 08:00:00 | ES | Futures | 5018.58 | 5027.61 | 5014.07 | 5022.53 | 42666.0 |
| 2021-10-15 09:00:00 | ES | Futures | 5022.53 | 5031.28 | 5017.74 | 5031.28 | 188662.0 |
| 2021-10-15 10:00:00 | ES | Futures | 5031.0 | 5036.64 | 5020.84 | 5033.26 | 180207.0 |
| 2021-10-15 11:00:00 | ES | Futures | 5033.54 | 5034.67 | 5023.95 | 5026.2 | 94550.0 |
| 2021-10-15 12:00:00 | ES | Futures | 5026.2 | 5033.26 | 5025.92 | 5031.85 | 69708.0 |
| 2021-10-15 13:00:00 | ES | Futures | 5032.13 | 5036.64 | 5028.46 | 5035.23 | 60680.0 |
| 2021-10-15 14:00:00 | ES | Futures | 5035.52 | 5043.14 | 5035.23 | 5040.31 | 94369.0 |
| 2021-10-15 15:00:00 | ES | Futures | 5040.6 | 5041.44 | 5032.69 | 5038.34 | 198461.0 |
| 2021-10-15 16:00:00 | ES | Futures | 5038.06 | 5040.6 | 5036.08 | 5040.6 | 49026.0 |
| 2021-10-15 00:00:00 | NQ | Futures | 17488.15 | 17508.72 | 17478.58 | 17504.96 | 3854.0 |
| 2021-10-15 01:00:00 | NQ | Futures | 17505.25 | 17515.39 | 17493.94 | 17511.04 | 3465.0 |
| 2021-10-15 02:00:00 | NQ | Futures | 17511.04 | 17519.74 | 17467.86 | 17485.83 | 7006.0 |
| 2021-10-15 03:00:00 | NQ | Futures | 17485.54 | 17486.99 | 17430.76 | 17461.19 | 10771.0 |
| 2021-10-15 04:00:00 | NQ | Futures | 17460.61 | 17493.07 | 17457.43 | 17475.68 | 6773.0 |
| 2021-10-15 05:00:00 | NQ | Futures | 17476.55 | 17483.8 | 17456.56 | 17479.16 | 4917.0 |
| 2021-10-15 06:00:00 | NQ | Futures | 17479.16 | 17495.39 | 17472.21 | 17475.97 | 4983.0 |
| 2021-10-15 07:00:00 | NQ | Futures | 17476.55 | 17501.77 | 17473.66 | 17491.62 | 6451.0 |
| 2021-10-15 08:00:00 | NQ | Futures | 17492.2 | 17511.91 | 17476.26 | 17486.41 | 16097.0 |
| 2021-10-15 09:00:00 | NQ | Futures | 17486.7 | 17504.09 | 17446.12 | 17479.74 | 76035.0 |
| 2021-10-15 10:00:00 | NQ | Futures | 17479.45 | 17518.29 | 17442.36 | 17517.13 | 66022.0 |
| 2021-10-15 11:00:00 | NQ | Futures | 17516.84 | 17529.3 | 17456.85 | 17461.77 | 50763.0 |
| 2021-10-15 12:00:00 | NQ | Futures | 17461.48 | 17506.12 | 17461.19 | 17502.06 | 33256.0 |
| 2021-10-15 13:00:00 | NQ | Futures | 17502.06 | 17508.14 | 17478.58 | 17504.09 | 22961.0 |
| 2021-10-15 14:00:00 | NQ | Futures | 17504.09 | 17526.98 | 17503.22 | 17522.63 | 24358.0 |
| 2021-10-15 15:00:00 | NQ | Futures | 17522.63 | 17548.72 | 17493.94 | 17545.82 | 50869.0 |
| 2021-10-15 16:00:00 | NQ | Futures | 17546.11 | 17557.12 | 17541.47 | 17556.25 | 10474.0 |
| 2021-10-15 00:00:00 | YM | Futures | 39111.8 | 39142.1 | 39100.6 | 39128.6 | 1449.0 |
| 2021-10-15 01:00:00 | YM | Futures | 39129.8 | 39136.5 | 39111.8 | 39132.0 | 1397.0 |
| 2021-10-15 02:00:00 | YM | Futures | 39134.2 | 39149.9 | 39091.6 | 39120.8 | 3302.0 |
| 2021-10-15 03:00:00 | YM | Futures | 39120.8 | 39139.8 | 39095.0 | 39127.5 | 5026.0 |
| 2021-10-15 04:00:00 | YM | Futures | 39124.2 | 39163.4 | 39119.7 | 39126.4 | 3412.0 |
| 2021-10-15 05:00:00 | YM | Futures | 39127.5 | 39145.4 | 39104.0 | 39137.6 | 2598.0 |
| 2021-10-15 06:00:00 | YM | Futures | 39137.6 | 39173.5 | 39132.0 | 39144.3 | 3293.0 |
| 2021-10-15 07:00:00 | YM | Futures | 39145.4 | 39190.3 | 39138.7 | 39166.7 | 3491.0 |
| 2021-10-15 08:00:00 | YM | Futures | 39165.6 | 39262.0 | 39127.5 | 39240.7 | 8384.0 |
| 2021-10-15 09:00:00 | YM | Futures | 39241.8 | 39341.6 | 39201.5 | 39340.5 | 29411.0 |
| 2021-10-15 10:00:00 | YM | Futures | 39339.4 | 39388.7 | 39240.7 | 39330.4 | 25231.0 |
| 2021-10-15 11:00:00 | YM | Futures | 39329.3 | 39339.4 | 39281.1 | 39296.8 | 11089.0 |
| 2021-10-15 12:00:00 | YM | Futures | 39295.7 | 39330.4 | 39288.9 | 39320.3 | 7789.0 |
| 2021-10-15 13:00:00 | YM | Futures | 39321.4 | 39405.5 | 39305.7 | 39395.4 | 8861.0 |
| 2021-10-15 14:00:00 | YM | Futures | 39396.5 | 39451.5 | 39395.4 | 39439.1 | 11712.0 |
| 2021-10-15 15:00:00 | YM | Futures | 39439.1 | 39445.9 | 39383.1 | 39427.9 | 14846.0 |
> showing 50 of 1,617 rows — these rows as CSV