PREVIEW / etf_5min / 2015-08-21
file: by_date/etf_5min/2015/2015-08-21.parquet size: 1.4 MB rows: 58,452
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-08-21 04:00:00 | SPY | ETF | 203.15 | 203.15 | 203.05 | 203.09 | 4139.0 |
| 2015-08-21 04:05:00 | SPY | ETF | 203.25 | 203.25 | 203.2 | 203.23 | 6125.0 |
| 2015-08-21 04:10:00 | SPY | ETF | 203.1 | 203.1 | 203.0 | 203.05 | 1981.0 |
| 2015-08-21 04:15:00 | SPY | ETF | 203.01 | 203.06 | 202.94 | 203.06 | 1725.0 |
| 2015-08-21 04:20:00 | SPY | ETF | 203.13 | 203.25 | 203.13 | 203.15 | 3830.0 |
| 2015-08-21 04:25:00 | SPY | ETF | 203.16 | 203.25 | 203.16 | 203.25 | 5474.0 |
| 2015-08-21 04:30:00 | SPY | ETF | 203.27 | 203.32 | 203.22 | 203.22 | 7250.0 |
| 2015-08-21 04:35:00 | SPY | ETF | 203.15 | 203.15 | 203.1 | 203.1 | 380.0 |
| 2015-08-21 04:40:00 | SPY | ETF | 203.11 | 203.2 | 203.11 | 203.2 | 12012.0 |
| 2015-08-21 04:45:00 | SPY | ETF | 203.0 | 203.22 | 202.97 | 203.2 | 32400.0 |
| 2015-08-21 04:50:00 | SPY | ETF | 203.2 | 203.32 | 203.2 | 203.32 | 24570.0 |
| 2015-08-21 04:55:00 | SPY | ETF | 203.3 | 203.3 | 203.19 | 203.19 | 1700.0 |
| 2015-08-21 05:00:00 | SPY | ETF | 203.31 | 203.35 | 203.29 | 203.33 | 13515.0 |
| 2015-08-21 05:05:00 | SPY | ETF | 203.43 | 203.56 | 203.43 | 203.52 | 12245.0 |
| 2015-08-21 05:10:00 | SPY | ETF | 203.42 | 203.47 | 203.35 | 203.35 | 1900.0 |
| 2015-08-21 05:15:00 | SPY | ETF | 203.3 | 203.35 | 203.23 | 203.28 | 5492.0 |
| 2015-08-21 05:20:00 | SPY | ETF | 203.28 | 203.36 | 203.28 | 203.36 | 300.0 |
| 2015-08-21 05:25:00 | SPY | ETF | 203.32 | 203.46 | 203.32 | 203.46 | 700.0 |
| 2015-08-21 05:30:00 | SPY | ETF | 203.4 | 203.44 | 203.4 | 203.44 | 10100.0 |
| 2015-08-21 05:35:00 | SPY | ETF | 203.44 | 203.5 | 203.4 | 203.4 | 4050.0 |
| 2015-08-21 05:40:00 | SPY | ETF | 203.39 | 203.55 | 203.39 | 203.52 | 3930.0 |
| 2015-08-21 05:45:00 | SPY | ETF | 203.53 | 203.53 | 203.33 | 203.33 | 3945.0 |
| 2015-08-21 05:50:00 | SPY | ETF | 203.35 | 203.36 | 203.01 | 203.02 | 11750.0 |
| 2015-08-21 05:55:00 | SPY | ETF | 203.01 | 203.08 | 202.94 | 203.08 | 13975.0 |
| 2015-08-21 06:00:00 | SPY | ETF | 203.08 | 203.08 | 203.0 | 203.05 | 19350.0 |
| 2015-08-21 06:05:00 | SPY | ETF | 203.08 | 203.14 | 203.05 | 203.13 | 916.0 |
| 2015-08-21 06:10:00 | SPY | ETF | 203.01 | 203.04 | 203.01 | 203.04 | 12500.0 |
| 2015-08-21 06:15:00 | SPY | ETF | 203.03 | 203.05 | 202.95 | 203.03 | 19015.0 |
| 2015-08-21 06:20:00 | SPY | ETF | 203.06 | 203.06 | 202.83 | 202.89 | 22465.0 |
| 2015-08-21 06:25:00 | SPY | ETF | 202.89 | 202.9 | 202.72 | 202.72 | 12677.0 |
| 2015-08-21 06:30:00 | SPY | ETF | 202.73 | 202.83 | 202.64 | 202.83 | 2355.0 |
| 2015-08-21 06:35:00 | SPY | ETF | 202.85 | 202.9 | 202.8 | 202.8 | 9436.0 |
| 2015-08-21 06:40:00 | SPY | ETF | 202.78 | 202.78 | 202.6 | 202.6 | 6800.0 |
| 2015-08-21 06:45:00 | SPY | ETF | 202.68 | 202.85 | 202.68 | 202.8 | 39555.0 |
| 2015-08-21 06:50:00 | SPY | ETF | 202.73 | 202.9 | 202.73 | 202.88 | 30300.0 |
| 2015-08-21 06:55:00 | SPY | ETF | 202.85 | 202.85 | 202.74 | 202.82 | 7900.0 |
| 2015-08-21 07:00:00 | SPY | ETF | 202.82 | 202.98 | 202.82 | 202.82 | 35460.0 |
| 2015-08-21 07:05:00 | SPY | ETF | 202.87 | 202.87 | 202.76 | 202.76 | 8066.0 |
| 2015-08-21 07:10:00 | SPY | ETF | 202.75 | 202.76 | 202.46 | 202.54 | 36433.0 |
| 2015-08-21 07:15:00 | SPY | ETF | 202.56 | 202.79 | 202.56 | 202.79 | 21555.0 |
| 2015-08-21 07:20:00 | SPY | ETF | 202.8 | 202.83 | 202.73 | 202.81 | 52455.0 |
| 2015-08-21 07:25:00 | SPY | ETF | 202.79 | 202.81 | 202.73 | 202.74 | 24975.0 |
| 2015-08-21 07:30:00 | SPY | ETF | 202.83 | 202.83 | 202.72 | 202.77 | 50510.0 |
| 2015-08-21 07:35:00 | SPY | ETF | 202.81 | 203.08 | 202.81 | 203.07 | 49325.0 |
| 2015-08-21 07:40:00 | SPY | ETF | 203.04 | 203.1 | 202.94 | 202.94 | 100949.0 |
| 2015-08-21 07:45:00 | SPY | ETF | 202.95 | 202.95 | 202.8 | 202.81 | 47355.0 |
| 2015-08-21 07:50:00 | SPY | ETF | 202.82 | 202.92 | 202.78 | 202.87 | 73920.0 |
| 2015-08-21 07:55:00 | SPY | ETF | 202.82 | 202.83 | 202.6 | 202.7 | 77651.0 |
| 2015-08-21 08:00:00 | SPY | ETF | 202.73 | 203.05 | 202.48 | 202.48 | 274764.0 |
| 2015-08-21 08:05:00 | SPY | ETF | 202.54 | 202.67 | 202.47 | 202.57 | 54692.0 |
> showing 50 of 58,452 rows — these rows as CSV