PREVIEW / etf_30min / 2015-01-21
file: by_date/etf_30min/2015/2015-01-21.parquet size: 382 KB rows: 12,864
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 |
|---|---|---|---|---|---|---|---|
| 2015-01-21 04:00:00 | SPY | ETF | 201.99 | 202.13 | 201.99 | 202.1 | 500.0 |
| 2015-01-21 04:30:00 | SPY | ETF | 201.96 | 201.98 | 201.91 | 201.93 | 400.0 |
| 2015-01-21 05:00:00 | SPY | ETF | 202.12 | 202.12 | 202.09 | 202.09 | 3000.0 |
| 2015-01-21 05:30:00 | SPY | ETF | 202.09 | 202.22 | 202.09 | 202.12 | 7700.0 |
| 2015-01-21 06:00:00 | SPY | ETF | 202.01 | 202.02 | 201.77 | 201.81 | 13421.0 |
| 2015-01-21 06:30:00 | SPY | ETF | 201.82 | 201.82 | 201.57 | 201.64 | 42440.0 |
| 2015-01-21 07:00:00 | SPY | ETF | 201.69 | 201.7 | 201.21 | 201.35 | 244558.0 |
| 2015-01-21 07:30:00 | SPY | ETF | 201.34 | 201.55 | 201.24 | 201.34 | 219952.0 |
| 2015-01-21 08:00:00 | SPY | ETF | 201.35 | 201.73 | 201.27 | 201.7 | 339242.0 |
| 2015-01-21 08:30:00 | SPY | ETF | 201.74 | 201.78 | 201.4 | 201.47 | 361895.0 |
| 2015-01-21 09:00:00 | SPY | ETF | 201.48 | 201.72 | 201.35 | 201.48 | 834531.0 |
| 2015-01-21 09:30:00 | SPY | ETF | 201.5 | 202.81 | 200.94 | 202.17 | 27531284.0 |
| 2015-01-21 10:00:00 | SPY | ETF | 202.17 | 202.66 | 201.75 | 202.5 | 13129351.0 |
| 2015-01-21 10:30:00 | SPY | ETF | 202.505 | 203.5 | 202.32 | 203.41 | 10215138.0 |
| 2015-01-21 11:00:00 | SPY | ETF | 203.4 | 203.66 | 202.91 | 203.12 | 6631971.0 |
| 2015-01-21 11:30:00 | SPY | ETF | 203.1101 | 203.43 | 202.94 | 203.2572 | 4017281.0 |
| 2015-01-21 12:00:00 | SPY | ETF | 203.2562 | 203.41 | 203.08 | 203.39 | 2877836.0 |
| 2015-01-21 12:30:00 | SPY | ETF | 203.39 | 203.475 | 202.65 | 202.89 | 4324735.0 |
| 2015-01-21 13:00:00 | SPY | ETF | 202.88 | 203.1 | 202.52 | 202.61 | 4349439.0 |
| 2015-01-21 13:30:00 | SPY | ETF | 202.61 | 202.65 | 202.185 | 202.21 | 5509200.0 |
| 2015-01-21 14:00:00 | SPY | ETF | 202.22 | 202.63 | 202.02 | 202.495 | 5708394.0 |
| 2015-01-21 14:30:00 | SPY | ETF | 202.5 | 202.97 | 202.231 | 202.89 | 5018308.0 |
| 2015-01-21 15:00:00 | SPY | ETF | 202.88 | 203.08 | 202.45 | 202.9001 | 6272907.0 |
| 2015-01-21 15:30:00 | SPY | ETF | 202.9 | 203.19 | 202.88 | 203.09 | 13053950.0 |
| 2015-01-21 16:00:00 | SPY | ETF | 203.09 | 203.13 | 202.4 | 203.07 | 3789872.0 |
| 2015-01-21 16:30:00 | SPY | ETF | 203.08 | 203.222 | 203.03 | 203.08 | 3801818.0 |
| 2015-01-21 17:00:00 | SPY | ETF | 203.07 | 203.17 | 203.04 | 203.16 | 246306.0 |
| 2015-01-21 17:30:00 | SPY | ETF | 203.16 | 203.17 | 203.11 | 203.11 | 94836.0 |
| 2015-01-21 18:00:00 | SPY | ETF | 203.12 | 203.17 | 202.97 | 202.98 | 106731.0 |
| 2015-01-21 18:30:00 | SPY | ETF | 202.99 | 203.19 | 202.99 | 203.08 | 23226.0 |
| 2015-01-21 19:00:00 | SPY | ETF | 203.03 | 203.09 | 203.0 | 203.06 | 14300.0 |
| 2015-01-21 19:30:00 | SPY | ETF | 203.06 | 203.08 | 203.01 | 203.07 | 14910.0 |
| 2015-01-21 06:00:00 | QQQ | ETF | 101.49 | 101.54 | 101.48 | 101.54 | 8000.0 |
| 2015-01-21 06:30:00 | QQQ | ETF | 101.44 | 101.46 | 101.43 | 101.43 | 10400.0 |
| 2015-01-21 07:00:00 | QQQ | ETF | 101.39 | 101.39 | 101.29 | 101.29 | 15600.0 |
| 2015-01-21 07:30:00 | QQQ | ETF | 101.33 | 101.42 | 101.29 | 101.34 | 12299.0 |
| 2015-01-21 08:00:00 | QQQ | ETF | 101.33 | 101.53 | 101.33 | 101.53 | 46807.0 |
| 2015-01-21 08:30:00 | QQQ | ETF | 101.54 | 101.54 | 101.36 | 101.39 | 31472.0 |
| 2015-01-21 09:00:00 | QQQ | ETF | 101.44 | 101.51 | 101.31 | 101.32 | 138880.0 |
| 2015-01-21 09:30:00 | QQQ | ETF | 101.32 | 102.03 | 100.9648 | 101.52 | 9081199.0 |
| 2015-01-21 10:00:00 | QQQ | ETF | 101.51 | 101.9 | 101.35 | 101.78 | 4356813.0 |
| 2015-01-21 10:30:00 | QQQ | ETF | 101.78 | 102.525 | 101.64 | 102.45 | 2779856.0 |
| 2015-01-21 11:00:00 | QQQ | ETF | 102.46 | 102.619 | 102.155 | 102.38 | 2433653.0 |
| 2015-01-21 11:30:00 | QQQ | ETF | 102.37 | 102.435 | 102.2 | 102.3501 | 823424.0 |
| 2015-01-21 12:00:00 | QQQ | ETF | 102.35 | 102.45 | 102.24 | 102.39 | 617702.0 |
| 2015-01-21 12:30:00 | QQQ | ETF | 102.4 | 102.45 | 101.95 | 102.14 | 2426802.0 |
| 2015-01-21 13:00:00 | QQQ | ETF | 102.13 | 102.285 | 101.96 | 102.0 | 1565086.0 |
| 2015-01-21 13:30:00 | QQQ | ETF | 102.0094 | 102.0094 | 101.69 | 101.7 | 1491481.0 |
| 2015-01-21 14:00:00 | QQQ | ETF | 101.7 | 101.98 | 101.58 | 101.89 | 1434212.0 |
| 2015-01-21 14:30:00 | QQQ | ETF | 101.8899 | 102.18 | 101.71 | 102.14 | 1156608.0 |
> showing 50 of 12,864 rows — these rows as CSV