PREVIEW / etf_30min / 2012-06-20

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-06-20.parquet
  size:    286 KB
  rows:    9,570

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
2012-06-20 04:00:00	SPY	ETF	135.31	135.5	135.31	135.44	640.0
2012-06-20 04:30:00	SPY	ETF	135.63	135.68	135.58	135.61	16500.0
2012-06-20 05:00:00	SPY	ETF	135.71	135.79	135.69	135.69	2600.0
2012-06-20 05:30:00	SPY	ETF	135.7	135.73	135.64	135.69	1200.0
2012-06-20 06:00:00	SPY	ETF	135.65	135.65	135.5	135.5	1400.0
2012-06-20 06:30:00	SPY	ETF	135.59	135.71	135.58	135.63	33350.0
2012-06-20 07:00:00	SPY	ETF	135.7	135.85	135.66	135.79	107925.0
2012-06-20 07:30:00	SPY	ETF	135.84	136.0	135.84	135.87	135255.0
2012-06-20 08:00:00	SPY	ETF	135.89	135.92	135.76	135.82	294686.0
2012-06-20 08:30:00	SPY	ETF	135.82	135.88	135.74	135.77	281863.0
2012-06-20 09:00:00	SPY	ETF	135.77	135.85	135.66	135.71	835756.0
2012-06-20 09:30:00	SPY	ETF	135.71	135.86	135.33	135.53	13289341.0
2012-06-20 10:00:00	SPY	ETF	135.52	135.73	135.37	135.5977	8654224.0
2012-06-20 10:30:00	SPY	ETF	135.58	135.64	135.31	135.35	7009290.0
2012-06-20 11:00:00	SPY	ETF	135.35	135.57	135.33	135.52	6719391.0
2012-06-20 11:30:00	SPY	ETF	135.52	135.58	135.36	135.37	5115984.0
2012-06-20 12:00:00	SPY	ETF	135.371	135.4	135.03	135.2	8463566.0
2012-06-20 12:30:00	SPY	ETF	135.2	135.52	134.27	135.42	37145977.0
2012-06-20 13:00:00	SPY	ETF	135.4215	136.1	135.4215	135.69	25210857.0
2012-06-20 13:30:00	SPY	ETF	135.7	135.79	135.4	135.68	8385165.0
2012-06-20 14:00:00	SPY	ETF	135.68	135.82	135.13	135.26	17042279.0
2012-06-20 14:30:00	SPY	ETF	135.26	135.49	134.79	135.05	17697610.0
2012-06-20 15:00:00	SPY	ETF	135.05	135.11	134.63	135.07	15140454.0
2012-06-20 15:30:00	SPY	ETF	135.06	135.5	134.96	135.48	17950895.0
2012-06-20 16:00:00	SPY	ETF	135.48	135.74	135.1343	135.61	7771672.0
2012-06-20 16:30:00	SPY	ETF	135.62	135.74	135.6	135.73	7246038.0
2012-06-20 17:00:00	SPY	ETF	135.7	135.74	135.66	135.69	374632.0
2012-06-20 17:30:00	SPY	ETF	135.7	135.72	135.66	135.67	6140.0
2012-06-20 18:00:00	SPY	ETF	135.69	135.69	135.47	135.48	77091.0
2012-06-20 18:30:00	SPY	ETF	135.49	135.6	135.49	135.53	16138.0
2012-06-20 19:00:00	SPY	ETF	135.54	135.55	135.47	135.54	45835.0
2012-06-20 19:30:00	SPY	ETF	135.53	135.6	135.49	135.5	29342.0
2012-06-20 04:30:00	QQQ	ETF	64.3	64.3	64.3	64.3	100.0
2012-06-20 05:00:00	QQQ	ETF	64.32	64.32	64.32	64.32	100.0
2012-06-20 06:00:00	QQQ	ETF	64.29	64.29	64.2	64.26	4400.0
2012-06-20 06:30:00	QQQ	ETF	64.28	64.28	64.28	64.28	5000.0
2012-06-20 07:00:00	QQQ	ETF	64.29	64.38	64.29	64.38	8400.0
2012-06-20 07:30:00	QQQ	ETF	64.38	64.41	64.34	64.34	10290.0
2012-06-20 08:00:00	QQQ	ETF	64.33	64.39	64.3	64.36	44044.0
2012-06-20 08:30:00	QQQ	ETF	64.33	64.39	64.31	64.33	51980.0
2012-06-20 09:00:00	QQQ	ETF	64.32	64.36	64.27	64.35	89267.0
2012-06-20 09:30:00	QQQ	ETF	64.36	64.45	64.15	64.33	3169909.0
2012-06-20 10:00:00	QQQ	ETF	64.3201	64.37	64.2	64.32	2751151.0
2012-06-20 10:30:00	QQQ	ETF	64.31	64.3213	64.18	64.2	1911423.0
2012-06-20 11:00:00	QQQ	ETF	64.2	64.33	64.19	64.33	1732610.0
2012-06-20 11:30:00	QQQ	ETF	64.329	64.36	64.24	64.2401	1663540.0
2012-06-20 12:00:00	QQQ	ETF	64.24	64.26	64.0	64.09	2225381.0
2012-06-20 12:30:00	QQQ	ETF	64.09	64.37	63.81	64.33	8921805.0
2012-06-20 13:00:00	QQQ	ETF	64.3265	64.57	64.3265	64.39	4721035.0
2012-06-20 13:30:00	QQQ	ETF	64.4	64.44	64.25	64.41	1958934.0

> showing 50 of 9,570 rows — these rows as CSV

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