PREVIEW / etf_1hour / 2024-03-14
file: by_date/etf_1hour/2024/2024-03-14.parquet size: 528 KB rows: 19,512
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-14 04:00:00 | SPY | ETF | 517.0 | 518.0 | 517.0 | 517.7 | 42699.0 |
| 2024-03-14 05:00:00 | SPY | ETF | 517.91 | 518.12 | 517.77 | 517.88 | 10275.0 |
| 2024-03-14 06:00:00 | SPY | ETF | 518.0 | 518.05 | 517.73 | 517.96 | 8798.0 |
| 2024-03-14 07:00:00 | SPY | ETF | 517.94 | 518.32 | 517.78 | 517.85 | 107083.0 |
| 2024-03-14 08:00:00 | SPY | ETF | 517.87 | 518.31 | 516.71 | 517.15 | 671155.0 |
| 2024-03-14 09:00:00 | SPY | ETF | 517.15 | 517.55 | 513.95 | 513.98 | 7298040.0 |
| 2024-03-14 10:00:00 | SPY | ETF | 513.99 | 515.61 | 513.35 | 514.64 | 9503282.0 |
| 2024-03-14 11:00:00 | SPY | ETF | 514.64 | 515.41 | 514.06 | 514.99 | 6288663.0 |
| 2024-03-14 12:00:00 | SPY | ETF | 514.99 | 515.15 | 513.84 | 513.9 | 5103462.0 |
| 2024-03-14 13:00:00 | SPY | ETF | 513.9 | 514.6 | 512.76 | 514.53 | 5880115.0 |
| 2024-03-14 14:00:00 | SPY | ETF | 514.54 | 515.19 | 513.84 | 513.8916 | 6882858.0 |
| 2024-03-14 15:00:00 | SPY | ETF | 513.89 | 514.98 | 511.82 | 514.95 | 27202444.0 |
| 2024-03-14 16:00:00 | SPY | ETF | 514.94 | 515.16 | 514.2145 | 514.74 | 5196141.0 |
| 2024-03-14 17:00:00 | SPY | ETF | 514.76 | 514.95 | 514.31 | 514.42 | 124513.0 |
| 2024-03-14 18:00:00 | SPY | ETF | 514.4 | 514.67 | 514.4 | 514.43 | 109090.0 |
| 2024-03-14 19:00:00 | SPY | ETF | 514.44 | 514.44 | 513.93 | 514.25 | 42514.0 |
| 2024-03-14 04:00:00 | QQQ | ETF | 442.05 | 442.76 | 442.0 | 442.5 | 82914.0 |
| 2024-03-14 05:00:00 | QQQ | ETF | 442.42 | 442.71 | 442.37 | 442.5 | 23085.0 |
| 2024-03-14 06:00:00 | QQQ | ETF | 442.51 | 442.62 | 442.16 | 442.31 | 44415.0 |
| 2024-03-14 07:00:00 | QQQ | ETF | 442.35 | 442.61 | 441.87 | 441.97 | 176392.0 |
| 2024-03-14 08:00:00 | QQQ | ETF | 442.0 | 442.6199 | 440.58 | 441.38 | 488754.0 |
| 2024-03-14 09:00:00 | QQQ | ETF | 441.31 | 442.03 | 438.02 | 438.29 | 5734713.0 |
| 2024-03-14 10:00:00 | QQQ | ETF | 438.24 | 440.73 | 437.39 | 439.71 | 6612523.0 |
| 2024-03-14 11:00:00 | QQQ | ETF | 439.76 | 440.62 | 438.85 | 439.77 | 4037068.0 |
| 2024-03-14 12:00:00 | QQQ | ETF | 439.77 | 440.04 | 438.34 | 438.5701 | 3579240.0 |
| 2024-03-14 13:00:00 | QQQ | ETF | 438.6 | 439.59 | 437.58 | 439.54 | 3275489.0 |
| 2024-03-14 14:00:00 | QQQ | ETF | 439.56 | 440.44 | 438.52 | 438.55 | 4167773.0 |
| 2024-03-14 15:00:00 | QQQ | ETF | 438.55 | 439.21 | 436.39 | 439.2 | 9078945.0 |
| 2024-03-14 16:00:00 | QQQ | ETF | 439.21 | 439.7 | 438.65 | 438.9 | 1684176.0 |
| 2024-03-14 17:00:00 | QQQ | ETF | 438.88 | 438.9 | 438.25 | 438.34 | 120161.0 |
| 2024-03-14 18:00:00 | QQQ | ETF | 438.39 | 438.71 | 438.34 | 438.46 | 162388.0 |
| 2024-03-14 19:00:00 | QQQ | ETF | 438.45 | 438.45 | 437.87 | 438.19 | 56151.0 |
| 2024-03-14 04:00:00 | IWM | ETF | 206.26 | 206.63 | 206.23 | 206.63 | 21168.0 |
| 2024-03-14 05:00:00 | IWM | ETF | 206.5 | 206.51 | 206.26 | 206.26 | 3230.0 |
| 2024-03-14 06:00:00 | IWM | ETF | 206.3 | 206.31 | 206.11 | 206.21 | 16592.0 |
| 2024-03-14 07:00:00 | IWM | ETF | 206.2 | 206.42 | 206.1 | 206.23 | 17119.0 |
| 2024-03-14 08:00:00 | IWM | ETF | 206.2 | 206.28 | 204.31 | 205.4 | 608855.0 |
| 2024-03-14 09:00:00 | IWM | ETF | 205.39 | 205.61 | 202.2507 | 202.34 | 4818149.0 |
| 2024-03-14 10:00:00 | IWM | ETF | 202.35 | 203.19 | 201.95 | 202.615 | 6570166.0 |
| 2024-03-14 11:00:00 | IWM | ETF | 202.62 | 202.77 | 201.73 | 202.43 | 3534302.0 |
| 2024-03-14 12:00:00 | IWM | ETF | 202.42 | 202.52 | 201.84 | 201.97 | 1931143.0 |
| 2024-03-14 13:00:00 | IWM | ETF | 201.98 | 202.155 | 201.325 | 202.15 | 2463042.0 |
| 2024-03-14 14:00:00 | IWM | ETF | 202.15 | 202.325 | 201.28 | 201.33 | 2369673.0 |
| 2024-03-14 15:00:00 | IWM | ETF | 201.33 | 201.98 | 200.17 | 201.96 | 10174472.0 |
| 2024-03-14 16:00:00 | IWM | ETF | 201.96 | 202.16 | 200.3696 | 201.96 | 3600388.0 |
| 2024-03-14 17:00:00 | IWM | ETF | 201.99 | 202.03 | 201.76 | 201.76 | 53477.0 |
| 2024-03-14 18:00:00 | IWM | ETF | 201.9 | 202.07 | 201.81 | 201.81 | 52878.0 |
| 2024-03-14 19:00:00 | IWM | ETF | 201.83 | 201.83 | 201.53 | 201.65 | 19175.0 |
| 2024-03-14 04:00:00 | DIA | ETF | 392.33 | 392.33 | 392.31 | 392.31 | 470.0 |
| 2024-03-14 05:00:00 | DIA | ETF | 392.67 | 392.67 | 392.67 | 392.67 | 256.0 |
> showing 50 of 19,512 rows — these rows as CSV