PREVIEW / etf_30min / 2012-09-11

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-09-11.parquet
  size:    285 KB
  rows:    9,630

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-11 04:00:00	SPY	ETF	143.4	143.59	143.4	143.49	1300.0
2012-09-11 04:30:00	SPY	ETF	143.55	143.7	143.54	143.65	13481.0
2012-09-11 05:00:00	SPY	ETF	143.58	143.67	143.51	143.67	41425.0
2012-09-11 05:30:00	SPY	ETF	143.61	143.61	143.57	143.57	1100.0
2012-09-11 06:00:00	SPY	ETF	143.54	143.54	143.46	143.46	1200.0
2012-09-11 06:30:00	SPY	ETF	143.47	143.65	143.47	143.61	74250.0
2012-09-11 07:00:00	SPY	ETF	143.62	143.85	143.61	143.81	194139.0
2012-09-11 07:30:00	SPY	ETF	143.82	143.85	143.7	143.75	203250.0
2012-09-11 08:00:00	SPY	ETF	143.71	143.88	143.69	143.72	445076.0
2012-09-11 08:30:00	SPY	ETF	143.74	143.81	143.57	143.7	808574.0
2012-09-11 09:00:00	SPY	ETF	143.73	143.87	143.58	143.6	892314.0
2012-09-11 09:30:00	SPY	ETF	143.6	144.07	143.56	144.0	12914824.0
2012-09-11 10:00:00	SPY	ETF	144.0099	144.07	143.9	143.96	6302503.0
2012-09-11 10:30:00	SPY	ETF	143.96	144.15	143.91	144.1	5152021.0
2012-09-11 11:00:00	SPY	ETF	144.1	144.37	144.09	144.34	4572673.0
2012-09-11 11:30:00	SPY	ETF	144.34	144.37	144.1	144.15	5524280.0
2012-09-11 12:00:00	SPY	ETF	144.15	144.19	143.99	144.12	4582675.0
2012-09-11 12:30:00	SPY	ETF	144.12	144.15	144.0	144.1098	3259258.0
2012-09-11 13:00:00	SPY	ETF	144.1	144.21	144.02	144.15	3477655.0
2012-09-11 13:30:00	SPY	ETF	144.15	144.28	144.11	144.16	2909217.0
2012-09-11 14:00:00	SPY	ETF	144.15	144.21	144.03	144.1792	2519899.0
2012-09-11 14:30:00	SPY	ETF	144.17	144.2	143.87	143.95	6292815.0
2012-09-11 15:00:00	SPY	ETF	143.94	144.02	143.79	143.86	5089026.0
2012-09-11 15:30:00	SPY	ETF	143.85	144.02	143.8	143.88	9005021.0
2012-09-11 16:00:00	SPY	ETF	143.88	144.0	143.68	143.72	5317215.0
2012-09-11 16:30:00	SPY	ETF	143.71	143.929	143.64	143.67	4491532.0
2012-09-11 17:00:00	SPY	ETF	143.67	144.06	143.61	143.66	169919.0
2012-09-11 17:30:00	SPY	ETF	143.65	143.67	143.4805	143.66	2517755.0
2012-09-11 18:00:00	SPY	ETF	143.63	143.65	143.53	143.55	67994.0
2012-09-11 18:30:00	SPY	ETF	143.56	143.56	143.52	143.56	23161.0
2012-09-11 19:00:00	SPY	ETF	143.55	143.6	143.51	143.55	42001.0
2012-09-11 19:30:00	SPY	ETF	143.6	143.62	143.54	143.61	45443.0
2012-09-11 06:30:00	QQQ	ETF	68.55	68.55	68.55	68.55	100.0
2012-09-11 07:00:00	QQQ	ETF	68.58	68.69	68.58	68.68	30000.0
2012-09-11 07:30:00	QQQ	ETF	68.67	68.67	68.62	68.62	16400.0
2012-09-11 08:00:00	QQQ	ETF	68.64	68.7	68.62	68.62	21495.0
2012-09-11 08:30:00	QQQ	ETF	68.66	68.67	68.58	68.64	51390.0
2012-09-11 09:00:00	QQQ	ETF	68.65	68.68	68.52	68.54	690845.0
2012-09-11 09:30:00	QQQ	ETF	68.54	68.79	68.44	68.71	3586467.0
2012-09-11 10:00:00	QQQ	ETF	68.71	68.76	68.47	68.585	2124633.0
2012-09-11 10:30:00	QQQ	ETF	68.59	68.74	68.56	68.7	1740618.0
2012-09-11 11:00:00	QQQ	ETF	68.7035	68.82	68.7	68.7999	1780168.0
2012-09-11 11:30:00	QQQ	ETF	68.79	68.81	68.63	68.66	1725642.0
2012-09-11 12:00:00	QQQ	ETF	68.65	68.74	68.61	68.6283	1823509.0
2012-09-11 12:30:00	QQQ	ETF	68.62	68.66	68.52	68.61	713193.0
2012-09-11 13:00:00	QQQ	ETF	68.61	68.69	68.55	68.67	704986.0
2012-09-11 13:30:00	QQQ	ETF	68.6699	68.75	68.64	68.65	1131590.0
2012-09-11 14:00:00	QQQ	ETF	68.65	68.69	68.55	68.67	883795.0
2012-09-11 14:30:00	QQQ	ETF	68.67	68.67	68.38	68.45	3681885.0
2012-09-11 15:00:00	QQQ	ETF	68.45	68.51	68.32	68.36	3089068.0

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

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