PREVIEW / etf_1min / 2014-11-25
file: by_date/etf_1min/2014/2014-11-25.parquet size: 2.3 MB rows: 121,486
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 |
|---|---|---|---|---|---|---|---|
| 2014-11-25 04:01:00 | SPY | ETF | 207.31 | 207.31 | 207.31 | 207.31 | 100.0 |
| 2014-11-25 04:06:00 | SPY | ETF | 207.31 | 207.31 | 207.31 | 207.31 | 20000.0 |
| 2014-11-25 04:09:00 | SPY | ETF | 207.48 | 207.48 | 207.48 | 207.48 | 500.0 |
| 2014-11-25 04:17:00 | SPY | ETF | 207.38 | 207.38 | 207.38 | 207.38 | 325.0 |
| 2014-11-25 04:23:00 | SPY | ETF | 207.42 | 207.42 | 207.42 | 207.42 | 100.0 |
| 2014-11-25 04:31:00 | SPY | ETF | 207.5 | 207.5 | 207.5 | 207.5 | 127.0 |
| 2014-11-25 04:35:00 | SPY | ETF | 207.54 | 207.54 | 207.54 | 207.54 | 100.0 |
| 2014-11-25 04:44:00 | SPY | ETF | 207.41 | 207.41 | 207.41 | 207.41 | 100.0 |
| 2014-11-25 04:50:00 | SPY | ETF | 207.44 | 207.44 | 207.44 | 207.44 | 900.0 |
| 2014-11-25 04:58:00 | SPY | ETF | 207.49 | 207.49 | 207.49 | 207.49 | 100.0 |
| 2014-11-25 05:02:00 | SPY | ETF | 207.46 | 207.46 | 207.46 | 207.46 | 1500.0 |
| 2014-11-25 05:03:00 | SPY | ETF | 207.46 | 207.46 | 207.46 | 207.46 | 1500.0 |
| 2014-11-25 05:04:00 | SPY | ETF | 207.49 | 207.49 | 207.49 | 207.49 | 1000.0 |
| 2014-11-25 05:08:00 | SPY | ETF | 207.58 | 207.58 | 207.58 | 207.58 | 100.0 |
| 2014-11-25 05:10:00 | SPY | ETF | 207.53 | 207.53 | 207.51 | 207.51 | 500.0 |
| 2014-11-25 05:15:00 | SPY | ETF | 207.53 | 207.53 | 207.53 | 207.53 | 200.0 |
| 2014-11-25 05:16:00 | SPY | ETF | 207.55 | 207.57 | 207.55 | 207.57 | 500.0 |
| 2014-11-25 05:17:00 | SPY | ETF | 207.55 | 207.57 | 207.55 | 207.57 | 2400.0 |
| 2014-11-25 05:18:00 | SPY | ETF | 207.55 | 207.57 | 207.55 | 207.56 | 14482.0 |
| 2014-11-25 05:30:00 | SPY | ETF | 207.51 | 207.51 | 207.51 | 207.51 | 800.0 |
| 2014-11-25 05:32:00 | SPY | ETF | 207.53 | 207.53 | 207.53 | 207.53 | 100.0 |
| 2014-11-25 05:34:00 | SPY | ETF | 207.54 | 207.54 | 207.54 | 207.54 | 200.0 |
| 2014-11-25 05:35:00 | SPY | ETF | 207.53 | 207.53 | 207.53 | 207.53 | 100.0 |
| 2014-11-25 05:42:00 | SPY | ETF | 207.45 | 207.47 | 207.45 | 207.47 | 3000.0 |
| 2014-11-25 05:44:00 | SPY | ETF | 207.45 | 207.47 | 207.45 | 207.47 | 3500.0 |
| 2014-11-25 06:06:00 | SPY | ETF | 207.46 | 207.46 | 207.46 | 207.46 | 4680.0 |
| 2014-11-25 06:09:00 | SPY | ETF | 207.45 | 207.47 | 207.45 | 207.47 | 480.0 |
| 2014-11-25 06:11:00 | SPY | ETF | 207.43 | 207.43 | 207.43 | 207.43 | 500.0 |
| 2014-11-25 06:12:00 | SPY | ETF | 207.43 | 207.43 | 207.43 | 207.43 | 100.0 |
| 2014-11-25 06:13:00 | SPY | ETF | 207.45 | 207.45 | 207.43 | 207.43 | 600.0 |
| 2014-11-25 06:18:00 | SPY | ETF | 207.43 | 207.43 | 207.43 | 207.43 | 100.0 |
| 2014-11-25 06:19:00 | SPY | ETF | 207.44 | 207.44 | 207.44 | 207.44 | 100.0 |
| 2014-11-25 06:20:00 | SPY | ETF | 207.43 | 207.43 | 207.43 | 207.43 | 100.0 |
| 2014-11-25 06:21:00 | SPY | ETF | 207.45 | 207.45 | 207.45 | 207.45 | 100.0 |
| 2014-11-25 06:22:00 | SPY | ETF | 207.45 | 207.45 | 207.45 | 207.45 | 100.0 |
| 2014-11-25 06:25:00 | SPY | ETF | 207.45 | 207.45 | 207.45 | 207.45 | 300.0 |
| 2014-11-25 06:27:00 | SPY | ETF | 207.47 | 207.47 | 207.47 | 207.47 | 500.0 |
| 2014-11-25 06:28:00 | SPY | ETF | 207.46 | 207.46 | 207.46 | 207.46 | 199.0 |
| 2014-11-25 06:31:00 | SPY | ETF | 207.5 | 207.52 | 207.5 | 207.52 | 539.0 |
| 2014-11-25 06:57:00 | SPY | ETF | 207.41 | 207.41 | 207.41 | 207.41 | 4000.0 |
| 2014-11-25 06:58:00 | SPY | ETF | 207.41 | 207.41 | 207.41 | 207.41 | 100.0 |
| 2014-11-25 07:00:00 | SPY | ETF | 207.41 | 207.41 | 207.41 | 207.41 | 400.0 |
| 2014-11-25 07:06:00 | SPY | ETF | 207.5 | 207.5 | 207.5 | 207.5 | 1000.0 |
| 2014-11-25 07:08:00 | SPY | ETF | 207.48 | 207.51 | 207.48 | 207.51 | 1330.0 |
| 2014-11-25 07:16:00 | SPY | ETF | 207.46 | 207.46 | 207.46 | 207.46 | 1000.0 |
| 2014-11-25 07:18:00 | SPY | ETF | 207.47 | 207.47 | 207.47 | 207.47 | 100.0 |
| 2014-11-25 07:20:00 | SPY | ETF | 207.47 | 207.47 | 207.47 | 207.47 | 100.0 |
| 2014-11-25 07:24:00 | SPY | ETF | 207.47 | 207.48 | 207.47 | 207.48 | 1900.0 |
| 2014-11-25 07:26:00 | SPY | ETF | 207.46 | 207.46 | 207.46 | 207.46 | 100.0 |
| 2014-11-25 07:28:00 | SPY | ETF | 207.43 | 207.43 | 207.43 | 207.43 | 3000.0 |
> showing 50 of 121,486 rows — these rows as CSV