PREVIEW / etf_30min / 2002-05-14
file: by_date/etf_30min/2002/2002-05-14.parquet size: 19 KB rows: 512
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-05-14 09:30:00 | SPY | ETF | 109.62 | 109.8 | 109.15 | 109.38 | 5095900.0 |
| 2002-05-14 10:00:00 | SPY | ETF | 109.36 | 109.5 | 109.0 | 109.5 | 1617600.0 |
| 2002-05-14 10:30:00 | SPY | ETF | 109.49 | 109.68 | 109.43 | 109.54 | 1464600.0 |
| 2002-05-14 11:00:00 | SPY | ETF | 109.57 | 109.75 | 109.3 | 109.46 | 1264700.0 |
| 2002-05-14 11:30:00 | SPY | ETF | 109.47 | 109.64 | 109.4 | 109.56 | 493400.0 |
| 2002-05-14 12:00:00 | SPY | ETF | 109.59 | 109.8 | 109.55 | 109.7 | 805200.0 |
| 2002-05-14 12:30:00 | SPY | ETF | 109.75 | 109.75 | 109.55 | 109.58 | 326800.0 |
| 2002-05-14 13:00:00 | SPY | ETF | 109.59 | 109.73 | 109.52 | 109.7 | 279700.0 |
| 2002-05-14 13:30:00 | SPY | ETF | 109.71 | 109.71 | 109.37 | 109.46 | 438700.0 |
| 2002-05-14 14:00:00 | SPY | ETF | 109.42 | 109.8 | 109.36 | 109.8 | 693100.0 |
| 2002-05-14 14:30:00 | SPY | ETF | 109.81 | 110.15 | 109.79 | 109.99 | 2295500.0 |
| 2002-05-14 15:00:00 | SPY | ETF | 109.97 | 110.12 | 109.84 | 110.02 | 1258300.0 |
| 2002-05-14 15:30:00 | SPY | ETF | 110.05 | 110.26 | 110.0 | 110.09 | 2098800.0 |
| 2002-05-14 16:00:00 | SPY | ETF | 110.13 | 110.51 | 110.06 | 110.45 | 1785000.0 |
| 2002-05-14 16:30:00 | SPY | ETF | 109.72 | 110.51 | 109.72 | 110.34 | 13613700.0 |
| 2002-05-14 17:00:00 | SPY | ETF | 110.34 | 110.35 | 110.23 | 110.27 | 7700.0 |
| 2002-05-14 17:30:00 | SPY | ETF | 110.26 | 110.27 | 110.2 | 110.2 | 4200.0 |
| 2002-05-14 18:00:00 | SPY | ETF | 110.27 | 110.3 | 110.13 | 110.2 | 15600.0 |
| 2002-05-14 09:30:00 | QQQ | ETF | 32.05 | 32.32 | 31.96 | 32.18 | 20008500.0 |
| 2002-05-14 10:00:00 | QQQ | ETF | 32.18 | 32.21 | 31.87 | 32.15 | 9784500.0 |
| 2002-05-14 10:30:00 | QQQ | ETF | 32.16 | 32.21 | 32.09 | 32.16 | 5476100.0 |
| 2002-05-14 11:00:00 | QQQ | ETF | 32.18 | 32.29 | 32.05 | 32.11 | 6865700.0 |
| 2002-05-14 11:30:00 | QQQ | ETF | 32.1 | 32.27 | 32.09 | 32.23 | 2656500.0 |
| 2002-05-14 12:00:00 | QQQ | ETF | 32.23 | 32.4 | 32.22 | 32.35 | 5785600.0 |
| 2002-05-14 12:30:00 | QQQ | ETF | 32.32 | 32.36 | 32.15 | 32.2 | 3993100.0 |
| 2002-05-14 13:00:00 | QQQ | ETF | 32.21 | 32.32 | 32.17 | 32.3 | 2453700.0 |
| 2002-05-14 13:30:00 | QQQ | ETF | 32.3 | 32.32 | 32.05 | 32.11 | 4562400.0 |
| 2002-05-14 14:00:00 | QQQ | ETF | 32.11 | 32.35 | 32.07 | 32.33 | 4387600.0 |
| 2002-05-14 14:30:00 | QQQ | ETF | 32.32 | 32.55 | 32.31 | 32.44 | 7499100.0 |
| 2002-05-14 15:00:00 | QQQ | ETF | 32.45 | 32.53 | 32.31 | 32.42 | 8144700.0 |
| 2002-05-14 15:30:00 | QQQ | ETF | 32.42 | 32.61 | 32.39 | 32.5 | 12884100.0 |
| 2002-05-14 16:00:00 | QQQ | ETF | 32.49 | 32.84 | 32.42 | 32.65 | 8363700.0 |
| 2002-05-14 16:30:00 | QQQ | ETF | 32.68 | 32.75 | 32.45 | 32.7 | 449700.0 |
| 2002-05-14 17:00:00 | QQQ | ETF | 32.7 | 32.72 | 32.64 | 32.69 | 405100.0 |
| 2002-05-14 17:30:00 | QQQ | ETF | 32.7 | 32.73 | 32.68 | 32.72 | 91800.0 |
| 2002-05-14 18:00:00 | QQQ | ETF | 32.72 | 32.73 | 32.68 | 32.7 | 24300.0 |
| 2002-05-14 09:30:00 | IWM | ETF | 50.35 | 50.445 | 50.11 | 50.185 | 168200.0 |
| 2002-05-14 10:00:00 | IWM | ETF | 50.22 | 50.245 | 50.115 | 50.22 | 101000.0 |
| 2002-05-14 10:30:00 | IWM | ETF | 50.255 | 50.455 | 50.22 | 50.45 | 961200.0 |
| 2002-05-14 11:00:00 | IWM | ETF | 50.48 | 50.615 | 50.47 | 50.585 | 1576200.0 |
| 2002-05-14 11:30:00 | IWM | ETF | 50.55 | 50.615 | 50.55 | 50.6 | 875800.0 |
| 2002-05-14 12:00:00 | IWM | ETF | 50.6 | 50.795 | 50.585 | 50.75 | 596000.0 |
| 2002-05-14 12:30:00 | IWM | ETF | 50.795 | 50.795 | 50.635 | 50.685 | 515200.0 |
| 2002-05-14 13:00:00 | IWM | ETF | 50.685 | 50.8 | 50.675 | 50.795 | 856600.0 |
| 2002-05-14 13:30:00 | IWM | ETF | 50.8 | 50.825 | 50.725 | 50.725 | 750000.0 |
| 2002-05-14 14:00:00 | IWM | ETF | 50.725 | 50.975 | 50.7 | 50.9 | 1255800.0 |
| 2002-05-14 14:30:00 | IWM | ETF | 50.975 | 51.04 | 50.95 | 51.03 | 438400.0 |
| 2002-05-14 15:00:00 | IWM | ETF | 51.0 | 51.02 | 50.87 | 50.9 | 46600.0 |
| 2002-05-14 15:30:00 | IWM | ETF | 50.92 | 51.1 | 50.875 | 50.95 | 330200.0 |
| 2002-05-14 16:00:00 | IWM | ETF | 50.95 | 51.2 | 50.95 | 51.2 | 24200.0 |
> showing 50 of 512 rows — these rows as CSV