PREVIEW / etf_1hour / 2001-03-30
file: by_date/etf_1hour/2001/2001-03-30.parquet size: 11 KB rows: 216
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-03-30 09:00:00 | SPY | ETF | 115.55 | 115.9 | 115.12 | 115.64 | 1002900.0 |
| 2001-03-30 10:00:00 | SPY | ETF | 115.5 | 115.95 | 114.8 | 115.09 | 1850700.0 |
| 2001-03-30 11:00:00 | SPY | ETF | 114.99 | 115.6 | 114.5 | 115.34 | 891100.0 |
| 2001-03-30 12:00:00 | SPY | ETF | 115.46 | 115.82 | 115.2 | 115.47 | 561500.0 |
| 2001-03-30 13:00:00 | SPY | ETF | 115.47 | 115.86 | 114.94 | 115.86 | 689700.0 |
| 2001-03-30 14:00:00 | SPY | ETF | 115.78 | 116.65 | 115.7 | 116.28 | 1650600.0 |
| 2001-03-30 15:00:00 | SPY | ETF | 116.1 | 116.44 | 115.43 | 116.12 | 1403700.0 |
| 2001-03-30 16:00:00 | SPY | ETF | 116.19 | 116.75 | 116.0 | 116.69 | 779700.0 |
| 2001-03-30 17:00:00 | SPY | ETF | 116.68 | 116.75 | 116.68 | 116.75 | 7200.0 |
| 2001-03-30 09:00:00 | QQQ | ETF | 39.3 | 39.43 | 38.62 | 39.05 | 8042200.0 |
| 2001-03-30 10:00:00 | QQQ | ETF | 39.05 | 39.28 | 38.23 | 38.35 | 10493400.0 |
| 2001-03-30 11:00:00 | QQQ | ETF | 38.33 | 38.9 | 38.08 | 38.79 | 7909500.0 |
| 2001-03-30 12:00:00 | QQQ | ETF | 38.79 | 39.15 | 38.6 | 38.86 | 6598700.0 |
| 2001-03-30 13:00:00 | QQQ | ETF | 38.87 | 39.5 | 38.55 | 39.48 | 5200400.0 |
| 2001-03-30 14:00:00 | QQQ | ETF | 39.48 | 39.98 | 39.31 | 39.45 | 10039100.0 |
| 2001-03-30 15:00:00 | QQQ | ETF | 39.45 | 39.53 | 38.85 | 39.13 | 10105500.0 |
| 2001-03-30 16:00:00 | QQQ | ETF | 39.12 | 39.4 | 39.05 | 39.26 | 964400.0 |
| 2001-03-30 17:00:00 | QQQ | ETF | 39.26 | 39.3 | 39.2 | 39.2 | 25900.0 |
| 2001-03-30 18:00:00 | QQQ | ETF | 39.2 | 39.35 | 39.1 | 39.1 | 7500.0 |
| 2001-03-30 09:00:00 | IWM | ETF | 44.225 | 44.225 | 44.2 | 44.2 | 1000.0 |
| 2001-03-30 10:00:00 | IWM | ETF | 44.19 | 44.3 | 44.025 | 44.3 | 36000.0 |
| 2001-03-30 11:00:00 | IWM | ETF | 43.95 | 43.95 | 43.95 | 43.95 | 200.0 |
| 2001-03-30 12:00:00 | IWM | ETF | 44.25 | 44.475 | 44.25 | 44.435 | 22800.0 |
| 2001-03-30 13:00:00 | IWM | ETF | 44.25 | 44.44 | 44.21 | 44.35 | 17400.0 |
| 2001-03-30 14:00:00 | IWM | ETF | 44.575 | 44.925 | 44.575 | 44.65 | 26800.0 |
| 2001-03-30 15:00:00 | IWM | ETF | 44.6 | 44.9 | 44.55 | 44.85 | 96600.0 |
| 2001-03-30 16:00:00 | IWM | ETF | 44.8 | 44.8 | 44.8 | 44.8 | 10000.0 |
| 2001-03-30 09:00:00 | DIA | ETF | 98.32 | 98.65 | 97.95 | 98.19 | 553300.0 |
| 2001-03-30 10:00:00 | DIA | ETF | 98.25 | 98.61 | 97.71 | 98.14 | 1012900.0 |
| 2001-03-30 11:00:00 | DIA | ETF | 98.14 | 98.6 | 97.55 | 98.45 | 772000.0 |
| 2001-03-30 12:00:00 | DIA | ETF | 98.49 | 98.8 | 98.25 | 98.41 | 382300.0 |
| 2001-03-30 13:00:00 | DIA | ETF | 98.32 | 98.75 | 98.1 | 98.54 | 257600.0 |
| 2001-03-30 14:00:00 | DIA | ETF | 98.55 | 99.29 | 98.42 | 98.91 | 772700.0 |
| 2001-03-30 15:00:00 | DIA | ETF | 98.85 | 99.14 | 98.36 | 98.68 | 960100.0 |
| 2001-03-30 16:00:00 | DIA | ETF | 98.8 | 99.28 | 98.21 | 98.9 | 163900.0 |
> showing 35 of 216 rows — these rows as CSV