PREVIEW / etf_5min / 2013-04-12

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-04-12.parquet
  size:    968 KB
  rows:    41,045

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-04-12 04:00:00	SPY	ETF	159.0	159.0	158.93	158.93	45200.0
2013-04-12 04:05:00	SPY	ETF	158.89	158.89	158.89	158.89	11500.0
2013-04-12 04:10:00	SPY	ETF	158.89	158.89	158.8	158.8	1675.0
2013-04-12 04:20:00	SPY	ETF	158.95	158.96	158.94	158.94	3000.0
2013-04-12 04:25:00	SPY	ETF	158.96	158.96	158.96	158.96	100.0
2013-04-12 04:45:00	SPY	ETF	158.96	158.96	158.96	158.96	400.0
2013-04-12 04:50:00	SPY	ETF	158.96	158.96	158.96	158.96	500.0
2013-04-12 05:10:00	SPY	ETF	158.82	158.82	158.75	158.75	8599.0
2013-04-12 05:15:00	SPY	ETF	158.78	158.79	158.68	158.68	4278.0
2013-04-12 05:20:00	SPY	ETF	158.66	158.77	158.66	158.72	1000.0
2013-04-12 05:25:00	SPY	ETF	158.72	158.77	158.72	158.74	12500.0
2013-04-12 05:30:00	SPY	ETF	158.8	158.8	158.8	158.8	500.0
2013-04-12 05:35:00	SPY	ETF	158.85	158.85	158.77	158.77	300.0
2013-04-12 05:40:00	SPY	ETF	158.75	158.75	158.66	158.67	18800.0
2013-04-12 05:45:00	SPY	ETF	158.69	158.75	158.69	158.75	8300.0
2013-04-12 05:55:00	SPY	ETF	158.79	158.79	158.79	158.79	200.0
2013-04-12 06:00:00	SPY	ETF	158.8	158.81	158.79	158.79	15100.0
2013-04-12 06:10:00	SPY	ETF	158.83	158.83	158.83	158.83	10000.0
2013-04-12 06:15:00	SPY	ETF	158.82	158.85	158.77	158.77	3450.0
2013-04-12 06:20:00	SPY	ETF	158.77	158.77	158.77	158.77	100.0
2013-04-12 06:30:00	SPY	ETF	158.78	158.83	158.78	158.83	14898.0
2013-04-12 06:35:00	SPY	ETF	158.82	158.83	158.8	158.8	28000.0
2013-04-12 06:40:00	SPY	ETF	158.8	158.84	158.79	158.84	4300.0
2013-04-12 06:45:00	SPY	ETF	158.83	158.87	158.83	158.86	3499.0
2013-04-12 06:50:00	SPY	ETF	158.85	158.85	158.85	158.85	15100.0
2013-04-12 06:55:00	SPY	ETF	158.87	158.88	158.81	158.85	45900.0
2013-04-12 07:00:00	SPY	ETF	158.88	158.9	158.83	158.84	44900.0
2013-04-12 07:05:00	SPY	ETF	158.85	158.85	158.82	158.83	7190.0
2013-04-12 07:10:00	SPY	ETF	158.82	158.84	158.77	158.82	35471.0
2013-04-12 07:15:00	SPY	ETF	158.82	158.87	158.82	158.87	11900.0
2013-04-12 07:20:00	SPY	ETF	158.85	158.85	158.77	158.77	23100.0
2013-04-12 07:25:00	SPY	ETF	158.76	158.81	158.76	158.79	163220.0
2013-04-12 07:30:00	SPY	ETF	158.79	158.81	158.74	158.74	173750.0
2013-04-12 07:35:00	SPY	ETF	158.74	158.74	158.7	158.7	518566.0
2013-04-12 07:40:00	SPY	ETF	158.69	158.71	158.66	158.66	131788.0
2013-04-12 07:45:00	SPY	ETF	158.655	158.68	158.63	158.68	217206.0
2013-04-12 07:50:00	SPY	ETF	158.67	158.69	158.67	158.69	199886.0
2013-04-12 07:55:00	SPY	ETF	158.67	158.69	158.66	158.67	81619.0
2013-04-12 08:00:00	SPY	ETF	158.68	158.87	158.65	158.7	1012305.0
2013-04-12 08:05:00	SPY	ETF	158.71	158.85	158.68	158.71	135935.0
2013-04-12 08:10:00	SPY	ETF	158.7	158.74	158.68	158.68	107743.0
2013-04-12 08:15:00	SPY	ETF	158.67	158.67	158.61	158.62	904285.0
2013-04-12 08:20:00	SPY	ETF	158.61	158.61	158.56	158.6	203285.0
2013-04-12 08:25:00	SPY	ETF	158.6	158.67	158.56	158.61	149717.0
2013-04-12 08:30:00	SPY	ETF	158.65	158.8	158.39	158.39	1060243.0
2013-04-12 08:35:00	SPY	ETF	158.39	158.47	158.32	158.45	186266.0
2013-04-12 08:40:00	SPY	ETF	158.44	158.5	158.4	158.46	122905.0
2013-04-12 08:45:00	SPY	ETF	158.45	158.68	158.42	158.64	151653.0
2013-04-12 08:50:00	SPY	ETF	158.64	158.66	158.59	158.65	146259.0
2013-04-12 08:55:00	SPY	ETF	158.64	158.65	158.59	158.64	109629.0

> showing 50 of 41,045 rows — these rows as CSV

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