PREVIEW / etf_1min / 2019-01-29

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-01-29.parquet
  size:    3.2 MB
  rows:    169,151

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-29 04:01:00	SPY	ETF	263.37	263.37	263.37	263.37	233.0
2019-01-29 04:02:00	SPY	ETF	263.32	263.32	263.32	263.32	296.0
2019-01-29 04:05:00	SPY	ETF	263.45	263.45	263.45	263.45	180.0
2019-01-29 04:07:00	SPY	ETF	263.36	263.36	263.36	263.36	100.0
2019-01-29 04:08:00	SPY	ETF	263.36	263.36	263.36	263.36	300.0
2019-01-29 04:10:00	SPY	ETF	263.36	263.36	263.36	263.36	100.0
2019-01-29 04:12:00	SPY	ETF	263.44	263.44	263.44	263.44	100.0
2019-01-29 04:14:00	SPY	ETF	263.5	263.51	263.5	263.51	810.0
2019-01-29 04:15:00	SPY	ETF	263.61	263.68	263.61	263.68	550.0
2019-01-29 04:16:00	SPY	ETF	263.56	263.56	263.56	263.56	150.0
2019-01-29 04:19:00	SPY	ETF	263.65	263.65	263.65	263.65	250.0
2019-01-29 04:20:00	SPY	ETF	263.56	263.56	263.56	263.56	1000.0
2019-01-29 04:23:00	SPY	ETF	263.53	263.53	263.53	263.53	602.0
2019-01-29 04:25:00	SPY	ETF	263.53	263.53	263.53	263.53	908.0
2019-01-29 04:35:00	SPY	ETF	263.57	263.57	263.53	263.53	650.0
2019-01-29 04:38:00	SPY	ETF	263.55	263.55	263.55	263.55	100.0
2019-01-29 04:40:00	SPY	ETF	263.4	263.4	263.4	263.4	250.0
2019-01-29 04:43:00	SPY	ETF	263.45	263.45	263.45	263.45	100.0
2019-01-29 04:47:00	SPY	ETF	263.35	263.35	263.35	263.35	100.0
2019-01-29 04:51:00	SPY	ETF	263.4	263.4	263.4	263.4	110.0
2019-01-29 04:58:00	SPY	ETF	263.52	263.52	263.52	263.52	500.0
2019-01-29 04:59:00	SPY	ETF	263.57	263.57	263.57	263.57	300.0
2019-01-29 05:01:00	SPY	ETF	263.57	263.57	263.57	263.57	100.0
2019-01-29 05:04:00	SPY	ETF	263.45	263.45	263.45	263.45	250.0
2019-01-29 05:07:00	SPY	ETF	263.5	263.57	263.5	263.57	750.0
2019-01-29 05:08:00	SPY	ETF	263.59	263.59	263.59	263.59	1000.0
2019-01-29 05:09:00	SPY	ETF	263.68	263.76	263.68	263.76	2353.0
2019-01-29 05:10:00	SPY	ETF	263.74	263.76	263.74	263.76	900.0
2019-01-29 05:11:00	SPY	ETF	263.71	263.71	263.71	263.71	100.0
2019-01-29 05:21:00	SPY	ETF	263.73	263.73	263.73	263.73	1300.0
2019-01-29 05:22:00	SPY	ETF	263.77	263.77	263.73	263.73	500.0
2019-01-29 05:25:00	SPY	ETF	263.7	263.7	263.68	263.68	300.0
2019-01-29 05:26:00	SPY	ETF	263.69	263.69	263.69	263.69	300.0
2019-01-29 05:28:00	SPY	ETF	263.72	263.72	263.72	263.72	250.0
2019-01-29 05:29:00	SPY	ETF	263.68	263.73	263.68	263.73	200.0
2019-01-29 05:30:00	SPY	ETF	263.78	263.78	263.78	263.78	300.0
2019-01-29 05:33:00	SPY	ETF	263.73	263.73	263.73	263.73	3000.0
2019-01-29 05:35:00	SPY	ETF	263.75	263.82	263.75	263.82	1661.0
2019-01-29 05:37:00	SPY	ETF	263.73	263.73	263.73	263.73	100.0
2019-01-29 05:40:00	SPY	ETF	263.67	263.67	263.67	263.67	800.0
2019-01-29 05:42:00	SPY	ETF	263.67	263.67	263.67	263.67	1000.0
2019-01-29 05:43:00	SPY	ETF	263.7	263.7	263.66	263.66	955.0
2019-01-29 05:46:00	SPY	ETF	263.66	263.66	263.66	263.66	100.0
2019-01-29 05:47:00	SPY	ETF	263.68	263.7	263.68	263.7	500.0
2019-01-29 05:52:00	SPY	ETF	263.67	263.67	263.67	263.67	310.0
2019-01-29 05:55:00	SPY	ETF	263.65	263.65	263.65	263.65	600.0
2019-01-29 05:57:00	SPY	ETF	263.6	263.6	263.6	263.6	200.0
2019-01-29 05:58:00	SPY	ETF	263.58	263.58	263.58	263.58	100.0
2019-01-29 06:00:00	SPY	ETF	263.62	263.62	263.58	263.58	550.0
2019-01-29 06:08:00	SPY	ETF	263.61	263.61	263.61	263.61	100.0

> showing 50 of 169,151 rows — these rows as CSV

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