PREVIEW / etf_5min / 2017-03-31

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-03-31.parquet
  size:    1.2 MB
  rows:    52,435

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-31 04:00:00	SPY	ETF	235.76	235.76	235.76	235.76	295.0
2017-03-31 04:05:00	SPY	ETF	235.75	235.75	235.75	235.75	500.0
2017-03-31 04:10:00	SPY	ETF	235.71	235.71	235.66	235.66	1000.0
2017-03-31 04:15:00	SPY	ETF	235.67	235.67	235.64	235.65	910.0
2017-03-31 04:20:00	SPY	ETF	235.62	235.63	235.62	235.63	10710.0
2017-03-31 04:30:00	SPY	ETF	235.7	235.7	235.7	235.7	2500.0
2017-03-31 04:50:00	SPY	ETF	235.6	235.64	235.6	235.64	340.0
2017-03-31 04:55:00	SPY	ETF	235.6	235.6	235.6	235.6	120.0
2017-03-31 05:00:00	SPY	ETF	235.61	235.62	235.61	235.61	1020.0
2017-03-31 05:10:00	SPY	ETF	235.7	235.7	235.7	235.7	600.0
2017-03-31 05:20:00	SPY	ETF	235.75	235.75	235.75	235.75	200.0
2017-03-31 05:25:00	SPY	ETF	235.72	235.72	235.72	235.72	100.0
2017-03-31 05:35:00	SPY	ETF	235.75	235.75	235.73	235.73	603.0
2017-03-31 05:45:00	SPY	ETF	235.81	235.82	235.81	235.82	1306.0
2017-03-31 05:55:00	SPY	ETF	235.69	235.69	235.69	235.69	100.0
2017-03-31 06:05:00	SPY	ETF	235.74	235.74	235.74	235.74	132.0
2017-03-31 06:20:00	SPY	ETF	235.67	235.71	235.64	235.64	26853.0
2017-03-31 06:25:00	SPY	ETF	235.68	235.71	235.68	235.71	7401.0
2017-03-31 06:30:00	SPY	ETF	235.71	235.72	235.71	235.72	9100.0
2017-03-31 06:35:00	SPY	ETF	235.68	235.72	235.68	235.69	30022.0
2017-03-31 06:40:00	SPY	ETF	235.69	235.69	235.62	235.62	14105.0
2017-03-31 06:45:00	SPY	ETF	235.66	235.72	235.65	235.7	55301.0
2017-03-31 06:50:00	SPY	ETF	235.72	235.72	235.72	235.72	4700.0
2017-03-31 06:55:00	SPY	ETF	235.72	235.72	235.68	235.68	7200.0
2017-03-31 07:00:00	SPY	ETF	235.72	235.72	235.69	235.72	7150.0
2017-03-31 07:05:00	SPY	ETF	235.71	235.72	235.69	235.72	2400.0
2017-03-31 07:10:00	SPY	ETF	235.69	235.72	235.69	235.72	1035.0
2017-03-31 07:15:00	SPY	ETF	235.72	235.74	235.7	235.74	2750.0
2017-03-31 07:20:00	SPY	ETF	235.74	235.8	235.74	235.76	7363.0
2017-03-31 07:25:00	SPY	ETF	235.79	235.79	235.76	235.76	11769.0
2017-03-31 07:30:00	SPY	ETF	235.76	235.79	235.76	235.79	2288.0
2017-03-31 07:35:00	SPY	ETF	235.8	235.8	235.76	235.78	5942.0
2017-03-31 07:40:00	SPY	ETF	235.82	235.84	235.8	235.82	26368.0
2017-03-31 07:45:00	SPY	ETF	235.82	235.82	235.82	235.82	600.0
2017-03-31 07:50:00	SPY	ETF	235.84	235.86	235.82	235.84	48938.0
2017-03-31 07:55:00	SPY	ETF	235.85	235.85	235.84	235.85	32851.0
2017-03-31 08:00:00	SPY	ETF	235.7	235.99	235.69	235.94	168696.0
2017-03-31 08:05:00	SPY	ETF	235.96	236.0	235.96	235.97	92008.0
2017-03-31 08:10:00	SPY	ETF	235.99	235.99	235.98	235.98	1054.0
2017-03-31 08:15:00	SPY	ETF	235.99	236.02	235.96	236.02	11538.0
2017-03-31 08:20:00	SPY	ETF	236.01	236.08	236.0	236.0	72395.0
2017-03-31 08:25:00	SPY	ETF	236.02	236.04	236.02	236.03	12023.0
2017-03-31 08:30:00	SPY	ETF	236.02	236.06	235.95	236.06	56999.0
2017-03-31 08:35:00	SPY	ETF	236.06	236.1	236.06	236.1	25241.0
2017-03-31 08:40:00	SPY	ETF	236.1	236.13	236.1	236.12	22468.0
2017-03-31 08:45:00	SPY	ETF	236.1	236.1	236.05	236.05	12237.0
2017-03-31 08:50:00	SPY	ETF	236.03	236.03	235.97	235.99	18486.0
2017-03-31 08:55:00	SPY	ETF	236.0	236.0	235.98	236.0	12299.0
2017-03-31 09:00:00	SPY	ETF	236.0	236.02	235.98	236.02	8889.0
2017-03-31 09:05:00	SPY	ETF	236.02	236.05	235.99	236.03	28403.0

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

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