PREVIEW / etf_1min / 2018-05-29

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-05-29.parquet
  size:    3.2 MB
  rows:    165,210

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-05-29 04:00:00	SPY	ETF	270.9	270.9	270.9	270.9	2906.0
2018-05-29 04:04:00	SPY	ETF	270.81	270.81	270.71	270.71	5892.0
2018-05-29 04:05:00	SPY	ETF	270.73	270.73	270.71	270.71	2908.0
2018-05-29 04:11:00	SPY	ETF	270.71	270.71	270.71	270.71	700.0
2018-05-29 04:13:00	SPY	ETF	270.73	270.73	270.73	270.73	550.0
2018-05-29 04:16:00	SPY	ETF	270.65	270.65	270.58	270.58	1017.0
2018-05-29 04:17:00	SPY	ETF	270.56	270.56	270.53	270.53	530.0
2018-05-29 04:19:00	SPY	ETF	270.48	270.48	270.48	270.48	592.0
2018-05-29 04:22:00	SPY	ETF	270.47	270.5	270.47	270.5	200.0
2018-05-29 04:23:00	SPY	ETF	270.46	270.46	270.46	270.46	359.0
2018-05-29 04:24:00	SPY	ETF	270.36	270.36	270.32	270.32	368.0
2018-05-29 04:27:00	SPY	ETF	270.34	270.34	270.2	270.2	3020.0
2018-05-29 04:28:00	SPY	ETF	270.19	270.22	270.1	270.1	4710.0
2018-05-29 04:29:00	SPY	ETF	270.04	270.04	270.0	270.0	1354.0
2018-05-29 04:30:00	SPY	ETF	269.94	269.94	269.67	269.67	5874.0
2018-05-29 04:31:00	SPY	ETF	269.69	269.69	269.5	269.5	10060.0
2018-05-29 04:32:00	SPY	ETF	269.45	269.45	269.38	269.38	900.0
2018-05-29 04:33:00	SPY	ETF	269.45	269.48	269.33	269.34	10500.0
2018-05-29 04:34:00	SPY	ETF	269.55	269.56	269.53	269.56	1315.0
2018-05-29 04:35:00	SPY	ETF	269.5	269.5	269.48	269.48	1078.0
2018-05-29 04:36:00	SPY	ETF	269.58	269.68	269.58	269.66	1950.0
2018-05-29 04:37:00	SPY	ETF	269.66	269.66	269.63	269.63	3760.0
2018-05-29 04:38:00	SPY	ETF	269.73	269.73	269.73	269.73	2500.0
2018-05-29 04:40:00	SPY	ETF	269.67	269.67	269.67	269.67	1741.0
2018-05-29 04:41:00	SPY	ETF	269.69	269.87	269.69	269.87	2568.0
2018-05-29 04:42:00	SPY	ETF	269.92	269.92	269.92	269.92	1420.0
2018-05-29 04:43:00	SPY	ETF	269.69	269.74	269.69	269.74	400.0
2018-05-29 04:44:00	SPY	ETF	269.84	269.84	269.84	269.84	620.0
2018-05-29 04:45:00	SPY	ETF	269.92	269.99	269.92	269.99	3900.0
2018-05-29 04:46:00	SPY	ETF	270.01	270.01	270.01	270.01	2020.0
2018-05-29 04:48:00	SPY	ETF	269.97	269.97	269.97	269.97	100.0
2018-05-29 04:52:00	SPY	ETF	270.02	270.02	269.99	269.99	820.0
2018-05-29 04:53:00	SPY	ETF	270.0	270.0	269.93	269.93	1100.0
2018-05-29 04:54:00	SPY	ETF	269.84	269.84	269.84	269.84	1010.0
2018-05-29 04:55:00	SPY	ETF	269.81	269.81	269.81	269.81	500.0
2018-05-29 04:56:00	SPY	ETF	270.0	270.0	270.0	270.0	500.0
2018-05-29 04:59:00	SPY	ETF	269.94	269.96	269.9	269.92	20000.0
2018-05-29 05:00:00	SPY	ETF	269.92	269.93	269.9	269.91	13700.0
2018-05-29 05:01:00	SPY	ETF	269.78	269.89	269.74	269.8	16420.0
2018-05-29 05:04:00	SPY	ETF	269.91	269.94	269.91	269.94	1200.0
2018-05-29 05:06:00	SPY	ETF	269.96	269.96	269.94	269.94	1720.0
2018-05-29 05:09:00	SPY	ETF	270.11	270.11	270.11	270.11	1000.0
2018-05-29 05:10:00	SPY	ETF	270.11	270.11	270.11	270.11	820.0
2018-05-29 05:11:00	SPY	ETF	270.08	270.09	270.08	270.09	1200.0
2018-05-29 05:12:00	SPY	ETF	270.12	270.12	270.11	270.11	300.0
2018-05-29 05:13:00	SPY	ETF	270.1	270.1	270.06	270.06	600.0
2018-05-29 05:14:00	SPY	ETF	270.11	270.11	270.09	270.1	2650.0
2018-05-29 05:15:00	SPY	ETF	270.09	270.09	270.09	270.09	378.0
2018-05-29 05:16:00	SPY	ETF	270.05	270.07	270.05	270.07	800.0
2018-05-29 05:17:00	SPY	ETF	270.11	270.11	270.06	270.06	200.0

> showing 50 of 165,210 rows — these rows as CSV

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