PREVIEW / etf_30min / 2014-08-12

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-08-12.parquet
  size:    326 KB
  rows:    11,184

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
2014-08-12 04:00:00	SPY	ETF	194.11	194.17	194.09	194.1	4800.0
2014-08-12 04:30:00	SPY	ETF	194.14	194.29	194.14	194.29	5855.0
2014-08-12 05:00:00	SPY	ETF	194.2	194.25	194.18	194.24	25625.0
2014-08-12 05:30:00	SPY	ETF	194.2	194.34	194.17	194.26	1887.0
2014-08-12 06:00:00	SPY	ETF	194.33	194.36	194.26	194.26	6546.0
2014-08-12 06:30:00	SPY	ETF	194.27	194.3	194.15	194.18	19802.0
2014-08-12 07:00:00	SPY	ETF	194.17	194.25	194.1	194.14	92840.0
2014-08-12 07:30:00	SPY	ETF	194.13	194.14	193.83	193.96	297140.0
2014-08-12 08:00:00	SPY	ETF	194.04	194.07	193.86	193.86	266508.0
2014-08-12 08:30:00	SPY	ETF	193.87	194.06	193.84	193.9	245551.0
2014-08-12 09:00:00	SPY	ETF	193.9	193.9	193.41	193.61	853250.0
2014-08-12 09:30:00	SPY	ETF	193.61	194.11	193.41	193.99	8676466.0
2014-08-12 10:00:00	SPY	ETF	193.98	194.15	193.56	193.95	6380557.0
2014-08-12 10:30:00	SPY	ETF	193.95	193.95	193.43	193.53	5390320.0
2014-08-12 11:00:00	SPY	ETF	193.53	193.535	193.05	193.34	6901021.0
2014-08-12 11:30:00	SPY	ETF	193.335	193.47	193.27	193.325	3167352.0
2014-08-12 12:00:00	SPY	ETF	193.33	193.44	193.13	193.34	5104097.0
2014-08-12 12:30:00	SPY	ETF	193.335	193.76	193.33	193.55	3567981.0
2014-08-12 13:00:00	SPY	ETF	193.55	193.73	193.47	193.59	3903572.0
2014-08-12 13:30:00	SPY	ETF	193.595	193.6	193.28	193.45	2537386.0
2014-08-12 14:00:00	SPY	ETF	193.445	193.46	193.01	193.13	5488379.0
2014-08-12 14:30:00	SPY	ETF	193.135	193.35	192.94	193.17	3415794.0
2014-08-12 15:00:00	SPY	ETF	193.185	193.45	193.17	193.32	3123296.0
2014-08-12 15:30:00	SPY	ETF	193.32	193.7	193.28	193.54	8395949.0
2014-08-12 16:00:00	SPY	ETF	193.54	193.8399	193.3701	193.62	3508413.0
2014-08-12 16:30:00	SPY	ETF	193.61	193.84	193.6	193.83	192281.0
2014-08-12 17:00:00	SPY	ETF	193.8	193.83	193.75	193.78	529301.0
2014-08-12 17:30:00	SPY	ETF	193.77	193.79	193.75	193.76	18859.0
2014-08-12 18:00:00	SPY	ETF	193.78	193.84	193.76	193.82	17201.0
2014-08-12 18:30:00	SPY	ETF	193.83	193.85	193.8	193.8	11350.0
2014-08-12 19:00:00	SPY	ETF	193.79	193.8	193.77	193.77	2350.0
2014-08-12 19:30:00	SPY	ETF	193.79	193.79	193.75	193.78	16650.0
2014-08-12 04:00:00	QQQ	ETF	95.54	95.54	95.54	95.54	500.0
2014-08-12 04:30:00	QQQ	ETF	95.65	95.79	95.65	95.79	900.0
2014-08-12 05:00:00	QQQ	ETF	95.61	95.67	95.61	95.66	34600.0
2014-08-12 05:30:00	QQQ	ETF	95.7	95.7	95.7	95.7	100.0
2014-08-12 06:00:00	QQQ	ETF	95.72	95.72	95.72	95.72	7400.0
2014-08-12 06:30:00	QQQ	ETF	95.64	95.65	95.64	95.65	18300.0
2014-08-12 07:00:00	QQQ	ETF	95.65	95.67	95.65	95.67	5200.0
2014-08-12 07:30:00	QQQ	ETF	95.6	95.6	95.41	95.45	16300.0
2014-08-12 08:00:00	QQQ	ETF	95.55	95.56	95.48	95.49	70760.0
2014-08-12 08:30:00	QQQ	ETF	95.48	95.56	95.45	95.5	112835.0
2014-08-12 09:00:00	QQQ	ETF	95.5	95.5	95.29	95.37	303792.0
2014-08-12 09:30:00	QQQ	ETF	95.38	95.65	95.27	95.605	2661530.0
2014-08-12 10:00:00	QQQ	ETF	95.605	95.67	95.38	95.48	1918452.0
2014-08-12 10:30:00	QQQ	ETF	95.48	95.49	95.25	95.295	1822413.0
2014-08-12 11:00:00	QQQ	ETF	95.3	95.3	94.995	95.16	2908472.0
2014-08-12 11:30:00	QQQ	ETF	95.16	95.27	95.12	95.205	1448619.0
2014-08-12 12:00:00	QQQ	ETF	95.2	95.26	95.09	95.18	910203.0
2014-08-12 12:30:00	QQQ	ETF	95.185	95.41	95.185	95.3	763668.0

> showing 50 of 11,184 rows — these rows as CSV

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