PREVIEW / etf_30min / 2002-04-30
file: by_date/etf_30min/2002/2002-04-30.parquet size: 19 KB rows: 521
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-30 09:30:00 | SPY | ETF | 107.02 | 107.1 | 106.64 | 106.73 | 1666700.0 |
| 2002-04-30 10:00:00 | SPY | ETF | 106.73 | 107.87 | 106.72 | 107.55 | 4352000.0 |
| 2002-04-30 10:30:00 | SPY | ETF | 107.55 | 107.8 | 107.45 | 107.66 | 1571300.0 |
| 2002-04-30 11:00:00 | SPY | ETF | 107.64 | 108.26 | 107.51 | 108.13 | 2311800.0 |
| 2002-04-30 11:30:00 | SPY | ETF | 108.14 | 108.46 | 108.07 | 108.45 | 1354800.0 |
| 2002-04-30 12:00:00 | SPY | ETF | 108.45 | 108.52 | 108.3 | 108.39 | 503100.0 |
| 2002-04-30 12:30:00 | SPY | ETF | 108.37 | 108.59 | 108.3 | 108.44 | 664800.0 |
| 2002-04-30 13:00:00 | SPY | ETF | 108.43 | 108.48 | 108.27 | 108.33 | 442000.0 |
| 2002-04-30 13:30:00 | SPY | ETF | 108.38 | 108.6 | 108.33 | 108.49 | 375400.0 |
| 2002-04-30 14:00:00 | SPY | ETF | 108.5 | 108.59 | 108.26 | 108.29 | 676100.0 |
| 2002-04-30 14:30:00 | SPY | ETF | 108.27 | 108.49 | 108.18 | 108.49 | 1639900.0 |
| 2002-04-30 15:00:00 | SPY | ETF | 108.47 | 108.64 | 108.25 | 108.3 | 646500.0 |
| 2002-04-30 15:30:00 | SPY | ETF | 108.3 | 108.36 | 107.84 | 107.97 | 1516800.0 |
| 2002-04-30 16:00:00 | SPY | ETF | 107.93 | 108.1 | 107.81 | 107.85 | 1310200.0 |
| 2002-04-30 16:30:00 | SPY | ETF | 107.76 | 107.91 | 107.76 | 107.91 | 13300.0 |
| 2002-04-30 17:00:00 | SPY | ETF | 107.92 | 107.98 | 107.85 | 107.96 | 14700.0 |
| 2002-04-30 17:30:00 | SPY | ETF | 108.04 | 108.05 | 107.92 | 107.92 | 1000.0 |
| 2002-04-30 18:00:00 | SPY | ETF | 108.06 | 108.2 | 108.0 | 108.0 | 800.0 |
| 2002-04-30 09:30:00 | QQQ | ETF | 31.03 | 31.32 | 30.94 | 31.04 | 12628400.0 |
| 2002-04-30 10:00:00 | QQQ | ETF | 31.01 | 31.73 | 31.0 | 31.51 | 17314200.0 |
| 2002-04-30 10:30:00 | QQQ | ETF | 31.5 | 31.8 | 31.48 | 31.76 | 8599500.0 |
| 2002-04-30 11:00:00 | QQQ | ETF | 31.74 | 32.1 | 31.64 | 32.05 | 10585800.0 |
| 2002-04-30 11:30:00 | QQQ | ETF | 32.05 | 32.11 | 31.91 | 32.1 | 4724300.0 |
| 2002-04-30 12:00:00 | QQQ | ETF | 32.1 | 32.19 | 31.92 | 31.97 | 5245400.0 |
| 2002-04-30 12:30:00 | QQQ | ETF | 31.96 | 32.07 | 31.9 | 31.92 | 2455500.0 |
| 2002-04-30 13:00:00 | QQQ | ETF | 31.92 | 31.98 | 31.77 | 31.8 | 3365500.0 |
| 2002-04-30 13:30:00 | QQQ | ETF | 31.8 | 31.99 | 31.8 | 31.96 | 5398000.0 |
| 2002-04-30 14:00:00 | QQQ | ETF | 31.96 | 32.09 | 31.81 | 31.84 | 3486200.0 |
| 2002-04-30 14:30:00 | QQQ | ETF | 31.85 | 32.05 | 31.77 | 32.03 | 3459800.0 |
| 2002-04-30 15:00:00 | QQQ | ETF | 32.03 | 32.12 | 31.86 | 31.89 | 3811200.0 |
| 2002-04-30 15:30:00 | QQQ | ETF | 31.9 | 31.99 | 31.58 | 31.76 | 9827900.0 |
| 2002-04-30 16:00:00 | QQQ | ETF | 31.76 | 32.1 | 31.62 | 31.7 | 2803300.0 |
| 2002-04-30 16:30:00 | QQQ | ETF | 31.7 | 31.75 | 31.04 | 31.74 | 1347700.0 |
| 2002-04-30 17:00:00 | QQQ | ETF | 31.74 | 31.79 | 31.72 | 31.75 | 61900.0 |
| 2002-04-30 17:30:00 | QQQ | ETF | 31.76 | 31.78 | 31.74 | 31.76 | 70200.0 |
| 2002-04-30 18:00:00 | QQQ | ETF | 31.78 | 31.8 | 31.75 | 31.8 | 15600.0 |
| 2002-04-30 09:30:00 | IWM | ETF | 49.9 | 50.01 | 49.81 | 50.01 | 49600.0 |
| 2002-04-30 10:00:00 | IWM | ETF | 49.99 | 50.37 | 49.98 | 50.3 | 134600.0 |
| 2002-04-30 10:30:00 | IWM | ETF | 50.25 | 50.355 | 50.195 | 50.315 | 54600.0 |
| 2002-04-30 11:00:00 | IWM | ETF | 50.3 | 50.525 | 50.285 | 50.465 | 142400.0 |
| 2002-04-30 11:30:00 | IWM | ETF | 50.465 | 50.55 | 50.435 | 50.55 | 82600.0 |
| 2002-04-30 12:00:00 | IWM | ETF | 50.56 | 50.645 | 50.455 | 50.54 | 98600.0 |
| 2002-04-30 12:30:00 | IWM | ETF | 50.475 | 50.605 | 50.475 | 50.58 | 31800.0 |
| 2002-04-30 13:00:00 | IWM | ETF | 50.57 | 50.57 | 50.4 | 50.495 | 101400.0 |
| 2002-04-30 13:30:00 | IWM | ETF | 50.5 | 50.595 | 50.5 | 50.595 | 67200.0 |
| 2002-04-30 14:00:00 | IWM | ETF | 50.55 | 50.62 | 50.5 | 50.5 | 337000.0 |
| 2002-04-30 14:30:00 | IWM | ETF | 50.5 | 50.585 | 50.5 | 50.57 | 18600.0 |
| 2002-04-30 15:00:00 | IWM | ETF | 50.535 | 50.72 | 50.535 | 50.64 | 69600.0 |
| 2002-04-30 15:30:00 | IWM | ETF | 50.595 | 50.795 | 50.505 | 50.795 | 167000.0 |
| 2002-04-30 16:00:00 | IWM | ETF | 50.625 | 50.83 | 50.625 | 50.65 | 81000.0 |
> showing 50 of 521 rows — these rows as CSV