PREVIEW / etf_1min / 2017-06-30

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-06-30.parquet
  size:    2.6 MB
  rows:    139,507

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-06-30 04:00:00	SPY	ETF	241.72	241.72	241.72	241.72	1010.0
2017-06-30 04:30:00	SPY	ETF	241.6	241.6	241.6	241.6	100.0
2017-06-30 04:39:00	SPY	ETF	241.5	241.52	241.5	241.5	700.0
2017-06-30 04:46:00	SPY	ETF	241.64	241.64	241.64	241.64	400.0
2017-06-30 04:50:00	SPY	ETF	241.65	241.68	241.65	241.68	300.0
2017-06-30 04:58:00	SPY	ETF	241.79	241.79	241.79	241.79	100.0
2017-06-30 05:03:00	SPY	ETF	241.79	241.79	241.79	241.79	300.0
2017-06-30 05:10:00	SPY	ETF	241.79	241.8	241.79	241.8	14302.0
2017-06-30 05:19:00	SPY	ETF	241.9	241.9	241.9	241.9	10510.0
2017-06-30 05:21:00	SPY	ETF	241.95	241.95	241.95	241.95	3000.0
2017-06-30 05:25:00	SPY	ETF	241.9	241.9	241.9	241.9	3000.0
2017-06-30 05:27:00	SPY	ETF	241.95	241.95	241.95	241.95	4800.0
2017-06-30 05:29:00	SPY	ETF	241.94	241.94	241.94	241.94	100.0
2017-06-30 05:31:00	SPY	ETF	241.97	241.98	241.97	241.98	6000.0
2017-06-30 05:32:00	SPY	ETF	241.98	241.98	241.98	241.98	100.0
2017-06-30 05:36:00	SPY	ETF	241.98	242.0	241.98	242.0	4111.0
2017-06-30 05:39:00	SPY	ETF	242.04	242.04	242.04	242.04	120.0
2017-06-30 05:41:00	SPY	ETF	242.1	242.1	242.1	242.1	800.0
2017-06-30 05:42:00	SPY	ETF	242.07	242.1	242.07	242.1	3000.0
2017-06-30 05:43:00	SPY	ETF	242.1	242.1	242.1	242.1	700.0
2017-06-30 05:48:00	SPY	ETF	242.05	242.05	242.05	242.05	300.0
2017-06-30 05:51:00	SPY	ETF	242.05	242.05	242.05	242.05	3800.0
2017-06-30 05:55:00	SPY	ETF	242.1	242.1	242.1	242.1	500.0
2017-06-30 05:57:00	SPY	ETF	242.1	242.1	242.1	242.1	3535.0
2017-06-30 06:03:00	SPY	ETF	242.14	242.15	242.14	242.15	1961.0
2017-06-30 06:04:00	SPY	ETF	242.22	242.25	242.22	242.25	2771.0
2017-06-30 06:05:00	SPY	ETF	242.26	242.26	242.26	242.26	400.0
2017-06-30 06:06:00	SPY	ETF	242.27	242.27	242.27	242.27	200.0
2017-06-30 06:08:00	SPY	ETF	242.3	242.31	242.3	242.31	320.0
2017-06-30 06:09:00	SPY	ETF	242.32	242.32	242.32	242.32	7403.0
2017-06-30 06:10:00	SPY	ETF	242.36	242.42	242.31	242.31	20821.0
2017-06-30 06:13:00	SPY	ETF	242.35	242.35	242.35	242.35	1000.0
2017-06-30 06:15:00	SPY	ETF	242.34	242.36	242.34	242.36	200.0
2017-06-30 06:19:00	SPY	ETF	242.27	242.27	242.27	242.27	2288.0
2017-06-30 06:23:00	SPY	ETF	242.28	242.29	242.27	242.27	3500.0
2017-06-30 06:24:00	SPY	ETF	242.29	242.29	242.29	242.29	1500.0
2017-06-30 06:32:00	SPY	ETF	242.32	242.33	242.3	242.33	800.0
2017-06-30 06:37:00	SPY	ETF	242.3	242.3	242.27	242.27	800.0
2017-06-30 06:39:00	SPY	ETF	242.27	242.27	242.27	242.27	1100.0
2017-06-30 06:41:00	SPY	ETF	242.33	242.33	242.3	242.3	2200.0
2017-06-30 06:46:00	SPY	ETF	242.31	242.31	242.31	242.31	1200.0
2017-06-30 06:50:00	SPY	ETF	242.31	242.31	242.31	242.31	350.0
2017-06-30 06:51:00	SPY	ETF	242.3	242.3	242.25	242.3	900.0
2017-06-30 06:55:00	SPY	ETF	242.28	242.28	242.28	242.28	200.0
2017-06-30 06:56:00	SPY	ETF	242.28	242.28	242.28	242.28	484.0
2017-06-30 06:57:00	SPY	ETF	242.28	242.28	242.28	242.28	1768.0
2017-06-30 06:59:00	SPY	ETF	242.3	242.3	242.3	242.3	2826.0
2017-06-30 07:00:00	SPY	ETF	242.28	242.3	242.27	242.3	13802.0
2017-06-30 07:01:00	SPY	ETF	242.3	242.34	242.3	242.34	1291.0
2017-06-30 07:02:00	SPY	ETF	242.3	242.31	242.3	242.3	16302.0

> showing 50 of 139,507 rows — these rows as CSV

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