PREVIEW / etf_30min / 2005-02-08
file: by_date/etf_30min/2005/2005-02-08.parquet size: 40 KB rows: 1,422
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-08 08:00:00 | SPY | ETF | 120.27 | 120.27 | 120.19 | 120.19 | 10200.0 |
| 2005-02-08 08:30:00 | SPY | ETF | 120.19 | 120.25 | 120.14 | 120.15 | 16000.0 |
| 2005-02-08 09:00:00 | SPY | ETF | 120.18 | 120.2 | 120.16 | 120.16 | 3600.0 |
| 2005-02-08 09:30:00 | SPY | ETF | 120.17 | 120.4 | 120.07 | 120.4 | 4323300.0 |
| 2005-02-08 10:00:00 | SPY | ETF | 120.4 | 120.5 | 120.33 | 120.4 | 3778900.0 |
| 2005-02-08 10:30:00 | SPY | ETF | 120.4 | 120.65 | 120.38 | 120.5 | 2713500.0 |
| 2005-02-08 11:00:00 | SPY | ETF | 120.48 | 120.58 | 120.42 | 120.55 | 1853800.0 |
| 2005-02-08 11:30:00 | SPY | ETF | 120.56 | 120.58 | 120.32 | 120.39 | 2125600.0 |
| 2005-02-08 12:00:00 | SPY | ETF | 120.39 | 120.4 | 120.08 | 120.16 | 3289800.0 |
| 2005-02-08 12:30:00 | SPY | ETF | 120.16 | 120.41 | 120.1 | 120.2 | 2415300.0 |
| 2005-02-08 13:00:00 | SPY | ETF | 120.2 | 120.44 | 120.11 | 120.29 | 2372000.0 |
| 2005-02-08 13:30:00 | SPY | ETF | 120.28 | 120.42 | 120.22 | 120.31 | 3173100.0 |
| 2005-02-08 14:00:00 | SPY | ETF | 120.31 | 120.47 | 120.27 | 120.36 | 5186300.0 |
| 2005-02-08 14:30:00 | SPY | ETF | 120.35 | 120.43 | 120.27 | 120.43 | 1376800.0 |
| 2005-02-08 15:00:00 | SPY | ETF | 120.43 | 120.5 | 120.31 | 120.35 | 1689600.0 |
| 2005-02-08 15:30:00 | SPY | ETF | 120.35 | 120.46 | 120.33 | 120.34 | 2384000.0 |
| 2005-02-08 16:00:00 | SPY | ETF | 120.35 | 120.3858 | 120.15 | 120.18 | 769700.0 |
| 2005-02-08 16:30:00 | SPY | ETF | 120.18 | 120.28 | 120.18 | 120.28 | 428100.0 |
| 2005-02-08 17:00:00 | SPY | ETF | 120.22 | 120.23 | 120.15 | 120.2 | 61000.0 |
| 2005-02-08 17:30:00 | SPY | ETF | 120.23 | 120.24 | 120.21 | 120.22 | 6400.0 |
| 2005-02-08 18:00:00 | SPY | ETF | 120.26 | 120.29 | 120.25 | 120.29 | 1100.0 |
| 2005-02-08 18:30:00 | SPY | ETF | 120.27 | 120.27 | 120.27 | 120.27 | 1000.0 |
| 2005-02-08 19:00:00 | SPY | ETF | 120.27 | 120.27 | 120.23 | 120.23 | 3600.0 |
| 2005-02-08 09:30:00 | QQQ | ETF | 37.65 | 37.84 | 37.63 | 37.84 | 7544500.0 |
| 2005-02-08 10:00:00 | QQQ | ETF | 37.84 | 37.93 | 37.83 | 37.88 | 7370600.0 |
| 2005-02-08 10:30:00 | QQQ | ETF | 37.88 | 38.01 | 37.35 | 37.89 | 7202500.0 |
| 2005-02-08 11:00:00 | QQQ | ETF | 37.9 | 37.95 | 37.85 | 37.94 | 2932500.0 |
| 2005-02-08 11:30:00 | QQQ | ETF | 37.93 | 37.94 | 37.81 | 37.83 | 2923600.0 |
| 2005-02-08 12:00:00 | QQQ | ETF | 37.83 | 37.83 | 37.62 | 37.67 | 8908800.0 |
| 2005-02-08 12:30:00 | QQQ | ETF | 37.67 | 37.74 | 37.65 | 37.71 | 3082000.0 |
| 2005-02-08 13:00:00 | QQQ | ETF | 37.71 | 37.78 | 37.66 | 37.77 | 2844400.0 |
| 2005-02-08 13:30:00 | QQQ | ETF | 37.77 | 37.81 | 37.69 | 37.73 | 4458300.0 |
| 2005-02-08 14:00:00 | QQQ | ETF | 37.73 | 37.81 | 37.72 | 37.75 | 5946300.0 |
| 2005-02-08 14:30:00 | QQQ | ETF | 37.75 | 37.81 | 37.72 | 37.78 | 4742100.0 |
| 2005-02-08 15:00:00 | QQQ | ETF | 37.78 | 37.79 | 37.72 | 37.74 | 2711900.0 |
| 2005-02-08 15:30:00 | QQQ | ETF | 37.74 | 37.8 | 37.71 | 37.74 | 5092100.0 |
| 2005-02-08 09:30:00 | IWM | ETF | 63.355 | 63.61 | 63.345 | 63.6 | 704200.0 |
| 2005-02-08 10:00:00 | IWM | ETF | 63.625 | 63.69 | 63.56 | 63.56 | 2082600.0 |
| 2005-02-08 10:30:00 | IWM | ETF | 63.56 | 63.73 | 63.56 | 63.575 | 891200.0 |
| 2005-02-08 11:00:00 | IWM | ETF | 63.6 | 63.625 | 63.49 | 63.585 | 494600.0 |
| 2005-02-08 11:30:00 | IWM | ETF | 63.595 | 63.6 | 63.465 | 63.48 | 380800.0 |
| 2005-02-08 12:00:00 | IWM | ETF | 63.465 | 63.485 | 63.3 | 63.34 | 944600.0 |
| 2005-02-08 12:30:00 | IWM | ETF | 63.35 | 63.44 | 63.31 | 63.375 | 556000.0 |
| 2005-02-08 13:00:00 | IWM | ETF | 63.38 | 63.52 | 63.345 | 63.52 | 851600.0 |
| 2005-02-08 13:30:00 | IWM | ETF | 63.52 | 63.53 | 63.4565 | 63.52 | 856400.0 |
| 2005-02-08 14:00:00 | IWM | ETF | 63.52 | 63.565 | 63.475 | 63.51 | 378400.0 |
| 2005-02-08 14:30:00 | IWM | ETF | 63.505 | 63.57 | 63.4455 | 63.57 | 277000.0 |
| 2005-02-08 15:00:00 | IWM | ETF | 63.575 | 63.625 | 63.505 | 63.535 | 491000.0 |
| 2005-02-08 15:30:00 | IWM | ETF | 63.525 | 63.65 | 63.505 | 63.555 | 891200.0 |
| 2005-02-08 16:00:00 | IWM | ETF | 63.53 | 63.57 | 63.39 | 63.47 | 807600.0 |
> showing 50 of 1,422 rows — these rows as CSV