PREVIEW / etf_30min / 2013-05-02

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-02.parquet
  size:    306 KB
  rows:    10,549

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-05-02 04:00:00	SPY	ETF	158.73	158.73	158.6	158.6	3975.0
2013-05-02 04:30:00	SPY	ETF	158.62	158.62	158.55	158.55	3199.0
2013-05-02 05:00:00	SPY	ETF	158.56	158.56	158.43	158.43	4500.0
2013-05-02 05:30:00	SPY	ETF	158.44	158.5	158.44	158.5	1950.0
2013-05-02 06:00:00	SPY	ETF	158.49	158.65	158.49	158.61	35798.0
2013-05-02 06:30:00	SPY	ETF	158.59	158.67	158.56	158.67	18800.0
2013-05-02 07:00:00	SPY	ETF	158.68	158.74	158.56	158.59	136090.0
2013-05-02 07:30:00	SPY	ETF	158.6	159.0	158.58	158.86	653957.0
2013-05-02 08:00:00	SPY	ETF	158.86	158.94	158.61	158.77	469107.0
2013-05-02 08:30:00	SPY	ETF	158.77	159.35	158.69	158.82	2984231.0
2013-05-02 09:00:00	SPY	ETF	158.83	158.85	158.47	158.67	2091066.0
2013-05-02 09:30:00	SPY	ETF	158.68	159.03	158.53	158.775	13548346.0
2013-05-02 10:00:00	SPY	ETF	158.77	159.27	158.76	159.23	7664722.0
2013-05-02 10:30:00	SPY	ETF	159.23	159.3	159.07	159.19	6585039.0
2013-05-02 11:00:00	SPY	ETF	159.181	159.72	159.16	159.7	8922317.0
2013-05-02 11:30:00	SPY	ETF	159.71	159.78	159.55	159.72	5506262.0
2013-05-02 12:00:00	SPY	ETF	159.71	159.81	159.52	159.55	3974063.0
2013-05-02 12:30:00	SPY	ETF	159.559	159.72	159.52	159.66	2993983.0
2013-05-02 13:00:00	SPY	ETF	159.67	159.87	159.64	159.8	4600034.0
2013-05-02 13:30:00	SPY	ETF	159.8	159.89	159.73	159.825	3668589.0
2013-05-02 14:00:00	SPY	ETF	159.82	159.86	159.67	159.73	6203195.0
2013-05-02 14:30:00	SPY	ETF	159.73	159.88	159.7	159.8	3865847.0
2013-05-02 15:00:00	SPY	ETF	159.79	159.83	159.66	159.78	5125160.0
2013-05-02 15:30:00	SPY	ETF	159.78	159.84	159.65	159.72	9995334.0
2013-05-02 16:00:00	SPY	ETF	159.72	159.8254	159.5045	159.75	4300061.0
2013-05-02 16:30:00	SPY	ETF	159.75	159.78	159.69	159.73	1781533.0
2013-05-02 17:00:00	SPY	ETF	159.73	159.75	159.7	159.75	64827.0
2013-05-02 17:30:00	SPY	ETF	159.75	159.75	159.7	159.75	27925.0
2013-05-02 18:00:00	SPY	ETF	159.72	159.72	159.65	159.66	22122.0
2013-05-02 18:30:00	SPY	ETF	159.66	159.69	159.66	159.68	3090.0
2013-05-02 19:00:00	SPY	ETF	159.66	159.72	159.66	159.69	17602.0
2013-05-02 19:30:00	SPY	ETF	159.73	159.77	159.69	159.7	30932.0
2013-05-02 04:00:00	QQQ	ETF	70.51	70.51	70.45	70.45	5400.0
2013-05-02 04:30:00	QQQ	ETF	70.45	70.45	70.45	70.45	100.0
2013-05-02 06:30:00	QQQ	ETF	70.49	70.49	70.49	70.49	400.0
2013-05-02 07:00:00	QQQ	ETF	70.51	70.52	70.44	70.44	6472.0
2013-05-02 07:30:00	QQQ	ETF	70.48	70.65	70.48	70.61	12750.0
2013-05-02 08:00:00	QQQ	ETF	70.49	70.62	70.49	70.56	40900.0
2013-05-02 08:30:00	QQQ	ETF	70.61	70.84	70.58	70.62	396756.0
2013-05-02 09:00:00	QQQ	ETF	70.63	70.63	70.46	70.51	245043.0
2013-05-02 09:30:00	QQQ	ETF	70.51	70.84	70.45	70.74	3178932.0
2013-05-02 10:00:00	QQQ	ETF	70.74	70.98	70.72	70.94	2225907.0
2013-05-02 10:30:00	QQQ	ETF	70.95	71.03	70.92	71.0075	2383748.0
2013-05-02 11:00:00	QQQ	ETF	71.01	71.23	70.98	71.221	2149687.0
2013-05-02 11:30:00	QQQ	ETF	71.23	71.3	71.19	71.24	2437575.0
2013-05-02 12:00:00	QQQ	ETF	71.2475	71.31	71.155	71.18	951323.0
2013-05-02 12:30:00	QQQ	ETF	71.18	71.3	71.16	71.27	771442.0
2013-05-02 13:00:00	QQQ	ETF	71.28	71.43	71.28	71.39	1769542.0
2013-05-02 13:30:00	QQQ	ETF	71.39	71.43	71.36	71.4	617571.0
2013-05-02 14:00:00	QQQ	ETF	71.39	71.41	71.31	71.35	1033890.0

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

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