PREVIEW / etf_30min / 2012-08-10

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-10.parquet
  size:    268 KB
  rows:    9,049

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-08-10 04:00:00	SPY	ETF	140.19	140.33	140.14	140.26	7356.0
2012-08-10 04:30:00	SPY	ETF	140.33	140.33	140.24	140.24	1800.0
2012-08-10 05:00:00	SPY	ETF	140.23	140.31	140.23	140.31	3600.0
2012-08-10 05:30:00	SPY	ETF	140.24	140.24	140.14	140.21	32100.0
2012-08-10 06:00:00	SPY	ETF	140.22	140.25	140.2	140.23	11100.0
2012-08-10 06:30:00	SPY	ETF	140.23	140.23	140.01	140.02	170902.0
2012-08-10 07:00:00	SPY	ETF	140.05	140.1	139.98	140.03	165437.0
2012-08-10 07:30:00	SPY	ETF	140.05	140.06	139.99	140.04	104879.0
2012-08-10 08:00:00	SPY	ETF	140.04	140.21	140.02	140.12	247586.0
2012-08-10 08:30:00	SPY	ETF	140.1	140.19	139.98	140.12	595261.0
2012-08-10 09:00:00	SPY	ETF	140.1	140.22	140.03	140.04	877844.0
2012-08-10 09:30:00	SPY	ETF	140.04	140.15	139.81	140.04	11923994.0
2012-08-10 10:00:00	SPY	ETF	140.04	140.41	139.91	140.28	10255183.0
2012-08-10 10:30:00	SPY	ETF	140.29	140.49	140.27	140.4	7679301.0
2012-08-10 11:00:00	SPY	ETF	140.4	140.43	139.97	140.32	9484538.0
2012-08-10 11:30:00	SPY	ETF	140.33	140.46	140.21	140.41	6715404.0
2012-08-10 12:00:00	SPY	ETF	140.41	140.43	140.285	140.39	3108593.0
2012-08-10 12:30:00	SPY	ETF	140.4	140.574	140.26	140.31	5743121.0
2012-08-10 13:00:00	SPY	ETF	140.32	140.335	140.17	140.301	3994360.0
2012-08-10 13:30:00	SPY	ETF	140.3	140.46	140.28	140.4	5245495.0
2012-08-10 14:00:00	SPY	ETF	140.39	140.45	140.31	140.4	3041014.0
2012-08-10 14:30:00	SPY	ETF	140.4	140.5	140.37	140.45	4810260.0
2012-08-10 15:00:00	SPY	ETF	140.45	140.63	140.43	140.62	6341187.0
2012-08-10 15:30:00	SPY	ETF	140.62	140.89	140.53	140.84	13038370.0
2012-08-10 16:00:00	SPY	ETF	140.85	140.95	140.23	140.9	4488156.0
2012-08-10 16:30:00	SPY	ETF	140.9	140.97	140.71	140.71	1176102.0
2012-08-10 17:00:00	SPY	ETF	140.71	140.79	140.71	140.78	27861.0
2012-08-10 17:30:00	SPY	ETF	140.75	140.78	140.74	140.75	22438.0
2012-08-10 18:00:00	SPY	ETF	140.74	140.78	140.74	140.78	14068.0
2012-08-10 18:30:00	SPY	ETF	140.79	140.79	140.77	140.78	8800.0
2012-08-10 19:00:00	SPY	ETF	140.79	140.8	140.77	140.79	6946.0
2012-08-10 19:30:00	SPY	ETF	140.8	140.87	140.78	140.87	25571.0
2012-08-10 04:30:00	QQQ	ETF	66.71	66.71	66.65	66.65	1600.0
2012-08-10 05:30:00	QQQ	ETF	66.63	66.63	66.63	66.63	100.0
2012-08-10 06:00:00	QQQ	ETF	66.62	66.62	66.62	66.62	1000.0
2012-08-10 06:30:00	QQQ	ETF	66.59	66.59	66.59	66.59	700.0
2012-08-10 07:00:00	QQQ	ETF	66.59	66.6	66.52	66.57	51925.0
2012-08-10 07:30:00	QQQ	ETF	66.58	66.58	66.55	66.57	28812.0
2012-08-10 08:00:00	QQQ	ETF	66.57	66.61	66.57	66.6	83390.0
2012-08-10 08:30:00	QQQ	ETF	66.61	66.64	66.52	66.61	54951.0
2012-08-10 09:00:00	QQQ	ETF	66.62	66.64	66.57	66.6	136106.0
2012-08-10 09:30:00	QQQ	ETF	66.6	66.66	66.41	66.5	2910862.0
2012-08-10 10:00:00	QQQ	ETF	66.5	66.71	66.46	66.62	1889829.0
2012-08-10 10:30:00	QQQ	ETF	66.62	66.71	66.62	66.69	1561908.0
2012-08-10 11:00:00	QQQ	ETF	66.69	66.73	66.51	66.67	2063263.0
2012-08-10 11:30:00	QQQ	ETF	66.67	66.71	66.62	66.682	825704.0
2012-08-10 12:00:00	QQQ	ETF	66.6899	66.69	66.6292	66.66	840544.0
2012-08-10 12:30:00	QQQ	ETF	66.67	66.68	66.6	66.63	556552.0
2012-08-10 13:00:00	QQQ	ETF	66.6301	66.65	66.58	66.6	469266.0
2012-08-10 13:30:00	QQQ	ETF	66.6	66.69	66.59	66.67	1198577.0

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

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