PREVIEW / etf_1hour / 2024-03-13
file: by_date/etf_1hour/2024/2024-03-13.parquet size: 533 KB rows: 19,650
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-13 04:00:00 | SPY | ETF | 517.36 | 517.44 | 516.6 | 516.89 | 27547.0 |
| 2024-03-13 05:00:00 | SPY | ETF | 516.69 | 516.99 | 516.6 | 516.88 | 10619.0 |
| 2024-03-13 06:00:00 | SPY | ETF | 516.9 | 517.25 | 516.71 | 517.25 | 65352.0 |
| 2024-03-13 07:00:00 | SPY | ETF | 517.2 | 517.49 | 517.07 | 517.1 | 217951.0 |
| 2024-03-13 08:00:00 | SPY | ETF | 517.34 | 517.4797 | 516.41 | 516.82 | 482057.0 |
| 2024-03-13 09:00:00 | SPY | ETF | 516.78 | 517.24 | 515.95 | 516.08 | 4481967.0 |
| 2024-03-13 10:00:00 | SPY | ETF | 516.08 | 516.78 | 515.67 | 516.21 | 5793059.0 |
| 2024-03-13 11:00:00 | SPY | ETF | 516.21 | 516.7199 | 515.83 | 516.43 | 3744847.0 |
| 2024-03-13 12:00:00 | SPY | ETF | 516.44 | 516.68 | 516.08 | 516.45 | 2739947.0 |
| 2024-03-13 13:00:00 | SPY | ETF | 516.4526 | 517.29 | 516.36 | 517.08 | 4211745.0 |
| 2024-03-13 14:00:00 | SPY | ETF | 517.09 | 517.19 | 516.4 | 516.4901 | 3804008.0 |
| 2024-03-13 15:00:00 | SPY | ETF | 516.5 | 516.695 | 514.49 | 515.99 | 12369886.0 |
| 2024-03-13 16:00:00 | SPY | ETF | 515.99 | 516.49 | 515.85 | 516.39 | 2139772.0 |
| 2024-03-13 17:00:00 | SPY | ETF | 516.4 | 516.41 | 516.29 | 516.37 | 41133.0 |
| 2024-03-13 18:00:00 | SPY | ETF | 516.33 | 516.42 | 516.2 | 516.3 | 67308.0 |
| 2024-03-13 19:00:00 | SPY | ETF | 516.3 | 516.62 | 516.28 | 516.55 | 46719.0 |
| 2024-03-13 04:00:00 | QQQ | ETF | 444.32 | 444.48 | 442.85 | 443.43 | 115043.0 |
| 2024-03-13 05:00:00 | QQQ | ETF | 443.29 | 443.4 | 442.97 | 443.35 | 46870.0 |
| 2024-03-13 06:00:00 | QQQ | ETF | 443.3 | 443.78 | 443.06 | 443.78 | 33574.0 |
| 2024-03-13 07:00:00 | QQQ | ETF | 443.77 | 444.02 | 443.41 | 443.44 | 117732.0 |
| 2024-03-13 08:00:00 | QQQ | ETF | 443.9498 | 444.26 | 442.3 | 442.5891 | 390216.0 |
| 2024-03-13 09:00:00 | QQQ | ETF | 442.58 | 442.95 | 440.435 | 440.512 | 4368823.0 |
| 2024-03-13 10:00:00 | QQQ | ETF | 440.52 | 441.598 | 439.66 | 440.37 | 5136818.0 |
| 2024-03-13 11:00:00 | QQQ | ETF | 440.37 | 441.13 | 439.12 | 440.39 | 3477545.0 |
| 2024-03-13 12:00:00 | QQQ | ETF | 440.39 | 440.98 | 439.99 | 440.75 | 2220972.0 |
| 2024-03-13 13:00:00 | QQQ | ETF | 440.76 | 441.84 | 440.75 | 441.58 | 3473321.0 |
| 2024-03-13 14:00:00 | QQQ | ETF | 441.59 | 441.97 | 441.08 | 441.395 | 2027703.0 |
| 2024-03-13 15:00:00 | QQQ | ETF | 441.38 | 441.62 | 439.22 | 440.23 | 6885843.0 |
| 2024-03-13 16:00:00 | QQQ | ETF | 440.21 | 440.83 | 440.1 | 440.79 | 1218225.0 |
| 2024-03-13 17:00:00 | QQQ | ETF | 440.82 | 440.82 | 440.37 | 440.42 | 65726.0 |
| 2024-03-13 18:00:00 | QQQ | ETF | 440.4 | 440.91 | 440.4 | 440.89 | 118447.0 |
| 2024-03-13 19:00:00 | QQQ | ETF | 440.86 | 441.3 | 440.85 | 441.24 | 66277.0 |
| 2024-03-13 04:00:00 | IWM | ETF | 204.93 | 205.0 | 204.63 | 204.78 | 18362.0 |
| 2024-03-13 05:00:00 | IWM | ETF | 204.79 | 205.2 | 204.79 | 205.08 | 8701.0 |
| 2024-03-13 06:00:00 | IWM | ETF | 205.09 | 205.17 | 204.93 | 205.11 | 9635.0 |
| 2024-03-13 07:00:00 | IWM | ETF | 205.13 | 205.49 | 205.03 | 205.11 | 167906.0 |
| 2024-03-13 08:00:00 | IWM | ETF | 205.17 | 205.48 | 204.57 | 204.67 | 95832.0 |
| 2024-03-13 09:00:00 | IWM | ETF | 204.66 | 206.58 | 204.55 | 205.9677 | 3451852.0 |
| 2024-03-13 10:00:00 | IWM | ETF | 205.97 | 206.49 | 205.44 | 205.6 | 2437438.0 |
| 2024-03-13 11:00:00 | IWM | ETF | 205.595 | 206.24 | 205.3501 | 205.99 | 1723482.0 |
| 2024-03-13 12:00:00 | IWM | ETF | 205.98 | 206.29 | 205.87 | 206.175 | 1225677.0 |
| 2024-03-13 13:00:00 | IWM | ETF | 206.16 | 206.58 | 206.01 | 206.21 | 1575103.0 |
| 2024-03-13 14:00:00 | IWM | ETF | 206.19 | 206.3 | 205.78 | 205.819 | 1172525.0 |
| 2024-03-13 15:00:00 | IWM | ETF | 205.81 | 205.94 | 204.77 | 205.73 | 4674975.0 |
| 2024-03-13 16:00:00 | IWM | ETF | 205.71 | 205.82 | 205.48 | 205.79 | 1286409.0 |
| 2024-03-13 17:00:00 | IWM | ETF | 205.74 | 205.87 | 205.56 | 205.8 | 14830.0 |
| 2024-03-13 18:00:00 | IWM | ETF | 205.79 | 205.8 | 205.7 | 205.7 | 9203.0 |
| 2024-03-13 19:00:00 | IWM | ETF | 205.73 | 205.95 | 205.68 | 205.94 | 62667.0 |
| 2024-03-13 07:00:00 | DIA | ETF | 391.26 | 391.26 | 391.17 | 391.17 | 800.0 |
| 2024-03-13 08:00:00 | DIA | ETF | 391.2096 | 391.32 | 390.92 | 390.98 | 11930.0 |
> showing 50 of 19,650 rows — these rows as CSV