PREVIEW / etf_1min / 2015-07-31

all etf 1-min files

  file:    by_date/etf_1min/2015/2015-07-31.parquet
  size:    2.4 MB
  rows:    123,000

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
2015-07-31 04:01:00	SPY	ETF	210.92	210.92	210.92	210.92	550.0
2015-07-31 04:02:00	SPY	ETF	210.92	210.92	210.92	210.92	2200.0
2015-07-31 04:03:00	SPY	ETF	210.92	210.92	210.92	210.92	300.0
2015-07-31 04:04:00	SPY	ETF	210.92	210.98	210.92	210.98	400.0
2015-07-31 04:05:00	SPY	ETF	210.94	210.94	210.94	210.94	100.0
2015-07-31 04:06:00	SPY	ETF	210.96	210.97	210.96	210.96	600.0
2015-07-31 04:22:00	SPY	ETF	210.88	210.88	210.88	210.88	400.0
2015-07-31 04:33:00	SPY	ETF	210.94	210.94	210.94	210.94	100.0
2015-07-31 04:35:00	SPY	ETF	211.01	211.01	211.01	211.01	1400.0
2015-07-31 04:48:00	SPY	ETF	211.09	211.15	211.09	211.12	1530.0
2015-07-31 04:51:00	SPY	ETF	211.08	211.08	211.08	211.08	200.0
2015-07-31 04:55:00	SPY	ETF	211.06	211.06	211.06	211.06	300.0
2015-07-31 05:00:00	SPY	ETF	210.98	210.98	210.98	210.98	2700.0
2015-07-31 05:04:00	SPY	ETF	210.94	210.94	210.94	210.94	1000.0
2015-07-31 05:08:00	SPY	ETF	210.93	210.95	210.93	210.95	12000.0
2015-07-31 05:19:00	SPY	ETF	211.03	211.03	211.03	211.03	17900.0
2015-07-31 05:24:00	SPY	ETF	210.98	210.98	210.98	210.98	300.0
2015-07-31 05:28:00	SPY	ETF	210.95	210.95	210.95	210.95	400.0
2015-07-31 05:33:00	SPY	ETF	210.95	210.95	210.95	210.95	500.0
2015-07-31 05:35:00	SPY	ETF	210.95	210.98	210.95	210.98	362.0
2015-07-31 05:36:00	SPY	ETF	210.93	210.93	210.93	210.93	900.0
2015-07-31 05:39:00	SPY	ETF	210.87	210.87	210.87	210.87	910.0
2015-07-31 05:40:00	SPY	ETF	210.84	210.84	210.75	210.75	2020.0
2015-07-31 05:41:00	SPY	ETF	210.77	210.77	210.77	210.77	1510.0
2015-07-31 05:43:00	SPY	ETF	210.71	210.71	210.71	210.71	330.0
2015-07-31 05:46:00	SPY	ETF	210.72	210.72	210.72	210.72	300.0
2015-07-31 05:47:00	SPY	ETF	210.7	210.7	210.66	210.7	505.0
2015-07-31 05:48:00	SPY	ETF	210.68	210.73	210.68	210.73	800.0
2015-07-31 05:54:00	SPY	ETF	210.7	210.7	210.7	210.7	100.0
2015-07-31 05:57:00	SPY	ETF	210.72	210.72	210.72	210.72	300.0
2015-07-31 06:04:00	SPY	ETF	210.72	210.72	210.72	210.72	300.0
2015-07-31 06:05:00	SPY	ETF	210.75	210.75	210.74	210.74	395.0
2015-07-31 06:07:00	SPY	ETF	210.69	210.7	210.69	210.7	500.0
2015-07-31 06:11:00	SPY	ETF	210.73	210.75	210.69	210.69	454.0
2015-07-31 06:12:00	SPY	ETF	210.72	210.72	210.72	210.72	330.0
2015-07-31 06:24:00	SPY	ETF	210.75	210.75	210.75	210.75	300.0
2015-07-31 06:30:00	SPY	ETF	210.81	210.81	210.81	210.81	100.0
2015-07-31 06:35:00	SPY	ETF	210.85	210.85	210.85	210.85	1400.0
2015-07-31 06:36:00	SPY	ETF	210.85	210.85	210.85	210.85	1000.0
2015-07-31 06:38:00	SPY	ETF	210.85	210.85	210.83	210.83	1500.0
2015-07-31 06:40:00	SPY	ETF	210.82	210.82	210.82	210.82	200.0
2015-07-31 06:48:00	SPY	ETF	210.83	210.83	210.83	210.83	405.0
2015-07-31 06:49:00	SPY	ETF	210.78	210.78	210.72	210.72	1700.0
2015-07-31 06:51:00	SPY	ETF	210.72	210.72	210.72	210.72	100.0
2015-07-31 06:54:00	SPY	ETF	210.73	210.78	210.73	210.78	1400.0
2015-07-31 06:58:00	SPY	ETF	210.72	210.72	210.71	210.72	25200.0
2015-07-31 06:59:00	SPY	ETF	210.74	210.74	210.74	210.74	100.0
2015-07-31 07:00:00	SPY	ETF	210.75	210.75	210.75	210.75	100.0
2015-07-31 07:02:00	SPY	ETF	210.75	210.75	210.75	210.75	200.0
2015-07-31 07:04:00	SPY	ETF	210.7	210.7	210.65	210.65	53500.0

> showing 50 of 123,000 rows — these rows as CSV

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