PREVIEW / etf_30min / 2005-05-13
file: by_date/etf_30min/2005/2005-05-13.parquet size: 46 KB rows: 1,508
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-13 05:00:00 | SPY | ETF | 116.22 | 116.22 | 116.22 | 116.22 | 7500.0 |
| 2005-05-13 07:00:00 | SPY | ETF | 116.23 | 116.28 | 116.23 | 116.28 | 29200.0 |
| 2005-05-13 07:30:00 | SPY | ETF | 116.28 | 116.42 | 116.28 | 116.3 | 43400.0 |
| 2005-05-13 08:00:00 | SPY | ETF | 116.34 | 116.38 | 116.32 | 116.32 | 48500.0 |
| 2005-05-13 08:30:00 | SPY | ETF | 116.3 | 116.33 | 116.19 | 116.24 | 145400.0 |
| 2005-05-13 09:00:00 | SPY | ETF | 116.24 | 116.31 | 116.16 | 116.31 | 504500.0 |
| 2005-05-13 09:30:00 | SPY | ETF | 116.3 | 116.32 | 115.68 | 115.86 | 8743000.0 |
| 2005-05-13 10:00:00 | SPY | ETF | 115.86 | 116.1 | 115.61 | 115.9 | 9087700.0 |
| 2005-05-13 10:30:00 | SPY | ETF | 115.9 | 116.46 | 115.75 | 116.45 | 8174000.0 |
| 2005-05-13 11:00:00 | SPY | ETF | 116.45 | 116.58 | 116.24 | 116.56 | 6044100.0 |
| 2005-05-13 11:30:00 | SPY | ETF | 116.57 | 116.62 | 116.34 | 116.49 | 4232600.0 |
| 2005-05-13 12:00:00 | SPY | ETF | 116.49 | 116.6 | 116.37 | 116.45 | 1889400.0 |
| 2005-05-13 12:30:00 | SPY | ETF | 116.44 | 116.46 | 116.15 | 116.21 | 2691300.0 |
| 2005-05-13 13:00:00 | SPY | ETF | 116.21 | 116.29 | 115.92 | 115.98 | 4506500.0 |
| 2005-05-13 13:30:00 | SPY | ETF | 115.98 | 116.04 | 115.58 | 115.73 | 3725100.0 |
| 2005-05-13 14:00:00 | SPY | ETF | 115.73 | 115.83 | 115.32 | 115.5 | 5560300.0 |
| 2005-05-13 14:30:00 | SPY | ETF | 115.49 | 115.5 | 114.8 | 115.12 | 9868900.0 |
| 2005-05-13 15:00:00 | SPY | ETF | 115.13 | 115.9 | 114.98 | 115.68 | 11288800.0 |
| 2005-05-13 15:30:00 | SPY | ETF | 115.68 | 115.75 | 115.41 | 115.59 | 5651900.0 |
| 2005-05-13 16:00:00 | SPY | ETF | 115.65 | 115.78 | 115.58 | 115.75 | 724300.0 |
| 2005-05-13 16:30:00 | SPY | ETF | 115.75 | 115.845 | 115.64 | 115.74 | 114300.0 |
| 2005-05-13 17:00:00 | SPY | ETF | 115.75 | 115.75 | 115.69 | 115.74 | 7800.0 |
| 2005-05-13 17:30:00 | SPY | ETF | 115.74 | 115.74 | 115.69 | 115.69 | 1200.0 |
| 2005-05-13 19:00:00 | SPY | ETF | 115.7 | 115.78 | 115.7 | 115.78 | 1800.0 |
| 2005-05-13 19:30:00 | SPY | ETF | 115.7 | 115.7 | 115.7 | 115.7 | 400.0 |
| 2005-05-13 09:30:00 | QQQ | ETF | 35.99 | 36.07 | 35.89 | 35.96 | 14983100.0 |
| 2005-05-13 10:00:00 | QQQ | ETF | 35.96 | 36.13 | 35.89 | 36.07 | 9835600.0 |
| 2005-05-13 10:30:00 | QQQ | ETF | 36.06 | 36.3 | 36.0 | 36.3 | 15187500.0 |
| 2005-05-13 11:00:00 | QQQ | ETF | 36.29 | 36.39 | 34.28 | 36.38 | 12199200.0 |
| 2005-05-13 11:30:00 | QQQ | ETF | 36.38 | 36.45 | 36.34 | 36.41 | 7653100.0 |
| 2005-05-13 12:00:00 | QQQ | ETF | 36.41 | 36.47 | 36.35 | 36.42 | 5503400.0 |
| 2005-05-13 12:30:00 | QQQ | ETF | 36.41 | 36.43 | 36.3 | 36.31 | 4716100.0 |
| 2005-05-13 13:00:00 | QQQ | ETF | 36.31 | 36.37 | 36.26 | 36.27 | 3351800.0 |
| 2005-05-13 13:30:00 | QQQ | ETF | 36.26 | 36.29 | 36.18 | 36.23 | 5985900.0 |
| 2005-05-13 14:00:00 | QQQ | ETF | 36.23 | 36.28 | 36.04 | 36.14 | 8630100.0 |
| 2005-05-13 14:30:00 | QQQ | ETF | 36.15 | 36.15 | 35.93 | 36.03 | 17156500.0 |
| 2005-05-13 15:00:00 | QQQ | ETF | 36.04 | 36.24 | 36.0 | 36.19 | 12296700.0 |
| 2005-05-13 15:30:00 | QQQ | ETF | 36.2 | 36.25 | 36.14 | 36.23 | 8450500.0 |
| 2005-05-13 08:00:00 | IWM | ETF | 58.425 | 58.425 | 58.425 | 58.425 | 1000.0 |
| 2005-05-13 08:30:00 | IWM | ETF | 58.41 | 58.47 | 58.41 | 58.46 | 32600.0 |
| 2005-05-13 09:00:00 | IWM | ETF | 58.465 | 58.465 | 58.43 | 58.45 | 54400.0 |
| 2005-05-13 09:30:00 | IWM | ETF | 58.5 | 58.6 | 58.005 | 58.08 | 5868400.0 |
| 2005-05-13 10:00:00 | IWM | ETF | 58.11 | 58.29 | 57.965 | 58.145 | 3931400.0 |
| 2005-05-13 10:30:00 | IWM | ETF | 58.145 | 58.55 | 58.065 | 58.545 | 2913200.0 |
| 2005-05-13 11:00:00 | IWM | ETF | 58.54 | 58.575 | 58.37 | 58.565 | 2538600.0 |
| 2005-05-13 11:30:00 | IWM | ETF | 58.57 | 58.6 | 58.42 | 58.53 | 1493000.0 |
| 2005-05-13 12:00:00 | IWM | ETF | 58.53 | 58.605 | 58.445 | 58.45 | 738800.0 |
| 2005-05-13 12:30:00 | IWM | ETF | 58.46 | 58.48 | 58.295 | 58.305 | 881000.0 |
| 2005-05-13 13:00:00 | IWM | ETF | 58.305 | 58.36 | 58.11 | 58.125 | 738200.0 |
| 2005-05-13 13:30:00 | IWM | ETF | 58.13 | 58.2 | 57.9 | 57.975 | 2109600.0 |
> showing 50 of 1,508 rows — these rows as CSV