PREVIEW / etf_5min / 2011-06-08

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-06-08.parquet
  size:    879 KB
  rows:    36,679

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-06-08 04:00:00	SPY	ETF	128.61	128.61	128.61	128.61	300.0
2011-06-08 04:05:00	SPY	ETF	128.76	128.76	128.76	128.76	600.0
2011-06-08 04:10:00	SPY	ETF	128.63	128.68	128.6	128.68	1750.0
2011-06-08 04:15:00	SPY	ETF	128.61	128.61	128.5	128.5	1800.0
2011-06-08 04:20:00	SPY	ETF	128.47	128.5	128.4	128.5	2900.0
2011-06-08 04:25:00	SPY	ETF	128.52	128.52	128.52	128.52	100.0
2011-06-08 04:35:00	SPY	ETF	128.51	128.51	128.47	128.47	200.0
2011-06-08 04:50:00	SPY	ETF	128.55	128.59	128.55	128.59	400.0
2011-06-08 04:55:00	SPY	ETF	128.59	128.59	128.59	128.59	100.0
2011-06-08 05:05:00	SPY	ETF	128.59	128.59	128.59	128.59	200.0
2011-06-08 05:15:00	SPY	ETF	128.59	128.59	128.59	128.59	1380.0
2011-06-08 05:20:00	SPY	ETF	128.61	128.61	128.59	128.59	220.0
2011-06-08 05:25:00	SPY	ETF	128.54	128.54	128.51	128.51	400.0
2011-06-08 05:35:00	SPY	ETF	128.59	128.59	128.59	128.59	200.0
2011-06-08 05:45:00	SPY	ETF	128.66	128.68	128.66	128.68	200.0
2011-06-08 05:50:00	SPY	ETF	128.68	128.68	128.68	128.68	100.0
2011-06-08 05:55:00	SPY	ETF	128.66	128.7	128.66	128.7	14950.0
2011-06-08 06:00:00	SPY	ETF	128.61	128.66	128.61	128.64	12900.0
2011-06-08 06:05:00	SPY	ETF	128.61	128.61	128.6	128.6	200.0
2011-06-08 06:10:00	SPY	ETF	128.61	128.63	128.57	128.59	1400.0
2011-06-08 06:15:00	SPY	ETF	128.49	128.49	128.49	128.49	300.0
2011-06-08 06:20:00	SPY	ETF	128.5	128.54	128.48	128.49	7750.0
2011-06-08 06:25:00	SPY	ETF	128.48	128.48	128.42	128.45	1000.0
2011-06-08 06:30:00	SPY	ETF	128.4	128.4	128.4	128.4	600.0
2011-06-08 06:35:00	SPY	ETF	128.46	128.46	128.42	128.42	2100.0
2011-06-08 06:40:00	SPY	ETF	128.4	128.4	128.25	128.29	4000.0
2011-06-08 06:45:00	SPY	ETF	128.28	128.28	128.2	128.25	9750.0
2011-06-08 06:50:00	SPY	ETF	128.25	128.28	128.22	128.28	38900.0
2011-06-08 06:55:00	SPY	ETF	128.24	128.36	128.24	128.34	15050.0
2011-06-08 07:00:00	SPY	ETF	128.35	128.41	128.31	128.39	38719.0
2011-06-08 07:05:00	SPY	ETF	128.39	128.42	128.36	128.37	44700.0
2011-06-08 07:10:00	SPY	ETF	128.35	128.44	128.35	128.43	25600.0
2011-06-08 07:15:00	SPY	ETF	128.43	128.49	128.43	128.45	34220.0
2011-06-08 07:20:00	SPY	ETF	128.45	128.46	128.43	128.43	8800.0
2011-06-08 07:25:00	SPY	ETF	128.43	128.44	128.38	128.4	29104.0
2011-06-08 07:30:00	SPY	ETF	128.37	128.44	128.37	128.38	31190.0
2011-06-08 07:35:00	SPY	ETF	128.39	128.39	128.3	128.31	55856.0
2011-06-08 07:40:00	SPY	ETF	128.33	128.36	128.3	128.3	37520.0
2011-06-08 07:45:00	SPY	ETF	128.31	128.35	128.3	128.35	50594.0
2011-06-08 07:50:00	SPY	ETF	128.34	128.42	128.33	128.37	51500.0
2011-06-08 07:55:00	SPY	ETF	128.41	128.44	128.4	128.43	9300.0
2011-06-08 08:00:00	SPY	ETF	128.45	128.65	128.36	128.41	157885.0
2011-06-08 08:05:00	SPY	ETF	128.4	128.41	128.36	128.4	20250.0
2011-06-08 08:10:00	SPY	ETF	128.39	128.42	128.37	128.42	55106.0
2011-06-08 08:15:00	SPY	ETF	128.41	128.49	128.35	128.49	77003.0
2011-06-08 08:20:00	SPY	ETF	128.5	128.52	128.47	128.51	82794.0
2011-06-08 08:25:00	SPY	ETF	128.52	128.55	128.45	128.45	175984.0
2011-06-08 08:30:00	SPY	ETF	128.45	128.46	128.4	128.44	501575.0
2011-06-08 08:35:00	SPY	ETF	128.44	128.55	128.44	128.55	121772.0
2011-06-08 08:40:00	SPY	ETF	128.55	128.61	128.55	128.61	192950.0

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

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