PREVIEW / etf_30min / 2006-04-04
file: by_date/etf_30min/2006/2006-04-04.parquet size: 60 KB rows: 2,163
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 |
|---|---|---|---|---|---|---|---|
| 2006-04-04 07:30:00 | SPY | ETF | 129.77 | 129.85 | 129.77 | 129.83 | 16200.0 |
| 2006-04-04 08:00:00 | SPY | ETF | 129.87 | 129.88 | 129.73 | 129.73 | 101200.0 |
| 2006-04-04 08:30:00 | SPY | ETF | 129.83 | 129.9 | 129.68 | 129.71 | 147200.0 |
| 2006-04-04 09:00:00 | SPY | ETF | 129.72 | 129.83 | 129.72 | 129.73 | 429200.0 |
| 2006-04-04 09:30:00 | SPY | ETF | 129.72 | 129.76 | 129.36 | 129.69 | 7730000.0 |
| 2006-04-04 10:00:00 | SPY | ETF | 129.69 | 130.05 | 129.66 | 129.86 | 5906200.0 |
| 2006-04-04 10:30:00 | SPY | ETF | 129.87 | 129.98 | 129.7182 | 129.73 | 3059400.0 |
| 2006-04-04 11:00:00 | SPY | ETF | 129.72 | 129.88 | 129.58 | 129.82 | 3150400.0 |
| 2006-04-04 11:30:00 | SPY | ETF | 129.81 | 130.17 | 129.8 | 130.07 | 4348000.0 |
| 2006-04-04 12:00:00 | SPY | ETF | 130.08 | 130.46 | 130.07 | 130.38 | 4262600.0 |
| 2006-04-04 12:30:00 | SPY | ETF | 130.38 | 130.44 | 130.26 | 130.38 | 2455100.0 |
| 2006-04-04 13:00:00 | SPY | ETF | 130.38 | 130.4201 | 130.14 | 130.19 | 2517600.0 |
| 2006-04-04 13:30:00 | SPY | ETF | 130.19 | 130.46 | 130.14 | 130.42 | 3897200.0 |
| 2006-04-04 14:00:00 | SPY | ETF | 130.41 | 130.67 | 130.24 | 130.58 | 4405800.0 |
| 2006-04-04 14:30:00 | SPY | ETF | 130.58 | 130.71 | 130.33 | 130.47 | 4449600.0 |
| 2006-04-04 15:00:00 | SPY | ETF | 130.47 | 130.6 | 130.39 | 130.51 | 2163200.0 |
| 2006-04-04 15:30:00 | SPY | ETF | 130.51 | 130.73 | 130.42 | 130.53 | 4089900.0 |
| 2006-04-04 16:00:00 | SPY | ETF | 130.52 | 130.6 | 130.52 | 130.58 | 495300.0 |
| 2006-04-04 16:30:00 | SPY | ETF | 130.55 | 130.61 | 130.54 | 130.54 | 155200.0 |
| 2006-04-04 17:00:00 | SPY | ETF | 130.58 | 130.58 | 130.49 | 130.49 | 267400.0 |
| 2006-04-04 17:30:00 | SPY | ETF | 130.55 | 130.55 | 130.52 | 130.52 | 700.0 |
| 2006-04-04 18:00:00 | SPY | ETF | 130.53 | 130.55 | 130.53 | 130.54 | 700.0 |
| 2006-04-04 18:30:00 | SPY | ETF | 130.57 | 130.57 | 130.57 | 130.57 | 400.0 |
| 2006-04-04 19:00:00 | SPY | ETF | 130.61 | 130.61 | 130.61 | 130.61 | 1000.0 |
| 2006-04-04 19:30:00 | SPY | ETF | 130.61 | 130.61 | 130.57 | 130.57 | 200.0 |
| 2006-04-04 09:30:00 | QQQ | ETF | 42.03 | 42.11 | 41.93 | 42.08 | 15044100.0 |
| 2006-04-04 10:00:00 | QQQ | ETF | 42.08 | 42.22 | 42.07 | 42.12 | 8358000.0 |
| 2006-04-04 10:30:00 | QQQ | ETF | 42.12 | 42.19 | 42.06 | 42.06 | 8191700.0 |
| 2006-04-04 11:00:00 | QQQ | ETF | 42.07 | 42.14 | 42.0 | 42.1 | 5520700.0 |
| 2006-04-04 11:30:00 | QQQ | ETF | 42.1 | 42.2 | 42.08 | 42.13 | 5815400.0 |
| 2006-04-04 12:00:00 | QQQ | ETF | 42.14 | 42.31 | 42.13 | 42.25 | 7059700.0 |
| 2006-04-04 12:30:00 | QQQ | ETF | 42.25 | 42.27 | 42.2 | 42.24 | 3889800.0 |
| 2006-04-04 13:00:00 | QQQ | ETF | 42.23 | 42.26 | 42.12 | 42.15 | 4359200.0 |
| 2006-04-04 13:30:00 | QQQ | ETF | 42.14 | 42.24 | 42.11 | 42.2 | 4422700.0 |
| 2006-04-04 14:00:00 | QQQ | ETF | 42.2 | 42.3 | 42.15 | 42.25 | 5775300.0 |
| 2006-04-04 14:30:00 | QQQ | ETF | 42.24 | 42.27 | 42.13 | 42.21 | 4918500.0 |
| 2006-04-04 15:00:00 | QQQ | ETF | 42.21 | 42.24 | 42.15 | 42.2 | 3106100.0 |
| 2006-04-04 15:30:00 | QQQ | ETF | 42.19 | 42.25 | 42.15 | 42.2 | 7321700.0 |
| 2006-04-04 08:00:00 | IWM | ETF | 75.38 | 75.39 | 75.38 | 75.39 | 2900.0 |
| 2006-04-04 08:30:00 | IWM | ETF | 75.38 | 75.38 | 75.27 | 75.28 | 6100.0 |
| 2006-04-04 09:00:00 | IWM | ETF | 75.28 | 75.83 | 75.26 | 75.26 | 252100.0 |
| 2006-04-04 09:30:00 | IWM | ETF | 75.28 | 75.44 | 75.07 | 75.39 | 5122100.0 |
| 2006-04-04 10:00:00 | IWM | ETF | 75.39 | 75.55 | 75.25 | 75.37 | 2942100.0 |
| 2006-04-04 10:30:00 | IWM | ETF | 75.38 | 75.46 | 75.27 | 75.29 | 1015700.0 |
| 2006-04-04 11:00:00 | IWM | ETF | 75.28 | 75.38 | 75.15 | 75.38 | 1636100.0 |
| 2006-04-04 11:30:00 | IWM | ETF | 75.37 | 75.71 | 75.34 | 75.62 | 1680700.0 |
| 2006-04-04 12:00:00 | IWM | ETF | 75.62 | 75.99 | 75.62 | 75.85 | 2116400.0 |
| 2006-04-04 12:30:00 | IWM | ETF | 75.85 | 75.91 | 75.74 | 75.87 | 1244600.0 |
| 2006-04-04 13:00:00 | IWM | ETF | 75.87 | 75.94 | 75.62 | 75.65 | 881200.0 |
| 2006-04-04 13:30:00 | IWM | ETF | 75.65 | 75.79 | 75.57 | 75.74 | 2274800.0 |
> showing 50 of 2,163 rows — these rows as CSV