PREVIEW / stock_30min / 2015-06-17

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-06-17.parquet
  size:    1.6 MB
  rows:    83,314
  symbols: 3,510

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-17 04:00:00	AAPL	Stock	31.955	31.955	31.9375	31.945	20720.0
2015-06-17 04:30:00	AAPL	Stock	31.95	31.95	31.925	31.95	7628.0
2015-06-17 06:00:00	AAPL	Stock	31.9625	31.9825	31.9425	31.9425	5260.0
2015-06-17 06:30:00	AAPL	Stock	31.95	31.95	31.8325	31.9125	20200.0
2015-06-17 07:00:00	AAPL	Stock	31.9325	31.9375	31.8675	31.9025	27128.0
2015-06-17 07:30:00	AAPL	Stock	31.9	31.925	31.875	31.8875	33404.0
2015-06-17 08:00:00	AAPL	Stock	31.8875	31.945	31.875	31.9025	159800.0
2015-06-17 08:30:00	AAPL	Stock	31.9	31.945	31.9	31.925	170972.0
2015-06-17 09:00:00	AAPL	Stock	31.93	31.9475	31.905	31.945	100436.0
2015-06-17 09:30:00	AAPL	Stock	31.93	31.97	31.8125	31.86	14315904.0
2015-06-17 10:00:00	AAPL	Stock	31.86	31.8725	31.765	31.7975	8962104.0
2015-06-17 10:30:00	AAPL	Stock	31.795	31.87	31.78	31.852	7072568.0
2015-06-17 11:00:00	AAPL	Stock	31.8475	31.87	31.7625	31.7628	6918764.0
2015-06-17 11:30:00	AAPL	Stock	31.7625	31.815	31.7575	31.8	5027712.0
2015-06-17 12:00:00	AAPL	Stock	31.8	31.8175	31.7075	31.7438	5858384.0
2015-06-17 12:30:00	AAPL	Stock	31.7425	31.75	31.6925	31.705	5337808.0
2015-06-17 13:00:00	AAPL	Stock	31.705	31.7525	31.7	31.7225	4620256.0
2015-06-17 13:30:00	AAPL	Stock	31.725	31.785	31.7128	31.7475	4905736.0
2015-06-17 14:00:00	AAPL	Stock	31.74	31.9125	31.685	31.7625	14732076.0
2015-06-17 14:30:00	AAPL	Stock	31.7638	31.9425	31.75	31.925	13746572.0
2015-06-17 15:00:00	AAPL	Stock	31.9235	31.94	31.85	31.9025	9165780.0
2015-06-17 15:30:00	AAPL	Stock	31.9025	31.9175	31.82	31.8225	10687248.0
2015-06-17 16:00:00	AAPL	Stock	31.825	31.8325	31.7475	31.78	12767632.0
2015-06-17 16:30:00	AAPL	Stock	31.7775	31.825	31.7475	31.7525	253656.0
2015-06-17 17:00:00	AAPL	Stock	31.75	31.825	31.7325	31.825	110908.0
2015-06-17 17:30:00	AAPL	Stock	31.7375	31.76	31.735	31.75	34560.0
2015-06-17 18:00:00	AAPL	Stock	31.75	31.75	31.7375	31.7375	9320.0
2015-06-17 18:30:00	AAPL	Stock	31.745	31.75	31.7375	31.74	13000.0
2015-06-17 19:00:00	AAPL	Stock	31.75	31.75	31.7375	31.7425	21976.0
2015-06-17 19:30:00	AAPL	Stock	31.7375	31.7508	31.7375	31.7425	80732.0
2015-06-17 07:30:00	MSFT	Stock	45.9	45.9	45.9	45.9	100.0
2015-06-17 08:30:00	MSFT	Stock	46.01	46.01	45.93	45.93	402.0
2015-06-17 09:00:00	MSFT	Stock	45.83	45.96	45.73	45.73	24246.0
2015-06-17 09:30:00	MSFT	Stock	45.73	45.92	45.73	45.84	2681223.0
2015-06-17 10:00:00	MSFT	Stock	45.84	45.86	45.76	45.82	1549558.0
2015-06-17 10:30:00	MSFT	Stock	45.81	45.953	45.805	45.95	1460156.0
2015-06-17 11:00:00	MSFT	Stock	45.95	45.99	45.66	45.7	1713578.0
2015-06-17 11:30:00	MSFT	Stock	45.69	45.79	45.65	45.75	1408202.0
2015-06-17 12:00:00	MSFT	Stock	45.75	45.76	45.53	45.58	1385960.0
2015-06-17 12:30:00	MSFT	Stock	45.58	45.589	45.37	45.47	1462794.0
2015-06-17 13:00:00	MSFT	Stock	45.465	45.49	45.36	45.46	1052438.0
2015-06-17 13:30:00	MSFT	Stock	45.45	45.6	45.43	45.55	1084943.0
2015-06-17 14:00:00	MSFT	Stock	45.54	45.9	45.4	45.62	2345718.0
2015-06-17 14:30:00	MSFT	Stock	45.615	46.07	45.61	45.98	2543779.0
2015-06-17 15:00:00	MSFT	Stock	45.99	46.01	45.86	45.93	1621886.0
2015-06-17 15:30:00	MSFT	Stock	45.93	46.01	45.83	45.97	3676170.0
2015-06-17 16:00:00	MSFT	Stock	45.97	45.97	45.8	45.8	2995596.0
2015-06-17 16:30:00	MSFT	Stock	45.8	45.8	45.61	45.8	1505.0
2015-06-17 17:30:00	MSFT	Stock	45.78	45.93	45.78	45.93	6500.0
2015-06-17 18:00:00	MSFT	Stock	45.9	45.9	45.9	45.9	114.0

> showing 50 of 83,314 rows — these rows as CSV

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