PREVIEW / etf_1min / 2017-12-22

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-12-22.parquet
  size:    2.6 MB
  rows:    137,012

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-12-22 04:00:00	SPY	ETF	267.8	267.86	267.8	267.86	883.0
2017-12-22 04:11:00	SPY	ETF	267.85	267.86	267.85	267.86	300.0
2017-12-22 04:12:00	SPY	ETF	267.86	267.86	267.86	267.86	300.0
2017-12-22 04:14:00	SPY	ETF	267.86	267.86	267.85	267.85	800.0
2017-12-22 04:16:00	SPY	ETF	267.87	267.87	267.87	267.87	700.0
2017-12-22 04:18:00	SPY	ETF	267.87	267.87	267.87	267.87	500.0
2017-12-22 04:36:00	SPY	ETF	267.9	267.91	267.9	267.91	350.0
2017-12-22 04:41:00	SPY	ETF	267.89	267.89	267.89	267.89	100.0
2017-12-22 04:47:00	SPY	ETF	267.84	267.84	267.84	267.84	200.0
2017-12-22 04:56:00	SPY	ETF	267.8	267.8	267.8	267.8	200.0
2017-12-22 05:02:00	SPY	ETF	267.84	267.84	267.84	267.84	400.0
2017-12-22 05:05:00	SPY	ETF	267.84	267.84	267.84	267.84	400.0
2017-12-22 05:36:00	SPY	ETF	267.84	267.84	267.84	267.84	200.0
2017-12-22 05:57:00	SPY	ETF	267.74	267.74	267.74	267.74	600.0
2017-12-22 06:09:00	SPY	ETF	267.74	267.74	267.74	267.74	300.0
2017-12-22 06:11:00	SPY	ETF	267.74	267.74	267.74	267.74	400.0
2017-12-22 06:13:00	SPY	ETF	267.74	267.74	267.74	267.74	3550.0
2017-12-22 06:14:00	SPY	ETF	267.74	267.74	267.74	267.74	450.0
2017-12-22 06:39:00	SPY	ETF	267.78	267.78	267.78	267.78	100.0
2017-12-22 06:53:00	SPY	ETF	267.85	267.85	267.85	267.85	100.0
2017-12-22 06:56:00	SPY	ETF	267.8	267.8	267.8	267.8	9100.0
2017-12-22 06:57:00	SPY	ETF	267.78	267.78	267.77	267.77	5000.0
2017-12-22 07:00:00	SPY	ETF	267.82	267.82	267.82	267.82	1250.0
2017-12-22 07:01:00	SPY	ETF	267.8	267.8	267.8	267.8	840.0
2017-12-22 07:04:00	SPY	ETF	267.85	267.85	267.85	267.85	1000.0
2017-12-22 07:05:00	SPY	ETF	267.83	267.83	267.83	267.83	2000.0
2017-12-22 07:16:00	SPY	ETF	267.78	267.78	267.78	267.78	500.0
2017-12-22 07:17:00	SPY	ETF	267.78	267.78	267.78	267.78	2500.0
2017-12-22 07:19:00	SPY	ETF	267.76	267.76	267.76	267.76	400.0
2017-12-22 07:20:00	SPY	ETF	267.76	267.76	267.75	267.75	3100.0
2017-12-22 07:23:00	SPY	ETF	267.75	267.75	267.75	267.75	2000.0
2017-12-22 07:26:00	SPY	ETF	267.74	267.74	267.74	267.74	400.0
2017-12-22 07:27:00	SPY	ETF	267.7	267.7	267.7	267.7	100.0
2017-12-22 07:28:00	SPY	ETF	267.72	267.72	267.65	267.65	6167.0
2017-12-22 07:30:00	SPY	ETF	267.7	267.71	267.7	267.71	300.0
2017-12-22 07:31:00	SPY	ETF	267.67	267.67	267.67	267.67	3000.0
2017-12-22 07:42:00	SPY	ETF	267.77	267.77	267.77	267.77	1000.0
2017-12-22 07:47:00	SPY	ETF	267.67	267.71	267.67	267.71	2000.0
2017-12-22 07:55:00	SPY	ETF	267.68	267.68	267.68	267.68	160.0
2017-12-22 07:58:00	SPY	ETF	267.65	267.66	267.65	267.66	650.0
2017-12-22 07:59:00	SPY	ETF	267.65	267.65	267.64	267.64	550.0
2017-12-22 08:00:00	SPY	ETF	267.84	267.84	267.79	267.79	1318.0
2017-12-22 08:01:00	SPY	ETF	267.65	267.65	267.65	267.65	251.0
2017-12-22 08:02:00	SPY	ETF	267.65	267.65	267.64	267.64	3082.0
2017-12-22 08:05:00	SPY	ETF	267.64	267.64	267.64	267.64	100.0
2017-12-22 08:06:00	SPY	ETF	267.67	267.67	267.67	267.67	100.0
2017-12-22 08:10:00	SPY	ETF	267.67	267.67	267.65	267.65	200.0
2017-12-22 08:11:00	SPY	ETF	267.63	267.63	267.62	267.62	2800.0
2017-12-22 08:12:00	SPY	ETF	267.6	267.6	267.6	267.6	291.0
2017-12-22 08:14:00	SPY	ETF	267.58	267.58	267.58	267.58	300.0

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

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