PREVIEW / etf_5min / 2017-03-01

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-03-01.parquet
  size:    1.4 MB
  rows:    59,610

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-03-01 04:00:00	SPY	ETF	237.42	237.66	237.42	237.6	56136.0
2017-03-01 04:05:00	SPY	ETF	237.6	237.6	237.55	237.58	592.0
2017-03-01 04:10:00	SPY	ETF	237.66	237.66	237.66	237.66	400.0
2017-03-01 04:15:00	SPY	ETF	237.66	237.66	237.59	237.63	1716.0
2017-03-01 04:20:00	SPY	ETF	237.64	237.69	237.64	237.66	19560.0
2017-03-01 04:25:00	SPY	ETF	237.66	237.66	237.66	237.66	300.0
2017-03-01 04:30:00	SPY	ETF	237.64	237.69	237.64	237.66	1000.0
2017-03-01 04:35:00	SPY	ETF	237.56	237.56	237.56	237.56	503.0
2017-03-01 04:40:00	SPY	ETF	237.58	237.61	237.58	237.58	2452.0
2017-03-01 04:45:00	SPY	ETF	237.63	237.64	237.63	237.63	3100.0
2017-03-01 04:50:00	SPY	ETF	237.6	237.61	237.6	237.61	900.0
2017-03-01 04:55:00	SPY	ETF	237.6	237.6	237.6	237.6	202.0
2017-03-01 05:05:00	SPY	ETF	237.61	237.64	237.61	237.61	1500.0
2017-03-01 05:10:00	SPY	ETF	237.6	237.61	237.6	237.61	500.0
2017-03-01 05:15:00	SPY	ETF	237.56	237.56	237.51	237.56	2737.0
2017-03-01 05:20:00	SPY	ETF	237.55	237.62	237.55	237.58	1213.0
2017-03-01 05:25:00	SPY	ETF	237.64	237.64	237.63	237.63	901.0
2017-03-01 05:30:00	SPY	ETF	237.66	237.69	237.65	237.65	4505.0
2017-03-01 05:35:00	SPY	ETF	237.66	237.7	237.66	237.7	3102.0
2017-03-01 05:40:00	SPY	ETF	237.7	237.73	237.65	237.68	23206.0
2017-03-01 05:45:00	SPY	ETF	237.69	237.7	237.67	237.68	12102.0
2017-03-01 05:50:00	SPY	ETF	237.63	237.65	237.63	237.65	505.0
2017-03-01 05:55:00	SPY	ETF	237.69	237.74	237.69	237.73	1103.0
2017-03-01 06:00:00	SPY	ETF	237.73	237.73	237.69	237.69	1450.0
2017-03-01 06:05:00	SPY	ETF	237.71	237.71	237.65	237.7	901.0
2017-03-01 06:10:00	SPY	ETF	237.75	237.75	237.75	237.75	801.0
2017-03-01 06:15:00	SPY	ETF	237.77	237.77	237.72	237.73	3573.0
2017-03-01 06:20:00	SPY	ETF	237.73	237.73	237.7	237.7	1301.0
2017-03-01 06:25:00	SPY	ETF	237.71	237.71	237.62	237.62	2219.0
2017-03-01 06:30:00	SPY	ETF	237.63	237.71	237.59	237.67	8714.0
2017-03-01 06:35:00	SPY	ETF	237.67	237.7	237.56	237.57	34016.0
2017-03-01 06:40:00	SPY	ETF	237.61	237.61	237.58	237.6	2017.0
2017-03-01 06:45:00	SPY	ETF	237.6	237.6	237.6	237.6	300.0
2017-03-01 06:50:00	SPY	ETF	237.57	237.58	237.53	237.58	1053.0
2017-03-01 06:55:00	SPY	ETF	237.58	237.65	237.58	237.63	6753.0
2017-03-01 07:00:00	SPY	ETF	237.68	237.7	237.64	237.67	16513.0
2017-03-01 07:05:00	SPY	ETF	237.7	237.75	237.66	237.66	55102.0
2017-03-01 07:10:00	SPY	ETF	237.68	237.7	237.64	237.65	4303.0
2017-03-01 07:15:00	SPY	ETF	237.66	237.74	237.66	237.7	14608.0
2017-03-01 07:20:00	SPY	ETF	237.7	237.72	237.7	237.72	23799.0
2017-03-01 07:25:00	SPY	ETF	237.75	237.75	237.68	237.69	23390.0
2017-03-01 07:30:00	SPY	ETF	237.68	237.73	237.66	237.7	47094.0
2017-03-01 07:35:00	SPY	ETF	237.71	237.82	237.67	237.82	20228.0
2017-03-01 07:40:00	SPY	ETF	237.83	237.86	237.79	237.86	13879.0
2017-03-01 07:45:00	SPY	ETF	237.85	237.86	237.8	237.84	77936.0
2017-03-01 07:50:00	SPY	ETF	237.86	237.88	237.84	237.87	26699.0
2017-03-01 07:55:00	SPY	ETF	237.88	237.89	237.85	237.88	31508.0
2017-03-01 08:00:00	SPY	ETF	237.88	237.88	237.58	237.87	171756.0
2017-03-01 08:05:00	SPY	ETF	237.87	237.88	237.84	237.88	18716.0
2017-03-01 08:10:00	SPY	ETF	237.89	238.0	237.86	237.97	57808.0

> showing 50 of 59,610 rows — these rows as CSV

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