PREVIEW / etf_1hour / 2002-01-25
file: by_date/etf_1hour/2002/2002-01-25.parquet size: 13 KB rows: 271
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-01-25 09:00:00 | SPY | ETF | 113.12 | 113.46 | 113.04 | 113.46 | 1942100.0 |
| 2002-01-25 10:00:00 | SPY | ETF | 113.42 | 113.86 | 113.24 | 113.79 | 2609100.0 |
| 2002-01-25 11:00:00 | SPY | ETF | 113.77 | 113.85 | 113.41 | 113.45 | 1298000.0 |
| 2002-01-25 12:00:00 | SPY | ETF | 113.44 | 114.18 | 113.43 | 114.0 | 1155500.0 |
| 2002-01-25 13:00:00 | SPY | ETF | 114.0 | 114.17 | 113.9 | 113.92 | 1094900.0 |
| 2002-01-25 14:00:00 | SPY | ETF | 113.95 | 114.03 | 113.62 | 113.69 | 1539900.0 |
| 2002-01-25 15:00:00 | SPY | ETF | 113.73 | 113.88 | 113.5 | 113.59 | 1624500.0 |
| 2002-01-25 16:00:00 | SPY | ETF | 113.52 | 113.59 | 113.47 | 113.55 | 1471400.0 |
| 2002-01-25 09:00:00 | QQQ | ETF | 38.47 | 38.61 | 38.36 | 38.54 | 10002500.0 |
| 2002-01-25 10:00:00 | QQQ | ETF | 38.56 | 38.75 | 38.46 | 38.65 | 12982100.0 |
| 2002-01-25 11:00:00 | QQQ | ETF | 38.64 | 38.72 | 38.42 | 38.49 | 5114700.0 |
| 2002-01-25 12:00:00 | QQQ | ETF | 38.49 | 39.09 | 38.46 | 39.04 | 9529800.0 |
| 2002-01-25 13:00:00 | QQQ | ETF | 39.03 | 39.15 | 38.9 | 38.99 | 5057700.0 |
| 2002-01-25 14:00:00 | QQQ | ETF | 38.97 | 39.09 | 38.72 | 38.86 | 6067300.0 |
| 2002-01-25 15:00:00 | QQQ | ETF | 38.87 | 38.99 | 38.65 | 38.8 | 7255100.0 |
| 2002-01-25 16:00:00 | QQQ | ETF | 38.77 | 38.86 | 38.7 | 38.8 | 1341100.0 |
| 2002-01-25 17:00:00 | QQQ | ETF | 38.8 | 38.81 | 38.8 | 38.8 | 4200.0 |
| 2002-01-25 18:00:00 | QQQ | ETF | 38.85 | 38.85 | 38.81 | 38.85 | 5800.0 |
| 2002-01-25 09:00:00 | IWM | ETF | 47.675 | 47.675 | 47.33 | 47.49 | 64200.0 |
| 2002-01-25 10:00:00 | IWM | ETF | 47.49 | 47.6 | 47.45 | 47.57 | 29400.0 |
| 2002-01-25 11:00:00 | IWM | ETF | 47.605 | 47.625 | 47.5 | 47.575 | 260600.0 |
| 2002-01-25 12:00:00 | IWM | ETF | 47.575 | 47.745 | 47.51 | 47.745 | 40800.0 |
| 2002-01-25 13:00:00 | IWM | ETF | 47.745 | 47.785 | 47.66 | 47.755 | 66200.0 |
| 2002-01-25 14:00:00 | IWM | ETF | 47.755 | 47.755 | 47.61 | 47.7 | 78200.0 |
| 2002-01-25 15:00:00 | IWM | ETF | 47.68 | 47.725 | 47.5 | 47.685 | 140800.0 |
| 2002-01-25 16:00:00 | IWM | ETF | 47.7 | 47.7 | 47.64 | 47.64 | 5800.0 |
| 2002-01-25 17:00:00 | IWM | ETF | 47.64 | 47.64 | 47.64 | 47.64 | 80000.0 |
| 2002-01-25 09:00:00 | DIA | ETF | 97.66 | 98.16 | 97.57 | 98.15 | 171800.0 |
| 2002-01-25 10:00:00 | DIA | ETF | 98.17 | 98.64 | 97.96 | 98.63 | 340300.0 |
| 2002-01-25 11:00:00 | DIA | ETF | 98.63 | 98.74 | 98.42 | 98.45 | 213800.0 |
| 2002-01-25 12:00:00 | DIA | ETF | 98.45 | 99.06 | 98.45 | 98.92 | 407800.0 |
| 2002-01-25 13:00:00 | DIA | ETF | 98.97 | 99.04 | 98.74 | 98.8 | 450200.0 |
| 2002-01-25 14:00:00 | DIA | ETF | 98.75 | 98.82 | 98.51 | 98.54 | 926500.0 |
| 2002-01-25 15:00:00 | DIA | ETF | 98.55 | 98.7 | 98.38 | 98.44 | 536500.0 |
| 2002-01-25 16:00:00 | DIA | ETF | 98.42 | 98.48 | 98.38 | 98.48 | 213400.0 |
> showing 35 of 271 rows — these rows as CSV