PREVIEW / etf_1hour / 2002-09-10
file: by_date/etf_1hour/2002/2002-09-10.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-09-10 09:00:00 | SPY | ETF | 91.14 | 91.2 | 90.62 | 90.69 | 4451200.0 |
| 2002-09-10 10:00:00 | SPY | ETF | 90.72 | 91.61 | 90.69 | 91.42 | 7973600.0 |
| 2002-09-10 11:00:00 | SPY | ETF | 91.41 | 91.49 | 90.92 | 91.0 | 3581800.0 |
| 2002-09-10 12:00:00 | SPY | ETF | 90.96 | 91.13 | 90.66 | 91.1 | 3622500.0 |
| 2002-09-10 13:00:00 | SPY | ETF | 91.09 | 91.23 | 90.8 | 90.91 | 3273200.0 |
| 2002-09-10 14:00:00 | SPY | ETF | 90.91 | 91.4 | 90.56 | 91.21 | 7417500.0 |
| 2002-09-10 15:00:00 | SPY | ETF | 91.23 | 91.59 | 91.05 | 91.55 | 4846600.0 |
| 2002-09-10 16:00:00 | SPY | ETF | 91.51 | 91.78 | 91.48 | 91.7 | 1155700.0 |
| 2002-09-10 09:00:00 | QQQ | ETF | 23.23 | 23.38 | 23.1 | 23.23 | 9766100.0 |
| 2002-09-10 10:00:00 | QQQ | ETF | 23.22 | 23.67 | 23.2 | 23.63 | 12556500.0 |
| 2002-09-10 11:00:00 | QQQ | ETF | 23.63 | 23.63 | 23.2 | 23.24 | 9487000.0 |
| 2002-09-10 12:00:00 | QQQ | ETF | 23.24 | 23.4 | 23.15 | 23.4 | 6802400.0 |
| 2002-09-10 13:00:00 | QQQ | ETF | 23.37 | 23.42 | 23.2 | 23.31 | 5140700.0 |
| 2002-09-10 14:00:00 | QQQ | ETF | 23.31 | 23.47 | 23.1 | 23.4 | 12027500.0 |
| 2002-09-10 15:00:00 | QQQ | ETF | 23.4 | 23.57 | 23.3 | 23.54 | 11903600.0 |
| 2002-09-10 16:00:00 | QQQ | ETF | 23.54 | 23.65 | 23.53 | 23.65 | 1493000.0 |
| 2002-09-10 09:00:00 | IWM | ETF | 39.325 | 39.325 | 39.075 | 39.075 | 90400.0 |
| 2002-09-10 10:00:00 | IWM | ETF | 39.1 | 39.445 | 39.1 | 39.39 | 224200.0 |
| 2002-09-10 11:00:00 | IWM | ETF | 39.375 | 39.375 | 39.075 | 39.09 | 260800.0 |
| 2002-09-10 12:00:00 | IWM | ETF | 39.065 | 39.135 | 39.005 | 39.075 | 36800.0 |
| 2002-09-10 13:00:00 | IWM | ETF | 39.135 | 39.135 | 38.875 | 38.995 | 32200.0 |
| 2002-09-10 14:00:00 | IWM | ETF | 38.915 | 39.245 | 38.795 | 39.14 | 383200.0 |
| 2002-09-10 15:00:00 | IWM | ETF | 39.17 | 39.395 | 39.04 | 39.395 | 460800.0 |
| 2002-09-10 16:00:00 | IWM | ETF | 39.395 | 39.395 | 39.275 | 39.275 | 45400.0 |
| 2002-09-10 09:00:00 | DIA | ETF | 85.77 | 85.78 | 85.18 | 85.31 | 1182200.0 |
| 2002-09-10 10:00:00 | DIA | ETF | 85.29 | 86.15 | 85.23 | 85.95 | 1637800.0 |
| 2002-09-10 11:00:00 | DIA | ETF | 85.96 | 86.05 | 85.54 | 85.59 | 1136000.0 |
| 2002-09-10 12:00:00 | DIA | ETF | 85.59 | 85.69 | 85.21 | 85.63 | 938800.0 |
| 2002-09-10 13:00:00 | DIA | ETF | 85.67 | 85.79 | 85.38 | 85.5 | 932900.0 |
| 2002-09-10 14:00:00 | DIA | ETF | 85.49 | 86.1 | 85.18 | 85.93 | 1563700.0 |
| 2002-09-10 15:00:00 | DIA | ETF | 85.91 | 86.25 | 85.7 | 86.24 | 1089500.0 |
| 2002-09-10 16:00:00 | DIA | ETF | 86.25 | 86.5 | 86.15 | 86.49 | 155900.0 |
| 2002-09-10 09:00:00 | TLT | ETF | 87.17 | 87.17 | 87.0 | 87.14 | 6100.0 |
| 2002-09-10 10:00:00 | TLT | ETF | 87.1 | 87.15 | 87.02 | 87.04 | 800.0 |
| 2002-09-10 11:00:00 | TLT | ETF | 87.36 | 87.39 | 87.3 | 87.39 | 3600.0 |
| 2002-09-10 12:00:00 | TLT | ETF | 87.59 | 87.86 | 87.59 | 87.61 | 205600.0 |
| 2002-09-10 13:00:00 | TLT | ETF | 87.61 | 87.9 | 87.61 | 87.75 | 11000.0 |
| 2002-09-10 14:00:00 | TLT | ETF | 87.9 | 88.0 | 87.9 | 87.9 | 3000.0 |
| 2002-09-10 15:00:00 | TLT | ETF | 87.76 | 87.8 | 87.74 | 87.76 | 103800.0 |
| 2002-09-10 16:00:00 | TLT | ETF | 87.75 | 87.75 | 87.75 | 87.75 | 1800.0 |
> showing 40 of 336 rows — these rows as CSV