PREVIEW / etf_1min / 2017-09-18

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-09-18.parquet
  size:    2.7 MB
  rows:    138,272

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-09-18 04:00:00	SPY	ETF	249.61	249.71	249.61	249.71	456.0
2017-09-18 04:06:00	SPY	ETF	249.73	249.73	249.73	249.73	197.0
2017-09-18 04:08:00	SPY	ETF	249.73	249.73	249.73	249.73	310.0
2017-09-18 04:24:00	SPY	ETF	249.71	249.71	249.71	249.71	100.0
2017-09-18 04:25:00	SPY	ETF	249.73	249.76	249.73	249.76	1400.0
2017-09-18 04:27:00	SPY	ETF	249.77	249.78	249.77	249.78	500.0
2017-09-18 04:29:00	SPY	ETF	249.78	249.78	249.78	249.78	300.0
2017-09-18 04:31:00	SPY	ETF	249.78	249.78	249.78	249.78	100.0
2017-09-18 04:32:00	SPY	ETF	249.84	249.84	249.84	249.84	1800.0
2017-09-18 04:34:00	SPY	ETF	249.86	249.86	249.86	249.86	100.0
2017-09-18 04:35:00	SPY	ETF	249.8	249.8	249.8	249.8	200.0
2017-09-18 04:44:00	SPY	ETF	249.77	249.77	249.77	249.77	100.0
2017-09-18 04:45:00	SPY	ETF	249.76	249.76	249.76	249.76	200.0
2017-09-18 04:59:00	SPY	ETF	249.8	249.8	249.8	249.8	200.0
2017-09-18 05:00:00	SPY	ETF	249.8	249.8	249.8	249.8	100.0
2017-09-18 05:01:00	SPY	ETF	249.79	249.8	249.79	249.8	1100.0
2017-09-18 05:12:00	SPY	ETF	249.86	249.86	249.86	249.86	600.0
2017-09-18 05:14:00	SPY	ETF	249.8	249.8	249.8	249.8	100.0
2017-09-18 05:36:00	SPY	ETF	249.85	249.85	249.85	249.85	100.0
2017-09-18 05:39:00	SPY	ETF	249.87	249.87	249.87	249.87	500.0
2017-09-18 05:40:00	SPY	ETF	249.87	249.87	249.87	249.87	300.0
2017-09-18 05:56:00	SPY	ETF	249.87	249.88	249.87	249.88	600.0
2017-09-18 05:57:00	SPY	ETF	249.88	249.88	249.88	249.88	130.0
2017-09-18 06:00:00	SPY	ETF	249.78	249.78	249.78	249.78	300.0
2017-09-18 06:04:00	SPY	ETF	249.82	249.82	249.81	249.81	1800.0
2017-09-18 06:16:00	SPY	ETF	249.75	249.75	249.75	249.75	1000.0
2017-09-18 06:17:00	SPY	ETF	249.75	249.75	249.75	249.75	200.0
2017-09-18 06:20:00	SPY	ETF	249.76	249.76	249.75	249.75	600.0
2017-09-18 06:30:00	SPY	ETF	249.75	249.75	249.75	249.75	100.0
2017-09-18 06:47:00	SPY	ETF	249.78	249.78	249.78	249.78	1000.0
2017-09-18 06:48:00	SPY	ETF	249.82	249.82	249.82	249.82	8000.0
2017-09-18 06:52:00	SPY	ETF	249.82	249.82	249.82	249.82	500.0
2017-09-18 06:55:00	SPY	ETF	249.8	249.8	249.8	249.8	200.0
2017-09-18 06:57:00	SPY	ETF	249.79	249.79	249.79	249.79	251.0
2017-09-18 06:58:00	SPY	ETF	249.76	249.76	249.76	249.76	200.0
2017-09-18 06:59:00	SPY	ETF	249.82	249.82	249.75	249.75	44800.0
2017-09-18 07:00:00	SPY	ETF	249.75	249.75	249.74	249.74	15810.0
2017-09-18 07:01:00	SPY	ETF	249.74	249.74	249.74	249.74	1000.0
2017-09-18 07:02:00	SPY	ETF	249.72	249.72	249.72	249.72	300.0
2017-09-18 07:04:00	SPY	ETF	249.71	249.71	249.7	249.7	8400.0
2017-09-18 07:06:00	SPY	ETF	249.72	249.73	249.72	249.73	5125.0
2017-09-18 07:11:00	SPY	ETF	249.74	249.74	249.74	249.74	300.0
2017-09-18 07:12:00	SPY	ETF	249.73	249.73	249.71	249.71	5000.0
2017-09-18 07:14:00	SPY	ETF	249.73	249.73	249.73	249.73	4000.0
2017-09-18 07:20:00	SPY	ETF	249.7	249.7	249.7	249.7	1800.0
2017-09-18 07:26:00	SPY	ETF	249.68	249.68	249.68	249.68	300.0
2017-09-18 07:29:00	SPY	ETF	249.68	249.68	249.67	249.67	7592.0
2017-09-18 07:30:00	SPY	ETF	249.66	249.66	249.66	249.66	100.0
2017-09-18 07:33:00	SPY	ETF	249.69	249.69	249.69	249.69	1100.0
2017-09-18 07:34:00	SPY	ETF	249.7	249.7	249.7	249.7	800.0

> showing 50 of 138,272 rows — these rows as CSV

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