PREVIEW / etf_1min / 2017-12-06

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-12-06.parquet
  size:    2.8 MB
  rows:    145,178

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-06 04:02:00	SPY	ETF	262.86	262.86	262.83	262.83	400.0
2017-12-06 04:03:00	SPY	ETF	262.81	262.81	262.81	262.81	200.0
2017-12-06 04:04:00	SPY	ETF	262.85	262.85	262.85	262.85	200.0
2017-12-06 04:06:00	SPY	ETF	262.74	262.74	262.74	262.74	230.0
2017-12-06 04:07:00	SPY	ETF	262.82	262.82	262.82	262.82	2030.0
2017-12-06 04:08:00	SPY	ETF	262.82	262.82	262.82	262.82	800.0
2017-12-06 04:11:00	SPY	ETF	262.79	262.79	262.79	262.79	100.0
2017-12-06 04:13:00	SPY	ETF	262.84	262.87	262.84	262.87	200.0
2017-12-06 04:16:00	SPY	ETF	262.85	262.85	262.81	262.81	800.0
2017-12-06 04:20:00	SPY	ETF	262.79	262.79	262.79	262.79	125.0
2017-12-06 04:21:00	SPY	ETF	262.79	262.79	262.79	262.79	875.0
2017-12-06 04:23:00	SPY	ETF	262.84	262.84	262.79	262.79	1050.0
2017-12-06 04:30:00	SPY	ETF	262.78	262.78	262.78	262.78	500.0
2017-12-06 04:35:00	SPY	ETF	262.69	262.69	262.69	262.69	301.0
2017-12-06 04:36:00	SPY	ETF	262.69	262.69	262.69	262.69	199.0
2017-12-06 04:41:00	SPY	ETF	262.66	262.66	262.66	262.66	210.0
2017-12-06 04:42:00	SPY	ETF	262.66	262.66	262.66	262.66	1790.0
2017-12-06 04:54:00	SPY	ETF	262.61	262.61	262.61	262.61	102.0
2017-12-06 04:55:00	SPY	ETF	262.6	262.6	262.6	262.6	6500.0
2017-12-06 04:56:00	SPY	ETF	262.6	262.6	262.6	262.6	3398.0
2017-12-06 04:59:00	SPY	ETF	262.58	262.58	262.58	262.58	2000.0
2017-12-06 05:02:00	SPY	ETF	262.62	262.62	262.62	262.62	3000.0
2017-12-06 05:16:00	SPY	ETF	262.62	262.62	262.62	262.62	600.0
2017-12-06 05:24:00	SPY	ETF	262.56	262.56	262.56	262.56	100.0
2017-12-06 05:29:00	SPY	ETF	262.62	262.62	262.62	262.62	345.0
2017-12-06 05:33:00	SPY	ETF	262.64	262.64	262.64	262.64	240.0
2017-12-06 05:39:00	SPY	ETF	262.63	262.63	262.63	262.63	200.0
2017-12-06 05:50:00	SPY	ETF	262.76	262.76	262.76	262.76	100.0
2017-12-06 05:51:00	SPY	ETF	262.78	262.78	262.78	262.78	200.0
2017-12-06 06:02:00	SPY	ETF	262.69	262.69	262.69	262.69	100.0
2017-12-06 06:03:00	SPY	ETF	262.7	262.7	262.67	262.67	200.0
2017-12-06 06:04:00	SPY	ETF	262.6	262.65	262.6	262.65	600.0
2017-12-06 06:05:00	SPY	ETF	262.65	262.65	262.65	262.65	1600.0
2017-12-06 06:06:00	SPY	ETF	262.65	262.65	262.65	262.65	849.0
2017-12-06 06:10:00	SPY	ETF	262.72	262.72	262.71	262.71	600.0
2017-12-06 06:11:00	SPY	ETF	262.75	262.75	262.75	262.75	600.0
2017-12-06 06:15:00	SPY	ETF	262.75	262.76	262.75	262.76	900.0
2017-12-06 06:16:00	SPY	ETF	262.76	262.79	262.76	262.79	348.0
2017-12-06 06:17:00	SPY	ETF	262.79	262.79	262.79	262.79	900.0
2017-12-06 06:25:00	SPY	ETF	262.8	262.87	262.8	262.87	4000.0
2017-12-06 06:27:00	SPY	ETF	262.82	262.82	262.82	262.82	300.0
2017-12-06 06:31:00	SPY	ETF	262.8	262.8	262.8	262.8	200.0
2017-12-06 06:33:00	SPY	ETF	262.85	262.85	262.85	262.85	300.0
2017-12-06 06:34:00	SPY	ETF	262.8	262.8	262.8	262.8	2100.0
2017-12-06 06:40:00	SPY	ETF	262.8	262.8	262.8	262.8	2670.0
2017-12-06 06:41:00	SPY	ETF	262.8	262.8	262.77	262.77	5200.0
2017-12-06 06:42:00	SPY	ETF	262.77	262.77	262.77	262.77	1200.0
2017-12-06 06:43:00	SPY	ETF	262.77	262.77	262.7	262.7	3752.0
2017-12-06 06:45:00	SPY	ETF	262.74	262.74	262.74	262.74	200.0
2017-12-06 06:49:00	SPY	ETF	262.72	262.72	262.72	262.72	200.0

> showing 50 of 145,178 rows — these rows as CSV

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