PREVIEW / etf_5min / 2014-07-11

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-07-11.parquet
  size:    929 KB
  rows:    39,531

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-07-11 04:00:00	SPY	ETF	196.75	196.75	196.75	196.75	600.0
2014-07-11 04:05:00	SPY	ETF	196.79	196.79	196.79	196.79	4481.0
2014-07-11 04:30:00	SPY	ETF	196.67	196.67	196.67	196.67	191.0
2014-07-11 04:35:00	SPY	ETF	196.7	196.7	196.7	196.7	1619.0
2014-07-11 04:50:00	SPY	ETF	196.68	196.68	196.68	196.68	100.0
2014-07-11 04:55:00	SPY	ETF	196.68	196.71	196.68	196.71	300.0
2014-07-11 05:05:00	SPY	ETF	196.69	196.7	196.69	196.7	1600.0
2014-07-11 05:20:00	SPY	ETF	196.65	196.65	196.65	196.65	100.0
2014-07-11 05:35:00	SPY	ETF	196.61	196.63	196.59	196.63	2400.0
2014-07-11 05:45:00	SPY	ETF	196.59	196.59	196.59	196.59	100.0
2014-07-11 05:50:00	SPY	ETF	196.63	196.65	196.63	196.65	1803.0
2014-07-11 06:05:00	SPY	ETF	196.65	196.65	196.65	196.65	2800.0
2014-07-11 06:15:00	SPY	ETF	196.67	196.67	196.67	196.67	200.0
2014-07-11 06:25:00	SPY	ETF	196.7	196.7	196.7	196.7	100.0
2014-07-11 06:30:00	SPY	ETF	196.71	196.72	196.66	196.66	11471.0
2014-07-11 06:40:00	SPY	ETF	196.6	196.62	196.59	196.59	26100.0
2014-07-11 06:45:00	SPY	ETF	196.57	196.57	196.57	196.57	100.0
2014-07-11 06:50:00	SPY	ETF	196.55	196.55	196.49	196.49	1500.0
2014-07-11 06:55:00	SPY	ETF	196.47	196.49	196.43	196.47	1250.0
2014-07-11 07:00:00	SPY	ETF	196.49	196.63	196.49	196.57	15376.0
2014-07-11 07:05:00	SPY	ETF	196.57	196.58	196.57	196.58	3890.0
2014-07-11 07:10:00	SPY	ETF	196.57	196.59	196.57	196.59	400.0
2014-07-11 07:15:00	SPY	ETF	196.57	196.59	196.56	196.59	19240.0
2014-07-11 07:20:00	SPY	ETF	196.6	196.62	196.6	196.6	29100.0
2014-07-11 07:25:00	SPY	ETF	196.59	196.6	196.57	196.59	25476.0
2014-07-11 07:30:00	SPY	ETF	196.62	196.65	196.62	196.65	20900.0
2014-07-11 07:35:00	SPY	ETF	196.64	196.65	196.64	196.65	5300.0
2014-07-11 07:40:00	SPY	ETF	196.62	196.62	196.62	196.62	1400.0
2014-07-11 07:45:00	SPY	ETF	196.6	196.62	196.6	196.61	700.0
2014-07-11 07:50:00	SPY	ETF	196.61	196.65	196.6	196.65	7914.0
2014-07-11 07:55:00	SPY	ETF	196.65	196.67	196.62	196.67	13400.0
2014-07-11 08:00:00	SPY	ETF	196.65	196.68	196.54	196.58	50947.0
2014-07-11 08:05:00	SPY	ETF	196.57	196.59	196.56	196.57	42200.0
2014-07-11 08:10:00	SPY	ETF	196.57	196.58	196.54	196.54	51920.0
2014-07-11 08:15:00	SPY	ETF	196.54	196.54	196.42	196.47	68539.0
2014-07-11 08:20:00	SPY	ETF	196.43	196.45	196.4	196.44	23942.0
2014-07-11 08:25:00	SPY	ETF	196.45	196.46	196.41	196.46	21188.0
2014-07-11 08:30:00	SPY	ETF	196.47	196.5	196.43	196.45	18480.0
2014-07-11 08:35:00	SPY	ETF	196.46	196.49	196.43	196.43	40002.0
2014-07-11 08:40:00	SPY	ETF	196.43	196.45	196.4	196.41	3997.0
2014-07-11 08:45:00	SPY	ETF	196.42	196.42	196.35	196.39	132626.0
2014-07-11 08:50:00	SPY	ETF	196.38	196.38	196.22	196.27	48035.0
2014-07-11 08:55:00	SPY	ETF	196.26	196.29	196.2	196.23	586304.0
2014-07-11 09:00:00	SPY	ETF	196.22	196.29	196.18	196.28	71403.0
2014-07-11 09:05:00	SPY	ETF	196.29	196.35	196.28	196.34	43606.0
2014-07-11 09:10:00	SPY	ETF	196.34	196.34	196.28	196.31	50241.0
2014-07-11 09:15:00	SPY	ETF	196.3	196.3	196.2	196.2	18369.0
2014-07-11 09:20:00	SPY	ETF	196.23	196.28	196.2	196.25	13202.0
2014-07-11 09:25:00	SPY	ETF	196.25	196.28	196.22	196.22	86186.0
2014-07-11 09:30:00	SPY	ETF	196.22	196.47	196.12	196.35	2260679.0

> showing 50 of 39,531 rows — these rows as CSV

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