PREVIEW / etf_1hour / 2024-03-19
file: by_date/etf_1hour/2024/2024-03-19.parquet size: 534 KB rows: 19,659
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-19 04:00:00 | SPY | ETF | 512.45 | 513.45 | 512.11 | 512.85 | 23353.0 |
| 2024-03-19 05:00:00 | SPY | ETF | 512.95 | 513.06 | 511.88 | 511.88 | 19320.0 |
| 2024-03-19 06:00:00 | SPY | ETF | 512.09 | 512.33 | 511.71 | 511.95 | 151856.0 |
| 2024-03-19 07:00:00 | SPY | ETF | 511.86 | 511.86 | 510.56 | 510.96 | 146339.0 |
| 2024-03-19 08:00:00 | SPY | ETF | 510.96 | 513.4604 | 510.29 | 511.44 | 237044.0 |
| 2024-03-19 09:00:00 | SPY | ETF | 511.45 | 512.2 | 511.12 | 511.6899 | 4561881.0 |
| 2024-03-19 10:00:00 | SPY | ETF | 511.68 | 512.61 | 511.22 | 512.23 | 6166184.0 |
| 2024-03-19 11:00:00 | SPY | ETF | 512.24 | 513.43 | 512.16 | 513.1802 | 3997074.0 |
| 2024-03-19 12:00:00 | SPY | ETF | 513.18 | 515.135 | 513.005 | 514.6798 | 5722994.0 |
| 2024-03-19 13:00:00 | SPY | ETF | 514.68 | 515.45 | 514.36 | 514.99 | 4104035.0 |
| 2024-03-19 14:00:00 | SPY | ETF | 514.99 | 515.3599 | 514.5 | 514.9 | 4738240.0 |
| 2024-03-19 15:00:00 | SPY | ETF | 514.885 | 515.995 | 514.23 | 515.76 | 11904369.0 |
| 2024-03-19 16:00:00 | SPY | ETF | 515.76 | 515.94 | 515.43 | 515.56 | 4077511.0 |
| 2024-03-19 17:00:00 | SPY | ETF | 515.52 | 515.62 | 515.41 | 515.53 | 62337.0 |
| 2024-03-19 18:00:00 | SPY | ETF | 515.53 | 515.6 | 515.42 | 515.57 | 31291.0 |
| 2024-03-19 19:00:00 | SPY | ETF | 515.6 | 515.63 | 515.45 | 515.45 | 10120.0 |
| 2024-03-19 04:00:00 | QQQ | ETF | 436.4 | 438.1 | 435.9 | 437.35 | 129034.0 |
| 2024-03-19 05:00:00 | QQQ | ETF | 437.49 | 437.57 | 436.2 | 436.28 | 41783.0 |
| 2024-03-19 06:00:00 | QQQ | ETF | 436.25 | 436.85 | 436.08 | 436.39 | 60016.0 |
| 2024-03-19 07:00:00 | QQQ | ETF | 436.339 | 436.339 | 434.53 | 434.85 | 304109.0 |
| 2024-03-19 08:00:00 | QQQ | ETF | 434.92 | 437.9496 | 433.95 | 435.16 | 355061.0 |
| 2024-03-19 09:00:00 | QQQ | ETF | 435.12 | 435.69 | 433.33 | 434.24 | 4935974.0 |
| 2024-03-19 10:00:00 | QQQ | ETF | 434.22 | 435.57 | 433.68 | 434.85 | 4860647.0 |
| 2024-03-19 11:00:00 | QQQ | ETF | 434.87 | 436.13 | 434.57 | 435.865 | 3254186.0 |
| 2024-03-19 12:00:00 | QQQ | ETF | 435.86 | 438.5 | 435.59 | 437.8993 | 4441714.0 |
| 2024-03-19 13:00:00 | QQQ | ETF | 437.91 | 438.89 | 437.63 | 438.39 | 2866442.0 |
| 2024-03-19 14:00:00 | QQQ | ETF | 438.4 | 438.98 | 437.86 | 438.42 | 2752830.0 |
| 2024-03-19 15:00:00 | QQQ | ETF | 438.4 | 438.88 | 437.24 | 438.58 | 6953229.0 |
| 2024-03-19 16:00:00 | QQQ | ETF | 438.57 | 438.93 | 438.4 | 438.6 | 1289528.0 |
| 2024-03-19 17:00:00 | QQQ | ETF | 438.649 | 438.72 | 438.47 | 438.68 | 27463.0 |
| 2024-03-19 18:00:00 | QQQ | ETF | 438.63 | 438.78 | 438.5 | 438.7 | 25799.0 |
| 2024-03-19 19:00:00 | QQQ | ETF | 438.78 | 438.83 | 438.47 | 438.52 | 52989.0 |
| 2024-03-19 04:00:00 | IWM | ETF | 200.89 | 201.05 | 200.7 | 200.82 | 19671.0 |
| 2024-03-19 05:00:00 | IWM | ETF | 200.73 | 200.83 | 200.43 | 200.61 | 5471.0 |
| 2024-03-19 06:00:00 | IWM | ETF | 200.62 | 200.93 | 200.54 | 200.63 | 4940.0 |
| 2024-03-19 07:00:00 | IWM | ETF | 200.6 | 200.62 | 200.22 | 200.27 | 178654.0 |
| 2024-03-19 08:00:00 | IWM | ETF | 200.6393 | 201.32 | 199.53 | 199.91 | 161143.0 |
| 2024-03-19 09:00:00 | IWM | ETF | 199.916 | 200.97 | 199.661 | 200.13 | 3204301.0 |
| 2024-03-19 10:00:00 | IWM | ETF | 200.135 | 200.71 | 199.92 | 200.585 | 2687086.0 |
| 2024-03-19 11:00:00 | IWM | ETF | 200.5704 | 201.565 | 200.46 | 201.56 | 2495014.0 |
| 2024-03-19 12:00:00 | IWM | ETF | 201.56 | 202.69 | 201.46 | 202.34 | 2562878.0 |
| 2024-03-19 13:00:00 | IWM | ETF | 202.34 | 202.75 | 202.155 | 202.34 | 2189325.0 |
| 2024-03-19 14:00:00 | IWM | ETF | 202.35 | 202.7 | 202.02 | 202.21 | 1878665.0 |
| 2024-03-19 15:00:00 | IWM | ETF | 202.21 | 202.435 | 201.74 | 202.13 | 4371235.0 |
| 2024-03-19 16:00:00 | IWM | ETF | 202.1 | 202.31 | 202.07 | 202.2 | 1008788.0 |
| 2024-03-19 17:00:00 | IWM | ETF | 202.15 | 202.19 | 202.06 | 202.15 | 15203.0 |
| 2024-03-19 18:00:00 | IWM | ETF | 202.11 | 202.16 | 202.01 | 202.16 | 7783.0 |
| 2024-03-19 19:00:00 | IWM | ETF | 202.15 | 202.15 | 202.01 | 202.05 | 13460.0 |
| 2024-03-19 04:00:00 | DIA | ETF | 387.67 | 387.9 | 387.67 | 387.9 | 300.0 |
| 2024-03-19 06:00:00 | DIA | ETF | 387.53 | 387.53 | 387.13 | 387.21 | 912.0 |
> showing 50 of 19,659 rows — these rows as CSV