PREVIEW / etf_30min / 2016-08-12

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-08-12.parquet
  size:    387 KB
  rows:    13,108

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-08-12 04:00:00	SPY	ETF	218.64	218.77	218.64	218.76	2900.0
2016-08-12 04:30:00	SPY	ETF	218.79	218.79	218.69	218.71	1600.0
2016-08-12 05:00:00	SPY	ETF	218.71	218.77	218.71	218.77	3900.0
2016-08-12 05:30:00	SPY	ETF	218.72	218.72	218.71	218.71	3240.0
2016-08-12 06:00:00	SPY	ETF	218.73	218.79	218.73	218.77	6185.0
2016-08-12 06:30:00	SPY	ETF	218.72	218.75	218.69	218.69	2900.0
2016-08-12 07:00:00	SPY	ETF	218.7	218.7	218.59	218.64	42390.0
2016-08-12 07:30:00	SPY	ETF	218.65	218.7	218.64	218.69	10259.0
2016-08-12 08:00:00	SPY	ETF	218.74	218.74	218.4	218.58	348363.0
2016-08-12 08:30:00	SPY	ETF	218.55	218.58	218.31	218.4	410369.0
2016-08-12 09:00:00	SPY	ETF	218.4	218.46	218.27	218.29	367293.0
2016-08-12 09:30:00	SPY	ETF	218.29	218.46	218.11	218.375	7268165.0
2016-08-12 10:00:00	SPY	ETF	218.38	218.55	218.27	218.42	4387429.0
2016-08-12 10:30:00	SPY	ETF	218.4189	218.68	218.39	218.61	2779536.0
2016-08-12 11:00:00	SPY	ETF	218.615	218.7	218.56	218.689	3469792.0
2016-08-12 11:30:00	SPY	ETF	218.6893	218.71	218.41	218.49	2068641.0
2016-08-12 12:00:00	SPY	ETF	218.485	218.53	218.24	218.34	2509602.0
2016-08-12 12:30:00	SPY	ETF	218.335	218.45	218.28	218.285	1711065.0
2016-08-12 13:00:00	SPY	ETF	218.28	218.2852	217.99	218.23	2573901.0
2016-08-12 13:30:00	SPY	ETF	218.225	218.23	218.1	218.13	2072222.0
2016-08-12 14:00:00	SPY	ETF	218.13	218.3	218.08	218.25	2179459.0
2016-08-12 14:30:00	SPY	ETF	218.245	218.39	218.23	218.31	1904461.0
2016-08-12 15:00:00	SPY	ETF	218.3199	218.38	218.27	218.375	2507535.0
2016-08-12 15:30:00	SPY	ETF	218.375	218.57	218.33	218.45	9695197.0
2016-08-12 16:00:00	SPY	ETF	218.46	218.54	218.41	218.45	6005055.0
2016-08-12 16:30:00	SPY	ETF	218.45	218.52	218.43	218.52	5666360.0
2016-08-12 17:00:00	SPY	ETF	218.52	218.52	218.46	218.47	12582.0
2016-08-12 17:30:00	SPY	ETF	218.52	218.52	218.44	218.44	51941.0
2016-08-12 18:00:00	SPY	ETF	218.45	218.46	218.4	218.4	36175.0
2016-08-12 18:30:00	SPY	ETF	218.4	218.44	218.4	218.41	11648.0
2016-08-12 19:00:00	SPY	ETF	218.44	218.44	218.43	218.43	640.0
2016-08-12 19:30:00	SPY	ETF	218.45	218.45	218.43	218.45	4378.0
2016-08-12 04:00:00	QQQ	ETF	117.18	117.18	117.18	117.18	100.0
2016-08-12 04:30:00	QQQ	ETF	117.15	117.15	117.15	117.15	100.0
2016-08-12 05:00:00	QQQ	ETF	117.19	117.19	117.19	117.19	100.0
2016-08-12 07:00:00	QQQ	ETF	117.12	117.14	117.11	117.12	30242.0
2016-08-12 07:30:00	QQQ	ETF	117.14	117.14	117.14	117.14	211.0
2016-08-12 08:00:00	QQQ	ETF	117.16	117.18	117.12	117.12	2400.0
2016-08-12 08:30:00	QQQ	ETF	117.06	117.1	116.98	117.05	82472.0
2016-08-12 09:00:00	QQQ	ETF	117.06	117.08	116.89	116.91	163573.0
2016-08-12 09:30:00	QQQ	ETF	116.91	117.05	116.79	116.9542	2780361.0
2016-08-12 10:00:00	QQQ	ETF	116.96	117.01	116.84	116.96	1019832.0
2016-08-12 10:30:00	QQQ	ETF	116.96	117.06	116.92	117.04	912145.0
2016-08-12 11:00:00	QQQ	ETF	117.05	117.121	117.04	117.12	709160.0
2016-08-12 11:30:00	QQQ	ETF	117.12	117.15	116.97	117.03	996035.0
2016-08-12 12:00:00	QQQ	ETF	117.02	117.05	116.93	117.0	1164564.0
2016-08-12 12:30:00	QQQ	ETF	116.99	117.06	116.98	116.99	453886.0
2016-08-12 13:00:00	QQQ	ETF	116.9966	117.0	116.83	116.98	562172.0
2016-08-12 13:30:00	QQQ	ETF	116.97	117.0	116.91	116.94	500707.0
2016-08-12 14:00:00	QQQ	ETF	116.93	117.03	116.9	117.01	499644.0

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

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