PREVIEW / etf_5min / 2017-12-12

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-12-12.parquet
  size:    1.3 MB
  rows:    55,082

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-12-12 04:05:00	SPY	ETF	266.62	266.62	266.62	266.62	100.0
2017-12-12 04:10:00	SPY	ETF	266.6	266.6	266.6	266.6	400.0
2017-12-12 04:15:00	SPY	ETF	266.69	266.69	266.69	266.69	400.0
2017-12-12 04:20:00	SPY	ETF	266.72	266.72	266.71	266.71	500.0
2017-12-12 04:30:00	SPY	ETF	266.74	266.75	266.67	266.69	2500.0
2017-12-12 04:35:00	SPY	ETF	266.72	266.72	266.7	266.71	21100.0
2017-12-12 04:45:00	SPY	ETF	266.64	266.64	266.49	266.6	4182.0
2017-12-12 04:55:00	SPY	ETF	266.53	266.53	266.53	266.53	100.0
2017-12-12 05:00:00	SPY	ETF	266.58	266.6	266.56	266.56	920.0
2017-12-12 05:05:00	SPY	ETF	266.53	266.53	266.5	266.51	600.0
2017-12-12 05:10:00	SPY	ETF	266.51	266.51	266.51	266.51	300.0
2017-12-12 05:25:00	SPY	ETF	266.47	266.52	266.47	266.52	600.0
2017-12-12 05:30:00	SPY	ETF	266.51	266.51	266.51	266.51	400.0
2017-12-12 05:45:00	SPY	ETF	266.44	266.44	266.44	266.44	600.0
2017-12-12 05:55:00	SPY	ETF	266.44	266.44	266.44	266.44	100.0
2017-12-12 06:00:00	SPY	ETF	266.51	266.51	266.51	266.51	444.0
2017-12-12 06:15:00	SPY	ETF	266.59	266.59	266.59	266.59	700.0
2017-12-12 06:20:00	SPY	ETF	266.58	266.58	266.58	266.58	700.0
2017-12-12 06:25:00	SPY	ETF	266.58	266.58	266.58	266.58	300.0
2017-12-12 06:30:00	SPY	ETF	266.57	266.57	266.56	266.56	10100.0
2017-12-12 06:35:00	SPY	ETF	266.56	266.56	266.53	266.53	900.0
2017-12-12 06:40:00	SPY	ETF	266.54	266.54	266.51	266.54	1900.0
2017-12-12 06:50:00	SPY	ETF	266.54	266.54	266.54	266.54	500.0
2017-12-12 06:55:00	SPY	ETF	266.56	266.57	266.56	266.57	400.0
2017-12-12 07:00:00	SPY	ETF	266.56	266.6	266.56	266.59	34973.0
2017-12-12 07:05:00	SPY	ETF	266.59	266.65	266.59	266.65	3600.0
2017-12-12 07:15:00	SPY	ETF	266.66	266.66	266.64	266.64	9206.0
2017-12-12 07:20:00	SPY	ETF	266.64	266.7	266.64	266.7	1700.0
2017-12-12 07:25:00	SPY	ETF	266.68	266.7	266.68	266.69	4500.0
2017-12-12 07:30:00	SPY	ETF	266.7	266.79	266.7	266.79	11340.0
2017-12-12 07:35:00	SPY	ETF	266.79	266.79	266.76	266.78	15493.0
2017-12-12 07:40:00	SPY	ETF	266.77	266.78	266.77	266.78	1400.0
2017-12-12 07:45:00	SPY	ETF	266.75	266.78	266.72	266.72	22100.0
2017-12-12 07:50:00	SPY	ETF	266.73	266.74	266.7	266.72	4101.0
2017-12-12 07:55:00	SPY	ETF	266.69	266.69	266.68	266.68	3500.0
2017-12-12 08:00:00	SPY	ETF	266.76	266.76	266.67	266.69	11554.0
2017-12-12 08:05:00	SPY	ETF	266.67	266.69	266.67	266.69	603.0
2017-12-12 08:10:00	SPY	ETF	266.68	266.71	266.68	266.7	13100.0
2017-12-12 08:15:00	SPY	ETF	266.7	266.7	266.64	266.64	5684.0
2017-12-12 08:20:00	SPY	ETF	266.65	266.72	266.65	266.68	5643.0
2017-12-12 08:25:00	SPY	ETF	266.69	266.7	266.66	266.7	72910.0
2017-12-12 08:30:00	SPY	ETF	266.67	266.73	266.65	266.72	108662.0
2017-12-12 08:35:00	SPY	ETF	266.72	266.72	266.63	266.65	26006.0
2017-12-12 08:40:00	SPY	ETF	266.64	266.65	266.56	266.56	37153.0
2017-12-12 08:45:00	SPY	ETF	266.56	266.66	266.56	266.63	17750.0
2017-12-12 08:50:00	SPY	ETF	266.63	266.65	266.61	266.64	17265.0
2017-12-12 08:55:00	SPY	ETF	266.63	266.76	266.31	266.75	106235.0
2017-12-12 09:00:00	SPY	ETF	266.75	266.76	266.71	266.75	17211.0
2017-12-12 09:05:00	SPY	ETF	266.75	266.77	266.72	266.77	72221.0
2017-12-12 09:10:00	SPY	ETF	266.75	266.75	266.7	266.7	16925.0

> showing 50 of 55,082 rows — these rows as CSV

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