PREVIEW / etf_1hour / 2001-10-03
file: by_date/etf_1hour/2001/2001-10-03.parquet size: 12 KB rows: 251
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 |
|---|---|---|---|---|---|---|---|
| 2001-10-03 09:00:00 | SPY | ETF | 104.6 | 104.78 | 104.35 | 104.45 | 3329400.0 |
| 2001-10-03 10:00:00 | SPY | ETF | 104.47 | 105.58 | 104.35 | 105.29 | 6509200.0 |
| 2001-10-03 11:00:00 | SPY | ETF | 105.26 | 106.98 | 105.22 | 106.65 | 4094900.0 |
| 2001-10-03 12:00:00 | SPY | ETF | 106.68 | 106.91 | 106.12 | 106.8 | 4042900.0 |
| 2001-10-03 13:00:00 | SPY | ETF | 106.8 | 107.44 | 106.45 | 107.27 | 3870800.0 |
| 2001-10-03 14:00:00 | SPY | ETF | 107.25 | 107.65 | 106.82 | 107.52 | 2796000.0 |
| 2001-10-03 15:00:00 | SPY | ETF | 107.5 | 107.88 | 107.25 | 107.34 | 4591700.0 |
| 2001-10-03 16:00:00 | SPY | ETF | 107.46 | 107.7 | 107.0 | 107.3 | 1750100.0 |
| 2001-10-03 17:00:00 | SPY | ETF | 107.3 | 107.4 | 107.3 | 107.36 | 5500.0 |
| 2001-10-03 18:00:00 | SPY | ETF | 107.35 | 107.39 | 107.2 | 107.39 | 700.0 |
| 2001-10-03 09:00:00 | QQQ | ETF | 28.42 | 28.69 | 28.33 | 28.48 | 7587100.0 |
| 2001-10-03 10:00:00 | QQQ | ETF | 28.47 | 29.46 | 28.38 | 29.31 | 23382400.0 |
| 2001-10-03 11:00:00 | QQQ | ETF | 29.32 | 30.64 | 29.27 | 30.4 | 19822600.0 |
| 2001-10-03 12:00:00 | QQQ | ETF | 30.4 | 31.0 | 29.95 | 30.9 | 17599500.0 |
| 2001-10-03 13:00:00 | QQQ | ETF | 30.88 | 31.41 | 30.71 | 31.32 | 17238100.0 |
| 2001-10-03 14:00:00 | QQQ | ETF | 31.35 | 31.5 | 30.87 | 31.41 | 16398300.0 |
| 2001-10-03 15:00:00 | QQQ | ETF | 31.4 | 31.61 | 30.85 | 31.05 | 22466600.0 |
| 2001-10-03 16:00:00 | QQQ | ETF | 31.09 | 31.32 | 30.22 | 31.0 | 5095300.0 |
| 2001-10-03 17:00:00 | QQQ | ETF | 31.03 | 31.07 | 30.95 | 31.0 | 88000.0 |
| 2001-10-03 18:00:00 | QQQ | ETF | 30.97 | 31.07 | 30.9 | 30.91 | 22400.0 |
| 2001-10-03 09:00:00 | IWM | ETF | 39.5 | 39.87 | 39.5 | 39.87 | 17400.0 |
| 2001-10-03 10:00:00 | IWM | ETF | 39.925 | 40.285 | 39.925 | 40.285 | 322600.0 |
| 2001-10-03 11:00:00 | IWM | ETF | 40.35 | 40.725 | 40.34 | 40.725 | 426000.0 |
| 2001-10-03 12:00:00 | IWM | ETF | 40.745 | 40.745 | 40.6 | 40.68 | 242800.0 |
| 2001-10-03 13:00:00 | IWM | ETF | 40.725 | 41.0 | 40.635 | 40.99 | 203600.0 |
| 2001-10-03 14:00:00 | IWM | ETF | 40.995 | 41.15 | 40.935 | 41.15 | 53800.0 |
| 2001-10-03 15:00:00 | IWM | ETF | 41.145 | 41.375 | 40.95 | 41.0 | 28400.0 |
| 2001-10-03 16:00:00 | IWM | ETF | 41.125 | 41.125 | 41.1 | 41.1 | 22000.0 |
| 2001-10-03 09:00:00 | DIA | ETF | 88.75 | 89.2 | 88.65 | 88.9 | 752100.0 |
| 2001-10-03 10:00:00 | DIA | ETF | 88.85 | 89.74 | 88.76 | 89.48 | 1114200.0 |
| 2001-10-03 11:00:00 | DIA | ETF | 89.49 | 90.95 | 89.4 | 90.7 | 1489900.0 |
| 2001-10-03 12:00:00 | DIA | ETF | 90.7 | 90.72 | 90.27 | 90.68 | 505500.0 |
| 2001-10-03 13:00:00 | DIA | ETF | 90.7 | 91.14 | 90.33 | 91.05 | 736300.0 |
| 2001-10-03 14:00:00 | DIA | ETF | 90.98 | 91.35 | 90.51 | 91.15 | 1015200.0 |
| 2001-10-03 15:00:00 | DIA | ETF | 91.18 | 91.64 | 91.04 | 91.22 | 1252300.0 |
| 2001-10-03 16:00:00 | DIA | ETF | 91.25 | 91.5 | 90.93 | 91.17 | 229700.0 |
| 2001-10-03 17:00:00 | DIA | ETF | 91.25 | 91.3 | 91.2 | 91.2 | 3200.0 |
> showing 37 of 251 rows — these rows as CSV