PREVIEW / etf_30min / 2017-01-12

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-01-12.parquet
  size:    434 KB
  rows:    14,753

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
2017-01-12 04:00:00	SPY	ETF	226.3	226.45	226.12	226.45	3975.0
2017-01-12 04:30:00	SPY	ETF	226.37	226.47	226.37	226.45	8010.0
2017-01-12 05:00:00	SPY	ETF	226.43	226.54	226.39	226.52	3410.0
2017-01-12 05:30:00	SPY	ETF	226.49	226.52	226.41	226.41	2999.0
2017-01-12 06:00:00	SPY	ETF	226.44	226.52	226.41	226.52	2204.0
2017-01-12 06:30:00	SPY	ETF	226.51	226.58	226.49	226.51	94583.0
2017-01-12 07:00:00	SPY	ETF	226.48	226.52	226.41	226.41	63744.0
2017-01-12 07:30:00	SPY	ETF	226.44	226.63	226.44	226.61	55219.0
2017-01-12 08:00:00	SPY	ETF	226.58	226.66	226.45	226.53	203347.0
2017-01-12 08:30:00	SPY	ETF	226.54	226.66	226.5	226.56	118698.0
2017-01-12 09:00:00	SPY	ETF	226.6	226.65	226.41	226.51	300643.0
2017-01-12 09:30:00	SPY	ETF	226.5	226.58	225.87	226.02	8965082.0
2017-01-12 10:00:00	SPY	ETF	226.01	226.06	225.18	225.48	8839756.0
2017-01-12 10:30:00	SPY	ETF	225.48	226.5	225.17	225.25	5153332.0
2017-01-12 11:00:00	SPY	ETF	225.24	225.49	224.955	225.46	5492023.0
2017-01-12 11:30:00	SPY	ETF	225.46	225.51	225.23	225.33	4176190.0
2017-01-12 12:00:00	SPY	ETF	225.31	225.93	225.305	225.84	3902269.0
2017-01-12 12:30:00	SPY	ETF	225.84	226.08	225.8	225.965	3958403.0
2017-01-12 13:00:00	SPY	ETF	225.96	226.21	225.88	226.08	3652917.0
2017-01-12 13:30:00	SPY	ETF	226.07	226.39	226.04	226.26	3301185.0
2017-01-12 14:00:00	SPY	ETF	226.26	226.4443	226.17	226.37	2728613.0
2017-01-12 14:30:00	SPY	ETF	226.38	226.64	226.35	226.5879	3648362.0
2017-01-12 15:00:00	SPY	ETF	226.58	226.6	226.29	226.39	3518361.0
2017-01-12 15:30:00	SPY	ETF	226.4	226.75	226.39	226.57	8884015.0
2017-01-12 16:00:00	SPY	ETF	226.56	226.5956	226.39	226.47	3270555.0
2017-01-12 16:30:00	SPY	ETF	226.46	226.53	226.43	226.52	142044.0
2017-01-12 17:00:00	SPY	ETF	226.49	226.54	226.48	226.51	123418.0
2017-01-12 17:30:00	SPY	ETF	226.51	226.54	226.51	226.51	10901.0
2017-01-12 18:00:00	SPY	ETF	226.5	226.63	226.5	226.63	35719.0
2017-01-12 18:30:00	SPY	ETF	226.6	226.63	226.6	226.6	4201.0
2017-01-12 19:00:00	SPY	ETF	226.57	226.58	226.54	226.58	14904.0
2017-01-12 19:30:00	SPY	ETF	226.54	226.57	226.49	226.56	18828.0
2017-01-12 04:00:00	QQQ	ETF	122.63	122.64	122.63	122.64	3400.0
2017-01-12 04:30:00	QQQ	ETF	122.59	122.63	122.59	122.63	1100.0
2017-01-12 05:00:00	QQQ	ETF	122.63	122.63	122.63	122.63	100.0
2017-01-12 05:30:00	QQQ	ETF	122.63	122.63	122.63	122.63	268.0
2017-01-12 06:00:00	QQQ	ETF	122.6	122.65	122.59	122.65	3200.0
2017-01-12 06:30:00	QQQ	ETF	122.67	122.69	122.64	122.64	6800.0
2017-01-12 07:00:00	QQQ	ETF	122.63	122.63	122.55	122.55	11700.0
2017-01-12 07:30:00	QQQ	ETF	122.55	122.64	122.55	122.64	7899.0
2017-01-12 08:00:00	QQQ	ETF	122.62	122.65	122.59	122.6	13332.0
2017-01-12 08:30:00	QQQ	ETF	122.59	122.64	122.57	122.59	13447.0
2017-01-12 09:00:00	QQQ	ETF	122.58	122.59	122.43	122.48	80313.0
2017-01-12 09:30:00	QQQ	ETF	122.48	122.535	122.1	122.25	2282578.0
2017-01-12 10:00:00	QQQ	ETF	122.25	122.31	121.7	121.905	3464238.0
2017-01-12 10:30:00	QQQ	ETF	121.905	122.0	121.71	121.76	1304436.0
2017-01-12 11:00:00	QQQ	ETF	121.76	121.9695	121.6	121.95	1323031.0
2017-01-12 11:30:00	QQQ	ETF	121.96	122.08	121.9	122.02	1025186.0
2017-01-12 12:00:00	QQQ	ETF	122.02	122.285	122.0	122.225	858894.0
2017-01-12 12:30:00	QQQ	ETF	122.23	122.385	122.23	122.32	809698.0

> showing 50 of 14,753 rows — these rows as CSV

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