PREVIEW / etf_1min / 2019-10-04

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-10-04.parquet
  size:    3.1 MB
  rows:    158,700

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-04 04:00:00	SPY	ETF	290.25	290.25	290.25	290.25	200.0
2019-10-04 04:02:00	SPY	ETF	290.06	290.06	290.06	290.06	1090.0
2019-10-04 04:03:00	SPY	ETF	290.03	290.03	290.03	290.03	350.0
2019-10-04 04:04:00	SPY	ETF	290.11	290.14	290.11	290.14	581.0
2019-10-04 04:05:00	SPY	ETF	290.17	290.3	290.17	290.25	3450.0
2019-10-04 04:06:00	SPY	ETF	290.15	290.15	290.15	290.15	400.0
2019-10-04 04:08:00	SPY	ETF	290.13	290.13	290.13	290.13	800.0
2019-10-04 04:09:00	SPY	ETF	290.25	290.25	290.23	290.23	1300.0
2019-10-04 04:12:00	SPY	ETF	290.15	290.15	290.15	290.15	300.0
2019-10-04 04:15:00	SPY	ETF	290.03	290.03	290.03	290.03	300.0
2019-10-04 04:19:00	SPY	ETF	290.17	290.17	290.17	290.17	100.0
2019-10-04 04:21:00	SPY	ETF	290.22	290.29	290.22	290.29	1400.0
2019-10-04 04:22:00	SPY	ETF	290.32	290.33	290.27	290.28	3300.0
2019-10-04 04:23:00	SPY	ETF	290.2	290.2	290.2	290.2	1000.0
2019-10-04 04:25:00	SPY	ETF	290.23	290.23	290.23	290.23	500.0
2019-10-04 04:27:00	SPY	ETF	290.11	290.11	290.1	290.1	3000.0
2019-10-04 04:28:00	SPY	ETF	290.0	290.0	290.0	290.0	330.0
2019-10-04 04:29:00	SPY	ETF	290.02	290.02	290.0	290.0	2000.0
2019-10-04 04:30:00	SPY	ETF	290.0	290.03	290.0	290.03	1200.0
2019-10-04 04:34:00	SPY	ETF	290.01	290.01	290.01	290.01	500.0
2019-10-04 04:37:00	SPY	ETF	290.03	290.05	290.03	290.05	500.0
2019-10-04 04:40:00	SPY	ETF	289.98	289.99	289.97	289.99	4400.0
2019-10-04 04:41:00	SPY	ETF	289.91	289.91	289.89	289.91	400.0
2019-10-04 04:45:00	SPY	ETF	289.9	289.9	289.9	289.9	250.0
2019-10-04 04:47:00	SPY	ETF	289.83	289.83	289.83	289.83	100.0
2019-10-04 04:50:00	SPY	ETF	289.88	289.88	289.88	289.88	100.0
2019-10-04 04:51:00	SPY	ETF	289.85	289.85	289.85	289.85	215.0
2019-10-04 04:54:00	SPY	ETF	289.78	289.78	289.78	289.78	100.0
2019-10-04 04:57:00	SPY	ETF	289.75	289.75	289.75	289.75	165.0
2019-10-04 04:59:00	SPY	ETF	289.81	289.84	289.81	289.82	3700.0
2019-10-04 05:01:00	SPY	ETF	289.8	289.8	289.8	289.8	102.0
2019-10-04 05:04:00	SPY	ETF	289.71	289.71	289.71	289.71	100.0
2019-10-04 05:05:00	SPY	ETF	289.73	289.73	289.73	289.73	100.0
2019-10-04 05:06:00	SPY	ETF	289.73	289.73	289.73	289.73	350.0
2019-10-04 05:09:00	SPY	ETF	289.77	289.78	289.77	289.78	1270.0
2019-10-04 05:13:00	SPY	ETF	289.78	289.78	289.78	289.78	400.0
2019-10-04 05:14:00	SPY	ETF	289.77	289.77	289.77	289.77	300.0
2019-10-04 05:23:00	SPY	ETF	289.88	289.88	289.86	289.86	300.0
2019-10-04 05:29:00	SPY	ETF	289.76	289.76	289.74	289.74	400.0
2019-10-04 05:33:00	SPY	ETF	289.59	289.59	289.59	289.59	102.0
2019-10-04 05:36:00	SPY	ETF	289.48	289.48	289.46	289.46	705.0
2019-10-04 05:37:00	SPY	ETF	289.45	289.45	289.45	289.45	821.0
2019-10-04 05:38:00	SPY	ETF	289.43	289.43	289.39	289.39	551.0
2019-10-04 05:40:00	SPY	ETF	289.39	289.39	289.36	289.36	2241.0
2019-10-04 05:41:00	SPY	ETF	289.37	289.37	289.37	289.37	325.0
2019-10-04 05:43:00	SPY	ETF	289.47	289.47	289.47	289.47	1000.0
2019-10-04 05:47:00	SPY	ETF	289.54	289.54	289.54	289.54	1000.0
2019-10-04 05:50:00	SPY	ETF	289.55	289.55	289.55	289.55	1000.0
2019-10-04 05:51:00	SPY	ETF	289.55	289.55	289.55	289.55	246.0
2019-10-04 05:52:00	SPY	ETF	289.57	289.57	289.52	289.52	2000.0

> showing 50 of 158,700 rows — these rows as CSV

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