PREVIEW / etf_1min / 2018-10-31

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-10-31.parquet
  size:    3.4 MB
  rows:    180,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
2018-10-31 04:00:00	SPY	ETF	269.1	269.35	269.0	269.35	2737.0
2018-10-31 04:01:00	SPY	ETF	269.28	269.28	269.28	269.28	197.0
2018-10-31 04:04:00	SPY	ETF	269.4	269.4	269.4	269.4	454.0
2018-10-31 04:06:00	SPY	ETF	269.36	269.36	269.36	269.36	100.0
2018-10-31 04:08:00	SPY	ETF	269.25	269.25	269.25	269.25	135.0
2018-10-31 04:11:00	SPY	ETF	269.32	269.32	269.32	269.32	100.0
2018-10-31 04:13:00	SPY	ETF	269.22	269.22	269.19	269.19	200.0
2018-10-31 04:16:00	SPY	ETF	269.29	269.34	269.29	269.34	400.0
2018-10-31 04:18:00	SPY	ETF	269.31	269.31	269.31	269.31	400.0
2018-10-31 04:19:00	SPY	ETF	269.34	269.34	269.34	269.34	300.0
2018-10-31 04:22:00	SPY	ETF	269.45	269.57	269.45	269.56	6747.0
2018-10-31 04:23:00	SPY	ETF	269.54	269.6	269.54	269.6	925.0
2018-10-31 04:24:00	SPY	ETF	269.63	269.65	269.63	269.65	10050.0
2018-10-31 04:25:00	SPY	ETF	269.67	269.75	269.67	269.75	800.0
2018-10-31 04:26:00	SPY	ETF	269.75	269.75	269.73	269.73	1931.0
2018-10-31 04:28:00	SPY	ETF	269.64	269.64	269.64	269.64	310.0
2018-10-31 04:29:00	SPY	ETF	269.63	269.69	269.63	269.69	1200.0
2018-10-31 04:30:00	SPY	ETF	269.7	269.7	269.7	269.7	394.0
2018-10-31 04:33:00	SPY	ETF	269.64	269.64	269.59	269.59	500.0
2018-10-31 04:35:00	SPY	ETF	269.72	269.72	269.72	269.72	300.0
2018-10-31 04:36:00	SPY	ETF	269.74	269.77	269.74	269.77	300.0
2018-10-31 04:37:00	SPY	ETF	269.74	269.82	269.74	269.78	1302.0
2018-10-31 04:38:00	SPY	ETF	269.82	269.82	269.79	269.79	1300.0
2018-10-31 04:39:00	SPY	ETF	269.72	269.75	269.7	269.75	900.0
2018-10-31 04:40:00	SPY	ETF	269.79	269.79	269.79	269.79	300.0
2018-10-31 04:41:00	SPY	ETF	269.84	269.88	269.84	269.88	4801.0
2018-10-31 04:42:00	SPY	ETF	269.87	269.94	269.87	269.87	3800.0
2018-10-31 04:43:00	SPY	ETF	269.82	269.82	269.82	269.82	400.0
2018-10-31 04:44:00	SPY	ETF	269.86	269.86	269.86	269.86	1500.0
2018-10-31 04:45:00	SPY	ETF	269.87	269.9	269.87	269.9	5150.0
2018-10-31 04:46:00	SPY	ETF	269.9	269.9	269.89	269.89	800.0
2018-10-31 04:48:00	SPY	ETF	269.84	269.84	269.81	269.81	400.0
2018-10-31 04:49:00	SPY	ETF	269.81	269.81	269.78	269.78	700.0
2018-10-31 04:50:00	SPY	ETF	269.77	269.85	269.77	269.85	2000.0
2018-10-31 04:52:00	SPY	ETF	269.85	269.85	269.85	269.85	300.0
2018-10-31 04:53:00	SPY	ETF	269.8	269.8	269.76	269.76	400.0
2018-10-31 04:55:00	SPY	ETF	269.81	269.81	269.81	269.81	301.0
2018-10-31 04:56:00	SPY	ETF	269.81	269.87	269.81	269.87	700.0
2018-10-31 04:57:00	SPY	ETF	269.86	269.86	269.86	269.86	300.0
2018-10-31 04:59:00	SPY	ETF	269.86	269.86	269.86	269.86	227.0
2018-10-31 05:01:00	SPY	ETF	269.89	269.89	269.89	269.89	300.0
2018-10-31 05:02:00	SPY	ETF	269.87	269.87	269.87	269.87	1000.0
2018-10-31 05:04:00	SPY	ETF	269.89	269.89	269.88	269.89	2781.0
2018-10-31 05:05:00	SPY	ETF	269.81	269.81	269.76	269.76	4400.0
2018-10-31 05:06:00	SPY	ETF	269.71	269.72	269.7	269.7	3000.0
2018-10-31 05:07:00	SPY	ETF	269.65	269.65	269.65	269.65	752.0
2018-10-31 05:08:00	SPY	ETF	269.65	269.7	269.65	269.7	869.0
2018-10-31 05:09:00	SPY	ETF	269.68	269.68	269.68	269.68	300.0
2018-10-31 05:10:00	SPY	ETF	269.65	269.65	269.65	269.65	4000.0
2018-10-31 05:12:00	SPY	ETF	269.68	269.68	269.68	269.68	700.0

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

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