PREVIEW / etf_1hour / 2024-10-24
file: by_date/etf_1hour/2024/2024-10-24.parquet size: 561 KB rows: 21,052
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-10-24 04:00:00 | SPY | ETF | 579.72 | 580.92 | 579.72 | 580.24 | 27386.0 |
| 2024-10-24 05:00:00 | SPY | ETF | 580.52 | 580.68 | 580.38 | 580.48 | 20928.0 |
| 2024-10-24 06:00:00 | SPY | ETF | 580.42 | 580.89 | 580.4 | 580.54 | 75333.0 |
| 2024-10-24 07:00:00 | SPY | ETF | 580.57 | 581.08 | 579.4 | 581.01 | 449664.0 |
| 2024-10-24 08:00:00 | SPY | ETF | 580.5108 | 581.21 | 579.11 | 580.51 | 208191.0 |
| 2024-10-24 09:00:00 | SPY | ETF | 580.54 | 580.91 | 578.62 | 579.39 | 3510708.0 |
| 2024-10-24 10:00:00 | SPY | ETF | 579.39 | 579.93 | 578.54 | 578.8004 | 2788325.0 |
| 2024-10-24 11:00:00 | SPY | ETF | 578.82 | 579.36 | 577.04 | 578.06 | 2740906.0 |
| 2024-10-24 12:00:00 | SPY | ETF | 578.06 | 578.99 | 576.57 | 578.88 | 2784316.0 |
| 2024-10-24 13:00:00 | SPY | ETF | 578.86 | 579.5601 | 578.42 | 578.49 | 1853954.0 |
| 2024-10-24 14:00:00 | SPY | ETF | 578.5322 | 579.36 | 578.0702 | 578.82 | 2022547.0 |
| 2024-10-24 15:00:00 | SPY | ETF | 578.81 | 579.885 | 578.25 | 579.18 | 5798945.0 |
| 2024-10-24 16:00:00 | SPY | ETF | 579.17 | 579.94 | 578.88 | 579.49 | 3481673.0 |
| 2024-10-24 17:00:00 | SPY | ETF | 579.55 | 579.56 | 579.35 | 579.53 | 53532.0 |
| 2024-10-24 18:00:00 | SPY | ETF | 579.56 | 579.63 | 579.21 | 579.3 | 69814.0 |
| 2024-10-24 19:00:00 | SPY | ETF | 579.28 | 579.36 | 579.0 | 579.36 | 21427.0 |
| 2024-10-24 04:00:00 | QQQ | ETF | 491.72 | 492.83 | 491.66 | 492.08 | 74863.0 |
| 2024-10-24 05:00:00 | QQQ | ETF | 492.17 | 492.39 | 491.9 | 492.2 | 26002.0 |
| 2024-10-24 06:00:00 | QQQ | ETF | 492.22 | 492.67 | 492.11 | 492.3 | 21109.0 |
| 2024-10-24 07:00:00 | QQQ | ETF | 492.3 | 493.24 | 492.15 | 493.17 | 133640.0 |
| 2024-10-24 08:00:00 | QQQ | ETF | 492.52 | 493.41 | 490.8 | 492.38 | 262821.0 |
| 2024-10-24 09:00:00 | QQQ | ETF | 492.38 | 492.9094 | 490.29 | 491.2663 | 2574461.0 |
| 2024-10-24 10:00:00 | QQQ | ETF | 491.27 | 492.228 | 490.52 | 490.744 | 2843868.0 |
| 2024-10-24 11:00:00 | QQQ | ETF | 490.7494 | 491.97 | 489.53 | 491.0475 | 1900411.0 |
| 2024-10-24 12:00:00 | QQQ | ETF | 491.04 | 491.93 | 489.44 | 491.73 | 1573696.0 |
| 2024-10-24 13:00:00 | QQQ | ETF | 491.72 | 492.4666 | 491.39 | 491.44 | 1344437.0 |
| 2024-10-24 14:00:00 | QQQ | ETF | 491.4801 | 492.36 | 491.05 | 492.02 | 1055815.0 |
| 2024-10-24 15:00:00 | QQQ | ETF | 491.9576 | 493.0 | 491.43 | 492.33 | 3171450.0 |
| 2024-10-24 16:00:00 | QQQ | ETF | 492.31 | 493.1 | 492.0901 | 492.47 | 1549776.0 |
| 2024-10-24 17:00:00 | QQQ | ETF | 492.48 | 492.49 | 492.12 | 492.23 | 29302.0 |
| 2024-10-24 18:00:00 | QQQ | ETF | 492.3 | 492.69 | 492.2 | 492.22 | 40354.0 |
| 2024-10-24 19:00:00 | QQQ | ETF | 492.26 | 492.32 | 491.92 | 492.32 | 50852.0 |
| 2024-10-24 04:00:00 | IWM | ETF | 220.0 | 220.48 | 219.98 | 220.32 | 14621.0 |
| 2024-10-24 05:00:00 | IWM | ETF | 220.33 | 220.43 | 220.21 | 220.29 | 4589.0 |
| 2024-10-24 06:00:00 | IWM | ETF | 220.29 | 220.61 | 220.23 | 220.46 | 18533.0 |
| 2024-10-24 07:00:00 | IWM | ETF | 220.38 | 220.65 | 220.24 | 220.57 | 61776.0 |
| 2024-10-24 08:00:00 | IWM | ETF | 220.4329 | 220.5701 | 219.49 | 220.15 | 181196.0 |
| 2024-10-24 09:00:00 | IWM | ETF | 220.1499 | 221.04 | 219.87 | 220.69 | 1895798.0 |
| 2024-10-24 10:00:00 | IWM | ETF | 220.685 | 220.95 | 219.67 | 220.09 | 1659632.0 |
| 2024-10-24 11:00:00 | IWM | ETF | 220.1 | 220.21 | 218.8 | 219.09 | 1260043.0 |
| 2024-10-24 12:00:00 | IWM | ETF | 219.1 | 219.4 | 218.525 | 219.19 | 1469141.0 |
| 2024-10-24 13:00:00 | IWM | ETF | 219.161 | 219.79 | 219.05 | 219.26 | 942827.0 |
| 2024-10-24 14:00:00 | IWM | ETF | 219.28 | 219.53 | 219.08 | 219.46 | 863931.0 |
| 2024-10-24 15:00:00 | IWM | ETF | 219.46 | 220.04 | 219.28 | 219.75 | 2610925.0 |
| 2024-10-24 16:00:00 | IWM | ETF | 219.72 | 220.17 | 219.72 | 219.97 | 1399891.0 |
| 2024-10-24 17:00:00 | IWM | ETF | 219.98 | 220.1 | 219.81 | 219.99 | 14298.0 |
| 2024-10-24 18:00:00 | IWM | ETF | 219.8891 | 219.89 | 219.69 | 219.78 | 14298.0 |
| 2024-10-24 19:00:00 | IWM | ETF | 219.73 | 219.86 | 219.68 | 219.75 | 7960.0 |
| 2024-10-24 04:00:00 | DIA | ETF | 424.97 | 424.97 | 424.84 | 424.9 | 2817.0 |
| 2024-10-24 05:00:00 | DIA | ETF | 424.87 | 424.97 | 424.87 | 424.97 | 225.0 |
> showing 50 of 21,052 rows — these rows as CSV