PREVIEW / etf_1min / 2018-11-07

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-11-07.parquet
  size:    3.5 MB
  rows:    176,662

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-11-07 04:00:00	SPY	ETF	277.29	277.5	277.29	277.5	2473.0
2018-11-07 04:01:00	SPY	ETF	277.5	277.6	277.41	277.6	1645.0
2018-11-07 04:02:00	SPY	ETF	277.53	277.53	277.42	277.5	1380.0
2018-11-07 04:03:00	SPY	ETF	277.5	277.59	277.5	277.59	1520.0
2018-11-07 04:04:00	SPY	ETF	277.35	277.35	277.35	277.35	647.0
2018-11-07 04:06:00	SPY	ETF	277.4	277.55	277.4	277.55	850.0
2018-11-07 04:07:00	SPY	ETF	277.59	277.63	277.59	277.62	1299.0
2018-11-07 04:08:00	SPY	ETF	277.59	277.59	277.59	277.59	1700.0
2018-11-07 04:09:00	SPY	ETF	277.53	277.56	277.46	277.47	21890.0
2018-11-07 04:10:00	SPY	ETF	277.46	277.49	277.46	277.46	3300.0
2018-11-07 04:11:00	SPY	ETF	277.45	277.5	277.43	277.5	5620.0
2018-11-07 04:13:00	SPY	ETF	277.46	277.46	277.46	277.46	300.0
2018-11-07 04:15:00	SPY	ETF	277.51	277.59	277.51	277.59	1275.0
2018-11-07 04:16:00	SPY	ETF	277.64	277.66	277.64	277.66	3900.0
2018-11-07 04:17:00	SPY	ETF	277.63	277.7	277.61	277.7	1155.0
2018-11-07 04:18:00	SPY	ETF	277.79	277.82	277.71	277.71	3825.0
2018-11-07 04:19:00	SPY	ETF	277.8	277.8	277.78	277.8	1215.0
2018-11-07 04:20:00	SPY	ETF	277.73	277.73	277.73	277.73	100.0
2018-11-07 04:21:00	SPY	ETF	277.71	277.75	277.71	277.71	2200.0
2018-11-07 04:22:00	SPY	ETF	277.71	277.71	277.71	277.71	100.0
2018-11-07 04:24:00	SPY	ETF	277.63	277.69	277.63	277.66	740.0
2018-11-07 04:25:00	SPY	ETF	277.66	277.66	277.63	277.63	300.0
2018-11-07 04:26:00	SPY	ETF	277.69	277.69	277.69	277.69	469.0
2018-11-07 04:27:00	SPY	ETF	277.65	277.65	277.65	277.65	469.0
2018-11-07 04:30:00	SPY	ETF	277.79	277.8	277.79	277.8	3570.0
2018-11-07 04:31:00	SPY	ETF	277.78	277.79	277.78	277.79	700.0
2018-11-07 04:32:00	SPY	ETF	277.71	277.71	277.71	277.71	1000.0
2018-11-07 04:35:00	SPY	ETF	277.79	277.79	277.79	277.79	1000.0
2018-11-07 04:37:00	SPY	ETF	277.86	277.99	277.86	277.87	6315.0
2018-11-07 04:38:00	SPY	ETF	277.83	277.87	277.83	277.87	3350.0
2018-11-07 04:39:00	SPY	ETF	277.81	277.81	277.75	277.77	3100.0
2018-11-07 04:41:00	SPY	ETF	277.74	277.74	277.74	277.74	464.0
2018-11-07 04:42:00	SPY	ETF	277.85	277.9	277.83	277.9	1625.0
2018-11-07 04:43:00	SPY	ETF	277.83	277.83	277.83	277.83	100.0
2018-11-07 04:44:00	SPY	ETF	277.86	277.86	277.83	277.83	300.0
2018-11-07 04:45:00	SPY	ETF	277.82	277.94	277.82	277.94	600.0
2018-11-07 04:48:00	SPY	ETF	277.89	277.89	277.89	277.89	500.0
2018-11-07 04:50:00	SPY	ETF	277.89	277.98	277.88	277.91	3600.0
2018-11-07 04:51:00	SPY	ETF	277.96	278.06	277.96	278.0	2600.0
2018-11-07 04:52:00	SPY	ETF	278.03	278.03	278.03	278.03	100.0
2018-11-07 04:53:00	SPY	ETF	278.0	278.0	277.98	277.98	1025.0
2018-11-07 04:54:00	SPY	ETF	278.08	278.13	278.08	278.13	910.0
2018-11-07 04:55:00	SPY	ETF	278.08	278.09	278.08	278.08	1076.0
2018-11-07 04:56:00	SPY	ETF	278.09	278.14	278.09	278.14	320.0
2018-11-07 04:57:00	SPY	ETF	278.19	278.29	278.19	278.29	3222.0
2018-11-07 04:58:00	SPY	ETF	278.25	278.29	278.25	278.29	3264.0
2018-11-07 04:59:00	SPY	ETF	278.25	278.25	278.25	278.25	1000.0
2018-11-07 05:00:00	SPY	ETF	278.2	278.27	278.2	278.27	2015.0
2018-11-07 05:01:00	SPY	ETF	278.25	278.34	278.25	278.34	1500.0
2018-11-07 05:02:00	SPY	ETF	278.21	278.21	278.15	278.15	1530.0

> showing 50 of 176,662 rows — these rows as CSV

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