PREVIEW / etf_30min / 2017-10-05

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-10-05.parquet
  size:    439 KB
  rows:    15,085

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-10-05 04:00:00	SPY	ETF	253.26	253.32	253.26	253.31	5200.0
2017-10-05 04:30:00	SPY	ETF	253.33	253.34	253.32	253.32	9830.0
2017-10-05 05:00:00	SPY	ETF	253.29	253.31	253.24	253.24	9850.0
2017-10-05 05:30:00	SPY	ETF	253.24	253.24	253.24	253.24	1100.0
2017-10-05 06:00:00	SPY	ETF	253.31	253.31	253.31	253.31	700.0
2017-10-05 06:30:00	SPY	ETF	253.29	253.31	253.29	253.31	1300.0
2017-10-05 07:00:00	SPY	ETF	253.33	253.38	253.32	253.34	30310.0
2017-10-05 07:30:00	SPY	ETF	253.34	253.44	253.34	253.42	28612.0
2017-10-05 08:00:00	SPY	ETF	253.35	253.62	253.35	253.6	162022.0
2017-10-05 08:30:00	SPY	ETF	253.58	253.64	253.45	253.46	167573.0
2017-10-05 09:00:00	SPY	ETF	253.51	253.56	253.43	253.52	211345.0
2017-10-05 09:30:00	SPY	ETF	253.54	253.8	253.4	253.6	5403716.0
2017-10-05 10:00:00	SPY	ETF	253.6	253.795	253.59	253.7	2470029.0
2017-10-05 10:30:00	SPY	ETF	253.7	253.86	253.61	253.765	2495078.0
2017-10-05 11:00:00	SPY	ETF	253.765	253.94	253.74	253.91	3814688.0
2017-10-05 11:30:00	SPY	ETF	253.91	254.26	253.88	254.245	3635663.0
2017-10-05 12:00:00	SPY	ETF	254.24	254.61	254.23	254.49	3603887.0
2017-10-05 12:30:00	SPY	ETF	254.49	254.54	254.37	254.41	3384697.0
2017-10-05 13:00:00	SPY	ETF	254.4	254.61	254.4	254.58	3530417.0
2017-10-05 13:30:00	SPY	ETF	254.575	254.59	254.435	254.515	2832690.0
2017-10-05 14:00:00	SPY	ETF	254.51	254.52	254.41	254.42	2750131.0
2017-10-05 14:30:00	SPY	ETF	254.42	254.59	254.4	254.56	4453088.0
2017-10-05 15:00:00	SPY	ETF	254.56	254.68	254.5	254.51	6267020.0
2017-10-05 15:30:00	SPY	ETF	254.51	254.65	254.46	254.64	9311047.0
2017-10-05 16:00:00	SPY	ETF	254.64	254.75	254.1843	254.65	6455544.0
2017-10-05 16:30:00	SPY	ETF	254.66	254.71	254.59	254.59	224275.0
2017-10-05 17:00:00	SPY	ETF	254.64	254.65	254.6	254.63	17531.0
2017-10-05 17:30:00	SPY	ETF	254.63	254.66	254.63	254.63	39037.0
2017-10-05 18:00:00	SPY	ETF	254.61	254.62	254.54	254.57	71954.0
2017-10-05 18:30:00	SPY	ETF	254.59	254.61	254.56	254.59	22357.0
2017-10-05 19:00:00	SPY	ETF	254.58	254.624	254.55	254.6	220110.0
2017-10-05 19:30:00	SPY	ETF	254.59	254.6	254.56	254.58	50400.0
2017-10-05 04:00:00	QQQ	ETF	146.11	146.16	146.11	146.16	300.0
2017-10-05 04:30:00	QQQ	ETF	146.14	146.14	146.14	146.14	10000.0
2017-10-05 05:30:00	QQQ	ETF	146.11	146.11	146.08	146.08	40151.0
2017-10-05 06:00:00	QQQ	ETF	146.17	146.17	146.17	146.17	800.0
2017-10-05 06:30:00	QQQ	ETF	146.18	146.18	146.18	146.18	100.0
2017-10-05 07:00:00	QQQ	ETF	146.17	146.25	146.17	146.25	5700.0
2017-10-05 07:30:00	QQQ	ETF	146.23	146.39	146.22	146.38	12020.0
2017-10-05 08:00:00	QQQ	ETF	146.39	146.67	146.16	146.62	62221.0
2017-10-05 08:30:00	QQQ	ETF	146.62	146.63	146.52	146.55	42082.0
2017-10-05 09:00:00	QQQ	ETF	146.59	146.6	146.53	146.55	32569.0
2017-10-05 09:30:00	QQQ	ETF	146.56	146.94	146.45	146.495	3853262.0
2017-10-05 10:00:00	QQQ	ETF	146.5	146.74	146.47	146.55	962244.0
2017-10-05 10:30:00	QQQ	ETF	146.56	146.64	146.4063	146.49	939545.0
2017-10-05 11:00:00	QQQ	ETF	146.4901	146.74	146.43	146.71	1031537.0
2017-10-05 11:30:00	QQQ	ETF	146.71	146.84	146.67	146.747	975679.0
2017-10-05 12:00:00	QQQ	ETF	146.74	147.16	146.72	147.09	1652801.0
2017-10-05 12:30:00	QQQ	ETF	147.1	147.16	147.0275	147.05	1152391.0
2017-10-05 13:00:00	QQQ	ETF	147.05	147.21	147.0234	147.21	833879.0

> showing 50 of 15,085 rows — these rows as CSV

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