PREVIEW / etf_1hour / 2002-07-11
file: by_date/etf_1hour/2002/2002-07-11.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-07-11 09:00:00 | SPY | ETF | 91.76 | 92.05 | 90.92 | 91.89 | 10189300.0 |
| 2002-07-11 10:00:00 | SPY | ETF | 91.86 | 92.85 | 91.64 | 92.01 | 10700800.0 |
| 2002-07-11 11:00:00 | SPY | ETF | 91.95 | 92.4 | 90.92 | 91.0 | 5004400.0 |
| 2002-07-11 12:00:00 | SPY | ETF | 90.94 | 91.74 | 90.32 | 91.6 | 7731000.0 |
| 2002-07-11 13:00:00 | SPY | ETF | 91.6 | 92.15 | 90.9 | 91.98 | 6052000.0 |
| 2002-07-11 14:00:00 | SPY | ETF | 91.98 | 92.88 | 91.74 | 91.88 | 7184000.0 |
| 2002-07-11 15:00:00 | SPY | ETF | 91.87 | 93.35 | 91.78 | 93.15 | 6358500.0 |
| 2002-07-11 16:00:00 | SPY | ETF | 93.18 | 93.24 | 91.84 | 93.1 | 3960400.0 |
| 2002-07-11 17:00:00 | SPY | ETF | 93.13 | 94.01 | 92.65 | 93.59 | 517700.0 |
| 2002-07-11 18:00:00 | SPY | ETF | 93.6 | 93.7 | 93.59 | 93.7 | 4800.0 |
| 2002-07-11 09:00:00 | QQQ | ETF | 23.76 | 24.08 | 23.53 | 24.05 | 22691200.0 |
| 2002-07-11 10:00:00 | QQQ | ETF | 24.06 | 24.44 | 23.7 | 23.95 | 31478100.0 |
| 2002-07-11 11:00:00 | QQQ | ETF | 23.95 | 24.14 | 23.61 | 23.68 | 12057700.0 |
| 2002-07-11 12:00:00 | QQQ | ETF | 23.68 | 24.25 | 23.55 | 24.18 | 17055500.0 |
| 2002-07-11 13:00:00 | QQQ | ETF | 24.19 | 24.5 | 23.92 | 24.45 | 19360300.0 |
| 2002-07-11 14:00:00 | QQQ | ETF | 24.47 | 24.78 | 24.23 | 24.24 | 28553900.0 |
| 2002-07-11 15:00:00 | QQQ | ETF | 24.25 | 24.89 | 24.21 | 24.82 | 23976200.0 |
| 2002-07-11 16:00:00 | QQQ | ETF | 24.8 | 24.85 | 24.04 | 24.8 | 2907200.0 |
| 2002-07-11 17:00:00 | QQQ | ETF | 24.8 | 25.97 | 24.79 | 25.26 | 5195300.0 |
| 2002-07-11 18:00:00 | QQQ | ETF | 25.26 | 25.31 | 25.24 | 25.29 | 92100.0 |
| 2002-07-11 09:00:00 | IWM | ETF | 41.5 | 41.585 | 41.015 | 41.45 | 97800.0 |
| 2002-07-11 10:00:00 | IWM | ETF | 41.355 | 41.62 | 41.285 | 41.375 | 229800.0 |
| 2002-07-11 11:00:00 | IWM | ETF | 41.365 | 41.445 | 40.825 | 40.88 | 197200.0 |
| 2002-07-11 12:00:00 | IWM | ETF | 40.825 | 40.875 | 40.55 | 40.86 | 702200.0 |
| 2002-07-11 13:00:00 | IWM | ETF | 40.86 | 41.05 | 40.685 | 41.02 | 396600.0 |
| 2002-07-11 14:00:00 | IWM | ETF | 41.02 | 41.45 | 41.02 | 41.26 | 519400.0 |
| 2002-07-11 15:00:00 | IWM | ETF | 41.24 | 41.51 | 41.175 | 41.46 | 943600.0 |
| 2002-07-11 16:00:00 | IWM | ETF | 41.525 | 41.53 | 41.38 | 41.53 | 268400.0 |
| 2002-07-11 09:00:00 | DIA | ETF | 87.61 | 88.15 | 87.0 | 87.96 | 1710700.0 |
| 2002-07-11 10:00:00 | DIA | ETF | 88.0 | 88.8 | 87.4 | 87.7 | 1282400.0 |
| 2002-07-11 11:00:00 | DIA | ETF | 87.75 | 88.16 | 86.89 | 86.91 | 618700.0 |
| 2002-07-11 12:00:00 | DIA | ETF | 86.8 | 87.3 | 86.17 | 87.08 | 1469300.0 |
| 2002-07-11 13:00:00 | DIA | ETF | 87.06 | 87.75 | 86.5 | 87.43 | 1053700.0 |
| 2002-07-11 14:00:00 | DIA | ETF | 87.47 | 88.25 | 87.15 | 87.23 | 1716100.0 |
| 2002-07-11 15:00:00 | DIA | ETF | 87.23 | 88.5 | 87.15 | 88.27 | 1835100.0 |
| 2002-07-11 16:00:00 | DIA | ETF | 88.35 | 88.45 | 88.13 | 88.43 | 136500.0 |
| 2002-07-11 17:00:00 | DIA | ETF | 88.39 | 88.74 | 88.25 | 88.6 | 5800.0 |
> showing 37 of 348 rows — these rows as CSV