PREVIEW / etf_1min / 2019-07-23

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-07-23.parquet
  size:    3.0 MB
  rows:    155,390

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-07-23 04:01:00	SPY	ETF	298.45	298.47	298.45	298.47	410.0
2019-07-23 04:02:00	SPY	ETF	298.49	298.49	298.49	298.49	415.0
2019-07-23 04:04:00	SPY	ETF	298.5	298.5	298.5	298.5	437.0
2019-07-23 04:09:00	SPY	ETF	298.46	298.46	298.46	298.46	3000.0
2019-07-23 04:11:00	SPY	ETF	298.48	298.5	298.48	298.5	3160.0
2019-07-23 04:12:00	SPY	ETF	298.51	298.51	298.51	298.51	169.0
2019-07-23 04:14:00	SPY	ETF	298.54	298.6	298.54	298.6	2050.0
2019-07-23 04:15:00	SPY	ETF	298.62	298.65	298.62	298.62	600.0
2019-07-23 04:17:00	SPY	ETF	298.56	298.56	298.56	298.56	100.0
2019-07-23 04:20:00	SPY	ETF	298.53	298.53	298.53	298.53	169.0
2019-07-23 04:22:00	SPY	ETF	298.54	298.62	298.54	298.62	1345.0
2019-07-23 04:24:00	SPY	ETF	298.58	298.58	298.58	298.58	400.0
2019-07-23 04:25:00	SPY	ETF	298.58	298.58	298.58	298.58	169.0
2019-07-23 04:27:00	SPY	ETF	298.56	298.56	298.56	298.56	169.0
2019-07-23 04:30:00	SPY	ETF	298.57	298.57	298.57	298.57	100.0
2019-07-23 04:32:00	SPY	ETF	298.54	298.62	298.54	298.62	776.0
2019-07-23 04:33:00	SPY	ETF	298.62	298.78	298.62	298.74	2400.0
2019-07-23 04:34:00	SPY	ETF	298.74	298.75	298.73	298.73	1700.0
2019-07-23 04:37:00	SPY	ETF	298.7	298.7	298.7	298.7	169.0
2019-07-23 04:38:00	SPY	ETF	298.68	298.68	298.68	298.68	169.0
2019-07-23 04:42:00	SPY	ETF	298.66	298.66	298.66	298.66	169.0
2019-07-23 04:43:00	SPY	ETF	298.65	298.65	298.65	298.65	131.0
2019-07-23 04:44:00	SPY	ETF	298.69	298.7	298.69	298.7	338.0
2019-07-23 04:45:00	SPY	ETF	298.72	298.72	298.72	298.72	169.0
2019-07-23 04:46:00	SPY	ETF	298.68	298.68	298.68	298.68	200.0
2019-07-23 04:47:00	SPY	ETF	298.74	298.74	298.74	298.74	169.0
2019-07-23 04:48:00	SPY	ETF	298.76	298.76	298.76	298.76	169.0
2019-07-23 04:54:00	SPY	ETF	298.8	298.8	298.8	298.8	100.0
2019-07-23 05:02:00	SPY	ETF	298.75	298.75	298.75	298.75	169.0
2019-07-23 05:03:00	SPY	ETF	298.75	298.75	298.75	298.75	1000.0
2019-07-23 05:04:00	SPY	ETF	298.73	298.73	298.73	298.73	169.0
2019-07-23 05:05:00	SPY	ETF	298.72	298.72	298.72	298.72	200.0
2019-07-23 05:06:00	SPY	ETF	298.72	298.72	298.72	298.72	800.0
2019-07-23 05:08:00	SPY	ETF	298.71	298.71	298.7	298.7	338.0
2019-07-23 05:17:00	SPY	ETF	298.71	298.71	298.7	298.7	300.0
2019-07-23 05:19:00	SPY	ETF	298.74	298.75	298.74	298.75	1794.0
2019-07-23 05:20:00	SPY	ETF	298.75	298.75	298.71	298.71	1375.0
2019-07-23 05:22:00	SPY	ETF	298.76	298.76	298.76	298.76	500.0
2019-07-23 05:23:00	SPY	ETF	298.75	298.75	298.75	298.75	500.0
2019-07-23 05:34:00	SPY	ETF	298.76	298.76	298.76	298.76	210.0
2019-07-23 05:35:00	SPY	ETF	298.76	298.76	298.76	298.76	200.0
2019-07-23 05:39:00	SPY	ETF	298.75	298.75	298.75	298.75	200.0
2019-07-23 05:45:00	SPY	ETF	298.75	298.75	298.75	298.75	200.0
2019-07-23 05:55:00	SPY	ETF	298.74	298.74	298.74	298.74	100.0
2019-07-23 06:00:00	SPY	ETF	298.75	298.78	298.75	298.78	1462.0
2019-07-23 06:05:00	SPY	ETF	298.78	298.78	298.78	298.78	750.0
2019-07-23 06:12:00	SPY	ETF	298.78	298.88	298.78	298.88	2007.0
2019-07-23 06:14:00	SPY	ETF	298.88	298.88	298.88	298.88	1269.0
2019-07-23 06:15:00	SPY	ETF	298.93	298.93	298.93	298.93	4931.0
2019-07-23 06:17:00	SPY	ETF	298.92	298.92	298.92	298.92	100.0

> showing 50 of 155,390 rows — these rows as CSV

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