PREVIEW / etf_1hour / 2024-05-22
file: by_date/etf_1hour/2024/2024-05-22.parquet size: 534 KB rows: 20,022
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-22 04:00:00 | SPY | ETF | 531.11 | 531.15 | 530.73 | 530.73 | 4881.0 |
| 2024-05-22 05:00:00 | SPY | ETF | 530.6 | 530.72 | 530.58 | 530.58 | 1013.0 |
| 2024-05-22 06:00:00 | SPY | ETF | 530.67 | 530.74 | 530.35 | 530.5 | 21981.0 |
| 2024-05-22 07:00:00 | SPY | ETF | 530.49 | 530.96 | 530.38 | 530.38 | 139484.0 |
| 2024-05-22 08:00:00 | SPY | ETF | 530.89 | 531.54 | 530.35 | 530.6 | 116601.0 |
| 2024-05-22 09:00:00 | SPY | ETF | 530.6 | 531.19 | 530.4 | 531.15 | 1955762.0 |
| 2024-05-22 10:00:00 | SPY | ETF | 531.145 | 531.28 | 530.78 | 531.12 | 1994693.0 |
| 2024-05-22 11:00:00 | SPY | ETF | 531.13 | 531.38 | 530.16 | 530.71 | 2294358.0 |
| 2024-05-22 12:00:00 | SPY | ETF | 530.69 | 531.17 | 530.63 | 530.8625 | 1770966.0 |
| 2024-05-22 13:00:00 | SPY | ETF | 530.85 | 531.24 | 529.43 | 529.9995 | 3501292.0 |
| 2024-05-22 14:00:00 | SPY | ETF | 529.98 | 529.98 | 527.6 | 528.57 | 6305013.0 |
| 2024-05-22 15:00:00 | SPY | ETF | 528.56 | 529.83 | 527.8 | 529.82 | 10316121.0 |
| 2024-05-22 16:00:00 | SPY | ETF | 529.8 | 531.52 | 528.01 | 529.94 | 4891566.0 |
| 2024-05-22 17:00:00 | SPY | ETF | 529.92 | 531.12 | 529.9 | 530.85 | 374582.0 |
| 2024-05-22 18:00:00 | SPY | ETF | 530.8 | 531.04 | 530.35 | 530.6 | 173961.0 |
| 2024-05-22 19:00:00 | SPY | ETF | 530.6 | 531.03 | 530.58 | 531.0 | 53143.0 |
| 2024-05-22 04:00:00 | QQQ | ETF | 455.82 | 456.05 | 455.52 | 455.67 | 32192.0 |
| 2024-05-22 05:00:00 | QQQ | ETF | 455.74 | 455.77 | 455.18 | 455.33 | 19943.0 |
| 2024-05-22 06:00:00 | QQQ | ETF | 455.43 | 455.43 | 454.79 | 455.3 | 30397.0 |
| 2024-05-22 07:00:00 | QQQ | ETF | 455.4 | 456.12 | 455.4 | 455.69 | 161563.0 |
| 2024-05-22 08:00:00 | QQQ | ETF | 455.69 | 456.24 | 455.2601 | 455.91 | 144910.0 |
| 2024-05-22 09:00:00 | QQQ | ETF | 455.93 | 456.61 | 455.62 | 456.48 | 2300356.0 |
| 2024-05-22 10:00:00 | QQQ | ETF | 456.47 | 456.65 | 455.92 | 456.3899 | 1583599.0 |
| 2024-05-22 11:00:00 | QQQ | ETF | 456.39 | 456.82 | 455.88 | 456.3601 | 1430624.0 |
| 2024-05-22 12:00:00 | QQQ | ETF | 456.36 | 456.67 | 455.6603 | 455.98 | 1308179.0 |
| 2024-05-22 13:00:00 | QQQ | ETF | 455.97 | 456.5 | 454.58 | 455.195 | 1913293.0 |
| 2024-05-22 14:00:00 | QQQ | ETF | 455.18 | 455.18 | 453.08 | 454.18 | 3527218.0 |
| 2024-05-22 15:00:00 | QQQ | ETF | 454.16 | 455.68 | 453.31 | 455.68 | 3565343.0 |
| 2024-05-22 16:00:00 | QQQ | ETF | 455.69 | 458.4 | 453.32 | 456.28 | 1792618.0 |
| 2024-05-22 17:00:00 | QQQ | ETF | 456.3 | 457.99 | 455.71 | 457.25 | 373835.0 |
| 2024-05-22 18:00:00 | QQQ | ETF | 457.25 | 457.63 | 456.95 | 457.18 | 143970.0 |
| 2024-05-22 19:00:00 | QQQ | ETF | 457.18 | 457.7 | 457.18 | 457.679 | 68319.0 |
| 2024-05-22 04:00:00 | IWM | ETF | 208.13 | 208.15 | 207.85 | 207.89 | 8416.0 |
| 2024-05-22 05:00:00 | IWM | ETF | 207.91 | 207.98 | 207.7 | 207.82 | 8208.0 |
| 2024-05-22 06:00:00 | IWM | ETF | 207.78 | 208.08 | 207.74 | 207.84 | 56797.0 |
| 2024-05-22 07:00:00 | IWM | ETF | 207.85 | 208.12 | 207.51 | 207.53 | 36780.0 |
| 2024-05-22 08:00:00 | IWM | ETF | 207.8 | 208.58 | 207.49 | 207.71 | 60906.0 |
| 2024-05-22 09:00:00 | IWM | ETF | 207.67 | 208.15 | 207.16 | 207.91 | 1940950.0 |
| 2024-05-22 10:00:00 | IWM | ETF | 207.935 | 208.06 | 207.34 | 208.03 | 1820480.0 |
| 2024-05-22 11:00:00 | IWM | ETF | 208.03 | 208.1 | 207.43 | 207.67 | 985920.0 |
| 2024-05-22 12:00:00 | IWM | ETF | 207.67 | 208.22 | 207.64 | 207.9946 | 875537.0 |
| 2024-05-22 13:00:00 | IWM | ETF | 207.99 | 208.136 | 207.2 | 207.595 | 1393655.0 |
| 2024-05-22 14:00:00 | IWM | ETF | 207.59 | 207.59 | 205.8 | 206.32 | 3268445.0 |
| 2024-05-22 15:00:00 | IWM | ETF | 206.32 | 206.8 | 205.94 | 206.62 | 5071824.0 |
| 2024-05-22 16:00:00 | IWM | ETF | 206.64 | 206.99 | 206.0 | 206.19 | 1762865.0 |
| 2024-05-22 17:00:00 | IWM | ETF | 206.15 | 206.45 | 206.13 | 206.2 | 65324.0 |
| 2024-05-22 18:00:00 | IWM | ETF | 206.29 | 206.46 | 206.16 | 206.45 | 14550.0 |
| 2024-05-22 19:00:00 | IWM | ETF | 206.45 | 206.67 | 206.45 | 206.58 | 27762.0 |
| 2024-05-22 07:00:00 | DIA | ETF | 398.24 | 398.24 | 397.9 | 397.9 | 2424.0 |
| 2024-05-22 08:00:00 | DIA | ETF | 397.849 | 398.1 | 397.849 | 398.1 | 4392.0 |
> showing 50 of 20,022 rows — these rows as CSV