PREVIEW / etf_30min / 2002-03-19
file: by_date/etf_30min/2002/2002-03-19.parquet size: 18 KB rows: 517
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-19 09:30:00 | SPY | ETF | 117.3 | 117.39 | 117.01 | 117.2 | 1691600.0 |
| 2002-03-19 10:00:00 | SPY | ETF | 117.15 | 117.3 | 116.93 | 117.08 | 1045600.0 |
| 2002-03-19 10:30:00 | SPY | ETF | 117.1 | 117.27 | 117.03 | 117.12 | 774000.0 |
| 2002-03-19 11:00:00 | SPY | ETF | 117.13 | 117.23 | 116.96 | 117.14 | 516000.0 |
| 2002-03-19 11:30:00 | SPY | ETF | 117.14 | 117.43 | 117.12 | 117.41 | 1244200.0 |
| 2002-03-19 12:00:00 | SPY | ETF | 117.43 | 117.6 | 117.36 | 117.53 | 875300.0 |
| 2002-03-19 12:30:00 | SPY | ETF | 117.53 | 117.58 | 117.33 | 117.43 | 356400.0 |
| 2002-03-19 13:00:00 | SPY | ETF | 117.4 | 117.54 | 117.34 | 117.48 | 508700.0 |
| 2002-03-19 13:30:00 | SPY | ETF | 117.49 | 117.73 | 117.4 | 117.61 | 943400.0 |
| 2002-03-19 14:00:00 | SPY | ETF | 117.62 | 117.74 | 117.1 | 117.11 | 2389000.0 |
| 2002-03-19 14:30:00 | SPY | ETF | 117.11 | 117.52 | 116.9 | 117.4 | 2562200.0 |
| 2002-03-19 15:00:00 | SPY | ETF | 117.39 | 117.48 | 116.82 | 117.11 | 1633500.0 |
| 2002-03-19 15:30:00 | SPY | ETF | 117.11 | 117.32 | 116.97 | 117.25 | 1223800.0 |
| 2002-03-19 16:00:00 | SPY | ETF | 117.34 | 117.6 | 117.19 | 117.46 | 831900.0 |
| 2002-03-19 16:30:00 | SPY | ETF | 117.19 | 117.46 | 117.19 | 117.36 | 30400.0 |
| 2002-03-19 18:00:00 | SPY | ETF | 117.49 | 117.54 | 117.42 | 117.54 | 1600.0 |
| 2002-03-19 09:30:00 | QQQ | ETF | 37.6 | 37.65 | 37.33 | 37.52 | 6156600.0 |
| 2002-03-19 10:00:00 | QQQ | ETF | 37.52 | 37.67 | 37.48 | 37.6 | 6381900.0 |
| 2002-03-19 10:30:00 | QQQ | ETF | 37.59 | 37.72 | 37.54 | 37.6 | 3459900.0 |
| 2002-03-19 11:00:00 | QQQ | ETF | 37.59 | 37.65 | 37.52 | 37.58 | 1946700.0 |
| 2002-03-19 11:30:00 | QQQ | ETF | 37.59 | 37.73 | 37.58 | 37.71 | 2274600.0 |
| 2002-03-19 12:00:00 | QQQ | ETF | 37.72 | 37.78 | 37.64 | 37.68 | 2261000.0 |
| 2002-03-19 12:30:00 | QQQ | ETF | 37.68 | 37.7 | 37.6 | 37.62 | 1317600.0 |
| 2002-03-19 13:00:00 | QQQ | ETF | 37.62 | 37.73 | 37.6 | 37.68 | 843600.0 |
| 2002-03-19 13:30:00 | QQQ | ETF | 37.7 | 37.77 | 37.63 | 37.72 | 1184500.0 |
| 2002-03-19 14:00:00 | QQQ | ETF | 37.72 | 37.88 | 37.4 | 37.41 | 8604100.0 |
| 2002-03-19 14:30:00 | QQQ | ETF | 37.41 | 37.7 | 37.34 | 37.51 | 9562000.0 |
| 2002-03-19 15:00:00 | QQQ | ETF | 37.52 | 37.59 | 37.22 | 37.4 | 7969400.0 |
| 2002-03-19 15:30:00 | QQQ | ETF | 37.39 | 37.5 | 37.31 | 37.45 | 3602700.0 |
| 2002-03-19 16:00:00 | QQQ | ETF | 37.44 | 37.47 | 37.37 | 37.4 | 1090700.0 |
| 2002-03-19 16:30:00 | QQQ | ETF | 37.4 | 37.46 | 37.4 | 37.45 | 19700.0 |
| 2002-03-19 17:00:00 | QQQ | ETF | 37.42 | 37.52 | 37.42 | 37.52 | 31600.0 |
| 2002-03-19 17:30:00 | QQQ | ETF | 37.5 | 37.52 | 37.45 | 37.45 | 14300.0 |
| 2002-03-19 18:00:00 | QQQ | ETF | 37.45 | 37.52 | 37.44 | 37.5 | 13100.0 |
| 2002-03-19 09:30:00 | IWM | ETF | 50.15 | 50.215 | 49.95 | 50.02 | 39800.0 |
| 2002-03-19 10:00:00 | IWM | ETF | 50.05 | 50.105 | 50.025 | 50.025 | 28000.0 |
| 2002-03-19 10:30:00 | IWM | ETF | 50.13 | 50.13 | 50.05 | 50.1 | 21200.0 |
| 2002-03-19 11:00:00 | IWM | ETF | 50.115 | 50.125 | 50.04 | 50.1 | 5800.0 |
| 2002-03-19 11:30:00 | IWM | ETF | 50.125 | 50.17 | 50.045 | 50.155 | 18600.0 |
| 2002-03-19 12:00:00 | IWM | ETF | 50.17 | 50.27 | 50.075 | 50.27 | 71200.0 |
| 2002-03-19 12:30:00 | IWM | ETF | 50.26 | 50.27 | 50.2 | 50.24 | 6000.0 |
| 2002-03-19 13:00:00 | IWM | ETF | 50.225 | 50.29 | 50.165 | 50.26 | 60400.0 |
| 2002-03-19 13:30:00 | IWM | ETF | 50.27 | 50.29 | 50.17 | 50.21 | 5000.0 |
| 2002-03-19 14:00:00 | IWM | ETF | 50.28 | 50.325 | 50.09 | 50.09 | 39600.0 |
| 2002-03-19 14:30:00 | IWM | ETF | 50.165 | 50.32 | 50.005 | 50.25 | 16800.0 |
| 2002-03-19 15:00:00 | IWM | ETF | 50.29 | 50.29 | 50.045 | 50.2 | 242800.0 |
| 2002-03-19 15:30:00 | IWM | ETF | 50.105 | 50.255 | 50.105 | 50.235 | 11400.0 |
| 2002-03-19 16:00:00 | IWM | ETF | 50.225 | 50.255 | 50.225 | 50.255 | 7600.0 |
| 2002-03-19 17:00:00 | IWM | ETF | 50.255 | 50.255 | 50.255 | 50.255 | 1000.0 |
| 2002-03-19 09:30:00 | DIA | ETF | 106.4 | 106.5 | 106.15 | 106.36 | 693700.0 |
> showing 50 of 517 rows — these rows as CSV