PREVIEW / etf_5min / 2017-02-27

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-02-27.parquet
  size:    1.2 MB
  rows:    54,761

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-02-27 04:00:00	SPY	ETF	236.8	236.93	236.8	236.89	645.0
2017-02-27 04:15:00	SPY	ETF	236.98	236.98	236.98	236.98	250.0
2017-02-27 04:20:00	SPY	ETF	237.12	237.12	236.94	236.94	620.0
2017-02-27 04:30:00	SPY	ETF	236.9	236.9	236.9	236.9	200.0
2017-02-27 04:35:00	SPY	ETF	236.83	236.83	236.83	236.83	100.0
2017-02-27 04:40:00	SPY	ETF	236.8	236.8	236.74	236.74	500.0
2017-02-27 04:50:00	SPY	ETF	236.81	236.81	236.78	236.78	206.0
2017-02-27 04:55:00	SPY	ETF	236.74	236.74	236.7	236.7	940.0
2017-02-27 05:00:00	SPY	ETF	236.77	236.77	236.77	236.77	308.0
2017-02-27 05:25:00	SPY	ETF	236.75	236.75	236.75	236.75	405.0
2017-02-27 05:35:00	SPY	ETF	236.75	236.75	236.71	236.72	4807.0
2017-02-27 05:45:00	SPY	ETF	236.67	236.67	236.65	236.65	705.0
2017-02-27 05:50:00	SPY	ETF	236.65	236.68	236.65	236.65	3604.0
2017-02-27 06:00:00	SPY	ETF	236.7	236.7	236.7	236.7	1000.0
2017-02-27 06:05:00	SPY	ETF	236.71	236.71	236.71	236.71	502.0
2017-02-27 06:10:00	SPY	ETF	236.74	236.74	236.74	236.74	4001.0
2017-02-27 06:15:00	SPY	ETF	236.7	236.7	236.7	236.7	400.0
2017-02-27 06:25:00	SPY	ETF	236.73	236.73	236.71	236.71	901.0
2017-02-27 06:30:00	SPY	ETF	236.68	236.68	236.65	236.65	505.0
2017-02-27 06:35:00	SPY	ETF	236.62	236.67	236.62	236.67	2301.0
2017-02-27 06:40:00	SPY	ETF	236.7	236.79	236.7	236.79	2413.0
2017-02-27 06:45:00	SPY	ETF	236.78	236.78	236.78	236.78	1000.0
2017-02-27 06:50:00	SPY	ETF	236.75	236.75	236.75	236.75	406.0
2017-02-27 06:55:00	SPY	ETF	236.8	236.8	236.8	236.8	202.0
2017-02-27 07:00:00	SPY	ETF	236.74	236.75	236.72	236.72	15200.0
2017-02-27 07:05:00	SPY	ETF	236.72	236.72	236.7	236.7	1963.0
2017-02-27 07:10:00	SPY	ETF	236.68	236.68	236.66	236.68	10004.0
2017-02-27 07:15:00	SPY	ETF	236.69	236.7	236.69	236.7	473.0
2017-02-27 07:20:00	SPY	ETF	236.71	236.71	236.71	236.71	1800.0
2017-02-27 07:25:00	SPY	ETF	236.7	236.76	236.7	236.72	7908.0
2017-02-27 07:30:00	SPY	ETF	236.7	236.7	236.7	236.7	4800.0
2017-02-27 07:35:00	SPY	ETF	236.71	236.73	236.71	236.73	550.0
2017-02-27 07:40:00	SPY	ETF	236.73	236.73	236.65	236.69	7940.0
2017-02-27 07:45:00	SPY	ETF	236.67	236.67	236.67	236.67	318.0
2017-02-27 07:50:00	SPY	ETF	236.65	236.65	236.57	236.65	38118.0
2017-02-27 07:55:00	SPY	ETF	236.65	236.65	236.58	236.64	72102.0
2017-02-27 08:00:00	SPY	ETF	236.61	236.77	236.54	236.59	110956.0
2017-02-27 08:05:00	SPY	ETF	236.6	236.62	236.51	236.54	23349.0
2017-02-27 08:10:00	SPY	ETF	236.52	236.58	236.52	236.55	32628.0
2017-02-27 08:15:00	SPY	ETF	236.56	236.56	236.44	236.47	60976.0
2017-02-27 08:20:00	SPY	ETF	236.5	236.56	236.47	236.53	16149.0
2017-02-27 08:25:00	SPY	ETF	236.56	236.58	236.51	236.51	21919.0
2017-02-27 08:30:00	SPY	ETF	236.55	236.63	236.52	236.63	52505.0
2017-02-27 08:35:00	SPY	ETF	236.63	236.7	236.63	236.68	40283.0
2017-02-27 08:40:00	SPY	ETF	236.69	236.7	236.63	236.66	21700.0
2017-02-27 08:45:00	SPY	ETF	236.63	236.68	236.63	236.64	6707.0
2017-02-27 08:50:00	SPY	ETF	236.61	236.62	236.57	236.58	11513.0
2017-02-27 08:55:00	SPY	ETF	236.58	236.63	236.58	236.63	32903.0
2017-02-27 09:00:00	SPY	ETF	236.63	236.73	236.63	236.69	60820.0
2017-02-27 09:05:00	SPY	ETF	236.69	236.72	236.66	236.66	21745.0

> showing 50 of 54,761 rows — these rows as CSV

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