PREVIEW / etf_1min / 2016-06-13

all etf 1-min files

  file:    by_date/etf_1min/2016/2016-06-13.parquet
  size:    2.5 MB
  rows:    135,316

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
2016-06-13 04:00:00	SPY	ETF	209.6	209.6	209.6	209.6	215.0
2016-06-13 04:01:00	SPY	ETF	209.79	209.79	209.79	209.79	200.0
2016-06-13 04:03:00	SPY	ETF	209.67	209.67	209.6	209.6	903.0
2016-06-13 04:06:00	SPY	ETF	209.74	209.76	209.74	209.76	301.0
2016-06-13 04:07:00	SPY	ETF	209.81	209.81	209.76	209.76	542.0
2016-06-13 04:08:00	SPY	ETF	209.76	209.76	209.76	209.76	102.0
2016-06-13 04:09:00	SPY	ETF	209.8	209.81	209.8	209.81	45055.0
2016-06-13 04:10:00	SPY	ETF	209.81	209.81	209.81	209.81	28500.0
2016-06-13 04:12:00	SPY	ETF	209.91	209.91	209.91	209.91	106.0
2016-06-13 04:14:00	SPY	ETF	209.94	209.94	209.94	209.94	34578.0
2016-06-13 04:18:00	SPY	ETF	209.93	209.93	209.93	209.93	1319.0
2016-06-13 04:21:00	SPY	ETF	209.83	209.83	209.83	209.83	154.0
2016-06-13 04:26:00	SPY	ETF	209.76	209.77	209.76	209.77	417.0
2016-06-13 04:32:00	SPY	ETF	209.72	209.72	209.72	209.72	1600.0
2016-06-13 04:40:00	SPY	ETF	209.68	209.68	209.68	209.68	1000.0
2016-06-13 04:47:00	SPY	ETF	209.59	209.62	209.59	209.62	313.0
2016-06-13 04:53:00	SPY	ETF	209.54	209.54	209.54	209.54	1006.0
2016-06-13 04:56:00	SPY	ETF	209.53	209.53	209.53	209.53	362.0
2016-06-13 04:57:00	SPY	ETF	209.51	209.51	209.47	209.47	1849.0
2016-06-13 04:58:00	SPY	ETF	209.46	209.46	209.46	209.46	720.0
2016-06-13 05:03:00	SPY	ETF	209.43	209.44	209.43	209.44	3014.0
2016-06-13 05:05:00	SPY	ETF	209.49	209.49	209.44	209.44	401.0
2016-06-13 05:07:00	SPY	ETF	209.4	209.4	209.36	209.36	2702.0
2016-06-13 05:10:00	SPY	ETF	209.36	209.36	209.34	209.34	2002.0
2016-06-13 05:11:00	SPY	ETF	209.35	209.35	209.35	209.35	302.0
2016-06-13 05:13:00	SPY	ETF	209.34	209.34	209.32	209.32	1803.0
2016-06-13 05:21:00	SPY	ETF	209.37	209.37	209.35	209.35	907.0
2016-06-13 05:23:00	SPY	ETF	209.33	209.33	209.33	209.33	1002.0
2016-06-13 05:25:00	SPY	ETF	209.35	209.35	209.3	209.3	1702.0
2016-06-13 05:26:00	SPY	ETF	209.28	209.28	209.28	209.28	101.0
2016-06-13 05:27:00	SPY	ETF	209.28	209.28	209.27	209.27	1104.0
2016-06-13 05:29:00	SPY	ETF	209.3	209.3	209.3	209.3	303.0
2016-06-13 05:32:00	SPY	ETF	209.39	209.39	209.39	209.39	1003.0
2016-06-13 05:36:00	SPY	ETF	209.42	209.42	209.42	209.42	500.0
2016-06-13 05:37:00	SPY	ETF	209.39	209.39	209.39	209.39	2300.0
2016-06-13 05:39:00	SPY	ETF	209.35	209.35	209.35	209.35	103.0
2016-06-13 05:40:00	SPY	ETF	209.44	209.44	209.44	209.44	403.0
2016-06-13 05:41:00	SPY	ETF	209.47	209.47	209.47	209.47	503.0
2016-06-13 05:42:00	SPY	ETF	209.43	209.43	209.43	209.43	101.0
2016-06-13 05:45:00	SPY	ETF	209.37	209.37	209.37	209.37	250.0
2016-06-13 05:48:00	SPY	ETF	209.37	209.37	209.32	209.32	1313.0
2016-06-13 05:49:00	SPY	ETF	209.32	209.32	209.32	209.32	100.0
2016-06-13 05:50:00	SPY	ETF	209.34	209.34	209.34	209.34	525.0
2016-06-13 05:51:00	SPY	ETF	209.34	209.34	209.34	209.34	300.0
2016-06-13 05:52:00	SPY	ETF	209.34	209.34	209.34	209.34	675.0
2016-06-13 05:53:00	SPY	ETF	209.32	209.32	209.32	209.32	450.0
2016-06-13 05:58:00	SPY	ETF	209.32	209.33	209.32	209.33	750.0
2016-06-13 06:00:00	SPY	ETF	209.34	209.37	209.34	209.37	1202.0
2016-06-13 06:01:00	SPY	ETF	209.38	209.42	209.38	209.42	1254.0
2016-06-13 06:02:00	SPY	ETF	209.43	209.44	209.43	209.44	3800.0

> showing 50 of 135,316 rows — these rows as CSV

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