PREVIEW / etf_5min / 2012-10-01

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-10-01.parquet
  size:    907 KB
  rows:    37,094

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-10-01 04:00:00	SPY	ETF	144.3	144.3	144.3	144.3	1000.0
2012-10-01 04:10:00	SPY	ETF	144.35	144.35	144.35	144.35	5000.0
2012-10-01 04:35:00	SPY	ETF	144.37	144.37	144.37	144.37	200.0
2012-10-01 04:40:00	SPY	ETF	144.4	144.55	144.4	144.55	2350.0
2012-10-01 04:45:00	SPY	ETF	144.58	144.6	144.55	144.6	20200.0
2012-10-01 04:50:00	SPY	ETF	144.56	144.56	144.56	144.56	200.0
2012-10-01 04:55:00	SPY	ETF	144.66	144.66	144.66	144.66	100.0
2012-10-01 05:20:00	SPY	ETF	144.7	144.7	144.7	144.7	300.0
2012-10-01 05:25:00	SPY	ETF	144.7	144.7	144.7	144.7	200.0
2012-10-01 05:30:00	SPY	ETF	144.64	144.64	144.64	144.64	100.0
2012-10-01 05:35:00	SPY	ETF	144.63	144.63	144.63	144.63	200.0
2012-10-01 05:50:00	SPY	ETF	144.61	144.61	144.61	144.61	100.0
2012-10-01 06:00:00	SPY	ETF	144.51	144.51	144.5	144.51	1200.0
2012-10-01 06:05:00	SPY	ETF	144.53	144.59	144.53	144.55	1900.0
2012-10-01 06:30:00	SPY	ETF	144.61	144.61	144.61	144.61	100.0
2012-10-01 06:35:00	SPY	ETF	144.6	144.6	144.6	144.6	1100.0
2012-10-01 06:45:00	SPY	ETF	144.59	144.59	144.59	144.59	250.0
2012-10-01 06:55:00	SPY	ETF	144.6	144.6	144.6	144.6	500.0
2012-10-01 07:00:00	SPY	ETF	144.6	144.61	144.59	144.61	3100.0
2012-10-01 07:05:00	SPY	ETF	144.6	144.61	144.59	144.59	4200.0
2012-10-01 07:10:00	SPY	ETF	144.58	144.58	144.5	144.5	6150.0
2012-10-01 07:15:00	SPY	ETF	144.51	144.51	144.47	144.47	5790.0
2012-10-01 07:20:00	SPY	ETF	144.49	144.49	144.46	144.46	1700.0
2012-10-01 07:25:00	SPY	ETF	144.48	144.52	144.47	144.47	27600.0
2012-10-01 07:30:00	SPY	ETF	144.5	144.55	144.5	144.55	40820.0
2012-10-01 07:35:00	SPY	ETF	144.56	144.56	144.54	144.54	1500.0
2012-10-01 07:40:00	SPY	ETF	144.5	144.52	144.43	144.43	61600.0
2012-10-01 07:45:00	SPY	ETF	144.46	144.48	144.45	144.48	2500.0
2012-10-01 07:50:00	SPY	ETF	144.48	144.51	144.48	144.48	1100.0
2012-10-01 07:55:00	SPY	ETF	144.5	144.54	144.5	144.54	9900.0
2012-10-01 08:00:00	SPY	ETF	144.51	144.74	144.35	144.53	113180.0
2012-10-01 08:05:00	SPY	ETF	144.5	144.51	144.44	144.49	9890.0
2012-10-01 08:10:00	SPY	ETF	144.46	144.48	144.44	144.45	25062.0
2012-10-01 08:15:00	SPY	ETF	144.5	144.56	144.5	144.54	131400.0
2012-10-01 08:20:00	SPY	ETF	144.53	144.57	144.52	144.53	15791.0
2012-10-01 08:25:00	SPY	ETF	144.53	144.53	143.93	144.5	11755.0
2012-10-01 08:30:00	SPY	ETF	144.55	144.61	144.53	144.6	57336.0
2012-10-01 08:35:00	SPY	ETF	144.61	144.63	144.56	144.63	22854.0
2012-10-01 08:40:00	SPY	ETF	144.65	144.68	144.55	144.56	57450.0
2012-10-01 08:45:00	SPY	ETF	144.56	144.69	144.55	144.67	158234.0
2012-10-01 08:50:00	SPY	ETF	144.68	144.73	144.67	144.67	42885.0
2012-10-01 08:55:00	SPY	ETF	144.7	144.7	143.97	144.67	60080.0
2012-10-01 09:00:00	SPY	ETF	143.97	144.66	143.97	144.65	118177.0
2012-10-01 09:05:00	SPY	ETF	144.65	144.68	144.62	144.62	51410.0
2012-10-01 09:10:00	SPY	ETF	144.62	144.64	143.97	144.62	126311.0
2012-10-01 09:15:00	SPY	ETF	144.63	144.65	143.93	144.63	103840.0
2012-10-01 09:20:00	SPY	ETF	144.62	144.65	144.57	144.58	59957.0
2012-10-01 09:25:00	SPY	ETF	144.57	144.58	144.5	144.53	201890.0
2012-10-01 09:30:00	SPY	ETF	144.52	144.91	144.43	144.82	3686333.0
2012-10-01 09:35:00	SPY	ETF	144.81	144.9	144.79	144.8799	2098504.0

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

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