PREVIEW / etf_30min / 2014-10-31

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-10-31.parquet
  size:    383 KB
  rows:    12,951

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-10-31 04:00:00	SPY	ETF	201.15	201.41	199.95	201.16	105730.0
2014-10-31 04:30:00	SPY	ETF	201.18	201.44	201.06	201.43	45529.0
2014-10-31 05:00:00	SPY	ETF	201.43	201.67	201.31	201.57	32997.0
2014-10-31 05:30:00	SPY	ETF	201.57	201.75	201.34	201.75	62765.0
2014-10-31 06:00:00	SPY	ETF	201.72	201.78	201.62	201.68	234013.0
2014-10-31 06:30:00	SPY	ETF	201.68	201.74	201.56	201.65	153106.0
2014-10-31 07:00:00	SPY	ETF	201.57	201.61	201.38	201.49	193611.0
2014-10-31 07:30:00	SPY	ETF	201.46	201.73	201.41	201.64	474191.0
2014-10-31 08:00:00	SPY	ETF	201.45	201.715	201.41	201.63	1080067.0
2014-10-31 08:30:00	SPY	ETF	201.63	201.66	201.26	201.57	2281804.0
2014-10-31 09:00:00	SPY	ETF	201.55	201.93	201.55	201.78	3439116.0
2014-10-31 09:30:00	SPY	ETF	201.78	201.82	200.81	200.99	25353324.0
2014-10-31 10:00:00	SPY	ETF	200.99	201.49	200.77	201.45	15634610.0
2014-10-31 10:30:00	SPY	ETF	201.455	201.53	201.2	201.39	8449745.0
2014-10-31 11:00:00	SPY	ETF	201.38	201.74	201.26	201.7	9111617.0
2014-10-31 11:30:00	SPY	ETF	201.705	201.72	201.24	201.35	5996023.0
2014-10-31 12:00:00	SPY	ETF	201.355	201.37	201.03	201.18	4850068.0
2014-10-31 12:30:00	SPY	ETF	201.18	201.43	201.1	201.409	4049190.0
2014-10-31 13:00:00	SPY	ETF	201.405	201.47	201.3	201.35	3630107.0
2014-10-31 13:30:00	SPY	ETF	201.355	201.4	201.1	201.15	7313426.0
2014-10-31 14:00:00	SPY	ETF	201.15	201.38	201.12	201.29	3609978.0
2014-10-31 14:30:00	SPY	ETF	201.29	201.31	201.05	201.21	5744221.0
2014-10-31 15:00:00	SPY	ETF	201.205	201.35	201.02	201.285	5510251.0
2014-10-31 15:30:00	SPY	ETF	201.285	201.79	201.25	201.66	18838670.0
2014-10-31 16:00:00	SPY	ETF	201.66	201.7702	201.46	201.56	14241976.0
2014-10-31 16:30:00	SPY	ETF	201.54	201.7694	201.46	201.48	2389964.0
2014-10-31 17:00:00	SPY	ETF	201.47	201.51	201.45	201.49	176005.0
2014-10-31 17:30:00	SPY	ETF	201.5	201.66	201.33	201.64	220319.0
2014-10-31 18:00:00	SPY	ETF	201.62	201.64	201.59	201.64	12481.0
2014-10-31 18:30:00	SPY	ETF	201.6	201.62	201.57	201.62	4640.0
2014-10-31 19:00:00	SPY	ETF	201.59	201.6	201.59	201.6	5073.0
2014-10-31 19:30:00	SPY	ETF	201.6	201.62	201.57	201.62	15434.0
2014-10-31 04:00:00	QQQ	ETF	100.44	101.68	100.44	101.17	72486.0
2014-10-31 04:30:00	QQQ	ETF	101.15	101.4	101.15	101.35	22080.0
2014-10-31 05:00:00	QQQ	ETF	101.41	101.5	101.35	101.48	6660.0
2014-10-31 05:30:00	QQQ	ETF	101.43	101.46	101.3	101.46	25141.0
2014-10-31 06:00:00	QQQ	ETF	101.44	101.51	101.42	101.47	25350.0
2014-10-31 06:30:00	QQQ	ETF	101.41	101.49	101.38	101.4	36300.0
2014-10-31 07:00:00	QQQ	ETF	101.4	101.4	101.31	101.34	61761.0
2014-10-31 07:30:00	QQQ	ETF	101.36	101.46	101.31	101.4	58630.0
2014-10-31 08:00:00	QQQ	ETF	101.41	101.46	101.32	101.45	332715.0
2014-10-31 08:30:00	QQQ	ETF	101.45	101.47	101.35	101.47	2490409.0
2014-10-31 09:00:00	QQQ	ETF	101.47	101.74	101.46	101.67	1611927.0
2014-10-31 09:30:00	QQQ	ETF	101.67	101.75	101.23	101.31	6732784.0
2014-10-31 10:00:00	QQQ	ETF	101.31	101.47	101.105	101.44	3819458.0
2014-10-31 10:30:00	QQQ	ETF	101.44	101.48	101.25	101.33	1705110.0
2014-10-31 11:00:00	QQQ	ETF	101.32	101.525	101.25	101.5001	2102172.0
2014-10-31 11:30:00	QQQ	ETF	101.5	101.505	101.2	101.24	2839553.0
2014-10-31 12:00:00	QQQ	ETF	101.24	101.275	101.145	101.22	1333758.0
2014-10-31 12:30:00	QQQ	ETF	101.21	101.38	101.19	101.36	1442500.0

> showing 50 of 12,951 rows — these rows as CSV

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