PREVIEW / etf_1hour / 2024-05-23
file: by_date/etf_1hour/2024/2024-05-23.parquet size: 542 KB rows: 20,176
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-05-23 04:00:00 | SPY | ETF | 532.0 | 532.73 | 532.0 | 532.31 | 9147.0 |
| 2024-05-23 05:00:00 | SPY | ETF | 532.4 | 532.8 | 532.32 | 532.74 | 12317.0 |
| 2024-05-23 06:00:00 | SPY | ETF | 532.7 | 533.11 | 532.66 | 533.11 | 6682.0 |
| 2024-05-23 07:00:00 | SPY | ETF | 533.11 | 533.58 | 532.2 | 533.53 | 271870.0 |
| 2024-05-23 08:00:00 | SPY | ETF | 533.18 | 534.0 | 531.57 | 533.7 | 437252.0 |
| 2024-05-23 09:00:00 | SPY | ETF | 533.7 | 533.72 | 529.545 | 529.96 | 5921095.0 |
| 2024-05-23 10:00:00 | SPY | ETF | 529.93 | 530.99 | 529.01 | 529.05 | 4228740.0 |
| 2024-05-23 11:00:00 | SPY | ETF | 529.06 | 531.484 | 528.98 | 531.08 | 3544584.0 |
| 2024-05-23 12:00:00 | SPY | ETF | 531.08 | 531.42 | 529.54 | 529.54 | 2634823.0 |
| 2024-05-23 13:00:00 | SPY | ETF | 529.56 | 529.84 | 526.57 | 526.7 | 4194139.0 |
| 2024-05-23 14:00:00 | SPY | ETF | 526.72 | 526.85 | 524.85 | 524.94 | 5898435.0 |
| 2024-05-23 15:00:00 | SPY | ETF | 524.94 | 526.26 | 524.72 | 525.95 | 11226808.0 |
| 2024-05-23 16:00:00 | SPY | ETF | 525.96 | 530.2218 | 525.52 | 525.98 | 4236250.0 |
| 2024-05-23 17:00:00 | SPY | ETF | 525.91 | 526.0 | 525.7 | 525.78 | 98276.0 |
| 2024-05-23 18:00:00 | SPY | ETF | 525.86 | 526.12 | 525.86 | 526.01 | 42943.0 |
| 2024-05-23 19:00:00 | SPY | ETF | 526.03 | 526.38 | 526.0 | 526.1 | 27860.0 |
| 2024-05-23 04:00:00 | QQQ | ETF | 459.12 | 459.76 | 459.12 | 459.43 | 84916.0 |
| 2024-05-23 05:00:00 | QQQ | ETF | 459.34 | 459.88 | 459.31 | 459.73 | 41094.0 |
| 2024-05-23 06:00:00 | QQQ | ETF | 459.7 | 460.29 | 459.61 | 460.23 | 51180.0 |
| 2024-05-23 07:00:00 | QQQ | ETF | 460.19 | 460.75 | 460.131 | 460.7 | 131272.0 |
| 2024-05-23 08:00:00 | QQQ | ETF | 460.3 | 461.5 | 459.31 | 461.081 | 292761.0 |
| 2024-05-23 09:00:00 | QQQ | ETF | 461.15 | 461.15 | 457.07 | 457.4 | 4993631.0 |
| 2024-05-23 10:00:00 | QQQ | ETF | 457.4 | 458.93 | 456.19 | 456.3153 | 4774888.0 |
| 2024-05-23 11:00:00 | QQQ | ETF | 456.33 | 459.2999 | 456.29 | 458.92 | 2859086.0 |
| 2024-05-23 12:00:00 | QQQ | ETF | 458.9213 | 459.3683 | 457.21 | 457.215 | 2103307.0 |
| 2024-05-23 13:00:00 | QQQ | ETF | 457.2 | 457.58 | 454.04 | 454.14 | 3966927.0 |
| 2024-05-23 14:00:00 | QQQ | ETF | 454.1 | 454.3401 | 452.0 | 452.135 | 4180867.0 |
| 2024-05-23 15:00:00 | QQQ | ETF | 452.12 | 454.13 | 451.8503 | 453.64 | 4839371.0 |
| 2024-05-23 16:00:00 | QQQ | ETF | 453.65 | 457.9384 | 453.26 | 453.43 | 834343.0 |
| 2024-05-23 17:00:00 | QQQ | ETF | 453.35 | 453.5 | 453.0 | 453.1 | 59326.0 |
| 2024-05-23 18:00:00 | QQQ | ETF | 453.17 | 453.58 | 453.17 | 453.56 | 93667.0 |
| 2024-05-23 19:00:00 | QQQ | ETF | 453.54 | 454.09 | 453.54 | 453.75 | 41315.0 |
| 2024-05-23 04:00:00 | IWM | ETF | 206.8 | 207.2 | 206.8 | 207.01 | 52047.0 |
| 2024-05-23 05:00:00 | IWM | ETF | 207.04 | 207.34 | 207.04 | 207.26 | 5675.0 |
| 2024-05-23 06:00:00 | IWM | ETF | 207.33 | 207.4 | 207.22 | 207.39 | 33761.0 |
| 2024-05-23 07:00:00 | IWM | ETF | 207.41 | 207.66 | 207.17 | 207.65 | 141630.0 |
| 2024-05-23 08:00:00 | IWM | ETF | 207.63 | 207.9 | 206.9696 | 207.44 | 313756.0 |
| 2024-05-23 09:00:00 | IWM | ETF | 207.52 | 207.62 | 205.11 | 205.47 | 3130327.0 |
| 2024-05-23 10:00:00 | IWM | ETF | 205.47 | 205.905 | 204.48 | 204.57 | 2676428.0 |
| 2024-05-23 11:00:00 | IWM | ETF | 204.57 | 205.65 | 204.55 | 205.44 | 2221993.0 |
| 2024-05-23 12:00:00 | IWM | ETF | 205.44 | 205.815 | 204.75 | 204.755 | 1405310.0 |
| 2024-05-23 13:00:00 | IWM | ETF | 204.75 | 204.84 | 203.25 | 203.29 | 3096806.0 |
| 2024-05-23 14:00:00 | IWM | ETF | 203.3 | 203.31 | 202.35 | 202.43 | 5565288.0 |
| 2024-05-23 15:00:00 | IWM | ETF | 202.42 | 203.31 | 202.4 | 203.25 | 6318049.0 |
| 2024-05-23 16:00:00 | IWM | ETF | 203.19 | 203.54 | 202.6 | 203.53 | 2284741.0 |
| 2024-05-23 17:00:00 | IWM | ETF | 203.49 | 203.5 | 203.3 | 203.31 | 15559.0 |
| 2024-05-23 18:00:00 | IWM | ETF | 203.39 | 203.67 | 203.39 | 203.6 | 56003.0 |
| 2024-05-23 19:00:00 | IWM | ETF | 203.57 | 203.68 | 203.5 | 203.5 | 8221.0 |
| 2024-05-23 05:00:00 | DIA | ETF | 396.77 | 396.77 | 396.77 | 396.77 | 100.0 |
| 2024-05-23 06:00:00 | DIA | ETF | 397.28 | 397.28 | 397.28 | 397.28 | 500.0 |
> showing 50 of 20,176 rows — these rows as CSV