PREVIEW / etf_1hour / 2002-09-12
file: by_date/etf_1hour/2002/2002-09-12.parquet size: 14 KB rows: 325
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-09-12 09:00:00 | SPY | ETF | 90.75 | 90.84 | 90.18 | 90.42 | 4971300.0 |
| 2002-09-12 10:00:00 | SPY | ETF | 90.29 | 90.53 | 89.84 | 89.91 | 6970800.0 |
| 2002-09-12 11:00:00 | SPY | ETF | 89.96 | 90.38 | 89.91 | 90.33 | 3902400.0 |
| 2002-09-12 12:00:00 | SPY | ETF | 90.37 | 90.4 | 89.75 | 89.87 | 5329100.0 |
| 2002-09-12 13:00:00 | SPY | ETF | 89.87 | 90.15 | 89.77 | 90.08 | 2417700.0 |
| 2002-09-12 14:00:00 | SPY | ETF | 90.09 | 90.1 | 89.22 | 89.25 | 6786600.0 |
| 2002-09-12 15:00:00 | SPY | ETF | 89.25 | 89.49 | 88.99 | 89.26 | 10020000.0 |
| 2002-09-12 16:00:00 | SPY | ETF | 89.26 | 89.48 | 89.19 | 89.45 | 887200.0 |
| 2002-09-12 09:00:00 | QQQ | ETF | 23.23 | 23.26 | 23.02 | 23.14 | 9800700.0 |
| 2002-09-12 10:00:00 | QQQ | ETF | 23.14 | 23.17 | 22.9 | 22.96 | 11411600.0 |
| 2002-09-12 11:00:00 | QQQ | ETF | 22.96 | 23.2 | 22.95 | 23.18 | 10067600.0 |
| 2002-09-12 12:00:00 | QQQ | ETF | 23.16 | 23.22 | 22.95 | 23.03 | 7752400.0 |
| 2002-09-12 13:00:00 | QQQ | ETF | 23.03 | 23.15 | 22.95 | 23.05 | 5015600.0 |
| 2002-09-12 14:00:00 | QQQ | ETF | 23.05 | 23.08 | 22.75 | 22.78 | 10594600.0 |
| 2002-09-12 15:00:00 | QQQ | ETF | 22.78 | 22.9 | 22.71 | 22.79 | 11959400.0 |
| 2002-09-12 16:00:00 | QQQ | ETF | 22.8 | 22.83 | 22.76 | 22.81 | 782600.0 |
| 2002-09-12 09:00:00 | IWM | ETF | 39.0 | 39.17 | 38.8 | 38.95 | 305000.0 |
| 2002-09-12 10:00:00 | IWM | ETF | 38.825 | 38.95 | 38.615 | 38.67 | 193400.0 |
| 2002-09-12 11:00:00 | IWM | ETF | 38.6 | 38.75 | 38.585 | 38.69 | 77600.0 |
| 2002-09-12 12:00:00 | IWM | ETF | 38.745 | 38.755 | 38.585 | 38.585 | 36400.0 |
| 2002-09-12 13:00:00 | IWM | ETF | 38.605 | 38.75 | 38.605 | 38.685 | 32800.0 |
| 2002-09-12 14:00:00 | IWM | ETF | 38.685 | 38.69 | 38.505 | 38.505 | 75400.0 |
| 2002-09-12 15:00:00 | IWM | ETF | 38.51 | 38.65 | 38.485 | 38.57 | 740600.0 |
| 2002-09-12 16:00:00 | IWM | ETF | 38.6 | 38.625 | 38.5 | 38.5 | 150000.0 |
| 2002-09-12 09:00:00 | DIA | ETF | 85.32 | 85.42 | 84.8 | 85.01 | 1027700.0 |
| 2002-09-12 10:00:00 | DIA | ETF | 85.02 | 85.1 | 84.4 | 84.46 | 1442100.0 |
| 2002-09-12 11:00:00 | DIA | ETF | 84.5 | 85.01 | 84.45 | 84.93 | 753900.0 |
| 2002-09-12 12:00:00 | DIA | ETF | 84.93 | 84.98 | 84.5 | 84.63 | 606200.0 |
| 2002-09-12 13:00:00 | DIA | ETF | 84.62 | 84.84 | 84.45 | 84.75 | 538600.0 |
| 2002-09-12 14:00:00 | DIA | ETF | 84.76 | 84.8 | 83.9 | 83.94 | 1097200.0 |
| 2002-09-12 15:00:00 | DIA | ETF | 83.95 | 84.24 | 83.74 | 83.95 | 1377900.0 |
| 2002-09-12 16:00:00 | DIA | ETF | 83.95 | 84.16 | 83.91 | 84.14 | 98400.0 |
| 2002-09-12 09:00:00 | TLT | ETF | 87.48 | 87.61 | 87.47 | 87.61 | 2600.0 |
| 2002-09-12 10:00:00 | TLT | ETF | 87.57 | 87.8 | 87.57 | 87.67 | 8800.0 |
| 2002-09-12 11:00:00 | TLT | ETF | 87.98 | 87.98 | 87.8 | 87.8 | 3500.0 |
| 2002-09-12 12:00:00 | TLT | ETF | 87.8 | 88.02 | 87.8 | 87.98 | 3700.0 |
| 2002-09-12 13:00:00 | TLT | ETF | 87.9 | 88.01 | 87.88 | 87.93 | 5700.0 |
| 2002-09-12 14:00:00 | TLT | ETF | 87.84 | 88.14 | 87.84 | 88.09 | 15600.0 |
| 2002-09-12 15:00:00 | TLT | ETF | 88.03 | 88.04 | 87.94 | 87.97 | 3500.0 |
> showing 39 of 325 rows — these rows as CSV