PREVIEW / etf_5min / 2017-01-04

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-01-04.parquet
  size:    1.4 MB
  rows:    58,826

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-01-04 04:00:00	SPY	ETF	225.43	225.43	225.43	225.43	251.0
2017-01-04 04:05:00	SPY	ETF	225.46	225.46	225.46	225.46	100.0
2017-01-04 04:10:00	SPY	ETF	225.49	225.49	225.49	225.49	298.0
2017-01-04 04:15:00	SPY	ETF	225.41	225.41	225.41	225.41	501.0
2017-01-04 04:20:00	SPY	ETF	225.5	225.5	225.5	225.5	501.0
2017-01-04 04:30:00	SPY	ETF	225.5	225.5	225.5	225.5	500.0
2017-01-04 04:35:00	SPY	ETF	225.5	225.5	225.5	225.5	101.0
2017-01-04 04:40:00	SPY	ETF	225.54	225.54	225.51	225.51	501.0
2017-01-04 04:50:00	SPY	ETF	225.52	225.59	225.52	225.59	2105.0
2017-01-04 04:55:00	SPY	ETF	225.59	225.59	225.59	225.59	900.0
2017-01-04 05:05:00	SPY	ETF	225.64	225.64	225.58	225.58	859.0
2017-01-04 05:10:00	SPY	ETF	225.58	225.58	225.58	225.58	578.0
2017-01-04 05:20:00	SPY	ETF	225.65	225.65	225.65	225.65	2000.0
2017-01-04 05:25:00	SPY	ETF	225.62	225.62	225.62	225.62	600.0
2017-01-04 05:30:00	SPY	ETF	225.62	225.62	225.62	225.62	300.0
2017-01-04 05:35:00	SPY	ETF	225.61	225.67	225.61	225.66	1903.0
2017-01-04 05:40:00	SPY	ETF	225.61	225.61	225.61	225.61	100.0
2017-01-04 06:05:00	SPY	ETF	225.4	225.4	225.4	225.4	1010.0
2017-01-04 06:10:00	SPY	ETF	225.44	225.44	225.44	225.44	100.0
2017-01-04 06:15:00	SPY	ETF	225.43	225.45	225.43	225.45	1250.0
2017-01-04 06:25:00	SPY	ETF	225.6	225.6	225.6	225.6	104.0
2017-01-04 06:30:00	SPY	ETF	225.59	225.59	225.59	225.59	401.0
2017-01-04 06:35:00	SPY	ETF	225.58	225.58	225.58	225.58	8901.0
2017-01-04 06:40:00	SPY	ETF	225.57	225.59	225.57	225.59	24799.0
2017-01-04 06:45:00	SPY	ETF	225.59	225.59	225.59	225.59	1800.0
2017-01-04 07:00:00	SPY	ETF	225.55	225.56	225.55	225.56	3997.0
2017-01-04 07:05:00	SPY	ETF	225.57	225.57	225.55	225.55	9556.0
2017-01-04 07:10:00	SPY	ETF	225.55	225.58	225.55	225.58	2600.0
2017-01-04 07:15:00	SPY	ETF	225.58	225.58	225.55	225.55	37641.0
2017-01-04 07:20:00	SPY	ETF	225.54	225.58	225.54	225.58	32697.0
2017-01-04 07:25:00	SPY	ETF	225.57	225.59	225.54	225.59	8955.0
2017-01-04 07:30:00	SPY	ETF	225.59	225.59	225.58	225.58	1555.0
2017-01-04 07:35:00	SPY	ETF	225.59	225.59	225.58	225.58	650.0
2017-01-04 07:40:00	SPY	ETF	225.62	225.62	225.62	225.62	390.0
2017-01-04 07:45:00	SPY	ETF	225.59	225.59	225.58	225.58	25200.0
2017-01-04 07:50:00	SPY	ETF	225.59	225.63	225.59	225.62	11001.0
2017-01-04 07:55:00	SPY	ETF	225.62	225.67	225.62	225.67	11652.0
2017-01-04 08:00:00	SPY	ETF	225.65	225.71	225.56	225.71	253117.0
2017-01-04 08:05:00	SPY	ETF	225.7	225.7	225.64	225.69	20606.0
2017-01-04 08:10:00	SPY	ETF	225.68	225.72	225.66	225.72	24760.0
2017-01-04 08:15:00	SPY	ETF	225.7	225.75	225.68	225.71	42273.0
2017-01-04 08:20:00	SPY	ETF	225.72	225.74	225.67	225.71	34216.0
2017-01-04 08:25:00	SPY	ETF	225.72	225.79	225.69	225.77	22803.0
2017-01-04 08:30:00	SPY	ETF	225.73	225.77	225.73	225.77	12759.0
2017-01-04 08:35:00	SPY	ETF	225.73	225.76	225.73	225.75	40516.0
2017-01-04 08:40:00	SPY	ETF	225.73	225.73	225.69	225.69	92666.0
2017-01-04 08:45:00	SPY	ETF	225.7	225.72	225.68	225.68	14340.0
2017-01-04 08:50:00	SPY	ETF	225.67	225.67	225.65	225.67	7986.0
2017-01-04 08:55:00	SPY	ETF	225.67	225.67	225.65	225.67	3690.0
2017-01-04 09:00:00	SPY	ETF	225.65	225.66	225.64	225.64	8876.0

> showing 50 of 58,826 rows — these rows as CSV

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