PREVIEW / etf_5min / 2012-07-06

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-07-06.parquet
  size:    831 KB
  rows:    34,546

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-06 04:00:00	SPY	ETF	136.69	136.69	136.69	136.69	1992.0
2012-07-06 04:40:00	SPY	ETF	136.68	136.69	136.62	136.62	800.0
2012-07-06 04:45:00	SPY	ETF	136.59	136.59	136.59	136.59	100.0
2012-07-06 04:50:00	SPY	ETF	136.6	136.7	136.6	136.7	10000.0
2012-07-06 05:00:00	SPY	ETF	136.54	136.54	136.54	136.54	1282.0
2012-07-06 05:25:00	SPY	ETF	136.5	136.5	136.5	136.5	5000.0
2012-07-06 05:40:00	SPY	ETF	136.47	136.47	136.47	136.47	3539.0
2012-07-06 05:45:00	SPY	ETF	136.41	136.41	136.41	136.41	200.0
2012-07-06 05:50:00	SPY	ETF	136.45	136.45	136.45	136.45	1000.0
2012-07-06 05:55:00	SPY	ETF	136.5	136.5	136.45	136.45	3800.0
2012-07-06 06:15:00	SPY	ETF	136.46	136.46	136.46	136.46	135.0
2012-07-06 06:50:00	SPY	ETF	136.48	136.49	136.48	136.49	5100.0
2012-07-06 06:55:00	SPY	ETF	136.49	136.55	136.49	136.55	7339.0
2012-07-06 07:00:00	SPY	ETF	136.54	136.54	136.53	136.53	25700.0
2012-07-06 07:05:00	SPY	ETF	136.62	136.62	136.62	136.62	200.0
2012-07-06 07:10:00	SPY	ETF	136.62	136.63	136.6	136.63	3000.0
2012-07-06 07:15:00	SPY	ETF	136.6	136.6	136.53	136.54	5100.0
2012-07-06 07:20:00	SPY	ETF	136.5	136.51	136.37	136.42	19250.0
2012-07-06 07:25:00	SPY	ETF	136.41	136.52	136.41	136.52	12860.0
2012-07-06 07:30:00	SPY	ETF	136.56	136.56	136.47	136.47	12050.0
2012-07-06 07:35:00	SPY	ETF	136.47	136.57	136.47	136.57	3400.0
2012-07-06 07:40:00	SPY	ETF	136.56	136.56	136.54	136.54	1761.0
2012-07-06 07:45:00	SPY	ETF	136.54	136.55	136.51	136.55	12200.0
2012-07-06 07:50:00	SPY	ETF	136.53	136.53	136.48	136.48	10300.0
2012-07-06 07:55:00	SPY	ETF	136.49	136.49	136.48	136.48	48200.0
2012-07-06 08:00:00	SPY	ETF	136.48	136.57	136.33	136.46	93138.0
2012-07-06 08:05:00	SPY	ETF	136.45	136.49	136.45	136.48	51198.0
2012-07-06 08:10:00	SPY	ETF	136.48	136.49	136.45	136.46	134350.0
2012-07-06 08:15:00	SPY	ETF	136.45	136.49	136.45	136.48	103000.0
2012-07-06 08:20:00	SPY	ETF	136.48	136.48	136.41	136.41	656300.0
2012-07-06 08:25:00	SPY	ETF	136.4	136.5	136.24	136.24	1025758.0
2012-07-06 08:30:00	SPY	ETF	136.24	136.24	135.92	135.98	2420849.0
2012-07-06 08:35:00	SPY	ETF	135.98	136.0	135.79	135.85	999912.0
2012-07-06 08:40:00	SPY	ETF	135.84	135.92	135.76	135.77	572752.0
2012-07-06 08:45:00	SPY	ETF	135.77	135.81	135.67	135.68	447844.0
2012-07-06 08:50:00	SPY	ETF	135.67	135.73	135.58	135.7	447022.0
2012-07-06 08:55:00	SPY	ETF	135.7	135.72	135.57	135.67	364869.0
2012-07-06 09:00:00	SPY	ETF	135.66	135.78	135.61	135.73	286367.0
2012-07-06 09:05:00	SPY	ETF	135.73	135.86	135.73	135.77	206952.0
2012-07-06 09:10:00	SPY	ETF	135.77	135.79	135.69	135.74	198793.0
2012-07-06 09:15:00	SPY	ETF	135.74	135.77	135.67	135.7	208249.0
2012-07-06 09:20:00	SPY	ETF	135.7	135.75	135.58	135.61	210548.0
2012-07-06 09:25:00	SPY	ETF	135.62	135.67	135.43	135.47	686730.0
2012-07-06 09:30:00	SPY	ETF	135.47	135.7	135.47	135.6	4161971.0
2012-07-06 09:35:00	SPY	ETF	135.6	135.71	135.52	135.62	2846474.0
2012-07-06 09:40:00	SPY	ETF	135.61	135.77	135.52	135.6	2375283.0
2012-07-06 09:45:00	SPY	ETF	135.6	135.62	135.43	135.5	2392972.0
2012-07-06 09:50:00	SPY	ETF	135.5	135.57	135.37	135.47	2439399.0
2012-07-06 09:55:00	SPY	ETF	135.48	135.61	135.37	135.59	2272675.0
2012-07-06 10:00:00	SPY	ETF	135.59	135.65	135.51	135.56	3420396.0

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

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