PREVIEW / etf_1min / 2019-11-20

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-11-20.parquet
  size:    3.2 MB
  rows:    166,044

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
2019-11-20 04:00:00	SPY	ETF	310.64	310.64	310.6	310.6	773.0
2019-11-20 04:01:00	SPY	ETF	310.57	310.57	310.56	310.56	1630.0
2019-11-20 04:02:00	SPY	ETF	310.62	310.62	310.59	310.59	500.0
2019-11-20 04:03:00	SPY	ETF	310.57	310.57	310.57	310.57	522.0
2019-11-20 04:04:00	SPY	ETF	310.52	310.52	310.5	310.5	600.0
2019-11-20 04:07:00	SPY	ETF	310.54	310.54	310.54	310.54	400.0
2019-11-20 04:12:00	SPY	ETF	310.5	310.5	310.5	310.5	100.0
2019-11-20 04:14:00	SPY	ETF	310.49	310.49	310.49	310.49	100.0
2019-11-20 04:16:00	SPY	ETF	310.49	310.49	310.49	310.49	400.0
2019-11-20 04:17:00	SPY	ETF	310.5	310.59	310.5	310.59	350.0
2019-11-20 04:18:00	SPY	ETF	310.6	310.6	310.6	310.6	275.0
2019-11-20 04:20:00	SPY	ETF	310.65	310.65	310.65	310.65	300.0
2019-11-20 04:21:00	SPY	ETF	310.71	310.71	310.71	310.71	300.0
2019-11-20 04:23:00	SPY	ETF	310.73	310.73	310.73	310.73	400.0
2019-11-20 04:24:00	SPY	ETF	310.74	310.74	310.74	310.74	400.0
2019-11-20 04:26:00	SPY	ETF	310.73	310.73	310.73	310.73	200.0
2019-11-20 04:27:00	SPY	ETF	310.78	310.78	310.78	310.78	300.0
2019-11-20 04:35:00	SPY	ETF	310.94	310.94	310.94	310.94	500.0
2019-11-20 04:36:00	SPY	ETF	310.9	310.9	310.9	310.9	300.0
2019-11-20 04:37:00	SPY	ETF	310.91	310.91	310.91	310.91	252.0
2019-11-20 04:38:00	SPY	ETF	310.88	310.88	310.88	310.88	100.0
2019-11-20 04:46:00	SPY	ETF	310.99	310.99	310.96	310.96	400.0
2019-11-20 04:49:00	SPY	ETF	310.85	310.85	310.85	310.85	200.0
2019-11-20 04:50:00	SPY	ETF	310.94	310.94	310.94	310.94	300.0
2019-11-20 04:53:00	SPY	ETF	310.88	310.88	310.88	310.88	300.0
2019-11-20 04:55:00	SPY	ETF	310.84	310.84	310.84	310.84	500.0
2019-11-20 04:56:00	SPY	ETF	310.85	310.85	310.85	310.85	300.0
2019-11-20 04:57:00	SPY	ETF	310.88	310.88	310.88	310.88	300.0
2019-11-20 04:58:00	SPY	ETF	310.89	310.89	310.89	310.89	100.0
2019-11-20 05:00:00	SPY	ETF	310.83	310.83	310.83	310.83	100.0
2019-11-20 05:07:00	SPY	ETF	310.8	310.8	310.8	310.8	115.0
2019-11-20 05:08:00	SPY	ETF	310.75	310.75	310.75	310.75	100.0
2019-11-20 05:10:00	SPY	ETF	310.72	310.72	310.72	310.72	1025.0
2019-11-20 05:11:00	SPY	ETF	310.69	310.69	310.69	310.69	105.0
2019-11-20 05:12:00	SPY	ETF	310.63	310.63	310.62	310.62	405.0
2019-11-20 05:13:00	SPY	ETF	310.64	310.64	310.64	310.64	250.0
2019-11-20 05:18:00	SPY	ETF	310.64	310.64	310.64	310.64	1000.0
2019-11-20 05:20:00	SPY	ETF	310.67	310.67	310.65	310.65	800.0
2019-11-20 05:21:00	SPY	ETF	310.68	310.68	310.68	310.68	300.0
2019-11-20 05:23:00	SPY	ETF	310.74	310.77	310.74	310.77	900.0
2019-11-20 05:24:00	SPY	ETF	310.74	310.74	310.74	310.74	600.0
2019-11-20 05:25:00	SPY	ETF	310.72	310.72	310.72	310.72	100.0
2019-11-20 05:28:00	SPY	ETF	310.6	310.63	310.6	310.63	400.0
2019-11-20 05:40:00	SPY	ETF	310.58	310.64	310.58	310.6	1700.0
2019-11-20 05:41:00	SPY	ETF	310.58	310.58	310.58	310.58	100.0
2019-11-20 05:42:00	SPY	ETF	310.58	310.6	310.58	310.6	4100.0
2019-11-20 05:44:00	SPY	ETF	310.62	310.62	310.62	310.62	150.0
2019-11-20 05:49:00	SPY	ETF	310.67	310.7	310.67	310.7	1200.0
2019-11-20 05:50:00	SPY	ETF	310.68	310.7	310.68	310.7	2600.0
2019-11-20 05:51:00	SPY	ETF	310.7	310.7	310.69	310.69	601.0

> showing 50 of 166,044 rows — these rows as CSV

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