PREVIEW / etf_1hour / 2001-08-13
file: by_date/etf_1hour/2001/2001-08-13.parquet size: 11 KB rows: 222
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-08-13 09:00:00 | SPY | ETF | 119.6 | 119.73 | 119.11 | 119.38 | 1124600.0 |
| 2001-08-13 10:00:00 | SPY | ETF | 119.42 | 119.72 | 118.95 | 119.11 | 1251300.0 |
| 2001-08-13 11:00:00 | SPY | ETF | 119.13 | 119.43 | 119.0 | 119.21 | 804800.0 |
| 2001-08-13 12:00:00 | SPY | ETF | 119.23 | 119.35 | 118.81 | 118.91 | 342300.0 |
| 2001-08-13 13:00:00 | SPY | ETF | 118.91 | 119.54 | 118.91 | 119.48 | 550600.0 |
| 2001-08-13 14:00:00 | SPY | ETF | 119.55 | 119.63 | 119.26 | 119.61 | 778700.0 |
| 2001-08-13 15:00:00 | SPY | ETF | 119.61 | 119.85 | 119.4 | 119.49 | 1812200.0 |
| 2001-08-13 16:00:00 | SPY | ETF | 119.48 | 119.52 | 118.38 | 119.35 | 392300.0 |
| 2001-08-13 17:00:00 | SPY | ETF | 119.25 | 119.33 | 119.25 | 119.33 | 3800.0 |
| 2001-08-13 09:00:00 | QQQ | ETF | 40.59 | 40.71 | 40.3 | 40.5 | 5855600.0 |
| 2001-08-13 10:00:00 | QQQ | ETF | 40.5 | 40.79 | 40.2 | 40.34 | 9689200.0 |
| 2001-08-13 11:00:00 | QQQ | ETF | 40.35 | 40.55 | 40.25 | 40.38 | 4765500.0 |
| 2001-08-13 12:00:00 | QQQ | ETF | 40.41 | 40.53 | 40.31 | 40.35 | 2448300.0 |
| 2001-08-13 13:00:00 | QQQ | ETF | 40.35 | 40.85 | 40.32 | 40.81 | 5028600.0 |
| 2001-08-13 14:00:00 | QQQ | ETF | 40.81 | 41.13 | 40.75 | 41.09 | 7197900.0 |
| 2001-08-13 15:00:00 | QQQ | ETF | 41.08 | 41.34 | 41.02 | 41.23 | 10458100.0 |
| 2001-08-13 16:00:00 | QQQ | ETF | 41.23 | 41.25 | 40.93 | 41.08 | 739400.0 |
| 2001-08-13 17:00:00 | QQQ | ETF | 41.06 | 41.19 | 41.06 | 41.11 | 25400.0 |
| 2001-08-13 18:00:00 | QQQ | ETF | 41.16 | 41.18 | 41.1 | 41.15 | 4800.0 |
| 2001-08-13 09:00:00 | IWM | ETF | 47.575 | 47.575 | 47.375 | 47.375 | 19400.0 |
| 2001-08-13 10:00:00 | IWM | ETF | 47.35 | 47.545 | 47.305 | 47.445 | 14000.0 |
| 2001-08-13 11:00:00 | IWM | ETF | 47.415 | 47.415 | 47.355 | 47.395 | 52000.0 |
| 2001-08-13 12:00:00 | IWM | ETF | 47.395 | 47.395 | 47.375 | 47.375 | 2200.0 |
| 2001-08-13 13:00:00 | IWM | ETF | 47.39 | 47.64 | 47.39 | 47.64 | 456600.0 |
| 2001-08-13 14:00:00 | IWM | ETF | 47.56 | 47.725 | 47.53 | 47.725 | 503800.0 |
| 2001-08-13 15:00:00 | IWM | ETF | 47.73 | 47.81 | 47.7 | 47.7 | 555200.0 |
| 2001-08-13 16:00:00 | IWM | ETF | 47.65 | 47.7 | 47.65 | 47.7 | 5000.0 |
| 2001-08-13 09:00:00 | DIA | ETF | 104.2 | 104.42 | 103.96 | 104.2 | 380000.0 |
| 2001-08-13 10:00:00 | DIA | ETF | 104.22 | 104.48 | 103.83 | 103.9 | 421600.0 |
| 2001-08-13 11:00:00 | DIA | ETF | 103.92 | 104.17 | 103.83 | 103.96 | 292200.0 |
| 2001-08-13 12:00:00 | DIA | ETF | 103.95 | 104.07 | 103.75 | 103.77 | 118800.0 |
| 2001-08-13 13:00:00 | DIA | ETF | 103.82 | 104.26 | 103.81 | 104.25 | 600300.0 |
| 2001-08-13 14:00:00 | DIA | ETF | 104.25 | 104.39 | 104.07 | 104.39 | 306200.0 |
| 2001-08-13 15:00:00 | DIA | ETF | 104.38 | 104.55 | 104.15 | 104.23 | 498800.0 |
| 2001-08-13 16:00:00 | DIA | ETF | 104.2 | 104.24 | 104.14 | 104.19 | 74100.0 |
> showing 35 of 222 rows — these rows as CSV