PREVIEW / etf_1hour / 2001-09-10
file: by_date/etf_1hour/2001/2001-09-10.parquet size: 12 KB rows: 245
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-09-10 09:00:00 | SPY | ETF | 107.7 | 109.09 | 107.7 | 108.82 | 4786600.0 |
| 2001-09-10 10:00:00 | SPY | ETF | 108.86 | 109.78 | 108.48 | 109.75 | 4638700.0 |
| 2001-09-10 11:00:00 | SPY | ETF | 109.7 | 110.25 | 109.42 | 110.0 | 3896700.0 |
| 2001-09-10 12:00:00 | SPY | ETF | 109.98 | 110.35 | 109.7 | 109.7 | 1368800.0 |
| 2001-09-10 13:00:00 | SPY | ETF | 109.74 | 109.8 | 109.2 | 109.5 | 1308500.0 |
| 2001-09-10 14:00:00 | SPY | ETF | 109.55 | 109.88 | 109.18 | 109.4 | 1867700.0 |
| 2001-09-10 15:00:00 | SPY | ETF | 109.41 | 110.0 | 109.1 | 109.83 | 3207200.0 |
| 2001-09-10 16:00:00 | SPY | ETF | 109.8 | 110.1 | 109.53 | 110.05 | 977400.0 |
| 2001-09-10 09:00:00 | QQQ | ETF | 33.49 | 34.1 | 33.34 | 33.95 | 15528000.0 |
| 2001-09-10 10:00:00 | QQQ | ETF | 33.87 | 34.12 | 33.46 | 34.07 | 17092600.0 |
| 2001-09-10 11:00:00 | QQQ | ETF | 34.1 | 34.32 | 33.76 | 34.11 | 9927100.0 |
| 2001-09-10 12:00:00 | QQQ | ETF | 34.08 | 34.28 | 33.8 | 33.82 | 5872900.0 |
| 2001-09-10 13:00:00 | QQQ | ETF | 33.81 | 33.89 | 33.61 | 33.89 | 7431300.0 |
| 2001-09-10 14:00:00 | QQQ | ETF | 33.89 | 34.12 | 33.6 | 33.82 | 7031300.0 |
| 2001-09-10 15:00:00 | QQQ | ETF | 33.83 | 34.14 | 33.59 | 34.0 | 11675200.0 |
| 2001-09-10 16:00:00 | QQQ | ETF | 34.0 | 34.13 | 33.9 | 34.05 | 2005300.0 |
| 2001-09-10 17:00:00 | QQQ | ETF | 34.11 | 34.15 | 34.05 | 34.1 | 120900.0 |
| 2001-09-10 18:00:00 | QQQ | ETF | 34.1 | 34.1 | 34.07 | 34.07 | 4600.0 |
| 2001-09-10 09:00:00 | IWM | ETF | 43.925 | 44.2 | 43.925 | 44.155 | 257400.0 |
| 2001-09-10 10:00:00 | IWM | ETF | 44.13 | 44.225 | 44.02 | 44.2 | 112200.0 |
| 2001-09-10 11:00:00 | IWM | ETF | 44.2 | 44.25 | 44.025 | 44.19 | 1908600.0 |
| 2001-09-10 12:00:00 | IWM | ETF | 44.055 | 44.22 | 44.055 | 44.075 | 249400.0 |
| 2001-09-10 13:00:00 | IWM | ETF | 44.045 | 44.065 | 43.76 | 43.76 | 1703200.0 |
| 2001-09-10 14:00:00 | IWM | ETF | 43.94 | 43.94 | 43.6 | 43.75 | 290800.0 |
| 2001-09-10 15:00:00 | IWM | ETF | 43.67 | 43.82 | 43.55 | 43.75 | 162600.0 |
| 2001-09-10 16:00:00 | IWM | ETF | 43.75 | 43.925 | 43.75 | 43.925 | 65000.0 |
| 2001-09-10 09:00:00 | DIA | ETF | 95.1 | 96.05 | 95.05 | 95.88 | 1302200.0 |
| 2001-09-10 10:00:00 | DIA | ETF | 95.85 | 96.45 | 95.51 | 96.4 | 1367100.0 |
| 2001-09-10 11:00:00 | DIA | ETF | 96.39 | 96.89 | 96.24 | 96.74 | 1373300.0 |
| 2001-09-10 12:00:00 | DIA | ETF | 96.71 | 96.95 | 96.4 | 96.41 | 678600.0 |
| 2001-09-10 13:00:00 | DIA | ETF | 96.42 | 96.48 | 95.8 | 96.09 | 1171800.0 |
| 2001-09-10 14:00:00 | DIA | ETF | 96.17 | 96.5 | 95.82 | 96.06 | 821100.0 |
| 2001-09-10 15:00:00 | DIA | ETF | 96.07 | 96.55 | 95.71 | 96.3 | 1157500.0 |
| 2001-09-10 16:00:00 | DIA | ETF | 96.3 | 96.5 | 96.05 | 96.45 | 120500.0 |
> showing 34 of 245 rows — these rows as CSV