PREVIEW / etf_5min / 2013-05-20

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-05-20.parquet
  size:    1004 KB
  rows:    42,395

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
2013-05-20 04:00:00	SPY	ETF	166.68	166.68	166.67	166.67	1297.0
2013-05-20 04:10:00	SPY	ETF	166.71	166.71	166.71	166.71	2500.0
2013-05-20 04:20:00	SPY	ETF	166.71	166.71	166.71	166.71	200.0
2013-05-20 05:15:00	SPY	ETF	166.66	166.66	166.66	166.66	900.0
2013-05-20 05:25:00	SPY	ETF	166.65	166.72	166.65	166.72	28327.0
2013-05-20 05:30:00	SPY	ETF	166.7	166.7	166.69	166.69	20000.0
2013-05-20 05:40:00	SPY	ETF	166.74	166.74	166.74	166.74	300.0
2013-05-20 05:45:00	SPY	ETF	166.8	166.82	166.78	166.82	15200.0
2013-05-20 05:50:00	SPY	ETF	166.8	166.8	166.73	166.74	20700.0
2013-05-20 06:00:00	SPY	ETF	166.82	166.82	166.82	166.82	10000.0
2013-05-20 06:05:00	SPY	ETF	166.78	166.78	166.78	166.78	100.0
2013-05-20 06:10:00	SPY	ETF	166.77	166.77	166.74	166.74	400.0
2013-05-20 06:25:00	SPY	ETF	166.75	166.77	166.75	166.77	1100.0
2013-05-20 06:30:00	SPY	ETF	166.76	166.77	166.75	166.77	1100.0
2013-05-20 06:35:00	SPY	ETF	166.75	166.75	166.75	166.75	6000.0
2013-05-20 06:40:00	SPY	ETF	166.74	166.75	166.74	166.75	1600.0
2013-05-20 06:55:00	SPY	ETF	166.75	166.75	166.73	166.73	500.0
2013-05-20 07:00:00	SPY	ETF	166.74	166.78	166.74	166.78	500.0
2013-05-20 07:05:00	SPY	ETF	166.78	166.8	166.76	166.8	3241.0
2013-05-20 07:10:00	SPY	ETF	166.79	166.79	166.74	166.74	4100.0
2013-05-20 07:15:00	SPY	ETF	166.76	166.76	166.72	166.72	3840.0
2013-05-20 07:20:00	SPY	ETF	166.73	166.73	166.73	166.73	1750.0
2013-05-20 07:25:00	SPY	ETF	166.73	166.75	166.72	166.75	3390.0
2013-05-20 07:30:00	SPY	ETF	166.72	166.73	166.72	166.73	640.0
2013-05-20 07:35:00	SPY	ETF	166.71	166.72	166.7	166.71	16700.0
2013-05-20 07:40:00	SPY	ETF	166.74	166.74	166.64	166.7	39516.0
2013-05-20 07:45:00	SPY	ETF	166.68	166.7	166.68	166.68	900.0
2013-05-20 07:50:00	SPY	ETF	166.7	166.7	166.64	166.64	47400.0
2013-05-20 07:55:00	SPY	ETF	166.67	166.73	166.67	166.73	7380.0
2013-05-20 08:00:00	SPY	ETF	166.73	166.8	166.69	166.77	32220.0
2013-05-20 08:05:00	SPY	ETF	166.76	166.78	166.71	166.71	51485.0
2013-05-20 08:10:00	SPY	ETF	166.72	166.72	166.7	166.7	13100.0
2013-05-20 08:15:00	SPY	ETF	166.68	166.68	166.63	166.65	16095.0
2013-05-20 08:20:00	SPY	ETF	166.65	166.65	166.58	166.58	45438.0
2013-05-20 08:25:00	SPY	ETF	166.57	166.61	166.55	166.57	61820.0
2013-05-20 08:30:00	SPY	ETF	166.57	166.59	166.55	166.59	55450.0
2013-05-20 08:35:00	SPY	ETF	166.59	166.62	166.58	166.6	38350.0
2013-05-20 08:40:00	SPY	ETF	166.59	166.59	166.55	166.58	34295.0
2013-05-20 08:45:00	SPY	ETF	166.58	166.59	166.54	166.54	18645.0
2013-05-20 08:50:00	SPY	ETF	166.53	166.54	166.5	166.5	77698.0
2013-05-20 08:55:00	SPY	ETF	166.51	166.54	166.48	166.54	34825.0
2013-05-20 09:00:00	SPY	ETF	166.53	166.56	166.51	166.55	32171.0
2013-05-20 09:05:00	SPY	ETF	166.55	166.63	166.55	166.62	31301.0
2013-05-20 09:10:00	SPY	ETF	166.62	166.62	166.58	166.59	22181.0
2013-05-20 09:15:00	SPY	ETF	166.59	166.62	166.58	166.61	28197.0
2013-05-20 09:20:00	SPY	ETF	166.61	166.66	166.61	166.65	68005.0
2013-05-20 09:25:00	SPY	ETF	166.65	166.77	166.63	166.77	209148.0
2013-05-20 09:30:00	SPY	ETF	166.78	167.01	166.77	167.01	3958154.0
2013-05-20 09:35:00	SPY	ETF	167.005	167.08	166.95	167.0601	2336813.0
2013-05-20 09:40:00	SPY	ETF	167.07	167.09	166.87	166.87	2164970.0

> showing 50 of 42,395 rows — these rows as CSV

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