PREVIEW / etf_1hour / 2002-07-03
file: by_date/etf_1hour/2002/2002-07-03.parquet size: 14 KB rows: 314
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-07-03 09:00:00 | SPY | ETF | 94.62 | 95.61 | 94.6 | 95.53 | 3756300.0 |
| 2002-07-03 10:00:00 | SPY | ETF | 95.58 | 95.7 | 94.11 | 94.22 | 5206000.0 |
| 2002-07-03 11:00:00 | SPY | ETF | 94.21 | 94.65 | 93.72 | 94.62 | 5018300.0 |
| 2002-07-03 12:00:00 | SPY | ETF | 94.64 | 94.83 | 93.84 | 94.35 | 2955700.0 |
| 2002-07-03 13:00:00 | SPY | ETF | 94.35 | 94.6 | 94.06 | 94.59 | 1959400.0 |
| 2002-07-03 14:00:00 | SPY | ETF | 94.51 | 95.5 | 94.26 | 95.5 | 4480500.0 |
| 2002-07-03 15:00:00 | SPY | ETF | 95.5 | 95.78 | 95.06 | 95.69 | 5325800.0 |
| 2002-07-03 16:00:00 | SPY | ETF | 95.69 | 95.74 | 94.82 | 95.53 | 1252100.0 |
| 2002-07-03 17:00:00 | SPY | ETF | 95.59 | 95.6 | 95.5 | 95.6 | 4300.0 |
| 2002-07-03 18:00:00 | SPY | ETF | 95.53 | 95.55 | 95.52 | 95.52 | 5000.0 |
| 2002-07-03 09:00:00 | QQQ | ETF | 23.85 | 24.34 | 23.83 | 24.23 | 12973100.0 |
| 2002-07-03 10:00:00 | QQQ | ETF | 24.23 | 24.32 | 23.62 | 23.7 | 20020100.0 |
| 2002-07-03 11:00:00 | QQQ | ETF | 23.7 | 24.22 | 23.63 | 24.19 | 15885400.0 |
| 2002-07-03 12:00:00 | QQQ | ETF | 24.22 | 24.25 | 23.85 | 24.1 | 8664800.0 |
| 2002-07-03 13:00:00 | QQQ | ETF | 24.11 | 24.31 | 23.96 | 24.24 | 8057700.0 |
| 2002-07-03 14:00:00 | QQQ | ETF | 24.23 | 24.65 | 24.15 | 24.64 | 17088700.0 |
| 2002-07-03 15:00:00 | QQQ | ETF | 24.64 | 24.75 | 24.4 | 24.72 | 13454400.0 |
| 2002-07-03 16:00:00 | QQQ | ETF | 24.73 | 24.77 | 24.68 | 24.74 | 2372700.0 |
| 2002-07-03 17:00:00 | QQQ | ETF | 24.74 | 24.76 | 24.71 | 24.75 | 43800.0 |
| 2002-07-03 18:00:00 | QQQ | ETF | 24.75 | 24.76 | 24.72 | 24.73 | 17600.0 |
| 2002-07-03 09:00:00 | IWM | ETF | 42.9 | 43.0 | 42.635 | 43.0 | 73200.0 |
| 2002-07-03 10:00:00 | IWM | ETF | 42.975 | 42.975 | 42.14 | 42.18 | 659400.0 |
| 2002-07-03 11:00:00 | IWM | ETF | 42.1 | 42.245 | 42.0 | 42.175 | 577600.0 |
| 2002-07-03 12:00:00 | IWM | ETF | 42.165 | 42.275 | 42.065 | 42.135 | 611400.0 |
| 2002-07-03 13:00:00 | IWM | ETF | 42.135 | 42.16 | 42.065 | 42.16 | 66400.0 |
| 2002-07-03 14:00:00 | IWM | ETF | 42.175 | 42.645 | 42.175 | 42.6 | 402000.0 |
| 2002-07-03 15:00:00 | IWM | ETF | 42.6 | 42.865 | 42.535 | 42.775 | 421600.0 |
| 2002-07-03 16:00:00 | IWM | ETF | 42.825 | 42.825 | 42.55 | 42.55 | 83600.0 |
| 2002-07-03 09:00:00 | DIA | ETF | 89.8 | 90.89 | 89.8 | 90.7 | 789800.0 |
| 2002-07-03 10:00:00 | DIA | ETF | 90.82 | 90.92 | 89.53 | 89.66 | 1400800.0 |
| 2002-07-03 11:00:00 | DIA | ETF | 89.66 | 89.85 | 89.1 | 89.85 | 1053700.0 |
| 2002-07-03 12:00:00 | DIA | ETF | 89.82 | 90.07 | 89.1 | 89.52 | 587100.0 |
| 2002-07-03 13:00:00 | DIA | ETF | 89.45 | 89.6 | 89.1 | 89.53 | 454000.0 |
| 2002-07-03 14:00:00 | DIA | ETF | 89.53 | 90.59 | 89.37 | 90.59 | 2050900.0 |
| 2002-07-03 15:00:00 | DIA | ETF | 90.58 | 90.75 | 90.08 | 90.72 | 1120700.0 |
| 2002-07-03 16:00:00 | DIA | ETF | 90.74 | 90.74 | 90.63 | 90.7 | 219300.0 |
| 2002-07-03 17:00:00 | DIA | ETF | 90.54 | 90.54 | 90.54 | 90.54 | 200.0 |
> showing 37 of 314 rows — these rows as CSV