PREVIEW / etf_30min / 2013-04-09

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-09.parquet
  size:    310 KB
  rows:    10,412

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
2013-04-09 04:00:00	SPY	ETF	156.48	156.67	156.48	156.66	7099.0
2013-04-09 04:30:00	SPY	ETF	156.69	156.69	156.5	156.5	7800.0
2013-04-09 05:00:00	SPY	ETF	156.39	156.62	156.39	156.62	9100.0
2013-04-09 05:30:00	SPY	ETF	156.61	156.61	156.4	156.49	47900.0
2013-04-09 06:00:00	SPY	ETF	156.5	156.55	156.47	156.55	5300.0
2013-04-09 06:30:00	SPY	ETF	156.52	156.52	156.41	156.41	88600.0
2013-04-09 07:00:00	SPY	ETF	156.45	156.63	156.45	156.57	50410.0
2013-04-09 07:30:00	SPY	ETF	156.57	156.64	156.52	156.54	70976.0
2013-04-09 08:00:00	SPY	ETF	156.54	156.64	156.44	156.55	447910.0
2013-04-09 08:30:00	SPY	ETF	156.54	156.75	156.54	156.65	534463.0
2013-04-09 09:00:00	SPY	ETF	156.65	156.71	156.48	156.5	652803.0
2013-04-09 09:30:00	SPY	ETF	156.5	156.6	155.98	156.06	11585028.0
2013-04-09 10:00:00	SPY	ETF	156.06	156.51	156.02	156.51	7448425.0
2013-04-09 10:30:00	SPY	ETF	156.51	156.53	156.11	156.24	8417073.0
2013-04-09 11:00:00	SPY	ETF	156.235	156.33	156.04	156.235	6329187.0
2013-04-09 11:30:00	SPY	ETF	156.2301	156.5	156.22	156.49	4383832.0
2013-04-09 12:00:00	SPY	ETF	156.49	156.58	156.37	156.561	3020682.0
2013-04-09 12:30:00	SPY	ETF	156.5616	156.76	156.561	156.63	4539120.0
2013-04-09 13:00:00	SPY	ETF	156.64	157.11	156.63	157.04	7449126.0
2013-04-09 13:30:00	SPY	ETF	157.04	157.19	156.99	157.03	5991585.0
2013-04-09 14:00:00	SPY	ETF	157.02	157.19	156.97	157.13	4735506.0
2013-04-09 14:30:00	SPY	ETF	157.13	157.32	157.12	157.23	6290583.0
2013-04-09 15:00:00	SPY	ETF	157.23	157.3	157.02	157.06	5926315.0
2013-04-09 15:30:00	SPY	ETF	157.055	157.09	156.7	156.74	16684015.0
2013-04-09 16:00:00	SPY	ETF	156.73	157.1	156.71	156.77	4900746.0
2013-04-09 16:30:00	SPY	ETF	156.76	156.8916	156.75	156.76	183633.0
2013-04-09 17:00:00	SPY	ETF	156.76	156.83	156.76	156.79	131745.0
2013-04-09 17:30:00	SPY	ETF	156.79	156.79	156.76	156.78	15315.0
2013-04-09 18:00:00	SPY	ETF	156.77	156.77	156.65	156.7	1098301.0
2013-04-09 18:30:00	SPY	ETF	156.72	156.72	156.69	156.69	6966.0
2013-04-09 19:00:00	SPY	ETF	156.69	156.74	156.69	156.74	3602.0
2013-04-09 19:30:00	SPY	ETF	156.73	156.74	156.63	156.65	50997.0
2013-04-09 04:30:00	QQQ	ETF	68.43	68.43	68.43	68.43	3600.0
2013-04-09 05:00:00	QQQ	ETF	68.45	68.45	68.45	68.45	11400.0
2013-04-09 06:30:00	QQQ	ETF	68.42	68.42	68.42	68.42	5400.0
2013-04-09 07:00:00	QQQ	ETF	68.44	68.49	68.44	68.49	4800.0
2013-04-09 07:30:00	QQQ	ETF	68.48	68.5	68.44	68.44	1300.0
2013-04-09 08:00:00	QQQ	ETF	68.45	68.49	68.42	68.44	26385.0
2013-04-09 08:30:00	QQQ	ETF	68.44	68.54	68.44	68.53	35060.0
2013-04-09 09:00:00	QQQ	ETF	68.53	68.56	68.42	68.42	140190.0
2013-04-09 09:30:00	QQQ	ETF	68.42	68.46	68.13	68.17	4167351.0
2013-04-09 10:00:00	QQQ	ETF	68.17	68.45	68.15	68.44	1603270.0
2013-04-09 10:30:00	QQQ	ETF	68.44	68.45	68.26	68.32	1843824.0
2013-04-09 11:00:00	QQQ	ETF	68.32	68.34	68.09	68.22	1744016.0
2013-04-09 11:30:00	QQQ	ETF	68.23	68.38	68.21	68.37	1178119.0
2013-04-09 12:00:00	QQQ	ETF	68.3799	68.42	68.31	68.415	623970.0
2013-04-09 12:30:00	QQQ	ETF	68.42	68.51	68.42	68.48	857408.0
2013-04-09 13:00:00	QQQ	ETF	68.49	68.87	68.49	68.84	2795792.0
2013-04-09 13:30:00	QQQ	ETF	68.84	68.88	68.775	68.7899	1548541.0
2013-04-09 14:00:00	QQQ	ETF	68.79	68.86	68.75	68.81	1513185.0

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

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