PREVIEW / etf_1hour / 2001-03-07
file: by_date/etf_1hour/2001/2001-03-07.parquet size: 11 KB rows: 218
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-07 09:00:00 | SPY | ETF | 126.9 | 126.9 | 126.2 | 126.3 | 1266300.0 |
| 2001-03-07 10:00:00 | SPY | ETF | 126.3 | 126.89 | 125.85 | 126.15 | 1357500.0 |
| 2001-03-07 11:00:00 | SPY | ETF | 126.16 | 126.42 | 125.81 | 125.86 | 509000.0 |
| 2001-03-07 12:00:00 | SPY | ETF | 125.88 | 126.7 | 125.78 | 126.42 | 366600.0 |
| 2001-03-07 13:00:00 | SPY | ETF | 126.38 | 126.74 | 126.25 | 126.55 | 631500.0 |
| 2001-03-07 14:00:00 | SPY | ETF | 126.58 | 126.59 | 125.76 | 126.41 | 576400.0 |
| 2001-03-07 15:00:00 | SPY | ETF | 126.4 | 126.74 | 126.01 | 126.64 | 1076200.0 |
| 2001-03-07 16:00:00 | SPY | ETF | 126.51 | 127.04 | 126.51 | 126.95 | 487100.0 |
| 2001-03-07 09:00:00 | QQQ | ETF | 50.4 | 50.43 | 49.45 | 49.55 | 9184900.0 |
| 2001-03-07 10:00:00 | QQQ | ETF | 49.53 | 50.12 | 49.0 | 49.48 | 9207300.0 |
| 2001-03-07 11:00:00 | QQQ | ETF | 49.45 | 49.7 | 49.04 | 49.05 | 5905800.0 |
| 2001-03-07 12:00:00 | QQQ | ETF | 49.04 | 50.0 | 48.97 | 49.83 | 8988900.0 |
| 2001-03-07 13:00:00 | QQQ | ETF | 49.8 | 50.3 | 49.75 | 50.18 | 6508400.0 |
| 2001-03-07 14:00:00 | QQQ | ETF | 50.18 | 50.24 | 49.45 | 49.85 | 5364300.0 |
| 2001-03-07 15:00:00 | QQQ | ETF | 49.9 | 50.14 | 49.54 | 49.72 | 6677500.0 |
| 2001-03-07 16:00:00 | QQQ | ETF | 49.7 | 49.76 | 49.4 | 49.42 | 1541400.0 |
| 2001-03-07 17:00:00 | QQQ | ETF | 49.5 | 49.8 | 49.4 | 49.6 | 44800.0 |
| 2001-03-07 18:00:00 | QQQ | ETF | 49.6 | 49.8 | 49.45 | 49.5 | 28400.0 |
| 2001-03-07 09:00:00 | IWM | ETF | 48.4 | 48.575 | 48.2 | 48.45 | 41800.0 |
| 2001-03-07 10:00:00 | IWM | ETF | 48.275 | 48.6 | 48.125 | 48.33 | 132200.0 |
| 2001-03-07 11:00:00 | IWM | ETF | 48.445 | 48.445 | 48.125 | 48.125 | 3800.0 |
| 2001-03-07 12:00:00 | IWM | ETF | 48.125 | 48.475 | 48.125 | 48.475 | 12200.0 |
| 2001-03-07 13:00:00 | IWM | ETF | 48.275 | 48.5 | 48.275 | 48.425 | 97000.0 |
| 2001-03-07 14:00:00 | IWM | ETF | 48.375 | 48.55 | 48.28 | 48.525 | 15400.0 |
| 2001-03-07 15:00:00 | IWM | ETF | 48.35 | 48.575 | 48.25 | 48.375 | 70000.0 |
| 2001-03-07 16:00:00 | IWM | ETF | 48.3 | 48.3 | 48.3 | 48.3 | 600.0 |
| 2001-03-07 09:00:00 | DIA | ETF | 106.8 | 106.95 | 106.4 | 106.89 | 165200.0 |
| 2001-03-07 10:00:00 | DIA | ETF | 106.75 | 107.17 | 106.5 | 106.72 | 428900.0 |
| 2001-03-07 11:00:00 | DIA | ETF | 106.69 | 106.9 | 106.3 | 106.62 | 371100.0 |
| 2001-03-07 12:00:00 | DIA | ETF | 106.71 | 107.0 | 106.51 | 106.88 | 408400.0 |
| 2001-03-07 13:00:00 | DIA | ETF | 106.8 | 107.13 | 106.8 | 107.02 | 249100.0 |
| 2001-03-07 14:00:00 | DIA | ETF | 107.06 | 107.15 | 106.69 | 107.14 | 193000.0 |
| 2001-03-07 15:00:00 | DIA | ETF | 107.07 | 107.53 | 106.85 | 107.39 | 670400.0 |
| 2001-03-07 16:00:00 | DIA | ETF | 107.4 | 107.6 | 107.32 | 107.45 | 67300.0 |
> showing 34 of 218 rows — these rows as CSV