PREVIEW / etf_1hour / 2024-09-19
file: by_date/etf_1hour/2024/2024-09-19.parquet size: 588 KB rows: 21,878
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-09-19 04:00:00 | SPY | ETF | 567.22 | 569.02 | 566.22 | 568.87 | 65358.0 |
| 2024-09-19 05:00:00 | SPY | ETF | 568.9 | 570.05 | 568.86 | 569.87 | 79453.0 |
| 2024-09-19 06:00:00 | SPY | ETF | 569.95 | 570.65 | 569.75 | 570.47 | 198776.0 |
| 2024-09-19 07:00:00 | SPY | ETF | 570.47 | 571.05 | 570.2 | 570.54 | 359178.0 |
| 2024-09-19 08:00:00 | SPY | ETF | 570.48 | 571.02 | 566.6 | 570.0 | 586388.0 |
| 2024-09-19 09:00:00 | SPY | ETF | 569.98 | 571.09 | 568.08 | 569.58 | 6151753.0 |
| 2024-09-19 10:00:00 | SPY | ETF | 569.61 | 571.89 | 569.37 | 569.91 | 6837961.0 |
| 2024-09-19 11:00:00 | SPY | ETF | 569.92 | 571.18 | 569.43 | 570.4 | 3829190.0 |
| 2024-09-19 12:00:00 | SPY | ETF | 570.4 | 572.048 | 570.3392 | 571.5 | 2932892.0 |
| 2024-09-19 13:00:00 | SPY | ETF | 571.5 | 572.88 | 571.3 | 572.5 | 3128067.0 |
| 2024-09-19 14:00:00 | SPY | ETF | 572.49 | 572.74 | 570.89 | 571.92 | 5249433.0 |
| 2024-09-19 15:00:00 | SPY | ETF | 571.92 | 572.11 | 570.35 | 570.92 | 11635246.0 |
| 2024-09-19 16:00:00 | SPY | ETF | 570.93 | 571.01 | 570.43 | 570.47 | 4782605.0 |
| 2024-09-19 17:00:00 | SPY | ETF | 570.55 | 570.74 | 570.5 | 570.66 | 42924.0 |
| 2024-09-19 18:00:00 | SPY | ETF | 570.68 | 570.85 | 570.15 | 570.41 | 106047.0 |
| 2024-09-19 19:00:00 | SPY | ETF | 570.38 | 570.64 | 570.19 | 570.25 | 24948.0 |
| 2024-09-19 04:00:00 | QQQ | ETF | 478.62 | 480.0 | 478.62 | 479.85 | 129382.0 |
| 2024-09-19 05:00:00 | QQQ | ETF | 479.83 | 480.98 | 479.6 | 480.91 | 115807.0 |
| 2024-09-19 06:00:00 | QQQ | ETF | 480.98 | 481.4 | 480.58 | 481.24 | 88925.0 |
| 2024-09-19 07:00:00 | QQQ | ETF | 481.26 | 481.77 | 480.8 | 481.6 | 275635.0 |
| 2024-09-19 08:00:00 | QQQ | ETF | 480.9 | 481.8 | 471.793 | 481.35 | 408783.0 |
| 2024-09-19 09:00:00 | QQQ | ETF | 481.37 | 483.06 | 480.49 | 481.64 | 5775938.0 |
| 2024-09-19 10:00:00 | QQQ | ETF | 481.63 | 485.19 | 481.42 | 482.93 | 6461536.0 |
| 2024-09-19 11:00:00 | QQQ | ETF | 482.965 | 485.11 | 482.59 | 483.79 | 3856762.0 |
| 2024-09-19 12:00:00 | QQQ | ETF | 483.8 | 485.51 | 483.67 | 485.13 | 2674097.0 |
| 2024-09-19 13:00:00 | QQQ | ETF | 485.13 | 486.23 | 484.7001 | 485.99 | 2402151.0 |
| 2024-09-19 14:00:00 | QQQ | ETF | 485.99 | 486.21 | 483.93 | 484.92 | 3426385.0 |
| 2024-09-19 15:00:00 | QQQ | ETF | 484.93 | 485.02 | 482.95 | 483.41 | 7786937.0 |
| 2024-09-19 16:00:00 | QQQ | ETF | 483.4 | 483.63 | 482.7 | 482.88 | 2793790.0 |
| 2024-09-19 17:00:00 | QQQ | ETF | 482.85 | 482.988 | 482.6901 | 482.78 | 38112.0 |
| 2024-09-19 18:00:00 | QQQ | ETF | 482.8984 | 483.16 | 482.2113 | 482.6 | 81825.0 |
| 2024-09-19 19:00:00 | QQQ | ETF | 482.617 | 483.0 | 482.5 | 482.62 | 52168.0 |
| 2024-09-19 04:00:00 | IWM | ETF | 223.85 | 225.16 | 222.63 | 224.81 | 90919.0 |
| 2024-09-19 05:00:00 | IWM | ETF | 224.87 | 225.94 | 224.86 | 225.51 | 76623.0 |
| 2024-09-19 06:00:00 | IWM | ETF | 225.56 | 226.7 | 225.42 | 226.5 | 84348.0 |
| 2024-09-19 07:00:00 | IWM | ETF | 226.5 | 226.55 | 225.17 | 225.27 | 407099.0 |
| 2024-09-19 08:00:00 | IWM | ETF | 225.25 | 226.4704 | 222.31 | 224.5717 | 665243.0 |
| 2024-09-19 09:00:00 | IWM | ETF | 224.52 | 225.1 | 221.5 | 222.94 | 5409272.0 |
| 2024-09-19 10:00:00 | IWM | ETF | 222.94 | 224.23 | 222.1 | 222.339 | 5565323.0 |
| 2024-09-19 11:00:00 | IWM | ETF | 222.35 | 223.47 | 222.24 | 223.13 | 2611745.0 |
| 2024-09-19 12:00:00 | IWM | ETF | 223.16 | 224.0816 | 223.09 | 224.0313 | 2196021.0 |
| 2024-09-19 13:00:00 | IWM | ETF | 224.04 | 224.23 | 223.73 | 224.05 | 1503526.0 |
| 2024-09-19 14:00:00 | IWM | ETF | 224.04 | 224.21 | 223.06 | 224.03 | 2469519.0 |
| 2024-09-19 15:00:00 | IWM | ETF | 224.02 | 224.13 | 223.17 | 223.97 | 5144198.0 |
| 2024-09-19 16:00:00 | IWM | ETF | 223.97 | 224.08 | 223.7278 | 223.9 | 1286617.0 |
| 2024-09-19 17:00:00 | IWM | ETF | 223.93 | 224.11 | 223.93 | 223.97 | 44652.0 |
| 2024-09-19 18:00:00 | IWM | ETF | 224.02 | 224.04 | 223.72 | 223.9 | 17341.0 |
| 2024-09-19 19:00:00 | IWM | ETF | 223.95 | 223.95 | 223.7 | 223.81 | 9645.0 |
| 2024-09-19 04:00:00 | DIA | ETF | 419.4 | 420.2 | 419.4 | 420.2 | 4500.0 |
| 2024-09-19 05:00:00 | DIA | ETF | 420.15 | 421.0 | 420.15 | 420.86 | 4631.0 |
> showing 50 of 21,878 rows — these rows as CSV