PREVIEW / etf_5min / 2019-06-19

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-06-19.parquet
  size:    1.4 MB
  rows:    61,768

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-06-19 04:00:00	SPY	ETF	292.59	292.73	292.59	292.65	1590.0
2019-06-19 04:05:00	SPY	ETF	292.7	292.7	292.58	292.58	723.0
2019-06-19 04:10:00	SPY	ETF	292.6	292.6	292.6	292.6	300.0
2019-06-19 04:15:00	SPY	ETF	292.57	292.61	292.57	292.61	2600.0
2019-06-19 04:20:00	SPY	ETF	292.52	292.61	292.48	292.57	4692.0
2019-06-19 04:25:00	SPY	ETF	292.59	292.59	292.57	292.57	1488.0
2019-06-19 04:35:00	SPY	ETF	292.5	292.5	292.47	292.47	300.0
2019-06-19 04:45:00	SPY	ETF	292.4	292.41	292.34	292.41	1601.0
2019-06-19 04:50:00	SPY	ETF	292.29	292.29	292.29	292.29	142.0
2019-06-19 04:55:00	SPY	ETF	292.22	292.32	292.19	292.32	911.0
2019-06-19 05:00:00	SPY	ETF	292.33	292.39	292.32	292.38	670.0
2019-06-19 05:05:00	SPY	ETF	292.36	292.36	292.36	292.36	100.0
2019-06-19 05:15:00	SPY	ETF	292.46	292.46	292.46	292.46	100.0
2019-06-19 05:25:00	SPY	ETF	292.48	292.54	292.32	292.32	2308.0
2019-06-19 05:30:00	SPY	ETF	292.41	292.41	292.41	292.41	400.0
2019-06-19 05:40:00	SPY	ETF	292.5	292.5	292.5	292.5	300.0
2019-06-19 05:45:00	SPY	ETF	292.49	292.49	292.44	292.44	200.0
2019-06-19 05:50:00	SPY	ETF	292.62	292.62	292.62	292.62	1583.0
2019-06-19 05:55:00	SPY	ETF	292.57	292.57	292.57	292.57	200.0
2019-06-19 06:05:00	SPY	ETF	292.49	292.49	292.48	292.48	422.0
2019-06-19 06:10:00	SPY	ETF	292.49	292.49	292.49	292.49	210.0
2019-06-19 06:15:00	SPY	ETF	292.53	292.66	292.49	292.66	2500.0
2019-06-19 06:20:00	SPY	ETF	292.69	292.69	292.59	292.64	6315.0
2019-06-19 06:25:00	SPY	ETF	292.65	292.7	292.63	292.7	8800.0
2019-06-19 06:30:00	SPY	ETF	292.77	292.77	292.7	292.7	900.0
2019-06-19 06:35:00	SPY	ETF	292.75	292.75	292.74	292.74	600.0
2019-06-19 06:40:00	SPY	ETF	292.58	292.58	292.58	292.58	200.0
2019-06-19 06:50:00	SPY	ETF	292.69	292.69	292.69	292.69	669.0
2019-06-19 06:55:00	SPY	ETF	292.69	292.69	292.67	292.67	3319.0
2019-06-19 07:00:00	SPY	ETF	292.67	292.68	292.65	292.66	13110.0
2019-06-19 07:05:00	SPY	ETF	292.64	292.64	292.5	292.5	8692.0
2019-06-19 07:10:00	SPY	ETF	292.5	292.5	292.49	292.49	969.0
2019-06-19 07:15:00	SPY	ETF	292.52	292.55	292.46	292.55	1079.0
2019-06-19 07:20:00	SPY	ETF	292.52	292.55	292.52	292.53	4000.0
2019-06-19 07:25:00	SPY	ETF	292.52	292.54	292.51	292.51	11610.0
2019-06-19 07:30:00	SPY	ETF	292.52	292.53	292.52	292.52	3490.0
2019-06-19 07:35:00	SPY	ETF	292.51	292.51	292.48	292.51	1000.0
2019-06-19 07:40:00	SPY	ETF	292.5	292.58	292.5	292.58	4107.0
2019-06-19 07:45:00	SPY	ETF	292.58	292.59	292.55	292.55	5904.0
2019-06-19 07:50:00	SPY	ETF	292.6	292.66	292.6	292.64	2849.0
2019-06-19 07:55:00	SPY	ETF	292.65	292.69	292.65	292.69	1097.0
2019-06-19 08:00:00	SPY	ETF	292.67	292.67	292.54	292.58	15157.0
2019-06-19 08:05:00	SPY	ETF	292.65	292.65	292.65	292.65	961.0
2019-06-19 08:10:00	SPY	ETF	292.64	292.67	292.64	292.66	1465.0
2019-06-19 08:15:00	SPY	ETF	292.66	292.68	292.61	292.62	2793.0
2019-06-19 08:20:00	SPY	ETF	292.59	292.62	292.56	292.62	9596.0
2019-06-19 08:25:00	SPY	ETF	292.67	292.67	292.65	292.65	400.0
2019-06-19 08:30:00	SPY	ETF	292.64	292.7	292.58	292.66	29558.0
2019-06-19 08:35:00	SPY	ETF	292.67	292.78	292.64	292.75	6960.0
2019-06-19 08:40:00	SPY	ETF	292.75	292.7597	292.72	292.74	15481.0

> showing 50 of 61,768 rows — these rows as CSV

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