PREVIEW / etf_1min / 2018-09-19

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-09-19.parquet
  size:    2.8 MB
  rows:    150,827

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-09-19 04:00:00	SPY	ETF	290.89	290.89	290.89	290.89	254.0
2018-09-19 04:04:00	SPY	ETF	290.94	290.94	290.94	290.94	400.0
2018-09-19 04:05:00	SPY	ETF	290.91	290.91	290.91	290.91	100.0
2018-09-19 04:06:00	SPY	ETF	290.88	290.89	290.88	290.89	200.0
2018-09-19 04:12:00	SPY	ETF	291.04	291.04	291.04	291.04	500.0
2018-09-19 04:14:00	SPY	ETF	291.04	291.04	291.04	291.04	300.0
2018-09-19 04:19:00	SPY	ETF	291.01	291.04	291.0	291.0	500.0
2018-09-19 04:20:00	SPY	ETF	291.04	291.04	291.04	291.04	2000.0
2018-09-19 04:25:00	SPY	ETF	290.9	290.9	290.9	290.9	100.0
2018-09-19 04:30:00	SPY	ETF	290.93	290.93	290.93	290.93	300.0
2018-09-19 04:37:00	SPY	ETF	290.8	290.8	290.8	290.8	200.0
2018-09-19 04:48:00	SPY	ETF	290.78	290.78	290.78	290.78	600.0
2018-09-19 04:56:00	SPY	ETF	290.83	290.83	290.83	290.83	500.0
2018-09-19 05:14:00	SPY	ETF	290.82	290.82	290.76	290.8	5500.0
2018-09-19 05:25:00	SPY	ETF	290.84	290.84	290.84	290.84	100.0
2018-09-19 05:27:00	SPY	ETF	290.79	290.79	290.79	290.79	100.0
2018-09-19 05:32:00	SPY	ETF	290.84	290.84	290.84	290.84	100.0
2018-09-19 05:40:00	SPY	ETF	290.85	290.85	290.83	290.83	700.0
2018-09-19 06:00:00	SPY	ETF	290.81	290.82	290.81	290.82	1150.0
2018-09-19 06:07:00	SPY	ETF	290.79	290.79	290.79	290.79	400.0
2018-09-19 06:08:00	SPY	ETF	290.78	290.78	290.78	290.78	1000.0
2018-09-19 06:18:00	SPY	ETF	290.76	290.76	290.76	290.76	200.0
2018-09-19 06:25:00	SPY	ETF	290.8	290.8	290.8	290.8	1000.0
2018-09-19 06:29:00	SPY	ETF	290.78	290.78	290.78	290.78	100.0
2018-09-19 06:31:00	SPY	ETF	290.87	290.87	290.87	290.87	200.0
2018-09-19 06:36:00	SPY	ETF	290.89	290.89	290.89	290.89	1000.0
2018-09-19 06:47:00	SPY	ETF	290.86	290.86	290.86	290.86	400.0
2018-09-19 06:52:00	SPY	ETF	290.89	290.89	290.89	290.89	4000.0
2018-09-19 07:00:00	SPY	ETF	290.84	290.84	290.84	290.84	300.0
2018-09-19 07:01:00	SPY	ETF	290.84	290.85	290.84	290.85	1190.0
2018-09-19 07:02:00	SPY	ETF	290.85	290.85	290.85	290.85	2000.0
2018-09-19 07:04:00	SPY	ETF	290.86	290.86	290.86	290.86	200.0
2018-09-19 07:05:00	SPY	ETF	290.86	290.86	290.84	290.84	1200.0
2018-09-19 07:10:00	SPY	ETF	290.84	290.84	290.81	290.81	1212.0
2018-09-19 07:12:00	SPY	ETF	290.82	290.82	290.78	290.78	582.0
2018-09-19 07:13:00	SPY	ETF	290.76	290.76	290.73	290.73	2000.0
2018-09-19 07:14:00	SPY	ETF	290.74	290.74	290.7	290.7	2332.0
2018-09-19 07:15:00	SPY	ETF	290.68	290.68	290.68	290.68	2000.0
2018-09-19 07:17:00	SPY	ETF	290.68	290.68	290.68	290.68	2000.0
2018-09-19 07:18:00	SPY	ETF	290.77	290.77	290.77	290.77	100.0
2018-09-19 07:22:00	SPY	ETF	290.76	290.76	290.76	290.76	3420.0
2018-09-19 07:24:00	SPY	ETF	290.76	290.76	290.76	290.76	4800.0
2018-09-19 07:25:00	SPY	ETF	290.76	290.76	290.75	290.75	3837.0
2018-09-19 07:26:00	SPY	ETF	290.75	290.75	290.75	290.75	910.0
2018-09-19 07:28:00	SPY	ETF	290.72	290.72	290.72	290.72	500.0
2018-09-19 07:30:00	SPY	ETF	290.74	290.74	290.74	290.74	236.0
2018-09-19 07:33:00	SPY	ETF	290.72	290.72	290.72	290.72	250.0
2018-09-19 07:34:00	SPY	ETF	290.72	290.72	290.7	290.7	1400.0
2018-09-19 07:37:00	SPY	ETF	290.69	290.69	290.69	290.69	300.0
2018-09-19 07:38:00	SPY	ETF	290.69	290.69	290.68	290.68	999.0

> showing 50 of 150,827 rows — these rows as CSV

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