PREVIEW / etf_5min / 2017-08-08

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-08-08.parquet
  size:    1.3 MB
  rows:    54,232

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-08-08 04:00:00	SPY	ETF	247.81	247.81	247.81	247.81	632.0
2017-08-08 04:55:00	SPY	ETF	247.65	247.65	247.65	247.65	1000.0
2017-08-08 05:15:00	SPY	ETF	247.65	247.65	247.65	247.65	100.0
2017-08-08 05:40:00	SPY	ETF	247.71	247.71	247.71	247.71	1000.0
2017-08-08 06:00:00	SPY	ETF	247.71	247.71	247.71	247.71	100.0
2017-08-08 06:05:00	SPY	ETF	247.71	247.71	247.71	247.71	4000.0
2017-08-08 06:40:00	SPY	ETF	247.67	247.67	247.67	247.67	100.0
2017-08-08 06:55:00	SPY	ETF	247.71	247.71	247.71	247.71	2000.0
2017-08-08 07:05:00	SPY	ETF	247.73	247.74	247.73	247.74	18766.0
2017-08-08 07:10:00	SPY	ETF	247.7	247.7	247.63	247.63	8700.0
2017-08-08 07:15:00	SPY	ETF	247.64	247.64	247.62	247.62	3300.0
2017-08-08 07:20:00	SPY	ETF	247.62	247.62	247.58	247.58	16800.0
2017-08-08 07:25:00	SPY	ETF	247.58	247.59	247.57	247.57	14420.0
2017-08-08 07:30:00	SPY	ETF	247.52	247.54	247.45	247.5	89315.0
2017-08-08 07:35:00	SPY	ETF	247.51	247.53	247.45	247.53	27550.0
2017-08-08 07:40:00	SPY	ETF	247.47	247.5	247.47	247.49	34610.0
2017-08-08 07:45:00	SPY	ETF	247.49	247.49	247.46	247.48	81180.0
2017-08-08 07:50:00	SPY	ETF	247.48	247.5	247.48	247.5	3190.0
2017-08-08 07:55:00	SPY	ETF	247.51	247.53	247.5	247.51	55325.0
2017-08-08 08:00:00	SPY	ETF	247.53	247.57	247.5	247.57	89922.0
2017-08-08 08:05:00	SPY	ETF	247.54	247.54	247.5	247.53	3177.0
2017-08-08 08:10:00	SPY	ETF	247.52	247.58	247.52	247.57	38505.0
2017-08-08 08:15:00	SPY	ETF	247.57	247.59	247.57	247.59	14310.0
2017-08-08 08:20:00	SPY	ETF	247.59	247.59	247.57	247.57	3000.0
2017-08-08 08:25:00	SPY	ETF	247.56	247.56	247.55	247.55	7916.0
2017-08-08 08:30:00	SPY	ETF	247.54	247.55	247.48	247.51	28569.0
2017-08-08 08:35:00	SPY	ETF	247.51	247.52	247.47	247.49	24905.0
2017-08-08 08:40:00	SPY	ETF	247.49	247.51	247.49	247.5	10456.0
2017-08-08 08:45:00	SPY	ETF	247.49	247.51	247.48	247.5	8384.0
2017-08-08 08:50:00	SPY	ETF	247.5	247.51	247.49	247.5	22438.0
2017-08-08 08:55:00	SPY	ETF	247.5	247.55	247.5	247.53	37072.0
2017-08-08 09:00:00	SPY	ETF	247.53	247.55	247.52	247.52	28242.0
2017-08-08 09:05:00	SPY	ETF	247.5	247.51	247.5	247.51	1452.0
2017-08-08 09:10:00	SPY	ETF	247.5	247.52	247.5	247.5	9749.0
2017-08-08 09:15:00	SPY	ETF	247.52	247.52	247.48	247.5	14697.0
2017-08-08 09:20:00	SPY	ETF	247.53	247.54	247.53	247.54	11460.0
2017-08-08 09:25:00	SPY	ETF	247.54	247.55	247.5	247.51	187978.0
2017-08-08 09:30:00	SPY	ETF	247.51	247.58	247.43	247.5385	1209948.0
2017-08-08 09:35:00	SPY	ETF	247.53	247.57	247.38	247.405	771193.0
2017-08-08 09:40:00	SPY	ETF	247.4	247.49	247.33	247.46	650520.0
2017-08-08 09:45:00	SPY	ETF	247.46	247.51	247.45	247.48	292539.0
2017-08-08 09:50:00	SPY	ETF	247.49	247.65	247.49	247.605	433464.0
2017-08-08 09:55:00	SPY	ETF	247.61	247.64	247.58	247.61	326855.0
2017-08-08 10:00:00	SPY	ETF	247.61	247.645	247.59	247.61	378293.0
2017-08-08 10:05:00	SPY	ETF	247.62	247.7	247.5701	247.685	554780.0
2017-08-08 10:10:00	SPY	ETF	247.69	247.7	247.64	247.68	374333.0
2017-08-08 10:15:00	SPY	ETF	247.67	247.81	247.62	247.79	622199.0
2017-08-08 10:20:00	SPY	ETF	247.79	247.82	247.74	247.765	299454.0
2017-08-08 10:25:00	SPY	ETF	247.76	247.85	247.7589	247.8	318710.0
2017-08-08 10:30:00	SPY	ETF	247.795	247.81	247.69	247.77	298477.0

> showing 50 of 54,232 rows — these rows as CSV

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