PREVIEW / etf_5min / 2017-01-27

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-01-27.parquet
  size:    1.2 MB
  rows:    53,438

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-01-27 04:00:00	SPY	ETF	229.55	229.55	229.49	229.49	405.0
2017-01-27 04:05:00	SPY	ETF	229.5	229.5	229.5	229.5	301.0
2017-01-27 04:15:00	SPY	ETF	229.42	229.45	229.42	229.45	2502.0
2017-01-27 04:20:00	SPY	ETF	229.43	229.46	229.43	229.46	1300.0
2017-01-27 04:25:00	SPY	ETF	229.46	229.46	229.46	229.46	301.0
2017-01-27 04:35:00	SPY	ETF	229.46	229.46	229.46	229.46	303.0
2017-01-27 04:45:00	SPY	ETF	229.39	229.39	229.39	229.39	203.0
2017-01-27 04:55:00	SPY	ETF	229.28	229.28	229.28	229.28	300.0
2017-01-27 05:00:00	SPY	ETF	229.27	229.27	229.18	229.26	858.0
2017-01-27 05:05:00	SPY	ETF	229.29	229.29	229.29	229.29	200.0
2017-01-27 05:10:00	SPY	ETF	229.28	229.28	229.28	229.28	100.0
2017-01-27 05:15:00	SPY	ETF	229.23	229.23	229.23	229.23	800.0
2017-01-27 05:20:00	SPY	ETF	229.28	229.28	229.28	229.28	301.0
2017-01-27 05:35:00	SPY	ETF	229.33	229.33	229.33	229.33	900.0
2017-01-27 05:40:00	SPY	ETF	229.36	229.38	229.36	229.38	2401.0
2017-01-27 05:45:00	SPY	ETF	229.36	229.36	229.36	229.36	1302.0
2017-01-27 05:50:00	SPY	ETF	229.34	229.34	229.34	229.34	200.0
2017-01-27 06:00:00	SPY	ETF	229.38	229.38	229.36	229.37	1301.0
2017-01-27 06:05:00	SPY	ETF	229.4	229.46	229.4	229.46	1507.0
2017-01-27 06:10:00	SPY	ETF	229.41	229.41	229.41	229.41	100.0
2017-01-27 06:15:00	SPY	ETF	229.34	229.34	229.34	229.34	402.0
2017-01-27 06:20:00	SPY	ETF	229.36	229.41	229.36	229.41	703.0
2017-01-27 06:30:00	SPY	ETF	229.44	229.44	229.44	229.44	301.0
2017-01-27 06:40:00	SPY	ETF	229.38	229.38	229.38	229.38	201.0
2017-01-27 06:45:00	SPY	ETF	229.36	229.36	229.32	229.32	400.0
2017-01-27 06:50:00	SPY	ETF	229.36	229.36	229.36	229.36	300.0
2017-01-27 07:00:00	SPY	ETF	229.34	229.34	229.34	229.34	2000.0
2017-01-27 07:05:00	SPY	ETF	229.31	229.35	229.27	229.32	37502.0
2017-01-27 07:10:00	SPY	ETF	229.32	229.38	229.32	229.38	2701.0
2017-01-27 07:15:00	SPY	ETF	229.38	229.46	229.37	229.37	3840.0
2017-01-27 07:20:00	SPY	ETF	229.43	229.43	229.4	229.43	988.0
2017-01-27 07:25:00	SPY	ETF	229.45	229.45	229.39	229.39	1587.0
2017-01-27 07:30:00	SPY	ETF	229.39	229.39	229.39	229.39	386.0
2017-01-27 07:35:00	SPY	ETF	229.45	229.45	229.42	229.44	6036.0
2017-01-27 07:40:00	SPY	ETF	229.46	229.46	229.44	229.46	3337.0
2017-01-27 07:45:00	SPY	ETF	229.47	229.47	229.44	229.44	2278.0
2017-01-27 07:50:00	SPY	ETF	229.44	229.5	229.44	229.5	2594.0
2017-01-27 07:55:00	SPY	ETF	229.5	229.55	229.5	229.52	31497.0
2017-01-27 08:00:00	SPY	ETF	229.52	229.56	229.31	229.56	40762.0
2017-01-27 08:05:00	SPY	ETF	229.53	229.53	229.49	229.49	9414.0
2017-01-27 08:10:00	SPY	ETF	229.49	229.5	229.49	229.49	1851.0
2017-01-27 08:15:00	SPY	ETF	229.5	229.53	229.5	229.52	7400.0
2017-01-27 08:20:00	SPY	ETF	229.5	229.54	229.49	229.54	11222.0
2017-01-27 08:25:00	SPY	ETF	229.54	229.58	229.54	229.55	5148.0
2017-01-27 08:30:00	SPY	ETF	229.54	229.54	229.42	229.42	28640.0
2017-01-27 08:35:00	SPY	ETF	229.43	229.55	229.42	229.48	33068.0
2017-01-27 08:40:00	SPY	ETF	229.45	229.46	229.42	229.45	14902.0
2017-01-27 08:45:00	SPY	ETF	229.43	229.45	229.41	229.42	7453.0
2017-01-27 08:50:00	SPY	ETF	229.41	229.42	229.4	229.4	13710.0
2017-01-27 08:55:00	SPY	ETF	229.4	229.49	229.39	229.48	7055.0

> showing 50 of 53,438 rows — these rows as CSV

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