PREVIEW / etf_30min / 2015-05-29

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-05-29.parquet
  size:    373 KB
  rows:    12,458

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-05-29 04:00:00	SPY	ETF	211.89	212.4	211.76	212.06	12065.0
2015-05-29 04:30:00	SPY	ETF	211.94	212.1	211.94	212.08	650.0
2015-05-29 05:00:00	SPY	ETF	212.06	212.06	211.88	211.95	15205.0
2015-05-29 05:30:00	SPY	ETF	211.89	212.06	211.88	212.04	41593.0
2015-05-29 06:00:00	SPY	ETF	212.15	212.54	212.13	212.54	15414.0
2015-05-29 06:30:00	SPY	ETF	212.57	212.75	212.56	212.56	60851.0
2015-05-29 07:00:00	SPY	ETF	212.57	212.63	212.36	212.45	32603.0
2015-05-29 07:30:00	SPY	ETF	212.45	212.5	212.36	212.42	117954.0
2015-05-29 08:00:00	SPY	ETF	212.45	212.66	212.17	212.37	435379.0
2015-05-29 08:30:00	SPY	ETF	212.35	212.55	212.15	212.19	440079.0
2015-05-29 09:00:00	SPY	ETF	212.2	212.41	212.15	212.39	296697.0
2015-05-29 09:30:00	SPY	ETF	212.38	212.43	211.82	212.065	9070090.0
2015-05-29 10:00:00	SPY	ETF	212.08	212.16	211.69	211.71	6351950.0
2015-05-29 10:30:00	SPY	ETF	211.72	211.735	210.82	211.13	13136749.0
2015-05-29 11:00:00	SPY	ETF	211.12	211.39	210.92	210.94	7623899.0
2015-05-29 11:30:00	SPY	ETF	210.94	211.58	210.86	211.48	8195861.0
2015-05-29 12:00:00	SPY	ETF	211.49	211.75	211.4	211.74	4509815.0
2015-05-29 12:30:00	SPY	ETF	211.74	211.955	211.7	211.71	3364735.0
2015-05-29 13:00:00	SPY	ETF	211.71	212.07	211.63	212.045	3689886.0
2015-05-29 13:30:00	SPY	ETF	212.05	212.1	211.76	211.79	2879357.0
2015-05-29 14:00:00	SPY	ETF	211.79	211.82	211.19	211.275	6554608.0
2015-05-29 14:30:00	SPY	ETF	211.28	211.36	210.92	211.175	8875115.0
2015-05-29 15:00:00	SPY	ETF	211.17	211.59	211.12	211.53	8734859.0
2015-05-29 15:30:00	SPY	ETF	211.54	211.66	211.09	211.1	18554769.0
2015-05-29 16:00:00	SPY	ETF	211.09	212.4558	210.93	211.35	13625719.0
2015-05-29 16:30:00	SPY	ETF	211.35	211.37	211.13	211.31	4783869.0
2015-05-29 17:00:00	SPY	ETF	211.33	211.35	211.19	211.2	652367.0
2015-05-29 17:30:00	SPY	ETF	211.18	211.23	211.14	211.14	1536517.0
2015-05-29 18:00:00	SPY	ETF	211.16	211.18	211.12	211.17	18045.0
2015-05-29 18:30:00	SPY	ETF	211.16	211.18	211.15	211.18	4104.0
2015-05-29 19:00:00	SPY	ETF	211.18	211.19	211.16	211.17	6710.0
2015-05-29 19:30:00	SPY	ETF	211.18	211.21	211.18	211.19	10821.0
2015-05-29 04:00:00	QQQ	ETF	110.52	110.52	110.22	110.22	7250.0
2015-05-29 04:30:00	QQQ	ETF	110.29	110.29	110.29	110.29	14950.0
2015-05-29 05:30:00	QQQ	ETF	110.28	110.38	110.28	110.38	4300.0
2015-05-29 06:30:00	QQQ	ETF	110.79	110.84	110.71	110.72	4600.0
2015-05-29 07:00:00	QQQ	ETF	110.73	110.73	110.69	110.69	1471.0
2015-05-29 07:30:00	QQQ	ETF	110.68	110.7	110.63	110.63	7500.0
2015-05-29 08:00:00	QQQ	ETF	110.659	110.66	110.53	110.57	32956.0
2015-05-29 08:30:00	QQQ	ETF	110.55	110.65	110.47	110.52	63277.0
2015-05-29 09:00:00	QQQ	ETF	110.51	110.64	110.5	110.63	45209.0
2015-05-29 09:30:00	QQQ	ETF	110.63	110.79	110.47	110.63	2179901.0
2015-05-29 10:00:00	QQQ	ETF	110.631	110.71	110.28	110.292	1766332.0
2015-05-29 10:30:00	QQQ	ETF	110.3	110.34	109.79	109.99	2168951.0
2015-05-29 11:00:00	QQQ	ETF	109.99	110.2	109.94	109.98	1764230.0
2015-05-29 11:30:00	QQQ	ETF	109.98	110.34	109.95	110.27	997073.0
2015-05-29 12:00:00	QQQ	ETF	110.28	110.455	110.27	110.44	827790.0
2015-05-29 12:30:00	QQQ	ETF	110.45	110.6	110.44	110.47	898385.0
2015-05-29 13:00:00	QQQ	ETF	110.49	110.64	110.45	110.63	633937.0
2015-05-29 13:30:00	QQQ	ETF	110.63	110.65	110.4	110.43	577822.0

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

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