PREVIEW / etf_30min / 2005-06-03
file: by_date/etf_30min/2005/2005-06-03.parquet size: 45 KB rows: 1,526
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-06-03 07:00:00 | SPY | ETF | 120.64 | 120.64 | 120.57 | 120.57 | 6200.0 |
| 2005-06-03 07:30:00 | SPY | ETF | 120.61 | 120.61 | 120.61 | 120.61 | 200.0 |
| 2005-06-03 08:00:00 | SPY | ETF | 120.65 | 120.82 | 120.64 | 120.77 | 180000.0 |
| 2005-06-03 08:30:00 | SPY | ETF | 120.73 | 120.95 | 120.47 | 120.74 | 1144300.0 |
| 2005-06-03 09:00:00 | SPY | ETF | 120.74 | 120.8 | 120.58 | 120.58 | 509600.0 |
| 2005-06-03 09:30:00 | SPY | ETF | 120.55 | 120.89 | 120.46 | 120.74 | 6759600.0 |
| 2005-06-03 10:00:00 | SPY | ETF | 120.72 | 120.74 | 120.33 | 120.43 | 6274800.0 |
| 2005-06-03 10:30:00 | SPY | ETF | 120.44 | 120.65 | 120.38 | 120.55 | 3334300.0 |
| 2005-06-03 11:00:00 | SPY | ETF | 120.55 | 120.62 | 120.38 | 120.41 | 2894400.0 |
| 2005-06-03 11:30:00 | SPY | ETF | 120.41 | 120.42 | 119.82 | 119.96 | 8310400.0 |
| 2005-06-03 12:00:00 | SPY | ETF | 119.96 | 120.14 | 119.76 | 119.88 | 4275300.0 |
| 2005-06-03 12:30:00 | SPY | ETF | 119.88 | 119.94 | 119.75 | 119.91 | 2686400.0 |
| 2005-06-03 13:00:00 | SPY | ETF | 119.91 | 120.0 | 119.83 | 120.0 | 1902900.0 |
| 2005-06-03 13:30:00 | SPY | ETF | 119.97 | 120.07 | 119.95 | 120.0 | 2585800.0 |
| 2005-06-03 14:00:00 | SPY | ETF | 120.0 | 120.18 | 119.85 | 120.03 | 2564200.0 |
| 2005-06-03 14:30:00 | SPY | ETF | 120.0 | 120.04 | 119.77 | 119.88 | 4530800.0 |
| 2005-06-03 15:00:00 | SPY | ETF | 119.89 | 120.03 | 119.73 | 119.81 | 3099400.0 |
| 2005-06-03 15:30:00 | SPY | ETF | 119.79 | 120.09 | 119.78 | 119.94 | 5032900.0 |
| 2005-06-03 16:00:00 | SPY | ETF | 119.95 | 120.63 | 119.92 | 120.14 | 819700.0 |
| 2005-06-03 16:30:00 | SPY | ETF | 120.14 | 120.15 | 119.92 | 120.11 | 1149400.0 |
| 2005-06-03 17:00:00 | SPY | ETF | 120.14 | 120.15 | 120.05 | 120.08 | 13800.0 |
| 2005-06-03 17:30:00 | SPY | ETF | 120.08 | 120.1 | 120.08 | 120.1 | 700.0 |
| 2005-06-03 18:00:00 | SPY | ETF | 120.1 | 120.15 | 120.07 | 120.15 | 9500.0 |
| 2005-06-03 18:30:00 | SPY | ETF | 120.15 | 120.15 | 120.14 | 120.15 | 15500.0 |
| 2005-06-03 19:30:00 | SPY | ETF | 120.15 | 120.15 | 120.15 | 120.15 | 1200.0 |
| 2005-06-03 09:30:00 | QQQ | ETF | 38.63 | 38.64 | 38.5 | 38.57 | 13717300.0 |
| 2005-06-03 10:00:00 | QQQ | ETF | 38.56 | 39.0 | 38.31 | 38.35 | 11503200.0 |
| 2005-06-03 10:30:00 | QQQ | ETF | 38.35 | 38.42 | 38.34 | 38.4 | 6947400.0 |
| 2005-06-03 11:00:00 | QQQ | ETF | 38.4 | 38.41 | 38.31 | 38.33 | 3815700.0 |
| 2005-06-03 11:30:00 | QQQ | ETF | 38.33 | 38.33 | 38.13 | 38.2 | 9622300.0 |
| 2005-06-03 12:00:00 | QQQ | ETF | 38.19 | 38.23 | 38.15 | 38.18 | 3239100.0 |
| 2005-06-03 12:30:00 | QQQ | ETF | 38.19 | 38.2 | 38.13 | 38.19 | 3686000.0 |
| 2005-06-03 13:00:00 | QQQ | ETF | 38.19 | 38.22 | 38.13 | 38.2 | 3644000.0 |
| 2005-06-03 13:30:00 | QQQ | ETF | 38.2 | 38.23 | 38.19 | 38.2 | 5500200.0 |
| 2005-06-03 14:00:00 | QQQ | ETF | 38.2 | 38.21 | 38.15 | 38.16 | 2772000.0 |
| 2005-06-03 14:30:00 | QQQ | ETF | 38.16 | 38.17 | 38.05 | 38.1 | 7056300.0 |
| 2005-06-03 15:00:00 | QQQ | ETF | 38.09 | 38.13 | 38.02 | 38.05 | 5716100.0 |
| 2005-06-03 15:30:00 | QQQ | ETF | 38.05 | 38.13 | 38.03 | 38.1 | 8224500.0 |
| 2005-06-03 08:00:00 | IWM | ETF | 62.195 | 62.195 | 62.195 | 62.195 | 6000.0 |
| 2005-06-03 08:30:00 | IWM | ETF | 62.185 | 62.355 | 62.175 | 62.25 | 32000.0 |
| 2005-06-03 09:00:00 | IWM | ETF | 62.16 | 62.16 | 62.13 | 62.14 | 18600.0 |
| 2005-06-03 09:30:00 | IWM | ETF | 62.145 | 62.415 | 62.07 | 62.36 | 2736200.0 |
| 2005-06-03 10:00:00 | IWM | ETF | 62.345 | 62.345 | 62.05 | 62.095 | 2083400.0 |
| 2005-06-03 10:30:00 | IWM | ETF | 62.115 | 62.25 | 62.1 | 62.185 | 1383800.0 |
| 2005-06-03 11:00:00 | IWM | ETF | 62.185 | 62.215 | 62.01 | 62.045 | 881000.0 |
| 2005-06-03 11:30:00 | IWM | ETF | 62.05 | 62.05 | 61.625 | 61.69 | 3413400.0 |
| 2005-06-03 12:00:00 | IWM | ETF | 61.69 | 61.73 | 61.555 | 61.665 | 1716600.0 |
| 2005-06-03 12:30:00 | IWM | ETF | 61.67 | 61.69 | 61.59 | 61.675 | 616800.0 |
| 2005-06-03 13:00:00 | IWM | ETF | 61.675 | 61.75 | 61.665 | 61.75 | 822400.0 |
| 2005-06-03 13:30:00 | IWM | ETF | 61.75 | 61.86 | 61.75 | 61.81 | 372000.0 |
> showing 50 of 1,526 rows — these rows as CSV