PREVIEW / etf_30min / 2007-04-10
file: by_date/etf_30min/2007/2007-04-10.parquet size: 103 KB rows: 3,699
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-04-10 06:00:00 | SPY | ETF | 144.48 | 144.48 | 144.48 | 144.48 | 6000.0 |
| 2007-04-10 07:00:00 | SPY | ETF | 144.52 | 144.52 | 144.4 | 144.4 | 22500.0 |
| 2007-04-10 07:30:00 | SPY | ETF | 144.37 | 144.43 | 144.37 | 144.43 | 18700.0 |
| 2007-04-10 08:00:00 | SPY | ETF | 144.36 | 144.47 | 144.19 | 144.45 | 55800.0 |
| 2007-04-10 08:30:00 | SPY | ETF | 144.45 | 144.46 | 144.29 | 144.3 | 328500.0 |
| 2007-04-10 09:00:00 | SPY | ETF | 144.3 | 144.36 | 144.25 | 144.32 | 402927.0 |
| 2007-04-10 09:30:00 | SPY | ETF | 144.33 | 144.72 | 144.27 | 144.71 | 8132881.0 |
| 2007-04-10 10:00:00 | SPY | ETF | 144.72 | 144.85 | 144.56 | 144.74 | 7901406.0 |
| 2007-04-10 10:30:00 | SPY | ETF | 144.74 | 144.79 | 144.65 | 144.65 | 3647311.0 |
| 2007-04-10 11:00:00 | SPY | ETF | 144.65 | 144.719 | 144.5 | 144.57 | 5274736.0 |
| 2007-04-10 11:30:00 | SPY | ETF | 144.58 | 144.63 | 144.39 | 144.42 | 5048216.0 |
| 2007-04-10 12:00:00 | SPY | ETF | 144.42 | 144.52 | 144.38 | 144.49 | 3754998.0 |
| 2007-04-10 12:30:00 | SPY | ETF | 144.49 | 144.57 | 144.43 | 144.43 | 1178628.0 |
| 2007-04-10 13:00:00 | SPY | ETF | 144.44 | 144.64 | 144.43 | 144.61 | 1961025.0 |
| 2007-04-10 13:30:00 | SPY | ETF | 144.62 | 144.72 | 144.53 | 144.62 | 3236319.0 |
| 2007-04-10 14:00:00 | SPY | ETF | 144.63 | 144.75 | 144.62 | 144.64 | 2837006.0 |
| 2007-04-10 14:30:00 | SPY | ETF | 144.64 | 144.75 | 144.59 | 144.71 | 2347952.0 |
| 2007-04-10 15:00:00 | SPY | ETF | 144.72 | 144.79 | 144.66 | 144.725 | 3004619.0 |
| 2007-04-10 15:30:00 | SPY | ETF | 144.73 | 144.83 | 144.73 | 144.8 | 4420042.0 |
| 2007-04-10 16:00:00 | SPY | ETF | 144.8 | 144.82 | 144.61 | 144.63 | 1882200.0 |
| 2007-04-10 16:30:00 | SPY | ETF | 144.63 | 144.67 | 144.6 | 144.6 | 274800.0 |
| 2007-04-10 17:00:00 | SPY | ETF | 144.61 | 144.61 | 144.61 | 144.61 | 4200.0 |
| 2007-04-10 17:30:00 | SPY | ETF | 144.59 | 144.64 | 144.59 | 144.63 | 22000.0 |
| 2007-04-10 18:00:00 | SPY | ETF | 144.62 | 144.63 | 144.61 | 144.63 | 2100.0 |
| 2007-04-10 18:30:00 | SPY | ETF | 144.62 | 144.62 | 144.61 | 144.61 | 1200.0 |
| 2007-04-10 19:00:00 | SPY | ETF | 144.61 | 144.62 | 144.61 | 144.61 | 4600.0 |
| 2007-04-10 19:30:00 | SPY | ETF | 144.61 | 144.61 | 144.6 | 144.61 | 4200.0 |
| 2007-04-10 07:00:00 | QQQ | ETF | 44.52 | 44.53 | 44.48 | 44.49 | 266200.0 |
| 2007-04-10 07:30:00 | QQQ | ETF | 44.47 | 44.5 | 44.43 | 44.49 | 300714.0 |
| 2007-04-10 08:00:00 | QQQ | ETF | 44.49 | 44.5 | 44.45 | 44.5 | 743846.0 |
| 2007-04-10 08:30:00 | QQQ | ETF | 44.49 | 44.49 | 44.43 | 44.45 | 1457710.0 |
| 2007-04-10 09:00:00 | QQQ | ETF | 44.44 | 44.46 | 44.44 | 44.44 | 843402.0 |
| 2007-04-10 09:30:00 | QQQ | ETF | 44.44 | 44.62 | 44.41 | 44.59 | 12080800.0 |
| 2007-04-10 10:00:00 | QQQ | ETF | 44.59 | 44.67 | 44.53 | 44.61 | 4657100.0 |
| 2007-04-10 10:30:00 | QQQ | ETF | 44.6 | 44.63 | 44.53 | 44.54 | 4606400.0 |
| 2007-04-10 11:00:00 | QQQ | ETF | 44.54 | 44.54 | 44.49 | 44.5 | 6555200.0 |
| 2007-04-10 11:30:00 | QQQ | ETF | 44.51 | 44.54 | 44.47 | 44.49 | 2777900.0 |
| 2007-04-10 12:00:00 | QQQ | ETF | 44.49 | 44.54 | 44.47 | 44.53 | 3158600.0 |
| 2007-04-10 12:30:00 | QQQ | ETF | 44.52 | 44.56 | 44.45 | 44.46 | 3083600.0 |
| 2007-04-10 13:00:00 | QQQ | ETF | 44.45 | 44.53 | 44.45 | 44.52 | 3229700.0 |
| 2007-04-10 13:30:00 | QQQ | ETF | 44.53 | 44.57 | 44.5 | 44.52 | 2982800.0 |
| 2007-04-10 14:00:00 | QQQ | ETF | 44.52 | 44.57 | 44.51 | 44.52 | 1349400.0 |
| 2007-04-10 14:30:00 | QQQ | ETF | 44.52 | 44.56 | 44.51 | 44.55 | 2451200.0 |
| 2007-04-10 15:00:00 | QQQ | ETF | 44.55 | 44.61 | 44.55 | 44.61 | 4445500.0 |
| 2007-04-10 15:30:00 | QQQ | ETF | 44.6 | 44.68 | 44.6 | 44.67 | 5684900.0 |
| 2007-04-10 16:00:00 | QQQ | ETF | 44.67 | 44.68 | 44.59 | 44.64 | 2175739.0 |
| 2007-04-10 16:30:00 | QQQ | ETF | 44.64 | 44.66 | 44.61 | 44.64 | 12853267.0 |
| 2007-04-10 17:00:00 | QQQ | ETF | 44.65 | 44.65 | 44.62 | 44.64 | 27540.0 |
| 2007-04-10 17:30:00 | QQQ | ETF | 44.65 | 44.67 | 44.65 | 44.67 | 71160.0 |
| 2007-04-10 18:00:00 | QQQ | ETF | 44.65 | 44.65 | 44.63 | 44.63 | 36731.0 |
> showing 50 of 3,699 rows — these rows as CSV