PREVIEW / etf_5min / 2019-07-03

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-07-03.parquet
  size:    949 KB
  rows:    38,345

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-03 04:00:00	SPY	ETF	297.16	297.23	297.13	297.15	3890.0
2019-07-03 04:05:00	SPY	ETF	297.19	297.29	297.19	297.29	2476.0
2019-07-03 04:10:00	SPY	ETF	297.31	297.31	297.3	297.3	7870.0
2019-07-03 04:15:00	SPY	ETF	297.24	297.25	297.23	297.23	801.0
2019-07-03 04:20:00	SPY	ETF	297.28	297.28	297.23	297.23	330.0
2019-07-03 04:35:00	SPY	ETF	297.34	297.35	297.34	297.35	515.0
2019-07-03 04:40:00	SPY	ETF	297.42	297.42	297.42	297.42	220.0
2019-07-03 04:50:00	SPY	ETF	297.49	297.5	297.45	297.45	1429.0
2019-07-03 04:55:00	SPY	ETF	297.5	297.56	297.5	297.5	3450.0
2019-07-03 05:00:00	SPY	ETF	297.55	297.57	297.55	297.56	2380.0
2019-07-03 05:05:00	SPY	ETF	297.53	297.53	297.53	297.53	360.0
2019-07-03 05:10:00	SPY	ETF	297.51	297.59	297.51	297.58	500.0
2019-07-03 05:15:00	SPY	ETF	297.58	297.66	297.58	297.66	3400.0
2019-07-03 05:20:00	SPY	ETF	297.63	297.63	297.63	297.63	100.0
2019-07-03 05:30:00	SPY	ETF	297.58	297.58	297.58	297.58	230.0
2019-07-03 05:35:00	SPY	ETF	297.53	297.53	297.53	297.53	100.0
2019-07-03 05:40:00	SPY	ETF	297.56	297.56	297.56	297.56	100.0
2019-07-03 05:50:00	SPY	ETF	297.56	297.56	297.56	297.56	610.0
2019-07-03 05:55:00	SPY	ETF	297.6	297.6	297.6	297.6	100.0
2019-07-03 06:00:00	SPY	ETF	297.55	297.55	297.5	297.53	2500.0
2019-07-03 06:05:00	SPY	ETF	297.58	297.63	297.58	297.63	2500.0
2019-07-03 06:10:00	SPY	ETF	297.63	297.63	297.63	297.63	100.0
2019-07-03 06:15:00	SPY	ETF	297.65	297.69	297.65	297.65	1700.0
2019-07-03 06:20:00	SPY	ETF	297.6	297.6	297.6	297.6	500.0
2019-07-03 06:25:00	SPY	ETF	297.62	297.62	297.6	297.6	800.0
2019-07-03 06:35:00	SPY	ETF	297.6	297.65	297.58	297.65	2700.0
2019-07-03 06:40:00	SPY	ETF	297.65	297.66	297.63	297.65	8600.0
2019-07-03 06:45:00	SPY	ETF	297.63	297.68	297.6	297.65	18650.0
2019-07-03 06:55:00	SPY	ETF	297.67	297.68	297.64	297.68	6490.0
2019-07-03 07:00:00	SPY	ETF	297.63	297.7	297.57	297.57	10829.0
2019-07-03 07:05:00	SPY	ETF	297.57	297.6	297.57	297.59	2625.0
2019-07-03 07:10:00	SPY	ETF	297.59	297.62	297.59	297.62	4380.0
2019-07-03 07:15:00	SPY	ETF	297.59	297.62	297.58	297.58	11975.0
2019-07-03 07:20:00	SPY	ETF	297.58	297.58	297.51	297.51	4920.0
2019-07-03 07:25:00	SPY	ETF	297.53	297.56	297.47	297.5	3138.0
2019-07-03 07:30:00	SPY	ETF	297.5	297.51	297.46	297.49	6877.0
2019-07-03 07:35:00	SPY	ETF	297.49	297.53	297.46	297.49	16499.0
2019-07-03 07:40:00	SPY	ETF	297.53	297.54	297.49	297.54	24389.0
2019-07-03 07:45:00	SPY	ETF	297.52	297.54	297.5	297.52	5317.0
2019-07-03 07:50:00	SPY	ETF	297.46	297.46	297.41	297.41	469.0
2019-07-03 07:55:00	SPY	ETF	297.44	297.44	297.39	297.39	6024.0
2019-07-03 08:00:00	SPY	ETF	297.63	297.68	296.41	297.48	19866.0
2019-07-03 08:05:00	SPY	ETF	297.48	297.55	297.48	297.53	6840.0
2019-07-03 08:10:00	SPY	ETF	297.49	297.5	297.4	297.4	3139.0
2019-07-03 08:15:00	SPY	ETF	297.35	297.47	297.33	297.42	64026.0
2019-07-03 08:20:00	SPY	ETF	297.42	297.47	296.43	297.42	121329.0
2019-07-03 08:25:00	SPY	ETF	297.4	297.5	297.4	297.49	5861.0
2019-07-03 08:30:00	SPY	ETF	297.5	297.51	297.36	297.37	23450.0
2019-07-03 08:35:00	SPY	ETF	297.375	297.39	297.36	297.37	5775.0
2019-07-03 08:40:00	SPY	ETF	297.35	297.35	297.29	297.35	26320.0

> showing 50 of 38,345 rows — these rows as CSV

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