PREVIEW / etf_30min / 2015-04-15

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-04-15.parquet
  size:    387 KB
  rows:    12,935

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-04-15 04:00:00	SPY	ETF	209.49	209.99	209.49	209.84	14691.0
2015-04-15 04:30:00	SPY	ETF	209.89	210.07	209.86	209.94	10315.0
2015-04-15 05:00:00	SPY	ETF	209.94	209.94	209.84	209.94	7600.0
2015-04-15 05:30:00	SPY	ETF	209.94	209.99	209.84	209.9	10477.0
2015-04-15 06:00:00	SPY	ETF	209.9	210.16	209.9	210.11	13084.0
2015-04-15 06:30:00	SPY	ETF	210.09	210.19	210.05	210.05	28995.0
2015-04-15 07:00:00	SPY	ETF	210.06	210.13	209.99	210.04	74809.0
2015-04-15 07:30:00	SPY	ETF	210.04	210.13	209.99	210.13	46427.0
2015-04-15 08:00:00	SPY	ETF	210.12	210.27	210.02	210.19	198740.0
2015-04-15 08:30:00	SPY	ETF	210.19	210.19	210.07	210.16	174470.0
2015-04-15 09:00:00	SPY	ETF	210.14	210.44	210.05	210.08	778194.0
2015-04-15 09:30:00	SPY	ETF	210.05	210.71	209.95	210.451	10450250.0
2015-04-15 10:00:00	SPY	ETF	210.45	210.6	210.26	210.35	5671629.0
2015-04-15 10:30:00	SPY	ETF	210.34	210.65	210.34	210.63	4788335.0
2015-04-15 11:00:00	SPY	ETF	210.64	210.66	210.2	210.365	4738781.0
2015-04-15 11:30:00	SPY	ETF	210.36	210.47	210.06	210.405	4254533.0
2015-04-15 12:00:00	SPY	ETF	210.41	210.5	210.3301	210.425	2445764.0
2015-04-15 12:30:00	SPY	ETF	210.42	210.54	210.225	210.51	2611379.0
2015-04-15 13:00:00	SPY	ETF	210.515	210.97	210.46	210.93	4187823.0
2015-04-15 13:30:00	SPY	ETF	210.92	210.98	210.77	210.8	6925721.0
2015-04-15 14:00:00	SPY	ETF	210.8	211.04	210.75	210.82	6416587.0
2015-04-15 14:30:00	SPY	ETF	210.825	211.04	210.73	210.91	7756567.0
2015-04-15 15:00:00	SPY	ETF	210.91	210.96	210.7	210.8699	5926398.0
2015-04-15 15:30:00	SPY	ETF	210.865	210.89	210.41	210.45	13461730.0
2015-04-15 16:00:00	SPY	ETF	210.47	210.95	210.44	210.48	5450682.0
2015-04-15 16:30:00	SPY	ETF	210.47	210.72	210.47	210.57	6071210.0
2015-04-15 17:00:00	SPY	ETF	210.59	210.67	210.57	210.62	37248.0
2015-04-15 17:30:00	SPY	ETF	210.63	210.65	210.63	210.65	7371.0
2015-04-15 18:00:00	SPY	ETF	210.61	210.68	210.56	210.58	53823.0
2015-04-15 18:30:00	SPY	ETF	210.55	210.55	210.52	210.52	11925.0
2015-04-15 19:00:00	SPY	ETF	210.531	210.55	210.49	210.49	17285.0
2015-04-15 19:30:00	SPY	ETF	210.48	210.55	210.47	210.54	24237.0
2015-04-15 06:00:00	QQQ	ETF	107.54	107.56	107.54	107.55	26536.0
2015-04-15 06:30:00	QQQ	ETF	107.58	107.58	107.58	107.58	1000.0
2015-04-15 07:00:00	QQQ	ETF	107.51	107.57	107.51	107.55	26200.0
2015-04-15 07:30:00	QQQ	ETF	107.57	107.58	107.52	107.56	14412.0
2015-04-15 08:00:00	QQQ	ETF	107.56	107.62	107.53	107.57	39395.0
2015-04-15 08:30:00	QQQ	ETF	107.55	107.57	107.5	107.57	28226.0
2015-04-15 09:00:00	QQQ	ETF	107.54	107.65	107.45	107.45	171842.0
2015-04-15 09:30:00	QQQ	ETF	107.45	107.68	107.335	107.559	3266359.0
2015-04-15 10:00:00	QQQ	ETF	107.55	107.62	107.41	107.51	1265587.0
2015-04-15 10:30:00	QQQ	ETF	107.51	107.62	107.49	107.62	647345.0
2015-04-15 11:00:00	QQQ	ETF	107.63	107.66	107.42	107.48	809172.0
2015-04-15 11:30:00	QQQ	ETF	107.48	107.63	107.321	107.595	963371.0
2015-04-15 12:00:00	QQQ	ETF	107.6	107.6299	107.53	107.57	382909.0
2015-04-15 12:30:00	QQQ	ETF	107.56	107.64	107.4701	107.63	434864.0
2015-04-15 13:00:00	QQQ	ETF	107.626	107.88	107.58	107.855	816054.0
2015-04-15 13:30:00	QQQ	ETF	107.85	107.925	107.81	107.85	645997.0
2015-04-15 14:00:00	QQQ	ETF	107.847	108.03	107.81	107.92	1325836.0
2015-04-15 14:30:00	QQQ	ETF	107.929	108.07	107.86	108.005	933719.0

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

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