PREVIEW / etf_30min / 2012-08-07

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-07.parquet
  size:    287 KB
  rows:    9,692

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-07 04:30:00	SPY	ETF	140.02	140.02	139.89	139.89	591.0
2012-08-07 05:00:00	SPY	ETF	139.9	139.9	139.9	139.9	400.0
2012-08-07 05:30:00	SPY	ETF	139.91	139.91	139.75	139.83	8100.0
2012-08-07 06:00:00	SPY	ETF	139.69	140.0	139.65	140.0	10100.0
2012-08-07 06:30:00	SPY	ETF	139.97	140.02	139.96	140.0	37725.0
2012-08-07 07:00:00	SPY	ETF	140.0	140.1	139.95	140.08	117800.0
2012-08-07 07:30:00	SPY	ETF	140.08	140.18	140.02	140.06	178596.0
2012-08-07 08:00:00	SPY	ETF	140.05	140.17	140.04	140.16	838172.0
2012-08-07 08:30:00	SPY	ETF	140.16	140.37	140.14	140.14	497587.0
2012-08-07 09:00:00	SPY	ETF	140.14	140.24	140.1	140.18	1106542.0
2012-08-07 09:30:00	SPY	ETF	140.18	140.48	140.15	140.42	12262966.0
2012-08-07 10:00:00	SPY	ETF	140.43	140.66	140.34	140.55	9000225.0
2012-08-07 10:30:00	SPY	ETF	140.55	140.62	140.45	140.535	8311593.0
2012-08-07 11:00:00	SPY	ETF	140.54	140.56	140.34	140.49	6083094.0
2012-08-07 11:30:00	SPY	ETF	140.5	140.83	140.5	140.791	10906686.0
2012-08-07 12:00:00	SPY	ETF	140.795	140.83	140.73	140.79	5852325.0
2012-08-07 12:30:00	SPY	ETF	140.79	140.92	140.78	140.81	3900491.0
2012-08-07 13:00:00	SPY	ETF	140.82	140.85	140.74	140.8354	4330395.0
2012-08-07 13:30:00	SPY	ETF	140.83	140.86	140.74	140.76	2982624.0
2012-08-07 14:00:00	SPY	ETF	140.77	140.79	140.58	140.6	3860979.0
2012-08-07 14:30:00	SPY	ETF	140.591	140.7	140.56	140.58	3288414.0
2012-08-07 15:00:00	SPY	ETF	140.59	140.6	140.38	140.502	8088410.0
2012-08-07 15:30:00	SPY	ETF	140.51	140.56	140.26	140.29	12882298.0
2012-08-07 16:00:00	SPY	ETF	140.3	140.44	140.28	140.28	10305631.0
2012-08-07 16:30:00	SPY	ETF	140.28	140.3235	140.2	140.31	2584331.0
2012-08-07 17:00:00	SPY	ETF	140.3	140.32	140.2	140.22	117210.0
2012-08-07 17:30:00	SPY	ETF	140.21	140.24	140.21	140.21	48600.0
2012-08-07 18:00:00	SPY	ETF	140.24	140.29	140.2	140.29	12329.0
2012-08-07 18:30:00	SPY	ETF	140.24	140.32	140.24	140.31	31100.0
2012-08-07 19:00:00	SPY	ETF	140.31	140.31	140.26	140.28	18650.0
2012-08-07 19:30:00	SPY	ETF	140.27	140.27	140.18	140.21	48700.0
2012-08-07 04:00:00	QQQ	ETF	66.38	66.43	66.38	66.43	3098.0
2012-08-07 05:00:00	QQQ	ETF	66.37	66.39	66.37	66.37	1000.0
2012-08-07 05:30:00	QQQ	ETF	66.34	66.34	66.34	66.34	100.0
2012-08-07 06:00:00	QQQ	ETF	66.39	66.4	66.39	66.4	600.0
2012-08-07 06:30:00	QQQ	ETF	66.39	66.39	66.38	66.38	2100.0
2012-08-07 07:00:00	QQQ	ETF	66.39	66.42	66.38	66.42	17940.0
2012-08-07 07:30:00	QQQ	ETF	66.42	66.43	66.39	66.39	57365.0
2012-08-07 08:00:00	QQQ	ETF	66.4	66.45	66.38	66.45	36175.0
2012-08-07 08:30:00	QQQ	ETF	66.45	66.52	66.4	66.41	95517.0
2012-08-07 09:00:00	QQQ	ETF	66.41	66.44	66.34	66.39	155312.0
2012-08-07 09:30:00	QQQ	ETF	66.38	66.52	66.28	66.44	3668143.0
2012-08-07 10:00:00	QQQ	ETF	66.44	66.64	66.4	66.6	3151480.0
2012-08-07 10:30:00	QQQ	ETF	66.6	66.62	66.53	66.6	1514590.0
2012-08-07 11:00:00	QQQ	ETF	66.6	66.64	66.47	66.6	1608232.0
2012-08-07 11:30:00	QQQ	ETF	66.61	66.84	66.61	66.81	3407098.0
2012-08-07 12:00:00	QQQ	ETF	66.8192	66.87	66.78	66.8501	1913203.0
2012-08-07 12:30:00	QQQ	ETF	66.86	66.92	66.8201	66.839	1664285.0
2012-08-07 13:00:00	QQQ	ETF	66.83	66.84	66.76	66.83	807030.0
2012-08-07 13:30:00	QQQ	ETF	66.83	66.85	66.78	66.81	641480.0

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

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