PREVIEW / etf_30min / 2015-07-30

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-07-30.parquet
  size:    367 KB
  rows:    12,449

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-30 04:00:00	SPY	ETF	210.39	210.39	210.34	210.34	1100.0
2015-07-30 04:30:00	SPY	ETF	210.36	210.41	210.22	210.41	3245.0
2015-07-30 05:00:00	SPY	ETF	210.47	210.47	210.42	210.44	3200.0
2015-07-30 05:30:00	SPY	ETF	210.47	210.78	210.44	210.74	19035.0
2015-07-30 06:00:00	SPY	ETF	210.73	210.96	210.73	210.96	38366.0
2015-07-30 06:30:00	SPY	ETF	210.89	210.89	210.78	210.82	28473.0
2015-07-30 07:00:00	SPY	ETF	210.83	210.9	210.6	210.64	55615.0
2015-07-30 07:30:00	SPY	ETF	210.64	210.71	210.61	210.7	12093.0
2015-07-30 08:00:00	SPY	ETF	210.643	210.65	210.19	210.36	476141.0
2015-07-30 08:30:00	SPY	ETF	210.3	210.34	209.99	210.17	558721.0
2015-07-30 09:00:00	SPY	ETF	210.16	210.21	209.88	210.16	754636.0
2015-07-30 09:30:00	SPY	ETF	210.16	210.47	209.42	209.58	11295586.0
2015-07-30 10:00:00	SPY	ETF	209.58	210.09	209.45	210.08	9788634.0
2015-07-30 10:30:00	SPY	ETF	210.08	210.32	209.74	209.81	5728655.0
2015-07-30 11:00:00	SPY	ETF	209.8	210.44	209.62	210.27	7683830.0
2015-07-30 11:30:00	SPY	ETF	210.27	210.68	210.26	210.56	5657504.0
2015-07-30 12:00:00	SPY	ETF	210.55	210.75	210.455	210.6501	3597183.0
2015-07-30 12:30:00	SPY	ETF	210.655	210.82	210.51	210.81	2517294.0
2015-07-30 13:00:00	SPY	ETF	210.81	210.91	210.65	210.76	4530429.0
2015-07-30 13:30:00	SPY	ETF	210.77	210.85	210.51	210.617	3283204.0
2015-07-30 14:00:00	SPY	ETF	210.62	210.8	210.58	210.655	4075272.0
2015-07-30 14:30:00	SPY	ETF	210.655	210.88	210.5301	210.855	3047505.0
2015-07-30 15:00:00	SPY	ETF	210.86	211.02	210.8101	210.985	5899337.0
2015-07-30 15:30:00	SPY	ETF	210.98	211.0	210.77	210.79	12733112.0
2015-07-30 16:00:00	SPY	ETF	210.79	211.03	210.76	211.01	2151955.0
2015-07-30 16:30:00	SPY	ETF	211.0	211.0	210.9	210.94	1514824.0
2015-07-30 17:00:00	SPY	ETF	210.93	210.95	210.6773	210.843	126843.0
2015-07-30 17:30:00	SPY	ETF	210.84	210.86	210.81	210.81	30450.0
2015-07-30 18:00:00	SPY	ETF	210.8	210.81	210.75	210.8	37018.0
2015-07-30 18:30:00	SPY	ETF	210.77	210.82	210.77	210.82	2875.0
2015-07-30 19:00:00	SPY	ETF	210.8	210.82	210.79	210.81	9341.0
2015-07-30 19:30:00	SPY	ETF	210.78	210.82	210.77	210.82	16993.0
2015-07-30 05:00:00	QQQ	ETF	111.4	111.4	111.4	111.4	200.0
2015-07-30 05:30:00	QQQ	ETF	111.41	111.61	111.41	111.61	800.0
2015-07-30 06:00:00	QQQ	ETF	111.64	111.69	111.64	111.69	400.0
2015-07-30 06:30:00	QQQ	ETF	111.67	111.67	111.61	111.61	1500.0
2015-07-30 07:00:00	QQQ	ETF	111.67	111.67	111.55	111.55	3700.0
2015-07-30 07:30:00	QQQ	ETF	111.55	111.56	111.55	111.56	2300.0
2015-07-30 08:00:00	QQQ	ETF	111.55	111.55	111.36	111.36	53114.0
2015-07-30 08:30:00	QQQ	ETF	111.37	111.41	111.26	111.35	49870.0
2015-07-30 09:00:00	QQQ	ETF	111.3	111.32	111.17	111.28	131797.0
2015-07-30 09:30:00	QQQ	ETF	111.29	111.48	110.71	110.73	3241984.0
2015-07-30 10:00:00	QQQ	ETF	110.72	111.17	110.621	111.12	1711463.0
2015-07-30 10:30:00	QQQ	ETF	111.12	111.27	111.0	111.04	1469896.0
2015-07-30 11:00:00	QQQ	ETF	111.03	111.51	110.91	111.47	1625033.0
2015-07-30 11:30:00	QQQ	ETF	111.46	111.77	111.46	111.74	1398378.0
2015-07-30 12:00:00	QQQ	ETF	111.76	111.97	111.67	111.9286	1143148.0
2015-07-30 12:30:00	QQQ	ETF	111.91	112.1	111.85	112.1	1042061.0
2015-07-30 13:00:00	QQQ	ETF	112.1	112.24	112.0074	112.2	1378145.0
2015-07-30 13:30:00	QQQ	ETF	112.21	112.25	111.99	112.03	883911.0

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

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