PREVIEW / etf_1min / 2018-11-21

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-11-21.parquet
  size:    3.2 MB
  rows:    169,014

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-11-21 04:00:00	SPY	ETF	265.53	265.53	265.53	265.53	610.0
2018-11-21 04:01:00	SPY	ETF	265.72	265.72	265.72	265.72	250.0
2018-11-21 04:02:00	SPY	ETF	265.67	265.76	265.67	265.68	1200.0
2018-11-21 04:03:00	SPY	ETF	265.7	265.72	265.68	265.68	2936.0
2018-11-21 04:04:00	SPY	ETF	265.68	265.74	265.68	265.74	464.0
2018-11-21 04:05:00	SPY	ETF	265.68	265.73	265.68	265.73	3369.0
2018-11-21 04:08:00	SPY	ETF	265.72	265.73	265.72	265.73	525.0
2018-11-21 04:09:00	SPY	ETF	265.68	265.68	265.68	265.68	200.0
2018-11-21 04:10:00	SPY	ETF	265.72	265.74	265.63	265.63	779.0
2018-11-21 04:12:00	SPY	ETF	265.67	265.67	265.67	265.67	200.0
2018-11-21 04:13:00	SPY	ETF	265.72	265.77	265.72	265.77	745.0
2018-11-21 04:15:00	SPY	ETF	265.8	265.8	265.67	265.67	623.0
2018-11-21 04:16:00	SPY	ETF	265.63	265.7	265.59	265.7	5369.0
2018-11-21 04:18:00	SPY	ETF	265.64	265.64	265.6	265.6	338.0
2018-11-21 04:19:00	SPY	ETF	265.54	265.54	265.54	265.54	169.0
2018-11-21 04:21:00	SPY	ETF	265.64	265.64	265.64	265.64	169.0
2018-11-21 04:22:00	SPY	ETF	265.58	265.58	265.54	265.54	752.0
2018-11-21 04:23:00	SPY	ETF	265.5	265.5	265.5	265.5	100.0
2018-11-21 04:24:00	SPY	ETF	265.46	265.56	265.46	265.56	407.0
2018-11-21 04:25:00	SPY	ETF	265.56	265.56	265.46	265.46	462.0
2018-11-21 04:26:00	SPY	ETF	265.52	265.56	265.52	265.56	338.0
2018-11-21 04:29:00	SPY	ETF	265.6	265.6	265.6	265.6	300.0
2018-11-21 04:30:00	SPY	ETF	265.55	265.55	265.46	265.46	838.0
2018-11-21 04:33:00	SPY	ETF	265.44	265.44	265.4	265.4	507.0
2018-11-21 04:34:00	SPY	ETF	265.34	265.37	265.34	265.37	800.0
2018-11-21 04:35:00	SPY	ETF	265.34	265.34	265.34	265.34	300.0
2018-11-21 04:41:00	SPY	ETF	265.4	265.4	265.4	265.4	144.0
2018-11-21 04:42:00	SPY	ETF	265.33	265.36	265.33	265.36	612.0
2018-11-21 04:43:00	SPY	ETF	265.32	265.32	265.21	265.21	707.0
2018-11-21 04:44:00	SPY	ETF	265.22	265.22	265.22	265.22	369.0
2018-11-21 04:46:00	SPY	ETF	265.26	265.26	265.22	265.22	338.0
2018-11-21 04:48:00	SPY	ETF	265.28	265.28	265.28	265.28	407.0
2018-11-21 04:49:00	SPY	ETF	265.3	265.34	265.3	265.34	2100.0
2018-11-21 04:50:00	SPY	ETF	265.24	265.28	265.24	265.28	369.0
2018-11-21 04:51:00	SPY	ETF	265.3	265.34	265.3	265.34	538.0
2018-11-21 04:52:00	SPY	ETF	265.42	265.52	265.42	265.52	707.0
2018-11-21 04:53:00	SPY	ETF	265.49	265.49	265.49	265.49	600.0
2018-11-21 04:56:00	SPY	ETF	265.48	265.48	265.48	265.48	500.0
2018-11-21 04:57:00	SPY	ETF	265.54	265.59	265.54	265.59	1449.0
2018-11-21 04:59:00	SPY	ETF	265.48	265.48	265.41	265.41	1430.0
2018-11-21 05:00:00	SPY	ETF	265.31	265.31	265.26	265.26	6771.0
2018-11-21 05:01:00	SPY	ETF	265.31	265.39	265.31	265.39	6800.0
2018-11-21 05:02:00	SPY	ETF	265.41	265.41	265.41	265.41	7000.0
2018-11-21 05:03:00	SPY	ETF	265.41	265.84	265.41	265.84	16412.0
2018-11-21 05:04:00	SPY	ETF	265.8	265.88	265.8	265.87	1619.0
2018-11-21 05:05:00	SPY	ETF	265.85	265.89	265.51	265.55	15340.0
2018-11-21 05:06:00	SPY	ETF	265.61	265.69	265.45	265.48	19100.0
2018-11-21 05:07:00	SPY	ETF	265.42	265.46	265.42	265.46	9040.0
2018-11-21 05:08:00	SPY	ETF	265.49	265.54	265.49	265.54	8500.0
2018-11-21 05:09:00	SPY	ETF	265.59	265.59	265.59	265.59	1000.0

> showing 50 of 169,014 rows — these rows as CSV

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