PREVIEW / futures_1hour / 2023-06-14
file: by_date/futures_1hour/2023/2023-06-14.parquet size: 67 KB rows: 2,026
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 |
|---|---|---|---|---|---|---|---|
| 2023-06-14 00:00:00 | ES | Futures | 4848.97 | 4850.62 | 4847.6 | 4850.34 | 2918.0 |
| 2023-06-14 01:00:00 | ES | Futures | 4850.34 | 4851.44 | 4847.05 | 4849.79 | 6710.0 |
| 2023-06-14 02:00:00 | ES | Futures | 4849.79 | 4850.34 | 4846.77 | 4847.87 | 5148.0 |
| 2023-06-14 03:00:00 | ES | Futures | 4847.87 | 4859.13 | 4847.87 | 4858.85 | 17591.0 |
| 2023-06-14 04:00:00 | ES | Futures | 4858.85 | 4862.15 | 4856.11 | 4860.22 | 13504.0 |
| 2023-06-14 05:00:00 | ES | Futures | 4860.22 | 4861.05 | 4854.46 | 4855.56 | 12321.0 |
| 2023-06-14 06:00:00 | ES | Futures | 4855.56 | 4860.22 | 4853.91 | 4858.58 | 13166.0 |
| 2023-06-14 07:00:00 | ES | Futures | 4858.3 | 4861.05 | 4853.91 | 4855.56 | 18463.0 |
| 2023-06-14 08:00:00 | ES | Futures | 4855.56 | 4860.77 | 4851.99 | 4853.36 | 31014.0 |
| 2023-06-14 09:00:00 | ES | Futures | 4853.36 | 4859.95 | 4846.5 | 4857.75 | 152714.0 |
| 2023-06-14 10:00:00 | ES | Futures | 4858.03 | 4866.81 | 4856.11 | 4861.6 | 156617.0 |
| 2023-06-14 11:00:00 | ES | Futures | 4861.32 | 4874.77 | 4860.22 | 4865.71 | 131976.0 |
| 2023-06-14 12:00:00 | ES | Futures | 4865.71 | 4867.36 | 4858.03 | 4863.52 | 90543.0 |
| 2023-06-14 13:00:00 | ES | Futures | 4863.24 | 4863.52 | 4850.62 | 4854.46 | 100841.0 |
| 2023-06-14 14:00:00 | ES | Futures | 4854.46 | 4854.73 | 4813.28 | 4844.03 | 452205.0 |
| 2023-06-14 15:00:00 | ES | Futures | 4844.03 | 4863.79 | 4830.03 | 4852.81 | 406907.0 |
| 2023-06-14 16:00:00 | ES | Futures | 4852.81 | 4861.05 | 4850.89 | 4858.58 | 73695.0 |
| 2023-06-14 18:00:00 | ES | Futures | 4856.38 | 4859.13 | 4855.01 | 4856.93 | 5313.0 |
| 2023-06-14 19:00:00 | ES | Futures | 4856.66 | 4857.48 | 4853.36 | 4853.36 | 4059.0 |
| 2023-06-14 20:00:00 | ES | Futures | 4853.36 | 4855.01 | 4851.99 | 4854.19 | 5358.0 |
| 2023-06-14 21:00:00 | ES | Futures | 4853.91 | 4855.28 | 4844.3 | 4846.22 | 12671.0 |
| 2023-06-14 22:00:00 | ES | Futures | 4846.5 | 4848.97 | 4844.3 | 4848.15 | 7216.0 |
| 2023-06-14 23:00:00 | ES | Futures | 4848.15 | 4851.71 | 4847.6 | 4851.44 | 4899.0 |
| 2023-06-14 00:00:00 | NQ | Futures | 16797.45 | 16802.46 | 16791.89 | 16800.51 | 1524.0 |
| 2023-06-14 01:00:00 | NQ | Futures | 16800.79 | 16804.41 | 16777.98 | 16796.34 | 3405.0 |
| 2023-06-14 02:00:00 | NQ | Futures | 16795.78 | 16803.29 | 16779.37 | 16779.93 | 2683.0 |
| 2023-06-14 03:00:00 | NQ | Futures | 16780.21 | 16843.07 | 16779.93 | 16842.51 | 6973.0 |
| 2023-06-14 04:00:00 | NQ | Futures | 16843.07 | 16856.97 | 16828.32 | 16836.95 | 5490.0 |
| 2023-06-14 05:00:00 | NQ | Futures | 16836.39 | 16848.07 | 16822.21 | 16831.66 | 4589.0 |
| 2023-06-14 06:00:00 | NQ | Futures | 16831.11 | 16840.84 | 16810.52 | 16818.31 | 5979.0 |
| 2023-06-14 07:00:00 | NQ | Futures | 16818.31 | 16832.5 | 16813.31 | 16821.65 | 7297.0 |
| 2023-06-14 08:00:00 | NQ | Futures | 16821.37 | 16850.3 | 16799.12 | 16804.41 | 14735.0 |
| 2023-06-14 09:00:00 | NQ | Futures | 16804.41 | 16825.54 | 16746.28 | 16821.65 | 78679.0 |
| 2023-06-14 10:00:00 | NQ | Futures | 16821.93 | 16885.62 | 16806.35 | 16853.36 | 75769.0 |
| 2023-06-14 11:00:00 | NQ | Futures | 16853.63 | 16928.17 | 16835.0 | 16881.73 | 59606.0 |
| 2023-06-14 12:00:00 | NQ | Futures | 16882.0 | 16898.97 | 16851.97 | 16884.79 | 36339.0 |
| 2023-06-14 13:00:00 | NQ | Futures | 16885.34 | 16886.18 | 16817.2 | 16837.78 | 38173.0 |
| 2023-06-14 14:00:00 | NQ | Futures | 16837.78 | 16875.05 | 16661.17 | 16835.56 | 165329.0 |
| 2023-06-14 15:00:00 | NQ | Futures | 16835.56 | 16925.11 | 16796.34 | 16913.99 | 121731.0 |
| 2023-06-14 16:00:00 | NQ | Futures | 16913.71 | 16958.77 | 16910.37 | 16947.64 | 22743.0 |
| 2023-06-14 18:00:00 | NQ | Futures | 16934.85 | 16942.64 | 16925.95 | 16934.29 | 2491.0 |
| 2023-06-14 19:00:00 | NQ | Futures | 16934.01 | 16935.41 | 16922.89 | 16926.23 | 2060.0 |
| 2023-06-14 20:00:00 | NQ | Futures | 16926.23 | 16931.79 | 16917.33 | 16921.5 | 2913.0 |
| 2023-06-14 21:00:00 | NQ | Futures | 16921.5 | 16926.5 | 16876.44 | 16881.73 | 6173.0 |
| 2023-06-14 22:00:00 | NQ | Futures | 16882.0 | 16898.14 | 16872.55 | 16891.46 | 3803.0 |
| 2023-06-14 23:00:00 | NQ | Futures | 16891.46 | 16908.7 | 16889.24 | 16906.2 | 2401.0 |
| 2023-06-14 00:00:00 | YM | Futures | 37742.6 | 37750.3 | 37733.9 | 37748.1 | 500.0 |
| 2023-06-14 01:00:00 | YM | Futures | 37748.1 | 37772.2 | 37742.6 | 37762.3 | 1356.0 |
| 2023-06-14 02:00:00 | YM | Futures | 37762.3 | 37762.3 | 37738.2 | 37756.9 | 2115.0 |
| 2023-06-14 03:00:00 | YM | Futures | 37756.9 | 37813.8 | 37752.5 | 37798.5 | 3097.0 |
> showing 50 of 2,026 rows — these rows as CSV