PREVIEW / etf_30min / 2016-01-22

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-01-22.parquet
  size:    409 KB
  rows:    13,851

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
2016-01-22 04:00:00	SPY	ETF	188.64	189.71	188.64	189.33	69809.0
2016-01-22 04:30:00	SPY	ETF	189.3	189.3	188.85	189.03	29689.0
2016-01-22 05:00:00	SPY	ETF	188.9	189.25	188.84	189.2	23332.0
2016-01-22 05:30:00	SPY	ETF	189.21	189.42	189.11	189.2	19515.0
2016-01-22 06:00:00	SPY	ETF	189.1	189.31	189.1	189.15	23416.0
2016-01-22 06:30:00	SPY	ETF	189.1	189.4	189.1	189.24	174317.0
2016-01-22 07:00:00	SPY	ETF	189.23	189.34	189.04	189.31	126996.0
2016-01-22 07:30:00	SPY	ETF	189.33	189.59	189.26	189.34	267102.0
2016-01-22 08:00:00	SPY	ETF	189.35	189.58	186.8	189.4	955481.0
2016-01-22 08:30:00	SPY	ETF	189.44	189.62	189.01	189.1	641474.0
2016-01-22 09:00:00	SPY	ETF	189.08	189.85	189.07	189.76	1183789.0
2016-01-22 09:30:00	SPY	ETF	189.78	190.29	189.26	190.24	28370373.0
2016-01-22 10:00:00	SPY	ETF	190.24	190.56	189.98	190.19	17030246.0
2016-01-22 10:30:00	SPY	ETF	190.2	190.46	189.49	189.5	11984946.0
2016-01-22 11:00:00	SPY	ETF	189.5	189.85	189.16	189.68	11127791.0
2016-01-22 11:30:00	SPY	ETF	189.68	189.745	188.88	189.09	8584102.0
2016-01-22 12:00:00	SPY	ETF	189.08	189.78	189.055	189.6	6803730.0
2016-01-22 12:30:00	SPY	ETF	189.6	189.99	189.4	189.9361	5214322.0
2016-01-22 13:00:00	SPY	ETF	189.94	190.18	189.59	189.95	6005524.0
2016-01-22 13:30:00	SPY	ETF	189.96	190.435	189.9	190.41	5609891.0
2016-01-22 14:00:00	SPY	ETF	190.4	190.76	190.23	190.25	9909103.0
2016-01-22 14:30:00	SPY	ETF	190.25	190.36	189.84	190.28	10267350.0
2016-01-22 15:00:00	SPY	ETF	190.285	190.37	189.72	190.18	8210068.0
2016-01-22 15:30:00	SPY	ETF	190.19	190.61	189.89	190.49	20047956.0
2016-01-22 16:00:00	SPY	ETF	190.49	190.57	190.01	190.39	11366438.0
2016-01-22 16:30:00	SPY	ETF	190.39	190.51	190.3	190.45	1480319.0
2016-01-22 17:00:00	SPY	ETF	190.45	190.55	190.43	190.49	63506.0
2016-01-22 17:30:00	SPY	ETF	190.49	190.55	190.47	190.5	27174.0
2016-01-22 18:00:00	SPY	ETF	190.5	190.7	190.49	190.7	81109.0
2016-01-22 18:30:00	SPY	ETF	190.7	190.78	190.67	190.75	47698.0
2016-01-22 19:00:00	SPY	ETF	190.75	190.76	190.67	190.67	13720.0
2016-01-22 19:30:00	SPY	ETF	190.67	190.75	190.65	190.73	45211.0
2016-01-22 04:00:00	QQQ	ETF	102.13	102.81	102.13	102.59	2075.0
2016-01-22 04:30:00	QQQ	ETF	102.48	102.51	102.43	102.43	1750.0
2016-01-22 05:00:00	QQQ	ETF	102.27	102.44	102.25	102.43	6200.0
2016-01-22 05:30:00	QQQ	ETF	102.46	102.46	102.45	102.46	1150.0
2016-01-22 06:00:00	QQQ	ETF	102.4	102.53	102.4	102.48	6150.0
2016-01-22 06:30:00	QQQ	ETF	102.47	102.68	102.45	102.63	28500.0
2016-01-22 07:00:00	QQQ	ETF	102.6	102.73	102.52	102.7	18907.0
2016-01-22 07:30:00	QQQ	ETF	102.71	102.8	102.67	102.69	22700.0
2016-01-22 08:00:00	QQQ	ETF	102.69	102.77	102.58	102.72	100334.0
2016-01-22 08:30:00	QQQ	ETF	102.75	102.82	102.48	102.53	110408.0
2016-01-22 09:00:00	QQQ	ETF	102.55	102.9	102.53	102.83	262871.0
2016-01-22 09:30:00	QQQ	ETF	102.84	103.25	102.5305	103.2	7328304.0
2016-01-22 10:00:00	QQQ	ETF	103.21	103.54	103.1	103.319	4338868.0
2016-01-22 10:30:00	QQQ	ETF	103.32	103.585	103.0	103.03	3751356.0
2016-01-22 11:00:00	QQQ	ETF	103.02	103.29	102.83	103.19	2388032.0
2016-01-22 11:30:00	QQQ	ETF	103.19	103.27	102.75	102.88	1798567.0
2016-01-22 12:00:00	QQQ	ETF	102.86	103.31	102.83	103.22	1660974.0
2016-01-22 12:30:00	QQQ	ETF	103.21	103.42	103.04	103.38	1376036.0

> showing 50 of 13,851 rows — these rows as CSV

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