PREVIEW / etf_30min / 2015-06-24

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-06-24.parquet
  size:    376 KB
  rows:    12,785

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-06-24 04:00:00	SPY	ETF	212.0	212.0	211.95	211.95	2400.0
2015-06-24 04:30:00	SPY	ETF	211.95	211.95	211.8	211.86	5498.0
2015-06-24 05:00:00	SPY	ETF	211.8	212.0	211.8	212.0	4418.0
2015-06-24 05:30:00	SPY	ETF	211.87	211.87	211.3	211.3	54513.0
2015-06-24 06:00:00	SPY	ETF	211.37	211.72	211.36	211.6	52249.0
2015-06-24 06:30:00	SPY	ETF	211.6	211.69	211.5	211.69	32517.0
2015-06-24 07:00:00	SPY	ETF	211.69	211.79	211.61	211.69	50660.0
2015-06-24 07:30:00	SPY	ETF	211.65	211.74	211.6	211.65	71301.0
2015-06-24 08:00:00	SPY	ETF	211.65	211.97	211.48	211.57	432497.0
2015-06-24 08:30:00	SPY	ETF	211.6	211.65	211.39	211.6	369659.0
2015-06-24 09:00:00	SPY	ETF	211.59	211.76	211.59	211.72	233547.0
2015-06-24 09:30:00	SPY	ETF	211.72	211.92	211.51	211.75	5709763.0
2015-06-24 10:00:00	SPY	ETF	211.74	212.07	211.64	212.03	4905755.0
2015-06-24 10:30:00	SPY	ETF	212.04	212.17	211.81	211.87	5863482.0
2015-06-24 11:00:00	SPY	ETF	211.87	211.88	211.43	211.61	5137637.0
2015-06-24 11:30:00	SPY	ETF	211.6	211.66	211.36	211.43	4936049.0
2015-06-24 12:00:00	SPY	ETF	211.44	211.44	211.1	211.18	6179976.0
2015-06-24 12:30:00	SPY	ETF	211.175	211.27	210.95	211.07	3205753.0
2015-06-24 13:00:00	SPY	ETF	211.07	211.19	210.68	210.76	7662563.0
2015-06-24 13:30:00	SPY	ETF	210.7634	210.85	210.61	210.8336	4677808.0
2015-06-24 14:00:00	SPY	ETF	210.84	211.3858	210.58	210.67	4258654.0
2015-06-24 14:30:00	SPY	ETF	210.66	211.0	210.63	210.87	5197183.0
2015-06-24 15:00:00	SPY	ETF	210.88	210.97	210.63	210.8962	5831108.0
2015-06-24 15:30:00	SPY	ETF	210.9	210.96	210.48	210.49	13475018.0
2015-06-24 16:00:00	SPY	ETF	210.48	211.9506	210.36	210.42	5210066.0
2015-06-24 16:30:00	SPY	ETF	210.42	211.769	210.42	210.51	5982024.0
2015-06-24 17:00:00	SPY	ETF	210.51	211.22	210.5	210.54	1579272.0
2015-06-24 17:30:00	SPY	ETF	210.54	210.56	210.52	210.54	40700.0
2015-06-24 18:00:00	SPY	ETF	210.55	210.64	210.55	210.61	57913.0
2015-06-24 18:30:00	SPY	ETF	210.64	210.67	210.62	210.62	32835.0
2015-06-24 19:00:00	SPY	ETF	210.63	210.65	210.62	210.64	10860.0
2015-06-24 19:30:00	SPY	ETF	210.63	210.65	210.6	210.65	17560.0
2015-06-24 04:00:00	QQQ	ETF	110.74	110.79	110.73	110.73	1070.0
2015-06-24 04:30:00	QQQ	ETF	110.73	110.73	110.73	110.73	21250.0
2015-06-24 05:30:00	QQQ	ETF	110.56	110.56	110.46	110.46	2100.0
2015-06-24 06:00:00	QQQ	ETF	110.44	110.44	110.44	110.44	400.0
2015-06-24 07:00:00	QQQ	ETF	110.62	110.67	110.58	110.61	44899.0
2015-06-24 07:30:00	QQQ	ETF	110.63	110.65	110.63	110.65	601.0
2015-06-24 08:00:00	QQQ	ETF	110.61	110.62	110.53	110.58	37186.0
2015-06-24 08:30:00	QQQ	ETF	110.59	110.59	110.5	110.55	47821.0
2015-06-24 09:00:00	QQQ	ETF	110.58	110.67	110.58	110.67	42573.0
2015-06-24 09:30:00	QQQ	ETF	110.66	110.82	110.52	110.7997	1591926.0
2015-06-24 10:00:00	QQQ	ETF	110.79	111.04	110.76	111.01	1111391.0
2015-06-24 10:30:00	QQQ	ETF	111.01	111.13	110.99	111.0	1136693.0
2015-06-24 11:00:00	QQQ	ETF	111.0	111.0	110.76	110.86	876611.0
2015-06-24 11:30:00	QQQ	ETF	110.85	110.86	110.7	110.75	668815.0
2015-06-24 12:00:00	QQQ	ETF	110.74	110.74	110.51	110.55	1270424.0
2015-06-24 12:30:00	QQQ	ETF	110.55	110.65	110.47	110.55	507737.0
2015-06-24 13:00:00	QQQ	ETF	110.55	110.64	110.33	110.3686	979199.0
2015-06-24 13:30:00	QQQ	ETF	110.36	110.41	110.24	110.3774	724545.0

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

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