PREVIEW / etf_5min / 2011-07-28

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-07-28.parquet
  size:    902 KB
  rows:    37,196

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
2011-07-28 04:00:00	SPY	ETF	130.77	131.0	130.77	131.0	800.0
2011-07-28 04:25:00	SPY	ETF	130.95	130.95	130.95	130.95	562.0
2011-07-28 04:35:00	SPY	ETF	130.95	130.95	130.95	130.95	1438.0
2011-07-28 04:45:00	SPY	ETF	130.92	130.92	130.92	130.92	550.0
2011-07-28 05:05:00	SPY	ETF	130.62	130.62	130.62	130.62	1000.0
2011-07-28 05:10:00	SPY	ETF	130.8	130.8	130.8	130.8	500.0
2011-07-28 05:30:00	SPY	ETF	130.7	130.7	130.6	130.6	900.0
2011-07-28 05:40:00	SPY	ETF	130.48	130.48	130.4	130.4	1200.0
2011-07-28 06:00:00	SPY	ETF	130.3	130.3	130.3	130.3	960.0
2011-07-28 06:05:00	SPY	ETF	130.44	130.44	130.44	130.44	100.0
2011-07-28 06:15:00	SPY	ETF	130.3	130.3	130.28	130.28	371.0
2011-07-28 06:20:00	SPY	ETF	130.28	130.3	130.28	130.3	600.0
2011-07-28 06:25:00	SPY	ETF	130.33	130.33	130.11	130.11	2090.0
2011-07-28 06:30:00	SPY	ETF	130.11	130.11	130.11	130.11	200.0
2011-07-28 06:35:00	SPY	ETF	130.36	130.37	130.22	130.37	1400.0
2011-07-28 06:50:00	SPY	ETF	130.43	130.55	130.43	130.55	10400.0
2011-07-28 06:55:00	SPY	ETF	130.55	130.7	130.55	130.6	107550.0
2011-07-28 07:00:00	SPY	ETF	130.64	130.65	130.58	130.6	32249.0
2011-07-28 07:05:00	SPY	ETF	130.56	130.57	130.52	130.54	8130.0
2011-07-28 07:10:00	SPY	ETF	130.51	130.52	130.48	130.48	5800.0
2011-07-28 07:15:00	SPY	ETF	130.52	130.55	130.48	130.48	17300.0
2011-07-28 07:20:00	SPY	ETF	130.48	130.59	130.43	130.56	126150.0
2011-07-28 07:25:00	SPY	ETF	130.59	130.67	130.55	130.56	21170.0
2011-07-28 07:30:00	SPY	ETF	130.55	130.56	130.51	130.55	2430.0
2011-07-28 07:35:00	SPY	ETF	130.65	130.75	130.64	130.65	101890.0
2011-07-28 07:40:00	SPY	ETF	130.65	130.65	130.6	130.65	62250.0
2011-07-28 07:45:00	SPY	ETF	130.68	130.7	130.63	130.68	17400.0
2011-07-28 07:50:00	SPY	ETF	130.68	130.68	130.6	130.6	14500.0
2011-07-28 07:55:00	SPY	ETF	130.59	130.59	130.48	130.53	47465.0
2011-07-28 08:00:00	SPY	ETF	130.54	130.55	130.3	130.36	148710.0
2011-07-28 08:05:00	SPY	ETF	130.39	130.44	130.36	130.38	71144.0
2011-07-28 08:10:00	SPY	ETF	130.37	130.37	130.19	130.28	135753.0
2011-07-28 08:15:00	SPY	ETF	130.28	130.32	130.26	130.31	46361.0
2011-07-28 08:20:00	SPY	ETF	130.3	130.33	130.21	130.26	77537.0
2011-07-28 08:25:00	SPY	ETF	130.26	130.32	130.18	130.18	185233.0
2011-07-28 08:30:00	SPY	ETF	130.3	130.74	130.3	130.6	1740482.0
2011-07-28 08:35:00	SPY	ETF	130.58	130.88	130.51	130.85	1579824.0
2011-07-28 08:40:00	SPY	ETF	130.85	130.93	130.78	130.9	641053.0
2011-07-28 08:45:00	SPY	ETF	130.89	131.05	130.8	130.95	1639607.0
2011-07-28 08:50:00	SPY	ETF	130.95	130.96	130.8	130.84	660887.0
2011-07-28 08:55:00	SPY	ETF	130.81	130.85	130.53	130.6	325020.0
2011-07-28 09:00:00	SPY	ETF	130.6	130.69	130.59	130.64	203093.0
2011-07-28 09:05:00	SPY	ETF	130.64	130.67	130.55	130.62	479463.0
2011-07-28 09:10:00	SPY	ETF	130.65	130.7	130.6	130.67	177878.0
2011-07-28 09:15:00	SPY	ETF	130.66	130.66	130.57	130.64	324939.0
2011-07-28 09:20:00	SPY	ETF	130.65	130.7	130.63	130.66	405931.0
2011-07-28 09:25:00	SPY	ETF	130.66	130.69	130.58	130.59	324345.0
2011-07-28 09:30:00	SPY	ETF	130.6	130.92	130.52	130.739	4351454.0
2011-07-28 09:35:00	SPY	ETF	130.74	130.77	130.5489	130.55	3161822.0
2011-07-28 09:40:00	SPY	ETF	130.55	130.58	130.45	130.56	3065945.0

> showing 50 of 37,196 rows — these rows as CSV

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