PREVIEW / futures_1hour / 2024-07-08
file: by_date/futures_1hour/2024/2024-07-08.parquet size: 65 KB rows: 2,059
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-07-08 00:00:00 | ES | Futures | 5887.42 | 5887.42 | 5885.58 | 5885.58 | 1978.0 |
| 2024-07-08 01:00:00 | ES | Futures | 5885.58 | 5886.89 | 5884.01 | 5884.01 | 4153.0 |
| 2024-07-08 02:00:00 | ES | Futures | 5884.01 | 5887.68 | 5883.75 | 5887.15 | 7245.0 |
| 2024-07-08 03:00:00 | ES | Futures | 5887.15 | 5891.87 | 5884.79 | 5891.87 | 14714.0 |
| 2024-07-08 04:00:00 | ES | Futures | 5891.61 | 5894.76 | 5890.82 | 5892.4 | 11707.0 |
| 2024-07-08 05:00:00 | ES | Futures | 5892.13 | 5893.97 | 5891.09 | 5892.66 | 8024.0 |
| 2024-07-08 06:00:00 | ES | Futures | 5892.66 | 5893.71 | 5891.61 | 5891.87 | 7984.0 |
| 2024-07-08 07:00:00 | ES | Futures | 5892.13 | 5897.12 | 5891.61 | 5897.12 | 16554.0 |
| 2024-07-08 08:00:00 | ES | Futures | 5896.85 | 5900.52 | 5895.81 | 5900.26 | 18312.0 |
| 2024-07-08 09:00:00 | ES | Futures | 5900.26 | 5911.8 | 5899.48 | 5909.44 | 121094.0 |
| 2024-07-08 10:00:00 | ES | Futures | 5909.44 | 5909.7 | 5897.38 | 5900.52 | 147666.0 |
| 2024-07-08 11:00:00 | ES | Futures | 5900.52 | 5903.93 | 5895.02 | 5898.95 | 100591.0 |
| 2024-07-08 12:00:00 | ES | Futures | 5899.21 | 5899.21 | 5890.56 | 5895.81 | 83554.0 |
| 2024-07-08 13:00:00 | ES | Futures | 5895.81 | 5901.83 | 5892.13 | 5900.26 | 59582.0 |
| 2024-07-08 14:00:00 | ES | Futures | 5900.52 | 5900.79 | 5888.46 | 5897.12 | 74833.0 |
| 2024-07-08 15:00:00 | ES | Futures | 5897.38 | 5903.15 | 5892.66 | 5901.31 | 159669.0 |
| 2024-07-08 16:00:00 | ES | Futures | 5901.05 | 5903.67 | 5898.95 | 5902.36 | 51486.0 |
| 2024-07-08 18:00:00 | ES | Futures | 5901.57 | 5905.24 | 5900.0 | 5903.67 | 3861.0 |
| 2024-07-08 19:00:00 | ES | Futures | 5903.93 | 5913.11 | 5903.93 | 5912.85 | 7376.0 |
| 2024-07-08 20:00:00 | ES | Futures | 5912.85 | 5914.16 | 5909.7 | 5909.96 | 7899.0 |
| 2024-07-08 21:00:00 | ES | Futures | 5910.22 | 5912.32 | 5907.6 | 5908.13 | 5689.0 |
| 2024-07-08 22:00:00 | ES | Futures | 5908.39 | 5909.96 | 5906.82 | 5908.91 | 3702.0 |
| 2024-07-08 23:00:00 | ES | Futures | 5908.91 | 5912.85 | 5908.91 | 5912.58 | 2974.0 |
| 2024-07-08 00:00:00 | NQ | Futures | 21749.25 | 21749.52 | 21739.49 | 21740.28 | 1307.0 |
| 2024-07-08 01:00:00 | NQ | Futures | 21739.49 | 21747.41 | 21734.47 | 21735.79 | 2006.0 |
| 2024-07-08 02:00:00 | NQ | Futures | 21735.79 | 21753.21 | 21734.21 | 21750.84 | 3610.0 |
| 2024-07-08 03:00:00 | NQ | Futures | 21750.57 | 21760.61 | 21740.81 | 21759.29 | 6817.0 |
| 2024-07-08 04:00:00 | NQ | Futures | 21759.55 | 21768.79 | 21750.84 | 21754.53 | 5797.0 |
| 2024-07-08 05:00:00 | NQ | Futures | 21754.27 | 21774.07 | 21753.21 | 21765.09 | 4323.0 |
| 2024-07-08 06:00:00 | NQ | Futures | 21764.57 | 21771.43 | 21760.61 | 21762.72 | 3933.0 |
| 2024-07-08 07:00:00 | NQ | Futures | 21762.72 | 21785.16 | 21757.44 | 21782.25 | 6856.0 |
| 2024-07-08 08:00:00 | NQ | Futures | 21781.99 | 21791.76 | 21777.76 | 21782.52 | 10094.0 |
| 2024-07-08 09:00:00 | NQ | Futures | 21782.78 | 21808.65 | 21752.69 | 21788.59 | 85057.0 |
| 2024-07-08 10:00:00 | NQ | Futures | 21789.12 | 21796.77 | 21739.49 | 21761.66 | 85156.0 |
| 2024-07-08 11:00:00 | NQ | Futures | 21761.66 | 21826.87 | 21756.12 | 21823.17 | 65517.0 |
| 2024-07-08 12:00:00 | NQ | Futures | 21823.96 | 21825.81 | 21761.66 | 21788.32 | 45948.0 |
| 2024-07-08 13:00:00 | NQ | Futures | 21788.85 | 21824.23 | 21779.35 | 21808.91 | 32618.0 |
| 2024-07-08 14:00:00 | NQ | Futures | 21808.65 | 21811.55 | 21761.66 | 21800.73 | 41570.0 |
| 2024-07-08 15:00:00 | NQ | Futures | 21800.73 | 21845.08 | 21770.9 | 21821.85 | 56908.0 |
| 2024-07-08 16:00:00 | NQ | Futures | 21822.38 | 21844.29 | 21811.29 | 21841.38 | 14529.0 |
| 2024-07-08 18:00:00 | NQ | Futures | 21837.69 | 21856.7 | 21828.71 | 21846.14 | 5315.0 |
| 2024-07-08 19:00:00 | NQ | Futures | 21846.14 | 21899.99 | 21845.34 | 21898.4 | 8002.0 |
| 2024-07-08 20:00:00 | NQ | Futures | 21897.88 | 21909.23 | 21880.72 | 21887.85 | 10151.0 |
| 2024-07-08 21:00:00 | NQ | Futures | 21888.11 | 21897.35 | 21867.25 | 21869.37 | 5626.0 |
| 2024-07-08 22:00:00 | NQ | Futures | 21869.37 | 21880.45 | 21861.97 | 21874.12 | 4461.0 |
| 2024-07-08 23:00:00 | NQ | Futures | 21873.85 | 21895.76 | 21873.33 | 21893.92 | 2582.0 |
| 2024-07-08 00:00:00 | YM | Futures | 41645.6 | 41645.6 | 41630.9 | 41631.9 | 347.0 |
| 2024-07-08 01:00:00 | YM | Futures | 41631.9 | 41631.9 | 41615.1 | 41618.3 | 695.0 |
| 2024-07-08 02:00:00 | YM | Futures | 41617.2 | 41644.5 | 41605.7 | 41641.4 | 1630.0 |
| 2024-07-08 03:00:00 | YM | Futures | 41642.4 | 41696.0 | 41621.4 | 41695.0 | 2072.0 |
> showing 50 of 2,059 rows — these rows as CSV