PREVIEW / etf_30min / 2002-01-25
file: by_date/etf_30min/2002/2002-01-25.parquet size: 17 KB rows: 439
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-01-25 09:30:00 | SPY | ETF | 113.12 | 113.46 | 113.04 | 113.46 | 1942100.0 |
| 2002-01-25 10:00:00 | SPY | ETF | 113.42 | 113.63 | 113.24 | 113.32 | 1011200.0 |
| 2002-01-25 10:30:00 | SPY | ETF | 113.32 | 113.86 | 113.29 | 113.79 | 1597900.0 |
| 2002-01-25 11:00:00 | SPY | ETF | 113.77 | 113.85 | 113.55 | 113.74 | 624700.0 |
| 2002-01-25 11:30:00 | SPY | ETF | 113.74 | 113.77 | 113.41 | 113.45 | 673300.0 |
| 2002-01-25 12:00:00 | SPY | ETF | 113.44 | 113.9 | 113.43 | 113.9 | 416400.0 |
| 2002-01-25 12:30:00 | SPY | ETF | 113.9 | 114.18 | 113.86 | 114.0 | 739100.0 |
| 2002-01-25 13:00:00 | SPY | ETF | 114.0 | 114.07 | 113.9 | 114.0 | 572900.0 |
| 2002-01-25 13:30:00 | SPY | ETF | 113.97 | 114.17 | 113.9 | 113.92 | 522000.0 |
| 2002-01-25 14:00:00 | SPY | ETF | 113.95 | 114.03 | 113.72 | 113.75 | 742600.0 |
| 2002-01-25 14:30:00 | SPY | ETF | 113.75 | 113.8 | 113.62 | 113.69 | 797300.0 |
| 2002-01-25 15:00:00 | SPY | ETF | 113.73 | 113.78 | 113.5 | 113.63 | 497200.0 |
| 2002-01-25 15:30:00 | SPY | ETF | 113.61 | 113.88 | 113.53 | 113.59 | 1127300.0 |
| 2002-01-25 16:00:00 | SPY | ETF | 113.52 | 113.59 | 113.47 | 113.55 | 1441400.0 |
| 2002-01-25 16:30:00 | SPY | ETF | 113.55 | 113.55 | 113.55 | 113.55 | 30000.0 |
| 2002-01-25 09:30:00 | QQQ | ETF | 38.47 | 38.61 | 38.36 | 38.54 | 10002500.0 |
| 2002-01-25 10:00:00 | QQQ | ETF | 38.56 | 38.75 | 38.49 | 38.55 | 8477100.0 |
| 2002-01-25 10:30:00 | QQQ | ETF | 38.55 | 38.7 | 38.46 | 38.65 | 4505000.0 |
| 2002-01-25 11:00:00 | QQQ | ETF | 38.64 | 38.72 | 38.51 | 38.63 | 2471500.0 |
| 2002-01-25 11:30:00 | QQQ | ETF | 38.63 | 38.65 | 38.42 | 38.49 | 2643200.0 |
| 2002-01-25 12:00:00 | QQQ | ETF | 38.49 | 38.83 | 38.46 | 38.81 | 3135600.0 |
| 2002-01-25 12:30:00 | QQQ | ETF | 38.8 | 39.09 | 38.8 | 39.04 | 6394200.0 |
| 2002-01-25 13:00:00 | QQQ | ETF | 39.03 | 39.05 | 38.9 | 38.99 | 2127900.0 |
| 2002-01-25 13:30:00 | QQQ | ETF | 38.97 | 39.15 | 38.95 | 38.99 | 2929800.0 |
| 2002-01-25 14:00:00 | QQQ | ETF | 38.97 | 39.09 | 38.8 | 38.86 | 2542700.0 |
| 2002-01-25 14:30:00 | QQQ | ETF | 38.86 | 38.95 | 38.72 | 38.86 | 3524600.0 |
| 2002-01-25 15:00:00 | QQQ | ETF | 38.87 | 38.91 | 38.65 | 38.75 | 3381500.0 |
| 2002-01-25 15:30:00 | QQQ | ETF | 38.74 | 38.99 | 38.74 | 38.8 | 3873600.0 |
| 2002-01-25 16:00:00 | QQQ | ETF | 38.77 | 38.86 | 38.7 | 38.78 | 1263600.0 |
| 2002-01-25 16:30:00 | QQQ | ETF | 38.77 | 38.84 | 38.77 | 38.8 | 77500.0 |
| 2002-01-25 17:00:00 | QQQ | ETF | 38.8 | 38.8 | 38.8 | 38.8 | 1200.0 |
| 2002-01-25 17:30:00 | QQQ | ETF | 38.8 | 38.81 | 38.8 | 38.8 | 3000.0 |
| 2002-01-25 18:00:00 | QQQ | ETF | 38.85 | 38.85 | 38.81 | 38.85 | 5800.0 |
| 2002-01-25 09:30:00 | IWM | ETF | 47.675 | 47.675 | 47.33 | 47.49 | 64200.0 |
| 2002-01-25 10:00:00 | IWM | ETF | 47.49 | 47.6 | 47.45 | 47.6 | 18200.0 |
| 2002-01-25 10:30:00 | IWM | ETF | 47.575 | 47.585 | 47.5 | 47.57 | 11200.0 |
| 2002-01-25 11:00:00 | IWM | ETF | 47.605 | 47.625 | 47.5 | 47.615 | 251600.0 |
| 2002-01-25 11:30:00 | IWM | ETF | 47.615 | 47.615 | 47.52 | 47.575 | 9000.0 |
| 2002-01-25 12:00:00 | IWM | ETF | 47.575 | 47.575 | 47.51 | 47.575 | 24400.0 |
| 2002-01-25 12:30:00 | IWM | ETF | 47.575 | 47.745 | 47.575 | 47.745 | 16400.0 |
| 2002-01-25 13:00:00 | IWM | ETF | 47.745 | 47.755 | 47.66 | 47.755 | 56400.0 |
| 2002-01-25 13:30:00 | IWM | ETF | 47.755 | 47.785 | 47.7 | 47.755 | 9800.0 |
| 2002-01-25 14:00:00 | IWM | ETF | 47.755 | 47.755 | 47.64 | 47.695 | 4400.0 |
| 2002-01-25 14:30:00 | IWM | ETF | 47.625 | 47.7 | 47.61 | 47.7 | 73800.0 |
| 2002-01-25 15:00:00 | IWM | ETF | 47.68 | 47.7 | 47.5 | 47.58 | 24400.0 |
| 2002-01-25 15:30:00 | IWM | ETF | 47.635 | 47.725 | 47.58 | 47.685 | 116400.0 |
| 2002-01-25 16:00:00 | IWM | ETF | 47.7 | 47.7 | 47.64 | 47.64 | 5800.0 |
| 2002-01-25 17:30:00 | IWM | ETF | 47.64 | 47.64 | 47.64 | 47.64 | 80000.0 |
| 2002-01-25 09:30:00 | DIA | ETF | 97.66 | 98.16 | 97.57 | 98.15 | 171800.0 |
| 2002-01-25 10:00:00 | DIA | ETF | 98.17 | 98.27 | 97.96 | 98.03 | 180100.0 |
> showing 50 of 439 rows — these rows as CSV