PREVIEW / etf_5min / 2019-07-09

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-07-09.parquet
  size:    1.4 MB
  rows:    60,421

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-09 04:00:00	SPY	ETF	295.39	295.48	295.39	295.48	1550.0
2019-07-09 04:05:00	SPY	ETF	295.38	295.38	295.33	295.33	550.0
2019-07-09 04:10:00	SPY	ETF	295.31	295.31	295.31	295.31	200.0
2019-07-09 04:20:00	SPY	ETF	295.4	295.4	295.4	295.4	2300.0
2019-07-09 04:25:00	SPY	ETF	295.48	295.5	295.48	295.5	400.0
2019-07-09 04:30:00	SPY	ETF	295.45	295.45	295.45	295.45	300.0
2019-07-09 04:35:00	SPY	ETF	295.45	295.45	295.45	295.45	100.0
2019-07-09 04:40:00	SPY	ETF	295.45	295.45	295.33	295.33	200.0
2019-07-09 04:45:00	SPY	ETF	295.3	295.38	295.3	295.32	1003.0
2019-07-09 04:50:00	SPY	ETF	295.5	295.5	295.5	295.5	377.0
2019-07-09 04:55:00	SPY	ETF	295.5	295.51	295.5	295.5	2475.0
2019-07-09 05:00:00	SPY	ETF	295.5	295.5	295.48	295.48	1408.0
2019-07-09 05:05:00	SPY	ETF	295.53	295.55	295.47	295.47	11038.0
2019-07-09 05:10:00	SPY	ETF	295.48	295.48	295.31	295.31	976.0
2019-07-09 05:15:00	SPY	ETF	295.36	295.38	295.36	295.38	290.0
2019-07-09 05:20:00	SPY	ETF	295.38	295.38	295.38	295.38	100.0
2019-07-09 05:25:00	SPY	ETF	295.4	295.4	295.38	295.38	1120.0
2019-07-09 05:30:00	SPY	ETF	295.35	295.35	295.31	295.31	3300.0
2019-07-09 05:50:00	SPY	ETF	295.35	295.41	295.33	295.4	1600.0
2019-07-09 05:55:00	SPY	ETF	295.48	295.48	295.41	295.43	2443.0
2019-07-09 06:00:00	SPY	ETF	295.41	295.41	295.33	295.33	2951.0
2019-07-09 06:05:00	SPY	ETF	295.51	295.53	295.48	295.53	3100.0
2019-07-09 06:10:00	SPY	ETF	295.58	295.58	295.5	295.5	1900.0
2019-07-09 06:15:00	SPY	ETF	295.53	295.53	295.53	295.53	970.0
2019-07-09 06:20:00	SPY	ETF	295.46	295.56	295.46	295.56	1523.0
2019-07-09 06:25:00	SPY	ETF	295.55	295.58	295.5	295.53	4000.0
2019-07-09 06:30:00	SPY	ETF	295.62	295.69	295.62	295.63	2660.0
2019-07-09 06:35:00	SPY	ETF	295.63	295.71	295.63	295.71	3569.0
2019-07-09 06:40:00	SPY	ETF	295.68	295.68	295.68	295.68	250.0
2019-07-09 06:45:00	SPY	ETF	295.68	295.7	295.68	295.7	925.0
2019-07-09 06:50:00	SPY	ETF	295.75	295.78	295.59	295.59	7525.0
2019-07-09 06:55:00	SPY	ETF	295.62	295.73	295.62	295.64	3090.0
2019-07-09 07:00:00	SPY	ETF	295.7	295.72	295.62	295.67	5805.0
2019-07-09 07:05:00	SPY	ETF	295.76	295.76	295.71	295.73	12213.0
2019-07-09 07:10:00	SPY	ETF	295.7	295.73	295.67	295.67	794.0
2019-07-09 07:15:00	SPY	ETF	295.69	295.69	295.69	295.69	100.0
2019-07-09 07:20:00	SPY	ETF	295.68	295.75	295.68	295.72	5450.0
2019-07-09 07:25:00	SPY	ETF	295.8	295.82	295.8	295.8	8725.0
2019-07-09 07:30:00	SPY	ETF	295.79	295.81	295.79	295.8	2386.0
2019-07-09 07:35:00	SPY	ETF	295.72	295.73	295.68	295.68	5750.0
2019-07-09 07:40:00	SPY	ETF	295.68	295.7	295.67	295.67	539.0
2019-07-09 07:45:00	SPY	ETF	295.7	295.72	295.67	295.72	13208.0
2019-07-09 07:50:00	SPY	ETF	295.73	295.74	295.7	295.74	15119.0
2019-07-09 07:55:00	SPY	ETF	295.74	295.74	295.7	295.73	14932.0
2019-07-09 08:00:00	SPY	ETF	295.71	295.8	295.67	295.75	47888.0
2019-07-09 08:05:00	SPY	ETF	295.79	295.8	295.65	295.67	18855.0
2019-07-09 08:10:00	SPY	ETF	295.67	295.74	295.67	295.71	41040.0
2019-07-09 08:15:00	SPY	ETF	295.71	295.87	295.67	295.8	144290.0
2019-07-09 08:20:00	SPY	ETF	295.79	295.83	295.76	295.83	9200.0
2019-07-09 08:25:00	SPY	ETF	295.83	295.83	295.75	295.75	7879.0

> showing 50 of 60,421 rows — these rows as CSV

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