PREVIEW / etf_1hour / 2001-11-29
file: by_date/etf_1hour/2001/2001-11-29.parquet size: 13 KB rows: 268
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-11-29 09:00:00 | SPY | ETF | 113.66 | 113.75 | 113.05 | 113.28 | 1777800.0 |
| 2001-11-29 10:00:00 | SPY | ETF | 113.31 | 114.12 | 113.0 | 113.84 | 3500600.0 |
| 2001-11-29 11:00:00 | SPY | ETF | 113.77 | 114.08 | 113.53 | 113.98 | 1822200.0 |
| 2001-11-29 12:00:00 | SPY | ETF | 113.98 | 114.12 | 113.6 | 113.79 | 837400.0 |
| 2001-11-29 13:00:00 | SPY | ETF | 113.79 | 113.81 | 113.31 | 113.74 | 1345800.0 |
| 2001-11-29 14:00:00 | SPY | ETF | 113.75 | 114.07 | 113.7 | 113.79 | 1487300.0 |
| 2001-11-29 15:00:00 | SPY | ETF | 113.75 | 114.56 | 113.61 | 114.48 | 3987700.0 |
| 2001-11-29 16:00:00 | SPY | ETF | 114.45 | 114.97 | 114.41 | 114.87 | 1143800.0 |
| 2001-11-29 17:00:00 | SPY | ETF | 113.35 | 114.83 | 113.35 | 114.51 | 904300.0 |
| 2001-11-29 18:00:00 | SPY | ETF | 115.21 | 115.21 | 114.72 | 115.18 | 2800.0 |
| 2001-11-29 09:00:00 | QQQ | ETF | 39.03 | 39.24 | 38.87 | 38.9 | 9216000.0 |
| 2001-11-29 10:00:00 | QQQ | ETF | 38.94 | 39.48 | 38.79 | 39.32 | 14198000.0 |
| 2001-11-29 11:00:00 | QQQ | ETF | 39.31 | 39.6 | 39.1 | 39.54 | 7809900.0 |
| 2001-11-29 12:00:00 | QQQ | ETF | 39.55 | 39.66 | 39.22 | 39.39 | 7889800.0 |
| 2001-11-29 13:00:00 | QQQ | ETF | 39.37 | 39.41 | 38.95 | 39.41 | 10036900.0 |
| 2001-11-29 14:00:00 | QQQ | ETF | 39.41 | 39.75 | 39.32 | 39.46 | 12898800.0 |
| 2001-11-29 15:00:00 | QQQ | ETF | 39.46 | 39.86 | 39.35 | 39.84 | 15687200.0 |
| 2001-11-29 16:00:00 | QQQ | ETF | 39.8 | 40.02 | 39.74 | 39.83 | 4052100.0 |
| 2001-11-29 17:00:00 | QQQ | ETF | 39.82 | 39.85 | 39.65 | 39.8 | 205800.0 |
| 2001-11-29 18:00:00 | QQQ | ETF | 39.78 | 39.81 | 39.75 | 39.78 | 99000.0 |
| 2001-11-29 09:00:00 | IWM | ETF | 45.175 | 45.35 | 45.155 | 45.25 | 49200.0 |
| 2001-11-29 10:00:00 | IWM | ETF | 45.18 | 45.45 | 45.1 | 45.44 | 52200.0 |
| 2001-11-29 11:00:00 | IWM | ETF | 45.37 | 45.45 | 45.335 | 45.445 | 46600.0 |
| 2001-11-29 12:00:00 | IWM | ETF | 45.455 | 45.575 | 45.35 | 45.375 | 35600.0 |
| 2001-11-29 13:00:00 | IWM | ETF | 45.375 | 45.52 | 45.315 | 45.455 | 93000.0 |
| 2001-11-29 14:00:00 | IWM | ETF | 45.495 | 45.725 | 45.495 | 45.65 | 113600.0 |
| 2001-11-29 15:00:00 | IWM | ETF | 45.64 | 46.15 | 45.575 | 46.15 | 103800.0 |
| 2001-11-29 16:00:00 | IWM | ETF | 46.07 | 46.35 | 46.07 | 46.35 | 10600.0 |
| 2001-11-29 09:00:00 | DIA | ETF | 97.55 | 97.64 | 97.23 | 97.34 | 202700.0 |
| 2001-11-29 10:00:00 | DIA | ETF | 97.32 | 97.93 | 97.06 | 97.58 | 743000.0 |
| 2001-11-29 11:00:00 | DIA | ETF | 97.64 | 97.8 | 97.32 | 97.75 | 190500.0 |
| 2001-11-29 12:00:00 | DIA | ETF | 97.75 | 97.79 | 97.36 | 97.59 | 315500.0 |
| 2001-11-29 13:00:00 | DIA | ETF | 97.49 | 97.54 | 97.18 | 97.4 | 89400.0 |
| 2001-11-29 14:00:00 | DIA | ETF | 97.52 | 97.84 | 97.52 | 97.55 | 459300.0 |
| 2001-11-29 15:00:00 | DIA | ETF | 97.58 | 98.5 | 97.44 | 98.45 | 500700.0 |
| 2001-11-29 16:00:00 | DIA | ETF | 98.48 | 98.81 | 98.4 | 98.75 | 90800.0 |
| 2001-11-29 17:00:00 | DIA | ETF | 98.8 | 98.8 | 98.8 | 98.8 | 700.0 |
| 2001-11-29 18:00:00 | DIA | ETF | 98.81 | 98.81 | 98.8 | 98.8 | 600.0 |
> showing 38 of 268 rows — these rows as CSV