PREVIEW / etf_30min / 2016-02-23

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-02-23.parquet
  size:    386 KB
  rows:    13,041

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
2016-02-23 04:00:00	SPY	ETF	193.82	194.0	193.71	193.78	8956.0
2016-02-23 04:30:00	SPY	ETF	193.73	193.88	193.47	193.48	18389.0
2016-02-23 05:00:00	SPY	ETF	193.52	193.67	193.39	193.39	8552.0
2016-02-23 05:30:00	SPY	ETF	193.46	193.81	193.43	193.8	8261.0
2016-02-23 06:00:00	SPY	ETF	193.81	194.1	193.79	193.96	26900.0
2016-02-23 06:30:00	SPY	ETF	193.93	194.03	193.88	193.9	29420.0
2016-02-23 07:00:00	SPY	ETF	193.95	194.24	193.94	194.18	80485.0
2016-02-23 07:30:00	SPY	ETF	194.15	194.2	193.86	193.97	152149.0
2016-02-23 08:00:00	SPY	ETF	193.96	194.2	193.65	193.73	650861.0
2016-02-23 08:30:00	SPY	ETF	193.73	194.38	193.7	194.3	647413.0
2016-02-23 09:00:00	SPY	ETF	194.28	194.3	193.82	193.99	1012305.0
2016-02-23 09:30:00	SPY	ETF	194.0	194.32	193.79	194.03	10844220.0
2016-02-23 10:00:00	SPY	ETF	194.03	194.125	193.2	193.47	10739354.0
2016-02-23 10:30:00	SPY	ETF	193.48	193.61	192.78	192.92	7818006.0
2016-02-23 11:00:00	SPY	ETF	192.92	192.99	192.47	192.68	8322163.0
2016-02-23 11:30:00	SPY	ETF	192.69	193.24	192.49	193.0	7417778.0
2016-02-23 12:00:00	SPY	ETF	192.99	192.99	192.65	192.92	3702079.0
2016-02-23 12:30:00	SPY	ETF	192.92	193.08	192.8	193.06	2983361.0
2016-02-23 13:00:00	SPY	ETF	193.05	193.09	192.81	192.94	5642025.0
2016-02-23 13:30:00	SPY	ETF	192.94	192.95	192.53	192.78	5708854.0
2016-02-23 14:00:00	SPY	ETF	192.78	193.1	192.68	192.86	4801442.0
2016-02-23 14:30:00	SPY	ETF	192.8599	192.96	192.57	192.5908	3585181.0
2016-02-23 15:00:00	SPY	ETF	192.5911	192.68	192.18	192.28	8706046.0
2016-02-23 15:30:00	SPY	ETF	192.3	192.95	192.29	192.37	16760983.0
2016-02-23 16:00:00	SPY	ETF	192.37	192.58	192.0	192.11	9029748.0
2016-02-23 16:30:00	SPY	ETF	192.11	192.39	191.96	192.0	939950.0
2016-02-23 17:00:00	SPY	ETF	192.0	192.5885	191.97	191.98	307641.0
2016-02-23 17:30:00	SPY	ETF	192.02	192.04	191.9	191.98	145942.0
2016-02-23 18:00:00	SPY	ETF	191.99	192.03	191.91	191.98	58071.0
2016-02-23 18:30:00	SPY	ETF	192.01	192.08	191.96	192.0	28268.0
2016-02-23 19:00:00	SPY	ETF	191.98	192.02	191.91	191.93	46673.0
2016-02-23 19:30:00	SPY	ETF	191.95	192.11	191.95	192.06	31364.0
2016-02-23 20:00:00	SPY	ETF	192.3999	192.3999	192.3999	192.3999	500000.0
2016-02-23 04:30:00	QQQ	ETF	102.4	102.4	102.4	102.4	100.0
2016-02-23 05:00:00	QQQ	ETF	102.4	102.4	102.32	102.32	1300.0
2016-02-23 05:30:00	QQQ	ETF	102.45	102.51	102.45	102.51	200.0
2016-02-23 06:00:00	QQQ	ETF	102.64	102.71	102.64	102.71	26745.0
2016-02-23 06:30:00	QQQ	ETF	102.64	102.65	102.59	102.62	400.0
2016-02-23 07:00:00	QQQ	ETF	102.64	102.8	102.64	102.77	14965.0
2016-02-23 07:30:00	QQQ	ETF	102.76	102.79	102.59	102.63	12116.0
2016-02-23 08:00:00	QQQ	ETF	102.76	102.76	102.42	102.47	88754.0
2016-02-23 08:30:00	QQQ	ETF	102.47	102.87	102.45	102.81	104239.0
2016-02-23 09:00:00	QQQ	ETF	102.77	102.78	102.57	102.71	71913.0
2016-02-23 09:30:00	QQQ	ETF	102.67	102.96	102.59	102.77	2225860.0
2016-02-23 10:00:00	QQQ	ETF	102.76	102.79	102.14	102.31	3596788.0
2016-02-23 10:30:00	QQQ	ETF	102.31	102.42	101.82	101.94	3227279.0
2016-02-23 11:00:00	QQQ	ETF	101.93	102.01	101.71	101.87	1918851.0
2016-02-23 11:30:00	QQQ	ETF	101.88	102.235	101.79	102.03	1729498.0
2016-02-23 12:00:00	QQQ	ETF	102.03	102.06	101.84	102.05	605454.0
2016-02-23 12:30:00	QQQ	ETF	102.05	102.18	102.0	102.18	785839.0

> showing 50 of 13,041 rows — these rows as CSV

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