PREVIEW / etf_1hour / 2002-08-27
file: by_date/etf_1hour/2002/2002-08-27.parquet size: 15 KB rows: 348
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-27 09:00:00 | SPY | ETF | 95.7 | 96.25 | 95.4 | 95.62 | 4562400.0 |
| 2002-08-27 10:00:00 | SPY | ETF | 95.66 | 95.7 | 94.2 | 94.53 | 9630100.0 |
| 2002-08-27 11:00:00 | SPY | ETF | 94.6 | 95.46 | 94.52 | 95.21 | 4348300.0 |
| 2002-08-27 12:00:00 | SPY | ETF | 95.18 | 95.21 | 94.63 | 94.75 | 2057900.0 |
| 2002-08-27 13:00:00 | SPY | ETF | 94.74 | 94.88 | 94.1 | 94.29 | 3498900.0 |
| 2002-08-27 14:00:00 | SPY | ETF | 94.3 | 94.63 | 93.9 | 94.01 | 3915600.0 |
| 2002-08-27 15:00:00 | SPY | ETF | 94.01 | 94.22 | 93.5 | 93.9 | 5325500.0 |
| 2002-08-27 16:00:00 | SPY | ETF | 93.89 | 94.16 | 93.85 | 94.16 | 979500.0 |
| 2002-08-27 09:00:00 | QQQ | ETF | 25.43 | 25.51 | 25.0 | 25.09 | 14077700.0 |
| 2002-08-27 10:00:00 | QQQ | ETF | 25.1 | 25.1 | 24.64 | 24.72 | 19785400.0 |
| 2002-08-27 11:00:00 | QQQ | ETF | 24.72 | 24.95 | 24.69 | 24.82 | 8980500.0 |
| 2002-08-27 12:00:00 | QQQ | ETF | 24.82 | 24.83 | 24.52 | 24.61 | 9260900.0 |
| 2002-08-27 13:00:00 | QQQ | ETF | 24.63 | 24.67 | 24.4 | 24.44 | 11936700.0 |
| 2002-08-27 14:00:00 | QQQ | ETF | 24.45 | 24.55 | 24.29 | 24.35 | 9455200.0 |
| 2002-08-27 15:00:00 | QQQ | ETF | 24.35 | 24.4 | 24.15 | 24.26 | 13427100.0 |
| 2002-08-27 16:00:00 | QQQ | ETF | 24.26 | 24.37 | 24.21 | 24.37 | 972900.0 |
| 2002-08-27 09:00:00 | IWM | ETF | 40.875 | 40.895 | 40.335 | 40.445 | 347000.0 |
| 2002-08-27 10:00:00 | IWM | ETF | 40.33 | 40.33 | 40.005 | 40.275 | 210000.0 |
| 2002-08-27 11:00:00 | IWM | ETF | 40.275 | 40.53 | 40.26 | 40.37 | 536200.0 |
| 2002-08-27 12:00:00 | IWM | ETF | 40.375 | 40.375 | 40.21 | 40.235 | 251000.0 |
| 2002-08-27 13:00:00 | IWM | ETF | 40.185 | 40.305 | 40.14 | 40.155 | 284600.0 |
| 2002-08-27 14:00:00 | IWM | ETF | 40.11 | 40.32 | 40.09 | 40.12 | 418200.0 |
| 2002-08-27 15:00:00 | IWM | ETF | 40.085 | 40.125 | 39.66 | 39.665 | 677000.0 |
| 2002-08-27 16:00:00 | IWM | ETF | 39.66 | 39.775 | 39.66 | 39.775 | 600.0 |
| 2002-08-27 09:00:00 | DIA | ETF | 89.98 | 90.4 | 89.62 | 89.87 | 1460400.0 |
| 2002-08-27 10:00:00 | DIA | ETF | 89.88 | 89.94 | 88.55 | 88.85 | 2585900.0 |
| 2002-08-27 11:00:00 | DIA | ETF | 88.89 | 89.7 | 88.8 | 89.48 | 1368600.0 |
| 2002-08-27 12:00:00 | DIA | ETF | 89.47 | 89.49 | 88.96 | 89.07 | 346400.0 |
| 2002-08-27 13:00:00 | DIA | ETF | 89.12 | 89.39 | 88.66 | 88.82 | 920100.0 |
| 2002-08-27 14:00:00 | DIA | ETF | 88.82 | 89.12 | 88.36 | 88.52 | 947400.0 |
| 2002-08-27 15:00:00 | DIA | ETF | 88.48 | 88.7 | 87.95 | 88.37 | 1501200.0 |
| 2002-08-27 16:00:00 | DIA | ETF | 88.36 | 88.5 | 88.31 | 88.5 | 66800.0 |
| 2002-08-27 09:00:00 | TLT | ETF | 85.4 | 85.4 | 85.35 | 85.38 | 3400.0 |
| 2002-08-27 10:00:00 | TLT | ETF | 85.34 | 85.68 | 85.34 | 85.6 | 134300.0 |
| 2002-08-27 11:00:00 | TLT | ETF | 85.55 | 85.55 | 85.36 | 85.36 | 51300.0 |
| 2002-08-27 12:00:00 | TLT | ETF | 85.36 | 85.37 | 85.35 | 85.37 | 2500.0 |
| 2002-08-27 13:00:00 | TLT | ETF | 85.37 | 85.41 | 85.3 | 85.41 | 65500.0 |
| 2002-08-27 14:00:00 | TLT | ETF | 85.42 | 85.47 | 85.35 | 85.35 | 40500.0 |
| 2002-08-27 15:00:00 | TLT | ETF | 85.2 | 85.44 | 85.2 | 85.44 | 4300.0 |
> showing 39 of 348 rows — these rows as CSV