PREVIEW / etf_1min / 2018-06-28

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-06-28.parquet
  size:    3.0 MB
  rows:    158,474

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
2018-06-28 04:00:00	SPY	ETF	270.3	270.51	270.28	270.51	1410.0
2018-06-28 04:01:00	SPY	ETF	270.53	270.55	270.53	270.55	345.0
2018-06-28 04:02:00	SPY	ETF	270.54	270.54	270.54	270.54	194.0
2018-06-28 04:03:00	SPY	ETF	270.55	270.58	270.55	270.58	365.0
2018-06-28 04:05:00	SPY	ETF	270.64	270.68	270.64	270.68	2110.0
2018-06-28 04:08:00	SPY	ETF	270.59	270.75	270.59	270.75	5300.0
2018-06-28 04:09:00	SPY	ETF	270.82	270.82	270.82	270.82	144.0
2018-06-28 04:11:00	SPY	ETF	270.73	270.73	270.73	270.73	200.0
2018-06-28 04:15:00	SPY	ETF	270.71	270.74	270.71	270.74	334.0
2018-06-28 04:17:00	SPY	ETF	270.63	270.63	270.63	270.63	8600.0
2018-06-28 04:23:00	SPY	ETF	270.67	270.67	270.66	270.66	300.0
2018-06-28 04:25:00	SPY	ETF	270.5	270.54	270.5	270.54	2200.0
2018-06-28 04:28:00	SPY	ETF	270.54	270.54	270.54	270.54	300.0
2018-06-28 04:32:00	SPY	ETF	270.51	270.51	270.51	270.51	350.0
2018-06-28 04:33:00	SPY	ETF	270.4	270.4	270.4	270.4	1000.0
2018-06-28 04:34:00	SPY	ETF	270.32	270.32	270.32	270.32	500.0
2018-06-28 04:35:00	SPY	ETF	270.29	270.29	270.29	270.29	500.0
2018-06-28 04:36:00	SPY	ETF	270.26	270.26	270.26	270.26	1410.0
2018-06-28 04:38:00	SPY	ETF	270.19	270.19	270.11	270.16	300.0
2018-06-28 04:39:00	SPY	ETF	270.12	270.12	270.11	270.11	2000.0
2018-06-28 04:41:00	SPY	ETF	270.01	270.01	270.0	270.0	610.0
2018-06-28 04:42:00	SPY	ETF	270.06	270.09	270.06	270.09	500.0
2018-06-28 04:45:00	SPY	ETF	270.01	270.01	270.01	270.01	300.0
2018-06-28 04:46:00	SPY	ETF	269.95	269.95	269.94	269.94	400.0
2018-06-28 04:47:00	SPY	ETF	269.97	270.01	269.97	270.01	300.0
2018-06-28 04:50:00	SPY	ETF	270.12	270.12	270.1	270.1	400.0
2018-06-28 04:52:00	SPY	ETF	270.09	270.14	270.05	270.14	16300.0
2018-06-28 04:53:00	SPY	ETF	270.14	270.14	270.14	270.14	1700.0
2018-06-28 04:55:00	SPY	ETF	270.19	270.22	270.19	270.22	2500.0
2018-06-28 04:57:00	SPY	ETF	270.16	270.16	270.16	270.16	100.0
2018-06-28 05:02:00	SPY	ETF	270.19	270.19	270.19	270.19	2800.0
2018-06-28 05:03:00	SPY	ETF	270.19	270.19	270.19	270.19	200.0
2018-06-28 05:04:00	SPY	ETF	270.06	270.06	270.05	270.05	4555.0
2018-06-28 05:05:00	SPY	ETF	270.05	270.05	270.05	270.05	500.0
2018-06-28 05:10:00	SPY	ETF	270.12	270.12	270.12	270.12	500.0
2018-06-28 05:11:00	SPY	ETF	270.13	270.13	270.06	270.06	700.0
2018-06-28 05:12:00	SPY	ETF	270.14	270.14	270.14	270.14	300.0
2018-06-28 05:13:00	SPY	ETF	270.04	270.05	270.04	270.05	1400.0
2018-06-28 05:14:00	SPY	ETF	270.05	270.05	270.05	270.05	100.0
2018-06-28 05:16:00	SPY	ETF	270.08	270.08	270.08	270.08	100.0
2018-06-28 05:18:00	SPY	ETF	270.02	270.04	270.02	270.04	600.0
2018-06-28 05:20:00	SPY	ETF	270.02	270.02	270.02	270.02	100.0
2018-06-28 05:23:00	SPY	ETF	270.14	270.14	270.14	270.14	200.0
2018-06-28 05:29:00	SPY	ETF	270.09	270.09	270.09	270.09	100.0
2018-06-28 05:32:00	SPY	ETF	269.99	269.99	269.83	269.89	1800.0
2018-06-28 05:33:00	SPY	ETF	269.87	269.87	269.82	269.82	360.0
2018-06-28 05:34:00	SPY	ETF	269.81	269.82	269.72	269.72	600.0
2018-06-28 05:36:00	SPY	ETF	269.69	269.69	269.69	269.69	100.0
2018-06-28 05:37:00	SPY	ETF	269.64	269.64	269.64	269.64	100.0
2018-06-28 05:40:00	SPY	ETF	269.61	269.61	269.61	269.61	225.0

> showing 50 of 158,474 rows — these rows as CSV

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