PREVIEW / etf_30min / 2013-06-28

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-06-28.parquet
  size:    330 KB
  rows:    11,110

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-06-28 04:00:00	SPY	ETF	161.64	161.67	161.48	161.53	7500.0
2013-06-28 04:30:00	SPY	ETF	161.55	161.62	161.55	161.62	1340.0
2013-06-28 05:00:00	SPY	ETF	161.55	161.7	161.52	161.68	16100.0
2013-06-28 05:30:00	SPY	ETF	161.72	161.81	161.63	161.63	36200.0
2013-06-28 06:00:00	SPY	ETF	161.61	161.64	161.39	161.43	26376.0
2013-06-28 06:30:00	SPY	ETF	161.41	161.49	161.31	161.38	12100.0
2013-06-28 07:00:00	SPY	ETF	161.35	161.48	161.24	161.44	202796.0
2013-06-28 07:30:00	SPY	ETF	161.44	161.64	161.44	161.58	126268.0
2013-06-28 08:00:00	SPY	ETF	161.6	161.6	161.03	161.19	582864.0
2013-06-28 08:30:00	SPY	ETF	161.21	161.21	160.81	160.94	1541606.0
2013-06-28 09:00:00	SPY	ETF	160.94	160.95	160.51	160.62	2005477.0
2013-06-28 09:30:00	SPY	ETF	160.63	160.83	159.981	160.021	17634292.0
2013-06-28 10:00:00	SPY	ETF	160.02	160.45	159.86	160.43	13572305.0
2013-06-28 10:30:00	SPY	ETF	160.4201	161.055	160.42	160.95	9991328.0
2013-06-28 11:00:00	SPY	ETF	160.955	161.39	160.9	160.94	9916476.0
2013-06-28 11:30:00	SPY	ETF	160.95	161.23	160.82	161.13	7793560.0
2013-06-28 12:00:00	SPY	ETF	161.12	161.14	160.49	160.75	7329459.0
2013-06-28 12:30:00	SPY	ETF	160.75	161.04	160.63	160.87	4524531.0
2013-06-28 13:00:00	SPY	ETF	160.86	161.16	160.75	161.0	3901515.0
2013-06-28 13:30:00	SPY	ETF	161.0	161.28	160.95	161.22	5154908.0
2013-06-28 14:00:00	SPY	ETF	161.22	161.4	161.08	161.15	8166022.0
2013-06-28 14:30:00	SPY	ETF	161.14	161.26	160.99	161.12	7953354.0
2013-06-28 15:00:00	SPY	ETF	161.12	161.17	160.71	161.17	11643425.0
2013-06-28 15:30:00	SPY	ETF	161.17	161.37	160.07	160.2	24833749.0
2013-06-28 16:00:00	SPY	ETF	160.19	161.0	159.94	160.29	10425142.0
2013-06-28 16:30:00	SPY	ETF	160.29	161.1168	160.01	160.16	4619412.0
2013-06-28 17:00:00	SPY	ETF	160.17	160.27	160.05	160.11	804811.0
2013-06-28 17:30:00	SPY	ETF	160.11	160.22	160.1	160.13	3611007.0
2013-06-28 18:00:00	SPY	ETF	160.13	160.19	160.13	160.17	9315.0
2013-06-28 18:30:00	SPY	ETF	160.19	160.25	160.16	160.19	17726.0
2013-06-28 19:00:00	SPY	ETF	160.17	160.19	160.16	160.17	9405.0
2013-06-28 19:30:00	SPY	ETF	160.17	160.28	159.99	160.2	208357.0
2013-06-28 04:00:00	QQQ	ETF	71.33	71.46	71.33	71.4	13000.0
2013-06-28 04:30:00	QQQ	ETF	71.42	71.44	71.42	71.42	3000.0
2013-06-28 05:00:00	QQQ	ETF	71.4	71.44	71.38	71.42	4800.0
2013-06-28 05:30:00	QQQ	ETF	71.44	71.44	71.38	71.38	2500.0
2013-06-28 06:00:00	QQQ	ETF	71.36	71.36	71.32	71.32	1800.0
2013-06-28 06:30:00	QQQ	ETF	71.3	71.33	71.24	71.25	5400.0
2013-06-28 07:00:00	QQQ	ETF	71.24	71.28	71.22	71.26	6800.0
2013-06-28 07:30:00	QQQ	ETF	71.28	71.38	71.28	71.38	15900.0
2013-06-28 08:00:00	QQQ	ETF	71.36	71.36	71.12	71.15	24702.0
2013-06-28 08:30:00	QQQ	ETF	71.17	71.17	71.04	71.09	15167.0
2013-06-28 09:00:00	QQQ	ETF	71.08	71.08	70.89	70.91	499035.0
2013-06-28 09:30:00	QQQ	ETF	70.92	71.1899	70.86	70.89	3868189.0
2013-06-28 10:00:00	QQQ	ETF	70.89	71.06	70.79	71.04	3068952.0
2013-06-28 10:30:00	QQQ	ETF	71.04	71.36	71.03	71.32	2377126.0
2013-06-28 11:00:00	QQQ	ETF	71.31	71.53	71.291	71.31	2108712.0
2013-06-28 11:30:00	QQQ	ETF	71.31	71.41	71.25	71.35	1404491.0
2013-06-28 12:00:00	QQQ	ETF	71.35	71.365	71.11	71.22	1146401.0
2013-06-28 12:30:00	QQQ	ETF	71.23	71.348	71.16	71.27	940506.0

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

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