PREVIEW / etf_30min / 2002-04-26
file: by_date/etf_30min/2002/2002-04-26.parquet size: 19 KB rows: 515
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-26 09:30:00 | SPY | ETF | 109.79 | 110.01 | 109.54 | 109.68 | 2355500.0 |
| 2002-04-26 10:00:00 | SPY | ETF | 109.65 | 109.71 | 108.85 | 108.86 | 2534300.0 |
| 2002-04-26 10:30:00 | SPY | ETF | 108.8 | 109.06 | 108.61 | 108.81 | 1955600.0 |
| 2002-04-26 11:00:00 | SPY | ETF | 108.81 | 108.81 | 108.34 | 108.6 | 1183200.0 |
| 2002-04-26 11:30:00 | SPY | ETF | 108.64 | 109.06 | 108.63 | 108.96 | 1192500.0 |
| 2002-04-26 12:00:00 | SPY | ETF | 108.95 | 109.0 | 108.63 | 108.63 | 411400.0 |
| 2002-04-26 12:30:00 | SPY | ETF | 108.62 | 108.68 | 108.43 | 108.53 | 467300.0 |
| 2002-04-26 13:00:00 | SPY | ETF | 108.52 | 108.86 | 108.33 | 108.85 | 1158100.0 |
| 2002-04-26 13:30:00 | SPY | ETF | 108.78 | 108.83 | 108.59 | 108.76 | 697900.0 |
| 2002-04-26 14:00:00 | SPY | ETF | 108.76 | 109.07 | 108.73 | 108.81 | 638700.0 |
| 2002-04-26 14:30:00 | SPY | ETF | 108.86 | 108.91 | 108.51 | 108.54 | 565700.0 |
| 2002-04-26 15:00:00 | SPY | ETF | 108.5 | 108.59 | 108.08 | 108.38 | 1317200.0 |
| 2002-04-26 15:30:00 | SPY | ETF | 108.39 | 108.43 | 107.9 | 107.95 | 1696400.0 |
| 2002-04-26 16:00:00 | SPY | ETF | 107.9 | 108.01 | 107.29 | 107.73 | 2492900.0 |
| 2002-04-26 16:30:00 | SPY | ETF | 107.35 | 107.48 | 107.3 | 107.31 | 29800.0 |
| 2002-04-26 17:00:00 | SPY | ETF | 107.35 | 107.35 | 107.3 | 107.34 | 11300.0 |
| 2002-04-26 17:30:00 | SPY | ETF | 107.34 | 107.59 | 107.3 | 107.59 | 2900.0 |
| 2002-04-26 18:00:00 | SPY | ETF | 107.39 | 107.39 | 107.39 | 107.39 | 100.0 |
| 2002-04-26 09:30:00 | QQQ | ETF | 32.66 | 32.78 | 32.45 | 32.5 | 11079300.0 |
| 2002-04-26 10:00:00 | QQQ | ETF | 32.53 | 32.56 | 32.0 | 32.01 | 12260900.0 |
| 2002-04-26 10:30:00 | QQQ | ETF | 32.01 | 32.15 | 31.91 | 32.01 | 9883500.0 |
| 2002-04-26 11:00:00 | QQQ | ETF | 32.01 | 32.05 | 31.74 | 31.85 | 7383300.0 |
| 2002-04-26 11:30:00 | QQQ | ETF | 31.85 | 32.03 | 31.82 | 31.93 | 6042800.0 |
| 2002-04-26 12:00:00 | QQQ | ETF | 31.91 | 31.96 | 31.69 | 31.75 | 4129400.0 |
| 2002-04-26 12:30:00 | QQQ | ETF | 31.7 | 31.76 | 31.51 | 31.57 | 4961300.0 |
| 2002-04-26 13:00:00 | QQQ | ETF | 31.56 | 31.69 | 31.4 | 31.63 | 8832800.0 |
| 2002-04-26 13:30:00 | QQQ | ETF | 31.63 | 31.73 | 31.6 | 31.7 | 2895200.0 |
| 2002-04-26 14:00:00 | QQQ | ETF | 31.7 | 31.85 | 31.6 | 31.68 | 4380300.0 |
| 2002-04-26 14:30:00 | QQQ | ETF | 31.67 | 31.7 | 31.5 | 31.51 | 3084800.0 |
| 2002-04-26 15:00:00 | QQQ | ETF | 31.53 | 31.59 | 31.26 | 31.43 | 9165800.0 |
| 2002-04-26 15:30:00 | QQQ | ETF | 31.43 | 31.49 | 31.17 | 31.17 | 7966000.0 |
| 2002-04-26 16:00:00 | QQQ | ETF | 31.2 | 31.36 | 31.0 | 31.04 | 4773200.0 |
| 2002-04-26 16:30:00 | QQQ | ETF | 31.05 | 31.09 | 31.0 | 31.06 | 104200.0 |
| 2002-04-26 17:00:00 | QQQ | ETF | 31.05 | 31.07 | 31.0 | 31.03 | 44000.0 |
| 2002-04-26 17:30:00 | QQQ | ETF | 31.03 | 31.03 | 30.95 | 31.01 | 32400.0 |
| 2002-04-26 18:00:00 | QQQ | ETF | 30.9 | 30.98 | 30.9 | 30.95 | 16600.0 |
| 2002-04-26 09:30:00 | IWM | ETF | 50.81 | 50.945 | 50.615 | 50.615 | 80000.0 |
| 2002-04-26 10:00:00 | IWM | ETF | 50.645 | 50.67 | 50.3 | 50.3 | 80800.0 |
| 2002-04-26 10:30:00 | IWM | ETF | 50.275 | 50.4 | 50.25 | 50.335 | 97200.0 |
| 2002-04-26 11:00:00 | IWM | ETF | 50.27 | 50.27 | 50.085 | 50.155 | 93400.0 |
| 2002-04-26 11:30:00 | IWM | ETF | 50.14 | 50.265 | 50.13 | 50.225 | 85400.0 |
| 2002-04-26 12:00:00 | IWM | ETF | 50.245 | 50.245 | 50.125 | 50.13 | 65800.0 |
| 2002-04-26 12:30:00 | IWM | ETF | 50.13 | 50.13 | 50.045 | 50.125 | 71000.0 |
| 2002-04-26 13:00:00 | IWM | ETF | 50.075 | 50.2 | 50.0 | 50.2 | 324200.0 |
| 2002-04-26 13:30:00 | IWM | ETF | 50.19 | 50.285 | 50.155 | 50.26 | 39000.0 |
| 2002-04-26 14:00:00 | IWM | ETF | 50.285 | 50.35 | 50.21 | 50.315 | 28400.0 |
| 2002-04-26 14:30:00 | IWM | ETF | 50.32 | 50.32 | 50.15 | 50.155 | 262200.0 |
| 2002-04-26 15:00:00 | IWM | ETF | 50.15 | 50.275 | 50.005 | 50.085 | 334400.0 |
| 2002-04-26 15:30:00 | IWM | ETF | 50.1 | 50.5 | 49.805 | 49.805 | 136200.0 |
| 2002-04-26 16:00:00 | IWM | ETF | 49.91 | 50.19 | 49.685 | 50.19 | 415000.0 |
> showing 50 of 515 rows — these rows as CSV