PREVIEW / etf_5min / 2012-07-03

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-07-03.parquet
  size:    569 KB
  rows:    22,250

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
2012-07-03 04:00:00	SPY	ETF	136.31	136.31	136.31	136.31	100.0
2012-07-03 04:25:00	SPY	ETF	136.21	136.21	136.15	136.15	700.0
2012-07-03 04:35:00	SPY	ETF	136.15	136.15	136.15	136.15	1100.0
2012-07-03 04:55:00	SPY	ETF	136.33	136.33	136.31	136.31	1200.0
2012-07-03 05:55:00	SPY	ETF	136.43	136.43	136.43	136.43	120.0
2012-07-03 06:05:00	SPY	ETF	136.36	136.36	136.36	136.36	10000.0
2012-07-03 06:10:00	SPY	ETF	136.32	136.32	136.32	136.32	1600.0
2012-07-03 06:30:00	SPY	ETF	136.24	136.24	136.24	136.24	500.0
2012-07-03 06:35:00	SPY	ETF	136.25	136.25	136.25	136.25	300.0
2012-07-03 06:40:00	SPY	ETF	136.25	136.25	136.25	136.25	100.0
2012-07-03 06:45:00	SPY	ETF	136.24	136.24	136.22	136.22	500.0
2012-07-03 07:00:00	SPY	ETF	136.3	136.33	136.3	136.33	11200.0
2012-07-03 07:05:00	SPY	ETF	136.33	136.36	136.31	136.36	11225.0
2012-07-03 07:10:00	SPY	ETF	136.36	136.42	136.35	136.38	40230.0
2012-07-03 07:15:00	SPY	ETF	136.4	136.41	136.39	136.39	10590.0
2012-07-03 07:20:00	SPY	ETF	136.37	136.41	136.36	136.36	3825.0
2012-07-03 07:25:00	SPY	ETF	136.39	136.4	136.35	136.35	5900.0
2012-07-03 07:30:00	SPY	ETF	136.38	136.46	136.38	136.45	28602.0
2012-07-03 07:35:00	SPY	ETF	136.45	136.49	136.45	136.48	23900.0
2012-07-03 07:40:00	SPY	ETF	136.49	136.49	136.44	136.44	1900.0
2012-07-03 07:45:00	SPY	ETF	136.45	136.47	136.44	136.44	1600.0
2012-07-03 07:50:00	SPY	ETF	136.44	136.5	136.44	136.48	3000.0
2012-07-03 07:55:00	SPY	ETF	136.49	136.5	136.44	136.44	71210.0
2012-07-03 08:00:00	SPY	ETF	136.43	136.48	136.42	136.47	8100.0
2012-07-03 08:05:00	SPY	ETF	136.47	136.47	136.44	136.44	6850.0
2012-07-03 08:10:00	SPY	ETF	136.44	136.45	136.34	136.39	96198.0
2012-07-03 08:15:00	SPY	ETF	136.4	136.4	136.36	136.37	16600.0
2012-07-03 08:20:00	SPY	ETF	136.37	136.4	136.34	136.34	4400.0
2012-07-03 08:25:00	SPY	ETF	136.39	136.42	136.34	136.41	35400.0
2012-07-03 08:30:00	SPY	ETF	136.39	136.42	136.35	136.41	12200.0
2012-07-03 08:35:00	SPY	ETF	136.41	136.41	136.39	136.39	4286.0
2012-07-03 08:40:00	SPY	ETF	136.38	136.4	136.35	136.36	50791.0
2012-07-03 08:45:00	SPY	ETF	136.37	136.47	136.36	136.46	51301.0
2012-07-03 08:50:00	SPY	ETF	136.47	136.5	136.46	136.5	109300.0
2012-07-03 08:55:00	SPY	ETF	136.5	136.51	136.46	136.47	60294.0
2012-07-03 09:00:00	SPY	ETF	136.49	136.51	136.42	136.44	50800.0
2012-07-03 09:05:00	SPY	ETF	136.44	136.48	136.41	136.43	25451.0
2012-07-03 09:10:00	SPY	ETF	136.43	136.43	136.37	136.39	43977.0
2012-07-03 09:15:00	SPY	ETF	136.4	136.4	136.35	136.38	49106.0
2012-07-03 09:20:00	SPY	ETF	136.38	136.43	136.38	136.41	72854.0
2012-07-03 09:25:00	SPY	ETF	136.4	136.5	136.4	136.48	283000.0
2012-07-03 09:30:00	SPY	ETF	136.48	136.55	136.44	136.46	2535287.0
2012-07-03 09:35:00	SPY	ETF	136.46	136.55	136.34	136.54	2922883.0
2012-07-03 09:40:00	SPY	ETF	136.535	136.72	136.53	136.6801	1822537.0
2012-07-03 09:45:00	SPY	ETF	136.68	136.71	136.64	136.69	1404947.0
2012-07-03 09:50:00	SPY	ETF	136.68	136.76	136.62	136.715	1092226.0
2012-07-03 09:55:00	SPY	ETF	136.72	136.87	136.72	136.79	1497391.0
2012-07-03 10:00:00	SPY	ETF	136.79	137.03	136.79	136.9915	3153227.0
2012-07-03 10:05:00	SPY	ETF	136.995	137.0	136.9	136.96	1348228.0
2012-07-03 10:10:00	SPY	ETF	136.96	136.97	136.85	136.86	1449801.0

> showing 50 of 22,250 rows — these rows as CSV

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