PREVIEW / etf_30min / 2015-02-26

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-02-26.parquet
  size:    373 KB
  rows:    12,640

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-02-26 04:00:00	SPY	ETF	211.63	211.96	211.63	211.9	2698.0
2015-02-26 04:30:00	SPY	ETF	211.86	211.94	211.82	211.88	2700.0
2015-02-26 05:00:00	SPY	ETF	211.85	211.85	211.75	211.77	3450.0
2015-02-26 05:30:00	SPY	ETF	211.83	211.93	211.8	211.8	2479.0
2015-02-26 06:00:00	SPY	ETF	211.87	211.87	211.84	211.84	600.0
2015-02-26 06:30:00	SPY	ETF	211.89	211.94	211.88	211.88	4000.0
2015-02-26 07:00:00	SPY	ETF	211.88	211.91	211.75	211.83	29005.0
2015-02-26 07:30:00	SPY	ETF	211.82	211.82	211.68	211.71	40154.0
2015-02-26 08:00:00	SPY	ETF	211.73	211.85	211.72	211.74	161557.0
2015-02-26 08:30:00	SPY	ETF	211.79	211.82	211.34	211.46	475947.0
2015-02-26 09:00:00	SPY	ETF	211.45	211.54	211.31	211.54	459901.0
2015-02-26 09:30:00	SPY	ETF	211.52	211.65	210.86	210.9	8945529.0
2015-02-26 10:00:00	SPY	ETF	210.9	211.265	210.88	211.221	4795651.0
2015-02-26 10:30:00	SPY	ETF	211.23	211.48	211.1	211.43	3900556.0
2015-02-26 11:00:00	SPY	ETF	211.42	211.71	211.42	211.53	4974169.0
2015-02-26 11:30:00	SPY	ETF	211.53	211.67	211.47	211.51	4534902.0
2015-02-26 12:00:00	SPY	ETF	211.5	211.51	211.12	211.33	3049181.0
2015-02-26 12:30:00	SPY	ETF	211.33	211.65	211.31	211.564	2839677.0
2015-02-26 13:00:00	SPY	ETF	211.57	211.6	211.2	211.36	2499921.0
2015-02-26 13:30:00	SPY	ETF	211.35	211.51	211.33	211.35	1908601.0
2015-02-26 14:00:00	SPY	ETF	211.36	211.47	210.98	211.01	3531121.0
2015-02-26 14:30:00	SPY	ETF	211.01	211.09	210.84	210.97	5012202.0
2015-02-26 15:00:00	SPY	ETF	210.97	211.26	210.65	211.205	7053830.0
2015-02-26 15:30:00	SPY	ETF	211.21	211.49	211.1	211.41	9519338.0
2015-02-26 16:00:00	SPY	ETF	211.39	211.635	211.3	211.45	3770855.0
2015-02-26 16:30:00	SPY	ETF	211.46	211.56	211.37	211.48	2161482.0
2015-02-26 17:00:00	SPY	ETF	211.46	211.47	211.37	211.37	18793.0
2015-02-26 17:30:00	SPY	ETF	211.42	211.43	211.42	211.42	2325.0
2015-02-26 18:00:00	SPY	ETF	211.41	211.42	211.34	211.36	25872.0
2015-02-26 18:30:00	SPY	ETF	211.36	211.36	211.3	211.31	17813.0
2015-02-26 19:00:00	SPY	ETF	211.25	211.25	211.16	211.2	13925.0
2015-02-26 19:30:00	SPY	ETF	211.2	211.22	211.14	211.17	60405.0
2015-02-26 04:00:00	QQQ	ETF	108.43	108.43	108.4	108.4	459.0
2015-02-26 06:00:00	QQQ	ETF	108.49	108.49	108.49	108.49	100.0
2015-02-26 06:30:00	QQQ	ETF	108.52	108.52	108.52	108.52	200.0
2015-02-26 07:00:00	QQQ	ETF	108.49	108.49	108.42	108.46	10950.0
2015-02-26 08:00:00	QQQ	ETF	108.41	108.46	108.4	108.4	56967.0
2015-02-26 08:30:00	QQQ	ETF	108.39	108.45	108.31	108.4	61128.0
2015-02-26 09:00:00	QQQ	ETF	108.39	108.45	108.34	108.42	47350.0
2015-02-26 09:30:00	QQQ	ETF	108.44	108.59	108.135	108.18	2967517.0
2015-02-26 10:00:00	QQQ	ETF	108.18	108.4299	108.16	108.425	1500062.0
2015-02-26 10:30:00	QQQ	ETF	108.42	108.66	108.3501	108.6	1340093.0
2015-02-26 11:00:00	QQQ	ETF	108.6	108.79	108.595	108.67	1146096.0
2015-02-26 11:30:00	QQQ	ETF	108.67	108.819	108.66	108.75	1140147.0
2015-02-26 12:00:00	QQQ	ETF	108.75	108.76	108.46	108.65	777742.0
2015-02-26 12:30:00	QQQ	ETF	108.64	108.87	108.63	108.81	895291.0
2015-02-26 13:00:00	QQQ	ETF	108.81	108.85	108.655	108.75	745304.0
2015-02-26 13:30:00	QQQ	ETF	108.74	108.83	108.71	108.74	565286.0
2015-02-26 14:00:00	QQQ	ETF	108.74	108.8	108.46	108.49	855241.0
2015-02-26 14:30:00	QQQ	ETF	108.49	108.6245	108.36	108.58	1102180.0

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

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