PREVIEW / etf_1hour / 2024-05-20
file: by_date/etf_1hour/2024/2024-05-20.parquet size: 545 KB rows: 20,094
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-20 04:00:00 | SPY | ETF | 529.82 | 530.16 | 529.82 | 530.04 | 14334.0 |
| 2024-05-20 05:00:00 | SPY | ETF | 529.93 | 530.16 | 529.93 | 530.13 | 1959.0 |
| 2024-05-20 06:00:00 | SPY | ETF | 530.12 | 530.23 | 530.07 | 530.23 | 28070.0 |
| 2024-05-20 07:00:00 | SPY | ETF | 530.23 | 530.43 | 529.98 | 530.31 | 101847.0 |
| 2024-05-20 08:00:00 | SPY | ETF | 530.2108 | 530.44 | 529.64 | 529.7 | 182398.0 |
| 2024-05-20 09:00:00 | SPY | ETF | 529.72 | 531.23 | 529.47 | 531.1679 | 3101141.0 |
| 2024-05-20 10:00:00 | SPY | ETF | 531.19 | 531.48 | 530.7 | 531.24 | 3034234.0 |
| 2024-05-20 11:00:00 | SPY | ETF | 531.23 | 531.5601 | 530.815 | 531.0013 | 2344118.0 |
| 2024-05-20 12:00:00 | SPY | ETF | 531.0 | 531.23 | 530.635 | 531.22 | 2050014.0 |
| 2024-05-20 13:00:00 | SPY | ETF | 531.21 | 531.28 | 530.06 | 530.2465 | 2238094.0 |
| 2024-05-20 14:00:00 | SPY | ETF | 530.25 | 530.44 | 529.17 | 529.895 | 3433895.0 |
| 2024-05-20 15:00:00 | SPY | ETF | 529.895 | 530.405 | 529.5 | 530.02 | 7054263.0 |
| 2024-05-20 16:00:00 | SPY | ETF | 530.02 | 530.29 | 529.7 | 529.96 | 3697560.0 |
| 2024-05-20 17:00:00 | SPY | ETF | 529.93 | 530.1 | 529.88 | 530.02 | 26651.0 |
| 2024-05-20 18:00:00 | SPY | ETF | 530.0 | 530.09 | 529.76 | 529.83 | 23177.0 |
| 2024-05-20 19:00:00 | SPY | ETF | 529.8 | 529.92 | 529.8 | 529.9 | 7258.0 |
| 2024-05-20 04:00:00 | QQQ | ETF | 452.4 | 452.63 | 452.27 | 452.39 | 28566.0 |
| 2024-05-20 05:00:00 | QQQ | ETF | 452.39 | 452.61 | 452.24 | 452.6 | 10064.0 |
| 2024-05-20 06:00:00 | QQQ | ETF | 452.69 | 452.8 | 452.51 | 452.8 | 49649.0 |
| 2024-05-20 07:00:00 | QQQ | ETF | 452.78 | 453.07 | 452.61 | 452.9 | 40319.0 |
| 2024-05-20 08:00:00 | QQQ | ETF | 452.8104 | 453.06 | 451.99 | 452.06 | 162736.0 |
| 2024-05-20 09:00:00 | QQQ | ETF | 452.11 | 454.64 | 451.785 | 454.51 | 3505032.0 |
| 2024-05-20 10:00:00 | QQQ | ETF | 454.52 | 455.01 | 454.1086 | 454.365 | 2807080.0 |
| 2024-05-20 11:00:00 | QQQ | ETF | 454.365 | 454.8153 | 454.02 | 454.334 | 1349644.0 |
| 2024-05-20 12:00:00 | QQQ | ETF | 454.33 | 455.58 | 454.31 | 455.51 | 1372178.0 |
| 2024-05-20 13:00:00 | QQQ | ETF | 455.516 | 455.56 | 454.161 | 454.401 | 2081723.0 |
| 2024-05-20 14:00:00 | QQQ | ETF | 454.405 | 454.92 | 453.48 | 454.46 | 1982398.0 |
| 2024-05-20 15:00:00 | QQQ | ETF | 454.46 | 455.318 | 454.28 | 454.92 | 4623350.0 |
| 2024-05-20 16:00:00 | QQQ | ETF | 454.91 | 455.09 | 454.24 | 454.4 | 1469550.0 |
| 2024-05-20 17:00:00 | QQQ | ETF | 454.4291 | 454.55 | 454.4 | 454.51 | 26074.0 |
| 2024-05-20 18:00:00 | QQQ | ETF | 454.51 | 454.91 | 454.37 | 454.4 | 37386.0 |
| 2024-05-20 19:00:00 | QQQ | ETF | 454.4101 | 454.58 | 454.3709 | 454.55 | 30004.0 |
| 2024-05-20 04:00:00 | IWM | ETF | 208.35 | 208.39 | 208.26 | 208.31 | 9237.0 |
| 2024-05-20 05:00:00 | IWM | ETF | 208.35 | 208.5 | 208.15 | 208.45 | 6574.0 |
| 2024-05-20 06:00:00 | IWM | ETF | 208.46 | 208.6 | 208.4 | 208.58 | 10868.0 |
| 2024-05-20 07:00:00 | IWM | ETF | 208.64 | 208.67 | 208.32 | 208.33 | 19828.0 |
| 2024-05-20 08:00:00 | IWM | ETF | 208.52 | 208.66 | 207.7 | 207.86 | 109509.0 |
| 2024-05-20 09:00:00 | IWM | ETF | 207.84 | 208.54 | 207.65 | 208.475 | 2002996.0 |
| 2024-05-20 10:00:00 | IWM | ETF | 208.475 | 208.99 | 208.16 | 208.94 | 2508124.0 |
| 2024-05-20 11:00:00 | IWM | ETF | 208.94 | 209.48 | 208.805 | 209.37 | 1455907.0 |
| 2024-05-20 12:00:00 | IWM | ETF | 209.38 | 209.43 | 209.09 | 209.37 | 830368.0 |
| 2024-05-20 13:00:00 | IWM | ETF | 209.36 | 209.36 | 208.88 | 208.9564 | 915230.0 |
| 2024-05-20 14:00:00 | IWM | ETF | 208.95 | 208.98 | 208.51 | 208.775 | 992774.0 |
| 2024-05-20 15:00:00 | IWM | ETF | 208.77 | 209.105 | 208.5 | 208.61 | 3191742.0 |
| 2024-05-20 16:00:00 | IWM | ETF | 208.61 | 208.75 | 208.5 | 208.72 | 566923.0 |
| 2024-05-20 17:00:00 | IWM | ETF | 208.68 | 208.73 | 208.56 | 208.69 | 5433.0 |
| 2024-05-20 18:00:00 | IWM | ETF | 208.68 | 208.88 | 208.56 | 208.66 | 17225.0 |
| 2024-05-20 19:00:00 | IWM | ETF | 208.65 | 208.72 | 208.61 | 208.65 | 6389.0 |
| 2024-05-20 04:00:00 | DIA | ETF | 400.17 | 400.17 | 400.0 | 400.0 | 672.0 |
| 2024-05-20 07:00:00 | DIA | ETF | 400.29 | 400.29 | 400.18 | 400.29 | 604.0 |
> showing 50 of 20,094 rows — these rows as CSV