PREVIEW / etf_1min / 2017-05-31

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-05-31.parquet
  size:    2.7 MB
  rows:    139,641

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
2017-05-31 04:07:00	SPY	ETF	241.66	241.66	241.66	241.66	200.0
2017-05-31 04:21:00	SPY	ETF	241.53	241.56	241.53	241.56	300.0
2017-05-31 05:18:00	SPY	ETF	241.43	241.43	241.42	241.42	200.0
2017-05-31 05:56:00	SPY	ETF	241.52	241.52	241.52	241.52	300.0
2017-05-31 06:25:00	SPY	ETF	241.54	241.54	241.54	241.54	800.0
2017-05-31 06:36:00	SPY	ETF	241.62	241.62	241.62	241.62	4000.0
2017-05-31 06:40:00	SPY	ETF	241.68	241.68	241.68	241.68	2000.0
2017-05-31 06:42:00	SPY	ETF	241.69	241.69	241.69	241.69	2000.0
2017-05-31 06:43:00	SPY	ETF	241.69	241.69	241.69	241.69	100.0
2017-05-31 06:47:00	SPY	ETF	241.69	241.69	241.69	241.69	2500.0
2017-05-31 06:50:00	SPY	ETF	241.71	241.71	241.71	241.71	400.0
2017-05-31 06:59:00	SPY	ETF	241.69	241.69	241.69	241.69	300.0
2017-05-31 07:00:00	SPY	ETF	241.74	241.74	241.74	241.74	503.0
2017-05-31 07:04:00	SPY	ETF	241.73	241.73	241.71	241.71	4000.0
2017-05-31 07:05:00	SPY	ETF	241.73	241.73	241.73	241.73	4000.0
2017-05-31 07:06:00	SPY	ETF	241.76	241.76	241.76	241.76	201.0
2017-05-31 07:07:00	SPY	ETF	241.75	241.75	241.75	241.75	299.0
2017-05-31 07:08:00	SPY	ETF	241.72	241.72	241.7	241.71	4000.0
2017-05-31 07:09:00	SPY	ETF	241.72	241.73	241.72	241.73	2200.0
2017-05-31 07:11:00	SPY	ETF	241.74	241.76	241.74	241.76	3000.0
2017-05-31 07:12:00	SPY	ETF	241.74	241.74	241.73	241.73	4000.0
2017-05-31 07:13:00	SPY	ETF	241.73	241.73	241.73	241.73	5000.0
2017-05-31 07:15:00	SPY	ETF	241.73	241.73	241.73	241.73	4000.0
2017-05-31 07:16:00	SPY	ETF	241.76	241.76	241.76	241.76	400.0
2017-05-31 07:17:00	SPY	ETF	241.73	241.76	241.73	241.76	9319.0
2017-05-31 07:19:00	SPY	ETF	241.77	241.77	241.77	241.77	8001.0
2017-05-31 07:22:00	SPY	ETF	241.79	241.8	241.79	241.8	271.0
2017-05-31 07:23:00	SPY	ETF	241.79	241.79	241.79	241.79	1420.0
2017-05-31 07:25:00	SPY	ETF	241.76	241.76	241.76	241.76	100.0
2017-05-31 07:26:00	SPY	ETF	241.78	241.78	241.78	241.78	800.0
2017-05-31 07:28:00	SPY	ETF	241.75	241.75	241.75	241.75	5000.0
2017-05-31 07:30:00	SPY	ETF	241.75	241.75	241.75	241.75	1338.0
2017-05-31 07:31:00	SPY	ETF	241.75	241.76	241.75	241.76	3138.0
2017-05-31 07:32:00	SPY	ETF	241.76	241.76	241.76	241.76	500.0
2017-05-31 07:33:00	SPY	ETF	241.76	241.77	241.76	241.77	2907.0
2017-05-31 07:34:00	SPY	ETF	241.78	241.79	241.78	241.79	1838.0
2017-05-31 07:35:00	SPY	ETF	241.79	241.79	241.79	241.79	669.0
2017-05-31 07:38:00	SPY	ETF	241.77	241.77	241.77	241.77	669.0
2017-05-31 07:40:00	SPY	ETF	241.77	241.77	241.77	241.77	50000.0
2017-05-31 07:41:00	SPY	ETF	241.77	241.77	241.76	241.76	2007.0
2017-05-31 07:42:00	SPY	ETF	241.76	241.76	241.76	241.76	1200.0
2017-05-31 07:45:00	SPY	ETF	241.76	241.76	241.76	241.76	1169.0
2017-05-31 07:46:00	SPY	ETF	241.77	241.88	241.77	241.87	16472.0
2017-05-31 07:47:00	SPY	ETF	241.87	241.89	241.87	241.87	13349.0
2017-05-31 07:48:00	SPY	ETF	241.9	241.91	241.88	241.91	7407.0
2017-05-31 07:49:00	SPY	ETF	241.91	241.92	241.91	241.92	3800.0
2017-05-31 07:50:00	SPY	ETF	241.92	241.93	241.91	241.91	17731.0
2017-05-31 07:51:00	SPY	ETF	241.85	241.85	241.85	241.85	104.0
2017-05-31 07:52:00	SPY	ETF	241.88	241.89	241.87	241.89	13831.0
2017-05-31 07:53:00	SPY	ETF	241.86	241.86	241.86	241.86	2550.0

> showing 50 of 139,641 rows — these rows as CSV

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