PREVIEW / etf_1hour / 2001-03-28
file: by_date/etf_1hour/2001/2001-03-28.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-28 09:00:00 | SPY | ETF | 116.9 | 116.95 | 115.88 | 116.08 | 2511300.0 |
| 2001-03-28 10:00:00 | SPY | ETF | 115.99 | 116.35 | 115.54 | 115.75 | 1440600.0 |
| 2001-03-28 11:00:00 | SPY | ETF | 115.84 | 116.07 | 115.13 | 115.36 | 1211400.0 |
| 2001-03-28 12:00:00 | SPY | ETF | 115.4 | 116.08 | 115.28 | 116.0 | 754200.0 |
| 2001-03-28 13:00:00 | SPY | ETF | 116.03 | 116.14 | 115.42 | 115.5 | 732000.0 |
| 2001-03-28 14:00:00 | SPY | ETF | 115.42 | 115.99 | 115.05 | 115.63 | 898600.0 |
| 2001-03-28 15:00:00 | SPY | ETF | 115.7 | 116.2 | 114.9 | 115.45 | 2113300.0 |
| 2001-03-28 16:00:00 | SPY | ETF | 115.35 | 116.53 | 114.14 | 115.25 | 678100.0 |
| 2001-03-28 17:00:00 | SPY | ETF | 115.0 | 115.27 | 115.0 | 115.27 | 10300.0 |
| 2001-03-28 09:00:00 | QQQ | ETF | 41.9 | 42.1 | 41.55 | 41.66 | 8787500.0 |
| 2001-03-28 10:00:00 | QQQ | ETF | 41.72 | 41.91 | 41.26 | 41.32 | 11611300.0 |
| 2001-03-28 11:00:00 | QQQ | ETF | 41.32 | 41.45 | 40.75 | 40.87 | 8539400.0 |
| 2001-03-28 12:00:00 | QQQ | ETF | 40.87 | 41.16 | 40.82 | 41.05 | 8697900.0 |
| 2001-03-28 13:00:00 | QQQ | ETF | 41.06 | 41.12 | 40.36 | 40.4 | 9846900.0 |
| 2001-03-28 14:00:00 | QQQ | ETF | 40.43 | 40.69 | 39.94 | 40.5 | 11600800.0 |
| 2001-03-28 15:00:00 | QQQ | ETF | 40.4 | 40.63 | 39.9 | 39.9 | 12293200.0 |
| 2001-03-28 16:00:00 | QQQ | ETF | 39.94 | 40.04 | 39.5 | 39.76 | 3151200.0 |
| 2001-03-28 17:00:00 | QQQ | ETF | 39.71 | 39.78 | 39.65 | 39.75 | 57300.0 |
| 2001-03-28 18:00:00 | QQQ | ETF | 39.75 | 39.8 | 39.5 | 39.75 | 19200.0 |
| 2001-03-28 09:00:00 | IWM | ETF | 44.45 | 44.5 | 44.15 | 44.15 | 560000.0 |
| 2001-03-28 10:00:00 | IWM | ETF | 44.2 | 44.36 | 44.03 | 44.325 | 120600.0 |
| 2001-03-28 11:00:00 | IWM | ETF | 44.29 | 44.29 | 43.95 | 44.0 | 125600.0 |
| 2001-03-28 12:00:00 | IWM | ETF | 44.0 | 44.25 | 43.975 | 44.15 | 81400.0 |
| 2001-03-28 13:00:00 | IWM | ETF | 44.225 | 44.225 | 44.0 | 44.0 | 87600.0 |
| 2001-03-28 14:00:00 | IWM | ETF | 43.975 | 44.225 | 43.775 | 44.2 | 64800.0 |
| 2001-03-28 15:00:00 | IWM | ETF | 44.295 | 44.295 | 44.0 | 44.01 | 51400.0 |
| 2001-03-28 16:00:00 | IWM | ETF | 44.0 | 44.0 | 43.875 | 43.875 | 101200.0 |
| 2001-03-28 09:00:00 | DIA | ETF | 98.4 | 98.73 | 97.61 | 97.64 | 1157200.0 |
| 2001-03-28 10:00:00 | DIA | ETF | 97.63 | 97.9 | 97.25 | 97.35 | 1296800.0 |
| 2001-03-28 11:00:00 | DIA | ETF | 97.26 | 97.6 | 97.0 | 97.21 | 582400.0 |
| 2001-03-28 12:00:00 | DIA | ETF | 97.21 | 97.83 | 97.18 | 97.79 | 352800.0 |
| 2001-03-28 13:00:00 | DIA | ETF | 97.75 | 97.89 | 97.32 | 97.6 | 227800.0 |
| 2001-03-28 14:00:00 | DIA | ETF | 97.6 | 98.0 | 97.17 | 97.8 | 471000.0 |
| 2001-03-28 15:00:00 | DIA | ETF | 97.75 | 98.5 | 97.2 | 97.69 | 1076600.0 |
| 2001-03-28 16:00:00 | DIA | ETF | 97.6 | 98.0 | 97.3 | 97.8 | 113600.0 |
| 2001-03-28 17:00:00 | DIA | ETF | 97.77 | 97.8 | 97.77 | 97.8 | 600.0 |
| 2001-03-28 18:00:00 | DIA | ETF | 98.0 | 98.0 | 97.8 | 98.0 | 400.0 |
> showing 37 of 216 rows — these rows as CSV