PREVIEW / etf_30min / 2014-06-09

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-06-09.parquet
  size:    330 KB
  rows:    11,361

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-06-09 04:00:00	SPY	ETF	195.41	195.41	195.25	195.35	15300.0
2014-06-09 04:30:00	SPY	ETF	195.35	195.35	195.33	195.35	13901.0
2014-06-09 05:00:00	SPY	ETF	195.36	195.36	195.32	195.34	2984.0
2014-06-09 05:30:00	SPY	ETF	195.33	195.38	195.23	195.35	4888.0
2014-06-09 06:00:00	SPY	ETF	195.35	195.35	195.33	195.33	4273.0
2014-06-09 06:30:00	SPY	ETF	195.36	195.36	195.35	195.35	30400.0
2014-06-09 07:00:00	SPY	ETF	195.35	195.38	195.29	195.29	85526.0
2014-06-09 07:30:00	SPY	ETF	195.32	195.38	195.3	195.37	102446.0
2014-06-09 08:00:00	SPY	ETF	195.38	195.53	195.28	195.32	223320.0
2014-06-09 08:30:00	SPY	ETF	195.32	195.32	195.24	195.3	170510.0
2014-06-09 09:00:00	SPY	ETF	195.3	195.365	195.23	195.35	742679.0
2014-06-09 09:30:00	SPY	ETF	195.35	195.72	195.29	195.57	12209767.0
2014-06-09 10:00:00	SPY	ETF	195.57	195.66	195.49	195.64	3682888.0
2014-06-09 10:30:00	SPY	ETF	195.63	195.77	195.53	195.715	2875982.0
2014-06-09 11:00:00	SPY	ETF	195.715	195.9	195.65	195.89	2675485.0
2014-06-09 11:30:00	SPY	ETF	195.89	196.05	195.86	195.95	3147143.0
2014-06-09 12:00:00	SPY	ETF	195.96	195.97	195.77	195.79	2516265.0
2014-06-09 12:30:00	SPY	ETF	195.79	195.862	195.72	195.75	2756487.0
2014-06-09 13:00:00	SPY	ETF	195.75	195.79	195.54	195.57	2698475.0
2014-06-09 13:30:00	SPY	ETF	195.58	195.69	195.55	195.585	3397635.0
2014-06-09 14:00:00	SPY	ETF	195.5801	195.6	195.2	195.26	5240900.0
2014-06-09 14:30:00	SPY	ETF	195.2601	195.5	195.17	195.47	4279557.0
2014-06-09 15:00:00	SPY	ETF	195.47	195.68	195.44	195.58	6227070.0
2014-06-09 15:30:00	SPY	ETF	195.58	195.61	195.42	195.58	7180027.0
2014-06-09 16:00:00	SPY	ETF	195.58	195.69	195.4233	195.59	3573753.0
2014-06-09 16:30:00	SPY	ETF	195.59	195.6066	195.5	195.53	256458.0
2014-06-09 17:00:00	SPY	ETF	195.52	195.59	195.52	195.59	9400.0
2014-06-09 17:30:00	SPY	ETF	195.53	195.59	195.5	195.5	24947.0
2014-06-09 18:00:00	SPY	ETF	195.5	195.54	195.46	195.49	51810.0
2014-06-09 18:30:00	SPY	ETF	195.49	195.49	195.46	195.47	13250.0
2014-06-09 19:00:00	SPY	ETF	195.48	195.52	195.47	195.52	16435.0
2014-06-09 19:30:00	SPY	ETF	195.52	195.54	195.52	195.54	6750.0
2014-06-09 04:00:00	QQQ	ETF	92.81	92.81	92.76	92.76	4899.0
2014-06-09 05:00:00	QQQ	ETF	92.76	92.76	92.76	92.76	100.0
2014-06-09 05:30:00	QQQ	ETF	92.85	92.85	92.83	92.84	650.0
2014-06-09 06:00:00	QQQ	ETF	92.82	92.84	92.82	92.84	200.0
2014-06-09 07:00:00	QQQ	ETF	92.82	92.82	92.82	92.82	200.0
2014-06-09 07:30:00	QQQ	ETF	92.8	92.81	92.8	92.81	800.0
2014-06-09 08:00:00	QQQ	ETF	92.81	92.81	92.75	92.75	34144.0
2014-06-09 08:30:00	QQQ	ETF	92.76	92.78	92.74	92.77	20232.0
2014-06-09 09:00:00	QQQ	ETF	92.79	92.85	92.74	92.85	39877.0
2014-06-09 09:30:00	QQQ	ETF	92.85	92.87	92.59	92.71	3280685.0
2014-06-09 10:00:00	QQQ	ETF	92.71	92.76	92.61	92.72	1969061.0
2014-06-09 10:30:00	QQQ	ETF	92.72	92.83	92.63	92.79	1073804.0
2014-06-09 11:00:00	QQQ	ETF	92.8	92.89	92.73	92.88	1054249.0
2014-06-09 11:30:00	QQQ	ETF	92.88	92.98	92.8741	92.929	984820.0
2014-06-09 12:00:00	QQQ	ETF	92.929	92.98	92.91	92.92	539330.0
2014-06-09 12:30:00	QQQ	ETF	92.92	92.98	92.91	92.94	569856.0
2014-06-09 13:00:00	QQQ	ETF	92.94	92.95	92.73	92.7401	780401.0
2014-06-09 13:30:00	QQQ	ETF	92.75	92.82	92.7	92.73	1289509.0

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

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