PREVIEW / etf_5min / 2016-05-13

all etf 5-min files

  file:    by_date/etf_5min/2016/2016-05-13.parquet
  size:    1.1 MB
  rows:    48,481

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
2016-05-13 04:00:00	SPY	ETF	205.84	205.84	205.53	205.53	9034.0
2016-05-13 04:05:00	SPY	ETF	205.51	205.56	205.46	205.46	3004.0
2016-05-13 04:10:00	SPY	ETF	205.46	205.48	205.37	205.38	24639.0
2016-05-13 04:15:00	SPY	ETF	205.38	205.48	205.34	205.48	3214.0
2016-05-13 04:20:00	SPY	ETF	205.46	205.46	205.41	205.42	764.0
2016-05-13 04:25:00	SPY	ETF	205.43	205.63	205.43	205.57	6076.0
2016-05-13 04:30:00	SPY	ETF	205.6	205.6	205.6	205.6	203.0
2016-05-13 04:35:00	SPY	ETF	205.45	205.53	205.45	205.49	11951.0
2016-05-13 04:40:00	SPY	ETF	205.46	205.49	205.44	205.44	23609.0
2016-05-13 04:45:00	SPY	ETF	205.49	205.49	205.49	205.49	505.0
2016-05-13 04:50:00	SPY	ETF	205.56	205.56	205.56	205.56	103.0
2016-05-13 04:55:00	SPY	ETF	205.49	205.57	205.49	205.57	614.0
2016-05-13 05:00:00	SPY	ETF	205.47	205.47	205.47	205.47	234.0
2016-05-13 05:10:00	SPY	ETF	205.45	205.5	205.45	205.5	206.0
2016-05-13 05:15:00	SPY	ETF	205.44	205.44	205.42	205.42	503.0
2016-05-13 05:20:00	SPY	ETF	205.4	205.4	205.37	205.37	646.0
2016-05-13 05:25:00	SPY	ETF	205.47	205.47	205.47	205.47	104.0
2016-05-13 05:30:00	SPY	ETF	205.49	205.49	205.44	205.44	1001.0
2016-05-13 05:35:00	SPY	ETF	205.44	205.44	205.44	205.44	404.0
2016-05-13 05:40:00	SPY	ETF	205.59	205.65	205.59	205.65	268.0
2016-05-13 05:45:00	SPY	ETF	205.64	205.68	205.64	205.68	6752.0
2016-05-13 05:50:00	SPY	ETF	205.63	205.63	205.51	205.51	1875.0
2016-05-13 05:55:00	SPY	ETF	205.52	205.55	205.45	205.55	1886.0
2016-05-13 06:00:00	SPY	ETF	205.53	205.61	205.53	205.61	407.0
2016-05-13 06:05:00	SPY	ETF	205.6	205.64	205.6	205.62	702.0
2016-05-13 06:10:00	SPY	ETF	205.62	205.68	205.53	205.53	4811.0
2016-05-13 06:15:00	SPY	ETF	205.51	205.51	205.46	205.49	1330.0
2016-05-13 06:20:00	SPY	ETF	205.53	205.53	205.52	205.52	300.0
2016-05-13 06:25:00	SPY	ETF	205.65	205.67	205.65	205.67	2126.0
2016-05-13 06:30:00	SPY	ETF	205.7	205.8	205.7	205.79	20519.0
2016-05-13 06:35:00	SPY	ETF	205.79	205.8	205.76	205.78	26780.0
2016-05-13 06:45:00	SPY	ETF	205.75	205.75	205.7	205.7	5694.0
2016-05-13 06:50:00	SPY	ETF	205.75	205.84	205.75	205.84	1315.0
2016-05-13 06:55:00	SPY	ETF	205.77	205.85	205.77	205.85	2121.0
2016-05-13 07:00:00	SPY	ETF	205.9	205.98	205.89	205.89	19664.0
2016-05-13 07:05:00	SPY	ETF	205.88	205.96	205.88	205.91	26058.0
2016-05-13 07:10:00	SPY	ETF	205.85	205.87	205.85	205.85	3701.0
2016-05-13 07:15:00	SPY	ETF	205.91	205.92	205.85	205.92	11402.0
2016-05-13 07:20:00	SPY	ETF	205.9	205.9	205.8	205.81	42309.0
2016-05-13 07:25:00	SPY	ETF	205.85	205.93	205.84	205.92	17208.0
2016-05-13 07:30:00	SPY	ETF	205.94	205.99	205.94	205.96	11225.0
2016-05-13 07:35:00	SPY	ETF	205.98	205.99	205.88	205.88	7153.0
2016-05-13 07:40:00	SPY	ETF	205.9	205.9	205.83	205.84	4767.0
2016-05-13 07:45:00	SPY	ETF	205.85	205.85	205.79	205.84	2855.0
2016-05-13 07:50:00	SPY	ETF	205.87	205.9	205.73	205.74	77388.0
2016-05-13 07:55:00	SPY	ETF	205.77	205.78	205.68	205.7	28978.0
2016-05-13 08:00:00	SPY	ETF	205.68	205.96	205.29	205.601	154634.0
2016-05-13 08:05:00	SPY	ETF	205.82	205.84	205.75	205.75	96706.0
2016-05-13 08:10:00	SPY	ETF	205.8	205.86	205.76	205.81	83300.0
2016-05-13 08:15:00	SPY	ETF	205.81	205.89	205.81	205.88	62230.0

> showing 50 of 48,481 rows — these rows as CSV

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