PREVIEW / etf_30min / 2017-08-28

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-08-28.parquet
  size:    429 KB
  rows:    14,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
2017-08-28 04:00:00	SPY	ETF	244.38	244.43	244.3	244.3	600.0
2017-08-28 04:30:00	SPY	ETF	244.27	244.28	244.23	244.23	10600.0
2017-08-28 05:00:00	SPY	ETF	244.26	244.3	244.26	244.3	1205.0
2017-08-28 05:30:00	SPY	ETF	244.39	244.47	244.39	244.46	1206.0
2017-08-28 06:00:00	SPY	ETF	244.43	244.43	244.35	244.43	5104.0
2017-08-28 06:30:00	SPY	ETF	244.49	244.5	244.49	244.49	12001.0
2017-08-28 07:00:00	SPY	ETF	244.47	244.7	244.47	244.67	88757.0
2017-08-28 07:30:00	SPY	ETF	244.67	244.71	244.64	244.71	45075.0
2017-08-28 08:00:00	SPY	ETF	244.7	244.92	244.68	244.86	101141.0
2017-08-28 08:30:00	SPY	ETF	244.89	245.0	244.89	245.0	228424.0
2017-08-28 09:00:00	SPY	ETF	245.0	245.15	245.0	245.14	232146.0
2017-08-28 09:30:00	SPY	ETF	245.17	245.2	244.58	244.64	3506586.0
2017-08-28 10:00:00	SPY	ETF	244.63	244.73	244.4101	244.47	2688632.0
2017-08-28 10:30:00	SPY	ETF	244.47	244.79	244.34	244.74	2026246.0
2017-08-28 11:00:00	SPY	ETF	244.76	244.832	244.52	244.62	1600541.0
2017-08-28 11:30:00	SPY	ETF	244.62	244.68	244.4	244.6	1373373.0
2017-08-28 12:00:00	SPY	ETF	244.6	244.6	244.17	244.23	2022118.0
2017-08-28 12:30:00	SPY	ETF	244.23	244.3	244.09	244.2599	1798032.0
2017-08-28 13:00:00	SPY	ETF	244.25	244.3957	244.23	244.2936	1036820.0
2017-08-28 13:30:00	SPY	ETF	244.29	244.49	244.22	244.451	1002559.0
2017-08-28 14:00:00	SPY	ETF	244.4591	244.51	244.32	244.3842	1336329.0
2017-08-28 14:30:00	SPY	ETF	244.395	244.495	244.29	244.41	1203194.0
2017-08-28 15:00:00	SPY	ETF	244.41	244.49	244.28	244.44	2647705.0
2017-08-28 15:30:00	SPY	ETF	244.44	244.61	244.395	244.59	5770817.0
2017-08-28 16:00:00	SPY	ETF	244.6	244.72	244.57	244.63	5749458.0
2017-08-28 16:30:00	SPY	ETF	244.63	244.75	244.57	244.72	227876.0
2017-08-28 17:00:00	SPY	ETF	244.69	244.69	243.3	243.6	1493348.0
2017-08-28 17:30:00	SPY	ETF	243.55	243.6	242.9	243.41	936100.0
2017-08-28 18:00:00	SPY	ETF	243.45	243.7	242.65	243.08	714952.0
2017-08-28 18:30:00	SPY	ETF	243.04	243.43	242.9	243.36	215897.0
2017-08-28 19:00:00	SPY	ETF	243.35	243.36	243.11	243.28	46115.0
2017-08-28 19:30:00	SPY	ETF	243.28	243.56	243.28	243.35	66089.0
2017-08-28 04:00:00	QQQ	ETF	141.8	141.81	141.65	141.65	15342.0
2017-08-28 04:30:00	QQQ	ETF	141.7	141.7	141.7	141.7	12200.0
2017-08-28 05:00:00	QQQ	ETF	141.7	141.72	141.7	141.72	6800.0
2017-08-28 05:30:00	QQQ	ETF	141.7	141.81	141.7	141.77	3699.0
2017-08-28 06:00:00	QQQ	ETF	141.86	141.86	141.82	141.82	19100.0
2017-08-28 06:30:00	QQQ	ETF	141.91	141.97	141.91	141.97	3600.0
2017-08-28 07:00:00	QQQ	ETF	141.96	142.02	141.93	141.99	7299.0
2017-08-28 07:30:00	QQQ	ETF	141.98	142.05	141.98	142.03	15998.0
2017-08-28 08:00:00	QQQ	ETF	142.0	142.23	141.92	142.2	87879.0
2017-08-28 08:30:00	QQQ	ETF	142.2	142.35	142.2	142.35	136710.0
2017-08-28 09:00:00	QQQ	ETF	142.35	142.43	142.35	142.4	193802.0
2017-08-28 09:30:00	QQQ	ETF	142.41	142.425	142.005	142.06	2515326.0
2017-08-28 10:00:00	QQQ	ETF	142.08	142.45	141.9501	142.29	1255272.0
2017-08-28 10:30:00	QQQ	ETF	142.29	142.74	142.185	142.67	1547729.0
2017-08-28 11:00:00	QQQ	ETF	142.67	142.74	142.51	142.62	847842.0
2017-08-28 11:30:00	QQQ	ETF	142.61	142.63	142.42	142.58	515082.0
2017-08-28 12:00:00	QQQ	ETF	142.58	142.59	142.26	142.26	856526.0
2017-08-28 12:30:00	QQQ	ETF	142.25	142.34	142.09	142.25	912656.0

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

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