PREVIEW / etf_1hour / 2002-04-15
file: by_date/etf_1hour/2002/2002-04-15.parquet size: 13 KB rows: 289
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-04-15 09:00:00 | SPY | ETF | 111.62 | 111.86 | 111.29 | 111.35 | 2683100.0 |
| 2002-04-15 10:00:00 | SPY | ETF | 111.34 | 111.5 | 110.65 | 110.68 | 3039000.0 |
| 2002-04-15 11:00:00 | SPY | ETF | 110.63 | 110.9 | 110.2 | 110.44 | 3238200.0 |
| 2002-04-15 12:00:00 | SPY | ETF | 110.48 | 111.02 | 110.36 | 110.89 | 1603400.0 |
| 2002-04-15 13:00:00 | SPY | ETF | 110.89 | 111.23 | 110.87 | 111.16 | 1580700.0 |
| 2002-04-15 14:00:00 | SPY | ETF | 111.14 | 111.29 | 110.72 | 110.8 | 1158400.0 |
| 2002-04-15 15:00:00 | SPY | ETF | 110.78 | 110.97 | 110.52 | 110.63 | 1625800.0 |
| 2002-04-15 16:00:00 | SPY | ETF | 110.6 | 110.73 | 110.43 | 110.73 | 1281500.0 |
| 2002-04-15 17:00:00 | SPY | ETF | 110.8 | 111.0 | 110.8 | 110.98 | 33800.0 |
| 2002-04-15 18:00:00 | SPY | ETF | 110.98 | 111.0 | 110.9 | 110.9 | 2000.0 |
| 2002-04-15 09:00:00 | QQQ | ETF | 33.8 | 33.9 | 33.56 | 33.72 | 9846800.0 |
| 2002-04-15 10:00:00 | QQQ | ETF | 33.72 | 33.96 | 33.6 | 33.61 | 14806800.0 |
| 2002-04-15 11:00:00 | QQQ | ETF | 33.61 | 33.72 | 33.2 | 33.43 | 10614600.0 |
| 2002-04-15 12:00:00 | QQQ | ETF | 33.43 | 33.79 | 33.37 | 33.69 | 8396300.0 |
| 2002-04-15 13:00:00 | QQQ | ETF | 33.66 | 33.85 | 33.61 | 33.82 | 5343200.0 |
| 2002-04-15 14:00:00 | QQQ | ETF | 33.82 | 33.94 | 33.65 | 33.7 | 8320300.0 |
| 2002-04-15 15:00:00 | QQQ | ETF | 33.7 | 33.87 | 33.61 | 33.78 | 5907100.0 |
| 2002-04-15 16:00:00 | QQQ | ETF | 33.77 | 33.95 | 33.65 | 33.95 | 3039700.0 |
| 2002-04-15 17:00:00 | QQQ | ETF | 33.96 | 34.13 | 33.77 | 34.12 | 1158400.0 |
| 2002-04-15 18:00:00 | QQQ | ETF | 34.08 | 34.11 | 34.07 | 34.11 | 16400.0 |
| 2002-04-15 09:00:00 | IWM | ETF | 51.5 | 51.625 | 51.165 | 51.225 | 1625600.0 |
| 2002-04-15 10:00:00 | IWM | ETF | 51.13 | 51.185 | 50.925 | 50.925 | 297800.0 |
| 2002-04-15 11:00:00 | IWM | ETF | 50.905 | 50.96 | 50.79 | 50.855 | 160400.0 |
| 2002-04-15 12:00:00 | IWM | ETF | 50.855 | 51.14 | 50.85 | 51.14 | 134600.0 |
| 2002-04-15 13:00:00 | IWM | ETF | 51.1 | 51.14 | 51.04 | 51.13 | 70200.0 |
| 2002-04-15 14:00:00 | IWM | ETF | 51.14 | 51.175 | 50.99 | 51.0 | 346400.0 |
| 2002-04-15 15:00:00 | IWM | ETF | 50.98 | 51.045 | 50.86 | 50.87 | 191800.0 |
| 2002-04-15 16:00:00 | IWM | ETF | 50.975 | 50.975 | 50.875 | 50.875 | 4600.0 |
| 2002-04-15 09:00:00 | DIA | ETF | 102.22 | 102.44 | 101.85 | 101.86 | 1697700.0 |
| 2002-04-15 10:00:00 | DIA | ETF | 101.9 | 101.97 | 101.25 | 101.25 | 490600.0 |
| 2002-04-15 11:00:00 | DIA | ETF | 101.25 | 101.48 | 100.75 | 100.97 | 605300.0 |
| 2002-04-15 12:00:00 | DIA | ETF | 100.95 | 101.5 | 100.87 | 101.43 | 406200.0 |
| 2002-04-15 13:00:00 | DIA | ETF | 101.44 | 101.74 | 101.38 | 101.63 | 313100.0 |
| 2002-04-15 14:00:00 | DIA | ETF | 101.66 | 101.74 | 101.12 | 101.15 | 194400.0 |
| 2002-04-15 15:00:00 | DIA | ETF | 101.2 | 101.39 | 100.99 | 101.06 | 1151500.0 |
| 2002-04-15 16:00:00 | DIA | ETF | 101.08 | 101.15 | 100.94 | 101.02 | 172000.0 |
> showing 36 of 289 rows — these rows as CSV