PREVIEW / etf_5min / 2019-09-18

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-09-18.parquet
  size:    1.4 MB
  rows:    60,110

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
2019-09-18 04:10:00	SPY	ETF	300.74	300.74	300.74	300.74	100.0
2019-09-18 04:15:00	SPY	ETF	300.8	300.8	300.8	300.8	800.0
2019-09-18 04:20:00	SPY	ETF	300.8	300.8	300.8	300.8	1130.0
2019-09-18 04:25:00	SPY	ETF	300.77	300.77	300.73	300.73	300.0
2019-09-18 04:30:00	SPY	ETF	300.73	300.73	300.73	300.73	1360.0
2019-09-18 04:55:00	SPY	ETF	300.64	300.64	300.64	300.64	2000.0
2019-09-18 05:00:00	SPY	ETF	300.55	300.55	300.55	300.55	2000.0
2019-09-18 05:15:00	SPY	ETF	300.54	300.54	300.5	300.52	6590.0
2019-09-18 05:20:00	SPY	ETF	300.56	300.56	300.56	300.56	100.0
2019-09-18 05:40:00	SPY	ETF	300.56	300.56	300.56	300.56	500.0
2019-09-18 05:50:00	SPY	ETF	300.53	300.53	300.52	300.52	1300.0
2019-09-18 05:55:00	SPY	ETF	300.52	300.52	300.48	300.52	1475.0
2019-09-18 06:05:00	SPY	ETF	300.52	300.52	300.52	300.52	100.0
2019-09-18 06:10:00	SPY	ETF	300.53	300.53	300.48	300.48	1400.0
2019-09-18 06:15:00	SPY	ETF	300.45	300.45	300.45	300.45	1000.0
2019-09-18 06:20:00	SPY	ETF	300.43	300.45	300.43	300.45	1150.0
2019-09-18 06:25:00	SPY	ETF	300.51	300.51	300.51	300.51	100.0
2019-09-18 06:30:00	SPY	ETF	300.51	300.52	300.51	300.52	8400.0
2019-09-18 06:40:00	SPY	ETF	300.6	300.6	300.58	300.6	5000.0
2019-09-18 06:45:00	SPY	ETF	300.55	300.58	300.55	300.58	696.0
2019-09-18 06:50:00	SPY	ETF	300.57	300.57	300.57	300.57	6600.0
2019-09-18 06:55:00	SPY	ETF	300.55	300.55	300.53	300.53	2200.0
2019-09-18 07:00:00	SPY	ETF	300.63	300.63	300.59	300.59	13961.0
2019-09-18 07:05:00	SPY	ETF	300.58	300.58	300.4	300.4	36435.0
2019-09-18 07:10:00	SPY	ETF	300.39	300.42	300.36	300.38	39288.0
2019-09-18 07:15:00	SPY	ETF	300.4	300.4	300.33	300.35	30813.0
2019-09-18 07:20:00	SPY	ETF	300.39	300.41	300.38	300.41	10891.0
2019-09-18 07:25:00	SPY	ETF	300.42	300.46	300.41	300.46	15500.0
2019-09-18 07:30:00	SPY	ETF	300.5	300.55	300.44	300.44	91200.0
2019-09-18 07:35:00	SPY	ETF	300.44	300.47	300.4	300.4	62500.0
2019-09-18 07:40:00	SPY	ETF	300.36	300.36	300.18	300.23	26305.0
2019-09-18 07:45:00	SPY	ETF	300.31	300.41	300.29	300.41	3570.0
2019-09-18 07:50:00	SPY	ETF	300.44	300.45	300.42	300.42	6290.0
2019-09-18 07:55:00	SPY	ETF	300.41	300.41	300.36	300.36	5100.0
2019-09-18 08:00:00	SPY	ETF	300.36	300.57	300.36	300.39	54161.0
2019-09-18 08:05:00	SPY	ETF	300.42	300.43	300.41	300.41	6244.0
2019-09-18 08:10:00	SPY	ETF	300.41	300.44	300.41	300.44	43464.0
2019-09-18 08:15:00	SPY	ETF	300.4	300.43	300.4	300.43	200.0
2019-09-18 08:20:00	SPY	ETF	300.47	300.47	300.42	300.42	1444.0
2019-09-18 08:25:00	SPY	ETF	300.4699	300.4699	300.43	300.44	1125.0
2019-09-18 08:30:00	SPY	ETF	300.44	300.53	300.44	300.49	27117.0
2019-09-18 08:35:00	SPY	ETF	300.48	300.54	300.48	300.53	10277.0
2019-09-18 08:40:00	SPY	ETF	300.54	300.56	300.49	300.5	17199.0
2019-09-18 08:45:00	SPY	ETF	300.54	300.66	300.54	300.6	16962.0
2019-09-18 08:50:00	SPY	ETF	300.61	300.63	300.52	300.52	11469.0
2019-09-18 08:55:00	SPY	ETF	300.57	300.66	300.56	300.63	34058.0
2019-09-18 09:00:00	SPY	ETF	300.62	300.66	300.6	300.65	15057.0
2019-09-18 09:05:00	SPY	ETF	300.64	300.65	300.52	300.52	12555.0
2019-09-18 09:10:00	SPY	ETF	300.52	300.61	300.51	300.61	17035.0
2019-09-18 09:15:00	SPY	ETF	300.6	300.6	300.57	300.6	3678.0

> showing 50 of 60,110 rows — these rows as CSV

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