PREVIEW / etf_5min / 2017-01-13

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-01-13.parquet
  size:    1.2 MB
  rows:    53,508

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-13 04:05:00	SPY	ETF	226.53	226.53	226.53	226.53	100.0
2017-01-13 04:10:00	SPY	ETF	226.54	226.54	226.54	226.54	100.0
2017-01-13 05:00:00	SPY	ETF	226.69	226.69	226.69	226.69	395.0
2017-01-13 05:35:00	SPY	ETF	226.69	226.69	226.69	226.69	301.0
2017-01-13 05:40:00	SPY	ETF	226.75	226.75	226.75	226.75	302.0
2017-01-13 05:45:00	SPY	ETF	226.82	226.82	226.76	226.76	405.0
2017-01-13 05:50:00	SPY	ETF	226.77	226.77	226.77	226.77	101.0
2017-01-13 05:55:00	SPY	ETF	226.82	226.82	226.82	226.82	500.0
2017-01-13 06:05:00	SPY	ETF	226.78	226.78	226.78	226.78	200.0
2017-01-13 06:15:00	SPY	ETF	226.78	226.8	226.78	226.79	17502.0
2017-01-13 06:20:00	SPY	ETF	226.79	226.79	226.75	226.75	421.0
2017-01-13 06:25:00	SPY	ETF	226.73	226.79	226.73	226.79	751.0
2017-01-13 06:35:00	SPY	ETF	226.76	226.76	226.75	226.75	602.0
2017-01-13 06:40:00	SPY	ETF	226.75	226.75	226.74	226.74	700.0
2017-01-13 06:45:00	SPY	ETF	226.7	226.7	226.65	226.65	708.0
2017-01-13 06:50:00	SPY	ETF	226.64	226.67	226.64	226.67	200.0
2017-01-13 06:55:00	SPY	ETF	226.63	226.64	226.63	226.64	400.0
2017-01-13 07:00:00	SPY	ETF	226.69	226.72	226.69	226.72	1294.0
2017-01-13 07:05:00	SPY	ETF	226.72	226.73	226.66	226.66	4836.0
2017-01-13 07:10:00	SPY	ETF	226.66	226.67	226.64	226.64	3350.0
2017-01-13 07:15:00	SPY	ETF	226.62	226.62	226.62	226.62	201.0
2017-01-13 07:20:00	SPY	ETF	226.67	226.67	226.67	226.67	100.0
2017-01-13 07:30:00	SPY	ETF	226.72	226.74	226.71	226.74	8873.0
2017-01-13 07:35:00	SPY	ETF	226.72	226.72	226.72	226.72	505.0
2017-01-13 07:40:00	SPY	ETF	226.74	226.74	226.62	226.62	96605.0
2017-01-13 07:45:00	SPY	ETF	226.61	226.61	226.59	226.61	3527.0
2017-01-13 07:50:00	SPY	ETF	226.7	226.73	226.66	226.66	54568.0
2017-01-13 07:55:00	SPY	ETF	226.68	226.75	226.68	226.75	2307.0
2017-01-13 08:00:00	SPY	ETF	226.67	226.8	226.62	226.76	54524.0
2017-01-13 08:05:00	SPY	ETF	226.75	226.76	226.7	226.73	25205.0
2017-01-13 08:10:00	SPY	ETF	226.69	226.7	226.65	226.68	17208.0
2017-01-13 08:15:00	SPY	ETF	226.66	226.66	226.56	226.57	36915.0
2017-01-13 08:20:00	SPY	ETF	226.57	226.57	226.5	226.5	102252.0
2017-01-13 08:25:00	SPY	ETF	226.52	226.52	226.48	226.51	12612.0
2017-01-13 08:30:00	SPY	ETF	226.51	226.61	226.4	226.54	47216.0
2017-01-13 08:35:00	SPY	ETF	226.51	226.62	226.51	226.52	12035.0
2017-01-13 08:40:00	SPY	ETF	226.56	226.62	226.52	226.62	2103.0
2017-01-13 08:45:00	SPY	ETF	226.62	226.69	226.62	226.69	31863.0
2017-01-13 08:50:00	SPY	ETF	226.69	226.72	226.66	226.66	59921.0
2017-01-13 08:55:00	SPY	ETF	226.66	226.69	226.63	226.68	24900.0
2017-01-13 09:00:00	SPY	ETF	226.7	226.73	226.65	226.66	20997.0
2017-01-13 09:05:00	SPY	ETF	226.66	226.75	226.66	226.75	6843.0
2017-01-13 09:10:00	SPY	ETF	226.74	226.76	226.7	226.74	94074.0
2017-01-13 09:15:00	SPY	ETF	226.72	226.79	226.71	226.79	47851.0
2017-01-13 09:20:00	SPY	ETF	226.79	226.81	226.775	226.79	31907.0
2017-01-13 09:25:00	SPY	ETF	226.79	226.79	226.72	226.73	87096.0
2017-01-13 09:30:00	SPY	ETF	226.73	227.1	226.73	227.1	2242538.0
2017-01-13 09:35:00	SPY	ETF	227.1	227.24	227.06	227.1	1366719.0
2017-01-13 09:40:00	SPY	ETF	227.11	227.32	227.1	227.3	983239.0
2017-01-13 09:45:00	SPY	ETF	227.31	227.4	227.3	227.31	900474.0

> showing 50 of 53,508 rows — these rows as CSV

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