PREVIEW / etf_30min / 2016-12-15

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-12-15.parquet
  size:    449 KB
  rows:    15,319

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-12-15 04:00:00	SPY	ETF	226.25	226.48	226.22	226.43	9223.0
2016-12-15 04:30:00	SPY	ETF	226.32	226.33	226.18	226.18	3272.0
2016-12-15 05:00:00	SPY	ETF	226.29	226.74	226.27	226.65	13867.0
2016-12-15 05:30:00	SPY	ETF	226.6	226.68	226.59	226.65	3125.0
2016-12-15 06:00:00	SPY	ETF	226.68	226.75	226.64	226.75	98193.0
2016-12-15 06:30:00	SPY	ETF	226.62	226.63	226.2	226.2	37499.0
2016-12-15 07:00:00	SPY	ETF	226.26	226.26	226.03	226.04	125542.0
2016-12-15 07:30:00	SPY	ETF	226.07	226.29	226.04	226.08	156311.0
2016-12-15 08:00:00	SPY	ETF	226.24	226.42	225.78	225.92	427900.0
2016-12-15 08:30:00	SPY	ETF	225.98	226.37	225.91	226.22	391192.0
2016-12-15 09:00:00	SPY	ETF	226.24	226.51	226.12	226.14	493743.0
2016-12-15 09:30:00	SPY	ETF	226.16	227.24	226.01	227.15	11068573.0
2016-12-15 10:00:00	SPY	ETF	227.14	227.46	226.91	227.0301	12137201.0
2016-12-15 10:30:00	SPY	ETF	227.04	227.415	227.02	227.2166	8573843.0
2016-12-15 11:00:00	SPY	ETF	227.21	227.81	227.2	227.44	8887332.0
2016-12-15 11:30:00	SPY	ETF	227.44	227.6	227.17	227.37	4951176.0
2016-12-15 12:00:00	SPY	ETF	227.37	227.45	227.09	227.31	6624396.0
2016-12-15 12:30:00	SPY	ETF	227.32	227.38	226.99	227.2	5505181.0
2016-12-15 13:00:00	SPY	ETF	227.2	227.45	227.13	227.26	3115719.0
2016-12-15 13:30:00	SPY	ETF	227.27	227.34	226.34	226.4892	6299921.0
2016-12-15 14:00:00	SPY	ETF	226.495	226.88	226.37	226.88	5463961.0
2016-12-15 14:30:00	SPY	ETF	226.87	227.03	226.77	226.7901	4292512.0
2016-12-15 15:00:00	SPY	ETF	226.795	226.97	226.67	226.7	5530167.0
2016-12-15 15:30:00	SPY	ETF	226.71	227.05	226.63	226.77	17562070.0
2016-12-15 16:00:00	SPY	ETF	226.78	227.02	226.74	226.9	10833503.0
2016-12-15 16:30:00	SPY	ETF	226.89	227.04	226.773	226.96	1954861.0
2016-12-15 17:00:00	SPY	ETF	226.98	227.0	226.81	226.96	1424443.0
2016-12-15 17:30:00	SPY	ETF	226.81	226.98	226.81	226.93	1065370.0
2016-12-15 18:00:00	SPY	ETF	226.93	227.05	226.81	227.05	344543.0
2016-12-15 18:30:00	SPY	ETF	227.05	227.14	226.98	227.03	80092.0
2016-12-15 19:00:00	SPY	ETF	227.02	227.03	226.92	226.92	29944.0
2016-12-15 19:30:00	SPY	ETF	226.93	226.93	226.83	226.86	49447.0
2016-12-15 04:30:00	QQQ	ETF	120.29	120.29	120.29	120.29	500.0
2016-12-15 05:00:00	QQQ	ETF	120.3	120.52	120.3	120.5	1642.0
2016-12-15 05:30:00	QQQ	ETF	120.5	120.54	120.5	120.51	27500.0
2016-12-15 06:00:00	QQQ	ETF	120.55	120.6	120.55	120.6	25100.0
2016-12-15 07:00:00	QQQ	ETF	120.29	120.29	120.15	120.16	15747.0
2016-12-15 07:30:00	QQQ	ETF	120.2	120.25	120.18	120.19	10500.0
2016-12-15 08:00:00	QQQ	ETF	120.21	120.21	120.04	120.14	65788.0
2016-12-15 08:30:00	QQQ	ETF	120.17	120.35	120.17	120.35	29270.0
2016-12-15 09:00:00	QQQ	ETF	120.33	120.45	120.3	120.33	44611.0
2016-12-15 09:30:00	QQQ	ETF	120.37	120.75	120.18	120.73	2598876.0
2016-12-15 10:00:00	QQQ	ETF	120.73	120.83	120.47	120.59	1686179.0
2016-12-15 10:30:00	QQQ	ETF	120.58	120.7973	120.48	120.5865	953518.0
2016-12-15 11:00:00	QQQ	ETF	120.58	121.11	120.58	120.95	1592443.0
2016-12-15 11:30:00	QQQ	ETF	120.95	121.026	120.675	120.7824	965872.0
2016-12-15 12:00:00	QQQ	ETF	120.78	120.88	120.64	120.81	628620.0
2016-12-15 12:30:00	QQQ	ETF	120.8	120.915	120.71	120.82	844492.0
2016-12-15 13:00:00	QQQ	ETF	120.82	120.9899	120.76	120.89	1144274.0
2016-12-15 13:30:00	QQQ	ETF	120.89	120.95	120.09	120.2	1972531.0

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

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