PREVIEW / etf_30min / 2015-04-01

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-04-01.parquet
  size:    385 KB
  rows:    12,987

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-04-01 04:00:00	SPY	ETF	205.78	205.79	205.6	205.63	4082.0
2015-04-01 04:30:00	SPY	ETF	205.62	205.79	205.62	205.78	3035.0
2015-04-01 05:00:00	SPY	ETF	205.94	206.17	205.94	206.15	7326.0
2015-04-01 05:30:00	SPY	ETF	206.2	206.52	206.2	206.47	10759.0
2015-04-01 06:00:00	SPY	ETF	206.48	206.54	206.35	206.35	30980.0
2015-04-01 06:30:00	SPY	ETF	206.37	206.46	206.37	206.4	104157.0
2015-04-01 07:00:00	SPY	ETF	206.4	206.41	205.65	205.65	365651.0
2015-04-01 07:30:00	SPY	ETF	205.71	205.88	205.7	205.83	251996.0
2015-04-01 08:00:00	SPY	ETF	205.81	206.43	205.35	205.77	665308.0
2015-04-01 08:30:00	SPY	ETF	205.77	206.43	204.82	205.979	824174.0
2015-04-01 09:00:00	SPY	ETF	205.98	206.43	204.57	206.39	1624499.0
2015-04-01 09:30:00	SPY	ETF	206.39	206.42	204.51	204.84	24575996.0
2015-04-01 10:00:00	SPY	ETF	204.83	205.3567	204.67	205.14	15449080.0
2015-04-01 10:30:00	SPY	ETF	205.16	205.93	204.84	205.7	9884110.0
2015-04-01 11:00:00	SPY	ETF	205.69	206.02	205.45	205.51	6483616.0
2015-04-01 11:30:00	SPY	ETF	205.51	205.81	205.34	205.47	6352461.0
2015-04-01 12:00:00	SPY	ETF	205.48	205.52	205.06	205.4	5664867.0
2015-04-01 12:30:00	SPY	ETF	205.4	205.71	205.21	205.49	4326048.0
2015-04-01 13:00:00	SPY	ETF	205.5	205.62	205.29	205.58	5173112.0
2015-04-01 13:30:00	SPY	ETF	205.58	205.95	205.49	205.74	4693131.0
2015-04-01 14:00:00	SPY	ETF	205.75	205.8	205.2	205.26	7517973.0
2015-04-01 14:30:00	SPY	ETF	205.25	205.59	205.1	205.42	5405590.0
2015-04-01 15:00:00	SPY	ETF	205.42	205.43	205.03	205.28	6582034.0
2015-04-01 15:30:00	SPY	ETF	205.27	205.76	205.17	205.76	17829850.0
2015-04-01 16:00:00	SPY	ETF	205.76	206.06	205.2559	205.86	4480908.0
2015-04-01 16:30:00	SPY	ETF	205.87	206.03	205.87	205.93	3302075.0
2015-04-01 17:00:00	SPY	ETF	205.91	205.99	205.89	205.98	1110522.0
2015-04-01 17:30:00	SPY	ETF	205.98	206.05	205.95	206.04	25767.0
2015-04-01 18:00:00	SPY	ETF	206.05	206.23	205.7	206.1	90839.0
2015-04-01 18:30:00	SPY	ETF	206.11	206.11	205.97	205.97	53527.0
2015-04-01 19:00:00	SPY	ETF	205.97	206.04	205.94	205.97	14711.0
2015-04-01 19:30:00	SPY	ETF	205.96	205.96	205.74	205.79	67008.0
2015-04-01 04:00:00	QQQ	ETF	105.25	105.3	105.24	105.27	18350.0
2015-04-01 04:30:00	QQQ	ETF	105.17	105.34	105.17	105.34	12390.0
2015-04-01 05:00:00	QQQ	ETF	105.53	105.55	105.53	105.55	3000.0
2015-04-01 05:30:00	QQQ	ETF	105.81	105.81	105.78	105.78	5000.0
2015-04-01 06:00:00	QQQ	ETF	105.67	105.67	105.67	105.67	5000.0
2015-04-01 06:30:00	QQQ	ETF	105.67	105.68	105.63	105.66	14500.0
2015-04-01 07:00:00	QQQ	ETF	105.62	105.62	105.24	105.24	48490.0
2015-04-01 07:30:00	QQQ	ETF	105.25	105.39	105.24	105.29	61309.0
2015-04-01 08:00:00	QQQ	ETF	105.33	105.6	105.24	105.3	53377.0
2015-04-01 08:30:00	QQQ	ETF	105.29	105.5	105.28	105.46	174438.0
2015-04-01 09:00:00	QQQ	ETF	105.45	105.6	105.43	105.6	264816.0
2015-04-01 09:30:00	QQQ	ETF	105.6	105.62	104.37	104.5001	6901999.0
2015-04-01 10:00:00	QQQ	ETF	104.49	104.85	104.37	104.61	4339756.0
2015-04-01 10:30:00	QQQ	ETF	104.61	104.98	104.39	104.87	3087565.0
2015-04-01 11:00:00	QQQ	ETF	104.87	105.1	104.7402	104.81	1470624.0
2015-04-01 11:30:00	QQQ	ETF	104.81	105.01	104.71	104.8059	956312.0
2015-04-01 12:00:00	QQQ	ETF	104.81	104.9	104.62	104.77	889451.0
2015-04-01 12:30:00	QQQ	ETF	104.77	104.88	104.611	104.72	1055621.0

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

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