PREVIEW / etf_30min / 2017-07-28

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-07-28.parquet
  size:    421 KB
  rows:    14,574

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-07-28 04:00:00	SPY	ETF	246.67	247.18	246.59	246.59	1702.0
2017-07-28 04:30:00	SPY	ETF	246.56	246.56	246.44	246.45	15620.0
2017-07-28 05:00:00	SPY	ETF	246.44	246.45	246.27	246.35	79576.0
2017-07-28 05:30:00	SPY	ETF	246.4	246.47	246.38	246.38	3010.0
2017-07-28 06:00:00	SPY	ETF	246.3	246.3	246.18	246.23	9937.0
2017-07-28 06:30:00	SPY	ETF	246.26	246.42	246.05	246.4	71232.0
2017-07-28 07:00:00	SPY	ETF	246.43	246.7	246.4	246.46	42947.0
2017-07-28 07:30:00	SPY	ETF	246.48	246.56	246.44	246.56	41106.0
2017-07-28 08:00:00	SPY	ETF	246.54	246.57	246.48	246.55	117649.0
2017-07-28 08:30:00	SPY	ETF	246.56	246.7	246.49	246.64	417581.0
2017-07-28 09:00:00	SPY	ETF	246.64	246.66	246.52	246.64	436710.0
2017-07-28 09:30:00	SPY	ETF	246.65	246.87	246.43	246.489	6698009.0
2017-07-28 10:00:00	SPY	ETF	246.49	246.62	246.29	246.35	4783798.0
2017-07-28 10:30:00	SPY	ETF	246.36	246.47	246.2	246.35	3153175.0
2017-07-28 11:00:00	SPY	ETF	246.355	246.6185	246.13	246.46	3304060.0
2017-07-28 11:30:00	SPY	ETF	246.45	246.705	246.43	246.67	1761649.0
2017-07-28 12:00:00	SPY	ETF	246.67	246.78	246.62	246.68	1238540.0
2017-07-28 12:30:00	SPY	ETF	246.675	246.75	246.605	246.66	1153143.0
2017-07-28 13:00:00	SPY	ETF	246.66	246.68	246.56	246.625	1375149.0
2017-07-28 13:30:00	SPY	ETF	246.62	246.75	246.595	246.64	1396630.0
2017-07-28 14:00:00	SPY	ETF	246.65	246.76	246.59	246.71	1506636.0
2017-07-28 14:30:00	SPY	ETF	246.71	246.87	246.67	246.8225	1961325.0
2017-07-28 15:00:00	SPY	ETF	246.83	246.88	246.68	246.76	3524960.0
2017-07-28 15:30:00	SPY	ETF	246.75	247.06	246.74	246.9	7439236.0
2017-07-28 16:00:00	SPY	ETF	246.9	247.04	246.89	247.01	6243393.0
2017-07-28 16:30:00	SPY	ETF	247.01	247.08	246.7019	247.0	1019705.0
2017-07-28 17:00:00	SPY	ETF	246.99	247.0	246.91	246.99	1381129.0
2017-07-28 17:30:00	SPY	ETF	247.01	247.05	246.97	247.02	50546.0
2017-07-28 18:00:00	SPY	ETF	247.02	247.02	246.99	247.0	12700.0
2017-07-28 18:30:00	SPY	ETF	247.0	247.08	247.0	247.04	21893.0
2017-07-28 19:00:00	SPY	ETF	247.04	247.07	247.04	247.07	6030.0
2017-07-28 19:30:00	SPY	ETF	247.07	247.07	247.04	247.07	12440.0
2017-07-28 04:00:00	QQQ	ETF	142.89	142.89	142.75	142.75	5300.0
2017-07-28 04:30:00	QQQ	ETF	142.71	142.71	142.57	142.64	10671.0
2017-07-28 05:00:00	QQQ	ETF	142.64	142.64	142.47	142.54	4233.0
2017-07-28 05:30:00	QQQ	ETF	142.56	142.6	142.55	142.6	1370.0
2017-07-28 06:00:00	QQQ	ETF	142.48	142.59	142.46	142.59	23702.0
2017-07-28 06:30:00	QQQ	ETF	142.58	142.77	142.5	142.7	21300.0
2017-07-28 07:00:00	QQQ	ETF	142.79	143.09	142.69	143.0	41474.0
2017-07-28 07:30:00	QQQ	ETF	143.02	143.16	142.92	143.03	27722.0
2017-07-28 08:00:00	QQQ	ETF	143.05	143.05	142.63	142.76	595151.0
2017-07-28 08:30:00	QQQ	ETF	142.74	143.17	142.72	143.16	239118.0
2017-07-28 09:00:00	QQQ	ETF	143.19	143.23	142.97	143.13	331913.0
2017-07-28 09:30:00	QQQ	ETF	143.15	143.77	142.87	143.35	6087995.0
2017-07-28 10:00:00	QQQ	ETF	143.35	143.65	143.24	143.38	2935856.0
2017-07-28 10:30:00	QQQ	ETF	143.38	143.52	143.18	143.29	3982565.0
2017-07-28 11:00:00	QQQ	ETF	143.29	143.63	143.24	143.54	2640859.0
2017-07-28 11:30:00	QQQ	ETF	143.54	143.73	143.5099	143.72	850968.0
2017-07-28 12:00:00	QQQ	ETF	143.73	143.87	143.69	143.85	1009495.0
2017-07-28 12:30:00	QQQ	ETF	143.85	144.0752	143.85	143.99	1365764.0

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

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