PREVIEW / etf_30min / 2005-03-28
file: by_date/etf_30min/2005/2005-03-28.parquet size: 42 KB rows: 1,488
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-28 08:00:00 | SPY | ETF | 117.4 | 117.41 | 117.38 | 117.4 | 80400.0 |
| 2005-03-28 08:30:00 | SPY | ETF | 117.38 | 117.45 | 117.38 | 117.41 | 110900.0 |
| 2005-03-28 09:00:00 | SPY | ETF | 117.41 | 117.51 | 117.4 | 117.42 | 325300.0 |
| 2005-03-28 09:30:00 | SPY | ETF | 117.42 | 117.71 | 117.34 | 117.66 | 7761800.0 |
| 2005-03-28 10:00:00 | SPY | ETF | 117.67 | 117.76 | 117.55 | 117.64 | 3981600.0 |
| 2005-03-28 10:30:00 | SPY | ETF | 117.64 | 117.88 | 117.64 | 117.72 | 3528600.0 |
| 2005-03-28 11:00:00 | SPY | ETF | 117.72 | 117.76 | 117.59 | 117.68 | 2605500.0 |
| 2005-03-28 11:30:00 | SPY | ETF | 117.69 | 117.77 | 117.48 | 117.53 | 3925900.0 |
| 2005-03-28 12:00:00 | SPY | ETF | 117.53 | 117.6 | 117.38 | 117.58 | 2867200.0 |
| 2005-03-28 12:30:00 | SPY | ETF | 117.59 | 117.64 | 117.49 | 117.57 | 855200.0 |
| 2005-03-28 13:00:00 | SPY | ETF | 117.56 | 117.71 | 117.55 | 117.61 | 826200.0 |
| 2005-03-28 13:30:00 | SPY | ETF | 117.6 | 117.76 | 117.6 | 117.68 | 1711800.0 |
| 2005-03-28 14:00:00 | SPY | ETF | 117.68 | 117.7 | 117.47 | 117.69 | 3084300.0 |
| 2005-03-28 14:30:00 | SPY | ETF | 117.69 | 117.94 | 117.64 | 117.83 | 4567400.0 |
| 2005-03-28 15:00:00 | SPY | ETF | 117.82 | 117.88 | 117.6 | 117.65 | 2250600.0 |
| 2005-03-28 15:30:00 | SPY | ETF | 117.66 | 117.68 | 117.33 | 117.37 | 5163800.0 |
| 2005-03-28 16:00:00 | SPY | ETF | 117.38 | 117.46 | 117.18 | 117.31 | 1601700.0 |
| 2005-03-28 16:30:00 | SPY | ETF | 117.33 | 117.38 | 117.31 | 117.35 | 161800.0 |
| 2005-03-28 17:00:00 | SPY | ETF | 117.32 | 117.32 | 117.29 | 117.31 | 20200.0 |
| 2005-03-28 17:30:00 | SPY | ETF | 117.34 | 117.35 | 117.32 | 117.32 | 2400.0 |
| 2005-03-28 18:00:00 | SPY | ETF | 117.31 | 117.31 | 116.9 | 117.3 | 11900.0 |
| 2005-03-28 19:00:00 | SPY | ETF | 117.31 | 117.35 | 117.31 | 117.35 | 1100.0 |
| 2005-03-28 19:30:00 | SPY | ETF | 117.31 | 117.31 | 117.31 | 117.31 | 100.0 |
| 2005-03-28 09:30:00 | QQQ | ETF | 36.41 | 36.54 | 36.37 | 36.5 | 9915300.0 |
| 2005-03-28 10:00:00 | QQQ | ETF | 36.5 | 36.52 | 36.41 | 36.46 | 6124900.0 |
| 2005-03-28 10:30:00 | QQQ | ETF | 36.46 | 36.61 | 36.46 | 36.55 | 6686900.0 |
| 2005-03-28 11:00:00 | QQQ | ETF | 36.55 | 36.58 | 36.49 | 36.51 | 2574000.0 |
| 2005-03-28 11:30:00 | QQQ | ETF | 36.52 | 36.55 | 36.44 | 36.47 | 3178800.0 |
| 2005-03-28 12:00:00 | QQQ | ETF | 36.47 | 36.52 | 36.41 | 36.52 | 2846100.0 |
| 2005-03-28 12:30:00 | QQQ | ETF | 36.51 | 36.53 | 36.45 | 36.48 | 1240400.0 |
| 2005-03-28 13:00:00 | QQQ | ETF | 36.49 | 36.55 | 36.47 | 36.49 | 2213500.0 |
| 2005-03-28 13:30:00 | QQQ | ETF | 36.49 | 36.58 | 36.48 | 36.49 | 3106300.0 |
| 2005-03-28 14:00:00 | QQQ | ETF | 36.49 | 36.49 | 36.38 | 36.46 | 5389100.0 |
| 2005-03-28 14:30:00 | QQQ | ETF | 36.46 | 36.55 | 36.44 | 36.5 | 4546800.0 |
| 2005-03-28 15:00:00 | QQQ | ETF | 36.5 | 36.52 | 36.42 | 36.44 | 3222400.0 |
| 2005-03-28 15:30:00 | QQQ | ETF | 36.44 | 36.45 | 36.31 | 36.33 | 5933700.0 |
| 2005-03-28 08:30:00 | IWM | ETF | 61.25 | 61.305 | 61.25 | 61.305 | 25000.0 |
| 2005-03-28 09:00:00 | IWM | ETF | 61.315 | 61.35 | 61.3 | 61.31 | 12600.0 |
| 2005-03-28 09:30:00 | IWM | ETF | 61.255 | 61.5 | 61.2 | 61.455 | 2303200.0 |
| 2005-03-28 10:00:00 | IWM | ETF | 61.45 | 61.505 | 61.315 | 61.375 | 974000.0 |
| 2005-03-28 10:30:00 | IWM | ETF | 61.375 | 61.46 | 61.3 | 61.3 | 1262000.0 |
| 2005-03-28 11:00:00 | IWM | ETF | 61.295 | 61.31 | 61.235 | 61.29 | 677000.0 |
| 2005-03-28 11:30:00 | IWM | ETF | 61.285 | 61.355 | 61.13 | 61.16 | 486400.0 |
| 2005-03-28 12:00:00 | IWM | ETF | 61.16 | 61.16 | 60.97 | 61.025 | 798200.0 |
| 2005-03-28 12:30:00 | IWM | ETF | 61.025 | 61.095 | 61.02 | 61.09 | 480800.0 |
| 2005-03-28 13:00:00 | IWM | ETF | 61.09 | 61.145 | 61.055 | 61.125 | 475000.0 |
| 2005-03-28 13:30:00 | IWM | ETF | 61.12 | 61.23 | 61.115 | 61.165 | 434400.0 |
| 2005-03-28 14:00:00 | IWM | ETF | 61.15 | 61.19 | 61.005 | 61.19 | 518200.0 |
| 2005-03-28 14:30:00 | IWM | ETF | 61.19 | 61.29 | 61.16 | 61.225 | 777400.0 |
| 2005-03-28 15:00:00 | IWM | ETF | 61.215 | 61.255 | 61.13 | 61.16 | 602600.0 |
> showing 50 of 1,488 rows — these rows as CSV