PREVIEW / etf_30min / 2011-09-29

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-09-29.parquet
  size:    290 KB
  rows:    9,682

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
2011-09-29 04:00:00	SPY	ETF	116.2	116.62	116.2	116.47	4192.0
2011-09-29 04:30:00	SPY	ETF	116.34	116.6	116.34	116.55	2000.0
2011-09-29 05:00:00	SPY	ETF	116.5	116.77	116.4	116.52	24250.0
2011-09-29 05:30:00	SPY	ETF	116.43	116.61	116.22	116.61	51970.0
2011-09-29 06:00:00	SPY	ETF	116.57	116.94	116.34	116.57	31251.0
2011-09-29 06:30:00	SPY	ETF	116.54	116.6	116.08	116.1	114770.0
2011-09-29 07:00:00	SPY	ETF	116.1	116.2	115.88	115.97	343597.0
2011-09-29 07:30:00	SPY	ETF	115.96	116.3	115.94	116.05	533990.0
2011-09-29 08:00:00	SPY	ETF	116.04	116.75	115.85	116.4	957994.0
2011-09-29 08:30:00	SPY	ETF	116.44	117.28	116.4	117.07	5488402.0
2011-09-29 09:00:00	SPY	ETF	117.09	117.45	116.92	117.05	2292643.0
2011-09-29 09:30:00	SPY	ETF	117.05	117.63	116.97	117.21	30456048.0
2011-09-29 10:00:00	SPY	ETF	117.21	117.37	116.28	116.365	23737369.0
2011-09-29 10:30:00	SPY	ETF	116.36	116.42	115.55	115.97	29664576.0
2011-09-29 11:00:00	SPY	ETF	115.97	116.32	115.72	116.26	16208750.0
2011-09-29 11:30:00	SPY	ETF	116.26	116.63	116.13	116.38	12393864.0
2011-09-29 12:00:00	SPY	ETF	116.39	116.66	116.19	116.4537	9966531.0
2011-09-29 12:30:00	SPY	ETF	116.45	116.48	115.66	115.985	13221205.0
2011-09-29 13:00:00	SPY	ETF	115.98	116.37	115.69	115.72	9301942.0
2011-09-29 13:30:00	SPY	ETF	115.71	115.82	114.82	115.17	19956624.0
2011-09-29 14:00:00	SPY	ETF	115.165	115.29	114.14	114.715	21271529.0
2011-09-29 14:30:00	SPY	ETF	114.72	114.98	114.15	114.69	17177779.0
2011-09-29 15:00:00	SPY	ETF	114.66	114.85	113.93	114.68	26781000.0
2011-09-29 15:30:00	SPY	ETF	114.68	116.04	114.585	116.02	47294398.0
2011-09-29 16:00:00	SPY	ETF	116.04	116.45	115.25	116.28	7808682.0
2011-09-29 16:30:00	SPY	ETF	116.28	116.4	116.23	116.38	510208.0
2011-09-29 17:00:00	SPY	ETF	116.34	116.5	116.28	116.4	301686.0
2011-09-29 17:30:00	SPY	ETF	116.4	116.41	116.35	116.38	76633.0
2011-09-29 18:00:00	SPY	ETF	116.38	116.54	116.02	116.44	245379.0
2011-09-29 18:30:00	SPY	ETF	116.44	116.5	116.36	116.46	39973.0
2011-09-29 19:00:00	SPY	ETF	116.44	116.44	116.23	116.26	61109.0
2011-09-29 19:30:00	SPY	ETF	116.29	116.34	116.24	116.3	75305.0
2011-09-29 04:00:00	QQQ	ETF	54.91	55.16	54.91	55.14	5598.0
2011-09-29 04:30:00	QQQ	ETF	55.14	55.14	55.14	55.14	100.0
2011-09-29 05:00:00	QQQ	ETF	55.19	55.19	55.13	55.13	275.0
2011-09-29 05:30:00	QQQ	ETF	55.12	55.12	55.12	55.12	100.0
2011-09-29 06:00:00	QQQ	ETF	55.14	55.32	55.05	55.05	4200.0
2011-09-29 06:30:00	QQQ	ETF	55.07	55.07	55.02	55.05	8400.0
2011-09-29 07:00:00	QQQ	ETF	55.02	55.02	54.79	54.79	34137.0
2011-09-29 07:30:00	QQQ	ETF	54.89	54.97	54.85	54.9	36250.0
2011-09-29 08:00:00	QQQ	ETF	54.9	55.06	54.86	55.05	217955.0
2011-09-29 08:30:00	QQQ	ETF	55.06	55.56	55.05	55.49	1177637.0
2011-09-29 09:00:00	QQQ	ETF	55.47	55.57	55.29	55.32	515895.0
2011-09-29 09:30:00	QQQ	ETF	55.33	55.43	55.05	55.1	10845166.0
2011-09-29 10:00:00	QQQ	ETF	55.12	55.2	54.49	54.5	6782580.0
2011-09-29 10:30:00	QQQ	ETF	54.5	54.58	54.04	54.23	8809168.0
2011-09-29 11:00:00	QQQ	ETF	54.223	54.4	54.1	54.38	4880796.0
2011-09-29 11:30:00	QQQ	ETF	54.39	54.62	54.33	54.4584	3801425.0
2011-09-29 12:00:00	QQQ	ETF	54.455	54.58	54.32	54.44	2514009.0
2011-09-29 12:30:00	QQQ	ETF	54.43	54.43	54.06	54.15	3681796.0

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

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