PREVIEW / etf_1min / 2018-11-23

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-11-23.parquet
  size:    1.7 MB
  rows:    87,680

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-23 04:00:00	SPY	ETF	264.39	264.39	264.3	264.3	2646.0
2018-11-23 04:02:00	SPY	ETF	264.41	264.41	264.41	264.41	327.0
2018-11-23 04:05:00	SPY	ETF	264.48	264.48	264.48	264.48	496.0
2018-11-23 04:07:00	SPY	ETF	264.44	264.44	264.44	264.44	360.0
2018-11-23 04:10:00	SPY	ETF	264.33	264.33	264.33	264.33	400.0
2018-11-23 04:13:00	SPY	ETF	264.28	264.28	264.28	264.28	1000.0
2018-11-23 04:15:00	SPY	ETF	264.44	264.44	264.44	264.44	300.0
2018-11-23 04:18:00	SPY	ETF	264.3	264.3	264.3	264.3	150.0
2018-11-23 04:20:00	SPY	ETF	264.31	264.31	264.31	264.31	400.0
2018-11-23 04:22:00	SPY	ETF	264.32	264.32	264.32	264.32	1000.0
2018-11-23 04:23:00	SPY	ETF	264.34	264.34	264.34	264.34	100.0
2018-11-23 04:24:00	SPY	ETF	264.41	264.48	264.41	264.48	350.0
2018-11-23 04:26:00	SPY	ETF	264.48	264.48	264.48	264.48	100.0
2018-11-23 04:29:00	SPY	ETF	264.51	264.51	264.51	264.51	169.0
2018-11-23 04:30:00	SPY	ETF	264.51	264.51	264.51	264.51	100.0
2018-11-23 04:31:00	SPY	ETF	264.5	264.5	264.5	264.5	1300.0
2018-11-23 04:32:00	SPY	ETF	264.49	264.49	264.49	264.49	150.0
2018-11-23 04:34:00	SPY	ETF	264.42	264.42	264.4	264.4	2549.0
2018-11-23 04:43:00	SPY	ETF	264.42	264.42	264.38	264.38	330.0
2018-11-23 04:46:00	SPY	ETF	264.48	264.52	264.48	264.52	507.0
2018-11-23 04:50:00	SPY	ETF	264.54	264.54	264.54	264.54	169.0
2018-11-23 04:52:00	SPY	ETF	264.56	264.56	264.56	264.56	400.0
2018-11-23 05:00:00	SPY	ETF	264.58	264.6	264.58	264.6	579.0
2018-11-23 05:01:00	SPY	ETF	264.54	264.54	264.54	264.54	169.0
2018-11-23 05:02:00	SPY	ETF	264.5	264.5	264.5	264.5	169.0
2018-11-23 05:03:00	SPY	ETF	264.5	264.5	264.45	264.45	230.0
2018-11-23 05:07:00	SPY	ETF	264.44	264.44	264.44	264.44	169.0
2018-11-23 05:08:00	SPY	ETF	264.41	264.64	264.41	264.44	8311.0
2018-11-23 05:14:00	SPY	ETF	264.4	264.4	264.4	264.4	100.0
2018-11-23 05:17:00	SPY	ETF	264.35	264.35	264.3	264.3	338.0
2018-11-23 05:28:00	SPY	ETF	264.3	264.3	264.3	264.3	144.0
2018-11-23 05:29:00	SPY	ETF	264.25	264.25	264.2	264.2	269.0
2018-11-23 05:34:00	SPY	ETF	264.2	264.2	264.2	264.2	338.0
2018-11-23 05:35:00	SPY	ETF	264.1	264.1	264.1	264.1	520.0
2018-11-23 05:38:00	SPY	ETF	264.0	264.0	263.95	263.95	375.0
2018-11-23 05:39:00	SPY	ETF	263.92	263.92	263.92	263.92	100.0
2018-11-23 05:40:00	SPY	ETF	263.95	264.19	263.95	264.03	1069.0
2018-11-23 05:41:00	SPY	ETF	264.01	264.01	264.01	264.01	100.0
2018-11-23 05:43:00	SPY	ETF	264.02	264.02	264.02	264.02	100.0
2018-11-23 05:44:00	SPY	ETF	263.94	263.94	263.94	263.94	169.0
2018-11-23 05:46:00	SPY	ETF	263.89	263.89	263.85	263.85	300.0
2018-11-23 05:48:00	SPY	ETF	263.88	263.88	263.88	263.88	100.0
2018-11-23 05:49:00	SPY	ETF	263.86	263.86	263.79	263.79	5505.0
2018-11-23 05:50:00	SPY	ETF	263.81	263.81	263.81	263.81	100.0
2018-11-23 05:51:00	SPY	ETF	263.75	263.75	263.65	263.65	220.0
2018-11-23 05:52:00	SPY	ETF	263.78	263.79	263.78	263.79	500.0
2018-11-23 05:53:00	SPY	ETF	263.74	263.74	263.74	263.74	100.0
2018-11-23 05:54:00	SPY	ETF	263.74	263.74	263.74	263.74	100.0
2018-11-23 05:55:00	SPY	ETF	263.78	263.81	263.78	263.81	338.0
2018-11-23 05:56:00	SPY	ETF	263.78	263.78	263.78	263.78	165.0

> showing 50 of 87,680 rows — these rows as CSV

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