PREVIEW / etf_30min / 2007-02-08
file: by_date/etf_30min/2007/2007-02-08.parquet size: 98 KB rows: 3,430
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 |
|---|---|---|---|---|---|---|---|
| 2007-02-08 05:30:00 | SPY | ETF | 145.01 | 145.01 | 145.01 | 145.01 | 10000.0 |
| 2007-02-08 06:00:00 | SPY | ETF | 145.05 | 145.05 | 145.05 | 145.05 | 4900.0 |
| 2007-02-08 07:00:00 | SPY | ETF | 145.04 | 145.04 | 144.91 | 144.91 | 144300.0 |
| 2007-02-08 07:30:00 | SPY | ETF | 144.92 | 144.92 | 144.76 | 144.79 | 77800.0 |
| 2007-02-08 08:00:00 | SPY | ETF | 144.77 | 145.0 | 144.77 | 144.86 | 872800.0 |
| 2007-02-08 08:30:00 | SPY | ETF | 144.89 | 144.93 | 144.8 | 144.8 | 248600.0 |
| 2007-02-08 09:00:00 | SPY | ETF | 144.8 | 144.82 | 144.71 | 144.79 | 666400.0 |
| 2007-02-08 09:30:00 | SPY | ETF | 144.78 | 144.84 | 144.27 | 144.56 | 10188600.0 |
| 2007-02-08 10:00:00 | SPY | ETF | 144.55 | 144.73 | 144.44 | 144.56 | 4832500.0 |
| 2007-02-08 10:30:00 | SPY | ETF | 144.57 | 144.73 | 144.34 | 144.48 | 7290300.0 |
| 2007-02-08 11:00:00 | SPY | ETF | 144.47 | 144.57 | 144.32 | 144.52 | 5081100.0 |
| 2007-02-08 11:30:00 | SPY | ETF | 144.51 | 144.55 | 144.4 | 144.48 | 2172900.0 |
| 2007-02-08 12:00:00 | SPY | ETF | 144.49 | 144.68 | 144.4 | 144.58 | 3891000.0 |
| 2007-02-08 12:30:00 | SPY | ETF | 144.58 | 144.81 | 144.57 | 144.67 | 2825900.0 |
| 2007-02-08 13:00:00 | SPY | ETF | 144.67 | 144.91 | 144.66 | 144.69 | 4076500.0 |
| 2007-02-08 13:30:00 | SPY | ETF | 144.7 | 144.84 | 144.68 | 144.77 | 3732000.0 |
| 2007-02-08 14:00:00 | SPY | ETF | 144.76 | 144.84 | 144.62 | 144.8 | 7756700.0 |
| 2007-02-08 14:30:00 | SPY | ETF | 144.8 | 145.12 | 144.7 | 145.0 | 4553400.0 |
| 2007-02-08 15:00:00 | SPY | ETF | 145.0 | 145.01 | 144.87 | 144.8799 | 5610300.0 |
| 2007-02-08 15:30:00 | SPY | ETF | 144.87 | 144.95 | 144.73 | 144.88 | 3853300.0 |
| 2007-02-08 16:00:00 | SPY | ETF | 144.88 | 145.04 | 144.87 | 145.02 | 630000.0 |
| 2007-02-08 16:30:00 | SPY | ETF | 145.01 | 145.01 | 144.95 | 144.99 | 587600.0 |
| 2007-02-08 17:00:00 | SPY | ETF | 144.99 | 145.0 | 144.94 | 145.0 | 58600.0 |
| 2007-02-08 17:30:00 | SPY | ETF | 144.98 | 144.98 | 144.98 | 144.98 | 900.0 |
| 2007-02-08 18:00:00 | SPY | ETF | 144.98 | 144.98 | 144.95 | 144.95 | 4800.0 |
| 2007-02-08 18:30:00 | SPY | ETF | 144.97 | 144.97 | 144.97 | 144.97 | 2000.0 |
| 2007-02-08 06:00:00 | QQQ | ETF | 44.46 | 44.46 | 44.46 | 44.46 | 3289.0 |
| 2007-02-08 07:00:00 | QQQ | ETF | 44.47 | 44.47 | 44.39 | 44.39 | 364200.0 |
| 2007-02-08 07:30:00 | QQQ | ETF | 44.39 | 44.43 | 44.36 | 44.42 | 407848.0 |
| 2007-02-08 08:00:00 | QQQ | ETF | 44.4 | 44.44 | 44.4 | 44.41 | 693816.0 |
| 2007-02-08 08:30:00 | QQQ | ETF | 44.4 | 44.46 | 44.4 | 44.4 | 685133.0 |
| 2007-02-08 09:00:00 | QQQ | ETF | 44.41 | 44.41 | 44.37 | 44.4 | 823083.0 |
| 2007-02-08 09:30:00 | QQQ | ETF | 44.39 | 44.49 | 44.23 | 44.31 | 17138200.0 |
| 2007-02-08 10:00:00 | QQQ | ETF | 44.32 | 44.45 | 44.28 | 44.38 | 8796300.0 |
| 2007-02-08 10:30:00 | QQQ | ETF | 44.38 | 44.44 | 44.29 | 44.38 | 5982500.0 |
| 2007-02-08 11:00:00 | QQQ | ETF | 44.38 | 44.44 | 44.29 | 44.41 | 4136700.0 |
| 2007-02-08 11:30:00 | QQQ | ETF | 44.42 | 44.42 | 44.33 | 44.37 | 3364400.0 |
| 2007-02-08 12:00:00 | QQQ | ETF | 44.37 | 44.46 | 44.32 | 44.4 | 2272200.0 |
| 2007-02-08 12:30:00 | QQQ | ETF | 44.4 | 44.53 | 44.4 | 44.48 | 5287500.0 |
| 2007-02-08 13:00:00 | QQQ | ETF | 44.48 | 44.57 | 44.43 | 44.47 | 6197200.0 |
| 2007-02-08 13:30:00 | QQQ | ETF | 44.47 | 44.56 | 44.46 | 44.5 | 2187300.0 |
| 2007-02-08 14:00:00 | QQQ | ETF | 44.5 | 44.53 | 44.41 | 44.48 | 6054200.0 |
| 2007-02-08 14:30:00 | QQQ | ETF | 44.49 | 44.6 | 44.43 | 44.58 | 13102600.0 |
| 2007-02-08 15:00:00 | QQQ | ETF | 44.59 | 44.59 | 44.49 | 44.5 | 4689700.0 |
| 2007-02-08 15:30:00 | QQQ | ETF | 44.51 | 44.52 | 44.45 | 44.51 | 5302500.0 |
| 2007-02-08 16:00:00 | QQQ | ETF | 44.51 | 44.57 | 44.47 | 44.53 | 934286.0 |
| 2007-02-08 16:30:00 | QQQ | ETF | 44.53 | 44.56 | 44.51 | 44.53 | 362732.0 |
| 2007-02-08 17:00:00 | QQQ | ETF | 44.54 | 44.56 | 44.53 | 44.54 | 126170.0 |
| 2007-02-08 17:30:00 | QQQ | ETF | 44.55 | 44.55 | 44.52 | 44.52 | 19119.0 |
| 2007-02-08 18:00:00 | QQQ | ETF | 44.53 | 44.54 | 44.52 | 44.53 | 13516.0 |
> showing 50 of 3,430 rows — these rows as CSV