PREVIEW / etf_30min / 2015-07-01

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-07-01.parquet
  size:    396 KB
  rows:    13,439

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-01 04:00:00	SPY	ETF	206.78	207.08	206.78	207.0	6143.0
2015-07-01 04:30:00	SPY	ETF	207.01	207.72	207.0	207.62	62052.0
2015-07-01 05:00:00	SPY	ETF	207.7	208.35	207.49	208.27	280688.0
2015-07-01 05:30:00	SPY	ETF	208.25	208.27	207.67	207.7	241162.0
2015-07-01 06:00:00	SPY	ETF	207.72	207.86	207.53	207.53	43582.0
2015-07-01 06:30:00	SPY	ETF	207.55	207.91	207.51	207.72	206202.0
2015-07-01 07:00:00	SPY	ETF	207.74	207.8	207.43	207.53	192032.0
2015-07-01 07:30:00	SPY	ETF	207.54	207.57	207.4	207.48	490007.0
2015-07-01 08:00:00	SPY	ETF	207.49	208.16	205.85	207.61	1152448.0
2015-07-01 08:30:00	SPY	ETF	207.61	207.7	205.85	207.6	582892.0
2015-07-01 09:00:00	SPY	ETF	207.6	207.91	205.85	207.75	1474230.0
2015-07-01 09:30:00	SPY	ETF	207.73	207.91	207.37	207.83	16031137.0
2015-07-01 10:00:00	SPY	ETF	207.84	208.03	207.52	207.79	13126026.0
2015-07-01 10:30:00	SPY	ETF	207.795	207.84	206.95	207.33	14046238.0
2015-07-01 11:00:00	SPY	ETF	207.331	207.55	207.2	207.45	4561670.0
2015-07-01 11:30:00	SPY	ETF	207.45	207.56	207.14	207.18	4758119.0
2015-07-01 12:00:00	SPY	ETF	207.17	207.37	206.97	207.18	5193231.0
2015-07-01 12:30:00	SPY	ETF	207.17	207.24	206.78	206.85	7548016.0
2015-07-01 13:00:00	SPY	ETF	206.84	207.17	206.67	206.96	6044520.0
2015-07-01 13:30:00	SPY	ETF	206.96	207.28	206.83	206.85	4549518.0
2015-07-01 14:00:00	SPY	ETF	206.85	206.98	206.56	206.775	6321578.0
2015-07-01 14:30:00	SPY	ETF	206.78	207.04	206.69	206.945	8642128.0
2015-07-01 15:00:00	SPY	ETF	206.95	207.31	206.94	207.31	10893632.0
2015-07-01 15:30:00	SPY	ETF	207.305	207.57	207.01	207.52	17405239.0
2015-07-01 16:00:00	SPY	ETF	207.52	207.75	207.29	207.68	5591670.0
2015-07-01 16:30:00	SPY	ETF	207.7	207.8	206.0613	207.77	3771208.0
2015-07-01 17:00:00	SPY	ETF	207.76	207.76	207.73	207.75	27141.0
2015-07-01 17:30:00	SPY	ETF	207.75	207.8	207.74	207.76	66851.0
2015-07-01 18:00:00	SPY	ETF	207.76	207.77	207.64	207.65	95049.0
2015-07-01 18:30:00	SPY	ETF	207.66	207.73	207.64	207.65	77682.0
2015-07-01 19:00:00	SPY	ETF	207.65	207.65	207.62	207.63	25682.0
2015-07-01 19:30:00	SPY	ETF	207.65	207.66	207.55	207.57	16626.0
2015-07-01 04:00:00	QQQ	ETF	107.63	107.7	107.63	107.7	200.0
2015-07-01 04:30:00	QQQ	ETF	107.75	108.0	107.75	108.0	400.0
2015-07-01 05:00:00	QQQ	ETF	108.0	108.47	108.0	108.47	15000.0
2015-07-01 06:00:00	QQQ	ETF	108.15	108.15	108.15	108.15	500.0
2015-07-01 06:30:00	QQQ	ETF	108.04	108.16	108.04	108.16	8700.0
2015-07-01 07:00:00	QQQ	ETF	108.14	108.17	108.04	108.05	22373.0
2015-07-01 07:30:00	QQQ	ETF	108.07	108.07	108.0	108.03	12639.0
2015-07-01 08:00:00	QQQ	ETF	108.03	108.15	108.02	108.06	95629.0
2015-07-01 08:30:00	QQQ	ETF	108.05	108.13	107.07	108.09	43553.0
2015-07-01 09:00:00	QQQ	ETF	108.1	108.23	107.07	108.12	202309.0
2015-07-01 09:30:00	QQQ	ETF	108.13	108.3	107.93	108.27	3295747.0
2015-07-01 10:00:00	QQQ	ETF	108.28	108.3464	108.07	108.16	2117499.0
2015-07-01 10:30:00	QQQ	ETF	108.16	108.1985	107.72	107.94	2314752.0
2015-07-01 11:00:00	QQQ	ETF	107.94	108.03	107.84	107.94	1172701.0
2015-07-01 11:30:00	QQQ	ETF	107.94	107.99	107.755	107.795	616224.0
2015-07-01 12:00:00	QQQ	ETF	107.8	107.88	107.61	107.72	862864.0
2015-07-01 12:30:00	QQQ	ETF	107.71	107.77	107.53	107.55	1352090.0
2015-07-01 13:00:00	QQQ	ETF	107.55	107.732	107.46	107.63	919428.0

> showing 50 of 13,439 rows — these rows as CSV

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