PREVIEW / etf_1min / 2018-06-06

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-06-06.parquet
  size:    3.0 MB
  rows:    153,308

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
2018-06-06 04:00:00	SPY	ETF	275.65	275.87	275.65	275.71	1101.0
2018-06-06 04:06:00	SPY	ETF	275.77	275.78	275.77	275.77	1700.0
2018-06-06 04:07:00	SPY	ETF	275.75	275.75	275.7	275.7	3403.0
2018-06-06 04:09:00	SPY	ETF	275.65	275.65	275.65	275.65	1000.0
2018-06-06 04:11:00	SPY	ETF	275.78	275.78	275.78	275.78	300.0
2018-06-06 04:17:00	SPY	ETF	275.77	275.77	275.77	275.77	512.0
2018-06-06 04:19:00	SPY	ETF	275.77	275.77	275.77	275.77	300.0
2018-06-06 04:25:00	SPY	ETF	275.75	275.75	275.75	275.75	1300.0
2018-06-06 04:30:00	SPY	ETF	275.78	275.78	275.78	275.78	500.0
2018-06-06 04:31:00	SPY	ETF	275.83	275.85	275.83	275.85	425.0
2018-06-06 04:32:00	SPY	ETF	275.88	275.88	275.88	275.88	300.0
2018-06-06 04:37:00	SPY	ETF	275.83	275.83	275.83	275.83	400.0
2018-06-06 04:38:00	SPY	ETF	275.83	275.83	275.83	275.83	318.0
2018-06-06 04:43:00	SPY	ETF	275.76	275.76	275.76	275.76	300.0
2018-06-06 04:45:00	SPY	ETF	275.78	275.78	275.75	275.75	600.0
2018-06-06 04:46:00	SPY	ETF	275.73	275.73	275.73	275.73	1400.0
2018-06-06 04:58:00	SPY	ETF	275.72	275.72	275.72	275.72	300.0
2018-06-06 05:00:00	SPY	ETF	275.73	275.73	275.73	275.73	500.0
2018-06-06 05:02:00	SPY	ETF	275.73	275.73	275.73	275.73	500.0
2018-06-06 05:04:00	SPY	ETF	275.73	275.73	275.73	275.73	300.0
2018-06-06 05:10:00	SPY	ETF	275.82	275.82	275.82	275.82	1700.0
2018-06-06 05:11:00	SPY	ETF	275.85	275.85	275.85	275.85	400.0
2018-06-06 05:14:00	SPY	ETF	275.93	275.93	275.93	275.93	212.0
2018-06-06 05:15:00	SPY	ETF	275.96	275.96	275.96	275.96	1350.0
2018-06-06 05:16:00	SPY	ETF	275.99	275.99	275.99	275.99	450.0
2018-06-06 05:18:00	SPY	ETF	275.95	275.95	275.95	275.95	1000.0
2018-06-06 05:21:00	SPY	ETF	275.99	275.99	275.99	275.99	300.0
2018-06-06 05:24:00	SPY	ETF	276.03	276.03	276.03	276.03	402.0
2018-06-06 05:26:00	SPY	ETF	276.06	276.06	276.06	276.06	403.0
2018-06-06 05:28:00	SPY	ETF	276.01	276.01	276.0	276.0	1579.0
2018-06-06 05:30:00	SPY	ETF	275.99	275.99	275.98	275.98	500.0
2018-06-06 05:31:00	SPY	ETF	275.98	275.98	275.98	275.98	300.0
2018-06-06 05:32:00	SPY	ETF	275.99	275.99	275.99	275.99	300.0
2018-06-06 05:35:00	SPY	ETF	275.97	275.97	275.97	275.97	5000.0
2018-06-06 05:37:00	SPY	ETF	275.93	275.94	275.93	275.94	6700.0
2018-06-06 05:39:00	SPY	ETF	275.96	275.96	275.96	275.96	800.0
2018-06-06 05:46:00	SPY	ETF	276.0	276.0	276.0	276.0	100.0
2018-06-06 05:47:00	SPY	ETF	275.99	275.99	275.96	275.96	428.0
2018-06-06 05:49:00	SPY	ETF	275.96	275.96	275.96	275.96	140.0
2018-06-06 05:50:00	SPY	ETF	275.96	275.96	275.96	275.96	100.0
2018-06-06 05:51:00	SPY	ETF	275.99	275.99	275.99	275.99	400.0
2018-06-06 05:52:00	SPY	ETF	275.97	275.97	275.95	275.95	410.0
2018-06-06 05:53:00	SPY	ETF	275.91	275.91	275.88	275.89	4402.0
2018-06-06 05:59:00	SPY	ETF	276.03	276.04	276.03	276.04	2302.0
2018-06-06 06:00:00	SPY	ETF	276.02	276.02	276.02	276.02	300.0
2018-06-06 06:06:00	SPY	ETF	275.96	275.96	275.96	275.96	300.0
2018-06-06 06:07:00	SPY	ETF	275.94	275.94	275.94	275.94	2500.0
2018-06-06 06:10:00	SPY	ETF	275.9	275.9	275.9	275.9	2500.0
2018-06-06 06:11:00	SPY	ETF	275.89	275.89	275.89	275.89	802.0
2018-06-06 06:12:00	SPY	ETF	275.87	275.87	275.87	275.87	850.0

> showing 50 of 153,308 rows — these rows as CSV

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