PREVIEW / etf_30min / 2015-03-26

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-03-26.parquet
  size:    384 KB
  rows:    12,958

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-03-26 04:00:00	SPY	ETF	205.49	205.49	204.4	204.9	16643.0
2015-03-26 04:30:00	SPY	ETF	204.91	204.95	204.29	204.29	34527.0
2015-03-26 05:00:00	SPY	ETF	204.3	204.38	203.84	203.93	112929.0
2015-03-26 05:30:00	SPY	ETF	203.94	204.2	203.94	204.17	150492.0
2015-03-26 06:00:00	SPY	ETF	204.14	204.52	204.06	204.52	72557.0
2015-03-26 06:30:00	SPY	ETF	204.51	204.56	204.36	204.44	86023.0
2015-03-26 07:00:00	SPY	ETF	204.45	204.57	204.23	204.52	262557.0
2015-03-26 07:30:00	SPY	ETF	204.54	204.68	204.34	204.39	423661.0
2015-03-26 08:00:00	SPY	ETF	204.36	205.85	204.0	204.34	664314.0
2015-03-26 08:30:00	SPY	ETF	204.38	205.02	204.12	204.79	1000401.0
2015-03-26 09:00:00	SPY	ETF	204.81	205.76	204.76	204.95	1249050.0
2015-03-26 09:30:00	SPY	ETF	204.96	205.51	204.5	204.79	19606887.0
2015-03-26 10:00:00	SPY	ETF	204.78	204.91	204.12	204.76	15413868.0
2015-03-26 10:30:00	SPY	ETF	204.76	205.3824	204.57	205.23	11876171.0
2015-03-26 11:00:00	SPY	ETF	205.23	205.24	204.69	205.07	8133772.0
2015-03-26 11:30:00	SPY	ETF	205.07	205.82	204.96	205.81	8912540.0
2015-03-26 12:00:00	SPY	ETF	205.82	205.9	205.36	205.4	7419716.0
2015-03-26 12:30:00	SPY	ETF	205.39	205.84	205.249	205.77	6027520.0
2015-03-26 13:00:00	SPY	ETF	205.76	205.79	205.17	205.594	5922379.0
2015-03-26 13:30:00	SPY	ETF	205.59	206.37	205.53	206.17	7289449.0
2015-03-26 14:00:00	SPY	ETF	206.17	206.22	205.6	205.6	8310905.0
2015-03-26 14:30:00	SPY	ETF	205.61	205.98	205.37	205.39	6673624.0
2015-03-26 15:00:00	SPY	ETF	205.37	205.55	205.24	205.41	9644918.0
2015-03-26 15:30:00	SPY	ETF	205.41	205.9	205.17	205.28	17913880.0
2015-03-26 16:00:00	SPY	ETF	205.28	205.43	205.105	205.36	10008985.0
2015-03-26 16:30:00	SPY	ETF	205.38	205.6941	205.38	205.45	1418180.0
2015-03-26 17:00:00	SPY	ETF	205.45	205.48	205.41	205.46	81195.0
2015-03-26 17:30:00	SPY	ETF	205.45	205.48	205.43	205.45	22223.0
2015-03-26 18:00:00	SPY	ETF	205.46	205.54	205.46	205.47	41943.0
2015-03-26 18:30:00	SPY	ETF	205.49	205.49	205.43	205.46	11058.0
2015-03-26 19:00:00	SPY	ETF	205.43	205.44	205.39	205.44	57138.0
2015-03-26 19:30:00	SPY	ETF	205.43	205.5	205.42	205.5	28757.0
2015-03-26 04:00:00	QQQ	ETF	105.1	105.1	104.74	104.79	8554.0
2015-03-26 04:30:00	QQQ	ETF	104.89	104.89	104.6	104.6	1500.0
2015-03-26 05:00:00	QQQ	ETF	104.61	104.61	104.22	104.26	19700.0
2015-03-26 05:30:00	QQQ	ETF	104.3	104.35	104.2	104.35	46950.0
2015-03-26 06:00:00	QQQ	ETF	104.25	104.38	104.23	104.38	75700.0
2015-03-26 06:30:00	QQQ	ETF	104.39	104.44	104.32	104.41	9839.0
2015-03-26 07:00:00	QQQ	ETF	104.38	104.47	104.31	104.44	57031.0
2015-03-26 07:30:00	QQQ	ETF	104.44	104.49	104.38	104.39	62910.0
2015-03-26 08:00:00	QQQ	ETF	104.39	105.27	104.28	104.31	211299.0
2015-03-26 08:30:00	QQQ	ETF	104.36	104.71	104.22	104.63	546449.0
2015-03-26 09:00:00	QQQ	ETF	104.62	104.8	104.57	104.6	704056.0
2015-03-26 09:30:00	QQQ	ETF	104.59	105.24	104.24	104.58	10678181.0
2015-03-26 10:00:00	QQQ	ETF	104.57	104.72	104.25	104.61	4642598.0
2015-03-26 10:30:00	QQQ	ETF	104.6	105.06	104.48	105.06	3374865.0
2015-03-26 11:00:00	QQQ	ETF	105.05	105.1	104.73	104.91	2696685.0
2015-03-26 11:30:00	QQQ	ETF	104.91	105.37	104.84	105.37	2166359.0
2015-03-26 12:00:00	QQQ	ETF	105.37	105.44	105.09	105.116	1991618.0
2015-03-26 12:30:00	QQQ	ETF	105.11	105.3843	105.0	105.35	1114799.0

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

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