PREVIEW / etf_30min / 2013-06-13

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-06-13.parquet
  size:    333 KB
  rows:    10,992

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-13 04:00:00	SPY	ETF	161.04	161.04	160.44	160.53	43515.0
2013-06-13 04:30:00	SPY	ETF	160.56	160.83	160.55	160.81	29600.0
2013-06-13 05:00:00	SPY	ETF	160.85	160.89	160.61	160.89	17195.0
2013-06-13 05:30:00	SPY	ETF	160.91	160.99	160.78	160.83	70100.0
2013-06-13 06:00:00	SPY	ETF	160.86	161.06	160.84	161.05	96000.0
2013-06-13 06:30:00	SPY	ETF	161.08	161.29	161.06	161.11	307000.0
2013-06-13 07:00:00	SPY	ETF	161.11	161.21	160.98	161.15	137205.0
2013-06-13 07:30:00	SPY	ETF	161.11	161.21	160.95	161.17	507019.0
2013-06-13 08:00:00	SPY	ETF	161.15	161.32	160.75	161.13	681785.0
2013-06-13 08:30:00	SPY	ETF	161.18	161.79	161.04	161.71	1734925.0
2013-06-13 09:00:00	SPY	ETF	161.68	161.92	161.64	161.66	1612466.0
2013-06-13 09:30:00	SPY	ETF	161.66	162.03	161.3	162.01	21922946.0
2013-06-13 10:00:00	SPY	ETF	162.01	162.23	161.72	161.99	12973847.0
2013-06-13 10:30:00	SPY	ETF	161.9899	162.43	161.9899	162.13	9816115.0
2013-06-13 11:00:00	SPY	ETF	162.13	162.43	162.04	162.38	8484411.0
2013-06-13 11:30:00	SPY	ETF	162.39	162.53	162.15	162.499	5311617.0
2013-06-13 12:00:00	SPY	ETF	162.5	162.57	162.36	162.44	5027277.0
2013-06-13 12:30:00	SPY	ETF	162.44	163.06	162.43	163.06	5928812.0
2013-06-13 13:00:00	SPY	ETF	163.05	163.07	162.81	162.93	6945437.0
2013-06-13 13:30:00	SPY	ETF	162.93	162.99	162.7	162.9399	4141236.0
2013-06-13 14:00:00	SPY	ETF	162.94	163.51	162.93	163.39	7823751.0
2013-06-13 14:30:00	SPY	ETF	163.3999	163.54	163.27	163.529	5869166.0
2013-06-13 15:00:00	SPY	ETF	163.53	163.95	163.52	163.881	9182272.0
2013-06-13 15:30:00	SPY	ETF	163.89	164.5	163.71	164.21	32354258.0
2013-06-13 16:00:00	SPY	ETF	164.21	164.28	161.8005	164.2	8105261.0
2013-06-13 16:30:00	SPY	ETF	164.22	164.26	164.1211	164.25	6101851.0
2013-06-13 17:00:00	SPY	ETF	164.24	164.29	164.23	164.26	4606074.0
2013-06-13 17:30:00	SPY	ETF	164.26	164.28	164.2	164.28	76611.0
2013-06-13 18:00:00	SPY	ETF	164.28	164.54	164.27	164.5	246653.0
2013-06-13 18:30:00	SPY	ETF	164.5	164.52	164.32	164.32	62009.0
2013-06-13 19:00:00	SPY	ETF	164.31	164.44	164.3	164.41	14092.0
2013-06-13 19:30:00	SPY	ETF	164.38	164.43	164.35	164.42	76507.0
2013-06-13 04:00:00	QQQ	ETF	71.5	71.5	71.26	71.26	9375.0
2013-06-13 04:30:00	QQQ	ETF	71.29	71.42	71.29	71.42	3000.0
2013-06-13 05:00:00	QQQ	ETF	71.38	71.44	71.32	71.44	3100.0
2013-06-13 05:30:00	QQQ	ETF	71.45	71.46	71.38	71.41	3100.0
2013-06-13 06:00:00	QQQ	ETF	71.44	71.48	71.44	71.48	3229.0
2013-06-13 06:30:00	QQQ	ETF	71.49	71.56	71.49	71.5	2400.0
2013-06-13 07:00:00	QQQ	ETF	71.51	71.53	71.5	71.53	2200.0
2013-06-13 07:30:00	QQQ	ETF	71.5	71.56	71.49	71.56	3460.0
2013-06-13 08:00:00	QQQ	ETF	71.56	71.59	71.52	71.53	8158.0
2013-06-13 08:30:00	QQQ	ETF	71.56	71.81	71.54	71.8	107437.0
2013-06-13 09:00:00	QQQ	ETF	71.8	71.87	71.77	71.77	146861.0
2013-06-13 09:30:00	QQQ	ETF	71.76	71.91	71.55	71.89	4617828.0
2013-06-13 10:00:00	QQQ	ETF	71.9	71.97	71.71	71.9	2438465.0
2013-06-13 10:30:00	QQQ	ETF	71.9	72.12	71.9	71.98	2368712.0
2013-06-13 11:00:00	QQQ	ETF	71.99	72.08	71.95	72.06	1759244.0
2013-06-13 11:30:00	QQQ	ETF	72.05	72.155	71.92	72.1301	1043709.0
2013-06-13 12:00:00	QQQ	ETF	72.14	72.1701	72.07	72.12	612927.0
2013-06-13 12:30:00	QQQ	ETF	72.12	72.34	72.11	72.34	1567790.0

> showing 50 of 10,992 rows — these rows as CSV

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