PREVIEW / etf_1hour / 2001-03-29
file: by_date/etf_1hour/2001/2001-03-29.parquet size: 10 KB rows: 179
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-29 10:00:00 | SPY | ETF | 114.63 | 116.5 | 114.44 | 116.16 | 2320200.0 |
| 2001-03-29 11:00:00 | SPY | ETF | 116.26 | 116.28 | 115.3 | 115.5 | 1143500.0 |
| 2001-03-29 12:00:00 | SPY | ETF | 115.46 | 116.2 | 115.41 | 115.9 | 650700.0 |
| 2001-03-29 13:00:00 | SPY | ETF | 115.89 | 116.08 | 115.4 | 115.5 | 466500.0 |
| 2001-03-29 14:00:00 | SPY | ETF | 115.45 | 115.62 | 114.0 | 114.0 | 1726400.0 |
| 2001-03-29 15:00:00 | SPY | ETF | 114.13 | 115.18 | 113.7 | 114.98 | 2133600.0 |
| 2001-03-29 16:00:00 | SPY | ETF | 115.06 | 115.59 | 114.44 | 115.39 | 714300.0 |
| 2001-03-29 17:00:00 | SPY | ETF | 115.39 | 115.39 | 115.39 | 115.39 | 300.0 |
| 2001-03-29 18:00:00 | SPY | ETF | 115.45 | 115.45 | 115.45 | 115.45 | 200.0 |
| 2001-03-29 10:00:00 | QQQ | ETF | 39.22 | 40.61 | 39.1 | 40.47 | 17791600.0 |
| 2001-03-29 11:00:00 | QQQ | ETF | 40.5 | 40.5 | 39.46 | 39.67 | 8742200.0 |
| 2001-03-29 12:00:00 | QQQ | ETF | 39.67 | 40.1 | 39.52 | 39.82 | 3897600.0 |
| 2001-03-29 13:00:00 | QQQ | ETF | 39.7 | 39.89 | 39.2 | 39.29 | 3593600.0 |
| 2001-03-29 14:00:00 | QQQ | ETF | 39.28 | 39.39 | 38.5 | 38.57 | 9835700.0 |
| 2001-03-29 15:00:00 | QQQ | ETF | 38.57 | 39.06 | 38.45 | 38.97 | 15770200.0 |
| 2001-03-29 16:00:00 | QQQ | ETF | 38.99 | 39.09 | 38.75 | 39.0 | 1204100.0 |
| 2001-03-29 17:00:00 | QQQ | ETF | 39.09 | 39.2 | 38.97 | 39.18 | 96500.0 |
| 2001-03-29 18:00:00 | QQQ | ETF | 39.19 | 39.4 | 39.1 | 39.4 | 23600.0 |
| 2001-03-29 10:00:00 | IWM | ETF | 43.9 | 44.7 | 43.9 | 44.7 | 57400.0 |
| 2001-03-29 11:00:00 | IWM | ETF | 44.65 | 44.65 | 44.25 | 44.25 | 181200.0 |
| 2001-03-29 12:00:00 | IWM | ETF | 44.385 | 44.5 | 44.385 | 44.5 | 74000.0 |
| 2001-03-29 13:00:00 | IWM | ETF | 44.5 | 44.5 | 44.375 | 44.475 | 88600.0 |
| 2001-03-29 14:00:00 | IWM | ETF | 44.205 | 44.4 | 43.9 | 43.9 | 75400.0 |
| 2001-03-29 15:00:00 | IWM | ETF | 43.775 | 44.0 | 43.75 | 43.95 | 91200.0 |
| 2001-03-29 10:00:00 | DIA | ETF | 97.05 | 98.97 | 97.03 | 98.8 | 1294000.0 |
| 2001-03-29 11:00:00 | DIA | ETF | 98.86 | 98.89 | 97.96 | 98.21 | 428600.0 |
| 2001-03-29 12:00:00 | DIA | ETF | 98.19 | 98.76 | 98.1 | 98.31 | 175600.0 |
| 2001-03-29 13:00:00 | DIA | ETF | 98.39 | 98.63 | 98.1 | 98.24 | 258400.0 |
| 2001-03-29 14:00:00 | DIA | ETF | 98.2 | 98.42 | 97.27 | 97.3 | 786800.0 |
| 2001-03-29 15:00:00 | DIA | ETF | 97.28 | 98.0 | 96.8 | 98.0 | 1215800.0 |
| 2001-03-29 16:00:00 | DIA | ETF | 98.0 | 98.38 | 97.92 | 98.11 | 176000.0 |
> showing 31 of 179 rows — these rows as CSV