PREVIEW / etf_30min / 2005-01-27
file: by_date/etf_30min/2005/2005-01-27.parquet size: 41 KB rows: 1,408
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-01-27 08:00:00 | SPY | ETF | 117.36 | 117.36 | 117.23 | 117.23 | 41800.0 |
| 2005-01-27 08:30:00 | SPY | ETF | 117.3 | 117.33 | 117.15 | 117.15 | 249000.0 |
| 2005-01-27 09:00:00 | SPY | ETF | 117.18 | 117.26 | 117.18 | 117.18 | 200700.0 |
| 2005-01-27 09:30:00 | SPY | ETF | 117.19 | 117.37 | 117.02 | 117.33 | 6983200.0 |
| 2005-01-27 10:00:00 | SPY | ETF | 117.33 | 117.49 | 117.19 | 117.27 | 5906000.0 |
| 2005-01-27 10:30:00 | SPY | ETF | 117.27 | 117.6 | 117.22 | 117.58 | 5093700.0 |
| 2005-01-27 11:00:00 | SPY | ETF | 117.57 | 117.75 | 117.55 | 117.6 | 3085700.0 |
| 2005-01-27 11:30:00 | SPY | ETF | 117.6 | 117.75 | 117.56 | 117.65 | 1730600.0 |
| 2005-01-27 12:00:00 | SPY | ETF | 117.65 | 117.68 | 117.53 | 117.58 | 2482200.0 |
| 2005-01-27 12:30:00 | SPY | ETF | 117.58 | 117.67 | 117.54 | 117.54 | 1396000.0 |
| 2005-01-27 13:00:00 | SPY | ETF | 117.53 | 117.6 | 117.29 | 117.3 | 2791800.0 |
| 2005-01-27 13:30:00 | SPY | ETF | 117.29 | 117.55 | 117.07 | 117.14 | 4209100.0 |
| 2005-01-27 14:00:00 | SPY | ETF | 117.13 | 117.7 | 117.1 | 117.2 | 3259900.0 |
| 2005-01-27 14:30:00 | SPY | ETF | 117.2 | 117.31 | 117.07 | 117.14 | 2125800.0 |
| 2005-01-27 15:00:00 | SPY | ETF | 117.14 | 117.47 | 116.98 | 117.4 | 5523400.0 |
| 2005-01-27 15:30:00 | SPY | ETF | 117.4 | 117.58 | 117.37 | 117.46 | 5089600.0 |
| 2005-01-27 16:00:00 | SPY | ETF | 117.47 | 117.62 | 117.35 | 117.52 | 1829900.0 |
| 2005-01-27 16:30:00 | SPY | ETF | 117.52 | 117.69 | 117.47 | 117.6 | 1044400.0 |
| 2005-01-27 17:00:00 | SPY | ETF | 117.6 | 117.63 | 117.56 | 117.62 | 325700.0 |
| 2005-01-27 17:30:00 | SPY | ETF | 117.65 | 117.68 | 117.6 | 117.68 | 12800.0 |
| 2005-01-27 18:00:00 | SPY | ETF | 117.67 | 117.71 | 117.63 | 117.64 | 6500.0 |
| 2005-01-27 18:30:00 | SPY | ETF | 117.65 | 117.65 | 117.65 | 117.65 | 11500.0 |
| 2005-01-27 19:00:00 | SPY | ETF | 117.65 | 117.66 | 117.55 | 117.55 | 32300.0 |
| 2005-01-27 19:30:00 | SPY | ETF | 117.55 | 117.55 | 117.51 | 117.55 | 20500.0 |
| 2005-01-27 09:30:00 | QQQ | ETF | 37.08 | 37.08 | 36.9 | 36.99 | 15661000.0 |
| 2005-01-27 10:00:00 | QQQ | ETF | 36.99 | 37.05 | 36.87 | 36.93 | 9912900.0 |
| 2005-01-27 10:30:00 | QQQ | ETF | 36.93 | 37.09 | 36.88 | 37.05 | 7092900.0 |
| 2005-01-27 11:00:00 | QQQ | ETF | 37.06 | 37.2 | 37.05 | 37.11 | 7593000.0 |
| 2005-01-27 11:30:00 | QQQ | ETF | 37.11 | 37.27 | 37.1 | 37.21 | 5317100.0 |
| 2005-01-27 12:00:00 | QQQ | ETF | 37.21 | 37.22 | 37.11 | 37.14 | 3232400.0 |
| 2005-01-27 12:30:00 | QQQ | ETF | 37.14 | 37.19 | 37.11 | 37.12 | 3424000.0 |
| 2005-01-27 13:00:00 | QQQ | ETF | 37.12 | 37.13 | 36.98 | 36.98 | 5916400.0 |
| 2005-01-27 13:30:00 | QQQ | ETF | 36.98 | 37.02 | 36.9 | 36.98 | 5485900.0 |
| 2005-01-27 14:00:00 | QQQ | ETF | 36.97 | 37.01 | 36.93 | 36.99 | 3277700.0 |
| 2005-01-27 14:30:00 | QQQ | ETF | 36.99 | 37.02 | 36.93 | 36.95 | 2866700.0 |
| 2005-01-27 15:00:00 | QQQ | ETF | 36.94 | 37.15 | 36.9 | 37.11 | 7721000.0 |
| 2005-01-27 15:30:00 | QQQ | ETF | 37.11 | 37.2 | 37.09 | 37.11 | 8483200.0 |
| 2005-01-27 08:00:00 | IWM | ETF | 61.31 | 61.31 | 61.31 | 61.31 | 2000.0 |
| 2005-01-27 08:30:00 | IWM | ETF | 61.33 | 61.365 | 61.25 | 61.25 | 12400.0 |
| 2005-01-27 09:00:00 | IWM | ETF | 61.16 | 61.16 | 61.16 | 61.16 | 200.0 |
| 2005-01-27 09:30:00 | IWM | ETF | 61.19 | 61.38 | 61.075 | 61.355 | 2637400.0 |
| 2005-01-27 10:00:00 | IWM | ETF | 61.36 | 61.54 | 61.295 | 61.395 | 2884400.0 |
| 2005-01-27 10:30:00 | IWM | ETF | 61.395 | 61.725 | 61.375 | 61.66 | 2197400.0 |
| 2005-01-27 11:00:00 | IWM | ETF | 61.66 | 61.83 | 61.66 | 61.715 | 1693400.0 |
| 2005-01-27 11:30:00 | IWM | ETF | 61.715 | 61.865 | 61.67 | 61.8 | 554400.0 |
| 2005-01-27 12:00:00 | IWM | ETF | 61.8099 | 61.8099 | 61.585 | 61.615 | 437400.0 |
| 2005-01-27 12:30:00 | IWM | ETF | 61.6 | 61.695 | 61.59 | 61.665 | 744400.0 |
| 2005-01-27 13:00:00 | IWM | ETF | 61.665 | 61.705 | 61.5 | 61.5 | 631400.0 |
| 2005-01-27 13:30:00 | IWM | ETF | 61.5 | 61.57 | 61.325 | 61.37 | 1971400.0 |
| 2005-01-27 14:00:00 | IWM | ETF | 61.36 | 61.5 | 61.33 | 61.41 | 831000.0 |
> showing 50 of 1,408 rows — these rows as CSV