PREVIEW / etf_1hour / 2001-11-13
file: by_date/etf_1hour/2001/2001-11-13.parquet size: 13 KB rows: 279
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-13 09:00:00 | SPY | ETF | 113.44 | 113.72 | 113.23 | 113.24 | 2706200.0 |
| 2001-11-13 10:00:00 | SPY | ETF | 113.25 | 113.86 | 113.18 | 113.7 | 1604700.0 |
| 2001-11-13 11:00:00 | SPY | ETF | 113.68 | 114.1 | 113.67 | 113.88 | 1667800.0 |
| 2001-11-13 12:00:00 | SPY | ETF | 113.9 | 114.26 | 113.7 | 114.15 | 1202400.0 |
| 2001-11-13 13:00:00 | SPY | ETF | 114.12 | 114.43 | 113.71 | 113.93 | 1943100.0 |
| 2001-11-13 14:00:00 | SPY | ETF | 113.99 | 114.11 | 113.58 | 113.79 | 1805600.0 |
| 2001-11-13 15:00:00 | SPY | ETF | 113.77 | 114.4 | 113.72 | 114.39 | 2712700.0 |
| 2001-11-13 16:00:00 | SPY | ETF | 114.39 | 114.63 | 114.25 | 114.6 | 1435700.0 |
| 2001-11-13 17:00:00 | SPY | ETF | 114.6 | 114.6 | 114.4 | 114.53 | 52700.0 |
| 2001-11-13 09:00:00 | QQQ | ETF | 39.03 | 39.25 | 38.75 | 38.77 | 16301500.0 |
| 2001-11-13 10:00:00 | QQQ | ETF | 38.86 | 39.2 | 38.74 | 39.1 | 13233800.0 |
| 2001-11-13 11:00:00 | QQQ | ETF | 39.12 | 39.32 | 39.08 | 39.21 | 8743700.0 |
| 2001-11-13 12:00:00 | QQQ | ETF | 39.21 | 39.42 | 39.06 | 39.37 | 10614000.0 |
| 2001-11-13 13:00:00 | QQQ | ETF | 39.36 | 39.5 | 38.85 | 39.04 | 14616400.0 |
| 2001-11-13 14:00:00 | QQQ | ETF | 39.07 | 39.17 | 38.63 | 38.8 | 15155300.0 |
| 2001-11-13 15:00:00 | QQQ | ETF | 38.8 | 39.37 | 38.72 | 39.34 | 15152300.0 |
| 2001-11-13 16:00:00 | QQQ | ETF | 39.35 | 39.45 | 39.08 | 39.36 | 2961900.0 |
| 2001-11-13 17:00:00 | QQQ | ETF | 39.36 | 39.4 | 39.3 | 39.33 | 166200.0 |
| 2001-11-13 18:00:00 | QQQ | ETF | 39.31 | 39.31 | 39.26 | 39.26 | 77900.0 |
| 2001-11-13 09:00:00 | IWM | ETF | 44.25 | 44.375 | 44.15 | 44.18 | 48000.0 |
| 2001-11-13 10:00:00 | IWM | ETF | 44.175 | 44.45 | 44.125 | 44.355 | 81800.0 |
| 2001-11-13 11:00:00 | IWM | ETF | 44.37 | 44.455 | 44.355 | 44.4 | 28400.0 |
| 2001-11-13 12:00:00 | IWM | ETF | 44.41 | 44.475 | 44.31 | 44.44 | 65200.0 |
| 2001-11-13 13:00:00 | IWM | ETF | 44.405 | 44.545 | 44.3 | 44.39 | 50400.0 |
| 2001-11-13 14:00:00 | IWM | ETF | 44.375 | 44.405 | 44.265 | 44.335 | 33800.0 |
| 2001-11-13 15:00:00 | IWM | ETF | 44.33 | 44.635 | 44.26 | 44.575 | 41200.0 |
| 2001-11-13 16:00:00 | IWM | ETF | 44.625 | 44.675 | 44.625 | 44.675 | 93200.0 |
| 2001-11-13 09:00:00 | DIA | ETF | 96.79 | 97.0 | 96.61 | 96.74 | 1053900.0 |
| 2001-11-13 10:00:00 | DIA | ETF | 96.7 | 97.19 | 96.64 | 97.03 | 570700.0 |
| 2001-11-13 11:00:00 | DIA | ETF | 97.03 | 97.37 | 97.0 | 97.17 | 271500.0 |
| 2001-11-13 12:00:00 | DIA | ETF | 97.2 | 97.62 | 97.04 | 97.5 | 306000.0 |
| 2001-11-13 13:00:00 | DIA | ETF | 97.49 | 97.82 | 97.2 | 97.37 | 440300.0 |
| 2001-11-13 14:00:00 | DIA | ETF | 97.39 | 97.52 | 97.1 | 97.35 | 692800.0 |
| 2001-11-13 15:00:00 | DIA | ETF | 97.34 | 97.79 | 97.28 | 97.79 | 538700.0 |
| 2001-11-13 16:00:00 | DIA | ETF | 97.72 | 98.62 | 97.61 | 97.89 | 144500.0 |
| 2001-11-13 17:00:00 | DIA | ETF | 97.81 | 97.81 | 97.81 | 97.81 | 200.0 |
> showing 36 of 279 rows — these rows as CSV