PREVIEW / etf_1hour / 2002-01-14
file: by_date/etf_1hour/2002/2002-01-14.parquet size: 14 KB rows: 292
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-01-14 09:00:00 | SPY | ETF | 114.65 | 114.84 | 114.48 | 114.72 | 1427800.0 |
| 2002-01-14 10:00:00 | SPY | ETF | 114.7 | 114.82 | 114.18 | 114.38 | 2653300.0 |
| 2002-01-14 11:00:00 | SPY | ETF | 114.36 | 114.46 | 114.18 | 114.37 | 1068700.0 |
| 2002-01-14 12:00:00 | SPY | ETF | 114.39 | 114.39 | 114.1 | 114.34 | 946000.0 |
| 2002-01-14 13:00:00 | SPY | ETF | 114.33 | 114.6 | 114.28 | 114.57 | 1867800.0 |
| 2002-01-14 14:00:00 | SPY | ETF | 114.6 | 114.63 | 114.22 | 114.54 | 1545900.0 |
| 2002-01-14 15:00:00 | SPY | ETF | 114.55 | 114.8 | 114.1 | 114.12 | 1851400.0 |
| 2002-01-14 16:00:00 | SPY | ETF | 114.13 | 114.22 | 113.96 | 114.2 | 761700.0 |
| 2002-01-14 18:00:00 | SPY | ETF | 114.16 | 114.25 | 114.16 | 114.25 | 3200.0 |
| 2002-01-14 09:00:00 | QQQ | ETF | 40.49 | 40.68 | 40.34 | 40.45 | 7860900.0 |
| 2002-01-14 10:00:00 | QQQ | ETF | 40.46 | 40.53 | 39.97 | 40.05 | 12393700.0 |
| 2002-01-14 11:00:00 | QQQ | ETF | 40.05 | 40.13 | 39.89 | 40.02 | 8972300.0 |
| 2002-01-14 12:00:00 | QQQ | ETF | 40.0 | 40.01 | 39.7 | 39.89 | 6054900.0 |
| 2002-01-14 13:00:00 | QQQ | ETF | 39.89 | 40.11 | 39.87 | 40.09 | 7156600.0 |
| 2002-01-14 14:00:00 | QQQ | ETF | 40.07 | 40.27 | 39.83 | 40.23 | 10017500.0 |
| 2002-01-14 15:00:00 | QQQ | ETF | 40.25 | 40.45 | 39.85 | 39.9 | 14303300.0 |
| 2002-01-14 16:00:00 | QQQ | ETF | 39.9 | 39.99 | 39.84 | 39.94 | 1110700.0 |
| 2002-01-14 17:00:00 | QQQ | ETF | 39.93 | 39.95 | 39.85 | 39.91 | 46500.0 |
| 2002-01-14 18:00:00 | QQQ | ETF | 39.89 | 39.91 | 39.84 | 39.85 | 13700.0 |
| 2002-01-14 09:00:00 | IWM | ETF | 48.63 | 48.63 | 48.4 | 48.615 | 108200.0 |
| 2002-01-14 10:00:00 | IWM | ETF | 48.545 | 48.545 | 48.11 | 48.12 | 157200.0 |
| 2002-01-14 11:00:00 | IWM | ETF | 48.145 | 48.175 | 48.04 | 48.12 | 93600.0 |
| 2002-01-14 12:00:00 | IWM | ETF | 48.14 | 48.14 | 47.985 | 48.075 | 39600.0 |
| 2002-01-14 13:00:00 | IWM | ETF | 48.085 | 48.215 | 48.085 | 48.175 | 123200.0 |
| 2002-01-14 14:00:00 | IWM | ETF | 48.21 | 48.215 | 48.04 | 48.175 | 59600.0 |
| 2002-01-14 15:00:00 | IWM | ETF | 48.125 | 48.235 | 47.85 | 47.85 | 193200.0 |
| 2002-01-14 16:00:00 | IWM | ETF | 47.925 | 47.975 | 47.925 | 47.975 | 3200.0 |
| 2002-01-14 09:00:00 | DIA | ETF | 99.74 | 99.86 | 99.52 | 99.68 | 233300.0 |
| 2002-01-14 10:00:00 | DIA | ETF | 99.64 | 99.7 | 99.31 | 99.44 | 591400.0 |
| 2002-01-14 11:00:00 | DIA | ETF | 99.5 | 99.55 | 99.28 | 99.36 | 531400.0 |
| 2002-01-14 12:00:00 | DIA | ETF | 99.37 | 99.39 | 99.11 | 99.25 | 941300.0 |
| 2002-01-14 13:00:00 | DIA | ETF | 99.26 | 99.48 | 99.25 | 99.44 | 435700.0 |
| 2002-01-14 14:00:00 | DIA | ETF | 99.48 | 99.48 | 99.12 | 99.3 | 103900.0 |
| 2002-01-14 15:00:00 | DIA | ETF | 99.39 | 99.6 | 99.0 | 99.05 | 518200.0 |
| 2002-01-14 16:00:00 | DIA | ETF | 99.02 | 99.15 | 98.91 | 99.01 | 108200.0 |
> showing 35 of 292 rows — these rows as CSV