PREVIEW / etf_5min / 2014-04-23

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-04-23.parquet
  size:    939 KB
  rows:    41,475

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
2014-04-23 04:15:00	SPY	ETF	188.0	188.0	188.0	188.0	2800.0
2014-04-23 04:20:00	SPY	ETF	188.05	188.1	188.05	188.1	1300.0
2014-04-23 05:00:00	SPY	ETF	187.97	187.97	187.97	187.97	300.0
2014-04-23 05:05:00	SPY	ETF	187.84	187.96	187.84	187.96	1101.0
2014-04-23 05:25:00	SPY	ETF	187.94	187.94	187.94	187.94	10000.0
2014-04-23 05:35:00	SPY	ETF	187.89	187.89	187.89	187.89	139.0
2014-04-23 05:45:00	SPY	ETF	187.97	187.97	187.84	187.84	349.0
2014-04-23 05:55:00	SPY	ETF	187.83	187.83	187.72	187.72	2365.0
2014-04-23 06:05:00	SPY	ETF	187.72	187.72	187.72	187.72	100.0
2014-04-23 06:10:00	SPY	ETF	187.78	187.78	187.73	187.73	950.0
2014-04-23 06:15:00	SPY	ETF	187.7	187.75	187.7	187.75	300.0
2014-04-23 06:20:00	SPY	ETF	187.78	187.78	187.78	187.78	400.0
2014-04-23 06:25:00	SPY	ETF	187.78	187.78	187.78	187.78	100.0
2014-04-23 06:30:00	SPY	ETF	187.74	187.78	187.73	187.76	1800.0
2014-04-23 06:35:00	SPY	ETF	187.75	187.75	187.75	187.75	179.0
2014-04-23 06:40:00	SPY	ETF	187.75	187.75	187.75	187.75	154.0
2014-04-23 06:50:00	SPY	ETF	187.73	187.75	187.73	187.74	946.0
2014-04-23 07:00:00	SPY	ETF	187.75	187.77	187.74	187.75	7216.0
2014-04-23 07:05:00	SPY	ETF	187.77	187.77	187.68	187.69	44661.0
2014-04-23 07:10:00	SPY	ETF	187.73	187.74	187.7	187.72	6600.0
2014-04-23 07:15:00	SPY	ETF	187.74	187.74	187.74	187.74	400.0
2014-04-23 07:20:00	SPY	ETF	187.74	187.74	187.74	187.74	635.0
2014-04-23 07:25:00	SPY	ETF	187.73	187.73	187.7	187.72	9500.0
2014-04-23 07:30:00	SPY	ETF	187.71	187.82	187.71	187.79	6055.0
2014-04-23 07:35:00	SPY	ETF	187.81	187.83	187.77	187.77	35120.0
2014-04-23 07:40:00	SPY	ETF	187.76	187.81	187.76	187.78	25769.0
2014-04-23 07:45:00	SPY	ETF	187.75	187.77	187.75	187.76	1998.0
2014-04-23 07:50:00	SPY	ETF	187.81	187.81	187.7	187.7	24229.0
2014-04-23 07:55:00	SPY	ETF	187.7	187.74	187.68	187.7	20126.0
2014-04-23 08:00:00	SPY	ETF	187.7	187.78	187.7	187.73	10413.0
2014-04-23 08:05:00	SPY	ETF	187.74	187.75	187.63	187.63	54370.0
2014-04-23 08:10:00	SPY	ETF	187.63	187.67	187.59	187.6	60575.0
2014-04-23 08:15:00	SPY	ETF	187.59	187.62	187.55	187.61	67237.0
2014-04-23 08:20:00	SPY	ETF	187.61	187.68	187.61	187.68	29363.0
2014-04-23 08:25:00	SPY	ETF	187.68	187.7	187.64	187.64	13985.0
2014-04-23 08:30:00	SPY	ETF	187.64	187.72	187.64	187.72	42940.0
2014-04-23 08:35:00	SPY	ETF	187.72	187.73	187.7	187.72	14569.0
2014-04-23 08:40:00	SPY	ETF	187.73	187.76	187.73	187.74	25835.0
2014-04-23 08:45:00	SPY	ETF	187.74	187.81	187.73	187.8	52404.0
2014-04-23 08:50:00	SPY	ETF	187.8	187.83	187.79	187.8	130502.0
2014-04-23 08:55:00	SPY	ETF	187.8	187.82	187.75	187.77	17556.0
2014-04-23 09:00:00	SPY	ETF	187.78	187.82	187.76	187.8	24427.0
2014-04-23 09:05:00	SPY	ETF	187.78	187.8	187.75	187.77	4600.0
2014-04-23 09:10:00	SPY	ETF	187.79	187.79	187.74	187.75	49584.0
2014-04-23 09:15:00	SPY	ETF	187.74	187.77	187.73	187.74	19280.0
2014-04-23 09:20:00	SPY	ETF	187.74	187.81	187.73	187.78	55054.0
2014-04-23 09:25:00	SPY	ETF	187.78	187.82	187.76	187.81	111799.0
2014-04-23 09:30:00	SPY	ETF	187.81	187.84	187.67	187.78	1781439.0
2014-04-23 09:35:00	SPY	ETF	187.78	187.79	187.6	187.7	1541425.0
2014-04-23 09:40:00	SPY	ETF	187.71	187.92	187.64	187.69	1431467.0

> showing 50 of 41,475 rows — these rows as CSV

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