PREVIEW / etf_30min / 2014-06-03

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-06-03.parquet
  size:    324 KB
  rows:    11,254

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-06-03 04:00:00	SPY	ETF	192.58	192.58	192.52	192.58	2852.0
2014-06-03 04:30:00	SPY	ETF	192.55	192.64	192.55	192.59	852.0
2014-06-03 05:00:00	SPY	ETF	192.6	192.6	192.51	192.51	3100.0
2014-06-03 05:30:00	SPY	ETF	192.54	192.55	192.48	192.5	8764.0
2014-06-03 06:00:00	SPY	ETF	192.51	192.53	192.51	192.51	11024.0
2014-06-03 06:30:00	SPY	ETF	192.51	192.58	192.51	192.52	18583.0
2014-06-03 07:00:00	SPY	ETF	192.52	192.54	192.33	192.33	248904.0
2014-06-03 07:30:00	SPY	ETF	192.33	192.35	192.2	192.28	200783.0
2014-06-03 08:00:00	SPY	ETF	192.3	192.635	192.23	192.4	411400.0
2014-06-03 08:30:00	SPY	ETF	192.4	192.41	192.31	192.32	431909.0
2014-06-03 09:00:00	SPY	ETF	192.33	192.46	192.32	192.41	618920.0
2014-06-03 09:30:00	SPY	ETF	192.4	192.7	192.28	192.645	8305448.0
2014-06-03 10:00:00	SPY	ETF	192.64	192.83	192.62	192.65	5097855.0
2014-06-03 10:30:00	SPY	ETF	192.66	192.74	192.36	192.4913	5912074.0
2014-06-03 11:00:00	SPY	ETF	192.49	192.56	192.42	192.52	4030935.0
2014-06-03 11:30:00	SPY	ETF	192.515	192.57	192.25	192.435	5702450.0
2014-06-03 12:00:00	SPY	ETF	192.43	192.73	192.42	192.66	3488650.0
2014-06-03 12:30:00	SPY	ETF	192.67	192.68	192.59	192.61	1686289.0
2014-06-03 13:00:00	SPY	ETF	192.62	192.77	192.6	192.76	1789603.0
2014-06-03 13:30:00	SPY	ETF	192.76	192.77	192.68	192.76	1419565.0
2014-06-03 14:00:00	SPY	ETF	192.77	192.8899	192.71	192.85	2096703.0
2014-06-03 14:30:00	SPY	ETF	192.85	192.9	192.71	192.73	2497329.0
2014-06-03 15:00:00	SPY	ETF	192.73	192.87	192.63	192.845	3531151.0
2014-06-03 15:30:00	SPY	ETF	192.85	192.86	192.78	192.81	7524262.0
2014-06-03 16:00:00	SPY	ETF	192.8	192.9009	192.76	192.82	6722983.0
2014-06-03 16:30:00	SPY	ETF	192.83	192.9	192.81	192.88	1180054.0
2014-06-03 17:00:00	SPY	ETF	192.89	192.97	192.88	192.95	376281.0
2014-06-03 17:30:00	SPY	ETF	192.91	192.92	192.9	192.92	20625.0
2014-06-03 18:00:00	SPY	ETF	192.9	192.9	192.73	192.77	45123.0
2014-06-03 18:30:00	SPY	ETF	192.81	192.81	192.78	192.79	1200.0
2014-06-03 19:00:00	SPY	ETF	192.82	192.85	192.82	192.85	900.0
2014-06-03 19:30:00	SPY	ETF	192.85	192.86	192.83	192.83	13770.0
2014-06-03 05:00:00	QQQ	ETF	91.03	91.03	91.03	91.03	100.0
2014-06-03 05:30:00	QQQ	ETF	90.98	91.04	90.98	91.04	300.0
2014-06-03 06:30:00	QQQ	ETF	91.0	91.0	90.97	90.97	1700.0
2014-06-03 07:00:00	QQQ	ETF	90.98	90.98	90.89	90.9	6400.0
2014-06-03 07:30:00	QQQ	ETF	90.89	90.9	90.84	90.86	3550.0
2014-06-03 08:00:00	QQQ	ETF	90.87	90.89	90.85	90.87	60544.0
2014-06-03 08:30:00	QQQ	ETF	90.89	90.92	90.87	90.89	50939.0
2014-06-03 09:00:00	QQQ	ETF	90.9	90.96	90.86	90.91	115268.0
2014-06-03 09:30:00	QQQ	ETF	90.91	91.23	90.8	91.22	3888832.0
2014-06-03 10:00:00	QQQ	ETF	91.22	91.33	91.18	91.2	1979366.0
2014-06-03 10:30:00	QQQ	ETF	91.22	91.28	91.0	91.09	1850154.0
2014-06-03 11:00:00	QQQ	ETF	91.08	91.11	90.98	91.01	937181.0
2014-06-03 11:30:00	QQQ	ETF	91.01	91.05	90.8601	90.9903	1074173.0
2014-06-03 12:00:00	QQQ	ETF	90.99	91.17	90.98	91.1224	921782.0
2014-06-03 12:30:00	QQQ	ETF	91.12	91.14	91.03	91.03	488055.0
2014-06-03 13:00:00	QQQ	ETF	91.03	91.19	91.03	91.1899	459229.0
2014-06-03 13:30:00	QQQ	ETF	91.18	91.19	91.09	91.14	578461.0
2014-06-03 14:00:00	QQQ	ETF	91.14	91.23	91.12	91.19	1152869.0

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

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