PREVIEW / etf_5min / 2017-10-02

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-10-02.parquet
  size:    1.3 MB
  rows:    56,758

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-10-02 04:00:00	SPY	ETF	251.44	251.47	251.44	251.45	800.0
2017-10-02 04:10:00	SPY	ETF	251.43	251.43	251.43	251.43	3000.0
2017-10-02 04:15:00	SPY	ETF	251.41	251.43	251.41	251.43	6900.0
2017-10-02 04:25:00	SPY	ETF	251.44	251.48	251.43	251.48	7200.0
2017-10-02 04:45:00	SPY	ETF	251.46	251.46	251.43	251.43	200.0
2017-10-02 04:50:00	SPY	ETF	251.45	251.45	251.45	251.45	170.0
2017-10-02 05:00:00	SPY	ETF	251.45	251.45	251.45	251.45	300.0
2017-10-02 05:10:00	SPY	ETF	251.48	251.48	251.48	251.48	102.0
2017-10-02 05:15:00	SPY	ETF	251.47	251.47	251.47	251.47	300.0
2017-10-02 05:20:00	SPY	ETF	251.48	251.48	251.48	251.48	100.0
2017-10-02 05:30:00	SPY	ETF	251.52	251.52	251.52	251.52	2269.0
2017-10-02 05:40:00	SPY	ETF	251.54	251.54	251.54	251.54	1000.0
2017-10-02 05:50:00	SPY	ETF	251.57	251.57	251.52	251.52	3100.0
2017-10-02 05:55:00	SPY	ETF	251.55	251.55	251.55	251.55	1000.0
2017-10-02 06:00:00	SPY	ETF	251.53	251.53	251.53	251.53	100.0
2017-10-02 06:05:00	SPY	ETF	251.49	251.52	251.49	251.52	2200.0
2017-10-02 06:10:00	SPY	ETF	251.57	251.58	251.57	251.58	600.0
2017-10-02 06:15:00	SPY	ETF	251.6	251.62	251.58	251.58	4004.0
2017-10-02 06:25:00	SPY	ETF	251.62	251.62	251.58	251.62	1600.0
2017-10-02 06:30:00	SPY	ETF	251.63	251.63	251.6	251.6	8520.0
2017-10-02 06:35:00	SPY	ETF	251.58	251.6	251.58	251.6	600.0
2017-10-02 06:40:00	SPY	ETF	251.6	251.63	251.6	251.63	880.0
2017-10-02 06:45:00	SPY	ETF	251.65	251.65	251.63	251.63	1205.0
2017-10-02 06:55:00	SPY	ETF	251.68	251.69	251.68	251.68	872.0
2017-10-02 07:00:00	SPY	ETF	251.68	251.7	251.66	251.66	3425.0
2017-10-02 07:05:00	SPY	ETF	251.63	251.63	251.63	251.63	510.0
2017-10-02 07:10:00	SPY	ETF	251.63	251.63	251.58	251.61	13591.0
2017-10-02 07:15:00	SPY	ETF	251.61	251.61	251.6	251.6	4410.0
2017-10-02 07:20:00	SPY	ETF	251.59	251.62	251.58	251.62	4700.0
2017-10-02 07:25:00	SPY	ETF	251.63	251.65	251.63	251.64	2050.0
2017-10-02 07:30:00	SPY	ETF	251.63	251.66	251.63	251.66	7750.0
2017-10-02 07:35:00	SPY	ETF	251.66	251.72	251.66	251.72	17256.0
2017-10-02 07:40:00	SPY	ETF	251.71	251.72	251.71	251.71	4397.0
2017-10-02 07:45:00	SPY	ETF	251.72	251.76	251.72	251.76	15348.0
2017-10-02 07:50:00	SPY	ETF	251.74	251.76	251.73	251.76	13970.0
2017-10-02 07:55:00	SPY	ETF	251.75	251.76	251.73	251.73	56820.0
2017-10-02 08:00:00	SPY	ETF	251.72	251.76	251.61	251.71	15234.0
2017-10-02 08:05:00	SPY	ETF	251.73	251.73	251.68	251.7	4011.0
2017-10-02 08:10:00	SPY	ETF	251.68	251.7	251.68	251.7	1000.0
2017-10-02 08:15:00	SPY	ETF	251.68	251.71	251.67	251.71	41700.0
2017-10-02 08:20:00	SPY	ETF	251.68	251.68	251.65	251.65	7400.0
2017-10-02 08:25:00	SPY	ETF	251.67	251.68	251.65	251.68	28914.0
2017-10-02 08:30:00	SPY	ETF	251.66	251.71	251.65	251.71	25082.0
2017-10-02 08:35:00	SPY	ETF	251.71	251.71	251.63	251.63	72427.0
2017-10-02 08:40:00	SPY	ETF	251.64	251.65	251.61	251.63	21650.0
2017-10-02 08:45:00	SPY	ETF	251.62	251.62	251.58	251.58	7150.0
2017-10-02 08:50:00	SPY	ETF	251.58	251.58	251.51	251.52	49944.0
2017-10-02 08:55:00	SPY	ETF	251.51	251.52	251.5	251.51	25147.0
2017-10-02 09:00:00	SPY	ETF	251.52	251.55	251.45	251.47	29152.0
2017-10-02 09:05:00	SPY	ETF	251.47	251.51	251.46	251.49	13145.0

> showing 50 of 56,758 rows — these rows as CSV

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