PREVIEW / etf_1min / 2017-07-07

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-07-07.parquet
  size:    2.6 MB
  rows:    137,947

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-07-07 04:12:00	SPY	ETF	240.75	240.75	240.75	240.75	450.0
2017-07-07 04:15:00	SPY	ETF	240.76	240.79	240.71	240.75	4425.0
2017-07-07 04:25:00	SPY	ETF	240.8	240.8	240.8	240.8	100.0
2017-07-07 04:26:00	SPY	ETF	240.82	240.82	240.82	240.82	500.0
2017-07-07 04:27:00	SPY	ETF	240.81	240.81	240.81	240.81	200.0
2017-07-07 04:28:00	SPY	ETF	240.8	240.8	240.8	240.8	100.0
2017-07-07 04:40:00	SPY	ETF	240.75	240.75	240.75	240.75	450.0
2017-07-07 04:42:00	SPY	ETF	240.75	240.75	240.75	240.75	300.0
2017-07-07 04:43:00	SPY	ETF	240.74	240.74	240.74	240.74	300.0
2017-07-07 04:48:00	SPY	ETF	240.7	240.7	240.7	240.7	500.0
2017-07-07 04:51:00	SPY	ETF	240.7	240.7	240.7	240.7	800.0
2017-07-07 04:54:00	SPY	ETF	240.7	240.7	240.7	240.7	1000.0
2017-07-07 04:56:00	SPY	ETF	240.7	240.7	240.7	240.7	400.0
2017-07-07 04:59:00	SPY	ETF	240.68	240.68	240.68	240.68	300.0
2017-07-07 05:01:00	SPY	ETF	240.68	240.68	240.68	240.68	400.0
2017-07-07 05:02:00	SPY	ETF	240.68	240.68	240.68	240.68	700.0
2017-07-07 05:03:00	SPY	ETF	240.68	240.68	240.68	240.68	1000.0
2017-07-07 05:04:00	SPY	ETF	240.68	240.68	240.68	240.68	300.0
2017-07-07 05:05:00	SPY	ETF	240.68	240.68	240.68	240.68	800.0
2017-07-07 05:06:00	SPY	ETF	240.68	240.68	240.68	240.68	326.0
2017-07-07 05:07:00	SPY	ETF	240.7	240.7	240.7	240.7	400.0
2017-07-07 05:09:00	SPY	ETF	240.71	240.71	240.71	240.71	300.0
2017-07-07 05:11:00	SPY	ETF	240.74	240.74	240.74	240.74	301.0
2017-07-07 05:12:00	SPY	ETF	240.75	240.75	240.75	240.75	704.0
2017-07-07 05:13:00	SPY	ETF	240.78	240.78	240.78	240.78	500.0
2017-07-07 05:14:00	SPY	ETF	240.8	240.8	240.8	240.8	201.0
2017-07-07 05:18:00	SPY	ETF	240.81	240.81	240.81	240.81	300.0
2017-07-07 05:19:00	SPY	ETF	240.8	240.8	240.8	240.8	401.0
2017-07-07 05:20:00	SPY	ETF	240.79	240.79	240.79	240.79	400.0
2017-07-07 05:21:00	SPY	ETF	240.8	240.8	240.8	240.8	300.0
2017-07-07 05:24:00	SPY	ETF	240.8	240.8	240.79	240.79	1103.0
2017-07-07 05:26:00	SPY	ETF	240.74	240.74	240.74	240.74	300.0
2017-07-07 05:27:00	SPY	ETF	240.74	240.74	240.74	240.74	302.0
2017-07-07 05:28:00	SPY	ETF	240.74	240.74	240.74	240.74	300.0
2017-07-07 05:32:00	SPY	ETF	240.7	240.7	240.7	240.7	1000.0
2017-07-07 05:33:00	SPY	ETF	240.7	240.7	240.7	240.7	252.0
2017-07-07 05:38:00	SPY	ETF	240.7	240.7	240.7	240.7	302.0
2017-07-07 05:52:00	SPY	ETF	240.66	240.66	240.66	240.66	200.0
2017-07-07 05:59:00	SPY	ETF	240.63	240.63	240.63	240.63	1630.0
2017-07-07 06:04:00	SPY	ETF	240.75	240.76	240.75	240.76	425.0
2017-07-07 06:06:00	SPY	ETF	240.72	240.72	240.72	240.72	4090.0
2017-07-07 06:07:00	SPY	ETF	240.75	240.75	240.75	240.75	377.0
2017-07-07 06:14:00	SPY	ETF	240.75	240.75	240.75	240.75	500.0
2017-07-07 06:15:00	SPY	ETF	240.75	240.75	240.75	240.75	500.0
2017-07-07 06:19:00	SPY	ETF	240.75	240.75	240.75	240.75	2400.0
2017-07-07 06:21:00	SPY	ETF	240.78	240.78	240.78	240.78	700.0
2017-07-07 06:22:00	SPY	ETF	240.78	240.78	240.78	240.78	4590.0
2017-07-07 06:37:00	SPY	ETF	240.83	240.85	240.81	240.82	16502.0
2017-07-07 06:38:00	SPY	ETF	240.83	240.85	240.83	240.85	8002.0
2017-07-07 06:39:00	SPY	ETF	240.8	240.81	240.8	240.8	40502.0

> showing 50 of 137,947 rows — these rows as CSV

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