PREVIEW / etf_30min / 2002-04-15
file: by_date/etf_30min/2002/2002-04-15.parquet size: 17 KB rows: 468
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-15 09:30:00 | SPY | ETF | 111.62 | 111.86 | 111.29 | 111.35 | 2683100.0 |
| 2002-04-15 10:00:00 | SPY | ETF | 111.34 | 111.5 | 111.15 | 111.25 | 1309500.0 |
| 2002-04-15 10:30:00 | SPY | ETF | 111.24 | 111.26 | 110.65 | 110.68 | 1729500.0 |
| 2002-04-15 11:00:00 | SPY | ETF | 110.63 | 110.9 | 110.36 | 110.51 | 1071900.0 |
| 2002-04-15 11:30:00 | SPY | ETF | 110.53 | 110.68 | 110.2 | 110.44 | 2166300.0 |
| 2002-04-15 12:00:00 | SPY | ETF | 110.48 | 110.67 | 110.36 | 110.59 | 679100.0 |
| 2002-04-15 12:30:00 | SPY | ETF | 110.62 | 111.02 | 110.58 | 110.89 | 924300.0 |
| 2002-04-15 13:00:00 | SPY | ETF | 110.89 | 111.17 | 110.87 | 111.1 | 854400.0 |
| 2002-04-15 13:30:00 | SPY | ETF | 111.13 | 111.23 | 110.87 | 111.16 | 726300.0 |
| 2002-04-15 14:00:00 | SPY | ETF | 111.14 | 111.29 | 110.94 | 110.95 | 519600.0 |
| 2002-04-15 14:30:00 | SPY | ETF | 110.94 | 111.14 | 110.72 | 110.8 | 638800.0 |
| 2002-04-15 15:00:00 | SPY | ETF | 110.78 | 110.96 | 110.55 | 110.86 | 825100.0 |
| 2002-04-15 15:30:00 | SPY | ETF | 110.82 | 110.97 | 110.52 | 110.63 | 800700.0 |
| 2002-04-15 16:00:00 | SPY | ETF | 110.6 | 110.7 | 110.43 | 110.53 | 1268200.0 |
| 2002-04-15 16:30:00 | SPY | ETF | 110.56 | 110.73 | 110.56 | 110.73 | 13300.0 |
| 2002-04-15 17:00:00 | SPY | ETF | 110.8 | 110.93 | 110.8 | 110.92 | 18100.0 |
| 2002-04-15 17:30:00 | SPY | ETF | 110.96 | 111.0 | 110.83 | 110.98 | 15700.0 |
| 2002-04-15 18:00:00 | SPY | ETF | 110.98 | 111.0 | 110.9 | 110.9 | 2000.0 |
| 2002-04-15 09:30:00 | QQQ | ETF | 33.8 | 33.9 | 33.56 | 33.72 | 9846800.0 |
| 2002-04-15 10:00:00 | QQQ | ETF | 33.72 | 33.96 | 33.6 | 33.85 | 7590900.0 |
| 2002-04-15 10:30:00 | QQQ | ETF | 33.85 | 33.86 | 33.6 | 33.61 | 7215900.0 |
| 2002-04-15 11:00:00 | QQQ | ETF | 33.61 | 33.72 | 33.34 | 33.4 | 5008800.0 |
| 2002-04-15 11:30:00 | QQQ | ETF | 33.4 | 33.5 | 33.2 | 33.43 | 5605800.0 |
| 2002-04-15 12:00:00 | QQQ | ETF | 33.43 | 33.6 | 33.37 | 33.56 | 6217500.0 |
| 2002-04-15 12:30:00 | QQQ | ETF | 33.58 | 33.79 | 33.54 | 33.69 | 2178800.0 |
| 2002-04-15 13:00:00 | QQQ | ETF | 33.66 | 33.84 | 33.61 | 33.81 | 3087000.0 |
| 2002-04-15 13:30:00 | QQQ | ETF | 33.82 | 33.85 | 33.63 | 33.82 | 2256200.0 |
| 2002-04-15 14:00:00 | QQQ | ETF | 33.82 | 33.91 | 33.75 | 33.8 | 4224600.0 |
| 2002-04-15 14:30:00 | QQQ | ETF | 33.8 | 33.94 | 33.65 | 33.7 | 4095700.0 |
| 2002-04-15 15:00:00 | QQQ | ETF | 33.7 | 33.84 | 33.61 | 33.79 | 3177000.0 |
| 2002-04-15 15:30:00 | QQQ | ETF | 33.8 | 33.87 | 33.7 | 33.78 | 2730100.0 |
| 2002-04-15 16:00:00 | QQQ | ETF | 33.77 | 33.86 | 33.65 | 33.82 | 1963500.0 |
| 2002-04-15 16:30:00 | QQQ | ETF | 33.67 | 33.95 | 33.67 | 33.95 | 1076200.0 |
| 2002-04-15 17:00:00 | QQQ | ETF | 33.96 | 34.07 | 33.77 | 34.05 | 966500.0 |
| 2002-04-15 17:30:00 | QQQ | ETF | 34.05 | 34.13 | 34.03 | 34.12 | 191900.0 |
| 2002-04-15 18:00:00 | QQQ | ETF | 34.08 | 34.11 | 34.07 | 34.11 | 16400.0 |
| 2002-04-15 09:30:00 | IWM | ETF | 51.5 | 51.625 | 51.165 | 51.225 | 1625600.0 |
| 2002-04-15 10:00:00 | IWM | ETF | 51.13 | 51.185 | 51.055 | 51.17 | 159000.0 |
| 2002-04-15 10:30:00 | IWM | ETF | 51.115 | 51.115 | 50.925 | 50.925 | 138800.0 |
| 2002-04-15 11:00:00 | IWM | ETF | 50.905 | 50.96 | 50.815 | 50.86 | 51600.0 |
| 2002-04-15 11:30:00 | IWM | ETF | 50.85 | 50.915 | 50.79 | 50.855 | 108800.0 |
| 2002-04-15 12:00:00 | IWM | ETF | 50.855 | 51.01 | 50.85 | 50.97 | 110800.0 |
| 2002-04-15 12:30:00 | IWM | ETF | 51.005 | 51.14 | 51.005 | 51.14 | 23800.0 |
| 2002-04-15 13:00:00 | IWM | ETF | 51.1 | 51.105 | 51.08 | 51.105 | 18600.0 |
| 2002-04-15 13:30:00 | IWM | ETF | 51.105 | 51.14 | 51.04 | 51.13 | 51600.0 |
| 2002-04-15 14:00:00 | IWM | ETF | 51.14 | 51.175 | 51.065 | 51.065 | 223600.0 |
| 2002-04-15 14:30:00 | IWM | ETF | 51.065 | 51.15 | 50.99 | 51.0 | 122800.0 |
| 2002-04-15 15:00:00 | IWM | ETF | 50.98 | 51.03 | 50.91 | 51.03 | 130000.0 |
| 2002-04-15 15:30:00 | IWM | ETF | 51.03 | 51.045 | 50.86 | 50.87 | 61800.0 |
| 2002-04-15 16:00:00 | IWM | ETF | 50.975 | 50.975 | 50.875 | 50.875 | 4600.0 |
> showing 50 of 468 rows — these rows as CSV