PREVIEW / etf_30min / 2016-10-06

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-10-06.parquet
  size:    392 KB
  rows:    13,457

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
2016-10-06 04:00:00	SPY	ETF	215.74	215.74	215.58	215.73	10210.0
2016-10-06 04:30:00	SPY	ETF	215.73	215.78	215.68	215.78	2400.0
2016-10-06 05:00:00	SPY	ETF	215.73	215.78	215.58	215.58	5300.0
2016-10-06 05:30:00	SPY	ETF	215.5	215.54	215.23	215.23	5493.0
2016-10-06 06:00:00	SPY	ETF	215.16	215.26	215.1	215.13	14488.0
2016-10-06 06:30:00	SPY	ETF	215.26	215.29	215.21	215.27	7991.0
2016-10-06 07:00:00	SPY	ETF	215.27	215.36	215.21	215.34	116310.0
2016-10-06 07:30:00	SPY	ETF	215.32	215.5	215.31	215.41	184513.0
2016-10-06 08:00:00	SPY	ETF	215.24	215.4	215.15	215.25	419181.0
2016-10-06 08:30:00	SPY	ETF	215.25	215.47	215.25	215.45	151081.0
2016-10-06 09:00:00	SPY	ETF	215.45	215.46	215.28	215.38	464702.0
2016-10-06 09:30:00	SPY	ETF	215.37	215.55	214.86	215.05	7576048.0
2016-10-06 10:00:00	SPY	ETF	215.05	215.22	215.0	215.15	5069117.0
2016-10-06 10:30:00	SPY	ETF	215.15	215.2	214.94	215.12	3346580.0
2016-10-06 11:00:00	SPY	ETF	215.12	215.27	214.735	215.26	4499779.0
2016-10-06 11:30:00	SPY	ETF	215.26	215.9	215.11	215.67	6868765.0
2016-10-06 12:00:00	SPY	ETF	215.675	216.04	215.66	215.83	3998958.0
2016-10-06 12:30:00	SPY	ETF	215.82	215.94	215.73	215.79	1807148.0
2016-10-06 13:00:00	SPY	ETF	215.79	215.85	215.7	215.81	1748279.0
2016-10-06 13:30:00	SPY	ETF	215.8	215.94	215.7	215.79	2034447.0
2016-10-06 14:00:00	SPY	ETF	215.7908	215.97	215.7808	215.9	2224387.0
2016-10-06 14:30:00	SPY	ETF	215.905	215.97	215.75	215.78	2559945.0
2016-10-06 15:00:00	SPY	ETF	215.79	215.95	215.7	215.723	3424155.0
2016-10-06 15:30:00	SPY	ETF	215.72	215.88	215.64	215.83	7157644.0
2016-10-06 16:00:00	SPY	ETF	215.82	216.09	215.78	215.96	3610324.0
2016-10-06 16:30:00	SPY	ETF	215.97	215.98	215.78	215.93	496364.0
2016-10-06 17:00:00	SPY	ETF	215.9	215.92	215.85	215.86	56632.0
2016-10-06 17:30:00	SPY	ETF	215.85	215.88	215.84	215.88	56470.0
2016-10-06 18:00:00	SPY	ETF	215.89	215.96	215.86	215.86	41209.0
2016-10-06 18:30:00	SPY	ETF	215.86	215.91	215.84	215.87	65510.0
2016-10-06 19:00:00	SPY	ETF	215.85	215.85	215.55	215.66	230112.0
2016-10-06 19:30:00	SPY	ETF	215.65	215.68	215.62	215.62	39667.0
2016-10-06 05:30:00	QQQ	ETF	118.75	118.75	118.6	118.6	6235.0
2016-10-06 06:00:00	QQQ	ETF	118.57	118.57	118.57	118.57	5000.0
2016-10-06 06:30:00	QQQ	ETF	118.63	118.63	118.63	118.63	149.0
2016-10-06 07:00:00	QQQ	ETF	118.62	118.66	118.59	118.66	4700.0
2016-10-06 07:30:00	QQQ	ETF	118.73	118.73	118.64	118.67	19451.0
2016-10-06 08:00:00	QQQ	ETF	118.66	118.67	118.57	118.6	104233.0
2016-10-06 08:30:00	QQQ	ETF	118.61	118.68	118.59	118.68	18648.0
2016-10-06 09:00:00	QQQ	ETF	118.68	118.68	118.6	118.64	167602.0
2016-10-06 09:30:00	QQQ	ETF	118.63	118.74	118.32	118.45	1723969.0
2016-10-06 10:00:00	QQQ	ETF	118.44	118.54	118.39	118.5	974483.0
2016-10-06 10:30:00	QQQ	ETF	118.5	118.55	118.36	118.53	621928.0
2016-10-06 11:00:00	QQQ	ETF	118.52	118.53	118.15	118.45	1441841.0
2016-10-06 11:30:00	QQQ	ETF	118.46	118.95	118.425	118.83	1532623.0
2016-10-06 12:00:00	QQQ	ETF	118.84	118.981	118.77	118.84	599026.0
2016-10-06 12:30:00	QQQ	ETF	118.84	118.88	118.73	118.78	396794.0
2016-10-06 13:00:00	QQQ	ETF	118.77	118.8	118.71	118.789	306624.0
2016-10-06 13:30:00	QQQ	ETF	118.789	118.83	118.69	118.71	302608.0
2016-10-06 14:00:00	QQQ	ETF	118.71	118.88	118.7	118.81	511273.0

> showing 50 of 13,457 rows — these rows as CSV

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