PREVIEW / etf_30min / 2015-07-21

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-07-21.parquet
  size:    383 KB
  rows:    12,902

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-07-21 04:00:00	SPY	ETF	212.73	212.83	212.73	212.8	7010.0
2015-07-21 04:30:00	SPY	ETF	212.8	212.87	212.65	212.65	10890.0
2015-07-21 05:00:00	SPY	ETF	212.65	212.65	212.64	212.64	900.0
2015-07-21 05:30:00	SPY	ETF	212.67	212.78	212.67	212.78	12700.0
2015-07-21 06:00:00	SPY	ETF	212.75	212.8	212.74	212.78	26193.0
2015-07-21 06:30:00	SPY	ETF	212.77	212.8	212.77	212.79	2400.0
2015-07-21 07:00:00	SPY	ETF	212.8	212.83	212.78	212.78	51055.0
2015-07-21 07:30:00	SPY	ETF	212.78	212.79	212.68	212.7	23507.0
2015-07-21 08:00:00	SPY	ETF	212.68	212.74	212.56	212.62	89814.0
2015-07-21 08:30:00	SPY	ETF	212.6	212.69	212.47	212.47	172587.0
2015-07-21 09:00:00	SPY	ETF	212.46	212.47	212.32	212.44	278878.0
2015-07-21 09:30:00	SPY	ETF	212.43	212.69	212.41	212.69	7724180.0
2015-07-21 10:00:00	SPY	ETF	212.69	212.74	212.36	212.44	4178776.0
2015-07-21 10:30:00	SPY	ETF	212.44	212.44	211.94	212.095	6119755.0
2015-07-21 11:00:00	SPY	ETF	212.0801	212.14	211.7	211.9	5848744.0
2015-07-21 11:30:00	SPY	ETF	211.89	211.99	211.785	211.88	4117156.0
2015-07-21 12:00:00	SPY	ETF	211.88	211.95	211.78	211.93	4764064.0
2015-07-21 12:30:00	SPY	ETF	211.93	212.03	211.63	211.78	4540355.0
2015-07-21 13:00:00	SPY	ETF	211.775	211.775	211.48	211.6199	3684783.0
2015-07-21 13:30:00	SPY	ETF	211.615	211.665	211.48	211.62	2404387.0
2015-07-21 14:00:00	SPY	ETF	211.62	211.87	211.39	211.84	4691023.0
2015-07-21 14:30:00	SPY	ETF	211.83	211.885	211.45	211.605	3796549.0
2015-07-21 15:00:00	SPY	ETF	211.61	211.74	211.47	211.65	5016411.0
2015-07-21 15:30:00	SPY	ETF	211.655	211.97	211.63	211.75	10874154.0
2015-07-21 16:00:00	SPY	ETF	211.75	212.11	211.74	212.02	5192080.0
2015-07-21 16:30:00	SPY	ETF	211.97	211.97	211.28	211.39	2848403.0
2015-07-21 17:00:00	SPY	ETF	211.4	211.4	211.25	211.25	398091.0
2015-07-21 17:30:00	SPY	ETF	211.25	211.32	211.2	211.32	50309.0
2015-07-21 18:00:00	SPY	ETF	211.33	211.44	211.31	211.36	61243.0
2015-07-21 18:30:00	SPY	ETF	211.3101	211.36	211.27	211.28	101641.0
2015-07-21 19:00:00	SPY	ETF	211.28	211.32	211.25	211.3	23935.0
2015-07-21 19:30:00	SPY	ETF	211.29	211.32	211.26	211.28	16566.0
2015-07-21 04:00:00	QQQ	ETF	114.03	114.03	114.0	114.0	200.0
2015-07-21 04:30:00	QQQ	ETF	114.15	114.15	114.15	114.15	366.0
2015-07-21 06:00:00	QQQ	ETF	114.1	114.1	114.1	114.1	1000.0
2015-07-21 06:30:00	QQQ	ETF	114.18	114.2	114.17	114.2	2950.0
2015-07-21 07:00:00	QQQ	ETF	114.2	114.22	114.2	114.22	7394.0
2015-07-21 07:30:00	QQQ	ETF	114.21	114.21	114.14	114.14	27904.0
2015-07-21 08:00:00	QQQ	ETF	114.16	114.26	114.1	114.11	125562.0
2015-07-21 08:30:00	QQQ	ETF	114.11	114.17	114.03	114.03	26596.0
2015-07-21 09:00:00	QQQ	ETF	114.02	114.05	113.99	114.03	83434.0
2015-07-21 09:30:00	QQQ	ETF	114.02	114.14	113.75	114.14	3177677.0
2015-07-21 10:00:00	QQQ	ETF	114.14	114.2	113.84	113.88	2486245.0
2015-07-21 10:30:00	QQQ	ETF	113.87	113.899	113.58	113.74	2451767.0
2015-07-21 11:00:00	QQQ	ETF	113.73	113.8	113.6	113.798	1651641.0
2015-07-21 11:30:00	QQQ	ETF	113.79	113.93	113.73	113.8799	1267082.0
2015-07-21 12:00:00	QQQ	ETF	113.87	114.0	113.86	113.99	741577.0
2015-07-21 12:30:00	QQQ	ETF	113.99	114.07	113.79	113.87	1095604.0
2015-07-21 13:00:00	QQQ	ETF	113.865	113.865	113.67	113.84	980970.0
2015-07-21 13:30:00	QQQ	ETF	113.83	113.91	113.76	113.87	764599.0

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

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