PREVIEW / stock_30min / 2016-11-10

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-11-10.parquet
  size:    1.7 MB
  rows:    85,542
  symbols: 3,198

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
2016-11-10 04:00:00	AAPL	Stock	27.885	28.0	27.885	28.0	12472.0
2016-11-10 04:30:00	AAPL	Stock	28.0	28.0	27.985	27.9875	1200.0
2016-11-10 05:00:00	AAPL	Stock	27.9375	27.9375	27.9375	27.9375	400.0
2016-11-10 05:30:00	AAPL	Stock	27.9625	27.9675	27.9425	27.9425	3972.0
2016-11-10 06:00:00	AAPL	Stock	27.9625	27.9625	27.8775	27.8775	5728.0
2016-11-10 06:30:00	AAPL	Stock	27.935	27.9375	27.9325	27.935	18484.0
2016-11-10 07:00:00	AAPL	Stock	27.935	27.9475	27.8625	27.8625	59888.0
2016-11-10 07:30:00	AAPL	Stock	27.8625	27.87	27.7175	27.75	178304.0
2016-11-10 08:00:00	AAPL	Stock	27.7475	27.925	27.72	27.75	387632.0
2016-11-10 08:30:00	AAPL	Stock	27.745	27.75	27.7125	27.7425	240940.0
2016-11-10 09:00:00	AAPL	Stock	27.7425	27.8	27.675	27.7725	414684.0
2016-11-10 09:30:00	AAPL	Stock	27.77	27.7725	27.5312	27.5725	20493968.0
2016-11-10 10:00:00	AAPL	Stock	27.5775	27.65	26.93	26.9445	28229544.0
2016-11-10 10:30:00	AAPL	Stock	26.945	27.0775	26.4575	26.745	40224036.0
2016-11-10 11:00:00	AAPL	Stock	26.745	26.9805	26.6975	26.9125	20606296.0
2016-11-10 11:30:00	AAPL	Stock	26.9175	27.005	26.7925	26.85	13009800.0
2016-11-10 12:00:00	AAPL	Stock	26.8475	26.9825	26.795	26.8	9677120.0
2016-11-10 12:30:00	AAPL	Stock	26.7975	27.0175	26.775	27.0142	9879256.0
2016-11-10 13:00:00	AAPL	Stock	27.015	27.1325	26.9538	27.0325	10002540.0
2016-11-10 13:30:00	AAPL	Stock	27.031	27.2	27.031	27.1175	7990812.0
2016-11-10 14:00:00	AAPL	Stock	27.1168	27.1925	27.08	27.1575	7253156.0
2016-11-10 14:30:00	AAPL	Stock	27.1525	27.185	27.0475	27.1475	6975280.0
2016-11-10 15:00:00	AAPL	Stock	27.1475	27.17	27.0475	27.0682	6569316.0
2016-11-10 15:30:00	AAPL	Stock	27.069	27.069	26.8488	26.9475	20673852.0
2016-11-10 16:00:00	AAPL	Stock	26.9475	27.08	26.885	26.915	8067852.0
2016-11-10 16:30:00	AAPL	Stock	26.925	26.9475	26.9	26.9175	52920.0
2016-11-10 17:00:00	AAPL	Stock	26.9175	26.9525	26.9025	26.9025	98196.0
2016-11-10 17:30:00	AAPL	Stock	26.9	26.9625	26.9	26.94	23588.0
2016-11-10 18:00:00	AAPL	Stock	26.96	26.97	26.915	26.925	43720.0
2016-11-10 18:30:00	AAPL	Stock	26.9375	26.9375	26.9275	26.9275	19200.0
2016-11-10 19:00:00	AAPL	Stock	26.9275	26.9475	26.9275	26.9375	12396.0
2016-11-10 19:30:00	AAPL	Stock	26.9375	26.9375	26.925	26.925	26212.0
2016-11-10 04:00:00	MSFT	Stock	60.87	60.87	60.87	60.87	2075.0
2016-11-10 05:00:00	MSFT	Stock	60.75	60.75	60.75	60.75	100.0
2016-11-10 06:00:00	MSFT	Stock	60.71	60.71	60.71	60.71	304.0
2016-11-10 06:30:00	MSFT	Stock	60.71	60.71	60.71	60.71	490.0
2016-11-10 07:30:00	MSFT	Stock	60.41	60.45	60.41	60.45	503.0
2016-11-10 08:00:00	MSFT	Stock	60.6	60.67	60.4	60.4	3548.0
2016-11-10 08:30:00	MSFT	Stock	60.5	60.5	60.4	60.4	3700.0
2016-11-10 09:00:00	MSFT	Stock	60.4	60.5	60.39	60.44	35221.0
2016-11-10 09:30:00	MSFT	Stock	60.48	60.49	59.664	59.665	4942935.0
2016-11-10 10:00:00	MSFT	Stock	59.665	59.8	58.55	58.58	5423320.0
2016-11-10 10:30:00	MSFT	Stock	58.59	58.77	57.63	57.927	8912879.0
2016-11-10 11:00:00	MSFT	Stock	57.92	58.7	57.9	58.56	4882915.0
2016-11-10 11:30:00	MSFT	Stock	58.56	58.7	58.23	58.335	4340271.0
2016-11-10 12:00:00	MSFT	Stock	58.33	58.55	58.21	58.25	2994712.0
2016-11-10 12:30:00	MSFT	Stock	58.25	58.77	58.23	58.76	2604708.0
2016-11-10 13:00:00	MSFT	Stock	58.767	58.95	58.67	58.79	3080574.0
2016-11-10 13:30:00	MSFT	Stock	58.785	59.18	58.75	59.125	2463412.0
2016-11-10 14:00:00	MSFT	Stock	59.125	59.37	59.1	59.27	2218196.0

> showing 50 of 85,542 rows — these rows as CSV

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