PREVIEW / etf_1hour / 2002-08-15
file: by_date/etf_1hour/2002/2002-08-15.parquet size: 15 KB rows: 336
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 |
|---|---|---|---|---|---|---|---|
| 2002-08-15 09:00:00 | SPY | ETF | 92.84 | 93.3 | 92.54 | 92.65 | 5191700.0 |
| 2002-08-15 10:00:00 | SPY | ETF | 92.67 | 93.85 | 92.2 | 93.55 | 8473900.0 |
| 2002-08-15 11:00:00 | SPY | ETF | 93.53 | 93.8 | 92.99 | 93.66 | 4064500.0 |
| 2002-08-15 12:00:00 | SPY | ETF | 93.67 | 93.99 | 92.65 | 92.87 | 8476800.0 |
| 2002-08-15 13:00:00 | SPY | ETF | 92.87 | 93.07 | 92.4 | 92.95 | 4255000.0 |
| 2002-08-15 14:00:00 | SPY | ETF | 92.94 | 93.56 | 92.55 | 92.72 | 6487600.0 |
| 2002-08-15 15:00:00 | SPY | ETF | 92.71 | 93.57 | 92.62 | 93.4 | 4895500.0 |
| 2002-08-15 16:00:00 | SPY | ETF | 93.41 | 93.6 | 93.32 | 93.5 | 1051300.0 |
| 2002-08-15 09:00:00 | QQQ | ETF | 24.24 | 24.42 | 23.95 | 24.0 | 16185700.0 |
| 2002-08-15 10:00:00 | QQQ | ETF | 23.94 | 24.5 | 23.84 | 24.45 | 22529500.0 |
| 2002-08-15 11:00:00 | QQQ | ETF | 24.45 | 24.53 | 24.26 | 24.46 | 12695100.0 |
| 2002-08-15 12:00:00 | QQQ | ETF | 24.45 | 24.55 | 24.0 | 24.01 | 17064400.0 |
| 2002-08-15 13:00:00 | QQQ | ETF | 24.03 | 24.1 | 23.72 | 24.1 | 14388100.0 |
| 2002-08-15 14:00:00 | QQQ | ETF | 24.1 | 24.45 | 24.04 | 24.17 | 16559600.0 |
| 2002-08-15 15:00:00 | QQQ | ETF | 24.16 | 24.45 | 24.11 | 24.37 | 12904600.0 |
| 2002-08-15 16:00:00 | QQQ | ETF | 24.33 | 24.53 | 24.3 | 24.53 | 1268900.0 |
| 2002-08-15 09:00:00 | IWM | ETF | 39.15 | 39.15 | 38.775 | 38.845 | 431000.0 |
| 2002-08-15 10:00:00 | IWM | ETF | 38.8 | 39.25 | 38.7 | 39.14 | 534200.0 |
| 2002-08-15 11:00:00 | IWM | ETF | 39.13 | 39.165 | 38.895 | 39.01 | 326000.0 |
| 2002-08-15 12:00:00 | IWM | ETF | 39.115 | 39.125 | 38.775 | 38.8 | 1307800.0 |
| 2002-08-15 13:00:00 | IWM | ETF | 38.8 | 38.84 | 38.695 | 38.8 | 193600.0 |
| 2002-08-15 14:00:00 | IWM | ETF | 38.8 | 39.095 | 38.785 | 38.915 | 268600.0 |
| 2002-08-15 15:00:00 | IWM | ETF | 38.915 | 39.135 | 38.87 | 38.975 | 313000.0 |
| 2002-08-15 16:00:00 | IWM | ETF | 38.825 | 38.88 | 38.825 | 38.88 | 2400.0 |
| 2002-08-15 09:00:00 | DIA | ETF | 88.05 | 88.2 | 87.34 | 87.36 | 1663100.0 |
| 2002-08-15 10:00:00 | DIA | ETF | 87.36 | 88.67 | 87.03 | 88.51 | 3146600.0 |
| 2002-08-15 11:00:00 | DIA | ETF | 88.44 | 88.78 | 87.97 | 88.54 | 1449200.0 |
| 2002-08-15 12:00:00 | DIA | ETF | 88.52 | 88.88 | 87.5 | 87.65 | 2594200.0 |
| 2002-08-15 13:00:00 | DIA | ETF | 87.61 | 87.9 | 87.22 | 87.84 | 1627100.0 |
| 2002-08-15 14:00:00 | DIA | ETF | 87.82 | 88.45 | 87.3 | 87.44 | 2006400.0 |
| 2002-08-15 15:00:00 | DIA | ETF | 87.44 | 88.46 | 87.35 | 88.25 | 1938500.0 |
| 2002-08-15 16:00:00 | DIA | ETF | 88.31 | 88.4 | 88.21 | 88.33 | 116700.0 |
| 2002-08-15 09:00:00 | TLT | ETF | 86.38 | 86.38 | 86.04 | 86.11 | 14900.0 |
| 2002-08-15 10:00:00 | TLT | ETF | 86.24 | 86.36 | 85.85 | 86.1 | 19100.0 |
| 2002-08-15 11:00:00 | TLT | ETF | 86.06 | 86.17 | 86.04 | 86.04 | 6300.0 |
| 2002-08-15 12:00:00 | TLT | ETF | 86.2 | 86.45 | 86.0 | 86.3 | 28400.0 |
| 2002-08-15 13:00:00 | TLT | ETF | 86.4 | 86.5 | 86.35 | 86.35 | 4400.0 |
| 2002-08-15 14:00:00 | TLT | ETF | 86.4 | 86.4 | 86.09 | 86.12 | 9600.0 |
| 2002-08-15 15:00:00 | TLT | ETF | 86.16 | 86.16 | 86.0 | 86.0 | 2700.0 |
| 2002-08-15 16:00:00 | TLT | ETF | 86.0 | 86.02 | 86.0 | 86.02 | 1200.0 |
> showing 40 of 336 rows — these rows as CSV