PREVIEW / etf_1hour / 2002-02-14
file: by_date/etf_1hour/2002/2002-02-14.parquet size: 13 KB rows: 286
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-02-14 09:00:00 | SPY | ETF | 112.51 | 112.58 | 111.9 | 112.02 | 2461300.0 |
| 2002-02-14 10:00:00 | SPY | ETF | 112.03 | 112.94 | 112.0 | 112.72 | 6048200.0 |
| 2002-02-14 11:00:00 | SPY | ETF | 112.73 | 112.82 | 112.5 | 112.71 | 877500.0 |
| 2002-02-14 12:00:00 | SPY | ETF | 112.71 | 112.97 | 112.62 | 112.71 | 984700.0 |
| 2002-02-14 13:00:00 | SPY | ETF | 112.68 | 112.84 | 112.32 | 112.41 | 1085900.0 |
| 2002-02-14 14:00:00 | SPY | ETF | 112.4 | 112.4 | 111.93 | 111.98 | 4002800.0 |
| 2002-02-14 15:00:00 | SPY | ETF | 111.94 | 112.18 | 111.59 | 111.98 | 3730000.0 |
| 2002-02-14 16:00:00 | SPY | ETF | 111.98 | 112.1 | 111.55 | 112.0 | 888400.0 |
| 2002-02-14 17:00:00 | SPY | ETF | 111.99 | 112.01 | 111.98 | 111.98 | 2600.0 |
| 2002-02-14 18:00:00 | SPY | ETF | 111.96 | 111.96 | 111.94 | 111.94 | 200.0 |
| 2002-02-14 09:00:00 | QQQ | ETF | 37.15 | 37.3 | 36.94 | 37.0 | 9096400.0 |
| 2002-02-14 10:00:00 | QQQ | ETF | 37.0 | 37.57 | 36.98 | 37.44 | 20399900.0 |
| 2002-02-14 11:00:00 | QQQ | ETF | 37.45 | 37.49 | 37.29 | 37.41 | 6984100.0 |
| 2002-02-14 12:00:00 | QQQ | ETF | 37.42 | 37.55 | 37.34 | 37.4 | 4710000.0 |
| 2002-02-14 13:00:00 | QQQ | ETF | 37.4 | 37.53 | 37.16 | 37.18 | 5249500.0 |
| 2002-02-14 14:00:00 | QQQ | ETF | 37.16 | 37.19 | 36.7 | 36.8 | 13869400.0 |
| 2002-02-14 15:00:00 | QQQ | ETF | 36.8 | 36.92 | 36.6 | 36.72 | 11916700.0 |
| 2002-02-14 16:00:00 | QQQ | ETF | 36.72 | 36.94 | 36.35 | 36.76 | 4182400.0 |
| 2002-02-14 17:00:00 | QQQ | ETF | 36.74 | 36.83 | 36.66 | 36.67 | 211700.0 |
| 2002-02-14 18:00:00 | QQQ | ETF | 36.69 | 36.75 | 36.65 | 36.74 | 14000.0 |
| 2002-02-14 09:00:00 | IWM | ETF | 47.47 | 47.545 | 47.17 | 47.17 | 78600.0 |
| 2002-02-14 10:00:00 | IWM | ETF | 47.275 | 47.59 | 47.25 | 47.5 | 559200.0 |
| 2002-02-14 11:00:00 | IWM | ETF | 47.52 | 47.525 | 47.35 | 47.495 | 63400.0 |
| 2002-02-14 12:00:00 | IWM | ETF | 47.445 | 47.485 | 47.39 | 47.405 | 23800.0 |
| 2002-02-14 13:00:00 | IWM | ETF | 47.415 | 47.42 | 47.355 | 47.375 | 423200.0 |
| 2002-02-14 14:00:00 | IWM | ETF | 47.25 | 47.31 | 47.055 | 47.08 | 350600.0 |
| 2002-02-14 15:00:00 | IWM | ETF | 47.07 | 47.115 | 46.785 | 46.925 | 232600.0 |
| 2002-02-14 16:00:00 | IWM | ETF | 46.905 | 46.905 | 46.75 | 46.835 | 226600.0 |
| 2002-02-14 09:00:00 | DIA | ETF | 100.4 | 100.5 | 99.78 | 99.94 | 462500.0 |
| 2002-02-14 10:00:00 | DIA | ETF | 99.96 | 100.64 | 99.85 | 100.45 | 1481800.0 |
| 2002-02-14 11:00:00 | DIA | ETF | 100.42 | 100.57 | 100.32 | 100.56 | 145100.0 |
| 2002-02-14 12:00:00 | DIA | ETF | 100.48 | 100.79 | 100.47 | 100.62 | 512500.0 |
| 2002-02-14 13:00:00 | DIA | ETF | 100.61 | 100.75 | 100.4 | 100.49 | 895200.0 |
| 2002-02-14 14:00:00 | DIA | ETF | 100.45 | 100.53 | 100.1 | 100.13 | 1682000.0 |
| 2002-02-14 15:00:00 | DIA | ETF | 100.11 | 100.29 | 99.75 | 100.16 | 605000.0 |
| 2002-02-14 16:00:00 | DIA | ETF | 100.16 | 100.3 | 100.11 | 100.3 | 62500.0 |
| 2002-02-14 17:00:00 | DIA | ETF | 100.3 | 100.3 | 100.3 | 100.3 | 100.0 |
| 2002-02-14 18:00:00 | DIA | ETF | 100.2 | 100.2 | 100.2 | 100.2 | 1000.0 |
> showing 38 of 286 rows — these rows as CSV