PREVIEW / etf_1hour / 2002-03-04
file: by_date/etf_1hour/2002/2002-03-04.parquet size: 14 KB rows: 311
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 |
|---|---|---|---|---|---|---|---|
| 2002-03-04 09:00:00 | SPY | ETF | 113.89 | 114.25 | 113.65 | 114.24 | 3839600.0 |
| 2002-03-04 10:00:00 | SPY | ETF | 114.23 | 115.17 | 114.23 | 114.88 | 5408100.0 |
| 2002-03-04 11:00:00 | SPY | ETF | 114.92 | 115.25 | 114.87 | 115.06 | 3120900.0 |
| 2002-03-04 12:00:00 | SPY | ETF | 115.03 | 115.54 | 115.0 | 115.46 | 1542100.0 |
| 2002-03-04 13:00:00 | SPY | ETF | 115.5 | 115.52 | 114.9 | 115.13 | 2966600.0 |
| 2002-03-04 14:00:00 | SPY | ETF | 115.13 | 115.65 | 114.94 | 115.42 | 3337400.0 |
| 2002-03-04 15:00:00 | SPY | ETF | 115.41 | 115.99 | 115.18 | 115.93 | 5043700.0 |
| 2002-03-04 16:00:00 | SPY | ETF | 115.88 | 115.97 | 115.61 | 115.68 | 1272400.0 |
| 2002-03-04 17:00:00 | SPY | ETF | 115.72 | 115.72 | 115.7 | 115.7 | 400.0 |
| 2002-03-04 18:00:00 | SPY | ETF | 115.71 | 115.71 | 115.68 | 115.68 | 3000.0 |
| 2002-03-04 09:00:00 | QQQ | ETF | 35.7 | 35.82 | 35.4 | 35.73 | 13294300.0 |
| 2002-03-04 10:00:00 | QQQ | ETF | 35.72 | 36.77 | 35.67 | 36.56 | 26652700.0 |
| 2002-03-04 11:00:00 | QQQ | ETF | 36.56 | 36.88 | 36.49 | 36.64 | 11555600.0 |
| 2002-03-04 12:00:00 | QQQ | ETF | 36.65 | 37.08 | 36.61 | 37.02 | 8741000.0 |
| 2002-03-04 13:00:00 | QQQ | ETF | 36.98 | 37.07 | 36.55 | 36.77 | 10222100.0 |
| 2002-03-04 14:00:00 | QQQ | ETF | 36.77 | 37.23 | 36.67 | 37.0 | 10354400.0 |
| 2002-03-04 15:00:00 | QQQ | ETF | 37.02 | 37.21 | 36.82 | 37.18 | 17294400.0 |
| 2002-03-04 16:00:00 | QQQ | ETF | 37.2 | 37.23 | 36.35 | 37.17 | 2238200.0 |
| 2002-03-04 17:00:00 | QQQ | ETF | 37.17 | 37.2 | 37.1 | 37.16 | 28200.0 |
| 2002-03-04 18:00:00 | QQQ | ETF | 37.18 | 37.22 | 37.16 | 37.21 | 21400.0 |
| 2002-03-04 09:00:00 | IWM | ETF | 47.75 | 47.92 | 47.625 | 47.875 | 88400.0 |
| 2002-03-04 10:00:00 | IWM | ETF | 47.855 | 48.37 | 47.855 | 48.315 | 249200.0 |
| 2002-03-04 11:00:00 | IWM | ETF | 48.315 | 48.43 | 48.245 | 48.295 | 159600.0 |
| 2002-03-04 12:00:00 | IWM | ETF | 48.365 | 48.54 | 48.255 | 48.42 | 318800.0 |
| 2002-03-04 13:00:00 | IWM | ETF | 48.55 | 48.59 | 48.35 | 48.42 | 104800.0 |
| 2002-03-04 14:00:00 | IWM | ETF | 48.45 | 48.675 | 48.43 | 48.49 | 115200.0 |
| 2002-03-04 15:00:00 | IWM | ETF | 48.49 | 48.74 | 48.49 | 48.645 | 352800.0 |
| 2002-03-04 16:00:00 | IWM | ETF | 48.525 | 48.55 | 48.5 | 48.525 | 11600.0 |
| 2002-03-04 09:00:00 | DIA | ETF | 104.2 | 104.6 | 104.08 | 104.55 | 2613000.0 |
| 2002-03-04 10:00:00 | DIA | ETF | 104.55 | 105.32 | 104.55 | 105.21 | 1646600.0 |
| 2002-03-04 11:00:00 | DIA | ETF | 105.2 | 105.48 | 105.11 | 105.26 | 539800.0 |
| 2002-03-04 12:00:00 | DIA | ETF | 105.26 | 105.7 | 105.16 | 105.64 | 524700.0 |
| 2002-03-04 13:00:00 | DIA | ETF | 105.6 | 105.68 | 105.04 | 105.12 | 414700.0 |
| 2002-03-04 14:00:00 | DIA | ETF | 105.23 | 105.69 | 105.02 | 105.59 | 412200.0 |
| 2002-03-04 15:00:00 | DIA | ETF | 105.62 | 106.25 | 105.35 | 106.11 | 1586500.0 |
| 2002-03-04 16:00:00 | DIA | ETF | 106.12 | 106.15 | 105.75 | 105.75 | 173300.0 |
| 2002-03-04 17:00:00 | DIA | ETF | 106.0 | 106.1 | 106.0 | 106.1 | 1500.0 |
> showing 37 of 311 rows — these rows as CSV