PREVIEW / etf_1hour / 2001-02-06
file: by_date/etf_1hour/2001/2001-02-06.parquet size: 10 KB rows: 200
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-02-06 09:00:00 | SPY | ETF | 135.3 | 135.99 | 135.3 | 135.72 | 955200.0 |
| 2001-02-06 10:00:00 | SPY | ETF | 135.85 | 136.19 | 135.41 | 136.0 | 699900.0 |
| 2001-02-06 11:00:00 | SPY | ETF | 136.0 | 136.59 | 135.93 | 136.58 | 2772300.0 |
| 2001-02-06 12:00:00 | SPY | ETF | 136.55 | 136.7 | 136.3 | 136.42 | 562900.0 |
| 2001-02-06 13:00:00 | SPY | ETF | 136.51 | 136.51 | 135.92 | 136.0 | 427600.0 |
| 2001-02-06 14:00:00 | SPY | ETF | 136.0 | 136.15 | 135.6 | 135.79 | 665700.0 |
| 2001-02-06 15:00:00 | SPY | ETF | 135.8 | 135.89 | 135.22 | 135.42 | 655300.0 |
| 2001-02-06 16:00:00 | SPY | ETF | 135.55 | 135.55 | 135.24 | 135.39 | 311300.0 |
| 2001-02-06 17:00:00 | SPY | ETF | 135.25 | 135.25 | 135.2 | 135.2 | 600.0 |
| 2001-02-06 09:00:00 | QQQ | ETF | 61.49 | 62.43 | 61.4 | 62.23 | 5333300.0 |
| 2001-02-06 10:00:00 | QQQ | ETF | 62.3 | 63.0 | 61.79 | 62.64 | 8850800.0 |
| 2001-02-06 11:00:00 | QQQ | ETF | 62.63 | 62.96 | 62.48 | 62.85 | 4151500.0 |
| 2001-02-06 12:00:00 | QQQ | ETF | 62.93 | 63.12 | 62.65 | 62.73 | 4740800.0 |
| 2001-02-06 13:00:00 | QQQ | ETF | 62.73 | 62.8 | 61.95 | 62.09 | 5348700.0 |
| 2001-02-06 14:00:00 | QQQ | ETF | 62.05 | 62.44 | 61.56 | 61.95 | 6248100.0 |
| 2001-02-06 15:00:00 | QQQ | ETF | 62.05 | 62.1 | 61.16 | 61.7 | 5519400.0 |
| 2001-02-06 16:00:00 | QQQ | ETF | 61.65 | 61.9 | 60.0 | 60.55 | 1590500.0 |
| 2001-02-06 17:00:00 | QQQ | ETF | 60.6 | 60.9 | 60.5 | 60.81 | 194000.0 |
| 2001-02-06 18:00:00 | QQQ | ETF | 60.8 | 60.81 | 60.61 | 60.66 | 26000.0 |
| 2001-02-06 09:00:00 | IWM | ETF | 49.875 | 50.15 | 49.875 | 50.15 | 36800.0 |
| 2001-02-06 10:00:00 | IWM | ETF | 50.15 | 50.475 | 50.135 | 50.475 | 156800.0 |
| 2001-02-06 11:00:00 | IWM | ETF | 50.575 | 50.705 | 50.555 | 50.65 | 165800.0 |
| 2001-02-06 12:00:00 | IWM | ETF | 50.725 | 50.745 | 50.63 | 50.725 | 6800.0 |
| 2001-02-06 13:00:00 | IWM | ETF | 50.745 | 50.745 | 50.625 | 50.65 | 16400.0 |
| 2001-02-06 14:00:00 | IWM | ETF | 50.65 | 50.65 | 50.375 | 50.4 | 5200.0 |
| 2001-02-06 15:00:00 | IWM | ETF | 50.5 | 50.5 | 50.2 | 50.5 | 24200.0 |
| 2001-02-06 16:00:00 | IWM | ETF | 50.575 | 50.575 | 50.575 | 50.575 | 12800.0 |
| 2001-02-06 09:00:00 | DIA | ETF | 109.3 | 109.8 | 109.3 | 109.48 | 111900.0 |
| 2001-02-06 10:00:00 | DIA | ETF | 109.55 | 110.09 | 109.34 | 109.86 | 198100.0 |
| 2001-02-06 11:00:00 | DIA | ETF | 109.86 | 110.39 | 109.8 | 110.3 | 128600.0 |
| 2001-02-06 12:00:00 | DIA | ETF | 110.3 | 110.48 | 110.21 | 110.43 | 320300.0 |
| 2001-02-06 13:00:00 | DIA | ETF | 110.45 | 110.45 | 109.88 | 110.07 | 128100.0 |
| 2001-02-06 14:00:00 | DIA | ETF | 110.1 | 110.1 | 109.48 | 109.79 | 81300.0 |
| 2001-02-06 15:00:00 | DIA | ETF | 109.79 | 109.86 | 109.46 | 109.78 | 212600.0 |
| 2001-02-06 16:00:00 | DIA | ETF | 109.61 | 109.76 | 109.48 | 109.48 | 2500.0 |
> showing 35 of 200 rows — these rows as CSV