PREVIEW / stock_30min / 2016-08-26

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-26.parquet
  size:    1.6 MB
  rows:    80,006
  symbols: 3,246

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-08-26 04:00:00	AAPL	Stock	26.9525	26.9525	26.9525	26.9525	1600.0
2016-08-26 04:30:00	AAPL	Stock	26.905	26.905	26.905	26.905	400.0
2016-08-26 05:30:00	AAPL	Stock	26.9025	26.9025	26.9	26.9	1600.0
2016-08-26 06:00:00	AAPL	Stock	26.8975	26.8975	26.8975	26.8975	400.0
2016-08-26 07:00:00	AAPL	Stock	26.8575	26.875	26.8575	26.87	4200.0
2016-08-26 07:30:00	AAPL	Stock	26.8675	26.8675	26.8375	26.8375	7720.0
2016-08-26 08:00:00	AAPL	Stock	26.8375	26.845	26.825	26.825	6256.0
2016-08-26 08:30:00	AAPL	Stock	26.8275	26.8625	26.825	26.85	48264.0
2016-08-26 09:00:00	AAPL	Stock	26.86	26.875	26.8125	26.8575	121496.0
2016-08-26 09:30:00	AAPL	Stock	26.86	26.9725	26.8025	26.805	11656648.0
2016-08-26 10:00:00	AAPL	Stock	26.8025	26.9875	26.7575	26.96	13214260.0
2016-08-26 10:30:00	AAPL	Stock	26.9622	26.9725	26.885	26.8912	6282180.0
2016-08-26 11:00:00	AAPL	Stock	26.8925	26.92	26.835	26.9052	4989652.0
2016-08-26 11:30:00	AAPL	Stock	26.9075	26.9125	26.735	26.76	6618484.0
2016-08-26 12:00:00	AAPL	Stock	26.7605	26.7605	26.5775	26.6825	12912352.0
2016-08-26 12:30:00	AAPL	Stock	26.6825	26.77	26.64	26.7425	5462300.0
2016-08-26 13:00:00	AAPL	Stock	26.74	26.7825	26.68	26.7238	4245092.0
2016-08-26 13:30:00	AAPL	Stock	26.7235	26.735	26.6708	26.69	3303136.0
2016-08-26 14:00:00	AAPL	Stock	26.6925	26.7225	26.63	26.6575	5107476.0
2016-08-26 14:30:00	AAPL	Stock	26.6575	26.699	26.64	26.6725	4760008.0
2016-08-26 15:00:00	AAPL	Stock	26.6725	26.74	26.6562	26.7278	5379696.0
2016-08-26 15:30:00	AAPL	Stock	26.73	26.775	26.725	26.735	11239364.0
2016-08-26 16:00:00	AAPL	Stock	26.735	26.8932	26.735	26.7425	7773256.0
2016-08-26 16:30:00	AAPL	Stock	26.75	26.7525	26.74	26.7475	17860.0
2016-08-26 17:00:00	AAPL	Stock	26.7375	26.745	26.73	26.73	41372.0
2016-08-26 18:00:00	AAPL	Stock	26.73	26.7325	26.725	26.7325	5868.0
2016-08-26 18:30:00	AAPL	Stock	26.725	26.725	26.725	26.725	2000.0
2016-08-26 19:00:00	AAPL	Stock	26.725	26.7325	26.72	26.725	11500.0
2016-08-26 19:30:00	AAPL	Stock	26.725	26.725	26.725	26.725	4280.0
2016-08-26 05:00:00	MSFT	Stock	58.1	58.1	58.1	58.1	206.0
2016-08-26 07:30:00	MSFT	Stock	58.1	58.1	58.1	58.1	197.0
2016-08-26 08:00:00	MSFT	Stock	58.1	58.1	58.1	58.1	100.0
2016-08-26 08:30:00	MSFT	Stock	58.15	58.16	58.1	58.16	1668.0
2016-08-26 09:00:00	MSFT	Stock	58.14	58.33	58.1	58.27	10821.0
2016-08-26 09:30:00	MSFT	Stock	58.28	58.6	58.25	58.34	2663882.0
2016-08-26 10:00:00	MSFT	Stock	58.34	58.7	58.09	58.62	1832955.0
2016-08-26 10:30:00	MSFT	Stock	58.63	58.645	58.46	58.58	855322.0
2016-08-26 11:00:00	MSFT	Stock	58.57	58.58	58.44	58.5	765794.0
2016-08-26 11:30:00	MSFT	Stock	58.5	58.52	58.11	58.125	1485362.0
2016-08-26 12:00:00	MSFT	Stock	58.12	58.125	57.81	57.915	1845860.0
2016-08-26 12:30:00	MSFT	Stock	57.91	58.0	57.84	57.93	827113.0
2016-08-26 13:00:00	MSFT	Stock	57.94	58.01	57.855	57.92	809066.0
2016-08-26 13:30:00	MSFT	Stock	57.93	57.95	57.78	57.82	857110.0
2016-08-26 14:00:00	MSFT	Stock	57.82	57.9	57.69	57.72	1265127.0
2016-08-26 14:30:00	MSFT	Stock	57.72	57.86	57.7	57.835	828699.0
2016-08-26 15:00:00	MSFT	Stock	57.83	57.99	57.81	57.97	1136006.0
2016-08-26 15:30:00	MSFT	Stock	57.98	58.11	57.97	58.04	3015747.0
2016-08-26 16:00:00	MSFT	Stock	58.04	58.07	57.94	58.0	1677679.0
2016-08-26 16:30:00	MSFT	Stock	57.99	58.0	57.99	58.0	1060.0
2016-08-26 17:00:00	MSFT	Stock	58.0	58.03	58.0	58.03	615.0

> showing 50 of 80,006 rows — these rows as CSV

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