PREVIEW / etf_30min / 2016-12-07

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-12-07.parquet
  size:    451 KB
  rows:    15,141

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-07 04:00:00	SPY	ETF	221.78	221.81	221.6	221.71	9010.0
2016-12-07 04:30:00	SPY	ETF	221.71	221.86	221.67	221.67	12831.0
2016-12-07 05:00:00	SPY	ETF	221.7	221.76	221.69	221.72	1601.0
2016-12-07 05:30:00	SPY	ETF	221.73	221.74	221.67	221.67	3109.0
2016-12-07 06:00:00	SPY	ETF	221.71	221.73	221.71	221.73	1027.0
2016-12-07 06:30:00	SPY	ETF	221.7	221.71	221.63	221.63	24152.0
2016-12-07 07:00:00	SPY	ETF	221.65	221.65	221.54	221.54	48198.0
2016-12-07 07:30:00	SPY	ETF	221.58	221.58	221.5	221.54	51912.0
2016-12-07 08:00:00	SPY	ETF	221.55	221.56	221.25	221.32	265971.0
2016-12-07 08:30:00	SPY	ETF	221.31	221.47	221.29	221.45	254841.0
2016-12-07 09:00:00	SPY	ETF	221.46	221.55	221.43	221.52	182119.0
2016-12-07 09:30:00	SPY	ETF	221.52	221.63	221.38	221.395	4766456.0
2016-12-07 10:00:00	SPY	ETF	221.39	221.89	221.39	221.89	5993446.0
2016-12-07 10:30:00	SPY	ETF	221.865	221.965	221.65	221.916	3983315.0
2016-12-07 11:00:00	SPY	ETF	221.915	221.96	221.79	221.8499	2794952.0
2016-12-07 11:30:00	SPY	ETF	221.85	222.32	221.84	222.3134	4573004.0
2016-12-07 12:00:00	SPY	ETF	222.32	222.42	222.22	222.36	3057490.0
2016-12-07 12:30:00	SPY	ETF	222.35	222.77	222.325	222.76	3744920.0
2016-12-07 13:00:00	SPY	ETF	222.77	223.46	222.76	223.241	10485023.0
2016-12-07 13:30:00	SPY	ETF	223.24	223.98	223.2	223.92	11732551.0
2016-12-07 14:00:00	SPY	ETF	223.93	224.06	223.7	223.8	10695794.0
2016-12-07 14:30:00	SPY	ETF	223.8	224.11	223.74	224.0	4811644.0
2016-12-07 15:00:00	SPY	ETF	224.0	224.5	223.8	224.375	9582057.0
2016-12-07 15:30:00	SPY	ETF	224.38	224.67	224.17	224.57	19115422.0
2016-12-07 16:00:00	SPY	ETF	224.58	224.64	224.15	224.29	9637396.0
2016-12-07 16:30:00	SPY	ETF	224.28	224.6	224.09	224.25	893251.0
2016-12-07 17:00:00	SPY	ETF	224.24	224.6	224.22	224.23	201024.0
2016-12-07 17:30:00	SPY	ETF	224.22	224.6	224.2	224.27	85179.0
2016-12-07 18:00:00	SPY	ETF	224.27	224.27	224.03	224.13	322078.0
2016-12-07 18:30:00	SPY	ETF	224.15	224.3	224.15	224.27	87694.0
2016-12-07 19:00:00	SPY	ETF	224.27	224.38	224.27	224.3	32193.0
2016-12-07 19:30:00	SPY	ETF	224.34	224.37	224.26	224.35	26452.0
2016-12-07 04:00:00	QQQ	ETF	116.93	116.93	116.93	116.93	500.0
2016-12-07 04:30:00	QQQ	ETF	116.99	117.0	116.94	116.94	1196.0
2016-12-07 05:00:00	QQQ	ETF	116.9	116.93	116.9	116.93	1284.0
2016-12-07 05:30:00	QQQ	ETF	116.91	116.91	116.91	116.91	100.0
2016-12-07 06:00:00	QQQ	ETF	116.88	116.88	116.88	116.88	100.0
2016-12-07 06:30:00	QQQ	ETF	116.87	116.87	116.87	116.87	2192.0
2016-12-07 07:30:00	QQQ	ETF	116.82	116.84	116.82	116.82	1715.0
2016-12-07 08:00:00	QQQ	ETF	116.82	116.82	116.59	116.62	41205.0
2016-12-07 08:30:00	QQQ	ETF	116.64	116.66	116.58	116.61	27222.0
2016-12-07 09:00:00	QQQ	ETF	116.6	116.66	116.59	116.64	87442.0
2016-12-07 09:30:00	QQQ	ETF	116.64	116.79	116.2919	116.2919	2170643.0
2016-12-07 10:00:00	QQQ	ETF	116.3	116.87	116.3	116.8	1356627.0
2016-12-07 10:30:00	QQQ	ETF	116.8	116.99	116.63	116.88	991161.0
2016-12-07 11:00:00	QQQ	ETF	116.89	117.0	116.65	116.72	753303.0
2016-12-07 11:30:00	QQQ	ETF	116.725	117.01	116.72	116.9908	791305.0
2016-12-07 12:00:00	QQQ	ETF	117.01	117.1	116.93	116.99	793551.0
2016-12-07 12:30:00	QQQ	ETF	116.99	117.375	116.96	117.37	934161.0
2016-12-07 13:00:00	QQQ	ETF	117.36	117.8	117.35	117.5797	3242192.0

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

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