PREVIEW / etf_1hour / 2001-05-03
file: by_date/etf_1hour/2001/2001-05-03.parquet size: 11 KB rows: 226
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-05-03 09:00:00 | SPY | ETF | 126.12 | 126.15 | 125.25 | 125.4 | 1737200.0 |
| 2001-05-03 10:00:00 | SPY | ETF | 125.35 | 125.5 | 124.61 | 125.27 | 2140100.0 |
| 2001-05-03 11:00:00 | SPY | ETF | 125.17 | 125.33 | 124.57 | 124.93 | 946700.0 |
| 2001-05-03 12:00:00 | SPY | ETF | 124.83 | 125.03 | 124.56 | 124.57 | 463200.0 |
| 2001-05-03 13:00:00 | SPY | ETF | 124.65 | 125.02 | 124.35 | 124.82 | 651300.0 |
| 2001-05-03 14:00:00 | SPY | ETF | 124.85 | 124.87 | 124.22 | 124.5 | 763200.0 |
| 2001-05-03 15:00:00 | SPY | ETF | 124.52 | 125.35 | 124.33 | 125.16 | 1781700.0 |
| 2001-05-03 16:00:00 | SPY | ETF | 125.05 | 125.42 | 125.05 | 125.4 | 533400.0 |
| 2001-05-03 17:00:00 | SPY | ETF | 125.31 | 125.31 | 125.3 | 125.3 | 200.0 |
| 2001-05-03 09:00:00 | QQQ | ETF | 47.9 | 47.9 | 47.3 | 47.68 | 12866600.0 |
| 2001-05-03 10:00:00 | QQQ | ETF | 47.68 | 47.82 | 47.23 | 47.76 | 10126700.0 |
| 2001-05-03 11:00:00 | QQQ | ETF | 47.75 | 47.88 | 47.0 | 47.19 | 7826700.0 |
| 2001-05-03 12:00:00 | QQQ | ETF | 47.15 | 47.34 | 46.8 | 46.85 | 5369400.0 |
| 2001-05-03 13:00:00 | QQQ | ETF | 46.9 | 47.02 | 46.55 | 46.95 | 6742800.0 |
| 2001-05-03 14:00:00 | QQQ | ETF | 46.95 | 46.98 | 46.2 | 46.4 | 8051600.0 |
| 2001-05-03 15:00:00 | QQQ | ETF | 46.4 | 47.02 | 46.2 | 46.85 | 10053800.0 |
| 2001-05-03 16:00:00 | QQQ | ETF | 46.81 | 46.9 | 46.65 | 46.78 | 1034300.0 |
| 2001-05-03 17:00:00 | QQQ | ETF | 46.78 | 46.79 | 46.65 | 46.68 | 69000.0 |
| 2001-05-03 18:00:00 | QQQ | ETF | 46.75 | 46.79 | 46.69 | 46.78 | 3800.0 |
| 2001-05-03 09:00:00 | IWM | ETF | 48.575 | 48.575 | 48.3 | 48.45 | 220400.0 |
| 2001-05-03 10:00:00 | IWM | ETF | 48.425 | 48.5 | 48.15 | 48.475 | 13600.0 |
| 2001-05-03 11:00:00 | IWM | ETF | 48.475 | 48.475 | 48.375 | 48.375 | 7400.0 |
| 2001-05-03 12:00:00 | IWM | ETF | 48.225 | 48.45 | 48.225 | 48.43 | 5000.0 |
| 2001-05-03 13:00:00 | IWM | ETF | 48.425 | 48.575 | 48.42 | 48.575 | 22200.0 |
| 2001-05-03 14:00:00 | IWM | ETF | 48.39 | 48.5 | 48.35 | 48.425 | 16000.0 |
| 2001-05-03 15:00:00 | IWM | ETF | 48.4 | 48.625 | 48.31 | 48.455 | 77000.0 |
| 2001-05-03 16:00:00 | IWM | ETF | 48.375 | 48.375 | 48.3 | 48.37 | 8000.0 |
| 2001-05-03 09:00:00 | DIA | ETF | 108.0 | 108.15 | 107.75 | 107.78 | 578200.0 |
| 2001-05-03 10:00:00 | DIA | ETF | 107.85 | 107.95 | 107.27 | 107.67 | 878000.0 |
| 2001-05-03 11:00:00 | DIA | ETF | 107.68 | 107.74 | 107.27 | 107.55 | 318900.0 |
| 2001-05-03 12:00:00 | DIA | ETF | 107.51 | 107.75 | 107.42 | 107.54 | 109500.0 |
| 2001-05-03 13:00:00 | DIA | ETF | 107.54 | 107.88 | 107.31 | 107.83 | 240500.0 |
| 2001-05-03 14:00:00 | DIA | ETF | 107.71 | 107.79 | 107.4 | 107.67 | 169600.0 |
| 2001-05-03 15:00:00 | DIA | ETF | 107.61 | 108.19 | 107.55 | 108.14 | 563100.0 |
| 2001-05-03 16:00:00 | DIA | ETF | 108.11 | 108.15 | 107.95 | 108.14 | 78000.0 |
| 2001-05-03 17:00:00 | DIA | ETF | 108.06 | 108.06 | 108.06 | 108.06 | 100.0 |
| 2001-05-03 18:00:00 | DIA | ETF | 108.05 | 108.05 | 108.05 | 108.05 | 200.0 |
> showing 37 of 226 rows — these rows as CSV