PREVIEW / etf_5min / 2017-03-07

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-03-07.parquet
  size:    1.2 MB
  rows:    54,134

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
2017-03-07 04:00:00	SPY	ETF	237.64	237.64	237.64	237.64	2010.0
2017-03-07 04:05:00	SPY	ETF	237.64	237.64	237.64	237.64	1000.0
2017-03-07 04:10:00	SPY	ETF	237.59	237.59	237.58	237.58	1400.0
2017-03-07 04:25:00	SPY	ETF	237.52	237.52	237.52	237.52	300.0
2017-03-07 04:35:00	SPY	ETF	237.47	237.47	237.47	237.47	100.0
2017-03-07 04:40:00	SPY	ETF	237.52	237.57	237.52	237.57	250.0
2017-03-07 05:10:00	SPY	ETF	237.57	237.57	237.57	237.57	300.0
2017-03-07 05:20:00	SPY	ETF	237.54	237.54	237.54	237.54	300.0
2017-03-07 05:25:00	SPY	ETF	237.54	237.54	237.54	237.54	400.0
2017-03-07 05:30:00	SPY	ETF	237.49	237.49	237.44	237.44	800.0
2017-03-07 05:35:00	SPY	ETF	237.49	237.49	237.49	237.49	900.0
2017-03-07 05:40:00	SPY	ETF	237.47	237.47	237.47	237.47	100.0
2017-03-07 05:45:00	SPY	ETF	237.46	237.46	237.46	237.46	100.0
2017-03-07 05:50:00	SPY	ETF	237.44	237.44	237.44	237.44	500.0
2017-03-07 05:55:00	SPY	ETF	237.4	237.44	237.4	237.44	700.0
2017-03-07 06:00:00	SPY	ETF	237.37	237.38	237.37	237.38	600.0
2017-03-07 06:25:00	SPY	ETF	237.47	237.47	237.47	237.47	400.0
2017-03-07 06:30:00	SPY	ETF	237.47	237.49	237.47	237.49	2400.0
2017-03-07 06:35:00	SPY	ETF	237.47	237.47	237.47	237.47	200.0
2017-03-07 06:40:00	SPY	ETF	237.44	237.44	237.44	237.44	700.0
2017-03-07 06:55:00	SPY	ETF	237.47	237.47	237.42	237.42	6100.0
2017-03-07 07:00:00	SPY	ETF	237.38	237.42	237.38	237.41	2800.0
2017-03-07 07:05:00	SPY	ETF	237.42	237.42	237.41	237.41	6100.0
2017-03-07 07:10:00	SPY	ETF	237.41	237.42	237.41	237.42	800.0
2017-03-07 07:15:00	SPY	ETF	237.42	237.42	237.38	237.38	25400.0
2017-03-07 07:20:00	SPY	ETF	237.38	237.4	237.38	237.4	25446.0
2017-03-07 07:30:00	SPY	ETF	237.46	237.49	237.46	237.48	12800.0
2017-03-07 07:35:00	SPY	ETF	237.48	237.54	237.48	237.5	20625.0
2017-03-07 07:40:00	SPY	ETF	237.55	237.55	237.51	237.51	13100.0
2017-03-07 07:45:00	SPY	ETF	237.49	237.54	237.49	237.54	1088.0
2017-03-07 07:50:00	SPY	ETF	237.49	237.52	237.49	237.52	2500.0
2017-03-07 07:55:00	SPY	ETF	237.45	237.45	237.45	237.45	20265.0
2017-03-07 08:00:00	SPY	ETF	237.39	237.55	237.39	237.52	5955.0
2017-03-07 08:05:00	SPY	ETF	237.52	237.52	237.47	237.47	1330.0
2017-03-07 08:10:00	SPY	ETF	237.47	237.47	237.4	237.4	40828.0
2017-03-07 08:15:00	SPY	ETF	237.42	237.45	237.41	237.45	3150.0
2017-03-07 08:20:00	SPY	ETF	237.45	237.45	237.34	237.35	50285.0
2017-03-07 08:25:00	SPY	ETF	237.34	237.37	237.28	237.35	20404.0
2017-03-07 08:30:00	SPY	ETF	237.35	237.4	237.34	237.4	23674.0
2017-03-07 08:35:00	SPY	ETF	237.37	237.45	237.37	237.41	14267.0
2017-03-07 08:40:00	SPY	ETF	237.41	237.44	237.38	237.44	33060.0
2017-03-07 08:45:00	SPY	ETF	237.46	237.48	237.43	237.47	27092.0
2017-03-07 08:50:00	SPY	ETF	237.48	237.48	237.43	237.46	21011.0
2017-03-07 08:55:00	SPY	ETF	237.46	237.54	237.46	237.51	26412.0
2017-03-07 09:00:00	SPY	ETF	237.51	237.51	237.44	237.49	33103.0
2017-03-07 09:05:00	SPY	ETF	237.48	237.7576	237.41	237.42	219064.0
2017-03-07 09:10:00	SPY	ETF	237.42	237.45	237.41	237.42	28625.0
2017-03-07 09:15:00	SPY	ETF	237.42	237.43	237.4	237.42	16410.0
2017-03-07 09:20:00	SPY	ETF	237.4	237.44	237.39	237.39	23525.0
2017-03-07 09:25:00	SPY	ETF	237.39	237.41	237.34	237.35	140312.0

> showing 50 of 54,134 rows — these rows as CSV

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