PREVIEW / stock_30min / 2015-06-12

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-06-12.parquet
  size:    1.6 MB
  rows:    81,866
  symbols: 3,486

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-12 04:00:00	AAPL	Stock	32.1875	32.1975	32.055	32.0625	2132.0
2015-06-12 04:30:00	AAPL	Stock	32.0625	32.0625	32.0375	32.0375	3840.0
2015-06-12 05:30:00	AAPL	Stock	32.0725	32.12	32.0725	32.12	5108.0
2015-06-12 06:00:00	AAPL	Stock	32.135	32.185	32.135	32.1625	6900.0
2015-06-12 06:30:00	AAPL	Stock	32.125	32.1375	32.1025	32.1225	8604.0
2015-06-12 07:00:00	AAPL	Stock	32.1075	32.1075	32.09	32.0925	31792.0
2015-06-12 07:30:00	AAPL	Stock	32.0925	32.0925	32.05	32.075	65024.0
2015-06-12 08:00:00	AAPL	Stock	32.09	32.125	32.0525	32.1	252504.0
2015-06-12 08:30:00	AAPL	Stock	32.0925	32.1	32.0675	32.0675	154876.0
2015-06-12 09:00:00	AAPL	Stock	32.0725	32.0825	32.0275	32.0375	320928.0
2015-06-12 09:30:00	AAPL	Stock	32.04	32.0525	31.925	31.98	21023912.0
2015-06-12 10:00:00	AAPL	Stock	31.9825	32.0825	31.957	31.9845	11946160.0
2015-06-12 10:30:00	AAPL	Stock	31.9825	31.995	31.8575	31.866	13290816.0
2015-06-12 11:00:00	AAPL	Stock	31.86	32.01	31.8475	31.9625	10053824.0
2015-06-12 11:30:00	AAPL	Stock	31.965	31.975	31.8875	31.9025	5676904.0
2015-06-12 12:00:00	AAPL	Stock	31.9025	31.9175	31.8575	31.9075	6241404.0
2015-06-12 12:30:00	AAPL	Stock	31.9075	31.915	31.8802	31.8925	3398604.0
2015-06-12 13:00:00	AAPL	Stock	31.8925	31.9475	31.8875	31.905	5292928.0
2015-06-12 13:30:00	AAPL	Stock	31.9032	31.94	31.8775	31.9175	5423724.0
2015-06-12 14:00:00	AAPL	Stock	31.9175	31.92	31.8525	31.8675	4940792.0
2015-06-12 14:30:00	AAPL	Stock	31.8662	31.8725	31.82	31.8225	6388156.0
2015-06-12 15:00:00	AAPL	Stock	31.8225	31.91	31.8125	31.8962	6852916.0
2015-06-12 15:30:00	AAPL	Stock	31.8975	31.925	31.7775	31.79	22267740.0
2015-06-12 16:00:00	AAPL	Stock	31.79	31.8025	31.7875	31.8	14915612.0
2015-06-12 16:30:00	AAPL	Stock	31.7975	31.8125	31.7925	31.805	65516.0
2015-06-12 17:00:00	AAPL	Stock	31.8	31.805	31.7975	31.7975	75176.0
2015-06-12 17:30:00	AAPL	Stock	31.795	31.8025	31.795	31.8	17708.0
2015-06-12 18:00:00	AAPL	Stock	31.8	31.8	31.795	31.8	10600.0
2015-06-12 18:30:00	AAPL	Stock	31.795	31.8	31.7925	31.795	42520.0
2015-06-12 19:00:00	AAPL	Stock	31.7975	31.8025	31.7925	31.8025	63928.0
2015-06-12 19:30:00	AAPL	Stock	31.8025	31.8075	31.795	31.8075	83472.0
2015-06-12 07:00:00	MSFT	Stock	46.55	46.55	46.55	46.55	400.0
2015-06-12 07:30:00	MSFT	Stock	46.24	46.24	46.24	46.24	6355.0
2015-06-12 08:00:00	MSFT	Stock	46.54	46.54	46.22	46.22	5238.0
2015-06-12 08:30:00	MSFT	Stock	46.23	46.23	46.19	46.19	2100.0
2015-06-12 09:00:00	MSFT	Stock	46.2	46.22	46.12	46.16	12323.0
2015-06-12 09:30:00	MSFT	Stock	46.22	46.38	46.08	46.27	4063187.0
2015-06-12 10:00:00	MSFT	Stock	46.27	46.47	46.25	46.29	2337990.0
2015-06-12 10:30:00	MSFT	Stock	46.29	46.32	46.06	46.1	2134599.0
2015-06-12 11:00:00	MSFT	Stock	46.09	46.25	46.05	46.18	1698545.0
2015-06-12 11:30:00	MSFT	Stock	46.18	46.22	45.94	45.96	1143263.0
2015-06-12 12:00:00	MSFT	Stock	45.96	46.01	45.9	45.98	870963.0
2015-06-12 12:30:00	MSFT	Stock	45.98	46.04	45.93	45.96	673740.0
2015-06-12 13:00:00	MSFT	Stock	45.95	46.03	45.93	46.03	711848.0
2015-06-12 13:30:00	MSFT	Stock	46.03	46.08	45.995	46.05	935026.0
2015-06-12 14:00:00	MSFT	Stock	46.06	46.076	45.99	46.035	594835.0
2015-06-12 14:30:00	MSFT	Stock	46.035	46.035	45.92	45.93	808026.0
2015-06-12 15:00:00	MSFT	Stock	45.93	46.07	45.915	46.055	1170815.0
2015-06-12 15:30:00	MSFT	Stock	46.06	46.11	45.97	45.97	2017024.0
2015-06-12 16:00:00	MSFT	Stock	45.97	46.0	45.97	46.0	3250836.0

> showing 50 of 81,866 rows — these rows as CSV

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