PREVIEW / etf_1min / 2017-03-01
file: by_date/etf_1min/2017/2017-03-01.parquet size: 3.1 MB rows: 163,949
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 |
|---|---|---|---|---|---|---|---|
| 2017-03-01 04:00:00 | SPY | ETF | 237.42 | 237.65 | 237.42 | 237.61 | 49836.0 |
| 2017-03-01 04:01:00 | SPY | ETF | 237.59 | 237.61 | 237.56 | 237.56 | 1600.0 |
| 2017-03-01 04:02:00 | SPY | ETF | 237.6 | 237.66 | 237.52 | 237.66 | 1000.0 |
| 2017-03-01 04:03:00 | SPY | ETF | 237.63 | 237.63 | 237.63 | 237.63 | 1100.0 |
| 2017-03-01 04:04:00 | SPY | ETF | 237.57 | 237.61 | 237.57 | 237.6 | 2600.0 |
| 2017-03-01 04:05:00 | SPY | ETF | 237.6 | 237.6 | 237.6 | 237.6 | 100.0 |
| 2017-03-01 04:06:00 | SPY | ETF | 237.6 | 237.6 | 237.55 | 237.58 | 492.0 |
| 2017-03-01 04:14:00 | SPY | ETF | 237.66 | 237.66 | 237.66 | 237.66 | 400.0 |
| 2017-03-01 04:15:00 | SPY | ETF | 237.66 | 237.66 | 237.66 | 237.66 | 500.0 |
| 2017-03-01 04:16:00 | SPY | ETF | 237.63 | 237.63 | 237.63 | 237.63 | 400.0 |
| 2017-03-01 04:17:00 | SPY | ETF | 237.59 | 237.59 | 237.59 | 237.59 | 400.0 |
| 2017-03-01 04:19:00 | SPY | ETF | 237.63 | 237.63 | 237.63 | 237.63 | 416.0 |
| 2017-03-01 04:20:00 | SPY | ETF | 237.64 | 237.64 | 237.64 | 237.64 | 1105.0 |
| 2017-03-01 04:21:00 | SPY | ETF | 237.68 | 237.68 | 237.66 | 237.66 | 10400.0 |
| 2017-03-01 04:23:00 | SPY | ETF | 237.68 | 237.68 | 237.68 | 237.68 | 2605.0 |
| 2017-03-01 04:24:00 | SPY | ETF | 237.68 | 237.69 | 237.66 | 237.66 | 5450.0 |
| 2017-03-01 04:26:00 | SPY | ETF | 237.66 | 237.66 | 237.66 | 237.66 | 300.0 |
| 2017-03-01 04:30:00 | SPY | ETF | 237.64 | 237.66 | 237.64 | 237.66 | 200.0 |
| 2017-03-01 04:31:00 | SPY | ETF | 237.68 | 237.69 | 237.66 | 237.66 | 500.0 |
| 2017-03-01 04:33:00 | SPY | ETF | 237.66 | 237.66 | 237.66 | 237.66 | 300.0 |
| 2017-03-01 04:38:00 | SPY | ETF | 237.56 | 237.56 | 237.56 | 237.56 | 203.0 |
| 2017-03-01 04:39:00 | SPY | ETF | 237.56 | 237.56 | 237.56 | 237.56 | 300.0 |
| 2017-03-01 04:42:00 | SPY | ETF | 237.58 | 237.58 | 237.58 | 237.58 | 1000.0 |
| 2017-03-01 04:43:00 | SPY | ETF | 237.58 | 237.61 | 237.58 | 237.61 | 452.0 |
| 2017-03-01 04:44:00 | SPY | ETF | 237.58 | 237.58 | 237.58 | 237.58 | 1000.0 |
| 2017-03-01 04:46:00 | SPY | ETF | 237.63 | 237.64 | 237.63 | 237.64 | 1100.0 |
| 2017-03-01 04:48:00 | SPY | ETF | 237.63 | 237.63 | 237.63 | 237.63 | 1000.0 |
| 2017-03-01 04:49:00 | SPY | ETF | 237.63 | 237.63 | 237.63 | 237.63 | 1000.0 |
| 2017-03-01 04:51:00 | SPY | ETF | 237.6 | 237.61 | 237.6 | 237.61 | 500.0 |
| 2017-03-01 04:54:00 | SPY | ETF | 237.61 | 237.61 | 237.61 | 237.61 | 400.0 |
| 2017-03-01 04:57:00 | SPY | ETF | 237.6 | 237.6 | 237.6 | 237.6 | 202.0 |
| 2017-03-01 05:07:00 | SPY | ETF | 237.61 | 237.64 | 237.61 | 237.64 | 500.0 |
| 2017-03-01 05:08:00 | SPY | ETF | 237.61 | 237.61 | 237.61 | 237.61 | 1000.0 |
| 2017-03-01 05:11:00 | SPY | ETF | 237.6 | 237.6 | 237.6 | 237.6 | 200.0 |
| 2017-03-01 05:13:00 | SPY | ETF | 237.6 | 237.61 | 237.6 | 237.61 | 300.0 |
| 2017-03-01 05:16:00 | SPY | ETF | 237.56 | 237.56 | 237.56 | 237.56 | 1903.0 |
| 2017-03-01 05:17:00 | SPY | ETF | 237.56 | 237.56 | 237.51 | 237.51 | 533.0 |
| 2017-03-01 05:18:00 | SPY | ETF | 237.56 | 237.56 | 237.56 | 237.56 | 301.0 |
| 2017-03-01 05:20:00 | SPY | ETF | 237.55 | 237.55 | 237.55 | 237.55 | 748.0 |
| 2017-03-01 05:24:00 | SPY | ETF | 237.62 | 237.62 | 237.58 | 237.58 | 465.0 |
| 2017-03-01 05:26:00 | SPY | ETF | 237.64 | 237.64 | 237.64 | 237.64 | 801.0 |
| 2017-03-01 05:29:00 | SPY | ETF | 237.63 | 237.63 | 237.63 | 237.63 | 100.0 |
| 2017-03-01 05:30:00 | SPY | ETF | 237.66 | 237.66 | 237.66 | 237.66 | 304.0 |
| 2017-03-01 05:32:00 | SPY | ETF | 237.69 | 237.69 | 237.69 | 237.69 | 401.0 |
| 2017-03-01 05:33:00 | SPY | ETF | 237.69 | 237.69 | 237.69 | 237.69 | 2300.0 |
| 2017-03-01 05:34:00 | SPY | ETF | 237.65 | 237.65 | 237.65 | 237.65 | 1500.0 |
| 2017-03-01 05:35:00 | SPY | ETF | 237.66 | 237.66 | 237.66 | 237.66 | 101.0 |
| 2017-03-01 05:36:00 | SPY | ETF | 237.7 | 237.7 | 237.68 | 237.68 | 1230.0 |
| 2017-03-01 05:38:00 | SPY | ETF | 237.7 | 237.7 | 237.7 | 237.7 | 1771.0 |
| 2017-03-01 05:40:00 | SPY | ETF | 237.7 | 237.7 | 237.68 | 237.68 | 1100.0 |
> showing 50 of 163,949 rows — these rows as CSV