PREVIEW / etf_30min / 2014-05-19

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-05-19.parquet
  size:    326 KB
  rows:    11,279

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
2014-05-19 04:00:00	SPY	ETF	187.99	187.99	187.39	187.39	3725.0
2014-05-19 04:30:00	SPY	ETF	187.29	187.36	187.23	187.33	8165.0
2014-05-19 05:00:00	SPY	ETF	187.35	187.36	187.3	187.33	3500.0
2014-05-19 05:30:00	SPY	ETF	187.42	187.44	187.19	187.31	39804.0
2014-05-19 06:00:00	SPY	ETF	187.31	187.47	187.3	187.47	67375.0
2014-05-19 06:30:00	SPY	ETF	187.44	187.58	187.42	187.45	58934.0
2014-05-19 07:00:00	SPY	ETF	187.46	187.62	187.45	187.53	249657.0
2014-05-19 07:30:00	SPY	ETF	187.57	187.86	187.57	187.83	208516.0
2014-05-19 08:00:00	SPY	ETF	187.83	188.0	187.45	187.67	572844.0
2014-05-19 08:30:00	SPY	ETF	187.66	187.72	187.55	187.58	287456.0
2014-05-19 09:00:00	SPY	ETF	187.58	187.76	187.57	187.68	758482.0
2014-05-19 09:30:00	SPY	ETF	187.69	188.39	187.52	188.22	9605814.0
2014-05-19 10:00:00	SPY	ETF	188.22	188.47	187.98	188.3501	6309628.0
2014-05-19 10:30:00	SPY	ETF	188.35	188.39	188.21	188.3	4052425.0
2014-05-19 11:00:00	SPY	ETF	188.31	188.77	188.29	188.6501	5810527.0
2014-05-19 11:30:00	SPY	ETF	188.66	188.7	188.57	188.65	2179085.0
2014-05-19 12:00:00	SPY	ETF	188.65	188.78	188.64	188.7	2167839.0
2014-05-19 12:30:00	SPY	ETF	188.6951	188.7	188.45	188.53	2938970.0
2014-05-19 13:00:00	SPY	ETF	188.53	188.64	188.49	188.53	1401013.0
2014-05-19 13:30:00	SPY	ETF	188.52	188.73	188.47	188.665	2306861.0
2014-05-19 14:00:00	SPY	ETF	188.66	188.86	188.62	188.78	2563816.0
2014-05-19 14:30:00	SPY	ETF	188.78	188.8	188.64	188.678	2054578.0
2014-05-19 15:00:00	SPY	ETF	188.678	188.76	188.51	188.6999	2606952.0
2014-05-19 15:30:00	SPY	ETF	188.69	188.89	188.69	188.74	7888985.0
2014-05-19 16:00:00	SPY	ETF	188.74	188.87	188.3	188.82	4687664.0
2014-05-19 16:30:00	SPY	ETF	188.8	188.8	188.0674	188.77	1682688.0
2014-05-19 17:00:00	SPY	ETF	188.75	188.75	188.7	188.71	197372.0
2014-05-19 17:30:00	SPY	ETF	188.7	188.7	188.67	188.7	27790.0
2014-05-19 18:00:00	SPY	ETF	188.7	188.7	188.6	188.6	98096.0
2014-05-19 18:30:00	SPY	ETF	188.62	188.65	188.6	188.6	14251.0
2014-05-19 19:00:00	SPY	ETF	188.63	188.66	188.63	188.65	13600.0
2014-05-19 19:30:00	SPY	ETF	188.63	188.65	188.61	188.61	46855.0
2014-05-19 04:00:00	QQQ	ETF	87.51	87.51	87.3	87.32	1700.0
2014-05-19 04:30:00	QQQ	ETF	87.26	87.26	87.2	87.2	310.0
2014-05-19 05:00:00	QQQ	ETF	87.26	87.26	87.23	87.23	200.0
2014-05-19 05:30:00	QQQ	ETF	87.2	87.2	87.2	87.2	500.0
2014-05-19 06:00:00	QQQ	ETF	87.26	87.27	87.26	87.27	2000.0
2014-05-19 06:30:00	QQQ	ETF	87.33	87.33	87.28	87.28	300.0
2014-05-19 07:00:00	QQQ	ETF	87.35	87.42	87.35	87.42	3300.0
2014-05-19 07:30:00	QQQ	ETF	87.46	87.49	87.44	87.48	9400.0
2014-05-19 08:00:00	QQQ	ETF	87.48	87.51	87.33	87.45	126205.0
2014-05-19 08:30:00	QQQ	ETF	87.46	87.48	87.43	87.45	25725.0
2014-05-19 09:00:00	QQQ	ETF	87.45	87.52	87.38	87.46	161675.0
2014-05-19 09:30:00	QQQ	ETF	87.47	87.9552	87.3	87.8	4716635.0
2014-05-19 10:00:00	QQQ	ETF	87.79	88.075	87.64	87.98	2564121.0
2014-05-19 10:30:00	QQQ	ETF	87.98	88.13	87.89	88.07	1695017.0
2014-05-19 11:00:00	QQQ	ETF	88.08	88.35	88.07	88.27	2433841.0
2014-05-19 11:30:00	QQQ	ETF	88.28	88.347	88.23	88.31	1599927.0
2014-05-19 12:00:00	QQQ	ETF	88.31	88.43	88.29	88.37	1076043.0
2014-05-19 12:30:00	QQQ	ETF	88.379	88.39	88.23	88.2627	1115294.0

> showing 50 of 11,279 rows — these rows as CSV

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