PREVIEW / stock_30min / 2017-01-25

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-01-25.parquet
  size:    1.6 MB
  rows:    82,586
  symbols: 3,128

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
2017-01-25 04:00:00	AAPL	Stock	30.025	30.065	30.025	30.065	1488.0
2017-01-25 05:00:00	AAPL	Stock	30.1	30.11	30.1	30.11	5980.0
2017-01-25 05:30:00	AAPL	Stock	30.065	30.0925	30.0625	30.0925	7440.0
2017-01-25 06:00:00	AAPL	Stock	30.0875	30.095	30.0875	30.095	6000.0
2017-01-25 06:30:00	AAPL	Stock	30.09	30.09	30.09	30.09	400.0
2017-01-25 07:00:00	AAPL	Stock	30.09	30.1	30.09	30.09	21124.0
2017-01-25 07:30:00	AAPL	Stock	30.0875	30.095	30.0775	30.09	22548.0
2017-01-25 08:00:00	AAPL	Stock	30.095	30.095	30.0575	30.065	89700.0
2017-01-25 08:30:00	AAPL	Stock	30.0625	30.095	30.0425	30.095	113348.0
2017-01-25 09:00:00	AAPL	Stock	30.0875	30.11	30.0625	30.11	344440.0
2017-01-25 09:30:00	AAPL	Stock	30.105	30.31	30.07	30.282	24290324.0
2017-01-25 10:00:00	AAPL	Stock	30.2825	30.39	30.255	30.3712	11842048.0
2017-01-25 10:30:00	AAPL	Stock	30.372	30.4225	30.345	30.3662	9080016.0
2017-01-25 11:00:00	AAPL	Stock	30.3675	30.3938	30.335	30.3438	6140000.0
2017-01-25 11:30:00	AAPL	Stock	30.345	30.3462	30.285	30.3215	5641144.0
2017-01-25 12:00:00	AAPL	Stock	30.32	30.35	30.31	30.3412	4256848.0
2017-01-25 12:30:00	AAPL	Stock	30.3425	30.4125	30.341	30.405	4694508.0
2017-01-25 13:00:00	AAPL	Stock	30.405	30.435	30.395	30.4325	4015896.0
2017-01-25 13:30:00	AAPL	Stock	30.435	30.5	30.42	30.4975	7261732.0
2017-01-25 14:00:00	AAPL	Stock	30.4962	30.5	30.435	30.46	6225796.0
2017-01-25 14:30:00	AAPL	Stock	30.46	30.4925	30.4225	30.485	5486472.0
2017-01-25 15:00:00	AAPL	Stock	30.485	30.525	30.465	30.4912	9621648.0
2017-01-25 15:30:00	AAPL	Stock	30.49	30.5	30.4525	30.475	10964864.0
2017-01-25 16:00:00	AAPL	Stock	30.48	30.4825	30.45	30.4575	8243788.0
2017-01-25 16:30:00	AAPL	Stock	30.465	30.475	30.465	30.475	107264.0
2017-01-25 17:00:00	AAPL	Stock	30.475	30.475	30.45	30.455	47412.0
2017-01-25 17:30:00	AAPL	Stock	30.455	30.47	30.45	30.47	24804.0
2017-01-25 18:00:00	AAPL	Stock	30.4625	30.4625	30.4625	30.4625	1080.0
2017-01-25 18:30:00	AAPL	Stock	30.465	30.465	30.465	30.465	1000.0
2017-01-25 19:00:00	AAPL	Stock	30.45	30.4625	30.45	30.46	7780.0
2017-01-25 19:30:00	AAPL	Stock	30.4525	30.4625	30.45	30.4625	48364.0
2017-01-25 06:00:00	MSFT	Stock	63.77	63.77	63.77	63.77	120.0
2017-01-25 07:00:00	MSFT	Stock	63.9	64.06	63.9	64.06	1800.0
2017-01-25 07:30:00	MSFT	Stock	64.06	64.06	63.96	64.04	1925.0
2017-01-25 08:00:00	MSFT	Stock	64.0	64.0	63.9	63.99	12525.0
2017-01-25 08:30:00	MSFT	Stock	63.98	64.0	63.52	64.0	34384.0
2017-01-25 09:00:00	MSFT	Stock	63.91	64.1	63.91	64.01	37699.0
2017-01-25 09:30:00	MSFT	Stock	63.95	64.1	63.49	63.68	3433756.0
2017-01-25 10:00:00	MSFT	Stock	63.68	63.82	63.565	63.64	1670098.0
2017-01-25 10:30:00	MSFT	Stock	63.64	63.75	63.59	63.73	1061311.0
2017-01-25 11:00:00	MSFT	Stock	63.73	63.88	63.7	63.75	1561477.0
2017-01-25 11:30:00	MSFT	Stock	63.74	63.82	63.64	63.82	1001431.0
2017-01-25 12:00:00	MSFT	Stock	63.82	63.82	63.735	63.765	761005.0
2017-01-25 12:30:00	MSFT	Stock	63.77	63.8	63.7	63.776	712205.0
2017-01-25 13:00:00	MSFT	Stock	63.77	63.82	63.76	63.8	737777.0
2017-01-25 13:30:00	MSFT	Stock	63.81	63.84	63.76	63.76	1058112.0
2017-01-25 14:00:00	MSFT	Stock	63.76	63.77	63.66	63.67	990485.0
2017-01-25 14:30:00	MSFT	Stock	63.68	63.68	63.52	63.525	1166520.0
2017-01-25 15:00:00	MSFT	Stock	63.53	63.59	63.45	63.56	1701305.0
2017-01-25 15:30:00	MSFT	Stock	63.565	63.72	63.54	63.68	3800736.0

> showing 50 of 82,586 rows — these rows as CSV

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