PREVIEW / etf_5min / 2017-09-06

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-09-06.parquet
  size:    1.2 MB
  rows:    52,545

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-09-06 04:00:00	SPY	ETF	246.65	246.68	246.65	246.66	2510.0
2017-09-06 04:10:00	SPY	ETF	246.62	246.62	246.62	246.62	7000.0
2017-09-06 04:15:00	SPY	ETF	246.51	246.51	246.51	246.51	100.0
2017-09-06 04:30:00	SPY	ETF	246.41	246.41	246.41	246.41	103.0
2017-09-06 04:35:00	SPY	ETF	246.49	246.49	246.49	246.49	109.0
2017-09-06 04:40:00	SPY	ETF	246.57	246.6	246.57	246.6	650.0
2017-09-06 04:45:00	SPY	ETF	246.57	246.57	246.54	246.54	200.0
2017-09-06 04:55:00	SPY	ETF	246.56	246.56	246.56	246.56	301.0
2017-09-06 05:00:00	SPY	ETF	246.51	246.51	246.49	246.49	604.0
2017-09-06 05:05:00	SPY	ETF	246.42	246.42	246.42	246.42	103.0
2017-09-06 05:10:00	SPY	ETF	246.38	246.38	246.38	246.38	303.0
2017-09-06 05:20:00	SPY	ETF	246.38	246.38	246.38	246.38	300.0
2017-09-06 05:35:00	SPY	ETF	246.44	246.44	246.22	246.22	4920.0
2017-09-06 05:40:00	SPY	ETF	246.16	246.3	246.11	246.26	3275.0
2017-09-06 06:00:00	SPY	ETF	246.46	246.47	246.45	246.47	1204.0
2017-09-06 06:30:00	SPY	ETF	246.31	246.31	246.31	246.31	303.0
2017-09-06 06:35:00	SPY	ETF	246.34	246.34	246.34	246.34	501.0
2017-09-06 06:45:00	SPY	ETF	246.37	246.44	246.35	246.44	1301.0
2017-09-06 06:50:00	SPY	ETF	246.36	246.36	246.28	246.28	3304.0
2017-09-06 06:55:00	SPY	ETF	246.3	246.31	246.3	246.31	2500.0
2017-09-06 07:00:00	SPY	ETF	246.37	246.42	246.37	246.42	4602.0
2017-09-06 07:05:00	SPY	ETF	246.43	246.43	246.4	246.4	1900.0
2017-09-06 07:10:00	SPY	ETF	246.4	246.43	246.4	246.4	3301.0
2017-09-06 07:15:00	SPY	ETF	246.41	246.41	246.39	246.39	30001.0
2017-09-06 07:20:00	SPY	ETF	246.42	246.44	246.42	246.44	6602.0
2017-09-06 07:25:00	SPY	ETF	246.48	246.5	246.47	246.5	3207.0
2017-09-06 07:30:00	SPY	ETF	246.52	246.6	246.52	246.6	16753.0
2017-09-06 07:35:00	SPY	ETF	246.59	246.6	246.57	246.57	14500.0
2017-09-06 07:40:00	SPY	ETF	246.57	246.57	246.54	246.54	2601.0
2017-09-06 07:45:00	SPY	ETF	246.58	246.64	246.57	246.6	7484.0
2017-09-06 07:50:00	SPY	ETF	246.62	246.66	246.6	246.66	4408.0
2017-09-06 07:55:00	SPY	ETF	246.68	246.71	246.67	246.68	22054.0
2017-09-06 08:00:00	SPY	ETF	246.67	246.75	246.46	246.68	52011.0
2017-09-06 08:05:00	SPY	ETF	246.69	246.73	246.68	246.69	5746.0
2017-09-06 08:10:00	SPY	ETF	246.68	246.71	246.68	246.68	47126.0
2017-09-06 08:15:00	SPY	ETF	246.71	246.73	246.65	246.72	11446.0
2017-09-06 08:20:00	SPY	ETF	246.71	246.75	246.71	246.72	8538.0
2017-09-06 08:25:00	SPY	ETF	246.72	246.77	246.72	246.77	31161.0
2017-09-06 08:30:00	SPY	ETF	246.77	246.79	246.7	246.71	63165.0
2017-09-06 08:35:00	SPY	ETF	246.7	246.74	246.68	246.74	20120.0
2017-09-06 08:40:00	SPY	ETF	246.74	246.82	246.74	246.8	15030.0
2017-09-06 08:45:00	SPY	ETF	246.8	246.87	246.8	246.87	203173.0
2017-09-06 08:50:00	SPY	ETF	246.87	246.91	246.86	246.86	44222.0
2017-09-06 08:55:00	SPY	ETF	246.87	246.9	246.87	246.87	142009.0
2017-09-06 09:00:00	SPY	ETF	246.87	246.92	246.86	246.9	34372.0
2017-09-06 09:05:00	SPY	ETF	246.89	246.97	246.89	246.95	84384.0
2017-09-06 09:10:00	SPY	ETF	246.94	246.94	246.88	246.89	32715.0
2017-09-06 09:15:00	SPY	ETF	246.89	246.94	246.84	246.87	30811.0
2017-09-06 09:20:00	SPY	ETF	246.87	246.87	246.83	246.86	47106.0
2017-09-06 09:25:00	SPY	ETF	246.84	246.9	246.82	246.87	161561.0

> showing 50 of 52,545 rows — these rows as CSV

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