PREVIEW / etf_30min / 2005-04-08
file: by_date/etf_30min/2005/2005-04-08.parquet size: 43 KB rows: 1,490
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-08 08:00:00 | SPY | ETF | 119.2 | 119.2 | 119.16 | 119.16 | 11600.0 |
| 2005-04-08 08:30:00 | SPY | ETF | 119.19 | 119.2 | 119.19 | 119.19 | 1500.0 |
| 2005-04-08 09:00:00 | SPY | ETF | 119.19 | 119.2 | 119.15 | 119.15 | 15300.0 |
| 2005-04-08 09:30:00 | SPY | ETF | 119.17 | 119.21 | 119.04 | 119.13 | 5307900.0 |
| 2005-04-08 10:00:00 | SPY | ETF | 119.13 | 119.19 | 118.72 | 118.78 | 5941400.0 |
| 2005-04-08 10:30:00 | SPY | ETF | 118.78 | 118.86 | 118.66 | 118.81 | 4752900.0 |
| 2005-04-08 11:00:00 | SPY | ETF | 118.81 | 118.92 | 118.69 | 118.79 | 4312300.0 |
| 2005-04-08 11:30:00 | SPY | ETF | 118.8 | 118.9 | 118.52 | 118.66 | 5723600.0 |
| 2005-04-08 12:00:00 | SPY | ETF | 118.67 | 118.87 | 118.65 | 118.79 | 2114800.0 |
| 2005-04-08 12:30:00 | SPY | ETF | 118.79 | 118.82 | 118.53 | 118.55 | 1697800.0 |
| 2005-04-08 13:00:00 | SPY | ETF | 118.56 | 118.79 | 118.54 | 118.65 | 7538700.0 |
| 2005-04-08 13:30:00 | SPY | ETF | 118.66 | 118.79 | 118.62 | 118.71 | 1720600.0 |
| 2005-04-08 14:00:00 | SPY | ETF | 118.71 | 118.72 | 118.35 | 118.39 | 4552300.0 |
| 2005-04-08 14:30:00 | SPY | ETF | 118.39 | 118.54 | 118.34 | 118.44 | 3758000.0 |
| 2005-04-08 15:00:00 | SPY | ETF | 118.449 | 118.47 | 118.14 | 118.21 | 5455300.0 |
| 2005-04-08 15:30:00 | SPY | ETF | 118.21 | 118.29 | 118.08 | 118.09 | 5795900.0 |
| 2005-04-08 16:00:00 | SPY | ETF | 118.12 | 118.17 | 117.9 | 117.95 | 2245400.0 |
| 2005-04-08 16:30:00 | SPY | ETF | 117.94 | 118.12 | 117.75 | 117.83 | 1018800.0 |
| 2005-04-08 17:00:00 | SPY | ETF | 117.84 | 117.9 | 117.81 | 117.82 | 43600.0 |
| 2005-04-08 17:30:00 | SPY | ETF | 117.81 | 117.94 | 117.75 | 117.78 | 54400.0 |
| 2005-04-08 18:00:00 | SPY | ETF | 117.77 | 117.8 | 117.7 | 117.72 | 12800.0 |
| 2005-04-08 18:30:00 | SPY | ETF | 117.7 | 117.79 | 117.7 | 117.78 | 1500.0 |
| 2005-04-08 19:00:00 | SPY | ETF | 117.78 | 117.82 | 117.78 | 117.82 | 1100.0 |
| 2005-04-08 19:30:00 | SPY | ETF | 117.85 | 117.85 | 117.73 | 117.73 | 4500.0 |
| 2005-04-08 09:30:00 | QQQ | ETF | 37.01 | 37.04 | 36.95 | 37.03 | 11590400.0 |
| 2005-04-08 10:00:00 | QQQ | ETF | 37.03 | 37.07 | 36.9 | 36.94 | 11871100.0 |
| 2005-04-08 10:30:00 | QQQ | ETF | 36.94 | 36.97 | 36.86 | 36.91 | 5045800.0 |
| 2005-04-08 11:00:00 | QQQ | ETF | 36.91 | 36.93 | 36.86 | 36.86 | 3482100.0 |
| 2005-04-08 11:30:00 | QQQ | ETF | 36.86 | 36.93 | 36.78 | 36.82 | 4977400.0 |
| 2005-04-08 12:00:00 | QQQ | ETF | 36.81 | 36.88 | 36.79 | 36.87 | 3909600.0 |
| 2005-04-08 12:30:00 | QQQ | ETF | 36.88 | 36.88 | 36.73 | 36.73 | 3050500.0 |
| 2005-04-08 13:00:00 | QQQ | ETF | 36.73 | 36.84 | 36.72 | 36.8 | 4659600.0 |
| 2005-04-08 13:30:00 | QQQ | ETF | 36.8 | 36.85 | 36.8 | 36.81 | 2948000.0 |
| 2005-04-08 14:00:00 | QQQ | ETF | 36.81 | 36.82 | 36.66 | 36.67 | 10095500.0 |
| 2005-04-08 14:30:00 | QQQ | ETF | 36.67 | 36.72 | 36.65 | 36.72 | 5067100.0 |
| 2005-04-08 15:00:00 | QQQ | ETF | 36.71 | 36.72 | 36.62 | 36.65 | 8702800.0 |
| 2005-04-08 15:30:00 | QQQ | ETF | 36.64 | 36.66 | 36.6 | 36.64 | 9037800.0 |
| 2005-04-08 09:00:00 | IWM | ETF | 61.605 | 61.605 | 61.605 | 61.605 | 3000.0 |
| 2005-04-08 09:30:00 | IWM | ETF | 61.53 | 61.66 | 61.35 | 61.48 | 1169400.0 |
| 2005-04-08 10:00:00 | IWM | ETF | 61.475 | 61.52 | 61.305 | 61.315 | 2760000.0 |
| 2005-04-08 10:30:00 | IWM | ETF | 61.31 | 61.325 | 61.115 | 61.215 | 2618400.0 |
| 2005-04-08 11:00:00 | IWM | ETF | 61.215 | 61.25 | 61.14 | 61.15 | 1980400.0 |
| 2005-04-08 11:30:00 | IWM | ETF | 61.115 | 61.165 | 60.935 | 61.01 | 1307400.0 |
| 2005-04-08 12:00:00 | IWM | ETF | 61.01 | 61.13 | 60.975 | 61.115 | 672800.0 |
| 2005-04-08 12:30:00 | IWM | ETF | 61.105 | 61.13 | 60.94 | 60.965 | 696800.0 |
| 2005-04-08 13:00:00 | IWM | ETF | 60.96 | 61.125 | 60.945 | 61.005 | 736400.0 |
| 2005-04-08 13:30:00 | IWM | ETF | 60.995 | 61.09 | 60.96 | 61.0 | 572000.0 |
| 2005-04-08 14:00:00 | IWM | ETF | 60.985 | 60.995 | 60.765 | 60.795 | 1310000.0 |
| 2005-04-08 14:30:00 | IWM | ETF | 60.8 | 60.925 | 60.78 | 60.87 | 906000.0 |
| 2005-04-08 15:00:00 | IWM | ETF | 60.86 | 60.89 | 60.695 | 60.725 | 1348000.0 |
> showing 50 of 1,490 rows — these rows as CSV