PREVIEW / etf_30min / 2015-11-05

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-11-05.parquet
  size:    376 KB
  rows:    12,656

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
2015-11-05 04:00:00	SPY	ETF	210.12	210.39	210.12	210.39	1082.0
2015-11-05 04:30:00	SPY	ETF	210.39	210.39	210.22	210.29	1203.0
2015-11-05 05:00:00	SPY	ETF	210.33	210.57	210.33	210.57	5078.0
2015-11-05 05:30:00	SPY	ETF	210.6	210.7	210.52	210.55	5084.0
2015-11-05 06:00:00	SPY	ETF	210.55	210.6	210.5	210.52	14139.0
2015-11-05 06:30:00	SPY	ETF	210.5	210.89	210.5	210.72	32014.0
2015-11-05 07:00:00	SPY	ETF	210.74	211.06	210.72	211.02	130679.0
2015-11-05 07:30:00	SPY	ETF	211.03	211.12	210.97	211.05	232147.0
2015-11-05 08:00:00	SPY	ETF	210.43	211.04	210.23	210.9335	271799.0
2015-11-05 08:30:00	SPY	ETF	210.92	210.95	210.61	210.67	503433.0
2015-11-05 09:00:00	SPY	ETF	210.67	210.74	210.41	210.42	400816.0
2015-11-05 09:30:00	SPY	ETF	210.43	210.89	210.21	210.8611	8740632.0
2015-11-05 10:00:00	SPY	ETF	210.86	210.98	209.54	209.59	8990438.0
2015-11-05 10:30:00	SPY	ETF	209.58	209.5992	209.09	209.415	8970393.0
2015-11-05 11:00:00	SPY	ETF	209.415	209.775	209.26	209.73	6869702.0
2015-11-05 11:30:00	SPY	ETF	209.73	210.13	209.52	210.09	4681655.0
2015-11-05 12:00:00	SPY	ETF	210.09	210.31	209.86	210.26	3752227.0
2015-11-05 12:30:00	SPY	ETF	210.25	210.41	210.03	210.38	2940604.0
2015-11-05 13:00:00	SPY	ETF	210.39	210.47	209.96	209.961	2809566.0
2015-11-05 13:30:00	SPY	ETF	209.98	210.26	209.95	210.19	2273949.0
2015-11-05 14:00:00	SPY	ETF	210.19	210.33	209.74	209.82	3642263.0
2015-11-05 14:30:00	SPY	ETF	209.82	209.93	209.63	209.92	4007620.0
2015-11-05 15:00:00	SPY	ETF	209.92	210.32	209.66	210.26	4460195.0
2015-11-05 15:30:00	SPY	ETF	210.255	210.4	210.09	210.12	8711546.0
2015-11-05 16:00:00	SPY	ETF	210.12	210.18	209.93	210.15	3634173.0
2015-11-05 16:30:00	SPY	ETF	210.15	210.23	210.11	210.21	1333873.0
2015-11-05 17:00:00	SPY	ETF	210.17	210.2335	210.11	210.14	79347.0
2015-11-05 17:30:00	SPY	ETF	210.14	210.17	210.1	210.15	57987.0
2015-11-05 18:00:00	SPY	ETF	210.14	210.15	210.0	210.01	101860.0
2015-11-05 18:30:00	SPY	ETF	210.01	210.0135	209.87	209.92	33053.0
2015-11-05 19:00:00	SPY	ETF	209.91	209.96	209.79	209.95	61377.0
2015-11-05 19:30:00	SPY	ETF	209.91	209.98	209.91	209.95	26211.0
2015-11-05 04:00:00	QQQ	ETF	114.9	115.03	114.9	115.03	700.0
2015-11-05 04:30:00	QQQ	ETF	115.05	115.05	115.01	115.01	200.0
2015-11-05 05:00:00	QQQ	ETF	115.15	115.15	115.15	115.15	750.0
2015-11-05 05:30:00	QQQ	ETF	115.15	115.2	115.15	115.19	1200.0
2015-11-05 06:00:00	QQQ	ETF	115.19	115.19	115.15	115.15	700.0
2015-11-05 06:30:00	QQQ	ETF	115.19	115.32	115.19	115.3	3600.0
2015-11-05 07:00:00	QQQ	ETF	115.3	115.39	115.29	115.35	12850.0
2015-11-05 07:30:00	QQQ	ETF	115.37	115.41	115.33	115.33	35651.0
2015-11-05 08:00:00	QQQ	ETF	115.33	115.33	115.25	115.29	46691.0
2015-11-05 08:30:00	QQQ	ETF	115.3	115.3	115.21	115.22	30758.0
2015-11-05 09:00:00	QQQ	ETF	115.23	115.26	115.1	115.13	187557.0
2015-11-05 09:30:00	QQQ	ETF	115.12	115.35	114.98	115.33	2362192.0
2015-11-05 10:00:00	QQQ	ETF	115.32	115.395	114.36	114.4	2428630.0
2015-11-05 10:30:00	QQQ	ETF	114.39	114.44	114.11	114.28	2345653.0
2015-11-05 11:00:00	QQQ	ETF	114.28	114.53	114.23	114.48	1220452.0
2015-11-05 11:30:00	QQQ	ETF	114.48	114.71	114.345	114.69	1366378.0
2015-11-05 12:00:00	QQQ	ETF	114.69	114.76	114.44	114.71	1074204.0
2015-11-05 12:30:00	QQQ	ETF	114.71	114.81	114.52	114.79	970951.0

> showing 50 of 12,656 rows — these rows as CSV

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