PREVIEW / etf_5min / 2019-07-05

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-07-05.parquet
  size:    1.3 MB
  rows:    58,914

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-05 04:00:00	SPY	ETF	298.74	298.74	298.67	298.67	660.0
2019-07-05 04:05:00	SPY	ETF	298.67	298.67	298.57	298.61	1620.0
2019-07-05 04:10:00	SPY	ETF	298.57	298.63	298.57	298.63	1850.0
2019-07-05 04:15:00	SPY	ETF	298.63	298.63	298.53	298.58	3600.0
2019-07-05 04:20:00	SPY	ETF	298.63	298.63	298.56	298.56	900.0
2019-07-05 04:25:00	SPY	ETF	298.55	298.57	298.55	298.57	2900.0
2019-07-05 04:30:00	SPY	ETF	298.57	298.65	298.57	298.65	1800.0
2019-07-05 04:35:00	SPY	ETF	298.63	298.63	298.43	298.45	2514.0
2019-07-05 04:40:00	SPY	ETF	298.5	298.5	298.5	298.5	220.0
2019-07-05 04:45:00	SPY	ETF	298.5	298.5	298.5	298.5	205.0
2019-07-05 04:50:00	SPY	ETF	298.34	298.34	298.34	298.34	500.0
2019-07-05 04:55:00	SPY	ETF	298.38	298.38	298.21	298.21	2418.0
2019-07-05 05:00:00	SPY	ETF	298.33	298.35	298.33	298.35	2347.0
2019-07-05 05:05:00	SPY	ETF	298.37	298.37	298.37	298.37	247.0
2019-07-05 05:10:00	SPY	ETF	298.34	298.34	298.34	298.34	100.0
2019-07-05 05:20:00	SPY	ETF	298.43	298.43	298.43	298.43	500.0
2019-07-05 05:25:00	SPY	ETF	298.43	298.43	298.37	298.37	2700.0
2019-07-05 05:45:00	SPY	ETF	298.4	298.4	298.33	298.33	1119.0
2019-07-05 05:50:00	SPY	ETF	298.35	298.35	298.33	298.33	400.0
2019-07-05 05:55:00	SPY	ETF	298.32	298.32	298.23	298.28	2938.0
2019-07-05 06:00:00	SPY	ETF	298.23	298.35	298.23	298.35	300.0
2019-07-05 06:05:00	SPY	ETF	298.35	298.35	298.35	298.35	1070.0
2019-07-05 06:15:00	SPY	ETF	298.36	298.4	298.35	298.4	900.0
2019-07-05 06:25:00	SPY	ETF	298.45	298.46	298.45	298.46	12900.0
2019-07-05 06:30:00	SPY	ETF	298.46	298.46	298.37	298.37	3610.0
2019-07-05 06:35:00	SPY	ETF	298.4	298.42	298.4	298.41	3700.0
2019-07-05 06:40:00	SPY	ETF	298.45	298.45	298.43	298.43	4100.0
2019-07-05 06:45:00	SPY	ETF	298.38	298.38	298.38	298.38	900.0
2019-07-05 06:50:00	SPY	ETF	298.41	298.41	298.41	298.41	500.0
2019-07-05 06:55:00	SPY	ETF	298.38	298.45	298.38	298.44	9900.0
2019-07-05 07:00:00	SPY	ETF	298.44	298.48	298.44	298.46	28623.0
2019-07-05 07:05:00	SPY	ETF	298.45	298.52	298.44	298.47	18300.0
2019-07-05 07:10:00	SPY	ETF	298.51	298.57	298.49	298.52	11775.0
2019-07-05 07:15:00	SPY	ETF	298.52	298.54	298.44	298.44	4172.0
2019-07-05 07:20:00	SPY	ETF	298.44	298.44	298.39	298.39	636.0
2019-07-05 07:25:00	SPY	ETF	298.4	298.42	298.35	298.35	4815.0
2019-07-05 07:30:00	SPY	ETF	298.35	298.35	298.3	298.32	7515.0
2019-07-05 07:35:00	SPY	ETF	298.35	298.35	298.34	298.34	6660.0
2019-07-05 07:40:00	SPY	ETF	298.35	298.39	298.35	298.37	5630.0
2019-07-05 07:45:00	SPY	ETF	298.37	298.37	298.36	298.36	18993.0
2019-07-05 07:50:00	SPY	ETF	298.37	298.38	298.37	298.38	3464.0
2019-07-05 07:55:00	SPY	ETF	298.37	298.38	298.33	298.33	21046.0
2019-07-05 08:00:00	SPY	ETF	298.44	299.19	298.24	298.3	27215.0
2019-07-05 08:05:00	SPY	ETF	298.26	298.3	298.2	298.28	20674.0
2019-07-05 08:10:00	SPY	ETF	298.28	298.31	298.24	298.29	72949.0
2019-07-05 08:15:00	SPY	ETF	298.24	298.25	298.16	298.16	62938.0
2019-07-05 08:20:00	SPY	ETF	298.15	298.18	298.11	298.15	88100.0
2019-07-05 08:25:00	SPY	ETF	298.16	298.28	298.05	298.05	95813.0
2019-07-05 08:30:00	SPY	ETF	298.07	298.59	297.89	297.95	318434.0
2019-07-05 08:35:00	SPY	ETF	297.95	298.13	297.85	297.86	149477.0

> showing 50 of 58,914 rows — these rows as CSV

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