PREVIEW / etf_30min / 2017-08-14

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-08-14.parquet
  size:    434 KB
  rows:    14,904

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-08-14 04:00:00	SPY	ETF	245.8	245.8	245.44	245.59	27124.0
2017-08-14 04:30:00	SPY	ETF	245.61	245.61	245.54	245.57	3265.0
2017-08-14 05:00:00	SPY	ETF	245.58	245.62	245.51	245.56	8570.0
2017-08-14 05:30:00	SPY	ETF	245.54	245.59	245.49	245.52	24360.0
2017-08-14 06:00:00	SPY	ETF	245.47	245.58	245.45	245.53	28780.0
2017-08-14 06:30:00	SPY	ETF	245.58	245.63	245.54	245.6	32003.0
2017-08-14 07:00:00	SPY	ETF	245.57	245.6	245.48	245.55	45232.0
2017-08-14 07:30:00	SPY	ETF	245.55	245.55	245.34	245.51	312481.0
2017-08-14 08:00:00	SPY	ETF	245.5	245.59	245.41	245.54	363680.0
2017-08-14 08:30:00	SPY	ETF	245.54	245.58	245.44	245.56	111166.0
2017-08-14 09:00:00	SPY	ETF	245.51	245.62	245.36	245.56	665469.0
2017-08-14 09:30:00	SPY	ETF	245.59	246.25	245.55	246.185	8617139.0
2017-08-14 10:00:00	SPY	ETF	246.19	246.37	246.165	246.29	5003390.0
2017-08-14 10:30:00	SPY	ETF	246.28	246.79	246.28	246.65	4589190.0
2017-08-14 11:00:00	SPY	ETF	246.64	246.69	246.46	246.6	3501689.0
2017-08-14 11:30:00	SPY	ETF	246.6	246.71	246.52	246.62	2587621.0
2017-08-14 12:00:00	SPY	ETF	246.62	246.74	246.52	246.5301	1948813.0
2017-08-14 12:30:00	SPY	ETF	246.53	246.61	246.45	246.54	1797499.0
2017-08-14 13:00:00	SPY	ETF	246.53	246.69	246.525	246.59	1628804.0
2017-08-14 13:30:00	SPY	ETF	246.585	246.63	246.47	246.62	2225297.0
2017-08-14 14:00:00	SPY	ETF	246.62	246.69	246.43	246.565	1978023.0
2017-08-14 14:30:00	SPY	ETF	246.5601	246.67	246.245	246.365	4305365.0
2017-08-14 15:00:00	SPY	ETF	246.36	246.7	246.27	246.675	6354412.0
2017-08-14 15:30:00	SPY	ETF	246.68	246.76	246.45	246.52	11660367.0
2017-08-14 16:00:00	SPY	ETF	246.52	246.5531	246.38	246.52	13437781.0
2017-08-14 16:30:00	SPY	ETF	246.51	246.69	246.51	246.63	110798.0
2017-08-14 17:00:00	SPY	ETF	246.62	246.64	246.3805	246.59	80626.0
2017-08-14 17:30:00	SPY	ETF	246.59	246.64	246.59	246.61	58658.0
2017-08-14 18:00:00	SPY	ETF	246.61	246.61	246.43	246.51	66849.0
2017-08-14 18:30:00	SPY	ETF	246.52	246.72	246.52	246.64	35359.0
2017-08-14 19:00:00	SPY	ETF	246.67	246.7	246.66	246.69	5900.0
2017-08-14 19:30:00	SPY	ETF	246.69	246.98	246.68	246.93	57415.0
2017-08-14 04:00:00	QQQ	ETF	143.03	143.13	143.0	143.11	7906.0
2017-08-14 04:30:00	QQQ	ETF	143.13	143.13	143.05	143.09	4171.0
2017-08-14 05:00:00	QQQ	ETF	143.13	143.13	143.13	143.13	100.0
2017-08-14 05:30:00	QQQ	ETF	143.06	143.09	143.05	143.07	13250.0
2017-08-14 06:00:00	QQQ	ETF	143.04	143.1	142.95	143.1	54201.0
2017-08-14 06:30:00	QQQ	ETF	143.0	143.07	143.0	143.05	7408.0
2017-08-14 07:00:00	QQQ	ETF	143.06	143.07	142.95	143.02	38006.0
2017-08-14 07:30:00	QQQ	ETF	142.94	142.97	142.88	142.93	26509.0
2017-08-14 08:00:00	QQQ	ETF	142.94	143.11	142.92	143.1	308640.0
2017-08-14 08:30:00	QQQ	ETF	143.1	143.13	143.02	143.13	37670.0
2017-08-14 09:00:00	QQQ	ETF	143.11	143.24	143.01	143.2	109946.0
2017-08-14 09:30:00	QQQ	ETF	143.23	143.55	143.19	143.47	5550883.0
2017-08-14 10:00:00	QQQ	ETF	143.47	143.77	143.47	143.68	2653103.0
2017-08-14 10:30:00	QQQ	ETF	143.67	144.015	143.67	143.805	2611479.0
2017-08-14 11:00:00	QQQ	ETF	143.8	143.82	143.64	143.74	1046826.0
2017-08-14 11:30:00	QQQ	ETF	143.74	143.82	143.67	143.751	653615.0
2017-08-14 12:00:00	QQQ	ETF	143.76	143.87	143.71	143.74	735574.0
2017-08-14 12:30:00	QQQ	ETF	143.74	143.82	143.655	143.79	789981.0

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

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