PREVIEW / etf_5min / 2012-04-20

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-04-20.parquet
  size:    807 KB
  rows:    34,269

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-04-20 04:00:00	SPY	ETF	138.17	138.17	138.17	138.17	500.0
2012-04-20 04:05:00	SPY	ETF	138.19	138.19	138.19	138.19	500.0
2012-04-20 04:15:00	SPY	ETF	138.01	138.01	138.01	138.01	100.0
2012-04-20 04:25:00	SPY	ETF	138.06	138.06	138.06	138.06	200.0
2012-04-20 04:35:00	SPY	ETF	138.05	138.07	138.05	138.07	450.0
2012-04-20 04:40:00	SPY	ETF	137.88	137.88	137.78	137.78	1400.0
2012-04-20 04:45:00	SPY	ETF	137.74	137.74	137.74	137.74	5000.0
2012-04-20 05:10:00	SPY	ETF	137.86	137.86	137.86	137.86	160.0
2012-04-20 05:35:00	SPY	ETF	137.88	137.88	137.88	137.88	500.0
2012-04-20 06:00:00	SPY	ETF	138.22	138.22	138.22	138.22	500.0
2012-04-20 06:05:00	SPY	ETF	138.25	138.32	138.25	138.32	3800.0
2012-04-20 06:10:00	SPY	ETF	138.4	138.4	138.4	138.4	500.0
2012-04-20 06:15:00	SPY	ETF	138.35	138.42	138.35	138.42	2300.0
2012-04-20 06:20:00	SPY	ETF	138.42	138.42	138.42	138.42	100.0
2012-04-20 06:25:00	SPY	ETF	138.4	138.4	138.4	138.4	1000.0
2012-04-20 06:30:00	SPY	ETF	138.39	138.4	138.3	138.3	1600.0
2012-04-20 06:35:00	SPY	ETF	138.33	138.5	138.33	138.43	3400.0
2012-04-20 06:40:00	SPY	ETF	138.47	138.61	138.47	138.48	17400.0
2012-04-20 06:45:00	SPY	ETF	138.45	138.45	138.4	138.45	17300.0
2012-04-20 06:50:00	SPY	ETF	138.45	138.45	138.38	138.38	9200.0
2012-04-20 06:55:00	SPY	ETF	138.38	138.45	138.38	138.45	9300.0
2012-04-20 07:00:00	SPY	ETF	138.47	138.47	138.4	138.45	43300.0
2012-04-20 07:05:00	SPY	ETF	138.41	138.44	138.37	138.38	28700.0
2012-04-20 07:10:00	SPY	ETF	138.39	138.43	138.36	138.37	24950.0
2012-04-20 07:15:00	SPY	ETF	138.36	138.36	138.31	138.31	9000.0
2012-04-20 07:20:00	SPY	ETF	138.34	138.34	138.33	138.33	13850.0
2012-04-20 07:25:00	SPY	ETF	138.26	138.34	138.24	138.27	79280.0
2012-04-20 07:30:00	SPY	ETF	138.26	138.27	138.18	138.22	29912.0
2012-04-20 07:35:00	SPY	ETF	138.24	138.24	138.2	138.2	11100.0
2012-04-20 07:40:00	SPY	ETF	138.2	138.3	138.2	138.25	40726.0
2012-04-20 07:45:00	SPY	ETF	138.25	138.29	138.25	138.26	9650.0
2012-04-20 07:50:00	SPY	ETF	138.23	138.42	138.23	138.42	632030.0
2012-04-20 07:55:00	SPY	ETF	138.39	138.39	138.32	138.34	12000.0
2012-04-20 08:00:00	SPY	ETF	138.33	138.58	137.81	138.3	1038301.0
2012-04-20 08:05:00	SPY	ETF	138.52	138.56	138.47	138.52	31891.0
2012-04-20 08:10:00	SPY	ETF	138.52	138.52	138.48	138.49	14840.0
2012-04-20 08:15:00	SPY	ETF	138.49	138.55	138.46	138.47	26900.0
2012-04-20 08:20:00	SPY	ETF	138.48	138.48	138.36	138.4	32110.0
2012-04-20 08:25:00	SPY	ETF	138.39	138.44	138.36	138.43	116375.0
2012-04-20 08:30:00	SPY	ETF	138.44	138.45	138.39	138.4	35597.0
2012-04-20 08:35:00	SPY	ETF	138.38	138.45	138.38	138.43	188616.0
2012-04-20 08:40:00	SPY	ETF	138.44	138.47	138.43	138.47	87407.0
2012-04-20 08:45:00	SPY	ETF	138.47	138.51	138.42	138.44	84140.0
2012-04-20 08:50:00	SPY	ETF	138.44	138.45	138.39	138.43	119819.0
2012-04-20 08:55:00	SPY	ETF	138.44	138.45	138.29	138.36	131957.0
2012-04-20 09:00:00	SPY	ETF	138.35	138.38	138.32	138.37	61364.0
2012-04-20 09:05:00	SPY	ETF	138.36	138.43	138.35	138.37	121255.0
2012-04-20 09:10:00	SPY	ETF	138.37	138.43	138.34	138.43	38657.0
2012-04-20 09:15:00	SPY	ETF	138.43	138.49	138.35	138.39	176607.0
2012-04-20 09:20:00	SPY	ETF	138.38	138.41	138.36	138.38	96867.0

> showing 50 of 34,269 rows — these rows as CSV

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