PREVIEW / etf_30min / 2005-05-19
file: by_date/etf_30min/2005/2005-05-19.parquet size: 43 KB rows: 1,518
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-05-19 07:00:00 | SPY | ETF | 118.8 | 118.82 | 118.8 | 118.81 | 19800.0 |
| 2005-05-19 07:30:00 | SPY | ETF | 118.82 | 118.83 | 118.82 | 118.83 | 20000.0 |
| 2005-05-19 08:00:00 | SPY | ETF | 118.81 | 118.84 | 118.78 | 118.8 | 45900.0 |
| 2005-05-19 08:30:00 | SPY | ETF | 118.8 | 118.95 | 118.8 | 118.94 | 107200.0 |
| 2005-05-19 09:00:00 | SPY | ETF | 118.95 | 119.08 | 118.95 | 119.0 | 72900.0 |
| 2005-05-19 09:30:00 | SPY | ETF | 119.02 | 119.08 | 118.73 | 119.01 | 5105200.0 |
| 2005-05-19 10:00:00 | SPY | ETF | 119.01 | 119.24 | 118.84 | 118.94 | 6756600.0 |
| 2005-05-19 10:30:00 | SPY | ETF | 118.95 | 119.09 | 118.82 | 119.05 | 3909400.0 |
| 2005-05-19 11:00:00 | SPY | ETF | 119.05 | 119.32 | 118.97 | 119.07 | 3878600.0 |
| 2005-05-19 11:30:00 | SPY | ETF | 119.07 | 119.11 | 118.96 | 119.03 | 3456800.0 |
| 2005-05-19 12:00:00 | SPY | ETF | 119.03 | 119.11 | 118.83 | 119.02 | 6580500.0 |
| 2005-05-19 12:30:00 | SPY | ETF | 119.01 | 119.18 | 119.0 | 119.15 | 1879900.0 |
| 2005-05-19 13:00:00 | SPY | ETF | 119.15 | 119.24 | 119.12 | 119.15 | 2248600.0 |
| 2005-05-19 13:30:00 | SPY | ETF | 119.15 | 119.18 | 118.83 | 118.83 | 3688900.0 |
| 2005-05-19 14:00:00 | SPY | ETF | 118.84 | 119.18 | 118.78 | 119.1 | 3119400.0 |
| 2005-05-19 14:30:00 | SPY | ETF | 119.09 | 119.14 | 118.7 | 119.11 | 7079400.0 |
| 2005-05-19 15:00:00 | SPY | ETF | 119.11 | 119.36 | 119.04 | 119.25 | 4591900.0 |
| 2005-05-19 15:30:00 | SPY | ETF | 119.25 | 119.41 | 119.23 | 119.37 | 5859000.0 |
| 2005-05-19 16:00:00 | SPY | ETF | 119.37 | 119.37 | 119.25 | 119.3 | 1612500.0 |
| 2005-05-19 16:30:00 | SPY | ETF | 119.3 | 119.32 | 119.28 | 119.3 | 326900.0 |
| 2005-05-19 17:00:00 | SPY | ETF | 119.29 | 119.29 | 119.25 | 119.27 | 130100.0 |
| 2005-05-19 17:30:00 | SPY | ETF | 119.27 | 119.32 | 119.27 | 119.32 | 101400.0 |
| 2005-05-19 18:00:00 | SPY | ETF | 119.35 | 119.35 | 119.35 | 119.35 | 490000.0 |
| 2005-05-19 09:30:00 | QQQ | ETF | 37.29 | 37.39 | 37.2 | 37.37 | 11304600.0 |
| 2005-05-19 10:00:00 | QQQ | ETF | 37.37 | 37.45 | 37.31 | 37.36 | 10745500.0 |
| 2005-05-19 10:30:00 | QQQ | ETF | 37.35 | 37.4 | 37.29 | 37.39 | 5524300.0 |
| 2005-05-19 11:00:00 | QQQ | ETF | 37.38 | 37.48 | 37.36 | 37.38 | 6841600.0 |
| 2005-05-19 11:30:00 | QQQ | ETF | 37.38 | 37.42 | 37.36 | 37.41 | 3998100.0 |
| 2005-05-19 12:00:00 | QQQ | ETF | 37.41 | 37.43 | 37.32 | 37.4 | 4362800.0 |
| 2005-05-19 12:30:00 | QQQ | ETF | 37.4 | 37.47 | 37.4 | 37.45 | 3381800.0 |
| 2005-05-19 13:00:00 | QQQ | ETF | 37.46 | 37.5 | 37.43 | 37.44 | 7354800.0 |
| 2005-05-19 13:30:00 | QQQ | ETF | 37.43 | 37.49 | 37.34 | 37.36 | 5011900.0 |
| 2005-05-19 14:00:00 | QQQ | ETF | 37.35 | 37.48 | 37.31 | 37.46 | 7483800.0 |
| 2005-05-19 14:30:00 | QQQ | ETF | 37.46 | 37.47 | 37.31 | 37.41 | 8206400.0 |
| 2005-05-19 15:00:00 | QQQ | ETF | 37.41 | 37.5 | 37.39 | 37.44 | 5808700.0 |
| 2005-05-19 15:30:00 | QQQ | ETF | 37.44 | 37.52 | 37.44 | 37.51 | 7929100.0 |
| 2005-05-19 08:00:00 | IWM | ETF | 60.505 | 60.505 | 60.505 | 60.505 | 1000.0 |
| 2005-05-19 08:30:00 | IWM | ETF | 60.5 | 60.525 | 60.5 | 60.525 | 2000.0 |
| 2005-05-19 09:00:00 | IWM | ETF | 60.535 | 60.565 | 60.45 | 60.45 | 40000.0 |
| 2005-05-19 09:30:00 | IWM | ETF | 60.455 | 60.725 | 60.36 | 60.715 | 2321200.0 |
| 2005-05-19 10:00:00 | IWM | ETF | 60.715 | 60.87 | 60.635 | 60.705 | 2930800.0 |
| 2005-05-19 10:30:00 | IWM | ETF | 60.71 | 60.775 | 60.555 | 60.69 | 3211800.0 |
| 2005-05-19 11:00:00 | IWM | ETF | 60.695 | 60.815 | 60.585 | 60.635 | 1837600.0 |
| 2005-05-19 11:30:00 | IWM | ETF | 60.635 | 60.68 | 60.565 | 60.585 | 997800.0 |
| 2005-05-19 12:00:00 | IWM | ETF | 60.585 | 60.725 | 60.49 | 60.515 | 2525800.0 |
| 2005-05-19 12:30:00 | IWM | ETF | 60.525 | 60.73 | 60.525 | 60.72 | 1085200.0 |
| 2005-05-19 13:00:00 | IWM | ETF | 60.725 | 60.775 | 60.595 | 60.63 | 823400.0 |
| 2005-05-19 13:30:00 | IWM | ETF | 60.625 | 60.66 | 60.4 | 60.43 | 2435400.0 |
| 2005-05-19 14:00:00 | IWM | ETF | 60.415 | 60.595 | 60.39 | 60.575 | 1066000.0 |
| 2005-05-19 14:30:00 | IWM | ETF | 60.565 | 60.6 | 60.345 | 60.545 | 2295600.0 |
> showing 50 of 1,518 rows — these rows as CSV