PREVIEW / etf_30min / 2013-06-05

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-06-05.parquet
  size:    335 KB
  rows:    11,257

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-05 04:00:00	SPY	ETF	163.42	163.42	163.27	163.35	2500.0
2013-06-05 04:30:00	SPY	ETF	163.35	163.57	163.35	163.4	4300.0
2013-06-05 05:00:00	SPY	ETF	163.37	163.47	163.31	163.47	1800.0
2013-06-05 05:30:00	SPY	ETF	163.42	163.42	163.11	163.19	22500.0
2013-06-05 06:00:00	SPY	ETF	163.22	163.22	162.9	162.94	39750.0
2013-06-05 06:30:00	SPY	ETF	162.92	162.93	162.75	162.93	72343.0
2013-06-05 07:00:00	SPY	ETF	162.91	163.08	162.81	162.81	161160.0
2013-06-05 07:30:00	SPY	ETF	162.83	162.97	162.8	162.93	156567.0
2013-06-05 08:00:00	SPY	ETF	162.93	163.27	162.75	162.94	1543589.0
2013-06-05 08:30:00	SPY	ETF	162.93	163.32	162.9	163.21	1368572.0
2013-06-05 09:00:00	SPY	ETF	163.19	163.28	163.0	163.08	1114962.0
2013-06-05 09:30:00	SPY	ETF	163.09	163.37	162.84	162.99	13330823.0
2013-06-05 10:00:00	SPY	ETF	162.99	163.42	162.43	162.845	20561998.0
2013-06-05 10:30:00	SPY	ETF	162.85	162.94	162.31	162.4	12328877.0
2013-06-05 11:00:00	SPY	ETF	162.4	162.43	161.99	162.18	15610587.0
2013-06-05 11:30:00	SPY	ETF	162.18	162.41	161.82	161.93	9301790.0
2013-06-05 12:00:00	SPY	ETF	161.94	162.0199	161.65	161.85	9911338.0
2013-06-05 12:30:00	SPY	ETF	161.85	161.858	161.35	161.48	11670936.0
2013-06-05 13:00:00	SPY	ETF	161.49	162.05	161.35	161.985	14052391.0
2013-06-05 13:30:00	SPY	ETF	161.98	162.19	161.67	161.77	11553753.0
2013-06-05 14:00:00	SPY	ETF	161.76	161.91	161.22	161.3	13097013.0
2013-06-05 14:30:00	SPY	ETF	161.305	161.82	161.13	161.64	13612501.0
2013-06-05 15:00:00	SPY	ETF	161.64	161.87	161.25	161.79	15940792.0
2013-06-05 15:30:00	SPY	ETF	161.79	161.98	161.26	161.26	23195337.0
2013-06-05 16:00:00	SPY	ETF	161.26	162.99	161.16	161.36	7972501.0
2013-06-05 16:30:00	SPY	ETF	161.36	163.5885	161.3	161.35	9860614.0
2013-06-05 17:00:00	SPY	ETF	161.35	161.45	161.33	161.34	131969.0
2013-06-05 17:30:00	SPY	ETF	161.34	161.38	161.32	161.38	125962.0
2013-06-05 18:00:00	SPY	ETF	161.38	161.49	161.29	161.44	220762.0
2013-06-05 18:30:00	SPY	ETF	161.44	161.46	161.41	161.43	42836.0
2013-06-05 19:00:00	SPY	ETF	161.44	161.5	161.41	161.44	158255.0
2013-06-05 19:30:00	SPY	ETF	161.44	161.58	161.43	161.55	108991.0
2013-06-05 04:00:00	QQQ	ETF	72.96	72.99	72.92	72.92	1800.0
2013-06-05 04:30:00	QQQ	ETF	72.95	73.01	72.95	72.95	2800.0
2013-06-05 05:00:00	QQQ	ETF	72.92	72.95	72.92	72.95	800.0
2013-06-05 05:30:00	QQQ	ETF	72.98	72.98	72.86	72.86	3100.0
2013-06-05 06:00:00	QQQ	ETF	72.83	72.83	72.75	72.77	1700.0
2013-06-05 06:30:00	QQQ	ETF	72.74	72.78	72.71	72.78	3984.0
2013-06-05 07:00:00	QQQ	ETF	72.8	72.83	72.72	72.73	30900.0
2013-06-05 07:30:00	QQQ	ETF	72.73	72.75	72.7	72.75	97980.0
2013-06-05 08:00:00	QQQ	ETF	72.8	72.83	72.71	72.72	744414.0
2013-06-05 08:30:00	QQQ	ETF	72.74	72.87	72.73	72.85	57213.0
2013-06-05 09:00:00	QQQ	ETF	72.86	72.89	72.72	72.75	2234588.0
2013-06-05 09:30:00	QQQ	ETF	72.77	73.04	72.62	72.88	3560203.0
2013-06-05 10:00:00	QQQ	ETF	72.89	73.03	72.61	72.76	3154145.0
2013-06-05 10:30:00	QQQ	ETF	72.76	72.84	72.46	72.54	4240319.0
2013-06-05 11:00:00	QQQ	ETF	72.54	72.54	72.3	72.42	2944276.0
2013-06-05 11:30:00	QQQ	ETF	72.41	72.52	72.31	72.34	2386242.0
2013-06-05 12:00:00	QQQ	ETF	72.35	72.39	72.22	72.32	1440725.0
2013-06-05 12:30:00	QQQ	ETF	72.315	72.33	72.04	72.09	1737631.0

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

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