PREVIEW / etf_5min / 2019-04-23

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-04-23.parquet
  size:    1.5 MB
  rows:    63,986

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-04-23 04:00:00	SPY	ETF	290.22	290.22	290.22	290.22	150.0
2019-04-23 04:05:00	SPY	ETF	290.21	290.27	290.21	290.27	464.0
2019-04-23 04:10:00	SPY	ETF	290.42	290.42	290.39	290.4	1728.0
2019-04-23 04:15:00	SPY	ETF	290.39	290.39	290.39	290.39	260.0
2019-04-23 04:20:00	SPY	ETF	290.35	290.39	290.35	290.39	232.0
2019-04-23 04:25:00	SPY	ETF	290.39	290.39	290.39	290.39	300.0
2019-04-23 04:30:00	SPY	ETF	290.37	290.37	290.37	290.37	510.0
2019-04-23 04:40:00	SPY	ETF	290.33	290.33	290.33	290.33	800.0
2019-04-23 04:45:00	SPY	ETF	290.32	290.38	290.32	290.38	1900.0
2019-04-23 04:55:00	SPY	ETF	290.36	290.36	290.36	290.36	300.0
2019-04-23 05:00:00	SPY	ETF	290.28	290.28	290.28	290.28	700.0
2019-04-23 05:10:00	SPY	ETF	290.26	290.26	290.26	290.26	400.0
2019-04-23 05:15:00	SPY	ETF	290.23	290.28	290.23	290.28	370.0
2019-04-23 05:20:00	SPY	ETF	290.26	290.27	290.26	290.27	800.0
2019-04-23 05:25:00	SPY	ETF	290.23	290.23	290.23	290.23	300.0
2019-04-23 05:35:00	SPY	ETF	290.16	290.16	290.16	290.16	500.0
2019-04-23 05:40:00	SPY	ETF	290.21	290.21	290.19	290.19	1119.0
2019-04-23 05:45:00	SPY	ETF	290.21	290.21	290.21	290.21	571.0
2019-04-23 05:50:00	SPY	ETF	290.15	290.15	290.15	290.15	600.0
2019-04-23 05:55:00	SPY	ETF	290.14	290.16	290.14	290.15	740.0
2019-04-23 06:00:00	SPY	ETF	290.19	290.19	290.19	290.19	300.0
2019-04-23 06:05:00	SPY	ETF	290.2	290.2	290.2	290.2	300.0
2019-04-23 06:15:00	SPY	ETF	290.21	290.21	290.21	290.21	1100.0
2019-04-23 06:20:00	SPY	ETF	290.21	290.21	290.19	290.19	1200.0
2019-04-23 06:30:00	SPY	ETF	290.17	290.17	290.17	290.17	200.0
2019-04-23 06:50:00	SPY	ETF	290.19	290.19	290.19	290.19	3300.0
2019-04-23 06:55:00	SPY	ETF	290.2	290.2	290.2	290.2	1425.0
2019-04-23 07:00:00	SPY	ETF	290.22	290.28	290.21	290.28	3003.0
2019-04-23 07:05:00	SPY	ETF	290.29	290.29	290.25	290.27	5450.0
2019-04-23 07:10:00	SPY	ETF	290.27	290.3	290.25	290.3	2037.0
2019-04-23 07:15:00	SPY	ETF	290.26	290.26	290.26	290.26	240.0
2019-04-23 07:20:00	SPY	ETF	290.3	290.3	290.25	290.26	1508.0
2019-04-23 07:25:00	SPY	ETF	290.26	290.26	290.24	290.25	15130.0
2019-04-23 07:30:00	SPY	ETF	290.27	290.29	290.25	290.27	7175.0
2019-04-23 07:35:00	SPY	ETF	290.32	290.34	290.32	290.34	5317.0
2019-04-23 07:40:00	SPY	ETF	290.37	290.45	290.37	290.45	6865.0
2019-04-23 07:45:00	SPY	ETF	290.46	290.57	290.46	290.55	8867.0
2019-04-23 07:50:00	SPY	ETF	290.57	290.64	290.56	290.56	5009.0
2019-04-23 07:55:00	SPY	ETF	290.52	290.58	290.52	290.57	8497.0
2019-04-23 08:00:00	SPY	ETF	290.25	290.65	290.21	290.57	19445.0
2019-04-23 08:05:00	SPY	ETF	290.56	290.85	290.56	290.82	25088.0
2019-04-23 08:10:00	SPY	ETF	290.81	290.84	290.77	290.7799	19031.0
2019-04-23 08:15:00	SPY	ETF	290.81	290.85	290.77	290.85	14740.0
2019-04-23 08:20:00	SPY	ETF	290.85	290.86	290.83	290.84	9976.0
2019-04-23 08:25:00	SPY	ETF	290.82	290.8299	290.73	290.81	55114.0
2019-04-23 08:30:00	SPY	ETF	290.79	290.8	290.71	290.72	13663.0
2019-04-23 08:35:00	SPY	ETF	290.72	290.73	290.66	290.67	88679.0
2019-04-23 08:40:00	SPY	ETF	290.67	290.69	290.64	290.64	23448.0
2019-04-23 08:45:00	SPY	ETF	290.61	290.61	290.53	290.53	17376.0
2019-04-23 08:50:00	SPY	ETF	290.54	290.65	290.53	290.65	41612.0

> showing 50 of 63,986 rows — these rows as CSV

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