PREVIEW / etf_30min / 2005-02-01
file: by_date/etf_30min/2005/2005-02-01.parquet size: 42 KB rows: 1,440
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-02-01 08:00:00 | SPY | ETF | 118.16 | 118.27 | 118.16 | 118.22 | 70000.0 |
| 2005-02-01 08:30:00 | SPY | ETF | 118.24 | 118.36 | 118.24 | 118.34 | 110400.0 |
| 2005-02-01 09:00:00 | SPY | ETF | 118.34 | 118.34 | 118.25 | 118.26 | 59000.0 |
| 2005-02-01 09:30:00 | SPY | ETF | 118.25 | 118.31 | 118.12 | 118.21 | 3817000.0 |
| 2005-02-01 10:00:00 | SPY | ETF | 118.19 | 118.3 | 118.1 | 118.29 | 2847400.0 |
| 2005-02-01 10:30:00 | SPY | ETF | 118.29 | 118.42 | 118.22 | 118.36 | 2708500.0 |
| 2005-02-01 11:00:00 | SPY | ETF | 118.37 | 118.56 | 118.35 | 118.43 | 3049400.0 |
| 2005-02-01 11:30:00 | SPY | ETF | 118.43 | 118.77 | 118.42 | 118.69 | 5090900.0 |
| 2005-02-01 12:00:00 | SPY | ETF | 118.7 | 118.88 | 118.65 | 118.8 | 4844100.0 |
| 2005-02-01 12:30:00 | SPY | ETF | 118.78 | 118.87 | 118.69 | 118.78 | 2618200.0 |
| 2005-02-01 13:00:00 | SPY | ETF | 118.78 | 118.83 | 118.69 | 118.81 | 1868000.0 |
| 2005-02-01 13:30:00 | SPY | ETF | 118.81 | 118.89 | 118.72 | 118.85 | 1219200.0 |
| 2005-02-01 14:00:00 | SPY | ETF | 118.88 | 119.05 | 118.85 | 118.91 | 4551400.0 |
| 2005-02-01 14:30:00 | SPY | ETF | 118.9 | 119.08 | 118.85 | 118.86 | 3891500.0 |
| 2005-02-01 15:00:00 | SPY | ETF | 118.86 | 118.96 | 118.76 | 118.78 | 3241900.0 |
| 2005-02-01 15:30:00 | SPY | ETF | 118.78 | 119.01 | 118.69 | 118.91 | 6218900.0 |
| 2005-02-01 16:00:00 | SPY | ETF | 118.88 | 119.0 | 118.79 | 118.98 | 1749000.0 |
| 2005-02-01 16:30:00 | SPY | ETF | 118.98 | 119.14 | 118.92 | 119.14 | 296600.0 |
| 2005-02-01 17:00:00 | SPY | ETF | 119.11 | 119.15 | 119.1 | 119.1 | 240500.0 |
| 2005-02-01 17:30:00 | SPY | ETF | 119.13 | 119.17 | 118.94 | 119.14 | 22000.0 |
| 2005-02-01 18:00:00 | SPY | ETF | 119.14 | 119.14 | 119.11 | 119.13 | 40500.0 |
| 2005-02-01 18:30:00 | SPY | ETF | 119.12 | 119.12 | 119.11 | 119.11 | 1400.0 |
| 2005-02-01 19:00:00 | SPY | ETF | 119.08 | 119.08 | 119.08 | 119.08 | 400.0 |
| 2005-02-01 19:30:00 | SPY | ETF | 119.08 | 119.08 | 119.08 | 119.08 | 500.0 |
| 2005-02-01 09:30:00 | QQQ | ETF | 37.48 | 37.5 | 37.39 | 37.45 | 9953600.0 |
| 2005-02-01 10:00:00 | QQQ | ETF | 37.45 | 37.52 | 37.37 | 37.52 | 6434500.0 |
| 2005-02-01 10:30:00 | QQQ | ETF | 37.51 | 37.57 | 37.48 | 37.49 | 5890600.0 |
| 2005-02-01 11:00:00 | QQQ | ETF | 37.49 | 37.55 | 37.47 | 37.47 | 3781200.0 |
| 2005-02-01 11:30:00 | QQQ | ETF | 37.47 | 37.59 | 37.47 | 37.56 | 5717200.0 |
| 2005-02-01 12:00:00 | QQQ | ETF | 37.57 | 37.65 | 37.54 | 37.59 | 4144600.0 |
| 2005-02-01 12:30:00 | QQQ | ETF | 37.6 | 37.63 | 37.48 | 37.57 | 5236500.0 |
| 2005-02-01 13:00:00 | QQQ | ETF | 37.56 | 37.58 | 37.53 | 37.57 | 2369200.0 |
| 2005-02-01 13:30:00 | QQQ | ETF | 37.57 | 37.63 | 37.53 | 37.62 | 2692700.0 |
| 2005-02-01 14:00:00 | QQQ | ETF | 37.62 | 37.64 | 37.56 | 37.57 | 4373500.0 |
| 2005-02-01 14:30:00 | QQQ | ETF | 37.57 | 37.63 | 37.52 | 37.53 | 3750800.0 |
| 2005-02-01 15:00:00 | QQQ | ETF | 37.53 | 37.54 | 37.44 | 37.46 | 6956200.0 |
| 2005-02-01 15:30:00 | QQQ | ETF | 37.46 | 37.55 | 37.43 | 37.51 | 7830800.0 |
| 2005-02-01 08:30:00 | IWM | ETF | 62.255 | 62.255 | 62.255 | 62.255 | 1000.0 |
| 2005-02-01 09:00:00 | IWM | ETF | 62.14 | 62.14 | 62.14 | 62.14 | 1800.0 |
| 2005-02-01 09:30:00 | IWM | ETF | 62.125 | 62.215 | 62.03 | 62.14 | 3455600.0 |
| 2005-02-01 10:00:00 | IWM | ETF | 62.13 | 62.35 | 62.075 | 62.35 | 1573400.0 |
| 2005-02-01 10:30:00 | IWM | ETF | 62.33 | 62.49 | 62.31 | 62.375 | 3951400.0 |
| 2005-02-01 11:00:00 | IWM | ETF | 62.375 | 62.59 | 62.365 | 62.465 | 1585200.0 |
| 2005-02-01 11:30:00 | IWM | ETF | 62.47 | 62.62 | 62.455 | 62.525 | 1409800.0 |
| 2005-02-01 12:00:00 | IWM | ETF | 62.535 | 62.685 | 62.52 | 62.54 | 672400.0 |
| 2005-02-01 12:30:00 | IWM | ETF | 62.54 | 62.59 | 62.435 | 62.465 | 705200.0 |
| 2005-02-01 13:00:00 | IWM | ETF | 62.465 | 62.49 | 62.325 | 62.415 | 615600.0 |
| 2005-02-01 13:30:00 | IWM | ETF | 62.405 | 62.495 | 62.345 | 62.49 | 365600.0 |
| 2005-02-01 14:00:00 | IWM | ETF | 62.5 | 62.55 | 62.425 | 62.445 | 678200.0 |
| 2005-02-01 14:30:00 | IWM | ETF | 62.455 | 62.605 | 62.4 | 62.445 | 855200.0 |
> showing 50 of 1,440 rows — these rows as CSV