PREVIEW / etf_30min / 2015-05-22

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-05-22.parquet
  size:    361 KB
  rows:    12,285

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-05-22 04:30:00	SPY	ETF	213.43	213.43	213.43	213.43	200.0
2015-05-22 05:00:00	SPY	ETF	213.42	213.42	213.36	213.37	1500.0
2015-05-22 05:30:00	SPY	ETF	213.26	213.32	213.26	213.32	5700.0
2015-05-22 06:00:00	SPY	ETF	213.31	213.31	213.22	213.23	1548.0
2015-05-22 06:30:00	SPY	ETF	213.27	213.39	213.23	213.39	9010.0
2015-05-22 07:00:00	SPY	ETF	213.41	213.48	213.38	213.45	86670.0
2015-05-22 07:30:00	SPY	ETF	213.45	213.51	213.33	213.51	94943.0
2015-05-22 08:00:00	SPY	ETF	213.5	213.52	213.43	213.45	105905.0
2015-05-22 08:30:00	SPY	ETF	213.41	213.44	212.9	213.07	1105079.0
2015-05-22 09:00:00	SPY	ETF	213.07	213.07	212.92	213.03	458123.0
2015-05-22 09:30:00	SPY	ETF	213.04	213.34	212.91	213.23	7112878.0
2015-05-22 10:00:00	SPY	ETF	213.24	213.4	213.14	213.2283	3952524.0
2015-05-22 10:30:00	SPY	ETF	213.23	213.43	213.1775	213.37	3427361.0
2015-05-22 11:00:00	SPY	ETF	213.37	213.4	212.95	213.1099	3322243.0
2015-05-22 11:30:00	SPY	ETF	213.095	213.16	212.92	213.16	2973555.0
2015-05-22 12:00:00	SPY	ETF	213.16	213.18	213.03	213.17	1255909.0
2015-05-22 12:30:00	SPY	ETF	213.17	213.27	213.15	213.24	1869658.0
2015-05-22 13:00:00	SPY	ETF	213.22	213.54	213.07	213.36	5075676.0
2015-05-22 13:30:00	SPY	ETF	213.36	213.45	213.3	213.33	1360168.0
2015-05-22 14:00:00	SPY	ETF	213.33	213.35	213.15	213.34	1849462.0
2015-05-22 14:30:00	SPY	ETF	213.34	213.35	213.24	213.27	2975758.0
2015-05-22 15:00:00	SPY	ETF	213.27	213.44	213.22	213.36	2878410.0
2015-05-22 15:30:00	SPY	ETF	213.36	213.4	212.92	212.97	10458418.0
2015-05-22 16:00:00	SPY	ETF	212.98	213.2915	212.85	213.03	4365536.0
2015-05-22 16:30:00	SPY	ETF	213.03	213.04	212.99	213.01	1830457.0
2015-05-22 17:00:00	SPY	ETF	213.01	213.02	212.96	212.96	114312.0
2015-05-22 17:30:00	SPY	ETF	212.96	212.98	212.9	212.94	50998.0
2015-05-22 18:00:00	SPY	ETF	212.92	212.94	212.9	212.93	6135.0
2015-05-22 18:30:00	SPY	ETF	212.91	212.94	212.91	212.94	6300.0
2015-05-22 19:00:00	SPY	ETF	212.94	212.94	212.94	212.94	4615.0
2015-05-22 19:30:00	SPY	ETF	212.93	212.94	212.91	212.94	5936.0
2015-05-22 06:30:00	QQQ	ETF	110.56	110.6	110.56	110.6	700.0
2015-05-22 07:00:00	QQQ	ETF	110.64	110.65	110.64	110.64	500.0
2015-05-22 07:30:00	QQQ	ETF	110.62	110.63	110.58	110.62	20100.0
2015-05-22 08:00:00	QQQ	ETF	110.62	110.7	110.62	110.69	36077.0
2015-05-22 08:30:00	QQQ	ETF	110.68	110.68	110.41	110.53	192711.0
2015-05-22 09:00:00	QQQ	ETF	110.51	110.51	110.43	110.45	63826.0
2015-05-22 09:30:00	QQQ	ETF	110.45	110.76	110.38	110.65	2291978.0
2015-05-22 10:00:00	QQQ	ETF	110.66	110.7837	110.62	110.68	725198.0
2015-05-22 10:30:00	QQQ	ETF	110.675	110.81	110.64	110.765	843934.0
2015-05-22 11:00:00	QQQ	ETF	110.765	110.79	110.51	110.59	1335877.0
2015-05-22 11:30:00	QQQ	ETF	110.585	110.6199	110.48	110.6162	671978.0
2015-05-22 12:00:00	QQQ	ETF	110.62	110.66	110.58	110.65	306929.0
2015-05-22 12:30:00	QQQ	ETF	110.645	110.73	110.64	110.66	376948.0
2015-05-22 13:00:00	QQQ	ETF	110.66	110.87	110.59	110.76	1144613.0
2015-05-22 13:30:00	QQQ	ETF	110.77	110.83	110.745	110.76	514072.0
2015-05-22 14:00:00	QQQ	ETF	110.76	110.76	110.603	110.69	512476.0
2015-05-22 14:30:00	QQQ	ETF	110.69	110.72	110.62	110.69	246149.0
2015-05-22 15:00:00	QQQ	ETF	110.69	110.8	110.665	110.75	545970.0
2015-05-22 15:30:00	QQQ	ETF	110.75	110.7755	110.48	110.5	2161100.0

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

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