PREVIEW / etf_1min / 2019-01-09

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-01-09.parquet
  size:    3.5 MB
  rows:    185,015

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-01-09 04:01:00	SPY	ETF	257.5	257.5	257.5	257.5	1000.0
2019-01-09 04:02:00	SPY	ETF	257.42	257.45	257.42	257.45	1000.0
2019-01-09 04:03:00	SPY	ETF	257.44	257.44	257.36	257.4	1338.0
2019-01-09 04:04:00	SPY	ETF	257.42	257.42	257.38	257.39	838.0
2019-01-09 04:05:00	SPY	ETF	257.31	257.34	257.3	257.34	669.0
2019-01-09 04:06:00	SPY	ETF	257.32	257.35	257.32	257.32	1400.0
2019-01-09 04:07:00	SPY	ETF	257.4	257.4	257.33	257.33	769.0
2019-01-09 04:08:00	SPY	ETF	257.39	257.41	257.35	257.41	400.0
2019-01-09 04:09:00	SPY	ETF	257.42	257.44	257.4	257.4	669.0
2019-01-09 04:10:00	SPY	ETF	257.46	257.46	257.38	257.38	1115.0
2019-01-09 04:11:00	SPY	ETF	257.42	257.42	257.42	257.42	169.0
2019-01-09 04:12:00	SPY	ETF	257.45	257.6	257.45	257.6	3089.0
2019-01-09 04:14:00	SPY	ETF	257.5	257.5	257.46	257.48	769.0
2019-01-09 04:15:00	SPY	ETF	257.49	257.49	257.49	257.49	529.0
2019-01-09 04:16:00	SPY	ETF	257.5	257.52	257.5	257.52	800.0
2019-01-09 04:17:00	SPY	ETF	257.54	257.56	257.54	257.56	338.0
2019-01-09 04:18:00	SPY	ETF	257.54	257.54	257.48	257.48	519.0
2019-01-09 04:19:00	SPY	ETF	257.55	257.55	257.55	257.55	169.0
2019-01-09 04:20:00	SPY	ETF	257.5	257.5	257.5	257.5	500.0
2019-01-09 04:21:00	SPY	ETF	257.54	257.6	257.5	257.6	1038.0
2019-01-09 04:22:00	SPY	ETF	257.58	257.58	257.58	257.58	301.0
2019-01-09 04:23:00	SPY	ETF	257.75	257.75	257.67	257.67	4084.0
2019-01-09 04:25:00	SPY	ETF	257.65	257.65	257.65	257.65	458.0
2019-01-09 04:27:00	SPY	ETF	257.63	257.63	257.63	257.63	100.0
2019-01-09 04:28:00	SPY	ETF	257.6	257.6	257.59	257.59	693.0
2019-01-09 04:30:00	SPY	ETF	257.67	257.68	257.65	257.68	1330.0
2019-01-09 04:32:00	SPY	ETF	257.65	257.74	257.65	257.74	669.0
2019-01-09 04:33:00	SPY	ETF	257.74	257.74	257.7	257.7	300.0
2019-01-09 04:34:00	SPY	ETF	257.71	257.71	257.71	257.71	200.0
2019-01-09 04:35:00	SPY	ETF	257.74	257.74	257.72	257.72	325.0
2019-01-09 04:38:00	SPY	ETF	257.75	257.75	257.75	257.75	1494.0
2019-01-09 04:41:00	SPY	ETF	257.7	257.7	257.7	257.7	300.0
2019-01-09 04:42:00	SPY	ETF	257.75	257.75	257.68	257.68	4569.0
2019-01-09 04:45:00	SPY	ETF	257.71	257.75	257.71	257.75	2469.0
2019-01-09 04:46:00	SPY	ETF	257.77	257.77	257.77	257.77	300.0
2019-01-09 04:48:00	SPY	ETF	257.71	257.71	257.65	257.65	1838.0
2019-01-09 04:50:00	SPY	ETF	257.6	257.6	257.6	257.6	469.0
2019-01-09 04:51:00	SPY	ETF	257.57	257.57	257.54	257.54	869.0
2019-01-09 04:52:00	SPY	ETF	257.52	257.52	257.52	257.52	269.0
2019-01-09 04:54:00	SPY	ETF	257.5	257.5	257.46	257.46	500.0
2019-01-09 04:55:00	SPY	ETF	257.49	257.49	257.49	257.49	300.0
2019-01-09 04:56:00	SPY	ETF	257.55	257.55	257.49	257.49	2179.0
2019-01-09 04:57:00	SPY	ETF	257.49	257.49	257.49	257.49	1100.0
2019-01-09 04:59:00	SPY	ETF	257.54	257.54	257.54	257.54	300.0
2019-01-09 05:01:00	SPY	ETF	257.47	257.47	257.37	257.37	1808.0
2019-01-09 05:03:00	SPY	ETF	257.44	257.45	257.44	257.45	469.0
2019-01-09 05:04:00	SPY	ETF	257.44	257.44	257.44	257.44	300.0
2019-01-09 05:06:00	SPY	ETF	257.48	257.48	257.48	257.48	200.0
2019-01-09 05:08:00	SPY	ETF	257.49	257.49	257.49	257.49	300.0
2019-01-09 05:10:00	SPY	ETF	257.43	257.5	257.43	257.5	1569.0

> showing 50 of 185,015 rows — these rows as CSV

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