PREVIEW / etf_1min / 2019-08-09

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-08-09.parquet
  size:    3.1 MB
  rows:    166,299

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-09 04:00:00	SPY	ETF	292.38	292.38	292.38	292.38	212.0
2019-08-09 04:02:00	SPY	ETF	292.32	292.32	292.32	292.32	500.0
2019-08-09 04:04:00	SPY	ETF	292.28	292.28	292.28	292.28	300.0
2019-08-09 04:05:00	SPY	ETF	292.24	292.24	292.2	292.2	822.0
2019-08-09 04:06:00	SPY	ETF	292.17	292.17	292.17	292.17	300.0
2019-08-09 04:07:00	SPY	ETF	292.2	292.2	292.2	292.2	534.0
2019-08-09 04:10:00	SPY	ETF	292.34	292.34	292.34	292.34	130.0
2019-08-09 04:11:00	SPY	ETF	292.26	292.26	292.25	292.25	293.0
2019-08-09 04:14:00	SPY	ETF	292.25	292.25	292.2	292.2	1018.0
2019-08-09 04:16:00	SPY	ETF	292.1	292.1	292.1	292.1	305.0
2019-08-09 04:19:00	SPY	ETF	292.1	292.1	292.1	292.1	100.0
2019-08-09 04:20:00	SPY	ETF	292.01	292.01	292.01	292.01	283.0
2019-08-09 04:22:00	SPY	ETF	292.05	292.05	292.05	292.05	200.0
2019-08-09 04:27:00	SPY	ETF	292.13	292.13	292.13	292.13	100.0
2019-08-09 04:28:00	SPY	ETF	292.2	292.2	292.2	292.2	520.0
2019-08-09 04:30:00	SPY	ETF	292.3	292.3	292.3	292.3	400.0
2019-08-09 04:36:00	SPY	ETF	292.15	292.15	292.15	292.15	200.0
2019-08-09 04:45:00	SPY	ETF	292.05	292.05	292.05	292.05	100.0
2019-08-09 04:47:00	SPY	ETF	292.1	292.1	292.1	292.1	1040.0
2019-08-09 04:48:00	SPY	ETF	292.15	292.15	292.15	292.15	130.0
2019-08-09 04:55:00	SPY	ETF	292.29	292.29	292.29	292.29	100.0
2019-08-09 05:16:00	SPY	ETF	292.43	292.43	292.43	292.43	750.0
2019-08-09 05:17:00	SPY	ETF	292.45	292.45	292.45	292.45	326.0
2019-08-09 05:18:00	SPY	ETF	292.65	292.65	292.65	292.65	833.0
2019-08-09 05:19:00	SPY	ETF	292.65	292.65	292.65	292.65	400.0
2019-08-09 05:20:00	SPY	ETF	292.68	292.68	292.68	292.68	1350.0
2019-08-09 05:31:00	SPY	ETF	292.35	292.35	292.35	292.35	100.0
2019-08-09 05:32:00	SPY	ETF	292.3	292.3	292.26	292.26	26004.0
2019-08-09 05:33:00	SPY	ETF	292.25	292.25	292.25	292.25	100.0
2019-08-09 05:37:00	SPY	ETF	292.14	292.14	292.14	292.14	550.0
2019-08-09 05:38:00	SPY	ETF	292.14	292.14	292.14	292.14	100.0
2019-08-09 05:39:00	SPY	ETF	292.14	292.14	292.14	292.14	300.0
2019-08-09 05:40:00	SPY	ETF	292.14	292.14	292.14	292.14	1000.0
2019-08-09 05:41:00	SPY	ETF	292.17	292.17	292.17	292.17	105.0
2019-08-09 05:42:00	SPY	ETF	292.29	292.29	292.29	292.29	100.0
2019-08-09 05:44:00	SPY	ETF	292.23	292.23	292.23	292.23	210.0
2019-08-09 05:45:00	SPY	ETF	292.17	292.17	292.17	292.17	445.0
2019-08-09 05:48:00	SPY	ETF	292.14	292.14	292.06	292.1	2033.0
2019-08-09 05:49:00	SPY	ETF	292.15	292.15	292.08	292.08	832.0
2019-08-09 05:50:00	SPY	ETF	292.16	292.16	292.16	292.16	100.0
2019-08-09 05:52:00	SPY	ETF	292.11	292.11	292.11	292.11	437.0
2019-08-09 05:53:00	SPY	ETF	292.0	292.01	292.0	292.01	501.0
2019-08-09 05:54:00	SPY	ETF	292.04	292.04	292.04	292.04	250.0
2019-08-09 05:55:00	SPY	ETF	292.04	292.04	292.04	292.04	410.0
2019-08-09 05:58:00	SPY	ETF	292.06	292.06	292.06	292.06	100.0
2019-08-09 06:00:00	SPY	ETF	292.09	292.09	292.09	292.09	101.0
2019-08-09 06:07:00	SPY	ETF	292.16	292.23	292.16	292.23	300.0
2019-08-09 06:11:00	SPY	ETF	292.2	292.2	292.2	292.2	350.0
2019-08-09 06:14:00	SPY	ETF	292.21	292.24	292.21	292.24	3000.0
2019-08-09 06:15:00	SPY	ETF	292.24	292.24	292.22	292.22	2115.0

> showing 50 of 166,299 rows — these rows as CSV

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