PREVIEW / etf_30min / 2012-09-13

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-09-13.parquet
  size:    307 KB
  rows:    10,184

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-09-13 04:00:00	SPY	ETF	144.51	144.51	144.24	144.33	1100.0
2012-09-13 04:30:00	SPY	ETF	144.3	144.31	144.24	144.24	68500.0
2012-09-13 05:00:00	SPY	ETF	144.29	144.31	144.23	144.29	1800.0
2012-09-13 05:30:00	SPY	ETF	144.29	144.38	144.29	144.38	900.0
2012-09-13 06:00:00	SPY	ETF	144.28	144.33	144.28	144.33	800.0
2012-09-13 06:30:00	SPY	ETF	144.31	144.35	144.25	144.35	75768.0
2012-09-13 07:00:00	SPY	ETF	144.33	144.44	144.33	144.43	55616.0
2012-09-13 07:30:00	SPY	ETF	144.42	144.44	144.33	144.34	145800.0
2012-09-13 08:00:00	SPY	ETF	144.33	144.39	144.29	144.35	191534.0
2012-09-13 08:30:00	SPY	ETF	144.31	144.49	144.21	144.45	320875.0
2012-09-13 09:00:00	SPY	ETF	144.46	144.46	144.33	144.37	227421.0
2012-09-13 09:30:00	SPY	ETF	144.37	144.37	144.15	144.27	9643398.0
2012-09-13 10:00:00	SPY	ETF	144.26	144.43	144.22	144.23	5843369.0
2012-09-13 10:30:00	SPY	ETF	144.23	144.39	144.21	144.3701	3048862.0
2012-09-13 11:00:00	SPY	ETF	144.38	144.6	144.37	144.565	5064117.0
2012-09-13 11:30:00	SPY	ETF	144.565	144.62	144.39	144.43	3800699.0
2012-09-13 12:00:00	SPY	ETF	144.42	144.5	143.99	144.39	6520202.0
2012-09-13 12:30:00	SPY	ETF	144.39	145.54	144.24	145.429	37539650.0
2012-09-13 13:00:00	SPY	ETF	145.44	145.945	144.86	145.94	22080266.0
2012-09-13 13:30:00	SPY	ETF	145.935	146.215	145.65	146.04	11667904.0
2012-09-13 14:00:00	SPY	ETF	146.04	147.04	145.98	146.9	17988874.0
2012-09-13 14:30:00	SPY	ETF	146.892	146.9	146.43	146.51	22105545.0
2012-09-13 15:00:00	SPY	ETF	146.525	146.69	146.22	146.54	10708466.0
2012-09-13 15:30:00	SPY	ETF	146.55	146.84	146.41	146.65	20868497.0
2012-09-13 16:00:00	SPY	ETF	146.66	146.71	144.46	146.38	11813850.0
2012-09-13 16:30:00	SPY	ETF	146.37	146.37	146.28	146.35	16460846.0
2012-09-13 17:00:00	SPY	ETF	146.35	146.43	146.32	146.42	6094646.0
2012-09-13 17:30:00	SPY	ETF	146.43	146.46	144.2847	146.44	4545682.0
2012-09-13 18:00:00	SPY	ETF	146.46	146.49	146.42	146.49	56152.0
2012-09-13 18:30:00	SPY	ETF	146.49	146.54	146.47	146.54	33143.0
2012-09-13 19:00:00	SPY	ETF	146.54	146.59	146.54	146.58	87618.0
2012-09-13 19:30:00	SPY	ETF	146.58	146.63	146.54	146.55	49426.0
2012-09-13 04:30:00	QQQ	ETF	68.56	68.56	68.56	68.56	600.0
2012-09-13 07:00:00	QQQ	ETF	68.54	68.61	68.54	68.61	11005.0
2012-09-13 07:30:00	QQQ	ETF	68.62	68.64	68.59	68.61	22892.0
2012-09-13 08:00:00	QQQ	ETF	68.55	68.6	68.55	68.55	82271.0
2012-09-13 08:30:00	QQQ	ETF	68.88	68.88	68.52	68.67	55127.0
2012-09-13 09:00:00	QQQ	ETF	68.67	68.74	68.48	68.72	103640.0
2012-09-13 09:30:00	QQQ	ETF	68.71	68.78	68.62	68.75	3162935.0
2012-09-13 10:00:00	QQQ	ETF	68.74	68.89	68.68	68.69	2388423.0
2012-09-13 10:30:00	QQQ	ETF	68.69	68.8	68.69	68.77	1255397.0
2012-09-13 11:00:00	QQQ	ETF	68.775	68.865	68.77	68.86	1557733.0
2012-09-13 11:30:00	QQQ	ETF	68.87	68.88	68.78	68.8	1438761.0
2012-09-13 12:00:00	QQQ	ETF	68.8	68.8701	68.72	68.7645	1652994.0
2012-09-13 12:30:00	QQQ	ETF	68.76	69.34	68.68	69.22	10766665.0
2012-09-13 13:00:00	QQQ	ETF	69.22	69.47	69.22	69.46	4987756.0
2012-09-13 13:30:00	QQQ	ETF	69.46	69.62	69.46	69.475	2383495.0
2012-09-13 14:00:00	QQQ	ETF	69.4746	69.86	69.43	69.7917	3306496.0
2012-09-13 14:30:00	QQQ	ETF	69.795	69.81	69.64	69.68	2897904.0
2012-09-13 15:00:00	QQQ	ETF	69.68	69.73	69.581	69.638	2909871.0

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

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