PREVIEW / etf_1min / 2016-07-07

all etf 1-min files

  file:    by_date/etf_1min/2016/2016-07-07.parquet
  size:    2.7 MB
  rows:    146,040

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
2016-07-07 04:00:00	SPY	ETF	209.92	210.12	209.92	210.12	2799.0
2016-07-07 04:01:00	SPY	ETF	210.03	210.05	210.0	210.05	900.0
2016-07-07 04:02:00	SPY	ETF	209.97	209.97	209.97	209.97	200.0
2016-07-07 04:03:00	SPY	ETF	209.97	209.97	209.97	209.97	100.0
2016-07-07 04:05:00	SPY	ETF	209.9	209.9	209.9	209.9	464.0
2016-07-07 04:11:00	SPY	ETF	209.87	209.9	209.86	209.9	520.0
2016-07-07 04:16:00	SPY	ETF	209.91	209.91	209.91	209.91	501.0
2016-07-07 04:18:00	SPY	ETF	209.99	209.99	209.99	209.99	1902.0
2016-07-07 04:24:00	SPY	ETF	209.99	210.06	209.99	210.06	1303.0
2016-07-07 04:25:00	SPY	ETF	210.04	210.06	210.04	210.06	320.0
2016-07-07 04:26:00	SPY	ETF	210.08	210.12	210.08	210.12	1403.0
2016-07-07 04:27:00	SPY	ETF	210.05	210.09	210.05	210.09	701.0
2016-07-07 04:29:00	SPY	ETF	210.05	210.11	210.05	210.09	827.0
2016-07-07 04:31:00	SPY	ETF	210.11	210.18	210.11	210.18	704.0
2016-07-07 04:33:00	SPY	ETF	210.18	210.22	210.18	210.22	427.0
2016-07-07 04:34:00	SPY	ETF	210.21	210.21	210.15	210.2	3104.0
2016-07-07 04:35:00	SPY	ETF	210.24	210.27	210.24	210.26	1254.0
2016-07-07 04:36:00	SPY	ETF	210.22	210.22	210.22	210.22	200.0
2016-07-07 04:39:00	SPY	ETF	210.21	210.21	210.21	210.21	400.0
2016-07-07 04:43:00	SPY	ETF	210.19	210.19	210.19	210.19	402.0
2016-07-07 04:44:00	SPY	ETF	210.16	210.16	210.16	210.16	100.0
2016-07-07 04:45:00	SPY	ETF	210.19	210.19	210.16	210.16	802.0
2016-07-07 04:46:00	SPY	ETF	210.27	210.27	210.27	210.27	405.0
2016-07-07 04:48:00	SPY	ETF	210.21	210.21	210.21	210.21	304.0
2016-07-07 04:49:00	SPY	ETF	210.21	210.21	210.16	210.16	802.0
2016-07-07 04:54:00	SPY	ETF	210.11	210.11	210.11	210.11	301.0
2016-07-07 04:56:00	SPY	ETF	210.16	210.16	210.16	210.16	803.0
2016-07-07 04:59:00	SPY	ETF	210.07	210.07	210.06	210.06	702.0
2016-07-07 05:04:00	SPY	ETF	210.0	210.0	209.96	209.96	301.0
2016-07-07 05:11:00	SPY	ETF	209.91	209.91	209.91	209.91	450.0
2016-07-07 05:13:00	SPY	ETF	209.87	209.87	209.87	209.87	304.0
2016-07-07 05:14:00	SPY	ETF	209.86	209.86	209.86	209.86	304.0
2016-07-07 05:15:00	SPY	ETF	209.84	209.84	209.84	209.84	2102.0
2016-07-07 05:17:00	SPY	ETF	209.78	209.78	209.78	209.78	327.0
2016-07-07 05:19:00	SPY	ETF	209.82	209.84	209.82	209.84	702.0
2016-07-07 05:20:00	SPY	ETF	209.84	209.84	209.84	209.84	300.0
2016-07-07 05:26:00	SPY	ETF	209.81	209.81	209.75	209.75	803.0
2016-07-07 05:27:00	SPY	ETF	209.72	209.72	209.69	209.7	1832.0
2016-07-07 05:28:00	SPY	ETF	209.66	209.66	209.66	209.66	300.0
2016-07-07 05:30:00	SPY	ETF	209.71	209.75	209.71	209.75	803.0
2016-07-07 05:31:00	SPY	ETF	209.75	209.75	209.75	209.75	2200.0
2016-07-07 05:32:00	SPY	ETF	209.73	209.73	209.73	209.73	3501.0
2016-07-07 05:33:00	SPY	ETF	209.75	209.78	209.75	209.75	2109.0
2016-07-07 05:34:00	SPY	ETF	209.75	209.75	209.75	209.75	302.0
2016-07-07 05:35:00	SPY	ETF	209.75	209.75	209.75	209.75	1200.0
2016-07-07 05:37:00	SPY	ETF	209.74	209.74	209.74	209.74	201.0
2016-07-07 05:40:00	SPY	ETF	209.7	209.7	209.68	209.68	993.0
2016-07-07 05:42:00	SPY	ETF	209.73	209.75	209.73	209.75	1402.0
2016-07-07 05:43:00	SPY	ETF	209.73	209.73	209.73	209.73	301.0
2016-07-07 05:48:00	SPY	ETF	209.8	209.84	209.8	209.84	488.0

> showing 50 of 146,040 rows — these rows as CSV

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