PREVIEW / etf_1hour / 2024-08-20
file: by_date/etf_1hour/2024/2024-08-20.parquet size: 552 KB rows: 20,509
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-08-20 04:00:00 | SPY | ETF | 560.0 | 560.43 | 559.31 | 559.77 | 66628.0 |
| 2024-08-20 05:00:00 | SPY | ETF | 559.89 | 560.2 | 559.71 | 559.71 | 16427.0 |
| 2024-08-20 06:00:00 | SPY | ETF | 559.68 | 560.11 | 559.65 | 560.05 | 8977.0 |
| 2024-08-20 07:00:00 | SPY | ETF | 559.95 | 560.26 | 559.76 | 559.95 | 94678.0 |
| 2024-08-20 08:00:00 | SPY | ETF | 560.21 | 560.57 | 559.4404 | 559.59 | 211379.0 |
| 2024-08-20 09:00:00 | SPY | ETF | 559.6 | 560.84 | 559.12 | 560.745 | 2775716.0 |
| 2024-08-20 10:00:00 | SPY | ETF | 560.75 | 560.82 | 557.96 | 558.38 | 4635802.0 |
| 2024-08-20 11:00:00 | SPY | ETF | 558.38 | 559.3205 | 557.84 | 559.29 | 2602650.0 |
| 2024-08-20 12:00:00 | SPY | ETF | 559.29 | 559.43 | 558.02 | 558.05 | 1785957.0 |
| 2024-08-20 13:00:00 | SPY | ETF | 558.05 | 558.48 | 557.325 | 558.325 | 1984230.0 |
| 2024-08-20 14:00:00 | SPY | ETF | 558.31 | 559.74 | 558.2 | 559.08 | 2656812.0 |
| 2024-08-20 15:00:00 | SPY | ETF | 559.08 | 559.23 | 558.4 | 558.62 | 5460206.0 |
| 2024-08-20 16:00:00 | SPY | ETF | 558.62 | 559.1 | 558.5487 | 558.58 | 2013689.0 |
| 2024-08-20 17:00:00 | SPY | ETF | 558.5801 | 558.7 | 558.42 | 558.5 | 879675.0 |
| 2024-08-20 18:00:00 | SPY | ETF | 558.51 | 558.69 | 558.35 | 558.53 | 27951.0 |
| 2024-08-20 19:00:00 | SPY | ETF | 558.6 | 558.74 | 558.45 | 558.54 | 12944.0 |
| 2024-08-20 04:00:00 | QQQ | ETF | 481.77 | 482.61 | 481.13 | 481.65 | 80188.0 |
| 2024-08-20 05:00:00 | QQQ | ETF | 481.76 | 482.36 | 481.76 | 481.85 | 18223.0 |
| 2024-08-20 06:00:00 | QQQ | ETF | 481.75 | 482.15 | 481.63 | 481.82 | 42544.0 |
| 2024-08-20 07:00:00 | QQQ | ETF | 481.79 | 482.1 | 481.45 | 481.7 | 116768.0 |
| 2024-08-20 08:00:00 | QQQ | ETF | 481.7919 | 482.89 | 480.91 | 481.1 | 302166.0 |
| 2024-08-20 09:00:00 | QQQ | ETF | 481.0901 | 482.94 | 480.2 | 482.79 | 3685649.0 |
| 2024-08-20 10:00:00 | QQQ | ETF | 482.8 | 482.9 | 478.55 | 479.55 | 4795413.0 |
| 2024-08-20 11:00:00 | QQQ | ETF | 479.56 | 481.22 | 479.27 | 481.19 | 2232738.0 |
| 2024-08-20 12:00:00 | QQQ | ETF | 481.21 | 481.35 | 479.34 | 479.37 | 1648688.0 |
| 2024-08-20 13:00:00 | QQQ | ETF | 479.4 | 480.25 | 478.65 | 480.13 | 1530904.0 |
| 2024-08-20 14:00:00 | QQQ | ETF | 480.11 | 481.532 | 479.97 | 481.2 | 2552720.0 |
| 2024-08-20 15:00:00 | QQQ | ETF | 481.19 | 481.34 | 480.03 | 480.2 | 3468999.0 |
| 2024-08-20 16:00:00 | QQQ | ETF | 480.2 | 480.69 | 480.0 | 480.06 | 1221172.0 |
| 2024-08-20 17:00:00 | QQQ | ETF | 480.07 | 480.26 | 479.6011 | 479.75 | 544957.0 |
| 2024-08-20 18:00:00 | QQQ | ETF | 479.84 | 480.28 | 479.64 | 479.8 | 124780.0 |
| 2024-08-20 19:00:00 | QQQ | ETF | 479.82 | 480.0 | 479.6 | 479.6112 | 59572.0 |
| 2024-08-20 04:00:00 | IWM | ETF | 215.78 | 215.99 | 215.14 | 215.22 | 7136.0 |
| 2024-08-20 05:00:00 | IWM | ETF | 215.28 | 215.38 | 215.13 | 215.13 | 5569.0 |
| 2024-08-20 06:00:00 | IWM | ETF | 215.04 | 215.29 | 215.04 | 215.21 | 5146.0 |
| 2024-08-20 07:00:00 | IWM | ETF | 215.17 | 215.5 | 215.17 | 215.37 | 76871.0 |
| 2024-08-20 08:00:00 | IWM | ETF | 215.2288 | 216.16 | 214.97 | 215.35 | 138429.0 |
| 2024-08-20 09:00:00 | IWM | ETF | 215.3713 | 215.41 | 214.012 | 214.35 | 1971081.0 |
| 2024-08-20 10:00:00 | IWM | ETF | 214.36 | 214.47 | 212.27 | 212.4 | 2844950.0 |
| 2024-08-20 11:00:00 | IWM | ETF | 212.41 | 213.0525 | 212.26 | 212.9912 | 1446711.0 |
| 2024-08-20 12:00:00 | IWM | ETF | 213.0 | 213.04 | 212.23 | 212.29 | 1353269.0 |
| 2024-08-20 13:00:00 | IWM | ETF | 212.3 | 212.54 | 212.05 | 212.38 | 1469977.0 |
| 2024-08-20 14:00:00 | IWM | ETF | 212.37 | 213.28 | 212.345 | 213.14 | 863880.0 |
| 2024-08-20 15:00:00 | IWM | ETF | 213.135 | 213.29 | 212.66 | 212.75 | 2316247.0 |
| 2024-08-20 16:00:00 | IWM | ETF | 212.69 | 213.07 | 212.69 | 212.82 | 2608186.0 |
| 2024-08-20 17:00:00 | IWM | ETF | 212.76 | 212.8386 | 212.73 | 212.82 | 6681.0 |
| 2024-08-20 18:00:00 | IWM | ETF | 212.79 | 212.8 | 212.65 | 212.7657 | 208007.0 |
| 2024-08-20 19:00:00 | IWM | ETF | 212.73 | 212.97 | 212.69 | 212.75 | 70067.0 |
| 2024-08-20 07:00:00 | DIA | ETF | 409.02 | 409.02 | 409.019 | 409.019 | 300.0 |
| 2024-08-20 08:00:00 | DIA | ETF | 409.01 | 409.1004 | 408.72 | 408.72 | 2340.0 |
> showing 50 of 20,509 rows — these rows as CSV