PREVIEW / etf_30min / 2005-03-29
file: by_date/etf_30min/2005/2005-03-29.parquet size: 46 KB rows: 1,517
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-03-29 08:00:00 | SPY | ETF | 117.04 | 117.07 | 116.98 | 117.05 | 72800.0 |
| 2005-03-29 08:30:00 | SPY | ETF | 117.06 | 117.12 | 117.05 | 117.1 | 58200.0 |
| 2005-03-29 09:00:00 | SPY | ETF | 117.1 | 117.17 | 117.1 | 117.14 | 41100.0 |
| 2005-03-29 09:30:00 | SPY | ETF | 117.14 | 117.48 | 117.06 | 117.24 | 6810500.0 |
| 2005-03-29 10:00:00 | SPY | ETF | 117.24 | 117.7 | 117.18 | 117.62 | 6304000.0 |
| 2005-03-29 10:30:00 | SPY | ETF | 117.62 | 117.9 | 117.54 | 117.76 | 4476900.0 |
| 2005-03-29 11:00:00 | SPY | ETF | 117.76 | 117.81 | 117.63 | 117.69 | 2993600.0 |
| 2005-03-29 11:30:00 | SPY | ETF | 117.7 | 117.75 | 117.54 | 117.66 | 2402600.0 |
| 2005-03-29 12:00:00 | SPY | ETF | 117.66 | 117.69 | 117.44 | 117.5 | 1617100.0 |
| 2005-03-29 12:30:00 | SPY | ETF | 117.5 | 117.56 | 117.33 | 117.44 | 1455000.0 |
| 2005-03-29 13:00:00 | SPY | ETF | 117.44 | 117.48 | 116.91 | 117.08 | 8060000.0 |
| 2005-03-29 13:30:00 | SPY | ETF | 117.09 | 117.19 | 116.98 | 117.04 | 2879100.0 |
| 2005-03-29 14:00:00 | SPY | ETF | 117.03 | 117.04 | 116.56 | 116.78 | 10730200.0 |
| 2005-03-29 14:30:00 | SPY | ETF | 116.78 | 116.94 | 116.61 | 116.88 | 4848100.0 |
| 2005-03-29 15:00:00 | SPY | ETF | 116.88 | 116.92 | 116.47 | 116.59 | 5369700.0 |
| 2005-03-29 15:30:00 | SPY | ETF | 116.65 | 116.75 | 116.25 | 116.4 | 8241900.0 |
| 2005-03-29 16:00:00 | SPY | ETF | 116.4 | 117.1 | 116.348 | 116.56 | 2243300.0 |
| 2005-03-29 16:30:00 | SPY | ETF | 116.56 | 116.82 | 116.53 | 116.53 | 283400.0 |
| 2005-03-29 17:00:00 | SPY | ETF | 116.53 | 116.6 | 116.53 | 116.59 | 23400.0 |
| 2005-03-29 17:30:00 | SPY | ETF | 116.56 | 116.61 | 116.56 | 116.61 | 53400.0 |
| 2005-03-29 18:00:00 | SPY | ETF | 116.6 | 116.6 | 116.58 | 116.58 | 2400.0 |
| 2005-03-29 18:30:00 | SPY | ETF | 116.58 | 116.61 | 116.58 | 116.61 | 3100.0 |
| 2005-03-29 19:00:00 | SPY | ETF | 116.64 | 116.64 | 116.63 | 116.63 | 1500.0 |
| 2005-03-29 19:30:00 | SPY | ETF | 116.62 | 116.64 | 116.62 | 116.64 | 2500.0 |
| 2005-03-29 09:30:00 | QQQ | ETF | 36.26 | 36.35 | 36.23 | 36.27 | 12191000.0 |
| 2005-03-29 10:00:00 | QQQ | ETF | 36.26 | 36.46 | 36.23 | 36.42 | 10220000.0 |
| 2005-03-29 10:30:00 | QQQ | ETF | 36.42 | 36.58 | 36.38 | 36.53 | 9293000.0 |
| 2005-03-29 11:00:00 | QQQ | ETF | 36.53 | 36.54 | 36.46 | 36.5 | 4416500.0 |
| 2005-03-29 11:30:00 | QQQ | ETF | 36.5 | 36.51 | 36.43 | 36.47 | 3424500.0 |
| 2005-03-29 12:00:00 | QQQ | ETF | 36.47 | 36.48 | 36.33 | 36.35 | 4545700.0 |
| 2005-03-29 12:30:00 | QQQ | ETF | 36.35 | 36.39 | 36.31 | 36.35 | 4509500.0 |
| 2005-03-29 13:00:00 | QQQ | ETF | 36.35 | 36.35 | 36.23 | 36.25 | 9380200.0 |
| 2005-03-29 13:30:00 | QQQ | ETF | 36.26 | 36.29 | 36.22 | 36.24 | 5034000.0 |
| 2005-03-29 14:00:00 | QQQ | ETF | 36.24 | 36.24 | 36.02 | 36.1 | 16842000.0 |
| 2005-03-29 14:30:00 | QQQ | ETF | 36.1 | 36.19 | 36.03 | 36.17 | 7452100.0 |
| 2005-03-29 15:00:00 | QQQ | ETF | 36.17 | 36.19 | 36.03 | 36.08 | 8264400.0 |
| 2005-03-29 15:30:00 | QQQ | ETF | 36.07 | 36.12 | 35.94 | 36.06 | 12998900.0 |
| 2005-03-29 08:00:00 | IWM | ETF | 60.96 | 60.96 | 60.96 | 60.96 | 400.0 |
| 2005-03-29 08:30:00 | IWM | ETF | 61.0 | 61.01 | 60.98 | 61.01 | 12800.0 |
| 2005-03-29 09:00:00 | IWM | ETF | 61.025 | 61.05 | 61.025 | 61.05 | 10600.0 |
| 2005-03-29 09:30:00 | IWM | ETF | 60.98 | 61.1 | 60.91 | 61.02 | 1806400.0 |
| 2005-03-29 10:00:00 | IWM | ETF | 61.01 | 61.32 | 60.94 | 61.28 | 1213800.0 |
| 2005-03-29 10:30:00 | IWM | ETF | 61.28 | 61.545 | 61.265 | 61.425 | 1557200.0 |
| 2005-03-29 11:00:00 | IWM | ETF | 61.42 | 61.435 | 61.275 | 61.29 | 1050000.0 |
| 2005-03-29 11:30:00 | IWM | ETF | 61.295 | 61.34 | 61.195 | 61.27 | 833800.0 |
| 2005-03-29 12:00:00 | IWM | ETF | 61.27 | 61.28 | 61.085 | 61.12 | 485000.0 |
| 2005-03-29 12:30:00 | IWM | ETF | 61.12 | 61.125 | 60.85 | 60.93 | 910800.0 |
| 2005-03-29 13:00:00 | IWM | ETF | 60.93 | 60.935 | 60.525 | 60.55 | 1140600.0 |
| 2005-03-29 13:30:00 | IWM | ETF | 60.555 | 60.67 | 60.535 | 60.615 | 1732800.0 |
| 2005-03-29 14:00:00 | IWM | ETF | 60.605 | 60.925 | 60.25 | 60.315 | 2361600.0 |
> showing 50 of 1,517 rows — these rows as CSV