PREVIEW / etf_5min / 2017-03-13

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-03-13.parquet
  size:    1.2 MB
  rows:    53,220

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-13 04:05:00	SPY	ETF	237.45	237.45	237.45	237.45	100.0
2017-03-13 04:20:00	SPY	ETF	237.35	237.35	237.35	237.35	300.0
2017-03-13 04:35:00	SPY	ETF	237.49	237.49	237.49	237.49	100.0
2017-03-13 04:45:00	SPY	ETF	237.49	237.49	237.49	237.49	300.0
2017-03-13 04:50:00	SPY	ETF	237.51	237.51	237.51	237.51	500.0
2017-03-13 05:05:00	SPY	ETF	237.49	237.49	237.49	237.49	400.0
2017-03-13 05:10:00	SPY	ETF	237.45	237.45	237.44	237.44	1000.0
2017-03-13 05:15:00	SPY	ETF	237.44	237.44	237.41	237.41	2920.0
2017-03-13 05:20:00	SPY	ETF	237.37	237.37	237.32	237.34	2252.0
2017-03-13 05:30:00	SPY	ETF	237.36	237.38	237.34	237.38	1202.0
2017-03-13 05:35:00	SPY	ETF	237.34	237.34	237.34	237.34	103.0
2017-03-13 05:40:00	SPY	ETF	237.37	237.37	237.3	237.3	1114.0
2017-03-13 05:45:00	SPY	ETF	237.32	237.34	237.32	237.34	802.0
2017-03-13 05:55:00	SPY	ETF	237.32	237.33	237.32	237.33	600.0
2017-03-13 06:00:00	SPY	ETF	237.31	237.31	237.31	237.31	485.0
2017-03-13 06:05:00	SPY	ETF	237.31	237.31	237.31	237.31	400.0
2017-03-13 06:10:00	SPY	ETF	237.32	237.32	237.32	237.32	300.0
2017-03-13 06:15:00	SPY	ETF	237.27	237.27	237.27	237.27	600.0
2017-03-13 06:20:00	SPY	ETF	237.33	237.33	237.33	237.33	100.0
2017-03-13 06:25:00	SPY	ETF	237.34	237.34	237.34	237.34	100.0
2017-03-13 06:30:00	SPY	ETF	237.35	237.35	237.31	237.34	3001.0
2017-03-13 06:35:00	SPY	ETF	237.32	237.33	237.31	237.31	800.0
2017-03-13 06:40:00	SPY	ETF	237.31	237.31	237.31	237.31	500.0
2017-03-13 06:45:00	SPY	ETF	237.33	237.33	237.32	237.32	8900.0
2017-03-13 06:50:00	SPY	ETF	237.31	237.31	237.29	237.29	1401.0
2017-03-13 06:55:00	SPY	ETF	237.31	237.31	237.3	237.31	900.0
2017-03-13 07:00:00	SPY	ETF	237.3	237.3	237.23	237.27	2700.0
2017-03-13 07:05:00	SPY	ETF	237.24	237.25	237.23	237.23	2200.0
2017-03-13 07:10:00	SPY	ETF	237.22	237.22	237.22	237.22	1100.0
2017-03-13 07:15:00	SPY	ETF	237.29	237.3	237.28	237.3	4006.0
2017-03-13 07:20:00	SPY	ETF	237.3	237.3	237.3	237.3	3000.0
2017-03-13 07:30:00	SPY	ETF	237.37	237.44	237.37	237.43	6509.0
2017-03-13 07:35:00	SPY	ETF	237.46	237.46	237.43	237.43	6902.0
2017-03-13 07:40:00	SPY	ETF	237.43	237.44	237.39	237.39	5702.0
2017-03-13 07:45:00	SPY	ETF	237.42	237.42	237.39	237.39	2101.0
2017-03-13 07:50:00	SPY	ETF	237.49	237.49	237.49	237.49	10501.0
2017-03-13 07:55:00	SPY	ETF	237.43	237.48	237.42	237.43	29606.0
2017-03-13 08:00:00	SPY	ETF	237.32	237.49	237.25	237.43	51632.0
2017-03-13 08:05:00	SPY	ETF	237.46	237.57	237.46	237.55	50524.0
2017-03-13 08:10:00	SPY	ETF	237.57	237.58	237.5	237.5	53703.0
2017-03-13 08:15:00	SPY	ETF	237.52	237.62	237.52	237.62	8453.0
2017-03-13 08:20:00	SPY	ETF	237.63	237.69	237.62	237.66	3535750.0
2017-03-13 08:25:00	SPY	ETF	237.67	237.67	237.6	237.62	11330.0
2017-03-13 08:30:00	SPY	ETF	237.61	237.68	237.6	237.65	37287.0
2017-03-13 08:35:00	SPY	ETF	237.64	237.68	237.62	237.68	22204.0
2017-03-13 08:40:00	SPY	ETF	237.69	237.76	237.63	237.63	103553.0
2017-03-13 08:45:00	SPY	ETF	237.64	237.68	237.52	237.54	46925.0
2017-03-13 08:50:00	SPY	ETF	237.53	237.6	237.53	237.56	20698.0
2017-03-13 08:55:00	SPY	ETF	237.54	237.65	237.54	237.65	43105.0
2017-03-13 09:00:00	SPY	ETF	237.57	237.6	237.56	237.6	2927.0

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

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