PREVIEW / etf_30min / 2017-10-20

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-10-20.parquet
  size:    441 KB
  rows:    15,349

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-20 04:00:00	SPY	ETF	256.44	256.54	256.3	256.3	15697.0
2017-10-20 05:00:00	SPY	ETF	256.23	256.31	256.23	256.28	14705.0
2017-10-20 05:30:00	SPY	ETF	256.38	256.43	256.37	256.43	4000.0
2017-10-20 06:00:00	SPY	ETF	256.45	256.45	256.34	256.44	45605.0
2017-10-20 06:30:00	SPY	ETF	256.39	256.47	256.38	256.45	18579.0
2017-10-20 07:00:00	SPY	ETF	256.4	256.46	256.34	256.4	120155.0
2017-10-20 07:30:00	SPY	ETF	256.41	256.51	256.4	256.45	103181.0
2017-10-20 08:00:00	SPY	ETF	256.39	256.48	256.34	256.38	91312.0
2017-10-20 08:30:00	SPY	ETF	256.36	256.49	256.36	256.44	131889.0
2017-10-20 09:00:00	SPY	ETF	256.47	256.81	256.47	256.69	1037534.0
2017-10-20 09:30:00	SPY	ETF	256.7	256.73	256.42	256.55	15716408.0
2017-10-20 10:00:00	SPY	ETF	256.55	256.75	256.52	256.59	8632054.0
2017-10-20 10:30:00	SPY	ETF	256.59	256.65	256.43	256.45	2696348.0
2017-10-20 11:00:00	SPY	ETF	256.44	256.59	256.44	256.5199	2827717.0
2017-10-20 11:30:00	SPY	ETF	256.52	256.73	256.51	256.69	3470722.0
2017-10-20 12:00:00	SPY	ETF	256.7	256.78	256.64	256.77	2544396.0
2017-10-20 12:30:00	SPY	ETF	256.765	256.83	256.67	256.79	1601354.0
2017-10-20 13:00:00	SPY	ETF	256.79	256.98	256.78	256.95	4098200.0
2017-10-20 13:30:00	SPY	ETF	256.96	257.07	256.9	256.92	3342498.0
2017-10-20 14:00:00	SPY	ETF	256.92	257.12	256.915	257.0862	4488808.0
2017-10-20 14:30:00	SPY	ETF	257.09	257.14	256.92	256.94	2577760.0
2017-10-20 15:00:00	SPY	ETF	256.93	257.03	256.85	256.875	2724421.0
2017-10-20 15:30:00	SPY	ETF	256.88	257.09	256.79	257.08	12300481.0
2017-10-20 16:00:00	SPY	ETF	257.08	257.24	257.07	257.2	14641747.0
2017-10-20 16:30:00	SPY	ETF	257.2	257.22	257.0914	257.16	1886451.0
2017-10-20 17:00:00	SPY	ETF	257.18	257.24	257.1	257.1	103435.0
2017-10-20 17:30:00	SPY	ETF	257.1	257.12	257.06	257.08	64210.0
2017-10-20 18:00:00	SPY	ETF	257.05	257.09	256.97	257.06	25661.0
2017-10-20 18:30:00	SPY	ETF	257.06	257.11	257.06	257.09	10873.0
2017-10-20 19:00:00	SPY	ETF	257.1	257.16	257.1	257.16	6414.0
2017-10-20 19:30:00	SPY	ETF	257.12	257.15	257.12	257.14	12002.0
2017-10-20 04:00:00	QQQ	ETF	148.72	148.87	148.65	148.65	8060.0
2017-10-20 04:30:00	QQQ	ETF	148.65	148.68	148.65	148.65	1951.0
2017-10-20 05:00:00	QQQ	ETF	148.58	148.58	148.58	148.58	500.0
2017-10-20 05:30:00	QQQ	ETF	148.61	148.61	148.61	148.61	400.0
2017-10-20 06:00:00	QQQ	ETF	148.64	148.64	148.63	148.64	825.0
2017-10-20 06:30:00	QQQ	ETF	148.72	148.75	148.72	148.74	1900.0
2017-10-20 07:00:00	QQQ	ETF	148.74	148.79	148.7	148.75	26800.0
2017-10-20 07:30:00	QQQ	ETF	148.74	148.81	148.73	148.81	32783.0
2017-10-20 08:00:00	QQQ	ETF	148.82	148.82	148.66	148.67	41559.0
2017-10-20 08:30:00	QQQ	ETF	148.68	148.78	148.68	148.71	15728.0
2017-10-20 09:00:00	QQQ	ETF	148.74	149.02	148.74	148.93	135388.0
2017-10-20 09:30:00	QQQ	ETF	148.91	148.96	148.76	148.85	2187274.0
2017-10-20 10:00:00	QQQ	ETF	148.8415	149.04	148.77	148.84	1542225.0
2017-10-20 10:30:00	QQQ	ETF	148.84	149.0203	148.58	148.6	1677389.0
2017-10-20 11:00:00	QQQ	ETF	148.6	148.73	148.58	148.68	924380.0
2017-10-20 11:30:00	QQQ	ETF	148.69	148.83	148.685	148.78	580828.0
2017-10-20 12:00:00	QQQ	ETF	148.78	148.9	148.7522	148.9	714360.0
2017-10-20 12:30:00	QQQ	ETF	148.895	148.93	148.79	148.9	678971.0
2017-10-20 13:00:00	QQQ	ETF	148.9	148.95	148.88	148.93	557775.0

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

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