PREVIEW / etf_5min / 2019-04-05

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-04-05.parquet
  size:    1.4 MB
  rows:    60,740

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-05 04:00:00	SPY	ETF	287.52	287.72	287.52	287.69	2549.0
2019-04-05 04:10:00	SPY	ETF	287.77	287.77	287.77	287.77	230.0
2019-04-05 04:20:00	SPY	ETF	287.7	287.7	287.68	287.7	360.0
2019-04-05 04:25:00	SPY	ETF	287.62	287.62	287.6	287.62	430.0
2019-04-05 04:30:00	SPY	ETF	287.6	287.6	287.6	287.6	100.0
2019-04-05 04:35:00	SPY	ETF	287.67	287.67	287.67	287.67	100.0
2019-04-05 04:45:00	SPY	ETF	287.62	287.62	287.62	287.62	100.0
2019-04-05 04:50:00	SPY	ETF	287.63	287.67	287.63	287.67	1420.0
2019-04-05 04:55:00	SPY	ETF	287.67	287.67	287.65	287.65	400.0
2019-04-05 05:00:00	SPY	ETF	287.6	287.62	287.6	287.62	421.0
2019-04-05 05:05:00	SPY	ETF	287.62	287.62	287.62	287.62	500.0
2019-04-05 05:10:00	SPY	ETF	287.65	287.65	287.65	287.65	1500.0
2019-04-05 05:20:00	SPY	ETF	287.57	287.57	287.57	287.57	200.0
2019-04-05 05:30:00	SPY	ETF	287.57	287.6	287.57	287.6	850.0
2019-04-05 05:35:00	SPY	ETF	287.58	287.62	287.58	287.62	1600.0
2019-04-05 05:40:00	SPY	ETF	287.67	287.67	287.62	287.62	1800.0
2019-04-05 05:45:00	SPY	ETF	287.7	287.7	287.65	287.65	600.0
2019-04-05 05:50:00	SPY	ETF	287.67	287.67	287.67	287.67	200.0
2019-04-05 06:00:00	SPY	ETF	287.64	287.67	287.5	287.5	8420.0
2019-04-05 06:05:00	SPY	ETF	287.53	287.57	287.53	287.57	1183.0
2019-04-05 06:10:00	SPY	ETF	287.56	287.6	287.56	287.6	907.0
2019-04-05 06:15:00	SPY	ETF	287.6	287.6	287.59	287.6	2269.0
2019-04-05 06:20:00	SPY	ETF	287.58	287.6	287.58	287.6	907.0
2019-04-05 06:25:00	SPY	ETF	287.56	287.6	287.56	287.6	1175.0
2019-04-05 06:30:00	SPY	ETF	287.61	287.65	287.61	287.65	1045.0
2019-04-05 06:35:00	SPY	ETF	287.66	287.68	287.66	287.67	857.0
2019-04-05 06:40:00	SPY	ETF	287.64	287.64	287.64	287.64	169.0
2019-04-05 06:45:00	SPY	ETF	287.65	287.67	287.65	287.67	488.0
2019-04-05 06:50:00	SPY	ETF	287.66	287.68	287.66	287.67	2038.0
2019-04-05 06:55:00	SPY	ETF	287.67	287.7	287.67	287.7	4669.0
2019-04-05 07:00:00	SPY	ETF	287.64	287.64	287.64	287.64	2500.0
2019-04-05 07:05:00	SPY	ETF	287.67	287.7	287.54	287.57	9000.0
2019-04-05 07:10:00	SPY	ETF	287.58	287.6	287.58	287.6	50484.0
2019-04-05 07:15:00	SPY	ETF	287.6	287.6	287.6	287.6	4200.0
2019-04-05 07:20:00	SPY	ETF	287.58	287.58	287.58	287.58	260.0
2019-04-05 07:25:00	SPY	ETF	287.6	287.6	287.59	287.6	19300.0
2019-04-05 07:30:00	SPY	ETF	287.53	287.57	287.5	287.52	22547.0
2019-04-05 07:35:00	SPY	ETF	287.52	287.52	287.44	287.46	27488.0
2019-04-05 07:40:00	SPY	ETF	287.48	287.51	287.48	287.49	1950.0
2019-04-05 07:45:00	SPY	ETF	287.49	287.49	287.46	287.49	1985.0
2019-04-05 07:50:00	SPY	ETF	287.49	287.53	287.44	287.46	32309.0
2019-04-05 07:55:00	SPY	ETF	287.48	287.52	287.48	287.5	4040.0
2019-04-05 08:00:00	SPY	ETF	287.58	287.68	287.5	287.6	26094.0
2019-04-05 08:05:00	SPY	ETF	287.54	287.55	287.48	287.5	41193.0
2019-04-05 08:10:00	SPY	ETF	287.48	287.5	287.45	287.5	40224.0
2019-04-05 08:15:00	SPY	ETF	287.49	287.57	287.49	287.53	2408.0
2019-04-05 08:20:00	SPY	ETF	287.52	287.53	287.5	287.5	3226.0
2019-04-05 08:25:00	SPY	ETF	287.57	287.6	287.48	287.5	46310.0
2019-04-05 08:30:00	SPY	ETF	287.57	288.28	287.57	288.08	218217.0
2019-04-05 08:35:00	SPY	ETF	288.07	288.21	288.02	288.06	97557.0

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

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