PREVIEW / etf_5min / 2017-04-04

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-04-04.parquet
  size:    1.2 MB
  rows:    52,807

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-04-04 04:00:00	SPY	ETF	234.76	234.76	234.6	234.6	835.0
2017-04-04 04:05:00	SPY	ETF	234.74	234.75	234.7	234.7	1525.0
2017-04-04 04:20:00	SPY	ETF	234.68	234.7	234.68	234.7	280.0
2017-04-04 04:45:00	SPY	ETF	234.87	234.88	234.87	234.88	200.0
2017-04-04 04:55:00	SPY	ETF	234.82	234.82	234.8	234.8	5100.0
2017-04-04 05:00:00	SPY	ETF	234.75	234.75	234.75	234.75	200.0
2017-04-04 05:05:00	SPY	ETF	234.77	234.8	234.77	234.8	4500.0
2017-04-04 05:15:00	SPY	ETF	234.74	234.76	234.74	234.76	300.0
2017-04-04 05:25:00	SPY	ETF	234.7	234.7	234.7	234.7	1002.0
2017-04-04 05:50:00	SPY	ETF	234.78	234.78	234.78	234.78	300.0
2017-04-04 05:55:00	SPY	ETF	234.8	234.8	234.8	234.8	1001.0
2017-04-04 06:10:00	SPY	ETF	234.85	234.87	234.85	234.87	200.0
2017-04-04 06:15:00	SPY	ETF	234.99	235.0	234.99	235.0	604.0
2017-04-04 06:20:00	SPY	ETF	235.02	235.05	235.02	235.05	1104.0
2017-04-04 06:25:00	SPY	ETF	235.05	235.07	235.01	235.02	4302.0
2017-04-04 06:35:00	SPY	ETF	235.0	235.03	235.0	235.03	1500.0
2017-04-04 06:40:00	SPY	ETF	235.01	235.01	235.0	235.0	2600.0
2017-04-04 06:45:00	SPY	ETF	235.0	235.02	235.0	235.02	1200.0
2017-04-04 06:50:00	SPY	ETF	235.0	235.04	235.0	235.04	554.0
2017-04-04 06:55:00	SPY	ETF	235.01	235.01	234.93	234.93	21682.0
2017-04-04 07:00:00	SPY	ETF	235.03	235.05	235.01	235.03	3281.0
2017-04-04 07:05:00	SPY	ETF	235.05	235.07	235.02	235.07	83513.0
2017-04-04 07:10:00	SPY	ETF	235.04	235.04	235.0	235.02	6948.0
2017-04-04 07:15:00	SPY	ETF	235.02	235.02	234.93	234.93	4356.0
2017-04-04 07:20:00	SPY	ETF	234.91	234.91	234.8	234.8	27566.0
2017-04-04 07:25:00	SPY	ETF	234.81	234.81	234.74	234.74	9332.0
2017-04-04 07:30:00	SPY	ETF	234.75	234.75	234.63	234.65	20663.0
2017-04-04 07:35:00	SPY	ETF	234.64	234.64	234.56	234.58	12550.0
2017-04-04 07:40:00	SPY	ETF	234.61	234.63	234.49	234.49	11759.0
2017-04-04 07:45:00	SPY	ETF	234.53	234.58	234.49	234.56	24752.0
2017-04-04 07:50:00	SPY	ETF	234.56	234.58	234.53	234.53	7158.0
2017-04-04 07:55:00	SPY	ETF	234.52	234.57	234.52	234.56	5672.0
2017-04-04 08:00:00	SPY	ETF	234.76	235.03	234.45	234.48	77782.0
2017-04-04 08:05:00	SPY	ETF	234.45	234.48	234.41	234.45	26508.0
2017-04-04 08:10:00	SPY	ETF	234.44	234.48	234.41	234.48	30363.0
2017-04-04 08:15:00	SPY	ETF	234.47	234.57	234.47	234.56	18254.0
2017-04-04 08:20:00	SPY	ETF	234.57	234.66	234.56	234.65	140620.0
2017-04-04 08:25:00	SPY	ETF	234.68	234.68	234.65	234.66	10858.0
2017-04-04 08:30:00	SPY	ETF	234.67	234.68	234.62	234.64	16252.0
2017-04-04 08:35:00	SPY	ETF	234.64	234.68	234.63	234.64	9515.0
2017-04-04 08:40:00	SPY	ETF	234.65	234.65	234.54	234.56	107924.0
2017-04-04 08:45:00	SPY	ETF	234.56	234.67	234.54	234.67	91882.0
2017-04-04 08:50:00	SPY	ETF	234.67	234.7	234.64	234.67	46808.0
2017-04-04 08:55:00	SPY	ETF	234.66	234.7	234.63	234.7	13511.0
2017-04-04 09:00:00	SPY	ETF	234.72	234.83	234.71	234.8	57607.0
2017-04-04 09:05:00	SPY	ETF	234.77	234.83	234.73	234.75	31505.0
2017-04-04 09:10:00	SPY	ETF	234.76	234.77	234.72	234.74	12608.0
2017-04-04 09:15:00	SPY	ETF	234.75	234.8	234.73	234.74	35244.0
2017-04-04 09:20:00	SPY	ETF	234.76	234.91	234.75	234.9	57949.0
2017-04-04 09:25:00	SPY	ETF	234.9	235.0	234.9	234.95	352887.0

> showing 50 of 52,807 rows — these rows as CSV

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