PREVIEW / etf_1hour / 2024-05-24
file: by_date/etf_1hour/2024/2024-05-24.parquet size: 521 KB rows: 19,124
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-24 04:00:00 | SPY | ETF | 526.64 | 527.36 | 526.64 | 527.29 | 10111.0 |
| 2024-05-24 05:00:00 | SPY | ETF | 527.14 | 527.29 | 526.95 | 526.95 | 7580.0 |
| 2024-05-24 06:00:00 | SPY | ETF | 527.14 | 527.48 | 527.14 | 527.42 | 5602.0 |
| 2024-05-24 07:00:00 | SPY | ETF | 527.35 | 527.6 | 526.55 | 527.57 | 223689.0 |
| 2024-05-24 08:00:00 | SPY | ETF | 527.37 | 527.91 | 526.16 | 527.44 | 338366.0 |
| 2024-05-24 09:00:00 | SPY | ETF | 527.49 | 528.095 | 526.881 | 527.202 | 4086111.0 |
| 2024-05-24 10:00:00 | SPY | ETF | 527.25 | 529.12 | 527.23 | 529.03 | 3742533.0 |
| 2024-05-24 11:00:00 | SPY | ETF | 529.02 | 530.27 | 528.89 | 529.45 | 4508699.0 |
| 2024-05-24 12:00:00 | SPY | ETF | 529.44 | 530.01 | 529.24 | 529.255 | 2400699.0 |
| 2024-05-24 13:00:00 | SPY | ETF | 529.26 | 529.87 | 529.06 | 529.565 | 2125637.0 |
| 2024-05-24 14:00:00 | SPY | ETF | 529.53 | 530.1 | 529.06 | 529.0899 | 2529389.0 |
| 2024-05-24 15:00:00 | SPY | ETF | 529.08 | 529.58 | 528.28 | 529.5 | 6041890.0 |
| 2024-05-24 16:00:00 | SPY | ETF | 529.51 | 529.69 | 529.2141 | 529.44 | 2484724.0 |
| 2024-05-24 17:00:00 | SPY | ETF | 529.4 | 529.6 | 529.37 | 529.5 | 694752.0 |
| 2024-05-24 18:00:00 | SPY | ETF | 529.6187 | 529.6332 | 529.48 | 529.5 | 7775.0 |
| 2024-05-24 19:00:00 | SPY | ETF | 529.53 | 529.6 | 529.36 | 529.38 | 18633.0 |
| 2024-05-24 04:00:00 | QQQ | ETF | 453.92 | 454.9 | 453.9 | 454.73 | 70720.0 |
| 2024-05-24 05:00:00 | QQQ | ETF | 454.72 | 454.88 | 454.41 | 454.57 | 15063.0 |
| 2024-05-24 06:00:00 | QQQ | ETF | 454.58 | 455.08 | 454.58 | 455.04 | 18519.0 |
| 2024-05-24 07:00:00 | QQQ | ETF | 454.88 | 455.28 | 454.74 | 455.26 | 76869.0 |
| 2024-05-24 08:00:00 | QQQ | ETF | 455.02 | 455.54 | 453.34 | 455.03 | 188130.0 |
| 2024-05-24 09:00:00 | QQQ | ETF | 455.09 | 455.89 | 454.58 | 455.01 | 2279446.0 |
| 2024-05-24 10:00:00 | QQQ | ETF | 455.05 | 457.78 | 455.05 | 457.6704 | 3122154.0 |
| 2024-05-24 11:00:00 | QQQ | ETF | 457.68 | 459.06 | 457.61 | 458.52 | 3302278.0 |
| 2024-05-24 12:00:00 | QQQ | ETF | 458.52 | 458.96 | 458.2 | 458.22 | 1647875.0 |
| 2024-05-24 13:00:00 | QQQ | ETF | 458.24 | 458.83 | 457.95 | 458.68 | 1514974.0 |
| 2024-05-24 14:00:00 | QQQ | ETF | 458.67 | 459.23 | 457.86 | 457.88 | 1897476.0 |
| 2024-05-24 15:00:00 | QQQ | ETF | 457.88 | 458.19 | 457.05 | 458.01 | 3895437.0 |
| 2024-05-24 16:00:00 | QQQ | ETF | 458.01 | 458.5329 | 457.8 | 457.93 | 1214521.0 |
| 2024-05-24 17:00:00 | QQQ | ETF | 457.95 | 458.0 | 457.88 | 457.88 | 16043.0 |
| 2024-05-24 18:00:00 | QQQ | ETF | 457.8799 | 457.9493 | 457.78 | 457.89 | 9958.0 |
| 2024-05-24 19:00:00 | QQQ | ETF | 457.9008 | 458.01 | 457.9008 | 457.95 | 8667.0 |
| 2024-05-24 04:00:00 | IWM | ETF | 203.88 | 204.3 | 203.81 | 204.3 | 12642.0 |
| 2024-05-24 05:00:00 | IWM | ETF | 204.15 | 204.29 | 204.12 | 204.19 | 16128.0 |
| 2024-05-24 06:00:00 | IWM | ETF | 204.23 | 204.38 | 204.23 | 204.36 | 13062.0 |
| 2024-05-24 07:00:00 | IWM | ETF | 204.31 | 204.6 | 204.28 | 204.54 | 60369.0 |
| 2024-05-24 08:00:00 | IWM | ETF | 204.3203 | 204.74 | 203.74 | 204.26 | 177434.0 |
| 2024-05-24 09:00:00 | IWM | ETF | 204.2 | 204.845 | 203.96 | 204.1 | 1963309.0 |
| 2024-05-24 10:00:00 | IWM | ETF | 204.12 | 205.185 | 204.12 | 205.18 | 2646164.0 |
| 2024-05-24 11:00:00 | IWM | ETF | 205.19 | 205.68 | 205.025 | 205.1301 | 1939385.0 |
| 2024-05-24 12:00:00 | IWM | ETF | 205.13 | 205.56 | 205.1 | 205.1783 | 1093264.0 |
| 2024-05-24 13:00:00 | IWM | ETF | 205.18 | 205.41 | 205.115 | 205.25 | 1034965.0 |
| 2024-05-24 14:00:00 | IWM | ETF | 205.245 | 205.395 | 204.875 | 204.915 | 1375882.0 |
| 2024-05-24 15:00:00 | IWM | ETF | 204.91 | 205.52 | 204.62 | 205.45 | 3290923.0 |
| 2024-05-24 16:00:00 | IWM | ETF | 205.44 | 205.54 | 205.33 | 205.44 | 669848.0 |
| 2024-05-24 17:00:00 | IWM | ETF | 205.47 | 205.53 | 205.38 | 205.5 | 16282.0 |
| 2024-05-24 18:00:00 | IWM | ETF | 205.53 | 205.53 | 205.44 | 205.51 | 26030.0 |
| 2024-05-24 19:00:00 | IWM | ETF | 205.51 | 205.51 | 205.3 | 205.41 | 11268.0 |
| 2024-05-24 04:00:00 | DIA | ETF | 391.13 | 391.21 | 391.13 | 391.21 | 1206.0 |
| 2024-05-24 05:00:00 | DIA | ETF | 391.3 | 391.3 | 391.12 | 391.14 | 1863.0 |
> showing 50 of 19,124 rows — these rows as CSV