PREVIEW / etf_1min / 2018-05-10

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-05-10.parquet
  size:    2.9 MB
  rows:    152,523

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-05-10 04:02:00	SPY	ETF	270.03	270.03	269.94	270.03	3100.0
2018-05-10 04:03:00	SPY	ETF	270.09	270.09	270.09	270.09	100.0
2018-05-10 04:05:00	SPY	ETF	270.04	270.04	270.04	270.04	250.0
2018-05-10 04:06:00	SPY	ETF	270.04	270.07	270.04	270.07	1100.0
2018-05-10 04:07:00	SPY	ETF	270.09	270.09	270.09	270.09	370.0
2018-05-10 04:08:00	SPY	ETF	270.09	270.09	270.09	270.09	1000.0
2018-05-10 04:09:00	SPY	ETF	270.11	270.11	270.07	270.07	700.0
2018-05-10 04:15:00	SPY	ETF	270.03	270.03	270.03	270.03	1100.0
2018-05-10 04:20:00	SPY	ETF	270.04	270.04	270.04	270.04	250.0
2018-05-10 04:21:00	SPY	ETF	270.07	270.07	270.07	270.07	400.0
2018-05-10 04:24:00	SPY	ETF	270.09	270.09	270.09	270.09	1000.0
2018-05-10 04:26:00	SPY	ETF	269.99	269.99	269.98	269.99	1650.0
2018-05-10 04:30:00	SPY	ETF	269.99	269.99	269.99	269.99	1200.0
2018-05-10 04:33:00	SPY	ETF	270.01	270.01	270.01	270.01	1000.0
2018-05-10 04:34:00	SPY	ETF	270.04	270.04	270.03	270.03	400.0
2018-05-10 04:37:00	SPY	ETF	269.99	269.99	269.99	269.99	150.0
2018-05-10 04:39:00	SPY	ETF	269.98	269.98	269.98	269.98	100.0
2018-05-10 04:41:00	SPY	ETF	269.95	269.95	269.95	269.95	100.0
2018-05-10 04:45:00	SPY	ETF	269.94	269.97	269.94	269.97	200.0
2018-05-10 04:49:00	SPY	ETF	269.97	269.97	269.97	269.97	900.0
2018-05-10 04:57:00	SPY	ETF	270.01	270.01	270.01	270.01	1500.0
2018-05-10 05:04:00	SPY	ETF	270.06	270.06	270.06	270.06	250.0
2018-05-10 05:13:00	SPY	ETF	270.0	270.0	270.0	270.0	100.0
2018-05-10 05:16:00	SPY	ETF	270.03	270.03	270.03	270.03	200.0
2018-05-10 05:21:00	SPY	ETF	270.03	270.03	270.03	270.03	100.0
2018-05-10 05:23:00	SPY	ETF	270.08	270.08	270.08	270.08	100.0
2018-05-10 05:24:00	SPY	ETF	270.11	270.13	270.02	270.02	700.0
2018-05-10 05:25:00	SPY	ETF	270.09	270.09	270.06	270.06	1300.0
2018-05-10 05:27:00	SPY	ETF	270.06	270.06	270.06	270.06	1200.0
2018-05-10 05:32:00	SPY	ETF	270.02	270.02	270.02	270.02	100.0
2018-05-10 05:39:00	SPY	ETF	269.88	269.88	269.88	269.88	500.0
2018-05-10 05:43:00	SPY	ETF	269.71	269.71	269.71	269.71	100.0
2018-05-10 05:45:00	SPY	ETF	269.7	269.7	269.7	269.7	200.0
2018-05-10 05:49:00	SPY	ETF	269.76	269.76	269.76	269.76	380.0
2018-05-10 05:52:00	SPY	ETF	269.75	269.75	269.75	269.75	400.0
2018-05-10 05:53:00	SPY	ETF	269.79	269.79	269.79	269.79	300.0
2018-05-10 05:56:00	SPY	ETF	269.8	269.8	269.8	269.8	1341.0
2018-05-10 06:01:00	SPY	ETF	269.71	269.71	269.71	269.71	100.0
2018-05-10 06:03:00	SPY	ETF	269.78	269.78	269.78	269.78	102.0
2018-05-10 06:04:00	SPY	ETF	269.8	269.8	269.8	269.8	200.0
2018-05-10 06:07:00	SPY	ETF	269.8	269.8	269.8	269.8	100.0
2018-05-10 06:08:00	SPY	ETF	269.78	269.78	269.78	269.78	300.0
2018-05-10 06:12:00	SPY	ETF	269.8	269.8	269.8	269.8	400.0
2018-05-10 06:16:00	SPY	ETF	269.83	269.83	269.8	269.8	499.0
2018-05-10 06:18:00	SPY	ETF	269.75	269.75	269.75	269.75	900.0
2018-05-10 06:20:00	SPY	ETF	269.8	269.8	269.8	269.8	100.0
2018-05-10 06:26:00	SPY	ETF	269.76	269.76	269.76	269.76	400.0
2018-05-10 06:32:00	SPY	ETF	269.78	269.78	269.78	269.78	2400.0
2018-05-10 06:33:00	SPY	ETF	269.78	269.78	269.76	269.78	1800.0
2018-05-10 06:34:00	SPY	ETF	269.78	269.78	269.78	269.78	1500.0

> showing 50 of 152,523 rows — these rows as CSV

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