PREVIEW / etf_30min / 2002-03-05
file: by_date/etf_30min/2002/2002-03-05.parquet size: 19 KB rows: 508
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-03-05 09:30:00 | SPY | ETF | 115.33 | 115.75 | 115.15 | 115.7 | 2770300.0 |
| 2002-03-05 10:00:00 | SPY | ETF | 115.72 | 116.4 | 115.25 | 115.45 | 4961300.0 |
| 2002-03-05 10:30:00 | SPY | ETF | 115.36 | 115.56 | 114.97 | 115.07 | 2207200.0 |
| 2002-03-05 11:00:00 | SPY | ETF | 115.14 | 115.44 | 115.11 | 115.38 | 1112100.0 |
| 2002-03-05 11:30:00 | SPY | ETF | 115.37 | 115.6 | 115.29 | 115.37 | 714000.0 |
| 2002-03-05 12:00:00 | SPY | ETF | 115.37 | 115.62 | 115.16 | 115.54 | 634100.0 |
| 2002-03-05 12:30:00 | SPY | ETF | 115.51 | 115.92 | 115.51 | 115.57 | 872100.0 |
| 2002-03-05 13:00:00 | SPY | ETF | 115.59 | 115.8 | 115.36 | 115.42 | 689300.0 |
| 2002-03-05 13:30:00 | SPY | ETF | 115.39 | 115.54 | 115.27 | 115.48 | 1179600.0 |
| 2002-03-05 14:00:00 | SPY | ETF | 115.5 | 115.73 | 115.39 | 115.56 | 772200.0 |
| 2002-03-05 14:30:00 | SPY | ETF | 115.55 | 115.6 | 115.07 | 115.19 | 1012800.0 |
| 2002-03-05 15:00:00 | SPY | ETF | 115.19 | 115.55 | 114.97 | 115.55 | 1365800.0 |
| 2002-03-05 15:30:00 | SPY | ETF | 115.48 | 115.55 | 115.09 | 115.21 | 2256700.0 |
| 2002-03-05 16:00:00 | SPY | ETF | 115.22 | 115.43 | 115.1 | 115.3 | 1256200.0 |
| 2002-03-05 16:30:00 | SPY | ETF | 115.3 | 115.33 | 115.3 | 115.3 | 26400.0 |
| 2002-03-05 17:00:00 | SPY | ETF | 115.29 | 115.34 | 115.29 | 115.3 | 1700.0 |
| 2002-03-05 17:30:00 | SPY | ETF | 115.3 | 115.32 | 115.22 | 115.32 | 22700.0 |
| 2002-03-05 18:00:00 | SPY | ETF | 115.17 | 115.17 | 115.17 | 115.17 | 500.0 |
| 2002-03-05 09:30:00 | QQQ | ETF | 36.93 | 37.5 | 36.81 | 37.45 | 14037300.0 |
| 2002-03-05 10:00:00 | QQQ | ETF | 37.46 | 37.87 | 37.05 | 37.21 | 19787600.0 |
| 2002-03-05 10:30:00 | QQQ | ETF | 37.17 | 37.44 | 36.99 | 37.09 | 9627800.0 |
| 2002-03-05 11:00:00 | QQQ | ETF | 37.09 | 37.37 | 37.04 | 37.3 | 5979300.0 |
| 2002-03-05 11:30:00 | QQQ | ETF | 37.28 | 37.43 | 37.21 | 37.21 | 2182900.0 |
| 2002-03-05 12:00:00 | QQQ | ETF | 37.25 | 37.49 | 37.16 | 37.46 | 2423700.0 |
| 2002-03-05 12:30:00 | QQQ | ETF | 37.46 | 37.74 | 37.43 | 37.53 | 5420000.0 |
| 2002-03-05 13:00:00 | QQQ | ETF | 37.54 | 37.64 | 37.32 | 37.33 | 3788900.0 |
| 2002-03-05 13:30:00 | QQQ | ETF | 37.34 | 37.47 | 37.23 | 37.44 | 3875300.0 |
| 2002-03-05 14:00:00 | QQQ | ETF | 37.41 | 37.6 | 37.36 | 37.49 | 3382700.0 |
| 2002-03-05 14:30:00 | QQQ | ETF | 37.48 | 37.5 | 37.15 | 37.19 | 4149600.0 |
| 2002-03-05 15:00:00 | QQQ | ETF | 37.19 | 37.48 | 37.06 | 37.44 | 5567500.0 |
| 2002-03-05 15:30:00 | QQQ | ETF | 37.43 | 37.46 | 37.19 | 37.27 | 5647600.0 |
| 2002-03-05 16:00:00 | QQQ | ETF | 37.29 | 37.57 | 37.13 | 37.37 | 1380500.0 |
| 2002-03-05 16:30:00 | QQQ | ETF | 37.37 | 37.5 | 37.27 | 37.33 | 157000.0 |
| 2002-03-05 17:00:00 | QQQ | ETF | 37.28 | 37.33 | 37.23 | 37.23 | 57200.0 |
| 2002-03-05 17:30:00 | QQQ | ETF | 37.23 | 37.23 | 37.18 | 37.19 | 40400.0 |
| 2002-03-05 18:00:00 | QQQ | ETF | 37.19 | 37.25 | 37.18 | 37.22 | 24700.0 |
| 2002-03-05 09:30:00 | IWM | ETF | 48.49 | 48.645 | 48.435 | 48.645 | 174600.0 |
| 2002-03-05 10:00:00 | IWM | ETF | 48.665 | 48.915 | 48.54 | 48.575 | 206600.0 |
| 2002-03-05 10:30:00 | IWM | ETF | 48.56 | 48.56 | 48.35 | 48.35 | 129600.0 |
| 2002-03-05 11:00:00 | IWM | ETF | 48.355 | 48.475 | 48.355 | 48.475 | 21000.0 |
| 2002-03-05 11:30:00 | IWM | ETF | 48.485 | 48.57 | 48.47 | 48.5 | 9000.0 |
| 2002-03-05 12:00:00 | IWM | ETF | 48.51 | 48.67 | 48.5 | 48.67 | 76000.0 |
| 2002-03-05 12:30:00 | IWM | ETF | 48.645 | 48.775 | 48.645 | 48.645 | 17200.0 |
| 2002-03-05 13:00:00 | IWM | ETF | 48.75 | 48.75 | 48.625 | 48.695 | 145800.0 |
| 2002-03-05 13:30:00 | IWM | ETF | 48.57 | 48.655 | 48.56 | 48.635 | 30600.0 |
| 2002-03-05 14:00:00 | IWM | ETF | 48.6 | 48.69 | 48.6 | 48.69 | 13000.0 |
| 2002-03-05 14:30:00 | IWM | ETF | 48.675 | 48.7 | 48.5 | 48.5 | 76600.0 |
| 2002-03-05 15:00:00 | IWM | ETF | 48.55 | 48.625 | 48.42 | 48.625 | 338000.0 |
| 2002-03-05 15:30:00 | IWM | ETF | 48.625 | 48.65 | 48.5 | 48.61 | 69600.0 |
| 2002-03-05 16:00:00 | IWM | ETF | 48.56 | 48.56 | 48.56 | 48.56 | 15000.0 |
> showing 50 of 508 rows — these rows as CSV