PREVIEW / etf_1hour / 2001-10-15
file: by_date/etf_1hour/2001/2001-10-15.parquet size: 12 KB rows: 253
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-10-15 09:00:00 | SPY | ETF | 108.63 | 108.87 | 108.17 | 108.3 | 1792300.0 |
| 2001-10-15 10:00:00 | SPY | ETF | 108.35 | 108.76 | 108.13 | 108.34 | 2329500.0 |
| 2001-10-15 11:00:00 | SPY | ETF | 108.27 | 108.86 | 108.06 | 108.5 | 2540600.0 |
| 2001-10-15 12:00:00 | SPY | ETF | 108.55 | 108.57 | 108.2 | 108.31 | 1433700.0 |
| 2001-10-15 13:00:00 | SPY | ETF | 108.3 | 109.16 | 108.23 | 109.09 | 1885000.0 |
| 2001-10-15 14:00:00 | SPY | ETF | 109.16 | 109.45 | 108.82 | 108.92 | 2690500.0 |
| 2001-10-15 15:00:00 | SPY | ETF | 108.91 | 109.43 | 108.85 | 109.34 | 2023500.0 |
| 2001-10-15 16:00:00 | SPY | ETF | 109.3 | 109.45 | 108.26 | 109.16 | 1371300.0 |
| 2001-10-15 17:00:00 | SPY | ETF | 109.16 | 109.34 | 109.0 | 109.0 | 5100.0 |
| 2001-10-15 09:00:00 | QQQ | ETF | 34.12 | 34.3 | 33.66 | 33.81 | 12453800.0 |
| 2001-10-15 10:00:00 | QQQ | ETF | 33.81 | 34.2 | 33.72 | 33.93 | 13375900.0 |
| 2001-10-15 11:00:00 | QQQ | ETF | 33.91 | 34.35 | 33.81 | 34.06 | 9402200.0 |
| 2001-10-15 12:00:00 | QQQ | ETF | 34.06 | 34.15 | 33.77 | 33.88 | 5229600.0 |
| 2001-10-15 13:00:00 | QQQ | ETF | 33.85 | 34.37 | 33.83 | 34.35 | 10012000.0 |
| 2001-10-15 14:00:00 | QQQ | ETF | 34.33 | 34.55 | 34.11 | 34.19 | 13230600.0 |
| 2001-10-15 15:00:00 | QQQ | ETF | 34.17 | 34.52 | 34.15 | 34.32 | 10105600.0 |
| 2001-10-15 16:00:00 | QQQ | ETF | 34.34 | 34.5 | 33.95 | 34.25 | 991500.0 |
| 2001-10-15 17:00:00 | QQQ | ETF | 34.26 | 34.4 | 34.2 | 34.22 | 353300.0 |
| 2001-10-15 18:00:00 | QQQ | ETF | 34.21 | 34.4 | 34.21 | 34.33 | 27700.0 |
| 2001-10-15 09:00:00 | IWM | ETF | 42.375 | 42.375 | 42.15 | 42.19 | 139200.0 |
| 2001-10-15 10:00:00 | IWM | ETF | 42.205 | 42.455 | 42.2 | 42.455 | 33000.0 |
| 2001-10-15 11:00:00 | IWM | ETF | 42.405 | 42.6 | 42.405 | 42.51 | 8000.0 |
| 2001-10-15 12:00:00 | IWM | ETF | 42.435 | 42.455 | 42.35 | 42.39 | 64600.0 |
| 2001-10-15 13:00:00 | IWM | ETF | 42.39 | 42.65 | 42.37 | 42.65 | 9400.0 |
| 2001-10-15 14:00:00 | IWM | ETF | 42.635 | 42.73 | 42.525 | 42.545 | 95800.0 |
| 2001-10-15 15:00:00 | IWM | ETF | 42.585 | 42.785 | 42.585 | 42.7 | 102000.0 |
| 2001-10-15 16:00:00 | IWM | ETF | 42.76 | 42.76 | 42.7 | 42.7 | 119000.0 |
| 2001-10-15 09:00:00 | DIA | ETF | 93.0 | 93.05 | 92.56 | 92.7 | 407700.0 |
| 2001-10-15 10:00:00 | DIA | ETF | 92.79 | 92.95 | 92.5 | 92.65 | 452000.0 |
| 2001-10-15 11:00:00 | DIA | ETF | 92.69 | 93.05 | 92.47 | 92.85 | 339900.0 |
| 2001-10-15 12:00:00 | DIA | ETF | 92.77 | 92.91 | 92.65 | 92.75 | 251400.0 |
| 2001-10-15 13:00:00 | DIA | ETF | 92.74 | 93.4 | 92.67 | 93.31 | 570000.0 |
| 2001-10-15 14:00:00 | DIA | ETF | 93.45 | 93.7 | 93.25 | 93.28 | 1043600.0 |
| 2001-10-15 15:00:00 | DIA | ETF | 93.28 | 93.67 | 93.25 | 93.53 | 545700.0 |
| 2001-10-15 16:00:00 | DIA | ETF | 93.55 | 94.0 | 93.53 | 94.0 | 48100.0 |
> showing 35 of 253 rows — these rows as CSV