PREVIEW / futures_1hour / 2024-08-15
file: by_date/futures_1hour/2024/2024-08-15.parquet size: 68 KB rows: 2,084
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 |
|---|---|---|---|---|---|---|---|
| 2024-08-15 00:00:00 | ES | Futures | 5757.38 | 5758.96 | 5756.33 | 5756.86 | 2498.0 |
| 2024-08-15 01:00:00 | ES | Futures | 5757.12 | 5757.12 | 5750.3 | 5753.45 | 5211.0 |
| 2024-08-15 02:00:00 | ES | Futures | 5753.71 | 5754.24 | 5746.63 | 5753.71 | 7109.0 |
| 2024-08-15 03:00:00 | ES | Futures | 5753.71 | 5759.22 | 5750.3 | 5758.43 | 9119.0 |
| 2024-08-15 04:00:00 | ES | Futures | 5758.43 | 5758.96 | 5745.06 | 5749.52 | 10185.0 |
| 2024-08-15 05:00:00 | ES | Futures | 5749.52 | 5753.45 | 5748.73 | 5752.66 | 8843.0 |
| 2024-08-15 06:00:00 | ES | Futures | 5752.93 | 5754.5 | 5741.91 | 5742.18 | 13024.0 |
| 2024-08-15 07:00:00 | ES | Futures | 5742.44 | 5758.43 | 5737.98 | 5756.33 | 23568.0 |
| 2024-08-15 08:00:00 | ES | Futures | 5756.6 | 5804.05 | 5751.88 | 5796.71 | 100676.0 |
| 2024-08-15 09:00:00 | ES | Futures | 5796.97 | 5810.34 | 5791.99 | 5809.29 | 183408.0 |
| 2024-08-15 10:00:00 | ES | Futures | 5809.29 | 5821.09 | 5795.13 | 5816.89 | 210936.0 |
| 2024-08-15 11:00:00 | ES | Futures | 5817.16 | 5830.0 | 5815.58 | 5824.5 | 119701.0 |
| 2024-08-15 12:00:00 | ES | Futures | 5824.23 | 5836.03 | 5820.83 | 5827.9 | 110492.0 |
| 2024-08-15 13:00:00 | ES | Futures | 5828.17 | 5835.77 | 5822.92 | 5835.51 | 87994.0 |
| 2024-08-15 14:00:00 | ES | Futures | 5835.51 | 5839.96 | 5832.89 | 5838.13 | 91034.0 |
| 2024-08-15 15:00:00 | ES | Futures | 5837.87 | 5842.85 | 5827.64 | 5839.96 | 242089.0 |
| 2024-08-15 16:00:00 | ES | Futures | 5839.44 | 5841.8 | 5833.41 | 5837.87 | 82314.0 |
| 2024-08-15 18:00:00 | ES | Futures | 5839.44 | 5847.04 | 5836.29 | 5844.95 | 7943.0 |
| 2024-08-15 19:00:00 | ES | Futures | 5844.95 | 5850.45 | 5843.37 | 5845.73 | 8347.0 |
| 2024-08-15 20:00:00 | ES | Futures | 5845.73 | 5845.99 | 5837.34 | 5842.32 | 13443.0 |
| 2024-08-15 21:00:00 | ES | Futures | 5842.06 | 5846.52 | 5839.18 | 5844.68 | 10686.0 |
| 2024-08-15 22:00:00 | ES | Futures | 5844.68 | 5849.14 | 5844.16 | 5845.99 | 5426.0 |
| 2024-08-15 23:00:00 | ES | Futures | 5846.26 | 5849.14 | 5845.21 | 5847.83 | 4675.0 |
| 2024-08-15 00:00:00 | NQ | Futures | 20289.7 | 20295.24 | 20280.19 | 20285.74 | 1547.0 |
| 2024-08-15 01:00:00 | NQ | Futures | 20286.26 | 20286.26 | 20242.18 | 20259.34 | 3886.0 |
| 2024-08-15 02:00:00 | NQ | Futures | 20260.92 | 20260.92 | 20216.31 | 20243.23 | 4940.0 |
| 2024-08-15 03:00:00 | NQ | Futures | 20242.18 | 20271.48 | 20225.55 | 20269.1 | 3717.0 |
| 2024-08-15 04:00:00 | NQ | Futures | 20268.58 | 20272.27 | 20192.55 | 20223.17 | 5902.0 |
| 2024-08-15 05:00:00 | NQ | Futures | 20222.38 | 20242.97 | 20217.36 | 20237.95 | 3307.0 |
| 2024-08-15 06:00:00 | NQ | Futures | 20238.75 | 20246.93 | 20180.93 | 20180.93 | 6217.0 |
| 2024-08-15 07:00:00 | NQ | Futures | 20181.46 | 20256.17 | 20173.28 | 20236.11 | 10114.0 |
| 2024-08-15 08:00:00 | NQ | Futures | 20235.84 | 20454.95 | 20208.65 | 20416.67 | 39107.0 |
| 2024-08-15 09:00:00 | NQ | Futures | 20416.93 | 20550.51 | 20397.66 | 20549.19 | 84290.0 |
| 2024-08-15 10:00:00 | NQ | Futures | 20549.72 | 20606.21 | 20490.85 | 20571.1 | 80830.0 |
| 2024-08-15 11:00:00 | NQ | Futures | 20571.1 | 20640.26 | 20560.54 | 20617.83 | 52568.0 |
| 2024-08-15 12:00:00 | NQ | Futures | 20618.09 | 20664.55 | 20604.63 | 20630.23 | 45589.0 |
| 2024-08-15 13:00:00 | NQ | Futures | 20630.76 | 20680.39 | 20611.49 | 20678.81 | 34309.0 |
| 2024-08-15 14:00:00 | NQ | Futures | 20679.33 | 20687.78 | 20659.53 | 20679.07 | 32923.0 |
| 2024-08-15 15:00:00 | NQ | Futures | 20679.33 | 20699.66 | 20636.04 | 20682.77 | 68905.0 |
| 2024-08-15 16:00:00 | NQ | Futures | 20682.77 | 20687.25 | 20653.99 | 20662.7 | 18303.0 |
| 2024-08-15 18:00:00 | NQ | Futures | 20664.81 | 20709.16 | 20654.78 | 20699.13 | 3892.0 |
| 2024-08-15 19:00:00 | NQ | Futures | 20700.19 | 20739.26 | 20697.81 | 20710.48 | 5060.0 |
| 2024-08-15 20:00:00 | NQ | Futures | 20711.01 | 20714.97 | 20670.89 | 20699.13 | 4820.0 |
| 2024-08-15 21:00:00 | NQ | Futures | 20697.55 | 20722.1 | 20683.56 | 20710.48 | 2765.0 |
| 2024-08-15 22:00:00 | NQ | Futures | 20711.01 | 20743.22 | 20708.37 | 20725.53 | 3077.0 |
| 2024-08-15 23:00:00 | NQ | Futures | 20725.0 | 20742.16 | 20716.29 | 20733.19 | 1924.0 |
| 2024-08-15 00:00:00 | YM | Futures | 42227.7 | 42246.6 | 42224.5 | 42229.8 | 508.0 |
| 2024-08-15 01:00:00 | YM | Futures | 42228.8 | 42233.0 | 42211.9 | 42230.9 | 684.0 |
| 2024-08-15 02:00:00 | YM | Futures | 42231.9 | 42262.4 | 42200.4 | 42262.4 | 1219.0 |
| 2024-08-15 03:00:00 | YM | Futures | 42260.3 | 42272.9 | 42233.0 | 42265.5 | 1265.0 |
> showing 50 of 2,084 rows — these rows as CSV