PREVIEW / etf_30min / 2012-09-18

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-09-18.parquet
  size:    288 KB
  rows:    9,819

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-09-18 04:00:00	SPY	ETF	146.57	146.57	146.29	146.32	68256.0
2012-09-18 04:30:00	SPY	ETF	146.32	146.42	146.3	146.42	3584.0
2012-09-18 05:00:00	SPY	ETF	146.32	146.38	146.32	146.38	9700.0
2012-09-18 05:30:00	SPY	ETF	146.33	146.33	146.22	146.24	18065.0
2012-09-18 06:00:00	SPY	ETF	146.25	146.31	146.25	146.31	13100.0
2012-09-18 06:30:00	SPY	ETF	146.31	146.45	146.3	146.45	10900.0
2012-09-18 07:00:00	SPY	ETF	146.44	146.6	146.38	146.58	150920.0
2012-09-18 07:30:00	SPY	ETF	146.58	146.6	146.49	146.58	256602.0
2012-09-18 08:00:00	SPY	ETF	146.59	146.99	146.4	146.43	1017568.0
2012-09-18 08:30:00	SPY	ETF	146.44	146.76	146.43	146.63	384237.0
2012-09-18 09:00:00	SPY	ETF	146.63	146.66	146.49	146.49	901007.0
2012-09-18 09:30:00	SPY	ETF	146.49	146.56	146.25	146.51	13947977.0
2012-09-18 10:00:00	SPY	ETF	146.5	146.6	146.35	146.5	10166758.0
2012-09-18 10:30:00	SPY	ETF	146.495	146.66	146.41	146.6401	7888689.0
2012-09-18 11:00:00	SPY	ETF	146.64	146.81	146.59	146.73	6498386.0
2012-09-18 11:30:00	SPY	ETF	146.73	146.74	146.49	146.53	4062184.0
2012-09-18 12:00:00	SPY	ETF	146.531	146.5799	146.29	146.3	6757797.0
2012-09-18 12:30:00	SPY	ETF	146.31	146.54	146.28	146.45	2773169.0
2012-09-18 13:00:00	SPY	ETF	146.45	146.55	146.27	146.43	5825563.0
2012-09-18 13:30:00	SPY	ETF	146.43	146.44	146.3	146.34	2635993.0
2012-09-18 14:00:00	SPY	ETF	146.34	146.47	146.29	146.43	2768587.0
2012-09-18 14:30:00	SPY	ETF	146.42	146.47	146.3	146.4	2733648.0
2012-09-18 15:00:00	SPY	ETF	146.39	146.53	146.35	146.47	3464842.0
2012-09-18 15:30:00	SPY	ETF	146.47	146.65	146.4	146.62	12571243.0
2012-09-18 16:00:00	SPY	ETF	146.63	146.7	146.4741	146.62	10375125.0
2012-09-18 16:30:00	SPY	ETF	146.63	146.77	146.52	146.74	1513663.0
2012-09-18 17:00:00	SPY	ETF	146.74	146.78	146.7	146.75	69400.0
2012-09-18 17:30:00	SPY	ETF	146.75	146.77	146.73	146.77	29881.0
2012-09-18 18:00:00	SPY	ETF	146.75	146.75	146.71	146.71	8377.0
2012-09-18 18:30:00	SPY	ETF	146.71	146.74	146.7	146.73	9047.0
2012-09-18 19:00:00	SPY	ETF	146.71	146.74	146.71	146.74	4023.0
2012-09-18 19:30:00	SPY	ETF	146.75	146.76	146.7	146.7	11715.0
2012-09-18 05:30:00	QQQ	ETF	69.92	69.92	69.92	69.92	100.0
2012-09-18 06:00:00	QQQ	ETF	69.92	69.94	69.92	69.94	7400.0
2012-09-18 06:30:00	QQQ	ETF	69.97	70.02	69.97	70.02	17800.0
2012-09-18 07:00:00	QQQ	ETF	70.02	70.07	70.0	70.06	8100.0
2012-09-18 07:30:00	QQQ	ETF	70.07	70.08	70.03	70.08	6991.0
2012-09-18 08:00:00	QQQ	ETF	69.92	70.09	69.92	70.01	16190.0
2012-09-18 08:30:00	QQQ	ETF	70.01	70.14	70.0	70.08	52869.0
2012-09-18 09:00:00	QQQ	ETF	70.08	70.09	70.02	70.04	256801.0
2012-09-18 09:30:00	QQQ	ETF	70.04	70.26	70.02	70.23	4567705.0
2012-09-18 10:00:00	QQQ	ETF	70.23	70.3	70.1	70.19	2510437.0
2012-09-18 10:30:00	QQQ	ETF	70.19	70.25	70.14	70.22	1964373.0
2012-09-18 11:00:00	QQQ	ETF	70.22	70.28	70.19	70.24	2101353.0
2012-09-18 11:30:00	QQQ	ETF	70.24	70.25	70.18	70.2	810140.0
2012-09-18 12:00:00	QQQ	ETF	70.2	70.23	70.07	70.082	1859698.0
2012-09-18 12:30:00	QQQ	ETF	70.09	70.19	70.07	70.15	738322.0
2012-09-18 13:00:00	QQQ	ETF	70.15	70.21	70.08	70.18	978924.0
2012-09-18 13:30:00	QQQ	ETF	70.19	70.2	70.12	70.14	604068.0
2012-09-18 14:00:00	QQQ	ETF	70.15	70.21	70.12	70.19	709727.0

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

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