PREVIEW / etf_1min / 2019-08-28

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-08-28.parquet
  size:    3.2 MB
  rows:    162,628

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
2019-08-28 04:00:00	SPY	ETF	287.02	287.02	287.02	287.02	119.0
2019-08-28 04:01:00	SPY	ETF	286.95	286.95	286.95	286.95	214.0
2019-08-28 04:02:00	SPY	ETF	286.9	286.9	286.9	286.9	1000.0
2019-08-28 04:05:00	SPY	ETF	287.09	287.37	287.09	287.3	1308.0
2019-08-28 04:07:00	SPY	ETF	287.4	287.62	287.4	287.62	2109.0
2019-08-28 04:13:00	SPY	ETF	287.49	287.49	287.49	287.49	169.0
2019-08-28 04:14:00	SPY	ETF	287.45	287.45	287.45	287.45	100.0
2019-08-28 04:20:00	SPY	ETF	287.52	287.52	287.52	287.52	100.0
2019-08-28 04:27:00	SPY	ETF	287.55	287.55	287.55	287.55	800.0
2019-08-28 04:28:00	SPY	ETF	287.5	287.5	287.5	287.5	200.0
2019-08-28 04:30:00	SPY	ETF	287.67	287.67	287.67	287.67	200.0
2019-08-28 04:31:00	SPY	ETF	287.56	287.56	287.56	287.56	800.0
2019-08-28 04:35:00	SPY	ETF	287.54	287.54	287.54	287.54	500.0
2019-08-28 04:36:00	SPY	ETF	287.42	287.42	287.35	287.35	1400.0
2019-08-28 04:39:00	SPY	ETF	287.16	287.16	286.66	286.66	780.0
2019-08-28 04:40:00	SPY	ETF	286.5	286.73	286.5	286.73	910.0
2019-08-28 04:41:00	SPY	ETF	286.73	286.73	286.73	286.73	722.0
2019-08-28 04:43:00	SPY	ETF	286.5	286.5	286.5	286.5	310.0
2019-08-28 04:46:00	SPY	ETF	286.71	286.71	286.71	286.71	104.0
2019-08-28 04:48:00	SPY	ETF	286.72	286.72	286.72	286.72	100.0
2019-08-28 04:51:00	SPY	ETF	286.78	287.05	286.78	287.05	806.0
2019-08-28 04:52:00	SPY	ETF	286.92	286.92	286.9	286.9	1602.0
2019-08-28 04:54:00	SPY	ETF	286.95	287.0	286.95	287.0	700.0
2019-08-28 04:57:00	SPY	ETF	287.07	287.07	287.07	287.07	701.0
2019-08-28 04:58:00	SPY	ETF	287.02	287.02	287.02	287.02	200.0
2019-08-28 05:05:00	SPY	ETF	287.12	287.12	287.12	287.12	100.0
2019-08-28 05:08:00	SPY	ETF	287.17	287.17	287.17	287.17	100.0
2019-08-28 05:09:00	SPY	ETF	287.27	287.27	287.27	287.27	100.0
2019-08-28 05:10:00	SPY	ETF	287.25	287.32	287.25	287.32	204.0
2019-08-28 05:13:00	SPY	ETF	287.22	287.22	287.22	287.22	100.0
2019-08-28 05:14:00	SPY	ETF	287.16	287.16	287.16	287.16	500.0
2019-08-28 05:18:00	SPY	ETF	287.25	287.25	287.25	287.25	200.0
2019-08-28 05:19:00	SPY	ETF	287.27	287.27	287.27	287.27	500.0
2019-08-28 05:20:00	SPY	ETF	287.4	287.4	287.4	287.4	300.0
2019-08-28 05:21:00	SPY	ETF	287.4	287.4	287.4	287.4	170.0
2019-08-28 05:25:00	SPY	ETF	287.19	287.19	287.19	287.19	119.0
2019-08-28 05:34:00	SPY	ETF	287.05	287.05	287.05	287.05	134.0
2019-08-28 05:35:00	SPY	ETF	287.02	287.02	287.02	287.02	100.0
2019-08-28 05:37:00	SPY	ETF	286.96	286.96	286.96	286.96	400.0
2019-08-28 05:42:00	SPY	ETF	286.92	286.92	286.92	286.92	404.0
2019-08-28 05:43:00	SPY	ETF	286.95	286.95	286.95	286.95	100.0
2019-08-28 05:46:00	SPY	ETF	287.07	287.07	287.04	287.04	1500.0
2019-08-28 05:48:00	SPY	ETF	286.92	286.92	286.92	286.92	400.0
2019-08-28 05:55:00	SPY	ETF	286.99	286.99	286.99	286.99	400.0
2019-08-28 05:57:00	SPY	ETF	286.9	286.9	286.9	286.9	300.0
2019-08-28 06:00:00	SPY	ETF	287.12	287.33	287.12	287.33	2904.0
2019-08-28 06:01:00	SPY	ETF	287.32	287.36	287.32	287.36	1100.0
2019-08-28 06:02:00	SPY	ETF	287.37	287.47	287.37	287.47	1100.0
2019-08-28 06:05:00	SPY	ETF	287.3	287.32	287.3	287.32	600.0
2019-08-28 06:07:00	SPY	ETF	287.29	287.29	287.29	287.29	300.0

> showing 50 of 162,628 rows — these rows as CSV

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