PREVIEW / etf_1hour / 2002-04-18
file: by_date/etf_1hour/2002/2002-04-18.parquet size: 14 KB rows: 301
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-04-18 09:00:00 | SPY | ETF | 112.9 | 113.43 | 112.9 | 113.4 | 1137600.0 |
| 2002-04-18 10:00:00 | SPY | ETF | 113.39 | 113.46 | 112.34 | 112.57 | 4163600.0 |
| 2002-04-18 11:00:00 | SPY | ETF | 112.62 | 112.76 | 112.0 | 112.08 | 2519900.0 |
| 2002-04-18 12:00:00 | SPY | ETF | 112.08 | 112.51 | 111.15 | 112.49 | 10604500.0 |
| 2002-04-18 13:00:00 | SPY | ETF | 112.49 | 112.65 | 112.26 | 112.42 | 1286800.0 |
| 2002-04-18 14:00:00 | SPY | ETF | 112.4 | 112.96 | 112.35 | 112.62 | 1917000.0 |
| 2002-04-18 15:00:00 | SPY | ETF | 112.62 | 112.98 | 112.53 | 112.75 | 1193700.0 |
| 2002-04-18 16:00:00 | SPY | ETF | 112.75 | 112.85 | 112.0 | 112.15 | 1130600.0 |
| 2002-04-18 09:00:00 | QQQ | ETF | 34.78 | 35.13 | 34.74 | 35.1 | 8537800.0 |
| 2002-04-18 10:00:00 | QQQ | ETF | 35.12 | 35.15 | 34.39 | 34.53 | 15480200.0 |
| 2002-04-18 11:00:00 | QQQ | ETF | 34.54 | 34.7 | 34.0 | 34.35 | 8704700.0 |
| 2002-04-18 12:00:00 | QQQ | ETF | 34.35 | 34.61 | 34.0 | 34.56 | 26077500.0 |
| 2002-04-18 13:00:00 | QQQ | ETF | 34.56 | 34.67 | 34.47 | 34.56 | 4710900.0 |
| 2002-04-18 14:00:00 | QQQ | ETF | 34.56 | 34.9 | 34.51 | 34.7 | 8901000.0 |
| 2002-04-18 15:00:00 | QQQ | ETF | 34.69 | 34.85 | 34.65 | 34.76 | 7007300.0 |
| 2002-04-18 16:00:00 | QQQ | ETF | 34.75 | 34.82 | 33.96 | 34.0 | 4800800.0 |
| 2002-04-18 09:00:00 | IWM | ETF | 51.775 | 51.865 | 51.675 | 51.865 | 50000.0 |
| 2002-04-18 10:00:00 | IWM | ETF | 51.825 | 51.825 | 51.125 | 51.385 | 392200.0 |
| 2002-04-18 11:00:00 | IWM | ETF | 51.415 | 51.46 | 51.325 | 51.345 | 859200.0 |
| 2002-04-18 12:00:00 | IWM | ETF | 51.4 | 51.4 | 51.075 | 51.39 | 111200.0 |
| 2002-04-18 13:00:00 | IWM | ETF | 51.385 | 51.45 | 51.35 | 51.425 | 74000.0 |
| 2002-04-18 14:00:00 | IWM | ETF | 51.42 | 51.625 | 51.35 | 51.55 | 724000.0 |
| 2002-04-18 15:00:00 | IWM | ETF | 51.515 | 51.625 | 51.465 | 51.56 | 68600.0 |
| 2002-04-18 16:00:00 | IWM | ETF | 51.57 | 51.605 | 51.49 | 51.49 | 1400.0 |
| 2002-04-18 09:00:00 | DIA | ETF | 102.4 | 102.75 | 102.4 | 102.6 | 294200.0 |
| 2002-04-18 10:00:00 | DIA | ETF | 102.6 | 102.61 | 101.58 | 101.85 | 1390500.0 |
| 2002-04-18 11:00:00 | DIA | ETF | 101.82 | 102.14 | 101.52 | 101.57 | 726000.0 |
| 2002-04-18 12:00:00 | DIA | ETF | 101.62 | 101.93 | 100.62 | 101.78 | 1919300.0 |
| 2002-04-18 13:00:00 | DIA | ETF | 101.84 | 102.02 | 101.67 | 101.77 | 279700.0 |
| 2002-04-18 14:00:00 | DIA | ETF | 101.72 | 102.32 | 101.7 | 102.0 | 556600.0 |
| 2002-04-18 15:00:00 | DIA | ETF | 101.91 | 102.38 | 101.91 | 102.21 | 337900.0 |
| 2002-04-18 16:00:00 | DIA | ETF | 102.17 | 102.21 | 101.8 | 101.8 | 40900.0 |
> showing 32 of 301 rows — these rows as CSV