PREVIEW / etf_1hour / 2001-05-21
file: by_date/etf_1hour/2001/2001-05-21.parquet size: 12 KB rows: 232
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 |
|---|---|---|---|---|---|---|---|
| 2001-05-21 09:00:00 | SPY | ETF | 129.84 | 129.84 | 129.15 | 129.49 | 697600.0 |
| 2001-05-21 10:00:00 | SPY | ETF | 129.5 | 130.21 | 129.42 | 130.17 | 2258300.0 |
| 2001-05-21 11:00:00 | SPY | ETF | 130.09 | 130.93 | 130.07 | 130.79 | 2622000.0 |
| 2001-05-21 12:00:00 | SPY | ETF | 130.9 | 131.11 | 130.74 | 130.82 | 690900.0 |
| 2001-05-21 13:00:00 | SPY | ETF | 130.78 | 131.18 | 130.57 | 130.57 | 602600.0 |
| 2001-05-21 14:00:00 | SPY | ETF | 130.61 | 131.32 | 130.52 | 131.32 | 711000.0 |
| 2001-05-21 15:00:00 | SPY | ETF | 131.33 | 131.8 | 131.24 | 131.77 | 2330900.0 |
| 2001-05-21 16:00:00 | SPY | ETF | 131.8 | 131.84 | 130.95 | 131.65 | 594500.0 |
| 2001-05-21 17:00:00 | SPY | ETF | 131.7 | 131.7 | 131.65 | 131.65 | 600.0 |
| 2001-05-21 09:00:00 | QQQ | ETF | 48.17 | 48.57 | 47.96 | 48.31 | 10377300.0 |
| 2001-05-21 10:00:00 | QQQ | ETF | 48.3 | 49.38 | 48.3 | 49.35 | 14412500.0 |
| 2001-05-21 11:00:00 | QQQ | ETF | 49.33 | 50.14 | 49.29 | 50.07 | 14347700.0 |
| 2001-05-21 12:00:00 | QQQ | ETF | 50.02 | 50.47 | 50.0 | 50.25 | 11387400.0 |
| 2001-05-21 13:00:00 | QQQ | ETF | 50.24 | 50.55 | 50.0 | 50.01 | 7518100.0 |
| 2001-05-21 14:00:00 | QQQ | ETF | 50.07 | 50.75 | 49.9 | 50.75 | 9604100.0 |
| 2001-05-21 15:00:00 | QQQ | ETF | 50.75 | 51.12 | 50.59 | 51.1 | 11875100.0 |
| 2001-05-21 16:00:00 | QQQ | ETF | 51.08 | 51.15 | 50.9 | 51.05 | 2153400.0 |
| 2001-05-21 17:00:00 | QQQ | ETF | 51.05 | 51.12 | 51.0 | 51.03 | 35900.0 |
| 2001-05-21 18:00:00 | QQQ | ETF | 51.02 | 51.05 | 51.02 | 51.03 | 9800.0 |
| 2001-05-21 09:00:00 | IWM | ETF | 50.425 | 50.475 | 50.35 | 50.475 | 17200.0 |
| 2001-05-21 10:00:00 | IWM | ETF | 50.475 | 50.875 | 50.475 | 50.825 | 61800.0 |
| 2001-05-21 11:00:00 | IWM | ETF | 50.8 | 51.075 | 50.73 | 51.075 | 29400.0 |
| 2001-05-21 12:00:00 | IWM | ETF | 51.075 | 51.075 | 50.95 | 51.05 | 21400.0 |
| 2001-05-21 13:00:00 | IWM | ETF | 51.05 | 51.12 | 50.995 | 51.095 | 27000.0 |
| 2001-05-21 14:00:00 | IWM | ETF | 51.0 | 51.15 | 50.95 | 51.15 | 110400.0 |
| 2001-05-21 15:00:00 | IWM | ETF | 51.175 | 51.375 | 51.175 | 51.32 | 104600.0 |
| 2001-05-21 16:00:00 | IWM | ETF | 51.45 | 51.45 | 51.45 | 51.45 | 1800.0 |
| 2001-05-21 09:00:00 | DIA | ETF | 113.0 | 113.0 | 112.4 | 112.65 | 459300.0 |
| 2001-05-21 10:00:00 | DIA | ETF | 112.65 | 113.15 | 112.51 | 112.78 | 786100.0 |
| 2001-05-21 11:00:00 | DIA | ETF | 112.72 | 113.38 | 112.69 | 113.15 | 638400.0 |
| 2001-05-21 12:00:00 | DIA | ETF | 113.1 | 113.35 | 112.91 | 112.95 | 532600.0 |
| 2001-05-21 13:00:00 | DIA | ETF | 113.01 | 113.17 | 112.6 | 112.7 | 214500.0 |
| 2001-05-21 14:00:00 | DIA | ETF | 112.7 | 113.13 | 112.56 | 113.09 | 257100.0 |
| 2001-05-21 15:00:00 | DIA | ETF | 113.15 | 113.6 | 113.07 | 113.46 | 961500.0 |
| 2001-05-21 16:00:00 | DIA | ETF | 113.51 | 113.58 | 113.15 | 113.2 | 133400.0 |
| 2001-05-21 17:00:00 | DIA | ETF | 113.5 | 113.5 | 113.5 | 113.5 | 300.0 |
| 2001-05-21 18:00:00 | DIA | ETF | 113.5 | 113.6 | 113.5 | 113.6 | 800.0 |
> showing 37 of 232 rows — these rows as CSV