PREVIEW / etf_30min / 2015-04-16

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-04-16.parquet
  size:    384 KB
  rows:    12,787

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
2015-04-16 04:00:00	SPY	ETF	210.32	210.32	210.3	210.32	900.0
2015-04-16 04:30:00	SPY	ETF	210.47	210.49	210.39	210.39	1300.0
2015-04-16 05:00:00	SPY	ETF	210.37	210.43	210.37	210.43	4545.0
2015-04-16 05:30:00	SPY	ETF	210.42	210.42	210.23	210.23	3258.0
2015-04-16 06:00:00	SPY	ETF	210.24	210.25	210.05	210.05	11283.0
2015-04-16 06:30:00	SPY	ETF	210.05	210.05	209.7	209.75	119167.0
2015-04-16 07:00:00	SPY	ETF	209.75	209.78	209.49	209.7	524729.0
2015-04-16 07:30:00	SPY	ETF	209.7	209.76	209.43	209.62	258455.0
2015-04-16 08:00:00	SPY	ETF	209.62	209.83	209.53	209.82	367365.0
2015-04-16 08:30:00	SPY	ETF	209.81	209.82	209.59	209.59	380053.0
2015-04-16 09:00:00	SPY	ETF	209.6	210.05	209.57	210.04	646054.0
2015-04-16 09:30:00	SPY	ETF	210.03	210.25	209.81	210.0	9208365.0
2015-04-16 10:00:00	SPY	ETF	210.0	210.21	209.89	209.935	5282039.0
2015-04-16 10:30:00	SPY	ETF	209.9251	210.4	209.7928	210.22	4804440.0
2015-04-16 11:00:00	SPY	ETF	210.21	210.46	210.1834	210.3	3339143.0
2015-04-16 11:30:00	SPY	ETF	210.31	210.37	210.02	210.2027	3639154.0
2015-04-16 12:00:00	SPY	ETF	210.2	210.45	210.19	210.35	2002780.0
2015-04-16 12:30:00	SPY	ETF	210.355	210.48	210.25	210.36	2203501.0
2015-04-16 13:00:00	SPY	ETF	210.365	210.54	210.28	210.39	2397931.0
2015-04-16 13:30:00	SPY	ETF	210.39	210.97	210.34	210.94	4143365.0
2015-04-16 14:00:00	SPY	ETF	210.945	210.98	210.74	210.84	3572395.0
2015-04-16 14:30:00	SPY	ETF	210.845	210.94	210.65	210.6535	2788907.0
2015-04-16 15:00:00	SPY	ETF	210.66	210.72	210.32	210.37	4224083.0
2015-04-16 15:30:00	SPY	ETF	210.37	210.57	210.24	210.36	12061383.0
2015-04-16 16:00:00	SPY	ETF	210.37	210.62	210.0258	210.57	5705424.0
2015-04-16 16:30:00	SPY	ETF	210.57	210.57	210.46	210.56	283724.0
2015-04-16 17:00:00	SPY	ETF	210.57	210.6	210.53	210.57	155633.0
2015-04-16 17:30:00	SPY	ETF	210.59	210.61	210.57	210.61	47878.0
2015-04-16 18:00:00	SPY	ETF	210.61	210.66	210.61	210.61	47389.0
2015-04-16 18:30:00	SPY	ETF	210.59	210.65	210.57	210.61	21672.0
2015-04-16 19:00:00	SPY	ETF	210.61	210.64	210.6	210.63	14055.0
2015-04-16 19:30:00	SPY	ETF	210.6	210.64	210.59	210.62	23558.0
2015-04-16 05:30:00	QQQ	ETF	107.84	107.84	107.79	107.79	3500.0
2015-04-16 06:00:00	QQQ	ETF	107.76	107.76	107.76	107.76	5600.0
2015-04-16 06:30:00	QQQ	ETF	107.75	107.75	107.62	107.68	19200.0
2015-04-16 07:00:00	QQQ	ETF	107.65	107.65	107.45	107.55	30364.0
2015-04-16 07:30:00	QQQ	ETF	107.54	107.54	107.32	107.44	30533.0
2015-04-16 08:00:00	QQQ	ETF	107.45	107.51	107.44	107.5	51516.0
2015-04-16 08:30:00	QQQ	ETF	107.49	107.51	107.42	107.46	102077.0
2015-04-16 09:00:00	QQQ	ETF	107.46	107.58	107.45	107.55	113962.0
2015-04-16 09:30:00	QQQ	ETF	107.55	107.84	107.47	107.6832	2899503.0
2015-04-16 10:00:00	QQQ	ETF	107.68	107.79	107.46	107.5	1597185.0
2015-04-16 10:30:00	QQQ	ETF	107.5	107.7399	107.4	107.62	1611518.0
2015-04-16 11:00:00	QQQ	ETF	107.62	107.74	107.59	107.68	646470.0
2015-04-16 11:30:00	QQQ	ETF	107.68	107.73	107.54	107.65	742115.0
2015-04-16 12:00:00	QQQ	ETF	107.66	107.73	107.6299	107.66	378023.0
2015-04-16 12:30:00	QQQ	ETF	107.67	107.735	107.6	107.65	479892.0
2015-04-16 13:00:00	QQQ	ETF	107.65	107.72	107.58	107.605	409927.0
2015-04-16 13:30:00	QQQ	ETF	107.6	107.87	107.56	107.83	909700.0
2015-04-16 14:00:00	QQQ	ETF	107.845	107.88	107.77	107.832	632692.0

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

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