PREVIEW / etf_30min / 2003-04-29
file: by_date/etf_30min/2003/2003-04-29.parquet size: 23 KB rows: 678
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-04-29 08:00:00 | SPY | ETF | 92.1 | 92.1 | 91.91 | 91.92 | 11300.0 |
| 2003-04-29 08:30:00 | SPY | ETF | 91.9 | 92.15 | 91.87 | 92.1 | 25600.0 |
| 2003-04-29 09:00:00 | SPY | ETF | 92.07 | 92.17 | 92.07 | 92.14 | 10000.0 |
| 2003-04-29 09:30:00 | SPY | ETF | 92.14 | 92.4 | 91.94 | 92.32 | 5161300.0 |
| 2003-04-29 10:00:00 | SPY | ETF | 92.32 | 92.8 | 92.1 | 92.19 | 8214000.0 |
| 2003-04-29 10:30:00 | SPY | ETF | 92.19 | 92.35 | 91.4 | 91.61 | 7904500.0 |
| 2003-04-29 11:00:00 | SPY | ETF | 91.59 | 91.79 | 91.44 | 91.68 | 2040900.0 |
| 2003-04-29 11:30:00 | SPY | ETF | 91.7 | 92.02 | 91.6 | 91.94 | 2513400.0 |
| 2003-04-29 12:00:00 | SPY | ETF | 91.94 | 92.04 | 91.68 | 91.84 | 1069600.0 |
| 2003-04-29 12:30:00 | SPY | ETF | 91.82 | 92.04 | 91.68 | 91.86 | 1522400.0 |
| 2003-04-29 13:00:00 | SPY | ETF | 91.89 | 92.15 | 91.78 | 91.92 | 2036100.0 |
| 2003-04-29 13:30:00 | SPY | ETF | 91.93 | 91.93 | 91.51 | 91.67 | 2569800.0 |
| 2003-04-29 14:00:00 | SPY | ETF | 91.67 | 91.8 | 91.55 | 91.69 | 1581700.0 |
| 2003-04-29 14:30:00 | SPY | ETF | 91.69 | 92.1 | 91.55 | 92.04 | 1838000.0 |
| 2003-04-29 15:00:00 | SPY | ETF | 92.03 | 92.42 | 92.0 | 92.38 | 3545000.0 |
| 2003-04-29 15:30:00 | SPY | ETF | 92.39 | 92.48 | 92.02 | 92.1 | 3555900.0 |
| 2003-04-29 16:00:00 | SPY | ETF | 92.11 | 92.21 | 92.02 | 92.03 | 3429800.0 |
| 2003-04-29 16:30:00 | SPY | ETF | 92.03 | 92.09 | 92.0 | 92.0 | 34300.0 |
| 2003-04-29 17:00:00 | SPY | ETF | 92.01 | 92.06 | 91.96 | 92.01 | 162700.0 |
| 2003-04-29 17:30:00 | SPY | ETF | 92.04 | 92.04 | 91.96 | 91.96 | 263000.0 |
| 2003-04-29 18:00:00 | SPY | ETF | 91.98 | 92.02 | 91.98 | 92.02 | 4200.0 |
| 2003-04-29 18:30:00 | SPY | ETF | 91.96 | 91.99 | 91.96 | 91.99 | 6400.0 |
| 2003-04-29 19:00:00 | SPY | ETF | 92.0 | 92.07 | 92.0 | 92.07 | 500.0 |
| 2003-04-29 19:30:00 | SPY | ETF | 91.99 | 92.0 | 91.98 | 92.0 | 3700.0 |
| 2003-04-29 08:00:00 | QQQ | ETF | 27.58 | 27.6 | 27.54 | 27.57 | 65100.0 |
| 2003-04-29 08:30:00 | QQQ | ETF | 27.57 | 27.64 | 27.55 | 27.61 | 27800.0 |
| 2003-04-29 09:00:00 | QQQ | ETF | 27.62 | 27.66 | 27.61 | 27.65 | 137400.0 |
| 2003-04-29 09:30:00 | QQQ | ETF | 27.64 | 27.86 | 27.62 | 27.83 | 10742200.0 |
| 2003-04-29 10:00:00 | QQQ | ETF | 27.84 | 28.06 | 27.77 | 27.79 | 14333400.0 |
| 2003-04-29 10:30:00 | QQQ | ETF | 27.8 | 27.85 | 27.42 | 27.53 | 9942100.0 |
| 2003-04-29 11:00:00 | QQQ | ETF | 27.53 | 27.62 | 27.45 | 27.57 | 4299000.0 |
| 2003-04-29 11:30:00 | QQQ | ETF | 27.57 | 27.73 | 27.56 | 27.69 | 3255000.0 |
| 2003-04-29 12:00:00 | QQQ | ETF | 27.69 | 27.74 | 27.6 | 27.65 | 2406900.0 |
| 2003-04-29 12:30:00 | QQQ | ETF | 27.66 | 27.72 | 27.57 | 27.67 | 2026400.0 |
| 2003-04-29 13:00:00 | QQQ | ETF | 27.66 | 27.73 | 27.61 | 27.64 | 2629200.0 |
| 2003-04-29 13:30:00 | QQQ | ETF | 27.63 | 27.66 | 27.51 | 27.59 | 2334700.0 |
| 2003-04-29 14:00:00 | QQQ | ETF | 27.58 | 27.64 | 27.55 | 27.6 | 2156400.0 |
| 2003-04-29 14:30:00 | QQQ | ETF | 27.59 | 27.77 | 27.55 | 27.75 | 3538600.0 |
| 2003-04-29 15:00:00 | QQQ | ETF | 27.75 | 27.89 | 27.73 | 27.87 | 5142200.0 |
| 2003-04-29 15:30:00 | QQQ | ETF | 27.87 | 27.93 | 27.7 | 27.75 | 6653600.0 |
| 2003-04-29 16:00:00 | QQQ | ETF | 27.74 | 27.76 | 27.68 | 27.71 | 5500500.0 |
| 2003-04-29 16:30:00 | QQQ | ETF | 27.7 | 27.75 | 27.69 | 27.74 | 430000.0 |
| 2003-04-29 17:00:00 | QQQ | ETF | 27.74 | 27.74 | 27.71 | 27.71 | 42500.0 |
| 2003-04-29 17:30:00 | QQQ | ETF | 27.73 | 27.76 | 27.72 | 27.74 | 58500.0 |
| 2003-04-29 18:00:00 | QQQ | ETF | 27.74 | 27.75 | 27.74 | 27.74 | 11700.0 |
| 2003-04-29 18:30:00 | QQQ | ETF | 27.75 | 27.78 | 27.75 | 27.77 | 1300.0 |
| 2003-04-29 19:00:00 | QQQ | ETF | 27.77 | 27.78 | 27.77 | 27.78 | 9400.0 |
| 2003-04-29 19:30:00 | QQQ | ETF | 27.78 | 27.78 | 27.74 | 27.74 | 10000.0 |
| 2003-04-29 09:30:00 | IWM | ETF | 39.43 | 39.66 | 39.375 | 39.635 | 409200.0 |
| 2003-04-29 10:00:00 | IWM | ETF | 39.675 | 39.775 | 39.565 | 39.615 | 320400.0 |
> showing 50 of 678 rows — these rows as CSV