PREVIEW / etf_1hour / 2002-08-21
file: by_date/etf_1hour/2002/2002-08-21.parquet size: 15 KB rows: 350
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-21 09:00:00 | SPY | ETF | 95.06 | 95.48 | 94.82 | 94.89 | 4790400.0 |
| 2002-08-21 10:00:00 | SPY | ETF | 94.94 | 94.96 | 93.75 | 93.85 | 6934100.0 |
| 2002-08-21 11:00:00 | SPY | ETF | 93.81 | 94.5 | 93.57 | 94.46 | 4216100.0 |
| 2002-08-21 12:00:00 | SPY | ETF | 94.46 | 95.2 | 94.43 | 95.07 | 4775000.0 |
| 2002-08-21 13:00:00 | SPY | ETF | 95.07 | 95.4 | 94.78 | 95.24 | 2858800.0 |
| 2002-08-21 14:00:00 | SPY | ETF | 95.24 | 95.75 | 94.18 | 94.47 | 7279400.0 |
| 2002-08-21 15:00:00 | SPY | ETF | 94.46 | 95.55 | 94.25 | 95.5 | 5819100.0 |
| 2002-08-21 16:00:00 | SPY | ETF | 95.4 | 95.78 | 95.28 | 95.75 | 963400.0 |
| 2002-08-21 09:00:00 | QQQ | ETF | 25.39 | 25.63 | 25.35 | 25.46 | 14037800.0 |
| 2002-08-21 10:00:00 | QQQ | ETF | 25.46 | 25.5 | 25.05 | 25.1 | 16545200.0 |
| 2002-08-21 11:00:00 | QQQ | ETF | 25.1 | 25.4 | 25.0 | 25.3 | 8952900.0 |
| 2002-08-21 12:00:00 | QQQ | ETF | 25.29 | 25.59 | 25.28 | 25.55 | 9725300.0 |
| 2002-08-21 13:00:00 | QQQ | ETF | 25.56 | 25.77 | 25.44 | 25.7 | 9688100.0 |
| 2002-08-21 14:00:00 | QQQ | ETF | 25.7 | 25.85 | 25.25 | 25.38 | 18873300.0 |
| 2002-08-21 15:00:00 | QQQ | ETF | 25.38 | 25.76 | 25.32 | 25.7 | 18382200.0 |
| 2002-08-21 16:00:00 | QQQ | ETF | 25.68 | 25.78 | 25.66 | 25.75 | 923300.0 |
| 2002-08-21 09:00:00 | IWM | ETF | 39.945 | 40.225 | 39.945 | 40.1 | 283000.0 |
| 2002-08-21 10:00:00 | IWM | ETF | 40.075 | 40.075 | 39.685 | 39.8 | 366600.0 |
| 2002-08-21 11:00:00 | IWM | ETF | 39.745 | 39.895 | 39.7 | 39.785 | 256200.0 |
| 2002-08-21 12:00:00 | IWM | ETF | 39.865 | 40.305 | 39.865 | 40.305 | 612000.0 |
| 2002-08-21 13:00:00 | IWM | ETF | 40.305 | 40.345 | 40.215 | 40.345 | 34000.0 |
| 2002-08-21 14:00:00 | IWM | ETF | 40.375 | 40.48 | 39.94 | 39.995 | 433400.0 |
| 2002-08-21 15:00:00 | IWM | ETF | 39.975 | 40.65 | 39.91 | 40.64 | 326400.0 |
| 2002-08-21 09:00:00 | DIA | ETF | 89.45 | 89.9 | 89.31 | 89.5 | 1614100.0 |
| 2002-08-21 10:00:00 | DIA | ETF | 89.52 | 89.55 | 88.25 | 88.37 | 2267000.0 |
| 2002-08-21 11:00:00 | DIA | ETF | 88.3 | 88.93 | 88.06 | 88.85 | 1316000.0 |
| 2002-08-21 12:00:00 | DIA | ETF | 88.87 | 89.6 | 88.83 | 89.48 | 1050300.0 |
| 2002-08-21 13:00:00 | DIA | ETF | 89.48 | 89.7 | 89.16 | 89.52 | 1005700.0 |
| 2002-08-21 14:00:00 | DIA | ETF | 89.54 | 90.0 | 88.56 | 88.81 | 2131600.0 |
| 2002-08-21 15:00:00 | DIA | ETF | 88.85 | 89.9 | 88.61 | 89.74 | 2297700.0 |
| 2002-08-21 16:00:00 | DIA | ETF | 89.74 | 89.97 | 89.55 | 89.95 | 150300.0 |
| 2002-08-21 09:00:00 | TLT | ETF | 85.68 | 85.85 | 85.63 | 85.79 | 11800.0 |
| 2002-08-21 10:00:00 | TLT | ETF | 85.74 | 86.01 | 85.74 | 86.01 | 8500.0 |
| 2002-08-21 11:00:00 | TLT | ETF | 86.02 | 86.02 | 85.8 | 85.93 | 3800.0 |
| 2002-08-21 12:00:00 | TLT | ETF | 85.89 | 85.89 | 85.78 | 85.8 | 5000.0 |
| 2002-08-21 13:00:00 | TLT | ETF | 85.85 | 85.91 | 85.76 | 85.9 | 3500.0 |
| 2002-08-21 14:00:00 | TLT | ETF | 85.91 | 86.1 | 85.91 | 86.0 | 5400.0 |
| 2002-08-21 15:00:00 | TLT | ETF | 86.0 | 86.0 | 85.81 | 85.81 | 2000.0 |
> showing 38 of 350 rows — these rows as CSV