PREVIEW / etf_1hour / 2024-09-06
file: by_date/etf_1hour/2024/2024-09-06.parquet size: 554 KB rows: 21,062
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-06 04:00:00 | SPY | ETF | 547.0 | 547.0 | 545.45 | 545.81 | 20506.0 |
| 2024-09-06 05:00:00 | SPY | ETF | 545.77 | 546.41 | 545.37 | 546.08 | 137045.0 |
| 2024-09-06 06:00:00 | SPY | ETF | 546.08 | 546.31 | 545.66 | 545.95 | 45036.0 |
| 2024-09-06 07:00:00 | SPY | ETF | 545.95 | 546.82 | 545.89 | 546.79 | 142290.0 |
| 2024-09-06 08:00:00 | SPY | ETF | 546.05 | 550.36 | 545.47 | 549.73 | 1542935.0 |
| 2024-09-06 09:00:00 | SPY | ETF | 549.77 | 551.6 | 547.83 | 547.8901 | 5301306.0 |
| 2024-09-06 10:00:00 | SPY | ETF | 547.89 | 548.26 | 541.56 | 542.22 | 8466801.0 |
| 2024-09-06 11:00:00 | SPY | ETF | 542.25 | 545.505 | 540.26 | 540.58 | 7876249.0 |
| 2024-09-06 12:00:00 | SPY | ETF | 540.53 | 541.18 | 539.66 | 540.135 | 3465810.0 |
| 2024-09-06 13:00:00 | SPY | ETF | 540.15 | 542.0 | 539.89 | 540.64 | 3290424.0 |
| 2024-09-06 14:00:00 | SPY | ETF | 540.65 | 540.85 | 539.44 | 540.45 | 2862358.0 |
| 2024-09-06 15:00:00 | SPY | ETF | 540.45 | 541.88 | 539.67 | 540.43 | 13302305.0 |
| 2024-09-06 16:00:00 | SPY | ETF | 540.42 | 542.91 | 537.86 | 538.68 | 4790425.0 |
| 2024-09-06 17:00:00 | SPY | ETF | 538.68 | 539.03 | 538.6 | 538.9005 | 148596.0 |
| 2024-09-06 18:00:00 | SPY | ETF | 538.83 | 538.86 | 538.56 | 538.67 | 34417.0 |
| 2024-09-06 19:00:00 | SPY | ETF | 538.795 | 538.96 | 538.68 | 538.8 | 20613.0 |
| 2024-09-06 04:00:00 | QQQ | ETF | 457.1 | 457.1 | 455.0 | 455.23 | 92543.0 |
| 2024-09-06 05:00:00 | QQQ | ETF | 455.27 | 456.32 | 454.83 | 456.22 | 103648.0 |
| 2024-09-06 06:00:00 | QQQ | ETF | 456.11 | 456.2 | 455.27 | 455.68 | 81084.0 |
| 2024-09-06 07:00:00 | QQQ | ETF | 455.68 | 456.87 | 455.68 | 456.77 | 153005.0 |
| 2024-09-06 08:00:00 | QQQ | ETF | 455.83 | 461.385 | 455.23 | 460.394 | 1666702.0 |
| 2024-09-06 09:00:00 | QQQ | ETF | 460.38 | 461.35 | 455.74 | 455.85 | 5182020.0 |
| 2024-09-06 10:00:00 | QQQ | ETF | 455.88 | 456.878 | 449.99 | 450.73 | 7581992.0 |
| 2024-09-06 11:00:00 | QQQ | ETF | 450.73 | 453.4 | 448.57 | 448.98 | 6560169.0 |
| 2024-09-06 12:00:00 | QQQ | ETF | 448.96 | 449.83 | 448.19 | 448.6999 | 2820511.0 |
| 2024-09-06 13:00:00 | QQQ | ETF | 448.6905 | 451.0 | 448.41 | 449.3 | 2705022.0 |
| 2024-09-06 14:00:00 | QQQ | ETF | 449.36 | 449.7395 | 448.24 | 449.425 | 2171231.0 |
| 2024-09-06 15:00:00 | QQQ | ETF | 449.44 | 450.7 | 448.32 | 448.87 | 7115678.0 |
| 2024-09-06 16:00:00 | QQQ | ETF | 448.85 | 452.123 | 446.0 | 446.89 | 2399996.0 |
| 2024-09-06 17:00:00 | QQQ | ETF | 446.8201 | 447.06 | 446.7 | 446.7 | 81495.0 |
| 2024-09-06 18:00:00 | QQQ | ETF | 446.7129 | 447.2 | 446.6801 | 447.1 | 36701.0 |
| 2024-09-06 19:00:00 | QQQ | ETF | 447.17 | 447.17 | 446.76 | 446.7736 | 38907.0 |
| 2024-09-06 04:00:00 | IWM | ETF | 211.0 | 211.0 | 210.57 | 210.66 | 23542.0 |
| 2024-09-06 05:00:00 | IWM | ETF | 210.64 | 211.03 | 210.43 | 211.03 | 11945.0 |
| 2024-09-06 06:00:00 | IWM | ETF | 210.83 | 211.04 | 210.43 | 210.77 | 108115.0 |
| 2024-09-06 07:00:00 | IWM | ETF | 210.71 | 211.02 | 210.54 | 210.88 | 73459.0 |
| 2024-09-06 08:00:00 | IWM | ETF | 210.75 | 213.0 | 209.57 | 211.55 | 1403387.0 |
| 2024-09-06 09:00:00 | IWM | ETF | 211.69 | 213.19 | 211.2 | 211.74 | 3445803.0 |
| 2024-09-06 10:00:00 | IWM | ETF | 211.755 | 211.79 | 208.16 | 208.35 | 5234263.0 |
| 2024-09-06 11:00:00 | IWM | ETF | 208.35 | 210.44 | 207.35 | 207.49 | 5077058.0 |
| 2024-09-06 12:00:00 | IWM | ETF | 207.47 | 208.17 | 207.14 | 208.04 | 2078773.0 |
| 2024-09-06 13:00:00 | IWM | ETF | 208.05 | 209.1 | 207.85 | 208.52 | 1454772.0 |
| 2024-09-06 14:00:00 | IWM | ETF | 208.53 | 208.6 | 207.21 | 207.93 | 1691486.0 |
| 2024-09-06 15:00:00 | IWM | ETF | 207.93 | 208.75 | 207.63 | 207.93 | 4303001.0 |
| 2024-09-06 16:00:00 | IWM | ETF | 207.9 | 208.0935 | 206.6 | 207.12 | 2798230.0 |
| 2024-09-06 17:00:00 | IWM | ETF | 207.07 | 207.9 | 206.817 | 206.97 | 26730.0 |
| 2024-09-06 18:00:00 | IWM | ETF | 207.01 | 207.25 | 206.92 | 207.11 | 21920.0 |
| 2024-09-06 19:00:00 | IWM | ETF | 207.02 | 207.02 | 206.92 | 206.92 | 4695.0 |
| 2024-09-06 04:00:00 | DIA | ETF | 407.22 | 407.22 | 406.9 | 406.9 | 250.0 |
| 2024-09-06 05:00:00 | DIA | ETF | 406.83 | 407.25 | 406.83 | 407.25 | 1338.0 |
> showing 50 of 21,062 rows — these rows as CSV