PREVIEW / etf_5min / 2014-05-20

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-05-20.parquet
  size:    976 KB
  rows:    41,449

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-05-20 04:00:00	SPY	ETF	188.83	188.83	188.83	188.83	137.0
2014-05-20 04:05:00	SPY	ETF	188.78	188.78	188.78	188.78	600.0
2014-05-20 04:10:00	SPY	ETF	188.76	188.76	188.76	188.76	150.0
2014-05-20 04:15:00	SPY	ETF	188.73	188.76	188.73	188.76	800.0
2014-05-20 04:35:00	SPY	ETF	188.58	188.6	188.58	188.6	8250.0
2014-05-20 04:40:00	SPY	ETF	188.58	188.58	188.58	188.58	134.0
2014-05-20 04:45:00	SPY	ETF	188.46	188.46	188.46	188.46	2500.0
2014-05-20 04:55:00	SPY	ETF	188.56	188.56	188.56	188.56	100.0
2014-05-20 05:15:00	SPY	ETF	188.66	188.66	188.66	188.66	123.0
2014-05-20 05:20:00	SPY	ETF	188.7	188.7	188.68	188.68	237.0
2014-05-20 05:35:00	SPY	ETF	188.67	188.67	188.67	188.67	301.0
2014-05-20 05:45:00	SPY	ETF	188.67	188.67	188.61	188.62	1300.0
2014-05-20 06:00:00	SPY	ETF	188.59	188.59	188.59	188.59	500.0
2014-05-20 06:05:00	SPY	ETF	188.63	188.75	188.63	188.72	5202.0
2014-05-20 06:10:00	SPY	ETF	188.72	188.72	188.72	188.72	295.0
2014-05-20 06:15:00	SPY	ETF	188.67	188.67	188.67	188.67	500.0
2014-05-20 06:25:00	SPY	ETF	188.7	188.7	188.7	188.7	200.0
2014-05-20 06:30:00	SPY	ETF	188.69	188.69	188.67	188.67	825.0
2014-05-20 06:35:00	SPY	ETF	188.64	188.7	188.59	188.67	6066.0
2014-05-20 06:40:00	SPY	ETF	188.65	188.67	188.63	188.67	3100.0
2014-05-20 06:45:00	SPY	ETF	188.63	188.64	188.62	188.64	3000.0
2014-05-20 06:55:00	SPY	ETF	188.66	188.71	188.66	188.71	680.0
2014-05-20 07:00:00	SPY	ETF	188.68	188.83	188.68	188.83	13145.0
2014-05-20 07:05:00	SPY	ETF	188.8	188.88	188.8	188.86	1805.0
2014-05-20 07:10:00	SPY	ETF	188.83	188.86	188.8	188.8	1585.0
2014-05-20 07:15:00	SPY	ETF	188.81	188.88	188.81	188.88	1902.0
2014-05-20 07:20:00	SPY	ETF	188.87	188.9	188.87	188.9	5000.0
2014-05-20 07:25:00	SPY	ETF	188.84	188.84	188.84	188.84	650.0
2014-05-20 07:30:00	SPY	ETF	188.88	188.91	188.86	188.89	31418.0
2014-05-20 07:35:00	SPY	ETF	188.84	188.84	188.84	188.84	27700.0
2014-05-20 07:40:00	SPY	ETF	188.87	188.87	188.78	188.81	19100.0
2014-05-20 07:45:00	SPY	ETF	188.78	188.81	188.78	188.8	724.0
2014-05-20 07:50:00	SPY	ETF	188.78	188.78	188.75	188.75	26100.0
2014-05-20 07:55:00	SPY	ETF	188.75	188.79	188.75	188.79	3389.0
2014-05-20 08:00:00	SPY	ETF	188.77	188.84	188.73	188.73	23926.0
2014-05-20 08:05:00	SPY	ETF	188.76	188.78	188.74	188.78	10651.0
2014-05-20 08:10:00	SPY	ETF	188.79	188.85	188.78	188.84	10229.0
2014-05-20 08:15:00	SPY	ETF	188.84	188.9	188.83	188.89	37630.0
2014-05-20 08:20:00	SPY	ETF	188.89	188.89	188.85	188.85	9177.0
2014-05-20 08:25:00	SPY	ETF	188.84	188.88	188.84	188.84	23425.0
2014-05-20 08:30:00	SPY	ETF	188.83	188.83	188.63	188.67	67858.0
2014-05-20 08:35:00	SPY	ETF	188.67	188.7	188.66	188.67	25779.0
2014-05-20 08:40:00	SPY	ETF	188.68	188.72	188.68	188.72	61454.0
2014-05-20 08:45:00	SPY	ETF	188.72	188.76	188.7	188.73	64704.0
2014-05-20 08:50:00	SPY	ETF	188.73	188.73	188.7	188.72	32178.0
2014-05-20 08:55:00	SPY	ETF	188.7	188.71	188.64	188.64	53911.0
2014-05-20 09:00:00	SPY	ETF	188.64	188.64	188.55	188.55	56918.0
2014-05-20 09:05:00	SPY	ETF	188.56	188.62	188.56	188.61	14995.0
2014-05-20 09:10:00	SPY	ETF	188.6	188.61	188.58	188.6	71282.0
2014-05-20 09:15:00	SPY	ETF	188.6	188.64	188.59	188.61	46479.0

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

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