PREVIEW / etf_30min / 2011-09-06

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-09-06.parquet
  size:    300 KB
  rows:    10,034

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-06 04:00:00	SPY	ETF	116.0	116.2	115.38	115.4	8797.0
2011-09-06 04:30:00	SPY	ETF	115.41	115.75	115.27	115.75	7920.0
2011-09-06 05:00:00	SPY	ETF	115.75	115.99	115.45	115.9	26675.0
2011-09-06 05:30:00	SPY	ETF	115.88	115.88	115.59	115.79	7600.0
2011-09-06 06:00:00	SPY	ETF	115.75	115.96	115.49	115.8	11108.0
2011-09-06 06:30:00	SPY	ETF	115.8	115.88	115.67	115.76	26375.0
2011-09-06 07:00:00	SPY	ETF	115.75	115.92	115.04	115.07	509925.0
2011-09-06 07:30:00	SPY	ETF	115.05	115.22	114.8	114.84	457171.0
2011-09-06 08:00:00	SPY	ETF	114.84	115.86	114.05	114.73	1988299.0
2011-09-06 08:30:00	SPY	ETF	114.73	115.0	114.4	114.47	1750639.0
2011-09-06 09:00:00	SPY	ETF	114.47	114.9	114.19	114.4	3950292.0
2011-09-06 09:30:00	SPY	ETF	114.39	115.419	114.38	115.29	33691762.0
2011-09-06 10:00:00	SPY	ETF	115.31	115.95	114.62	114.67	31672950.0
2011-09-06 10:30:00	SPY	ETF	114.67	115.14	114.41	115.0865	22801350.0
2011-09-06 11:00:00	SPY	ETF	115.08	115.56	114.86	115.52	16893867.0
2011-09-06 11:30:00	SPY	ETF	115.52	115.75	115.29	115.62	11775672.0
2011-09-06 12:00:00	SPY	ETF	115.6295	116.08	115.535	115.89	10721429.0
2011-09-06 12:30:00	SPY	ETF	115.9	115.9	115.62	115.76	6792327.0
2011-09-06 13:00:00	SPY	ETF	115.76	116.17	115.64	115.9	13823049.0
2011-09-06 13:30:00	SPY	ETF	115.9	116.44	115.71	116.23	16373606.0
2011-09-06 14:00:00	SPY	ETF	116.23	116.885	116.14	116.72	14767755.0
2011-09-06 14:30:00	SPY	ETF	116.72	116.725	116.16	116.21	11785556.0
2011-09-06 15:00:00	SPY	ETF	116.2	116.65	115.72	115.98	17853293.0
2011-09-06 15:30:00	SPY	ETF	115.98	117.16	115.82	117.02	42348801.0
2011-09-06 16:00:00	SPY	ETF	117.01	117.8324	114.7	117.03	12797205.0
2011-09-06 16:30:00	SPY	ETF	117.04	117.26	116.98	117.15	9223195.0
2011-09-06 17:00:00	SPY	ETF	117.15	117.29	117.08	117.29	194619.0
2011-09-06 17:30:00	SPY	ETF	117.28	117.3	117.24	117.26	41006.0
2011-09-06 18:00:00	SPY	ETF	117.25	117.27	116.99	117.15	121644.0
2011-09-06 18:30:00	SPY	ETF	117.16	117.22	117.14	117.2	21800.0
2011-09-06 19:00:00	SPY	ETF	117.17	117.35	117.16	117.35	56559.0
2011-09-06 19:30:00	SPY	ETF	117.35	117.4	117.25	117.26	47396.0
2011-09-06 04:00:00	QQQ	ETF	52.9	52.9	52.7	52.7	1031.0
2011-09-06 05:00:00	QQQ	ETF	53.0	53.0	53.0	53.0	200.0
2011-09-06 06:30:00	QQQ	ETF	52.63	52.7	52.63	52.65	4303.0
2011-09-06 07:00:00	QQQ	ETF	52.67	52.72	52.34	52.37	49159.0
2011-09-06 07:30:00	QQQ	ETF	52.34	52.36	52.25	52.25	47614.0
2011-09-06 08:00:00	QQQ	ETF	52.25	52.4	52.19	52.22	138509.0
2011-09-06 08:30:00	QQQ	ETF	52.25	52.33	52.14	52.17	294160.0
2011-09-06 09:00:00	QQQ	ETF	52.19	52.32	52.01	52.03	588656.0
2011-09-06 09:30:00	QQQ	ETF	52.04	52.36	52.01	52.305	6810827.0
2011-09-06 10:00:00	QQQ	ETF	52.3	52.5	52.04	52.0529	7052881.0
2011-09-06 10:30:00	QQQ	ETF	52.06	52.271	51.91	52.271	4886639.0
2011-09-06 11:00:00	QQQ	ETF	52.2622	52.47	52.12	52.46	3810133.0
2011-09-06 11:30:00	QQQ	ETF	52.46	52.58	52.28	52.44	3069994.0
2011-09-06 12:00:00	QQQ	ETF	52.43	52.65	52.4	52.55	1815923.0
2011-09-06 12:30:00	QQQ	ETF	52.54	52.55	52.39	52.46	1253533.0
2011-09-06 13:00:00	QQQ	ETF	52.46	52.72	52.41	52.6	2040603.0
2011-09-06 13:30:00	QQQ	ETF	52.59	52.89	52.5	52.8001	2758879.0
2011-09-06 14:00:00	QQQ	ETF	52.81	53.16	52.78	53.08	3602764.0

> showing 50 of 10,034 rows — these rows as CSV

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