PREVIEW / etf_1hour / 2003-03-12
file: by_date/etf_1hour/2003/2003-03-12.parquet size: 17 KB rows: 395
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 |
|---|---|---|---|---|---|---|---|
| 2003-03-12 08:00:00 | SPY | ETF | 80.6 | 81.1 | 79.81 | 80.3 | 229600.0 |
| 2003-03-12 09:00:00 | SPY | ETF | 80.23 | 80.79 | 80.2 | 80.35 | 6716300.0 |
| 2003-03-12 10:00:00 | SPY | ETF | 80.36 | 80.48 | 79.9 | 80.08 | 9280500.0 |
| 2003-03-12 11:00:00 | SPY | ETF | 80.07 | 80.23 | 79.66 | 79.77 | 5772700.0 |
| 2003-03-12 12:00:00 | SPY | ETF | 79.75 | 79.84 | 79.42 | 79.64 | 7714200.0 |
| 2003-03-12 13:00:00 | SPY | ETF | 79.62 | 79.88 | 79.38 | 79.86 | 4828400.0 |
| 2003-03-12 14:00:00 | SPY | ETF | 79.88 | 80.6 | 79.65 | 80.5 | 8608000.0 |
| 2003-03-12 15:00:00 | SPY | ETF | 80.51 | 81.01 | 80.15 | 80.97 | 13420600.0 |
| 2003-03-12 16:00:00 | SPY | ETF | 80.98 | 81.15 | 80.49 | 81.1 | 2297000.0 |
| 2003-03-12 17:00:00 | SPY | ETF | 81.05 | 81.2 | 81.05 | 81.19 | 30000.0 |
| 2003-03-12 18:00:00 | SPY | ETF | 81.18 | 81.2 | 81.1 | 81.1 | 7600.0 |
| 2003-03-12 19:00:00 | SPY | ETF | 81.18 | 81.21 | 81.13 | 81.2 | 7700.0 |
| 2003-03-12 08:00:00 | QQQ | ETF | 23.77 | 24.0 | 23.56 | 23.7 | 238800.0 |
| 2003-03-12 09:00:00 | QQQ | ETF | 23.7 | 24.08 | 23.7 | 23.91 | 11003400.0 |
| 2003-03-12 10:00:00 | QQQ | ETF | 23.92 | 23.97 | 23.76 | 23.79 | 10585500.0 |
| 2003-03-12 11:00:00 | QQQ | ETF | 23.78 | 23.88 | 23.63 | 23.68 | 7721900.0 |
| 2003-03-12 12:00:00 | QQQ | ETF | 23.67 | 23.73 | 23.55 | 23.63 | 9478000.0 |
| 2003-03-12 13:00:00 | QQQ | ETF | 23.62 | 23.74 | 23.54 | 23.74 | 6252500.0 |
| 2003-03-12 14:00:00 | QQQ | ETF | 23.74 | 24.02 | 23.65 | 23.99 | 10931600.0 |
| 2003-03-12 15:00:00 | QQQ | ETF | 24.02 | 24.18 | 23.86 | 24.16 | 13572900.0 |
| 2003-03-12 16:00:00 | QQQ | ETF | 24.14 | 24.25 | 24.14 | 24.23 | 5062100.0 |
| 2003-03-12 17:00:00 | QQQ | ETF | 24.21 | 24.25 | 24.19 | 24.25 | 116000.0 |
| 2003-03-12 18:00:00 | QQQ | ETF | 24.25 | 24.25 | 24.2 | 24.24 | 87900.0 |
| 2003-03-12 19:00:00 | QQQ | ETF | 24.23 | 24.29 | 24.22 | 24.28 | 63700.0 |
| 2003-03-12 08:00:00 | IWM | ETF | 34.5 | 34.59 | 34.5 | 34.59 | 1600.0 |
| 2003-03-12 09:00:00 | IWM | ETF | 34.44 | 34.54 | 34.33 | 34.33 | 514600.0 |
| 2003-03-12 10:00:00 | IWM | ETF | 34.33 | 34.34 | 34.155 | 34.205 | 1094200.0 |
| 2003-03-12 11:00:00 | IWM | ETF | 34.225 | 34.26 | 34.16 | 34.185 | 314200.0 |
| 2003-03-12 12:00:00 | IWM | ETF | 34.175 | 34.205 | 34.115 | 34.155 | 272800.0 |
| 2003-03-12 13:00:00 | IWM | ETF | 34.155 | 34.205 | 34.13 | 34.19 | 675600.0 |
| 2003-03-12 14:00:00 | IWM | ETF | 34.195 | 34.39 | 34.175 | 34.39 | 419200.0 |
| 2003-03-12 15:00:00 | IWM | ETF | 34.345 | 34.53 | 34.255 | 34.45 | 1294800.0 |
| 2003-03-12 16:00:00 | IWM | ETF | 34.54 | 34.54 | 34.355 | 34.355 | 61200.0 |
| 2003-03-12 08:00:00 | DIA | ETF | 75.34 | 76.18 | 74.88 | 75.19 | 21300.0 |
| 2003-03-12 09:00:00 | DIA | ETF | 75.15 | 75.65 | 75.1 | 75.28 | 1403100.0 |
| 2003-03-12 10:00:00 | DIA | ETF | 75.26 | 75.33 | 74.91 | 75.09 | 1624600.0 |
| 2003-03-12 11:00:00 | DIA | ETF | 75.08 | 75.16 | 74.68 | 74.78 | 1492800.0 |
| 2003-03-12 12:00:00 | DIA | ETF | 74.75 | 74.82 | 74.44 | 74.65 | 1062400.0 |
| 2003-03-12 13:00:00 | DIA | ETF | 74.64 | 74.8 | 74.31 | 74.79 | 941000.0 |
| 2003-03-12 14:00:00 | DIA | ETF | 74.79 | 75.35 | 74.52 | 75.3 | 1033800.0 |
| 2003-03-12 15:00:00 | DIA | ETF | 75.28 | 75.71 | 74.85 | 75.68 | 1794500.0 |
| 2003-03-12 16:00:00 | DIA | ETF | 75.68 | 75.85 | 75.64 | 75.85 | 237500.0 |
| 2003-03-12 17:00:00 | DIA | ETF | 75.76 | 75.84 | 75.72 | 75.84 | 11600.0 |
| 2003-03-12 18:00:00 | DIA | ETF | 75.83 | 75.91 | 75.82 | 75.87 | 2100.0 |
| 2003-03-12 19:00:00 | DIA | ETF | 75.88 | 75.88 | 75.81 | 75.81 | 400.0 |
| 2003-03-12 09:00:00 | TLT | ETF | 90.92 | 91.0 | 90.88 | 90.88 | 6100.0 |
| 2003-03-12 10:00:00 | TLT | ETF | 90.89 | 91.14 | 90.89 | 91.14 | 88800.0 |
| 2003-03-12 11:00:00 | TLT | ETF | 91.1 | 91.15 | 90.96 | 91.14 | 28200.0 |
| 2003-03-12 12:00:00 | TLT | ETF | 91.15 | 91.19 | 91.12 | 91.12 | 4300.0 |
| 2003-03-12 13:00:00 | TLT | ETF | 91.15 | 91.36 | 91.15 | 91.22 | 30900.0 |
> showing 50 of 395 rows — these rows as CSV