PREVIEW / etf_5min / 2012-07-27

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-07-27.parquet
  size:    910 KB
  rows:    36,625

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-27 04:00:00	SPY	ETF	136.12	136.12	136.12	136.12	250.0
2012-07-27 04:25:00	SPY	ETF	136.18	136.18	136.18	136.18	200.0
2012-07-27 04:30:00	SPY	ETF	136.17	136.17	136.17	136.17	500.0
2012-07-27 04:40:00	SPY	ETF	136.2	136.2	136.2	136.2	760.0
2012-07-27 04:45:00	SPY	ETF	136.15	136.15	136.05	136.07	7184.0
2012-07-27 04:50:00	SPY	ETF	136.09	136.09	136.0	136.0	5100.0
2012-07-27 04:55:00	SPY	ETF	136.1	136.1	136.1	136.1	1000.0
2012-07-27 05:00:00	SPY	ETF	136.0	136.0	135.99	135.99	5000.0
2012-07-27 05:05:00	SPY	ETF	136.0	136.05	135.99	136.05	3900.0
2012-07-27 05:15:00	SPY	ETF	135.97	136.1	135.97	136.1	1600.0
2012-07-27 05:20:00	SPY	ETF	136.07	136.07	136.04	136.04	1100.0
2012-07-27 05:30:00	SPY	ETF	135.97	135.99	135.97	135.99	350.0
2012-07-27 05:35:00	SPY	ETF	135.96	135.96	135.96	135.96	300.0
2012-07-27 05:40:00	SPY	ETF	136.05	136.52	136.05	136.52	1185.0
2012-07-27 05:45:00	SPY	ETF	136.41	136.41	136.41	136.41	100.0
2012-07-27 05:50:00	SPY	ETF	136.27	136.27	136.15	136.15	1300.0
2012-07-27 05:55:00	SPY	ETF	136.17	136.22	136.15	136.15	730.0
2012-07-27 06:05:00	SPY	ETF	136.23	136.26	136.22	136.22	400.0
2012-07-27 06:15:00	SPY	ETF	136.27	136.27	136.26	136.27	1405.0
2012-07-27 06:20:00	SPY	ETF	136.39	136.39	136.39	136.39	495.0
2012-07-27 06:25:00	SPY	ETF	136.41	136.44	136.41	136.44	1143.0
2012-07-27 06:30:00	SPY	ETF	136.5	136.5	136.5	136.5	160.0
2012-07-27 06:35:00	SPY	ETF	136.5	136.5	136.45	136.45	2035.0
2012-07-27 06:50:00	SPY	ETF	136.39	136.44	136.38	136.38	4300.0
2012-07-27 06:55:00	SPY	ETF	136.4	136.59	136.4	136.56	12200.0
2012-07-27 07:00:00	SPY	ETF	136.57	136.77	136.57	136.75	89376.0
2012-07-27 07:05:00	SPY	ETF	136.76	136.78	136.6	136.61	63323.0
2012-07-27 07:10:00	SPY	ETF	136.64	136.69	136.62	136.62	10556.0
2012-07-27 07:15:00	SPY	ETF	136.62	136.72	136.62	136.67	201906.0
2012-07-27 07:20:00	SPY	ETF	136.65	136.65	136.55	136.55	13700.0
2012-07-27 07:25:00	SPY	ETF	136.55	136.61	136.54	136.54	6400.0
2012-07-27 07:30:00	SPY	ETF	136.53	136.61	136.51	136.59	71470.0
2012-07-27 07:35:00	SPY	ETF	136.57	136.61	136.54	136.6	4240.0
2012-07-27 07:40:00	SPY	ETF	136.58	136.67	136.52	136.65	11050.0
2012-07-27 07:45:00	SPY	ETF	136.61	136.63	136.55	136.58	6762.0
2012-07-27 07:50:00	SPY	ETF	136.59	136.61	136.54	136.54	6152.0
2012-07-27 07:55:00	SPY	ETF	136.49	136.49	136.44	136.45	29471.0
2012-07-27 08:00:00	SPY	ETF	136.48	136.62	136.42	136.62	36718.0
2012-07-27 08:05:00	SPY	ETF	136.52	136.58	136.47	136.52	43400.0
2012-07-27 08:10:00	SPY	ETF	136.5	136.68	136.5	136.57	81416.0
2012-07-27 08:15:00	SPY	ETF	136.6	136.69	136.59	136.64	41336.0
2012-07-27 08:20:00	SPY	ETF	136.65	136.68	136.62	136.66	88880.0
2012-07-27 08:25:00	SPY	ETF	136.66	136.87	136.65	136.74	272256.0
2012-07-27 08:30:00	SPY	ETF	136.81	137.02	136.78	136.8	999229.0
2012-07-27 08:35:00	SPY	ETF	136.8	136.98	136.73	136.78	230877.0
2012-07-27 08:40:00	SPY	ETF	136.78	136.78	136.59	136.7	263658.0
2012-07-27 08:45:00	SPY	ETF	136.7	136.72	136.53	136.53	115625.0
2012-07-27 08:50:00	SPY	ETF	136.52	136.64	136.47	136.63	111600.0
2012-07-27 08:55:00	SPY	ETF	136.62	136.74	136.62	136.74	173075.0
2012-07-27 09:00:00	SPY	ETF	136.74	136.89	136.72	136.85	764543.0

> showing 50 of 36,625 rows — these rows as CSV

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