PREVIEW / etf_1hour / 2001-12-03
file: by_date/etf_1hour/2001/2001-12-03.parquet size: 13 KB rows: 265
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-12-03 09:00:00 | SPY | ETF | 113.65 | 113.77 | 113.3 | 113.49 | 2109700.0 |
| 2001-12-03 10:00:00 | SPY | ETF | 113.38 | 113.78 | 113.01 | 113.45 | 3340200.0 |
| 2001-12-03 11:00:00 | SPY | ETF | 113.45 | 113.72 | 113.04 | 113.6 | 3075600.0 |
| 2001-12-03 12:00:00 | SPY | ETF | 113.6 | 113.91 | 113.35 | 113.87 | 698700.0 |
| 2001-12-03 13:00:00 | SPY | ETF | 113.87 | 114.08 | 113.7 | 113.7 | 1157000.0 |
| 2001-12-03 14:00:00 | SPY | ETF | 113.67 | 113.84 | 113.35 | 113.5 | 1233000.0 |
| 2001-12-03 15:00:00 | SPY | ETF | 113.46 | 113.75 | 113.21 | 113.42 | 2344900.0 |
| 2001-12-03 16:00:00 | SPY | ETF | 113.36 | 113.99 | 113.25 | 113.27 | 1252200.0 |
| 2001-12-03 09:00:00 | QQQ | ETF | 39.29 | 39.6 | 39.19 | 39.27 | 10751600.0 |
| 2001-12-03 10:00:00 | QQQ | ETF | 39.23 | 39.5 | 38.9 | 39.19 | 16062800.0 |
| 2001-12-03 11:00:00 | QQQ | ETF | 39.17 | 39.32 | 38.87 | 39.24 | 7064600.0 |
| 2001-12-03 12:00:00 | QQQ | ETF | 39.24 | 39.41 | 39.05 | 39.39 | 4228000.0 |
| 2001-12-03 13:00:00 | QQQ | ETF | 39.4 | 39.51 | 39.21 | 39.22 | 5978500.0 |
| 2001-12-03 14:00:00 | QQQ | ETF | 39.23 | 39.29 | 39.05 | 39.13 | 5385700.0 |
| 2001-12-03 15:00:00 | QQQ | ETF | 39.14 | 39.25 | 38.95 | 39.02 | 8502700.0 |
| 2001-12-03 16:00:00 | QQQ | ETF | 39.03 | 39.1 | 38.91 | 38.95 | 2037900.0 |
| 2001-12-03 17:00:00 | QQQ | ETF | 38.97 | 39.03 | 38.95 | 38.98 | 46200.0 |
| 2001-12-03 18:00:00 | QQQ | ETF | 39.0 | 39.0 | 38.89 | 38.9 | 57900.0 |
| 2001-12-03 09:00:00 | IWM | ETF | 45.45 | 45.65 | 45.45 | 45.65 | 14200.0 |
| 2001-12-03 10:00:00 | IWM | ETF | 45.4 | 45.575 | 45.35 | 45.5 | 16800.0 |
| 2001-12-03 11:00:00 | IWM | ETF | 45.375 | 45.6 | 45.345 | 45.6 | 57200.0 |
| 2001-12-03 12:00:00 | IWM | ETF | 45.4 | 45.575 | 45.385 | 45.575 | 20400.0 |
| 2001-12-03 13:00:00 | IWM | ETF | 45.5 | 45.705 | 45.455 | 45.675 | 20400.0 |
| 2001-12-03 14:00:00 | IWM | ETF | 45.65 | 45.65 | 45.5 | 45.6 | 8600.0 |
| 2001-12-03 15:00:00 | IWM | ETF | 45.525 | 45.635 | 45.45 | 45.525 | 37400.0 |
| 2001-12-03 16:00:00 | IWM | ETF | 45.525 | 45.525 | 45.275 | 45.5 | 34800.0 |
| 2001-12-03 09:00:00 | DIA | ETF | 98.1 | 98.1 | 97.55 | 97.63 | 294400.0 |
| 2001-12-03 10:00:00 | DIA | ETF | 97.59 | 97.79 | 97.21 | 97.5 | 564900.0 |
| 2001-12-03 11:00:00 | DIA | ETF | 97.51 | 97.78 | 97.26 | 97.65 | 221300.0 |
| 2001-12-03 12:00:00 | DIA | ETF | 97.74 | 97.92 | 97.5 | 97.92 | 91100.0 |
| 2001-12-03 13:00:00 | DIA | ETF | 97.85 | 98.0 | 97.77 | 97.81 | 123900.0 |
| 2001-12-03 14:00:00 | DIA | ETF | 97.86 | 97.99 | 97.62 | 97.75 | 232300.0 |
| 2001-12-03 15:00:00 | DIA | ETF | 97.65 | 98.0 | 97.53 | 97.77 | 167900.0 |
| 2001-12-03 16:00:00 | DIA | ETF | 97.7 | 97.8 | 97.67 | 97.8 | 32600.0 |
> showing 34 of 265 rows — these rows as CSV