PREVIEW / etf_30min / 2010-12-14
file: by_date/etf_30min/2010/2010-12-14.parquet size: 272 KB rows: 9,073
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-14 04:00:00 | SPY | ETF | 124.68 | 124.68 | 124.59 | 124.59 | 200.0 |
| 2010-12-14 04:30:00 | SPY | ETF | 124.65 | 124.67 | 124.65 | 124.67 | 1000.0 |
| 2010-12-14 05:00:00 | SPY | ETF | 124.74 | 124.8 | 124.74 | 124.79 | 15600.0 |
| 2010-12-14 05:30:00 | SPY | ETF | 124.87 | 124.92 | 124.83 | 124.92 | 16600.0 |
| 2010-12-14 06:00:00 | SPY | ETF | 124.84 | 124.85 | 124.82 | 124.82 | 40100.0 |
| 2010-12-14 06:30:00 | SPY | ETF | 124.81 | 124.87 | 124.75 | 124.79 | 28600.0 |
| 2010-12-14 07:00:00 | SPY | ETF | 124.79 | 124.85 | 124.76 | 124.82 | 127300.0 |
| 2010-12-14 07:30:00 | SPY | ETF | 124.83 | 124.96 | 124.82 | 124.91 | 270110.0 |
| 2010-12-14 08:00:00 | SPY | ETF | 124.79 | 124.93 | 124.52 | 124.74 | 1405719.0 |
| 2010-12-14 08:30:00 | SPY | ETF | 124.73 | 124.86 | 124.62 | 124.79 | 1318530.0 |
| 2010-12-14 09:00:00 | SPY | ETF | 124.78 | 124.84 | 124.7 | 124.75 | 1155400.0 |
| 2010-12-14 09:30:00 | SPY | ETF | 124.75 | 124.899 | 124.62 | 124.78 | 15149310.0 |
| 2010-12-14 10:00:00 | SPY | ETF | 124.78 | 125.07 | 124.775 | 124.9899 | 13637212.0 |
| 2010-12-14 10:30:00 | SPY | ETF | 124.9882 | 125.05 | 124.86 | 124.86 | 7479721.0 |
| 2010-12-14 11:00:00 | SPY | ETF | 124.87 | 124.98 | 124.84 | 124.97 | 5324380.0 |
| 2010-12-14 11:30:00 | SPY | ETF | 124.96 | 125.08 | 124.95 | 125.01 | 4538616.0 |
| 2010-12-14 12:00:00 | SPY | ETF | 125.01 | 125.1 | 124.99 | 125.0301 | 3486311.0 |
| 2010-12-14 12:30:00 | SPY | ETF | 125.04 | 125.11 | 124.99 | 125.05 | 10437964.0 |
| 2010-12-14 13:00:00 | SPY | ETF | 125.06 | 125.12 | 125.04 | 125.1 | 6880223.0 |
| 2010-12-14 13:30:00 | SPY | ETF | 125.11 | 125.15 | 125.06 | 125.08 | 4862960.0 |
| 2010-12-14 14:00:00 | SPY | ETF | 125.07 | 125.23 | 124.89 | 124.98 | 11962263.0 |
| 2010-12-14 14:30:00 | SPY | ETF | 124.99 | 125.11 | 124.72 | 124.94 | 12498688.0 |
| 2010-12-14 15:00:00 | SPY | ETF | 124.94 | 124.98 | 124.49 | 124.565 | 13096501.0 |
| 2010-12-14 15:30:00 | SPY | ETF | 124.56 | 124.68 | 124.29 | 124.65 | 21457785.0 |
| 2010-12-14 16:00:00 | SPY | ETF | 124.65 | 124.995 | 124.325 | 124.64 | 5614002.0 |
| 2010-12-14 16:30:00 | SPY | ETF | 124.65 | 124.8456 | 124.5531 | 124.64 | 2729662.0 |
| 2010-12-14 17:00:00 | SPY | ETF | 124.64 | 124.71 | 124.64 | 124.69 | 74998.0 |
| 2010-12-14 17:30:00 | SPY | ETF | 124.72 | 124.73 | 124.68 | 124.7 | 12000.0 |
| 2010-12-14 18:00:00 | SPY | ETF | 124.7 | 124.7 | 124.55 | 124.56 | 41090.0 |
| 2010-12-14 18:30:00 | SPY | ETF | 124.56 | 124.64 | 124.5 | 124.57 | 83702.0 |
| 2010-12-14 19:00:00 | SPY | ETF | 124.57 | 124.59 | 124.51 | 124.53 | 18165.0 |
| 2010-12-14 19:30:00 | SPY | ETF | 124.54 | 124.61 | 124.45 | 124.51 | 102373.0 |
| 2010-12-14 04:30:00 | QQQ | ETF | 54.44 | 54.44 | 54.41 | 54.41 | 40000.0 |
| 2010-12-14 05:00:00 | QQQ | ETF | 54.43 | 54.43 | 54.43 | 54.43 | 4622.0 |
| 2010-12-14 06:30:00 | QQQ | ETF | 54.49 | 54.49 | 54.45 | 54.45 | 1300.0 |
| 2010-12-14 07:00:00 | QQQ | ETF | 54.47 | 54.47 | 54.45 | 54.47 | 114180.0 |
| 2010-12-14 07:30:00 | QQQ | ETF | 54.47 | 54.53 | 54.47 | 54.49 | 21336.0 |
| 2010-12-14 08:00:00 | QQQ | ETF | 54.48 | 54.48 | 54.3 | 54.37 | 876819.0 |
| 2010-12-14 08:30:00 | QQQ | ETF | 54.37 | 54.46 | 54.37 | 54.42 | 348329.0 |
| 2010-12-14 09:00:00 | QQQ | ETF | 54.43 | 54.44 | 54.39 | 54.42 | 465404.0 |
| 2010-12-14 09:30:00 | QQQ | ETF | 54.42 | 54.52 | 54.3 | 54.45 | 8043798.0 |
| 2010-12-14 10:00:00 | QQQ | ETF | 54.45 | 54.6 | 54.44 | 54.555 | 4078012.0 |
| 2010-12-14 10:30:00 | QQQ | ETF | 54.5525 | 54.57 | 54.47 | 54.48 | 4468514.0 |
| 2010-12-14 11:00:00 | QQQ | ETF | 54.48 | 54.53 | 54.46 | 54.52 | 1459534.0 |
| 2010-12-14 11:30:00 | QQQ | ETF | 54.52 | 54.57 | 54.511 | 54.5395 | 1198225.0 |
| 2010-12-14 12:00:00 | QQQ | ETF | 54.54 | 54.56 | 54.52 | 54.54 | 707024.0 |
| 2010-12-14 12:30:00 | QQQ | ETF | 54.54 | 54.54 | 54.5 | 54.51 | 1002520.0 |
| 2010-12-14 13:00:00 | QQQ | ETF | 54.5 | 54.56 | 54.5 | 54.555 | 668041.0 |
| 2010-12-14 13:30:00 | QQQ | ETF | 54.5588 | 54.61 | 54.54 | 54.565 | 1375609.0 |
| 2010-12-14 14:00:00 | QQQ | ETF | 54.56 | 54.62 | 54.47 | 54.515 | 3530512.0 |
> showing 50 of 9,073 rows — these rows as CSV