PREVIEW / etf_1min / 2019-10-14

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-10-14.parquet
  size:    2.7 MB
  rows:    144,491

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-10-14 04:01:00	SPY	ETF	296.06	296.1	296.06	296.08	2558.0
2019-10-14 04:02:00	SPY	ETF	296.0	296.12	296.0	296.12	400.0
2019-10-14 04:03:00	SPY	ETF	296.04	296.04	296.03	296.03	7000.0
2019-10-14 04:04:00	SPY	ETF	296.04	296.06	295.8	295.93	4675.0
2019-10-14 04:11:00	SPY	ETF	295.99	295.99	295.99	295.99	100.0
2019-10-14 04:12:00	SPY	ETF	295.95	296.0	295.95	296.0	1600.0
2019-10-14 04:13:00	SPY	ETF	296.0	296.0	296.0	296.0	500.0
2019-10-14 04:14:00	SPY	ETF	295.9	295.9	295.9	295.9	570.0
2019-10-14 04:19:00	SPY	ETF	295.87	295.9	295.87	295.9	650.0
2019-10-14 04:20:00	SPY	ETF	295.88	295.88	295.88	295.88	500.0
2019-10-14 04:22:00	SPY	ETF	295.88	295.88	295.88	295.88	500.0
2019-10-14 04:23:00	SPY	ETF	295.91	295.91	295.85	295.85	300.0
2019-10-14 04:24:00	SPY	ETF	296.0	296.0	296.0	296.0	100.0
2019-10-14 04:25:00	SPY	ETF	296.07	296.07	296.07	296.07	100.0
2019-10-14 04:26:00	SPY	ETF	296.05	296.05	296.04	296.04	600.0
2019-10-14 04:27:00	SPY	ETF	296.06	296.06	296.06	296.06	141.0
2019-10-14 04:28:00	SPY	ETF	296.05	296.05	296.05	296.05	200.0
2019-10-14 04:30:00	SPY	ETF	296.15	296.15	296.15	296.15	200.0
2019-10-14 04:39:00	SPY	ETF	296.26	296.26	296.25	296.25	400.0
2019-10-14 04:41:00	SPY	ETF	296.35	296.35	296.35	296.35	550.0
2019-10-14 04:44:00	SPY	ETF	296.37	296.37	296.37	296.37	500.0
2019-10-14 04:46:00	SPY	ETF	296.43	296.43	296.43	296.43	400.0
2019-10-14 04:55:00	SPY	ETF	296.4	296.4	296.4	296.4	250.0
2019-10-14 04:58:00	SPY	ETF	296.45	296.45	296.4	296.4	3400.0
2019-10-14 05:00:00	SPY	ETF	296.35	296.35	296.35	296.35	2500.0
2019-10-14 05:09:00	SPY	ETF	296.35	296.35	296.35	296.35	2000.0
2019-10-14 05:17:00	SPY	ETF	296.35	296.35	296.35	296.35	820.0
2019-10-14 05:19:00	SPY	ETF	296.33	296.33	295.9	295.9	8460.0
2019-10-14 05:20:00	SPY	ETF	295.8	296.11	295.76	296.11	3050.0
2019-10-14 05:21:00	SPY	ETF	295.85	295.85	295.5	295.5	825.0
2019-10-14 05:22:00	SPY	ETF	295.45	295.45	295.34	295.41	3200.0
2019-10-14 05:23:00	SPY	ETF	295.46	295.46	295.45	295.45	650.0
2019-10-14 05:24:00	SPY	ETF	295.66	295.66	295.66	295.66	400.0
2019-10-14 05:25:00	SPY	ETF	295.53	295.53	295.53	295.53	252.0
2019-10-14 05:27:00	SPY	ETF	295.42	295.42	295.4	295.4	2161.0
2019-10-14 05:28:00	SPY	ETF	295.3	295.38	295.23	295.38	9352.0
2019-10-14 05:29:00	SPY	ETF	295.35	295.45	295.31	295.45	4800.0
2019-10-14 05:30:00	SPY	ETF	295.46	295.51	295.46	295.51	2500.0
2019-10-14 05:31:00	SPY	ETF	295.42	295.42	295.42	295.42	660.0
2019-10-14 05:32:00	SPY	ETF	295.58	295.63	295.53	295.63	2300.0
2019-10-14 05:33:00	SPY	ETF	295.58	295.58	295.58	295.58	500.0
2019-10-14 05:36:00	SPY	ETF	295.38	295.38	295.28	295.28	1000.0
2019-10-14 05:38:00	SPY	ETF	295.45	295.45	295.44	295.44	2050.0
2019-10-14 05:40:00	SPY	ETF	295.3	295.3	295.2	295.2	2200.0
2019-10-14 05:41:00	SPY	ETF	295.17	295.17	295.08	295.1	3900.0
2019-10-14 05:42:00	SPY	ETF	295.08	295.08	295.0	295.0	1940.0
2019-10-14 05:43:00	SPY	ETF	295.0	295.05	295.0	295.03	797.0
2019-10-14 05:44:00	SPY	ETF	294.86	294.86	294.85	294.85	4210.0
2019-10-14 05:45:00	SPY	ETF	294.85	294.86	294.83	294.86	25600.0
2019-10-14 05:47:00	SPY	ETF	295.01	295.05	295.01	295.04	3650.0

> showing 50 of 144,491 rows — these rows as CSV

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