PREVIEW / etf_30min / 2014-08-29

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-08-29.parquet
  size:    329 KB
  rows:    11,243

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
2014-08-29 04:00:00	SPY	ETF	200.69	200.97	200.69	200.97	8232.0
2014-08-29 04:30:00	SPY	ETF	200.77	200.78	200.69	200.69	5284.0
2014-08-29 05:00:00	SPY	ETF	200.79	200.79	200.65	200.65	1833.0
2014-08-29 05:30:00	SPY	ETF	200.65	200.68	200.54	200.63	11432.0
2014-08-29 06:00:00	SPY	ETF	200.6	200.71	200.57	200.68	44426.0
2014-08-29 06:30:00	SPY	ETF	200.7	200.84	200.7	200.76	105313.0
2014-08-29 07:00:00	SPY	ETF	200.75	200.85	200.68	200.78	42508.0
2014-08-29 07:30:00	SPY	ETF	200.8	200.83	200.63	200.64	39946.0
2014-08-29 08:00:00	SPY	ETF	200.65	200.78	200.55	200.56	175817.0
2014-08-29 08:30:00	SPY	ETF	200.57	200.6	200.41	200.45	301516.0
2014-08-29 09:00:00	SPY	ETF	200.45	200.56	200.43	200.45	259018.0
2014-08-29 09:30:00	SPY	ETF	200.45	200.55	200.01	200.17	7410064.0
2014-08-29 10:00:00	SPY	ETF	200.16	200.19	199.82	199.91	5876206.0
2014-08-29 10:30:00	SPY	ETF	199.91	200.27	199.86	200.26	3030955.0
2014-08-29 11:00:00	SPY	ETF	200.27	200.5	200.27	200.45	2946246.0
2014-08-29 11:30:00	SPY	ETF	200.455	200.68	200.42	200.64	3382786.0
2014-08-29 12:00:00	SPY	ETF	200.64	200.725	200.45	200.5	1796639.0
2014-08-29 12:30:00	SPY	ETF	200.495	200.565	200.4	200.515	2101931.0
2014-08-29 13:00:00	SPY	ETF	200.51	200.54	200.35	200.43	1665990.0
2014-08-29 13:30:00	SPY	ETF	200.43	200.46	200.35	200.41	1367673.0
2014-08-29 14:00:00	SPY	ETF	200.419	200.49	200.4	200.46	1416008.0
2014-08-29 14:30:00	SPY	ETF	200.46	200.46	200.31	200.38	1573528.0
2014-08-29 15:00:00	SPY	ETF	200.385	200.45	200.28	200.389	3784497.0
2014-08-29 15:30:00	SPY	ETF	200.385	200.73	200.35	200.7	14551845.0
2014-08-29 16:00:00	SPY	ETF	200.69	200.729	200.4857	200.56	7485292.0
2014-08-29 16:30:00	SPY	ETF	200.56	200.71	200.42	200.46	3351061.0
2014-08-29 17:00:00	SPY	ETF	200.46	200.53	200.43	200.53	50638.0
2014-08-29 17:30:00	SPY	ETF	200.71	200.71	200.54	200.55	198722.0
2014-08-29 18:00:00	SPY	ETF	200.57	200.57	200.55	200.55	6200.0
2014-08-29 18:30:00	SPY	ETF	200.57	200.57	200.55	200.55	4600.0
2014-08-29 19:00:00	SPY	ETF	200.55	200.57	200.53	200.55	2896.0
2014-08-29 19:30:00	SPY	ETF	200.55	200.57	200.5	200.51	6375.0
2014-08-29 04:00:00	QQQ	ETF	99.61	99.77	99.61	99.74	3600.0
2014-08-29 04:30:00	QQQ	ETF	99.84	99.84	99.84	99.84	100.0
2014-08-29 05:30:00	QQQ	ETF	99.63	99.63	99.63	99.63	6500.0
2014-08-29 06:00:00	QQQ	ETF	99.67	99.67	99.67	99.67	200.0
2014-08-29 06:30:00	QQQ	ETF	99.71	99.72	99.71	99.72	5500.0
2014-08-29 07:00:00	QQQ	ETF	99.71	99.76	99.68	99.75	23960.0
2014-08-29 07:30:00	QQQ	ETF	99.76	99.76	99.67	99.67	45700.0
2014-08-29 08:00:00	QQQ	ETF	99.7	99.74	99.67	99.67	74423.0
2014-08-29 08:30:00	QQQ	ETF	99.65	99.67	99.55	99.56	109376.0
2014-08-29 09:00:00	QQQ	ETF	99.57	99.68	99.57	99.64	106731.0
2014-08-29 09:30:00	QQQ	ETF	99.65	99.71	99.425	99.49	2264963.0
2014-08-29 10:00:00	QQQ	ETF	99.48	99.51	99.2701	99.35	2164579.0
2014-08-29 10:30:00	QQQ	ETF	99.35	99.6	99.32	99.599	894013.0
2014-08-29 11:00:00	QQQ	ETF	99.595	99.72	99.595	99.7	1502062.0
2014-08-29 11:30:00	QQQ	ETF	99.69	99.795	99.68	99.751	1065100.0
2014-08-29 12:00:00	QQQ	ETF	99.76	99.78	99.63	99.6666	724125.0
2014-08-29 12:30:00	QQQ	ETF	99.665	99.695	99.612	99.675	449824.0
2014-08-29 13:00:00	QQQ	ETF	99.68	99.6907	99.53	99.59	533556.0

> showing 50 of 11,243 rows — these rows as CSV

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