PREVIEW / etf_1min / 2017-03-28

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-03-28.parquet
  size:    2.9 MB
  rows:    147,380

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-03-28 04:00:00	SPY	ETF	233.78	233.78	233.78	233.78	386.0
2017-03-28 04:06:00	SPY	ETF	233.79	233.79	233.79	233.79	600.0
2017-03-28 04:07:00	SPY	ETF	233.8	233.8	233.8	233.8	400.0
2017-03-28 04:22:00	SPY	ETF	233.8	233.8	233.8	233.8	300.0
2017-03-28 04:23:00	SPY	ETF	233.85	233.85	233.85	233.85	100.0
2017-03-28 04:26:00	SPY	ETF	233.84	233.84	233.84	233.84	1500.0
2017-03-28 04:31:00	SPY	ETF	233.89	233.89	233.89	233.89	200.0
2017-03-28 04:44:00	SPY	ETF	233.91	233.91	233.91	233.91	100.0
2017-03-28 04:48:00	SPY	ETF	233.89	233.89	233.89	233.89	300.0
2017-03-28 04:51:00	SPY	ETF	233.9	233.9	233.9	233.9	400.0
2017-03-28 05:00:00	SPY	ETF	233.9	233.9	233.9	233.9	100.0
2017-03-28 05:27:00	SPY	ETF	233.87	233.87	233.87	233.87	100.0
2017-03-28 05:50:00	SPY	ETF	233.92	233.92	233.92	233.92	300.0
2017-03-28 06:16:00	SPY	ETF	233.88	233.88	233.88	233.88	300.0
2017-03-28 06:18:00	SPY	ETF	233.87	233.87	233.87	233.87	100.0
2017-03-28 06:38:00	SPY	ETF	233.8	233.8	233.8	233.8	100.0
2017-03-28 06:40:00	SPY	ETF	233.79	233.79	233.78	233.78	333.0
2017-03-28 06:47:00	SPY	ETF	233.79	233.79	233.79	233.79	100.0
2017-03-28 06:53:00	SPY	ETF	233.79	233.79	233.79	233.79	500.0
2017-03-28 07:01:00	SPY	ETF	233.76	233.76	233.69	233.69	5934.0
2017-03-28 07:02:00	SPY	ETF	233.71	233.71	233.7	233.7	1001.0
2017-03-28 07:03:00	SPY	ETF	233.7	233.7	233.7	233.7	200.0
2017-03-28 07:06:00	SPY	ETF	233.75	233.75	233.75	233.75	10000.0
2017-03-28 07:08:00	SPY	ETF	233.71	233.71	233.71	233.71	2501.0
2017-03-28 07:09:00	SPY	ETF	233.7	233.7	233.7	233.7	400.0
2017-03-28 07:13:00	SPY	ETF	233.71	233.71	233.71	233.71	500.0
2017-03-28 07:14:00	SPY	ETF	233.71	233.71	233.69	233.69	900.0
2017-03-28 07:15:00	SPY	ETF	233.72	233.72	233.72	233.72	100.0
2017-03-28 07:17:00	SPY	ETF	233.69	233.69	233.69	233.69	1200.0
2017-03-28 07:19:00	SPY	ETF	233.7	233.7	233.7	233.7	200.0
2017-03-28 07:22:00	SPY	ETF	233.7	233.7	233.7	233.7	100.0
2017-03-28 07:24:00	SPY	ETF	233.69	233.69	233.67	233.67	1202.0
2017-03-28 07:25:00	SPY	ETF	233.6	233.62	233.6	233.62	733.0
2017-03-28 07:26:00	SPY	ETF	233.6	233.6	233.6	233.6	105.0
2017-03-28 07:28:00	SPY	ETF	233.6	233.6	233.6	233.6	380.0
2017-03-28 07:29:00	SPY	ETF	233.59	233.59	233.54	233.54	513.0
2017-03-28 07:30:00	SPY	ETF	233.58	233.58	233.54	233.54	7402.0
2017-03-28 07:31:00	SPY	ETF	233.54	233.54	233.53	233.53	20481.0
2017-03-28 07:32:00	SPY	ETF	233.54	233.54	233.51	233.54	16517.0
2017-03-28 07:33:00	SPY	ETF	233.5	233.51	233.5	233.51	3310.0
2017-03-28 07:34:00	SPY	ETF	233.5	233.5	233.46	233.46	5511.0
2017-03-28 07:35:00	SPY	ETF	233.47	233.47	233.44	233.44	703.0
2017-03-28 07:36:00	SPY	ETF	233.43	233.44	233.3	233.3	13209.0
2017-03-28 07:37:00	SPY	ETF	233.33	233.35	233.3	233.32	5601.0
2017-03-28 07:38:00	SPY	ETF	233.32	233.32	233.31	233.32	24100.0
2017-03-28 07:39:00	SPY	ETF	233.36	233.36	233.36	233.36	1210.0
2017-03-28 07:40:00	SPY	ETF	233.37	233.37	233.37	233.37	500.0
2017-03-28 07:41:00	SPY	ETF	233.37	233.38	233.35	233.37	3161.0
2017-03-28 07:42:00	SPY	ETF	233.38	233.38	233.38	233.38	2505.0
2017-03-28 07:43:00	SPY	ETF	233.48	233.48	233.45	233.45	711.0

> showing 50 of 147,380 rows — these rows as CSV

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