PREVIEW / etf_30min / 2017-03-22

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-03-22.parquet
  size:    434 KB
  rows:    14,943

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-03-22 04:00:00	SPY	ETF	233.33	233.76	233.13	233.54	26873.0
2017-03-22 04:30:00	SPY	ETF	233.52	233.52	233.2	233.46	8749.0
2017-03-22 05:00:00	SPY	ETF	233.33	233.6	233.2	233.53	10247.0
2017-03-22 05:30:00	SPY	ETF	233.64	233.9	233.58	233.84	23681.0
2017-03-22 06:00:00	SPY	ETF	233.84	233.88	233.63	233.7	14919.0
2017-03-22 06:30:00	SPY	ETF	233.77	233.88	233.76	233.88	9057.0
2017-03-22 07:00:00	SPY	ETF	233.81	233.95	233.79	233.84	305801.0
2017-03-22 07:30:00	SPY	ETF	233.83	233.86	233.58	233.77	209725.0
2017-03-22 08:00:00	SPY	ETF	233.74	233.97	233.6	233.89	303498.0
2017-03-22 08:30:00	SPY	ETF	233.9	233.91	233.72	233.83	288971.0
2017-03-22 09:00:00	SPY	ETF	233.81	233.85	233.49	233.77	683065.0
2017-03-22 09:30:00	SPY	ETF	233.77	233.965	233.23	233.28	11507830.0
2017-03-22 10:00:00	SPY	ETF	233.27	233.55	233.11	233.34	7374759.0
2017-03-22 10:30:00	SPY	ETF	233.33	233.96	233.05	233.94	11595838.0
2017-03-22 11:00:00	SPY	ETF	233.93	234.555	233.63	234.42	9263147.0
2017-03-22 11:30:00	SPY	ETF	234.42	234.455	234.18	234.265	5405370.0
2017-03-22 12:00:00	SPY	ETF	234.265	234.38	233.83	233.887	4854934.0
2017-03-22 12:30:00	SPY	ETF	233.88	234.0799	233.68	233.89	3206287.0
2017-03-22 13:00:00	SPY	ETF	233.88	234.075	233.42	233.96	6162570.0
2017-03-22 13:30:00	SPY	ETF	233.97	234.22	233.64	233.65	3740189.0
2017-03-22 14:00:00	SPY	ETF	233.655	234.06	233.64	233.78	2580297.0
2017-03-22 14:30:00	SPY	ETF	233.78	234.29	233.765	234.21	3997189.0
2017-03-22 15:00:00	SPY	ETF	234.19	234.61	234.08	234.33	5141365.0
2017-03-22 15:30:00	SPY	ETF	234.3373	234.48	234.12	234.27	10152483.0
2017-03-22 16:00:00	SPY	ETF	234.27	234.28	233.9	234.03	7974487.0
2017-03-22 16:30:00	SPY	ETF	234.03	234.28	233.93	233.97	681956.0
2017-03-22 17:00:00	SPY	ETF	233.95	234.28	233.89	234.0	322609.0
2017-03-22 17:30:00	SPY	ETF	233.99	234.28	233.94	233.97	1030642.0
2017-03-22 18:00:00	SPY	ETF	233.97	234.42	233.97	234.35	141306.0
2017-03-22 18:30:00	SPY	ETF	234.35	234.41	234.32	234.36	13454.0
2017-03-22 19:00:00	SPY	ETF	234.39	234.45	234.38	234.42	29048.0
2017-03-22 19:30:00	SPY	ETF	234.37	234.58	234.37	234.51	40188.0
2017-03-22 04:00:00	QQQ	ETF	129.6	129.77	129.52	129.68	6547.0
2017-03-22 04:30:00	QQQ	ETF	129.63	129.64	129.57	129.61	2799.0
2017-03-22 05:00:00	QQQ	ETF	129.56	129.63	129.5	129.63	1440.0
2017-03-22 05:30:00	QQQ	ETF	129.68	129.77	129.68	129.77	19500.0
2017-03-22 06:00:00	QQQ	ETF	129.8	129.8	129.73	129.75	6150.0
2017-03-22 06:30:00	QQQ	ETF	129.81	129.83	129.81	129.83	1900.0
2017-03-22 07:00:00	QQQ	ETF	129.83	129.88	129.8	129.81	10744.0
2017-03-22 07:30:00	QQQ	ETF	129.81	129.81	129.74	129.81	34825.0
2017-03-22 08:00:00	QQQ	ETF	129.79	129.89	129.77	129.89	20507.0
2017-03-22 08:30:00	QQQ	ETF	129.87	129.87	129.84	129.85	50990.0
2017-03-22 09:00:00	QQQ	ETF	129.87	129.91	129.8	129.9	173085.0
2017-03-22 09:30:00	QQQ	ETF	129.89	130.3	129.82	129.89	3874673.0
2017-03-22 10:00:00	QQQ	ETF	129.89	130.15	129.795	129.87	2397959.0
2017-03-22 10:30:00	QQQ	ETF	129.87	130.32	129.68	130.32	2465891.0
2017-03-22 11:00:00	QQQ	ETF	130.31	130.715	130.14	130.6501	2223619.0
2017-03-22 11:30:00	QQQ	ETF	130.65	130.705	130.51	130.559	818441.0
2017-03-22 12:00:00	QQQ	ETF	130.555	130.6053	130.37	130.39	854079.0
2017-03-22 12:30:00	QQQ	ETF	130.39	130.5047	130.27	130.39	1077203.0

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

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