PREVIEW / etf_5min / 2017-10-05

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-10-05.parquet
  size:    1.2 MB
  rows:    53,474

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-10-05 04:00:00	SPY	ETF	253.26	253.27	253.26	253.27	4100.0
2017-10-05 04:05:00	SPY	ETF	253.32	253.32	253.32	253.32	700.0
2017-10-05 04:10:00	SPY	ETF	253.29	253.29	253.29	253.29	100.0
2017-10-05 04:25:00	SPY	ETF	253.31	253.31	253.31	253.31	300.0
2017-10-05 04:30:00	SPY	ETF	253.33	253.34	253.33	253.34	420.0
2017-10-05 04:45:00	SPY	ETF	253.32	253.32	253.32	253.32	4010.0
2017-10-05 04:50:00	SPY	ETF	253.34	253.34	253.32	253.32	5400.0
2017-10-05 05:15:00	SPY	ETF	253.29	253.31	253.29	253.31	5300.0
2017-10-05 05:20:00	SPY	ETF	253.28	253.28	253.28	253.28	3950.0
2017-10-05 05:25:00	SPY	ETF	253.24	253.24	253.24	253.24	600.0
2017-10-05 05:35:00	SPY	ETF	253.24	253.24	253.24	253.24	600.0
2017-10-05 05:55:00	SPY	ETF	253.24	253.24	253.24	253.24	500.0
2017-10-05 06:20:00	SPY	ETF	253.31	253.31	253.31	253.31	300.0
2017-10-05 06:25:00	SPY	ETF	253.31	253.31	253.31	253.31	400.0
2017-10-05 06:30:00	SPY	ETF	253.29	253.29	253.29	253.29	500.0
2017-10-05 06:35:00	SPY	ETF	253.29	253.29	253.29	253.29	400.0
2017-10-05 06:45:00	SPY	ETF	253.31	253.31	253.31	253.31	400.0
2017-10-05 07:00:00	SPY	ETF	253.33	253.33	253.33	253.33	10400.0
2017-10-05 07:05:00	SPY	ETF	253.32	253.33	253.32	253.33	4300.0
2017-10-05 07:10:00	SPY	ETF	253.34	253.37	253.34	253.37	6410.0
2017-10-05 07:15:00	SPY	ETF	253.36	253.37	253.36	253.37	3200.0
2017-10-05 07:20:00	SPY	ETF	253.37	253.38	253.37	253.38	5000.0
2017-10-05 07:25:00	SPY	ETF	253.34	253.34	253.34	253.34	1000.0
2017-10-05 07:30:00	SPY	ETF	253.34	253.36	253.34	253.36	651.0
2017-10-05 07:35:00	SPY	ETF	253.38	253.43	253.38	253.4	21810.0
2017-10-05 07:40:00	SPY	ETF	253.43	253.44	253.43	253.44	500.0
2017-10-05 07:45:00	SPY	ETF	253.42	253.42	253.4	253.4	1400.0
2017-10-05 07:50:00	SPY	ETF	253.42	253.42	253.4	253.4	1876.0
2017-10-05 07:55:00	SPY	ETF	253.4	253.42	253.4	253.42	2375.0
2017-10-05 08:00:00	SPY	ETF	253.35	253.42	253.35	253.39	5450.0
2017-10-05 08:05:00	SPY	ETF	253.39	253.4	253.39	253.4	2450.0
2017-10-05 08:10:00	SPY	ETF	253.42	253.53	253.42	253.51	54618.0
2017-10-05 08:15:00	SPY	ETF	253.5	253.52	253.48	253.49	62000.0
2017-10-05 08:20:00	SPY	ETF	253.5	253.52	253.48	253.5	6423.0
2017-10-05 08:25:00	SPY	ETF	253.5	253.62	253.5	253.6	31081.0
2017-10-05 08:30:00	SPY	ETF	253.58	253.64	253.57	253.6	48949.0
2017-10-05 08:35:00	SPY	ETF	253.6	253.6	253.52	253.52	9874.0
2017-10-05 08:40:00	SPY	ETF	253.52	253.54	253.52	253.53	30248.0
2017-10-05 08:45:00	SPY	ETF	253.52	253.52	253.5	253.5	19702.0
2017-10-05 08:50:00	SPY	ETF	253.5	253.5	253.47	253.47	43440.0
2017-10-05 08:55:00	SPY	ETF	253.46	253.47	253.45	253.46	15360.0
2017-10-05 09:00:00	SPY	ETF	253.51	253.56	253.48	253.5	65868.0
2017-10-05 09:05:00	SPY	ETF	253.5	253.5	253.43	253.45	38249.0
2017-10-05 09:10:00	SPY	ETF	253.46	253.47	253.46	253.47	3794.0
2017-10-05 09:15:00	SPY	ETF	253.46	253.48	253.45	253.46	10560.0
2017-10-05 09:20:00	SPY	ETF	253.46	253.53	253.45	253.51	20174.0
2017-10-05 09:25:00	SPY	ETF	253.52	253.52	253.49	253.52	72700.0
2017-10-05 09:30:00	SPY	ETF	253.54	253.56	253.4	253.56	1278213.0
2017-10-05 09:35:00	SPY	ETF	253.56	253.66	253.56	253.5901	678079.0
2017-10-05 09:40:00	SPY	ETF	253.6	253.71	253.54	253.6766	577621.0

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

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