PREVIEW / etf_30min / 2013-06-20

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-06-20.parquet
  size:    370 KB
  rows:    12,298

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-20 04:00:00	SPY	ETF	163.0	163.06	162.4	162.56	52749.0
2013-06-20 04:30:00	SPY	ETF	162.6	162.6	162.4	162.4	18284.0
2013-06-20 05:00:00	SPY	ETF	162.36	162.63	162.32	162.52	64550.0
2013-06-20 05:30:00	SPY	ETF	162.48	162.48	161.76	161.92	54600.0
2013-06-20 06:00:00	SPY	ETF	161.94	162.08	161.79	162.01	99300.0
2013-06-20 06:30:00	SPY	ETF	161.97	162.28	161.97	162.22	99503.0
2013-06-20 07:00:00	SPY	ETF	162.17	162.44	162.13	162.13	603705.0
2013-06-20 07:30:00	SPY	ETF	162.14	162.21	161.87	162.19	504934.0
2013-06-20 08:00:00	SPY	ETF	162.19	162.44	161.94	162.33	620748.0
2013-06-20 08:30:00	SPY	ETF	162.31	162.43	162.0	162.01	1090547.0
2013-06-20 09:00:00	SPY	ETF	162.0	162.09	161.78	161.85	2035653.0
2013-06-20 09:30:00	SPY	ETF	161.86	162.1	161.39	161.7299	32224565.0
2013-06-20 10:00:00	SPY	ETF	161.73	162.01	160.92	161.041	24986390.0
2013-06-20 10:30:00	SPY	ETF	161.04	161.3006	160.63	161.08	20404394.0
2013-06-20 11:00:00	SPY	ETF	161.09	161.13	160.48	160.795	14776952.0
2013-06-20 11:30:00	SPY	ETF	160.81	161.19	160.64	161.06	13482814.0
2013-06-20 12:00:00	SPY	ETF	161.045	161.37	161.045	161.16	10724904.0
2013-06-20 12:30:00	SPY	ETF	161.16	161.48	160.821	160.85	8413218.0
2013-06-20 13:00:00	SPY	ETF	160.855	161.07	160.49	160.705	11486663.0
2013-06-20 13:30:00	SPY	ETF	160.71	161.02	160.6	160.89	10724825.0
2013-06-20 14:00:00	SPY	ETF	160.895	160.95	159.86	159.9	26743881.0
2013-06-20 14:30:00	SPY	ETF	159.905	161.25	159.36	159.418	22248885.0
2013-06-20 15:00:00	SPY	ETF	159.41	160.5666	159.25	159.47	27822406.0
2013-06-20 15:30:00	SPY	ETF	159.47	159.85	158.98	159.38	51833662.0
2013-06-20 16:00:00	SPY	ETF	159.37	163.4668	159.2907	159.68	12149554.0
2013-06-20 16:30:00	SPY	ETF	159.68	163.4668	159.54	159.62	15458550.0
2013-06-20 17:00:00	SPY	ETF	159.6	159.69	159.57	159.6	2154297.0
2013-06-20 17:30:00	SPY	ETF	159.59	159.66	159.4371	159.58	311952.0
2013-06-20 18:00:00	SPY	ETF	159.6	159.79	159.6	159.69	263456.0
2013-06-20 18:30:00	SPY	ETF	159.7	159.7	159.51	159.51	91181.0
2013-06-20 19:00:00	SPY	ETF	159.54	159.6	159.51	159.59	33976.0
2013-06-20 19:30:00	SPY	ETF	159.59	159.68	159.53	159.61	82068.0
2013-06-20 04:00:00	QQQ	ETF	72.52	72.52	72.15	72.21	11178.0
2013-06-20 04:30:00	QQQ	ETF	72.24	72.24	72.18	72.18	1200.0
2013-06-20 05:00:00	QQQ	ETF	72.15	72.27	72.15	72.27	3800.0
2013-06-20 05:30:00	QQQ	ETF	72.24	72.24	71.94	72.0	9370.0
2013-06-20 06:00:00	QQQ	ETF	72.0	72.03	71.91	72.0	38380.0
2013-06-20 06:30:00	QQQ	ETF	72.03	72.09	72.03	72.06	13344.0
2013-06-20 07:00:00	QQQ	ETF	72.09	72.15	72.06	72.07	23800.0
2013-06-20 07:30:00	QQQ	ETF	72.05	72.09	71.99	72.07	12700.0
2013-06-20 08:00:00	QQQ	ETF	72.09	72.19	72.04	72.15	57039.0
2013-06-20 08:30:00	QQQ	ETF	72.15	72.19	72.08	72.08	60810.0
2013-06-20 09:00:00	QQQ	ETF	72.08	72.08	71.92	71.93	321081.0
2013-06-20 09:30:00	QQQ	ETF	71.92	72.16	71.82	72.0499	7202877.0
2013-06-20 10:00:00	QQQ	ETF	72.05	72.15	71.74	71.74	5451384.0
2013-06-20 10:30:00	QQQ	ETF	71.75	71.91	71.66	71.76	4932010.0
2013-06-20 11:00:00	QQQ	ETF	71.7601	71.77	71.46	71.57	3324275.0
2013-06-20 11:30:00	QQQ	ETF	71.57	71.69	71.5	71.61	2857413.0
2013-06-20 12:00:00	QQQ	ETF	71.609	71.72	71.57	71.655	1583186.0
2013-06-20 12:30:00	QQQ	ETF	71.659	71.79	71.42	71.46	1661768.0

> showing 50 of 12,298 rows — these rows as CSV

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