PREVIEW / etf_1min / 2019-08-07

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-08-07.parquet
  size:    3.8 MB
  rows:    190,722

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-07 04:00:00	SPY	ETF	287.49	287.52	287.49	287.52	5025.0
2019-08-07 04:01:00	SPY	ETF	287.66	287.66	287.66	287.66	730.0
2019-08-07 04:03:00	SPY	ETF	287.79	287.79	287.74	287.74	1500.0
2019-08-07 04:04:00	SPY	ETF	287.75	287.75	287.69	287.69	400.0
2019-08-07 04:05:00	SPY	ETF	287.66	287.69	287.66	287.69	1316.0
2019-08-07 04:06:00	SPY	ETF	287.75	287.81	287.66	287.66	5200.0
2019-08-07 04:07:00	SPY	ETF	287.66	287.66	287.66	287.66	600.0
2019-08-07 04:09:00	SPY	ETF	287.72	287.72	287.72	287.72	200.0
2019-08-07 04:10:00	SPY	ETF	287.85	287.85	287.85	287.85	100.0
2019-08-07 04:11:00	SPY	ETF	287.8	287.8	287.8	287.8	300.0
2019-08-07 04:13:00	SPY	ETF	287.64	287.64	287.56	287.56	400.0
2019-08-07 04:16:00	SPY	ETF	287.59	287.59	287.59	287.59	769.0
2019-08-07 04:17:00	SPY	ETF	287.64	287.64	287.64	287.64	300.0
2019-08-07 04:18:00	SPY	ETF	287.64	287.64	287.64	287.64	300.0
2019-08-07 04:20:00	SPY	ETF	287.59	287.59	287.59	287.59	300.0
2019-08-07 04:21:00	SPY	ETF	287.56	287.56	287.56	287.56	300.0
2019-08-07 04:22:00	SPY	ETF	287.49	287.55	287.49	287.55	404.0
2019-08-07 04:24:00	SPY	ETF	287.5	287.5	287.46	287.46	1400.0
2019-08-07 04:26:00	SPY	ETF	287.63	287.63	287.63	287.63	300.0
2019-08-07 04:28:00	SPY	ETF	287.56	287.56	287.56	287.56	300.0
2019-08-07 04:30:00	SPY	ETF	287.65	287.65	287.65	287.65	200.0
2019-08-07 04:31:00	SPY	ETF	287.63	287.63	287.63	287.63	309.0
2019-08-07 04:34:00	SPY	ETF	287.63	287.63	287.63	287.63	300.0
2019-08-07 04:36:00	SPY	ETF	287.63	287.63	287.63	287.63	400.0
2019-08-07 04:37:00	SPY	ETF	287.71	287.8	287.71	287.8	2420.0
2019-08-07 04:39:00	SPY	ETF	287.93	288.03	287.93	288.03	1640.0
2019-08-07 04:40:00	SPY	ETF	288.07	288.22	288.07	288.22	2174.0
2019-08-07 04:42:00	SPY	ETF	288.11	288.11	288.11	288.11	300.0
2019-08-07 04:43:00	SPY	ETF	288.09	288.09	288.09	288.09	180.0
2019-08-07 04:44:00	SPY	ETF	288.06	288.06	288.06	288.06	300.0
2019-08-07 04:46:00	SPY	ETF	288.06	288.07	288.06	288.07	200.0
2019-08-07 04:49:00	SPY	ETF	288.11	288.11	288.11	288.11	500.0
2019-08-07 04:50:00	SPY	ETF	288.28	288.28	288.28	288.28	400.0
2019-08-07 04:55:00	SPY	ETF	288.08	288.08	288.08	288.08	340.0
2019-08-07 04:58:00	SPY	ETF	288.11	288.11	288.11	288.11	100.0
2019-08-07 05:01:00	SPY	ETF	288.23	288.23	288.23	288.23	170.0
2019-08-07 05:02:00	SPY	ETF	288.11	288.11	288.11	288.11	300.0
2019-08-07 05:05:00	SPY	ETF	288.06	288.06	288.06	288.06	900.0
2019-08-07 05:07:00	SPY	ETF	288.08	288.08	288.08	288.08	800.0
2019-08-07 05:13:00	SPY	ETF	287.96	287.96	287.96	287.96	510.0
2019-08-07 05:15:00	SPY	ETF	288.0	288.0	288.0	288.0	125.0
2019-08-07 05:16:00	SPY	ETF	288.02	288.02	288.02	288.02	100.0
2019-08-07 05:20:00	SPY	ETF	288.01	288.01	288.0	288.0	2300.0
2019-08-07 05:21:00	SPY	ETF	288.0	288.0	288.0	288.0	300.0
2019-08-07 05:25:00	SPY	ETF	288.01	288.01	288.01	288.01	900.0
2019-08-07 05:28:00	SPY	ETF	288.01	288.01	288.01	288.01	300.0
2019-08-07 05:29:00	SPY	ETF	288.07	288.11	288.07	288.11	4004.0
2019-08-07 05:30:00	SPY	ETF	288.2	288.2	288.18	288.18	800.0
2019-08-07 05:36:00	SPY	ETF	288.08	288.08	288.03	288.03	750.0
2019-08-07 05:38:00	SPY	ETF	288.13	288.13	288.13	288.13	300.0

> showing 50 of 190,722 rows — these rows as CSV

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