PREVIEW / etf_30min / 2005-04-14
file: by_date/etf_30min/2005/2005-04-14.parquet size: 47 KB rows: 1,570
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 |
|---|---|---|---|---|---|---|---|
| 2005-04-14 07:00:00 | SPY | ETF | 117.43 | 117.44 | 117.33 | 117.43 | 98100.0 |
| 2005-04-14 07:30:00 | SPY | ETF | 117.43 | 117.45 | 117.4 | 117.41 | 55300.0 |
| 2005-04-14 08:00:00 | SPY | ETF | 117.36 | 117.43 | 117.35 | 117.43 | 18400.0 |
| 2005-04-14 08:30:00 | SPY | ETF | 117.42 | 117.47 | 117.35 | 117.46 | 31500.0 |
| 2005-04-14 09:00:00 | SPY | ETF | 117.45 | 117.5 | 117.42 | 117.42 | 115600.0 |
| 2005-04-14 09:30:00 | SPY | ETF | 117.44 | 117.5 | 117.17 | 117.38 | 7018700.0 |
| 2005-04-14 10:00:00 | SPY | ETF | 117.37 | 117.371 | 116.88 | 116.96 | 11106300.0 |
| 2005-04-14 10:30:00 | SPY | ETF | 116.95 | 117.16 | 116.6 | 117.11 | 7626900.0 |
| 2005-04-14 11:00:00 | SPY | ETF | 117.11 | 117.35 | 117.02 | 117.1 | 5129500.0 |
| 2005-04-14 11:30:00 | SPY | ETF | 117.1 | 117.23 | 116.95 | 117.0 | 3748000.0 |
| 2005-04-14 12:00:00 | SPY | ETF | 116.96 | 117.04 | 116.79 | 116.85 | 5331600.0 |
| 2005-04-14 12:30:00 | SPY | ETF | 116.85 | 117.03 | 116.76 | 116.85 | 3450900.0 |
| 2005-04-14 13:00:00 | SPY | ETF | 116.86 | 117.0 | 116.41 | 116.43 | 7179900.0 |
| 2005-04-14 13:30:00 | SPY | ETF | 116.44 | 116.69 | 116.24 | 116.6 | 12164700.0 |
| 2005-04-14 14:00:00 | SPY | ETF | 116.6 | 116.99 | 116.5 | 116.86 | 7423800.0 |
| 2005-04-14 14:30:00 | SPY | ETF | 116.86 | 116.98 | 116.56 | 116.7 | 4884200.0 |
| 2005-04-14 15:00:00 | SPY | ETF | 116.69 | 116.74 | 116.45 | 116.63 | 3651600.0 |
| 2005-04-14 15:30:00 | SPY | ETF | 116.63 | 116.78 | 116.13 | 116.2 | 9822500.0 |
| 2005-04-14 16:00:00 | SPY | ETF | 116.19 | 116.24 | 115.7 | 115.8 | 3185100.0 |
| 2005-04-14 16:30:00 | SPY | ETF | 115.77 | 115.77 | 115.52 | 115.54 | 1450400.0 |
| 2005-04-14 17:00:00 | SPY | ETF | 115.54 | 115.78 | 115.38 | 115.53 | 711300.0 |
| 2005-04-14 17:30:00 | SPY | ETF | 115.53 | 115.56 | 115.4 | 115.55 | 937500.0 |
| 2005-04-14 18:00:00 | SPY | ETF | 115.6 | 115.61 | 115.5 | 115.57 | 324400.0 |
| 2005-04-14 18:30:00 | SPY | ETF | 115.62 | 115.62 | 115.62 | 115.62 | 1000.0 |
| 2005-04-14 19:00:00 | SPY | ETF | 115.61 | 115.63 | 115.61 | 115.63 | 300.0 |
| 2005-04-14 19:30:00 | SPY | ETF | 115.65 | 115.67 | 115.63 | 115.63 | 3100.0 |
| 2005-04-14 09:30:00 | QQQ | ETF | 36.06 | 36.08 | 35.92 | 36.02 | 16182700.0 |
| 2005-04-14 10:00:00 | QQQ | ETF | 36.02 | 36.03 | 35.67 | 35.75 | 26320200.0 |
| 2005-04-14 10:30:00 | QQQ | ETF | 35.75 | 35.85 | 35.66 | 35.83 | 15276400.0 |
| 2005-04-14 11:00:00 | QQQ | ETF | 35.83 | 35.93 | 35.78 | 35.85 | 7001400.0 |
| 2005-04-14 11:30:00 | QQQ | ETF | 35.84 | 35.9 | 35.75 | 35.75 | 5240500.0 |
| 2005-04-14 12:00:00 | QQQ | ETF | 35.75 | 35.82 | 35.7 | 35.72 | 4892600.0 |
| 2005-04-14 12:30:00 | QQQ | ETF | 35.73 | 35.8 | 35.7 | 35.74 | 5446200.0 |
| 2005-04-14 13:00:00 | QQQ | ETF | 35.75 | 35.9 | 35.59 | 35.59 | 12868700.0 |
| 2005-04-14 13:30:00 | QQQ | ETF | 35.59 | 35.7 | 35.5 | 35.66 | 11708800.0 |
| 2005-04-14 14:00:00 | QQQ | ETF | 35.67 | 35.79 | 35.63 | 35.75 | 10131400.0 |
| 2005-04-14 14:30:00 | QQQ | ETF | 35.75 | 35.75 | 35.63 | 35.71 | 8100200.0 |
| 2005-04-14 15:00:00 | QQQ | ETF | 35.71 | 36.55 | 35.59 | 35.67 | 9066000.0 |
| 2005-04-14 15:30:00 | QQQ | ETF | 35.66 | 35.7 | 35.5 | 35.56 | 11915400.0 |
| 2005-04-14 07:00:00 | IWM | ETF | 59.81 | 59.84 | 59.81 | 59.84 | 3000.0 |
| 2005-04-14 07:30:00 | IWM | ETF | 59.84 | 59.87 | 59.84 | 59.87 | 1800.0 |
| 2005-04-14 08:30:00 | IWM | ETF | 59.865 | 59.88 | 59.86 | 59.88 | 21600.0 |
| 2005-04-14 09:00:00 | IWM | ETF | 59.88 | 59.88 | 59.85 | 59.85 | 32000.0 |
| 2005-04-14 09:30:00 | IWM | ETF | 59.865 | 60.125 | 59.625 | 60.035 | 5683200.0 |
| 2005-04-14 10:00:00 | IWM | ETF | 60.015 | 60.02 | 59.56 | 59.705 | 4120600.0 |
| 2005-04-14 10:30:00 | IWM | ETF | 59.7 | 59.72 | 59.44 | 59.615 | 4490400.0 |
| 2005-04-14 11:00:00 | IWM | ETF | 59.61 | 59.815 | 59.595 | 59.64 | 1967600.0 |
| 2005-04-14 11:30:00 | IWM | ETF | 59.64 | 59.7 | 59.545 | 59.55 | 1010000.0 |
| 2005-04-14 12:00:00 | IWM | ETF | 59.545 | 59.63 | 59.46 | 59.495 | 425400.0 |
| 2005-04-14 12:30:00 | IWM | ETF | 59.49 | 59.615 | 59.34 | 59.395 | 1303400.0 |
> showing 50 of 1,570 rows — these rows as CSV