PREVIEW / etf_30min / 2005-04-11
file: by_date/etf_30min/2005/2005-04-11.parquet size: 41 KB rows: 1,434
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-11 07:30:00 | SPY | ETF | 118.22 | 118.25 | 118.18 | 118.19 | 15500.0 |
| 2005-04-11 08:00:00 | SPY | ETF | 118.19 | 118.27 | 118.18 | 118.27 | 186900.0 |
| 2005-04-11 08:30:00 | SPY | ETF | 118.27 | 118.36 | 118.26 | 118.33 | 71400.0 |
| 2005-04-11 09:00:00 | SPY | ETF | 118.32 | 118.36 | 118.3 | 118.31 | 62200.0 |
| 2005-04-11 09:30:00 | SPY | ETF | 118.29 | 118.42 | 118.11 | 118.13 | 6191400.0 |
| 2005-04-11 10:00:00 | SPY | ETF | 118.13 | 118.2 | 117.83 | 118.04 | 6195400.0 |
| 2005-04-11 10:30:00 | SPY | ETF | 118.03 | 118.25 | 117.97 | 118.07 | 4605000.0 |
| 2005-04-11 11:00:00 | SPY | ETF | 118.07 | 118.19 | 117.96 | 118.0 | 1770100.0 |
| 2005-04-11 11:30:00 | SPY | ETF | 117.99 | 118.09 | 117.86 | 117.95 | 2350100.0 |
| 2005-04-11 12:00:00 | SPY | ETF | 117.95 | 118.29 | 117.93 | 118.25 | 3149800.0 |
| 2005-04-11 12:30:00 | SPY | ETF | 118.26 | 118.36 | 118.14 | 118.243 | 1901600.0 |
| 2005-04-11 13:00:00 | SPY | ETF | 118.22 | 118.32 | 118.02 | 118.13 | 1278900.0 |
| 2005-04-11 13:30:00 | SPY | ETF | 118.12 | 118.24 | 118.03 | 118.07 | 1902200.0 |
| 2005-04-11 14:00:00 | SPY | ETF | 118.07 | 118.2 | 118.0 | 118.09 | 1857200.0 |
| 2005-04-11 14:30:00 | SPY | ETF | 118.1 | 118.34 | 118.09 | 118.25 | 2279100.0 |
| 2005-04-11 15:00:00 | SPY | ETF | 118.27 | 118.29 | 118.11 | 118.15 | 2610500.0 |
| 2005-04-11 15:30:00 | SPY | ETF | 118.14 | 118.19 | 118.05 | 118.19 | 3573600.0 |
| 2005-04-11 16:00:00 | SPY | ETF | 118.2 | 118.25 | 118.09 | 118.15 | 3650700.0 |
| 2005-04-11 16:30:00 | SPY | ETF | 118.15 | 118.15 | 118.07 | 118.11 | 60400.0 |
| 2005-04-11 17:00:00 | SPY | ETF | 118.09 | 118.09 | 118.09 | 118.09 | 400.0 |
| 2005-04-11 17:30:00 | SPY | ETF | 118.12 | 118.12 | 118.12 | 118.12 | 860000.0 |
| 2005-04-11 18:00:00 | SPY | ETF | 118.09 | 118.09 | 118.08 | 118.09 | 800.0 |
| 2005-04-11 09:30:00 | QQQ | ETF | 36.75 | 36.78 | 36.64 | 36.65 | 7237300.0 |
| 2005-04-11 10:00:00 | QQQ | ETF | 36.65 | 36.66 | 36.41 | 36.49 | 11392800.0 |
| 2005-04-11 10:30:00 | QQQ | ETF | 36.48 | 36.56 | 36.47 | 36.51 | 5869000.0 |
| 2005-04-11 11:00:00 | QQQ | ETF | 36.51 | 36.56 | 36.47 | 36.49 | 3805500.0 |
| 2005-04-11 11:30:00 | QQQ | ETF | 36.5 | 36.53 | 36.46 | 36.49 | 3818700.0 |
| 2005-04-11 12:00:00 | QQQ | ETF | 36.5 | 36.59 | 36.49 | 36.58 | 4194600.0 |
| 2005-04-11 12:30:00 | QQQ | ETF | 36.58 | 36.64 | 36.57 | 36.6 | 3849100.0 |
| 2005-04-11 13:00:00 | QQQ | ETF | 36.6 | 36.64 | 36.51 | 36.55 | 4138400.0 |
| 2005-04-11 13:30:00 | QQQ | ETF | 36.55 | 36.58 | 36.47 | 36.48 | 2859000.0 |
| 2005-04-11 14:00:00 | QQQ | ETF | 36.48 | 36.52 | 36.46 | 36.48 | 2523200.0 |
| 2005-04-11 14:30:00 | QQQ | ETF | 36.49 | 36.56 | 36.47 | 36.5 | 2390200.0 |
| 2005-04-11 15:00:00 | QQQ | ETF | 36.5 | 36.52 | 36.46 | 36.46 | 4250500.0 |
| 2005-04-11 15:30:00 | QQQ | ETF | 36.46 | 36.48 | 36.4 | 36.48 | 8133400.0 |
| 2005-04-11 08:30:00 | IWM | ETF | 60.685 | 60.685 | 60.685 | 60.685 | 1800.0 |
| 2005-04-11 09:00:00 | IWM | ETF | 60.73 | 60.73 | 60.7 | 60.7 | 2400.0 |
| 2005-04-11 09:30:00 | IWM | ETF | 60.675 | 60.74 | 60.43 | 60.445 | 2380600.0 |
| 2005-04-11 10:00:00 | IWM | ETF | 60.44 | 60.45 | 60.23 | 60.33 | 3040600.0 |
| 2005-04-11 10:30:00 | IWM | ETF | 60.33 | 60.445 | 60.195 | 60.27 | 2256600.0 |
| 2005-04-11 11:00:00 | IWM | ETF | 60.27 | 60.39 | 60.25 | 60.36 | 1025600.0 |
| 2005-04-11 11:30:00 | IWM | ETF | 60.345 | 60.365 | 60.275 | 60.33 | 357400.0 |
| 2005-04-11 12:00:00 | IWM | ETF | 60.335 | 60.525 | 60.335 | 60.52 | 1331200.0 |
| 2005-04-11 12:30:00 | IWM | ETF | 60.515 | 60.58 | 60.48 | 60.485 | 526000.0 |
| 2005-04-11 13:00:00 | IWM | ETF | 60.49 | 60.57 | 60.43 | 60.485 | 461800.0 |
| 2005-04-11 13:30:00 | IWM | ETF | 60.475 | 60.57 | 60.4 | 60.415 | 379000.0 |
| 2005-04-11 14:00:00 | IWM | ETF | 60.415 | 60.49 | 60.385 | 60.43 | 701400.0 |
| 2005-04-11 14:30:00 | IWM | ETF | 60.435 | 60.665 | 60.435 | 60.58 | 924800.0 |
| 2005-04-11 15:00:00 | IWM | ETF | 60.585 | 60.585 | 60.405 | 60.44 | 1124800.0 |
| 2005-04-11 15:30:00 | IWM | ETF | 60.44 | 60.45 | 60.25 | 60.335 | 3500800.0 |
> showing 50 of 1,434 rows — these rows as CSV