PREVIEW / etf_30min / 2002-04-24
file: by_date/etf_30min/2002/2002-04-24.parquet size: 18 KB rows: 499
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-24 09:30:00 | SPY | ETF | 110.56 | 110.86 | 110.46 | 110.63 | 1683900.0 |
| 2002-04-24 10:00:00 | SPY | ETF | 110.61 | 110.8 | 110.28 | 110.68 | 2571900.0 |
| 2002-04-24 10:30:00 | SPY | ETF | 110.68 | 111.03 | 110.56 | 110.9 | 1371000.0 |
| 2002-04-24 11:00:00 | SPY | ETF | 110.88 | 111.09 | 110.71 | 110.93 | 763200.0 |
| 2002-04-24 11:30:00 | SPY | ETF | 110.93 | 111.24 | 110.9 | 111.16 | 832900.0 |
| 2002-04-24 12:00:00 | SPY | ETF | 111.12 | 111.13 | 110.95 | 111.03 | 486900.0 |
| 2002-04-24 12:30:00 | SPY | ETF | 111.0 | 111.18 | 110.88 | 110.93 | 512100.0 |
| 2002-04-24 13:00:00 | SPY | ETF | 110.93 | 110.99 | 110.8 | 110.88 | 300100.0 |
| 2002-04-24 13:30:00 | SPY | ETF | 110.89 | 110.89 | 110.69 | 110.79 | 1026600.0 |
| 2002-04-24 14:00:00 | SPY | ETF | 110.79 | 111.06 | 110.42 | 110.65 | 1513600.0 |
| 2002-04-24 14:30:00 | SPY | ETF | 110.63 | 110.72 | 110.1 | 110.27 | 1452700.0 |
| 2002-04-24 15:00:00 | SPY | ETF | 110.27 | 110.29 | 109.82 | 109.9 | 1386000.0 |
| 2002-04-24 15:30:00 | SPY | ETF | 109.91 | 109.98 | 109.51 | 109.59 | 2338000.0 |
| 2002-04-24 16:00:00 | SPY | ETF | 109.63 | 109.65 | 109.32 | 109.47 | 2104600.0 |
| 2002-04-24 16:30:00 | SPY | ETF | 109.45 | 109.55 | 109.45 | 109.55 | 5900.0 |
| 2002-04-24 17:00:00 | SPY | ETF | 109.51 | 109.52 | 109.51 | 109.51 | 1900.0 |
| 2002-04-24 17:30:00 | SPY | ETF | 109.46 | 109.55 | 109.46 | 109.55 | 600.0 |
| 2002-04-24 18:00:00 | SPY | ETF | 109.46 | 109.52 | 109.46 | 109.52 | 600.0 |
| 2002-04-24 09:30:00 | QQQ | ETF | 33.21 | 33.31 | 33.0 | 33.05 | 7253200.0 |
| 2002-04-24 10:00:00 | QQQ | ETF | 33.05 | 33.17 | 32.77 | 33.04 | 7942000.0 |
| 2002-04-24 10:30:00 | QQQ | ETF | 33.04 | 33.2 | 32.95 | 33.05 | 6327700.0 |
| 2002-04-24 11:00:00 | QQQ | ETF | 33.05 | 33.15 | 32.9 | 33.08 | 3188800.0 |
| 2002-04-24 11:30:00 | QQQ | ETF | 33.07 | 33.27 | 33.05 | 33.23 | 3709900.0 |
| 2002-04-24 12:00:00 | QQQ | ETF | 33.24 | 33.25 | 33.11 | 33.22 | 1774500.0 |
| 2002-04-24 12:30:00 | QQQ | ETF | 33.2 | 33.3 | 33.08 | 33.1 | 2231800.0 |
| 2002-04-24 13:00:00 | QQQ | ETF | 33.13 | 33.16 | 33.06 | 33.09 | 1520600.0 |
| 2002-04-24 13:30:00 | QQQ | ETF | 33.07 | 33.09 | 32.93 | 32.99 | 3427000.0 |
| 2002-04-24 14:00:00 | QQQ | ETF | 32.98 | 33.1 | 32.77 | 32.92 | 4893400.0 |
| 2002-04-24 14:30:00 | QQQ | ETF | 32.92 | 32.96 | 32.57 | 32.62 | 6222000.0 |
| 2002-04-24 15:00:00 | QQQ | ETF | 32.65 | 32.68 | 32.45 | 32.51 | 5894000.0 |
| 2002-04-24 15:30:00 | QQQ | ETF | 32.52 | 32.59 | 32.35 | 32.4 | 8082400.0 |
| 2002-04-24 16:00:00 | QQQ | ETF | 32.4 | 32.55 | 32.37 | 32.44 | 3941000.0 |
| 2002-04-24 16:30:00 | QQQ | ETF | 32.46 | 32.59 | 32.44 | 32.54 | 327500.0 |
| 2002-04-24 17:00:00 | QQQ | ETF | 32.55 | 32.57 | 32.52 | 32.55 | 83600.0 |
| 2002-04-24 17:30:00 | QQQ | ETF | 32.53 | 32.6 | 32.52 | 32.54 | 12100.0 |
| 2002-04-24 18:00:00 | QQQ | ETF | 32.52 | 32.57 | 32.52 | 32.55 | 55800.0 |
| 2002-04-24 09:30:00 | IWM | ETF | 51.0 | 51.25 | 50.95 | 51.25 | 160600.0 |
| 2002-04-24 10:00:00 | IWM | ETF | 51.2 | 51.25 | 50.955 | 51.235 | 44400.0 |
| 2002-04-24 10:30:00 | IWM | ETF | 51.26 | 51.325 | 51.2 | 51.29 | 70600.0 |
| 2002-04-24 11:00:00 | IWM | ETF | 51.29 | 51.29 | 51.1 | 51.25 | 30600.0 |
| 2002-04-24 11:30:00 | IWM | ETF | 51.195 | 51.25 | 51.14 | 51.23 | 26800.0 |
| 2002-04-24 12:00:00 | IWM | ETF | 51.185 | 51.2 | 51.11 | 51.14 | 28400.0 |
| 2002-04-24 12:30:00 | IWM | ETF | 51.085 | 51.15 | 50.995 | 51.0 | 32800.0 |
| 2002-04-24 13:00:00 | IWM | ETF | 50.975 | 51.025 | 50.895 | 50.94 | 188000.0 |
| 2002-04-24 13:30:00 | IWM | ETF | 50.89 | 50.9 | 50.8 | 50.86 | 132600.0 |
| 2002-04-24 14:00:00 | IWM | ETF | 50.79 | 50.9 | 50.605 | 50.68 | 61200.0 |
| 2002-04-24 14:30:00 | IWM | ETF | 50.68 | 50.68 | 50.505 | 50.515 | 46800.0 |
| 2002-04-24 15:00:00 | IWM | ETF | 50.57 | 50.575 | 50.45 | 50.56 | 54600.0 |
| 2002-04-24 15:30:00 | IWM | ETF | 50.53 | 50.53 | 50.385 | 50.52 | 155800.0 |
| 2002-04-24 16:00:00 | IWM | ETF | 50.52 | 50.52 | 50.46 | 50.46 | 5600.0 |
> showing 50 of 499 rows — these rows as CSV