PREVIEW / etf_1hour / 2024-03-27
file: by_date/etf_1hour/2024/2024-03-27.parquet size: 528 KB rows: 19,632
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-03-27 04:00:00 | SPY | ETF | 520.32 | 520.86 | 520.3 | 520.66 | 36178.0 |
| 2024-03-27 05:00:00 | SPY | ETF | 520.82 | 520.94 | 520.51 | 520.87 | 9224.0 |
| 2024-03-27 06:00:00 | SPY | ETF | 520.94 | 521.36 | 520.75 | 521.27 | 36410.0 |
| 2024-03-27 07:00:00 | SPY | ETF | 521.24 | 521.29 | 520.36 | 520.91 | 302043.0 |
| 2024-03-27 08:00:00 | SPY | ETF | 520.93 | 521.35 | 520.3 | 521.33 | 345899.0 |
| 2024-03-27 09:00:00 | SPY | ETF | 521.34 | 521.85 | 520.74 | 520.89 | 5122632.0 |
| 2024-03-27 10:00:00 | SPY | ETF | 520.9 | 520.95 | 519.63 | 519.845 | 8044478.0 |
| 2024-03-27 11:00:00 | SPY | ETF | 519.85 | 520.16 | 519.53 | 519.54 | 3597926.0 |
| 2024-03-27 12:00:00 | SPY | ETF | 519.54 | 520.4799 | 519.485 | 520.3099 | 3083435.0 |
| 2024-03-27 13:00:00 | SPY | ETF | 520.31 | 520.5 | 519.73 | 520.175 | 2562166.0 |
| 2024-03-27 14:00:00 | SPY | ETF | 520.18 | 520.98 | 520.02 | 520.27 | 3903263.0 |
| 2024-03-27 15:00:00 | SPY | ETF | 520.27 | 523.2 | 519.84 | 523.17 | 20630941.0 |
| 2024-03-27 16:00:00 | SPY | ETF | 523.17 | 523.54 | 522.8983 | 522.91 | 5949019.0 |
| 2024-03-27 17:00:00 | SPY | ETF | 522.94 | 523.17 | 522.69 | 522.98 | 207993.0 |
| 2024-03-27 18:00:00 | SPY | ETF | 522.95 | 523.17 | 522.29 | 522.43 | 133797.0 |
| 2024-03-27 19:00:00 | SPY | ETF | 522.45 | 522.63 | 522.37 | 522.43 | 37194.0 |
| 2024-03-27 04:00:00 | QQQ | ETF | 444.38 | 445.37 | 444.38 | 445.18 | 45810.0 |
| 2024-03-27 05:00:00 | QQQ | ETF | 445.25 | 445.47 | 444.9 | 445.31 | 29211.0 |
| 2024-03-27 06:00:00 | QQQ | ETF | 445.25 | 445.88 | 445.19 | 445.84 | 82181.0 |
| 2024-03-27 07:00:00 | QQQ | ETF | 445.74 | 445.76 | 445.34 | 445.41 | 81080.0 |
| 2024-03-27 08:00:00 | QQQ | ETF | 445.36 | 446.0 | 444.4 | 446.0 | 203706.0 |
| 2024-03-27 09:00:00 | QQQ | ETF | 446.01 | 446.54 | 443.5196 | 443.621 | 4256355.0 |
| 2024-03-27 10:00:00 | QQQ | ETF | 443.61 | 443.8 | 441.93 | 442.9 | 5664759.0 |
| 2024-03-27 11:00:00 | QQQ | ETF | 442.9 | 443.14 | 442.2 | 442.325 | 3042111.0 |
| 2024-03-27 12:00:00 | QQQ | ETF | 442.32 | 443.69 | 442.23 | 443.39 | 2446925.0 |
| 2024-03-27 13:00:00 | QQQ | ETF | 443.4 | 443.53 | 442.58 | 443.11 | 2045451.0 |
| 2024-03-27 14:00:00 | QQQ | ETF | 443.11 | 443.8596 | 442.7 | 442.86 | 2703789.0 |
| 2024-03-27 15:00:00 | QQQ | ETF | 442.85 | 444.98 | 442.27 | 444.935 | 7183542.0 |
| 2024-03-27 16:00:00 | QQQ | ETF | 444.93 | 445.37 | 444.77 | 444.89 | 1606930.0 |
| 2024-03-27 17:00:00 | QQQ | ETF | 444.88 | 445.0 | 444.76 | 444.8 | 53395.0 |
| 2024-03-27 18:00:00 | QQQ | ETF | 444.82 | 444.83 | 444.2 | 444.31 | 70402.0 |
| 2024-03-27 19:00:00 | QQQ | ETF | 444.34 | 444.57 | 444.15 | 444.28 | 53637.0 |
| 2024-03-27 04:00:00 | IWM | ETF | 206.08 | 206.56 | 206.02 | 206.29 | 15483.0 |
| 2024-03-27 05:00:00 | IWM | ETF | 206.29 | 206.48 | 206.2 | 206.43 | 4344.0 |
| 2024-03-27 06:00:00 | IWM | ETF | 206.39 | 206.79 | 206.39 | 206.73 | 43902.0 |
| 2024-03-27 07:00:00 | IWM | ETF | 206.71 | 206.75 | 206.4 | 206.45 | 75172.0 |
| 2024-03-27 08:00:00 | IWM | ETF | 206.69 | 206.72 | 205.87 | 206.58 | 67829.0 |
| 2024-03-27 09:00:00 | IWM | ETF | 206.58 | 207.405 | 206.53 | 206.95 | 2400699.0 |
| 2024-03-27 10:00:00 | IWM | ETF | 206.95 | 207.7 | 206.155 | 207.28 | 3790098.0 |
| 2024-03-27 11:00:00 | IWM | ETF | 207.28 | 207.96 | 207.21 | 207.77 | 2549000.0 |
| 2024-03-27 12:00:00 | IWM | ETF | 207.78 | 208.47 | 207.6 | 208.45 | 2593978.0 |
| 2024-03-27 13:00:00 | IWM | ETF | 208.4501 | 208.46 | 208.0 | 208.14 | 1515346.0 |
| 2024-03-27 14:00:00 | IWM | ETF | 208.14 | 208.6899 | 208.08 | 208.47 | 1464359.0 |
| 2024-03-27 15:00:00 | IWM | ETF | 208.47 | 209.71 | 208.316 | 209.65 | 7574294.0 |
| 2024-03-27 16:00:00 | IWM | ETF | 209.65 | 210.0 | 209.59 | 209.69 | 2365539.0 |
| 2024-03-27 17:00:00 | IWM | ETF | 209.71 | 210.07 | 209.71 | 209.93 | 90782.0 |
| 2024-03-27 18:00:00 | IWM | ETF | 209.87 | 209.87 | 209.26 | 209.32 | 230917.0 |
| 2024-03-27 19:00:00 | IWM | ETF | 209.37 | 209.53 | 209.18 | 209.51 | 162351.0 |
| 2024-03-27 04:00:00 | DIA | ETF | 394.11 | 394.11 | 394.11 | 394.11 | 500.0 |
| 2024-03-27 06:00:00 | DIA | ETF | 394.5 | 394.69 | 394.5 | 394.69 | 3839.0 |
> showing 50 of 19,632 rows — these rows as CSV