PREVIEW / etf_1hour / 2024-05-10
file: by_date/etf_1hour/2024/2024-05-10.parquet size: 518 KB rows: 19,243
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-10 04:00:00 | SPY | ETF | 521.0 | 521.91 | 520.86 | 521.91 | 9543.0 |
| 2024-05-10 05:00:00 | SPY | ETF | 521.9 | 522.32 | 521.9 | 522.22 | 23923.0 |
| 2024-05-10 06:00:00 | SPY | ETF | 522.11 | 522.11 | 521.8 | 521.92 | 95073.0 |
| 2024-05-10 07:00:00 | SPY | ETF | 521.91 | 522.0 | 520.94 | 521.73 | 194732.0 |
| 2024-05-10 08:00:00 | SPY | ETF | 521.88 | 522.32 | 520.78 | 521.34 | 326815.0 |
| 2024-05-10 09:00:00 | SPY | ETF | 521.3108 | 522.635 | 521.3 | 522.42 | 4789802.0 |
| 2024-05-10 10:00:00 | SPY | ETF | 522.41 | 522.43 | 520.01 | 520.48 | 8054881.0 |
| 2024-05-10 11:00:00 | SPY | ETF | 520.5 | 520.66 | 519.59 | 520.365 | 4550109.0 |
| 2024-05-10 12:00:00 | SPY | ETF | 520.37 | 520.77 | 519.83 | 520.53 | 3471229.0 |
| 2024-05-10 13:00:00 | SPY | ETF | 520.535 | 520.84 | 519.91 | 520.8 | 2975627.0 |
| 2024-05-10 14:00:00 | SPY | ETF | 520.79 | 520.9499 | 520.115 | 520.9322 | 3049340.0 |
| 2024-05-10 15:00:00 | SPY | ETF | 520.93 | 521.34 | 520.62 | 520.84 | 7255122.0 |
| 2024-05-10 16:00:00 | SPY | ETF | 520.84 | 520.95 | 520.41 | 520.45 | 3622621.0 |
| 2024-05-10 17:00:00 | SPY | ETF | 520.45 | 520.53 | 520.07 | 520.0822 | 67047.0 |
| 2024-05-10 18:00:00 | SPY | ETF | 520.1 | 520.13 | 519.98 | 520.07 | 59993.0 |
| 2024-05-10 19:00:00 | SPY | ETF | 520.1 | 520.13 | 519.75 | 519.92 | 34739.0 |
| 2024-05-10 04:00:00 | QQQ | ETF | 441.82 | 442.77 | 441.53 | 442.76 | 16791.0 |
| 2024-05-10 05:00:00 | QQQ | ETF | 442.92 | 443.24 | 442.86 | 443.16 | 18760.0 |
| 2024-05-10 06:00:00 | QQQ | ETF | 443.01 | 443.13 | 442.84 | 442.84 | 28400.0 |
| 2024-05-10 07:00:00 | QQQ | ETF | 442.89 | 443.16 | 442.66 | 442.82 | 64999.0 |
| 2024-05-10 08:00:00 | QQQ | ETF | 442.8 | 443.2 | 441.1 | 442.04 | 185725.0 |
| 2024-05-10 09:00:00 | QQQ | ETF | 442.01 | 444.31 | 441.92 | 443.8 | 3274913.0 |
| 2024-05-10 10:00:00 | QQQ | ETF | 443.8 | 443.81 | 440.499 | 441.22 | 5266383.0 |
| 2024-05-10 11:00:00 | QQQ | ETF | 441.24 | 441.8199 | 440.61 | 441.63 | 3070239.0 |
| 2024-05-10 12:00:00 | QQQ | ETF | 441.63 | 442.03 | 440.96 | 441.835 | 1781509.0 |
| 2024-05-10 13:00:00 | QQQ | ETF | 441.83 | 442.04 | 440.94 | 442.008 | 1528316.0 |
| 2024-05-10 14:00:00 | QQQ | ETF | 442.0 | 442.26 | 441.44 | 442.115 | 1540265.0 |
| 2024-05-10 15:00:00 | QQQ | ETF | 442.11 | 442.44 | 441.76 | 442.06 | 3917326.0 |
| 2024-05-10 16:00:00 | QQQ | ETF | 442.06 | 442.11 | 441.69 | 441.76 | 620552.0 |
| 2024-05-10 17:00:00 | QQQ | ETF | 441.75 | 441.8 | 441.48 | 441.56 | 27404.0 |
| 2024-05-10 18:00:00 | QQQ | ETF | 441.5 | 441.57 | 441.4 | 441.45 | 8087.0 |
| 2024-05-10 19:00:00 | QQQ | ETF | 442.06 | 442.06 | 441.14 | 441.25 | 36401.0 |
| 2024-05-10 04:00:00 | IWM | ETF | 206.32 | 206.71 | 206.26 | 206.7 | 10302.0 |
| 2024-05-10 05:00:00 | IWM | ETF | 206.81 | 207.0 | 206.79 | 206.89 | 9244.0 |
| 2024-05-10 06:00:00 | IWM | ETF | 206.87 | 206.88 | 206.67 | 206.71 | 6243.0 |
| 2024-05-10 07:00:00 | IWM | ETF | 206.7 | 206.95 | 206.57 | 206.57 | 24980.0 |
| 2024-05-10 08:00:00 | IWM | ETF | 206.778 | 207.0 | 206.1207 | 206.24 | 87068.0 |
| 2024-05-10 09:00:00 | IWM | ETF | 206.24 | 206.62 | 205.79 | 206.01 | 1749404.0 |
| 2024-05-10 10:00:00 | IWM | ETF | 206.0 | 206.005 | 204.04 | 204.1341 | 4697138.0 |
| 2024-05-10 11:00:00 | IWM | ETF | 204.145 | 204.35 | 203.85 | 204.27 | 2169279.0 |
| 2024-05-10 12:00:00 | IWM | ETF | 204.25 | 204.26 | 203.905 | 204.11 | 1432500.0 |
| 2024-05-10 13:00:00 | IWM | ETF | 204.1 | 204.15 | 203.68 | 204.01 | 1642086.0 |
| 2024-05-10 14:00:00 | IWM | ETF | 204.0 | 204.085 | 203.7201 | 204.07 | 1037829.0 |
| 2024-05-10 15:00:00 | IWM | ETF | 204.065 | 204.47 | 203.96 | 204.3 | 3280682.0 |
| 2024-05-10 16:00:00 | IWM | ETF | 204.31 | 204.4 | 204.01 | 204.1 | 565740.0 |
| 2024-05-10 17:00:00 | IWM | ETF | 204.1 | 204.18 | 204.02 | 204.08 | 12037.0 |
| 2024-05-10 18:00:00 | IWM | ETF | 204.08 | 204.08 | 203.8 | 203.99 | 11017.0 |
| 2024-05-10 19:00:00 | IWM | ETF | 204.01 | 204.08 | 203.81 | 203.9 | 6363.0 |
| 2024-05-10 04:00:00 | DIA | ETF | 394.7 | 395.0 | 394.67 | 395.0 | 3124.0 |
| 2024-05-10 05:00:00 | DIA | ETF | 395.06 | 395.4 | 395.06 | 395.35 | 1647.0 |
> showing 50 of 19,243 rows — these rows as CSV