PREVIEW / etf_1min / 2017-12-13

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-12-13.parquet
  size:    2.9 MB
  rows:    148,686

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-12-13 04:00:00	SPY	ETF	266.57	266.57	266.57	266.57	228.0
2017-12-13 04:13:00	SPY	ETF	266.7	266.7	266.7	266.7	150.0
2017-12-13 04:20:00	SPY	ETF	266.72	266.72	266.72	266.72	105.0
2017-12-13 05:45:00	SPY	ETF	266.73	266.73	266.73	266.73	101.0
2017-12-13 06:09:00	SPY	ETF	266.9	266.92	266.9	266.92	5503.0
2017-12-13 06:21:00	SPY	ETF	266.82	266.9	266.82	266.9	501.0
2017-12-13 07:00:00	SPY	ETF	266.75	266.75	266.75	266.75	300.0
2017-12-13 07:01:00	SPY	ETF	266.75	266.75	266.75	266.75	300.0
2017-12-13 07:02:00	SPY	ETF	266.75	266.75	266.75	266.75	2400.0
2017-12-13 07:06:00	SPY	ETF	266.73	266.73	266.73	266.73	404.0
2017-12-13 07:08:00	SPY	ETF	266.63	266.63	266.63	266.63	500.0
2017-12-13 07:09:00	SPY	ETF	266.66	266.66	266.66	266.66	501.0
2017-12-13 07:12:00	SPY	ETF	266.71	266.75	266.71	266.75	475.0
2017-12-13 07:15:00	SPY	ETF	266.75	266.75	266.75	266.75	1000.0
2017-12-13 07:18:00	SPY	ETF	266.72	266.72	266.72	266.72	104.0
2017-12-13 07:19:00	SPY	ETF	266.71	266.77	266.71	266.77	505.0
2017-12-13 07:22:00	SPY	ETF	266.73	266.73	266.73	266.73	23000.0
2017-12-13 07:23:00	SPY	ETF	266.73	266.73	266.73	266.73	27000.0
2017-12-13 07:24:00	SPY	ETF	266.71	266.71	266.71	266.71	706.0
2017-12-13 07:26:00	SPY	ETF	266.7	266.7	266.7	266.7	199.0
2017-12-13 07:29:00	SPY	ETF	266.73	266.73	266.73	266.73	101.0
2017-12-13 07:33:00	SPY	ETF	266.73	266.73	266.73	266.73	1000.0
2017-12-13 07:34:00	SPY	ETF	266.73	266.75	266.72	266.74	27578.0
2017-12-13 07:36:00	SPY	ETF	266.74	266.74	266.74	266.74	300.0
2017-12-13 07:37:00	SPY	ETF	266.72	266.72	266.71	266.72	35006.0
2017-12-13 07:38:00	SPY	ETF	266.7	266.7	266.7	266.7	3500.0
2017-12-13 07:50:00	SPY	ETF	266.7	266.7	266.68	266.7	1499.0
2017-12-13 07:51:00	SPY	ETF	266.71	266.71	266.71	266.71	100.0
2017-12-13 07:52:00	SPY	ETF	266.68	266.68	266.63	266.63	19377.0
2017-12-13 07:56:00	SPY	ETF	266.68	266.68	266.63	266.63	2341.0
2017-12-13 07:57:00	SPY	ETF	266.63	266.63	266.58	266.61	14749.0
2017-12-13 07:58:00	SPY	ETF	266.56	266.61	266.55	266.61	2861.0
2017-12-13 07:59:00	SPY	ETF	266.63	266.65	266.63	266.64	1112.0
2017-12-13 08:00:00	SPY	ETF	266.72	266.73	266.65	266.66	1371.0
2017-12-13 08:01:00	SPY	ETF	266.66	266.66	266.66	266.66	653.0
2017-12-13 08:02:00	SPY	ETF	266.65	266.66	266.65	266.66	502.0
2017-12-13 08:03:00	SPY	ETF	266.62	266.64	266.62	266.64	1103.0
2017-12-13 08:05:00	SPY	ETF	266.65	266.67	266.65	266.67	406.0
2017-12-13 08:06:00	SPY	ETF	266.67	266.67	266.67	266.67	201.0
2017-12-13 08:08:00	SPY	ETF	266.69	266.72	266.69	266.72	10207.0
2017-12-13 08:09:00	SPY	ETF	266.73	266.79	266.73	266.79	24630.0
2017-12-13 08:10:00	SPY	ETF	266.78	266.79	266.77	266.78	11070.0
2017-12-13 08:11:00	SPY	ETF	266.76	266.76	266.76	266.76	100.0
2017-12-13 08:12:00	SPY	ETF	266.78	266.79	266.77	266.79	88002.0
2017-12-13 08:14:00	SPY	ETF	266.79	266.79	266.79	266.79	3760.0
2017-12-13 08:15:00	SPY	ETF	266.81	266.81	266.81	266.81	3675.0
2017-12-13 08:16:00	SPY	ETF	266.81	266.81	266.81	266.81	17498.0
2017-12-13 08:20:00	SPY	ETF	266.81	266.81	266.81	266.81	250.0
2017-12-13 08:21:00	SPY	ETF	266.81	266.86	266.81	266.86	794.0
2017-12-13 08:22:00	SPY	ETF	266.86	266.86	266.86	266.86	1203.0

> showing 50 of 148,686 rows — these rows as CSV

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