PREVIEW / etf_30min / 2012-12-26

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-12-26.parquet
  size:    283 KB
  rows:    9,655

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-12-26 04:00:00	SPY	ETF	142.4	142.4	142.4	142.4	100.0
2012-12-26 05:30:00	SPY	ETF	142.39	142.39	142.39	142.39	100.0
2012-12-26 06:00:00	SPY	ETF	142.49	142.49	142.47	142.47	2100.0
2012-12-26 06:30:00	SPY	ETF	142.44	142.49	142.41	142.41	600.0
2012-12-26 07:00:00	SPY	ETF	142.42	142.5	142.42	142.49	51450.0
2012-12-26 07:30:00	SPY	ETF	142.49	142.63	142.47	142.58	65276.0
2012-12-26 08:00:00	SPY	ETF	142.58	142.62	142.52	142.53	142622.0
2012-12-26 08:30:00	SPY	ETF	142.53	142.55	142.42	142.49	109822.0
2012-12-26 09:00:00	SPY	ETF	142.49	142.76	142.33	142.64	320773.0
2012-12-26 09:30:00	SPY	ETF	142.64	142.71	142.48	142.53	6456760.0
2012-12-26 10:00:00	SPY	ETF	142.54	142.62	142.31	142.39	5395828.0
2012-12-26 10:30:00	SPY	ETF	142.395	142.4	142.02	142.02	4431796.0
2012-12-26 11:00:00	SPY	ETF	142.02	142.05	141.51	141.52	9357744.0
2012-12-26 11:30:00	SPY	ETF	141.525	142.18	141.35	141.655	6470256.0
2012-12-26 12:00:00	SPY	ETF	141.66	141.7401	141.5	141.58	3641209.0
2012-12-26 12:30:00	SPY	ETF	141.575	141.83	141.48	141.759	6218110.0
2012-12-26 13:00:00	SPY	ETF	141.759	141.785	141.62	141.7701	3225941.0
2012-12-26 13:30:00	SPY	ETF	141.78	141.8	141.64	141.69	5840767.0
2012-12-26 14:00:00	SPY	ETF	141.69	141.96	141.685	141.808	4731303.0
2012-12-26 14:30:00	SPY	ETF	141.81	142.18	141.74	142.06	6372637.0
2012-12-26 15:00:00	SPY	ETF	142.07	142.095	141.85	141.97	4303774.0
2012-12-26 15:30:00	SPY	ETF	141.97	141.97	141.69	141.71	18393623.0
2012-12-26 16:00:00	SPY	ETF	141.73	142.4068	141.53	141.62	8190465.0
2012-12-26 16:30:00	SPY	ETF	141.62	142.4065	141.48	141.57	2130935.0
2012-12-26 17:00:00	SPY	ETF	141.55	142.4065	141.52	141.62	6139224.0
2012-12-26 17:30:00	SPY	ETF	141.62	141.63	141.58	141.62	35106.0
2012-12-26 18:00:00	SPY	ETF	141.6	141.64	141.56	141.6	1030627.0
2012-12-26 18:30:00	SPY	ETF	141.63	141.66	141.61	141.63	6510.0
2012-12-26 19:00:00	SPY	ETF	141.65	141.68	141.61	141.68	13550.0
2012-12-26 19:30:00	SPY	ETF	141.64	141.71	141.62	141.71	16215.0
2012-12-26 06:00:00	QQQ	ETF	65.47	65.47	65.4	65.4	17061.0
2012-12-26 07:30:00	QQQ	ETF	65.11	65.15	65.05	65.07	17700.0
2012-12-26 08:00:00	QQQ	ETF	65.05	65.12	65.05	65.1	11446.0
2012-12-26 08:30:00	QQQ	ETF	65.07	65.08	65.03	65.04	25899.0
2012-12-26 09:00:00	QQQ	ETF	65.05	65.14	65.05	65.07	39493.0
2012-12-26 09:30:00	QQQ	ETF	65.08	65.18	64.99	65.0801	1744216.0
2012-12-26 10:00:00	QQQ	ETF	65.09	65.14	64.92	64.97	860681.0
2012-12-26 10:30:00	QQQ	ETF	64.97	64.97	64.67	64.67	846633.0
2012-12-26 11:00:00	QQQ	ETF	64.66	64.6999	64.38	64.399	2304418.0
2012-12-26 11:30:00	QQQ	ETF	64.39	64.5715	64.29	64.5669	1468599.0
2012-12-26 12:00:00	QQQ	ETF	64.57	64.59	64.41	64.46	960441.0
2012-12-26 12:30:00	QQQ	ETF	64.45	64.5425	64.38	64.5	1067453.0
2012-12-26 13:00:00	QQQ	ETF	64.509	64.569	64.44	64.56	695212.0
2012-12-26 13:30:00	QQQ	ETF	64.56	64.61	64.53	64.54	967242.0
2012-12-26 14:00:00	QQQ	ETF	64.5426	64.72	64.54	64.58	2248021.0
2012-12-26 14:30:00	QQQ	ETF	64.58	64.74	64.54	64.71	1026647.0
2012-12-26 15:00:00	QQQ	ETF	64.7	64.71	64.58	64.6499	1047701.0
2012-12-26 15:30:00	QQQ	ETF	64.64	64.65	64.48	64.52	5139694.0
2012-12-26 16:00:00	QQQ	ETF	64.52	64.5502	64.45	64.5	1077520.0
2012-12-26 16:30:00	QQQ	ETF	64.49	64.52	64.47	64.52	7589.0

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

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