PREVIEW / etf_30min / 2004-04-30
file: by_date/etf_30min/2004/2004-04-30.parquet size: 36 KB rows: 1,183
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 |
|---|---|---|---|---|---|---|---|
| 2004-04-30 08:00:00 | SPY | ETF | 112.2 | 112.3 | 112.19 | 112.23 | 29700.0 |
| 2004-04-30 08:30:00 | SPY | ETF | 112.26 | 112.38 | 112.24 | 112.3 | 61500.0 |
| 2004-04-30 09:00:00 | SPY | ETF | 112.3 | 112.3 | 112.19 | 112.23 | 27000.0 |
| 2004-04-30 09:30:00 | SPY | ETF | 112.17 | 112.38 | 111.92 | 111.94 | 5452800.0 |
| 2004-04-30 10:00:00 | SPY | ETF | 111.94 | 112.24 | 111.6 | 111.74 | 4481200.0 |
| 2004-04-30 10:30:00 | SPY | ETF | 111.75 | 112.19 | 111.49 | 111.98 | 4535800.0 |
| 2004-04-30 11:00:00 | SPY | ETF | 111.99 | 112.3 | 111.93 | 112.08 | 2706500.0 |
| 2004-04-30 11:30:00 | SPY | ETF | 112.05 | 112.06 | 111.72 | 111.86 | 1534500.0 |
| 2004-04-30 12:00:00 | SPY | ETF | 111.85 | 112.06 | 111.68 | 111.94 | 1363200.0 |
| 2004-04-30 12:30:00 | SPY | ETF | 111.93 | 112.06 | 111.6 | 111.73 | 1534900.0 |
| 2004-04-30 13:00:00 | SPY | ETF | 111.72 | 111.9 | 111.62 | 111.69 | 1364500.0 |
| 2004-04-30 13:30:00 | SPY | ETF | 111.69 | 112.06 | 111.64 | 112.0 | 1556600.0 |
| 2004-04-30 14:00:00 | SPY | ETF | 112.02 | 112.03 | 111.68 | 111.9 | 881100.0 |
| 2004-04-30 14:30:00 | SPY | ETF | 111.9 | 112.13 | 111.72 | 111.73 | 1374100.0 |
| 2004-04-30 15:00:00 | SPY | ETF | 111.74 | 111.76 | 111.1 | 111.15 | 3841000.0 |
| 2004-04-30 15:30:00 | SPY | ETF | 111.14 | 111.62 | 111.1 | 111.13 | 3752800.0 |
| 2004-04-30 16:00:00 | SPY | ETF | 111.12 | 111.14 | 110.9 | 111.13 | 3113800.0 |
| 2004-04-30 16:30:00 | SPY | ETF | 110.91 | 110.92 | 110.84 | 110.85 | 114600.0 |
| 2004-04-30 17:00:00 | SPY | ETF | 110.85 | 110.96 | 110.81 | 110.89 | 38300.0 |
| 2004-04-30 17:30:00 | SPY | ETF | 110.83 | 110.9 | 110.83 | 110.86 | 1100.0 |
| 2004-04-30 18:00:00 | SPY | ETF | 110.9 | 110.9 | 110.9 | 110.9 | 300.0 |
| 2004-04-30 18:30:00 | SPY | ETF | 110.9 | 110.9 | 110.9 | 110.9 | 200.0 |
| 2004-04-30 19:30:00 | SPY | ETF | 110.9 | 110.9 | 110.9 | 110.9 | 1600.0 |
| 2004-04-30 08:00:00 | QQQ | ETF | 35.72 | 35.8 | 35.68 | 35.76 | 138800.0 |
| 2004-04-30 08:30:00 | QQQ | ETF | 35.76 | 35.83 | 35.74 | 35.78 | 515200.0 |
| 2004-04-30 09:00:00 | QQQ | ETF | 35.77 | 35.8 | 35.66 | 35.67 | 331300.0 |
| 2004-04-30 09:30:00 | QQQ | ETF | 35.66 | 35.8 | 35.51 | 35.569 | 17304200.0 |
| 2004-04-30 10:00:00 | QQQ | ETF | 35.56 | 35.63 | 35.36 | 35.455 | 11514600.0 |
| 2004-04-30 10:30:00 | QQQ | ETF | 35.46 | 35.59 | 35.32 | 35.48 | 12115300.0 |
| 2004-04-30 11:00:00 | QQQ | ETF | 35.48 | 35.63 | 35.43 | 35.532 | 7645500.0 |
| 2004-04-30 11:30:00 | QQQ | ETF | 35.532 | 35.54 | 35.3 | 35.36 | 5207900.0 |
| 2004-04-30 12:00:00 | QQQ | ETF | 35.36 | 35.421 | 35.2 | 35.337 | 7252300.0 |
| 2004-04-30 12:30:00 | QQQ | ETF | 35.34 | 35.37 | 35.18 | 35.23 | 5050400.0 |
| 2004-04-30 13:00:00 | QQQ | ETF | 35.247 | 35.29 | 35.17 | 35.197 | 4759800.0 |
| 2004-04-30 13:30:00 | QQQ | ETF | 35.197 | 35.42 | 35.18 | 35.32 | 8503200.0 |
| 2004-04-30 14:00:00 | QQQ | ETF | 35.31 | 35.37 | 35.2 | 35.29 | 3492500.0 |
| 2004-04-30 14:30:00 | QQQ | ETF | 35.2895 | 35.4 | 35.22 | 35.232 | 5164200.0 |
| 2004-04-30 15:00:00 | QQQ | ETF | 35.23 | 35.237 | 34.83 | 34.89 | 13702500.0 |
| 2004-04-30 15:30:00 | QQQ | ETF | 34.89 | 35.12 | 34.83 | 34.837 | 16027300.0 |
| 2004-04-30 16:00:00 | QQQ | ETF | 34.86 | 34.95 | 34.71 | 34.75 | 7358000.0 |
| 2004-04-30 16:30:00 | QQQ | ETF | 34.75 | 34.95 | 34.74 | 34.76 | 309500.0 |
| 2004-04-30 17:00:00 | QQQ | ETF | 34.77 | 34.91 | 34.74 | 34.76 | 680900.0 |
| 2004-04-30 17:30:00 | QQQ | ETF | 34.76 | 34.77 | 34.73 | 34.75 | 59300.0 |
| 2004-04-30 18:00:00 | QQQ | ETF | 34.75 | 34.75 | 34.73 | 34.75 | 18200.0 |
| 2004-04-30 18:30:00 | QQQ | ETF | 34.76 | 34.77 | 34.76 | 34.76 | 3800.0 |
| 2004-04-30 19:00:00 | QQQ | ETF | 34.77 | 34.79 | 34.76 | 34.76 | 4900.0 |
| 2004-04-30 19:30:00 | QQQ | ETF | 34.79 | 34.79 | 34.75 | 34.75 | 3900.0 |
| 2004-04-30 08:00:00 | IWM | ETF | 56.75 | 56.825 | 56.75 | 56.825 | 37000.0 |
| 2004-04-30 08:30:00 | IWM | ETF | 56.84 | 56.845 | 56.825 | 56.845 | 11800.0 |
| 2004-04-30 09:00:00 | IWM | ETF | 56.815 | 56.83 | 56.805 | 56.825 | 66200.0 |
> showing 50 of 1,183 rows — these rows as CSV