PREVIEW / etf_30min / 2002-04-04
file: by_date/etf_30min/2002/2002-04-04.parquet size: 18 KB rows: 469
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-04-04 09:30:00 | SPY | ETF | 112.6 | 113.07 | 112.35 | 112.87 | 4085000.0 |
| 2002-04-04 10:00:00 | SPY | ETF | 112.84 | 113.4 | 112.67 | 113.18 | 4357400.0 |
| 2002-04-04 10:30:00 | SPY | ETF | 113.17 | 113.35 | 112.84 | 112.89 | 1178200.0 |
| 2002-04-04 11:00:00 | SPY | ETF | 112.9 | 112.95 | 112.62 | 112.79 | 2331900.0 |
| 2002-04-04 11:30:00 | SPY | ETF | 112.79 | 113.05 | 112.62 | 112.85 | 1539900.0 |
| 2002-04-04 12:00:00 | SPY | ETF | 112.88 | 113.14 | 112.76 | 113.13 | 485500.0 |
| 2002-04-04 12:30:00 | SPY | ETF | 113.14 | 113.14 | 112.7 | 112.71 | 336000.0 |
| 2002-04-04 13:00:00 | SPY | ETF | 112.73 | 112.87 | 112.45 | 112.46 | 727100.0 |
| 2002-04-04 13:30:00 | SPY | ETF | 112.46 | 112.63 | 112.32 | 112.6 | 862100.0 |
| 2002-04-04 14:00:00 | SPY | ETF | 112.63 | 112.73 | 112.37 | 112.6 | 1616700.0 |
| 2002-04-04 14:30:00 | SPY | ETF | 112.57 | 112.8 | 112.32 | 112.5 | 1174800.0 |
| 2002-04-04 15:00:00 | SPY | ETF | 112.49 | 112.64 | 112.23 | 112.5 | 1213300.0 |
| 2002-04-04 15:30:00 | SPY | ETF | 112.49 | 112.99 | 112.42 | 112.89 | 2188800.0 |
| 2002-04-04 16:00:00 | SPY | ETF | 112.94 | 112.94 | 112.66 | 112.8 | 1116600.0 |
| 2002-04-04 16:30:00 | SPY | ETF | 112.94 | 112.94 | 112.79 | 112.79 | 3600.0 |
| 2002-04-04 17:00:00 | SPY | ETF | 112.78 | 112.78 | 112.7 | 112.7 | 6500.0 |
| 2002-04-04 17:30:00 | SPY | ETF | 112.73 | 112.75 | 112.71 | 112.75 | 12000.0 |
| 2002-04-04 18:00:00 | SPY | ETF | 112.66 | 112.67 | 112.66 | 112.67 | 400.0 |
| 2002-04-04 09:30:00 | QQQ | ETF | 34.5 | 34.88 | 34.36 | 34.78 | 16500900.0 |
| 2002-04-04 10:00:00 | QQQ | ETF | 34.78 | 35.09 | 34.6 | 34.96 | 13011100.0 |
| 2002-04-04 10:30:00 | QQQ | ETF | 34.96 | 35.16 | 34.85 | 34.91 | 6980400.0 |
| 2002-04-04 11:00:00 | QQQ | ETF | 34.9 | 34.93 | 34.6 | 34.65 | 8974200.0 |
| 2002-04-04 11:30:00 | QQQ | ETF | 34.63 | 34.79 | 34.54 | 34.68 | 3826100.0 |
| 2002-04-04 12:00:00 | QQQ | ETF | 34.63 | 34.85 | 34.58 | 34.8 | 2398100.0 |
| 2002-04-04 12:30:00 | QQQ | ETF | 34.8 | 34.84 | 34.6 | 34.62 | 1536900.0 |
| 2002-04-04 13:00:00 | QQQ | ETF | 34.61 | 34.76 | 34.55 | 34.56 | 2066100.0 |
| 2002-04-04 13:30:00 | QQQ | ETF | 34.56 | 34.69 | 34.47 | 34.6 | 5866500.0 |
| 2002-04-04 14:00:00 | QQQ | ETF | 34.6 | 34.7 | 34.5 | 34.58 | 2974600.0 |
| 2002-04-04 14:30:00 | QQQ | ETF | 34.57 | 34.67 | 34.33 | 34.45 | 4090400.0 |
| 2002-04-04 15:00:00 | QQQ | ETF | 34.45 | 34.57 | 34.28 | 34.5 | 6918900.0 |
| 2002-04-04 15:30:00 | QQQ | ETF | 34.5 | 34.84 | 34.44 | 34.76 | 10194000.0 |
| 2002-04-04 16:00:00 | QQQ | ETF | 34.75 | 34.82 | 34.72 | 34.79 | 2573300.0 |
| 2002-04-04 16:30:00 | QQQ | ETF | 34.8 | 34.82 | 34.7 | 34.7 | 95400.0 |
| 2002-04-04 17:00:00 | QQQ | ETF | 34.74 | 34.77 | 34.66 | 34.67 | 577200.0 |
| 2002-04-04 17:30:00 | QQQ | ETF | 34.67 | 34.68 | 34.63 | 34.63 | 40600.0 |
| 2002-04-04 18:00:00 | QQQ | ETF | 34.65 | 34.8 | 34.63 | 34.65 | 9900.0 |
| 2002-04-04 09:30:00 | IWM | ETF | 49.2 | 49.52 | 49.175 | 49.43 | 149200.0 |
| 2002-04-04 10:00:00 | IWM | ETF | 49.52 | 49.67 | 49.35 | 49.59 | 186400.0 |
| 2002-04-04 10:30:00 | IWM | ETF | 49.515 | 49.64 | 49.515 | 49.57 | 135600.0 |
| 2002-04-04 11:00:00 | IWM | ETF | 49.57 | 49.57 | 49.44 | 49.495 | 92200.0 |
| 2002-04-04 11:30:00 | IWM | ETF | 49.495 | 49.535 | 49.4 | 49.5 | 72600.0 |
| 2002-04-04 12:00:00 | IWM | ETF | 49.495 | 49.575 | 49.495 | 49.575 | 144200.0 |
| 2002-04-04 12:30:00 | IWM | ETF | 49.595 | 49.595 | 49.52 | 49.52 | 58200.0 |
| 2002-04-04 13:00:00 | IWM | ETF | 49.52 | 49.555 | 49.47 | 49.525 | 146200.0 |
| 2002-04-04 13:30:00 | IWM | ETF | 49.43 | 49.5 | 49.355 | 49.45 | 181200.0 |
| 2002-04-04 14:00:00 | IWM | ETF | 49.465 | 49.475 | 49.39 | 49.425 | 70800.0 |
| 2002-04-04 14:30:00 | IWM | ETF | 49.485 | 49.505 | 49.35 | 49.355 | 61600.0 |
| 2002-04-04 15:00:00 | IWM | ETF | 49.4 | 49.415 | 49.32 | 49.41 | 130800.0 |
| 2002-04-04 15:30:00 | IWM | ETF | 49.4 | 49.685 | 49.4 | 49.685 | 594000.0 |
| 2002-04-04 16:00:00 | IWM | ETF | 49.625 | 49.65 | 49.62 | 49.62 | 55400.0 |
> showing 50 of 469 rows — these rows as CSV