PREVIEW / etf_1min / 2017-12-12

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-12-12.parquet
  size:    2.7 MB
  rows:    141,734

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-12 04:08:00	SPY	ETF	266.62	266.62	266.62	266.62	100.0
2017-12-12 04:14:00	SPY	ETF	266.6	266.6	266.6	266.6	400.0
2017-12-12 04:19:00	SPY	ETF	266.69	266.69	266.69	266.69	400.0
2017-12-12 04:21:00	SPY	ETF	266.72	266.72	266.72	266.72	400.0
2017-12-12 04:23:00	SPY	ETF	266.71	266.71	266.71	266.71	100.0
2017-12-12 04:30:00	SPY	ETF	266.74	266.75	266.74	266.75	400.0
2017-12-12 04:31:00	SPY	ETF	266.7	266.7	266.69	266.69	1400.0
2017-12-12 04:32:00	SPY	ETF	266.67	266.67	266.67	266.67	300.0
2017-12-12 04:34:00	SPY	ETF	266.69	266.69	266.69	266.69	400.0
2017-12-12 04:36:00	SPY	ETF	266.72	266.72	266.7	266.7	17700.0
2017-12-12 04:37:00	SPY	ETF	266.7	266.7	266.7	266.7	3100.0
2017-12-12 04:39:00	SPY	ETF	266.71	266.71	266.71	266.71	300.0
2017-12-12 04:45:00	SPY	ETF	266.64	266.64	266.64	266.64	1400.0
2017-12-12 04:48:00	SPY	ETF	266.57	266.6	266.49	266.6	2782.0
2017-12-12 04:57:00	SPY	ETF	266.53	266.53	266.53	266.53	100.0
2017-12-12 05:02:00	SPY	ETF	266.58	266.58	266.58	266.58	100.0
2017-12-12 05:03:00	SPY	ETF	266.6	266.6	266.6	266.6	500.0
2017-12-12 05:04:00	SPY	ETF	266.56	266.56	266.56	266.56	320.0
2017-12-12 05:06:00	SPY	ETF	266.53	266.53	266.5	266.51	600.0
2017-12-12 05:12:00	SPY	ETF	266.51	266.51	266.51	266.51	300.0
2017-12-12 05:27:00	SPY	ETF	266.47	266.47	266.47	266.47	300.0
2017-12-12 05:29:00	SPY	ETF	266.52	266.52	266.52	266.52	300.0
2017-12-12 05:33:00	SPY	ETF	266.51	266.51	266.51	266.51	400.0
2017-12-12 05:45:00	SPY	ETF	266.44	266.44	266.44	266.44	600.0
2017-12-12 05:55:00	SPY	ETF	266.44	266.44	266.44	266.44	100.0
2017-12-12 06:02:00	SPY	ETF	266.51	266.51	266.51	266.51	444.0
2017-12-12 06:19:00	SPY	ETF	266.59	266.59	266.59	266.59	700.0
2017-12-12 06:23:00	SPY	ETF	266.58	266.58	266.58	266.58	700.0
2017-12-12 06:29:00	SPY	ETF	266.58	266.58	266.58	266.58	300.0
2017-12-12 06:33:00	SPY	ETF	266.57	266.57	266.57	266.57	100.0
2017-12-12 06:34:00	SPY	ETF	266.56	266.56	266.56	266.56	10000.0
2017-12-12 06:36:00	SPY	ETF	266.56	266.56	266.56	266.56	800.0
2017-12-12 06:39:00	SPY	ETF	266.53	266.53	266.53	266.53	100.0
2017-12-12 06:41:00	SPY	ETF	266.54	266.54	266.54	266.54	300.0
2017-12-12 06:42:00	SPY	ETF	266.51	266.51	266.51	266.51	1000.0
2017-12-12 06:43:00	SPY	ETF	266.54	266.54	266.54	266.54	600.0
2017-12-12 06:54:00	SPY	ETF	266.54	266.54	266.54	266.54	500.0
2017-12-12 06:58:00	SPY	ETF	266.56	266.57	266.56	266.57	400.0
2017-12-12 07:00:00	SPY	ETF	266.56	266.6	266.56	266.56	1003.0
2017-12-12 07:01:00	SPY	ETF	266.59	266.59	266.59	266.59	300.0
2017-12-12 07:02:00	SPY	ETF	266.59	266.59	266.58	266.58	1200.0
2017-12-12 07:03:00	SPY	ETF	266.6	266.6	266.6	266.6	1000.0
2017-12-12 07:04:00	SPY	ETF	266.6	266.6	266.58	266.59	31470.0
2017-12-12 07:05:00	SPY	ETF	266.59	266.59	266.59	266.59	900.0
2017-12-12 07:06:00	SPY	ETF	266.59	266.62	266.59	266.62	1800.0
2017-12-12 07:07:00	SPY	ETF	266.61	266.61	266.61	266.61	300.0
2017-12-12 07:08:00	SPY	ETF	266.61	266.61	266.61	266.61	100.0
2017-12-12 07:09:00	SPY	ETF	266.63	266.65	266.63	266.65	500.0
2017-12-12 07:15:00	SPY	ETF	266.66	266.66	266.66	266.66	710.0
2017-12-12 07:18:00	SPY	ETF	266.66	266.66	266.66	266.66	5200.0

> showing 50 of 141,734 rows — these rows as CSV

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