PREVIEW / etf_30min / 2005-04-05
file: by_date/etf_30min/2005/2005-04-05.parquet size: 39 KB rows: 1,431
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-04-05 08:00:00 | SPY | ETF | 117.81 | 117.84 | 117.77 | 117.83 | 104600.0 |
| 2005-04-05 08:30:00 | SPY | ETF | 117.85 | 117.89 | 117.82 | 117.83 | 309900.0 |
| 2005-04-05 09:00:00 | SPY | ETF | 117.83 | 117.87 | 117.79 | 117.79 | 40300.0 |
| 2005-04-05 09:30:00 | SPY | ETF | 117.78 | 118.26 | 117.77 | 118.24 | 5979000.0 |
| 2005-04-05 10:00:00 | SPY | ETF | 118.24 | 118.29 | 118.07 | 118.1 | 5169100.0 |
| 2005-04-05 10:30:00 | SPY | ETF | 118.1 | 118.38 | 118.09 | 118.2 | 4926200.0 |
| 2005-04-05 11:00:00 | SPY | ETF | 118.2 | 118.21 | 117.98 | 118.1 | 2813800.0 |
| 2005-04-05 11:30:00 | SPY | ETF | 118.08 | 118.15 | 117.9 | 117.95 | 2420500.0 |
| 2005-04-05 12:00:00 | SPY | ETF | 117.96 | 118.18 | 117.9 | 118.13 | 2945100.0 |
| 2005-04-05 12:30:00 | SPY | ETF | 118.13 | 118.2 | 118.02 | 118.03 | 1583000.0 |
| 2005-04-05 13:00:00 | SPY | ETF | 118.04 | 118.24 | 118.03 | 118.14 | 1660900.0 |
| 2005-04-05 13:30:00 | SPY | ETF | 118.14 | 118.32 | 118.01 | 118.24 | 2228300.0 |
| 2005-04-05 14:00:00 | SPY | ETF | 118.24 | 118.32 | 117.67 | 118.09 | 5835500.0 |
| 2005-04-05 14:30:00 | SPY | ETF | 118.08 | 118.18 | 117.97 | 118.0 | 2598600.0 |
| 2005-04-05 15:00:00 | SPY | ETF | 118.0 | 118.15 | 117.97 | 118.07 | 2230300.0 |
| 2005-04-05 15:30:00 | SPY | ETF | 118.07 | 118.22 | 118.0 | 118.08 | 3566600.0 |
| 2005-04-05 16:00:00 | SPY | ETF | 118.08 | 118.19 | 118.0 | 118.15 | 999500.0 |
| 2005-04-05 16:30:00 | SPY | ETF | 118.12 | 118.17 | 118.1 | 118.1 | 2535000.0 |
| 2005-04-05 17:00:00 | SPY | ETF | 118.12 | 118.13 | 118.08 | 118.1 | 57600.0 |
| 2005-04-05 17:30:00 | SPY | ETF | 118.14 | 118.14 | 118.14 | 118.14 | 100.0 |
| 2005-04-05 18:00:00 | SPY | ETF | 118.07 | 118.07 | 118.07 | 118.07 | 100.0 |
| 2005-04-05 18:30:00 | SPY | ETF | 118.09 | 118.09 | 118.09 | 118.09 | 1000.0 |
| 2005-04-05 19:30:00 | SPY | ETF | 118.1 | 118.1 | 118.1 | 118.1 | 200.0 |
| 2005-04-05 09:30:00 | QQQ | ETF | 36.49 | 36.66 | 36.44 | 36.64 | 10007200.0 |
| 2005-04-05 10:00:00 | QQQ | ETF | 36.65 | 36.67 | 36.53 | 36.55 | 7213300.0 |
| 2005-04-05 10:30:00 | QQQ | ETF | 36.55 | 36.65 | 36.49 | 36.56 | 6864300.0 |
| 2005-04-05 11:00:00 | QQQ | ETF | 36.56 | 36.56 | 36.45 | 36.5 | 4762200.0 |
| 2005-04-05 11:30:00 | QQQ | ETF | 36.49 | 36.56 | 36.47 | 36.5 | 4029000.0 |
| 2005-04-05 12:00:00 | QQQ | ETF | 36.5 | 36.56 | 36.47 | 36.55 | 2196300.0 |
| 2005-04-05 12:30:00 | QQQ | ETF | 36.55 | 36.59 | 36.53 | 36.54 | 1810500.0 |
| 2005-04-05 13:00:00 | QQQ | ETF | 36.54 | 36.62 | 36.53 | 36.58 | 4600400.0 |
| 2005-04-05 13:30:00 | QQQ | ETF | 36.58 | 36.63 | 36.52 | 36.6 | 2982500.0 |
| 2005-04-05 14:00:00 | QQQ | ETF | 36.6 | 36.63 | 36.42 | 36.55 | 6269500.0 |
| 2005-04-05 14:30:00 | QQQ | ETF | 36.55 | 36.58 | 36.5 | 36.52 | 2927300.0 |
| 2005-04-05 15:00:00 | QQQ | ETF | 36.52 | 36.57 | 36.51 | 36.56 | 2438100.0 |
| 2005-04-05 15:30:00 | QQQ | ETF | 36.55 | 36.6 | 36.53 | 36.55 | 4975300.0 |
| 2005-04-05 08:00:00 | IWM | ETF | 61.165 | 61.165 | 61.155 | 61.155 | 3200.0 |
| 2005-04-05 08:30:00 | IWM | ETF | 61.155 | 61.155 | 61.155 | 61.155 | 1000.0 |
| 2005-04-05 09:00:00 | IWM | ETF | 61.145 | 61.145 | 61.11 | 61.145 | 16400.0 |
| 2005-04-05 09:30:00 | IWM | ETF | 61.065 | 61.3 | 61.0 | 61.285 | 2846600.0 |
| 2005-04-05 10:00:00 | IWM | ETF | 61.29 | 61.325 | 61.075 | 61.125 | 1688200.0 |
| 2005-04-05 10:30:00 | IWM | ETF | 61.12 | 61.265 | 61.065 | 61.125 | 871000.0 |
| 2005-04-05 11:00:00 | IWM | ETF | 61.125 | 61.125 | 60.89 | 60.945 | 1744800.0 |
| 2005-04-05 11:30:00 | IWM | ETF | 60.945 | 61.035 | 60.875 | 60.9 | 1127400.0 |
| 2005-04-05 12:00:00 | IWM | ETF | 60.89 | 61.08 | 60.885 | 61.075 | 831400.0 |
| 2005-04-05 12:30:00 | IWM | ETF | 61.055 | 61.15 | 61.035 | 61.1 | 402000.0 |
| 2005-04-05 13:00:00 | IWM | ETF | 61.09 | 61.215 | 61.085 | 61.12 | 1681600.0 |
| 2005-04-05 13:30:00 | IWM | ETF | 61.12 | 61.19 | 61.04 | 61.125 | 1137200.0 |
| 2005-04-05 14:00:00 | IWM | ETF | 61.125 | 61.18 | 60.875 | 61.13 | 1102400.0 |
| 2005-04-05 14:30:00 | IWM | ETF | 61.125 | 61.125 | 61.01 | 61.04 | 1116800.0 |
> showing 50 of 1,431 rows — these rows as CSV