PREVIEW / etf_30min / 2010-11-02
file: by_date/etf_30min/2010/2010-11-02.parquet size: 261 KB rows: 8,746
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-11-02 04:00:00 | SPY | ETF | 118.83 | 119.15 | 118.83 | 119.14 | 1320.0 |
| 2010-11-02 04:30:00 | SPY | ETF | 119.07 | 119.07 | 119.03 | 119.05 | 700.0 |
| 2010-11-02 05:00:00 | SPY | ETF | 119.19 | 119.19 | 119.19 | 119.19 | 100.0 |
| 2010-11-02 05:30:00 | SPY | ETF | 119.18 | 119.2 | 119.18 | 119.18 | 3000.0 |
| 2010-11-02 06:00:00 | SPY | ETF | 119.13 | 119.19 | 119.12 | 119.19 | 10900.0 |
| 2010-11-02 06:30:00 | SPY | ETF | 119.22 | 119.28 | 119.2 | 119.22 | 4700.0 |
| 2010-11-02 07:00:00 | SPY | ETF | 119.21 | 119.3 | 119.19 | 119.29 | 188895.0 |
| 2010-11-02 07:30:00 | SPY | ETF | 119.29 | 119.48 | 119.29 | 119.4 | 418805.0 |
| 2010-11-02 08:00:00 | SPY | ETF | 119.39 | 119.59 | 118.85 | 119.54 | 1033720.0 |
| 2010-11-02 08:30:00 | SPY | ETF | 119.55 | 119.57 | 119.4 | 119.42 | 536072.0 |
| 2010-11-02 09:00:00 | SPY | ETF | 119.45 | 119.57 | 119.39 | 119.43 | 2093247.0 |
| 2010-11-02 09:30:00 | SPY | ETF | 119.42 | 119.64 | 119.31 | 119.43 | 25769904.0 |
| 2010-11-02 10:00:00 | SPY | ETF | 119.42 | 119.49 | 119.2 | 119.2899 | 12708026.0 |
| 2010-11-02 10:30:00 | SPY | ETF | 119.285 | 119.33 | 119.1 | 119.25 | 11831683.0 |
| 2010-11-02 11:00:00 | SPY | ETF | 119.25 | 119.43 | 119.2 | 119.33 | 11005032.0 |
| 2010-11-02 11:30:00 | SPY | ETF | 119.34 | 119.42 | 119.28 | 119.34 | 4399243.0 |
| 2010-11-02 12:00:00 | SPY | ETF | 119.35 | 119.45 | 119.31 | 119.35 | 6754368.0 |
| 2010-11-02 12:30:00 | SPY | ETF | 119.345 | 119.56 | 119.33 | 119.51 | 7682752.0 |
| 2010-11-02 13:00:00 | SPY | ETF | 119.51 | 119.61 | 119.49 | 119.5238 | 6139914.0 |
| 2010-11-02 13:30:00 | SPY | ETF | 119.522 | 119.75 | 119.5 | 119.699 | 7373264.0 |
| 2010-11-02 14:00:00 | SPY | ETF | 119.7 | 119.73 | 119.5 | 119.56 | 6190792.0 |
| 2010-11-02 14:30:00 | SPY | ETF | 119.56 | 119.6 | 119.41 | 119.49 | 7624385.0 |
| 2010-11-02 15:00:00 | SPY | ETF | 119.49 | 119.62 | 119.48 | 119.52 | 6295868.0 |
| 2010-11-02 15:30:00 | SPY | ETF | 119.52 | 119.58 | 119.38 | 119.47 | 21752794.0 |
| 2010-11-02 16:00:00 | SPY | ETF | 119.46 | 119.81 | 119.255 | 119.76 | 9997680.0 |
| 2010-11-02 16:30:00 | SPY | ETF | 119.75 | 119.79 | 119.68 | 119.76 | 2940933.0 |
| 2010-11-02 17:00:00 | SPY | ETF | 119.76 | 119.8 | 119.74 | 119.74 | 1104989.0 |
| 2010-11-02 17:30:00 | SPY | ETF | 119.76 | 119.76 | 119.7 | 119.74 | 28026.0 |
| 2010-11-02 18:00:00 | SPY | ETF | 119.72 | 119.85 | 119.49 | 119.85 | 155203.0 |
| 2010-11-02 18:30:00 | SPY | ETF | 119.81 | 119.82 | 119.76 | 119.82 | 14224.0 |
| 2010-11-02 19:00:00 | SPY | ETF | 119.82 | 120.08 | 119.82 | 120.03 | 172639.0 |
| 2010-11-02 19:30:00 | SPY | ETF | 120.05 | 120.11 | 120.02 | 120.05 | 86874.0 |
| 2010-11-02 04:00:00 | QQQ | ETF | 52.5 | 52.5 | 52.5 | 52.5 | 200.0 |
| 2010-11-02 04:30:00 | QQQ | ETF | 52.43 | 52.43 | 52.43 | 52.43 | 400.0 |
| 2010-11-02 05:00:00 | QQQ | ETF | 52.46 | 52.48 | 52.46 | 52.48 | 300.0 |
| 2010-11-02 06:00:00 | QQQ | ETF | 52.46 | 52.46 | 52.46 | 52.46 | 100.0 |
| 2010-11-02 06:30:00 | QQQ | ETF | 52.46 | 52.47 | 52.46 | 52.47 | 5200.0 |
| 2010-11-02 07:00:00 | QQQ | ETF | 52.47 | 52.51 | 52.47 | 52.51 | 13404.0 |
| 2010-11-02 07:30:00 | QQQ | ETF | 52.57 | 52.58 | 52.55 | 52.57 | 55612.0 |
| 2010-11-02 08:00:00 | QQQ | ETF | 52.56 | 52.66 | 52.56 | 52.66 | 130586.0 |
| 2010-11-02 08:30:00 | QQQ | ETF | 52.66 | 52.66 | 52.57 | 52.58 | 261813.0 |
| 2010-11-02 09:00:00 | QQQ | ETF | 52.58 | 52.67 | 52.57 | 52.66 | 385407.0 |
| 2010-11-02 09:30:00 | QQQ | ETF | 52.66 | 52.85 | 52.65 | 52.73 | 9926673.0 |
| 2010-11-02 10:00:00 | QQQ | ETF | 52.74 | 52.77 | 52.63 | 52.66 | 4692172.0 |
| 2010-11-02 10:30:00 | QQQ | ETF | 52.66 | 52.71 | 52.575 | 52.68 | 3765713.0 |
| 2010-11-02 11:00:00 | QQQ | ETF | 52.6725 | 52.75 | 52.65 | 52.68 | 1962016.0 |
| 2010-11-02 11:30:00 | QQQ | ETF | 52.67 | 52.7291 | 52.66 | 52.7 | 1031242.0 |
| 2010-11-02 12:00:00 | QQQ | ETF | 52.705 | 52.745 | 52.67 | 52.68 | 1345539.0 |
| 2010-11-02 12:30:00 | QQQ | ETF | 52.68 | 52.79 | 52.67 | 52.76 | 1635090.0 |
| 2010-11-02 13:00:00 | QQQ | ETF | 52.765 | 52.84 | 52.765 | 52.805 | 1900192.0 |
> showing 50 of 8,746 rows — these rows as CSV