PREVIEW / etf_1min / 2017-02-14

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-02-14.parquet
  size:    3.0 MB
  rows:    149,794

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-02-14 04:00:00	SPY	ETF	232.75	232.75	232.75	232.75	200.0
2017-02-14 04:22:00	SPY	ETF	232.67	232.7	232.67	232.7	300.0
2017-02-14 04:25:00	SPY	ETF	232.59	232.59	232.59	232.59	1000.0
2017-02-14 04:27:00	SPY	ETF	232.59	232.59	232.59	232.59	400.0
2017-02-14 04:31:00	SPY	ETF	232.59	232.59	232.59	232.59	350.0
2017-02-14 04:32:00	SPY	ETF	232.57	232.57	232.57	232.57	800.0
2017-02-14 04:33:00	SPY	ETF	232.59	232.59	232.59	232.59	3000.0
2017-02-14 04:41:00	SPY	ETF	232.64	232.64	232.64	232.64	1300.0
2017-02-14 04:46:00	SPY	ETF	232.59	232.59	232.59	232.59	300.0
2017-02-14 04:56:00	SPY	ETF	232.62	232.62	232.62	232.62	300.0
2017-02-14 04:58:00	SPY	ETF	232.64	232.64	232.64	232.64	1000.0
2017-02-14 05:00:00	SPY	ETF	232.59	232.59	232.59	232.59	501.0
2017-02-14 05:06:00	SPY	ETF	232.59	232.59	232.59	232.59	500.0
2017-02-14 05:40:00	SPY	ETF	232.6	232.6	232.6	232.6	100.0
2017-02-14 05:51:00	SPY	ETF	232.59	232.59	232.59	232.59	202.0
2017-02-14 06:01:00	SPY	ETF	232.77	232.77	232.77	232.77	103.0
2017-02-14 06:02:00	SPY	ETF	232.79	232.79	232.79	232.79	500.0
2017-02-14 06:07:00	SPY	ETF	232.75	232.75	232.75	232.75	1003.0
2017-02-14 06:11:00	SPY	ETF	232.74	232.74	232.74	232.74	281.0
2017-02-14 06:22:00	SPY	ETF	232.71	232.71	232.71	232.71	252.0
2017-02-14 06:24:00	SPY	ETF	232.66	232.66	232.66	232.66	199.0
2017-02-14 06:26:00	SPY	ETF	232.66	232.69	232.66	232.69	650.0
2017-02-14 06:30:00	SPY	ETF	232.64	232.64	232.64	232.64	3300.0
2017-02-14 06:58:00	SPY	ETF	232.8	232.8	232.8	232.8	503.0
2017-02-14 07:00:00	SPY	ETF	232.76	232.8	232.76	232.8	600.0
2017-02-14 07:03:00	SPY	ETF	232.81	232.81	232.81	232.81	100.0
2017-02-14 07:05:00	SPY	ETF	232.77	232.77	232.77	232.77	1301.0
2017-02-14 07:06:00	SPY	ETF	232.75	232.75	232.75	232.75	5003.0
2017-02-14 07:07:00	SPY	ETF	232.75	232.76	232.75	232.76	10000.0
2017-02-14 07:08:00	SPY	ETF	232.77	232.77	232.77	232.77	600.0
2017-02-14 07:19:00	SPY	ETF	232.8	232.8	232.8	232.8	10202.0
2017-02-14 07:20:00	SPY	ETF	232.8	232.81	232.8	232.81	8750.0
2017-02-14 07:21:00	SPY	ETF	232.81	232.81	232.81	232.81	1698.0
2017-02-14 07:32:00	SPY	ETF	232.77	232.77	232.77	232.77	2600.0
2017-02-14 07:44:00	SPY	ETF	232.79	232.79	232.79	232.79	200.0
2017-02-14 07:46:00	SPY	ETF	232.79	232.81	232.79	232.8	401.0
2017-02-14 07:47:00	SPY	ETF	232.81	232.81	232.81	232.81	200.0
2017-02-14 07:48:00	SPY	ETF	232.81	232.83	232.81	232.82	2100.0
2017-02-14 07:49:00	SPY	ETF	232.83	232.83	232.83	232.83	200.0
2017-02-14 07:50:00	SPY	ETF	232.82	232.82	232.82	232.82	100.0
2017-02-14 07:51:00	SPY	ETF	232.81	232.81	232.77	232.77	702.0
2017-02-14 07:52:00	SPY	ETF	232.8	232.8	232.8	232.8	101.0
2017-02-14 07:53:00	SPY	ETF	232.8	232.8	232.76	232.76	2100.0
2017-02-14 07:56:00	SPY	ETF	232.77	232.83	232.77	232.83	11000.0
2017-02-14 07:58:00	SPY	ETF	232.8	232.8	232.77	232.77	7000.0
2017-02-14 07:59:00	SPY	ETF	232.77	232.77	232.77	232.77	100.0
2017-02-14 08:00:00	SPY	ETF	232.79	232.8	232.79	232.79	5830.0
2017-02-14 08:01:00	SPY	ETF	232.79	232.79	232.79	232.79	148.0
2017-02-14 08:02:00	SPY	ETF	232.79	232.8	232.76	232.76	1239.0
2017-02-14 08:04:00	SPY	ETF	232.8	232.8	232.8	232.8	100.0

> showing 50 of 149,794 rows — these rows as CSV

> unlock the full archive -- $79 one-time