PREVIEW / etf_1hour / 2002-07-18
file: by_date/etf_1hour/2002/2002-07-18.parquet size: 14 KB rows: 309
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-18 09:00:00 | SPY | ETF | 90.7 | 91.1 | 90.02 | 90.26 | 3731600.0 |
| 2002-07-18 10:00:00 | SPY | ETF | 90.25 | 90.7 | 89.65 | 90.07 | 4722000.0 |
| 2002-07-18 11:00:00 | SPY | ETF | 90.02 | 91.0 | 90.0 | 90.96 | 2525400.0 |
| 2002-07-18 12:00:00 | SPY | ETF | 91.0 | 91.05 | 90.16 | 90.43 | 3803700.0 |
| 2002-07-18 13:00:00 | SPY | ETF | 90.37 | 90.64 | 89.99 | 90.19 | 1957800.0 |
| 2002-07-18 14:00:00 | SPY | ETF | 90.18 | 90.25 | 88.8 | 89.0 | 5194800.0 |
| 2002-07-18 15:00:00 | SPY | ETF | 89.02 | 89.27 | 88.24 | 88.33 | 6571000.0 |
| 2002-07-18 16:00:00 | SPY | ETF | 88.3 | 88.35 | 87.75 | 87.8 | 1864400.0 |
| 2002-07-18 09:00:00 | QQQ | ETF | 25.38 | 25.57 | 25.03 | 25.13 | 14682000.0 |
| 2002-07-18 10:00:00 | QQQ | ETF | 25.13 | 25.3 | 25.01 | 25.12 | 18228300.0 |
| 2002-07-18 11:00:00 | QQQ | ETF | 25.14 | 25.52 | 25.1 | 25.5 | 14978400.0 |
| 2002-07-18 12:00:00 | QQQ | ETF | 25.5 | 25.53 | 25.07 | 25.16 | 14552500.0 |
| 2002-07-18 13:00:00 | QQQ | ETF | 25.18 | 25.32 | 25.03 | 25.1 | 9278700.0 |
| 2002-07-18 14:00:00 | QQQ | ETF | 25.09 | 25.15 | 24.71 | 24.8 | 17514900.0 |
| 2002-07-18 15:00:00 | QQQ | ETF | 24.77 | 24.91 | 24.67 | 24.78 | 17031800.0 |
| 2002-07-18 16:00:00 | QQQ | ETF | 24.76 | 24.89 | 24.72 | 24.73 | 796100.0 |
| 2002-07-18 09:00:00 | IWM | ETF | 40.65 | 40.95 | 40.605 | 40.605 | 65600.0 |
| 2002-07-18 10:00:00 | IWM | ETF | 40.525 | 40.885 | 40.5 | 40.75 | 277000.0 |
| 2002-07-18 11:00:00 | IWM | ETF | 40.71 | 40.9 | 40.7 | 40.86 | 145200.0 |
| 2002-07-18 12:00:00 | IWM | ETF | 40.76 | 40.76 | 40.5 | 40.57 | 120200.0 |
| 2002-07-18 13:00:00 | IWM | ETF | 40.57 | 40.61 | 40.125 | 40.125 | 49400.0 |
| 2002-07-18 14:00:00 | IWM | ETF | 40.305 | 40.305 | 39.73 | 39.835 | 469600.0 |
| 2002-07-18 15:00:00 | IWM | ETF | 39.77 | 40.0 | 39.525 | 39.575 | 695200.0 |
| 2002-07-18 16:00:00 | IWM | ETF | 39.575 | 39.575 | 39.45 | 39.45 | 5200.0 |
| 2002-07-18 09:00:00 | DIA | ETF | 85.56 | 86.05 | 85.25 | 85.39 | 668400.0 |
| 2002-07-18 10:00:00 | DIA | ETF | 85.45 | 86.0 | 84.9 | 85.56 | 1001300.0 |
| 2002-07-18 11:00:00 | DIA | ETF | 85.44 | 86.45 | 85.4 | 86.39 | 748400.0 |
| 2002-07-18 12:00:00 | DIA | ETF | 86.45 | 86.45 | 85.55 | 86.0 | 927200.0 |
| 2002-07-18 13:00:00 | DIA | ETF | 85.96 | 86.25 | 85.55 | 85.8 | 526900.0 |
| 2002-07-18 14:00:00 | DIA | ETF | 85.83 | 85.94 | 84.58 | 84.8 | 1697600.0 |
| 2002-07-18 15:00:00 | DIA | ETF | 84.85 | 85.15 | 84.1 | 84.21 | 2150600.0 |
| 2002-07-18 16:00:00 | DIA | ETF | 84.25 | 84.25 | 83.85 | 83.85 | 54200.0 |
> showing 32 of 309 rows — these rows as CSV