PREVIEW / stock_30min / 2017-06-06

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-06-06.parquet
  size:    1.6 MB
  rows:    81,026
  symbols: 3,038

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-06-06 05:00:00	AAPL	Stock	38.5	38.5	38.5	38.5	3632.0
2017-06-06 05:30:00	AAPL	Stock	38.5225	38.5225	38.5225	38.5225	1312.0
2017-06-06 06:00:00	AAPL	Stock	38.5225	38.525	38.5225	38.525	4400.0
2017-06-06 06:30:00	AAPL	Stock	38.5025	38.5225	38.4625	38.4825	22092.0
2017-06-06 07:00:00	AAPL	Stock	38.495	38.5	38.4	38.425	50816.0
2017-06-06 07:30:00	AAPL	Stock	38.425	38.45	38.375	38.42	51732.0
2017-06-06 08:00:00	AAPL	Stock	38.42	38.475	38.32	38.3525	97420.0
2017-06-06 08:30:00	AAPL	Stock	38.35	38.425	38.35	38.4	77308.0
2017-06-06 09:00:00	AAPL	Stock	38.41	38.4725	38.4	38.4725	261524.0
2017-06-06 09:30:00	AAPL	Stock	38.4725	38.7025	38.445	38.4825	15402256.0
2017-06-06 10:00:00	AAPL	Stock	38.485	38.65	38.45	38.6352	7253572.0
2017-06-06 10:30:00	AAPL	Stock	38.635	38.685	38.6225	38.6585	6109820.0
2017-06-06 11:00:00	AAPL	Stock	38.6562	38.6925	38.545	38.5718	4658088.0
2017-06-06 11:30:00	AAPL	Stock	38.5737	38.6475	38.5575	38.591	3583828.0
2017-06-06 12:00:00	AAPL	Stock	38.5908	38.6213	38.5725	38.6075	2949492.0
2017-06-06 12:30:00	AAPL	Stock	38.6075	38.7	38.595	38.6775	3408944.0
2017-06-06 13:00:00	AAPL	Stock	38.6763	38.6875	38.63	38.6525	2395940.0
2017-06-06 13:30:00	AAPL	Stock	38.6538	38.7	38.625	38.6975	2723112.0
2017-06-06 14:00:00	AAPL	Stock	38.6985	38.7925	38.685	38.7775	6546108.0
2017-06-06 14:30:00	AAPL	Stock	38.78	38.935	38.77	38.915	7202772.0
2017-06-06 15:00:00	AAPL	Stock	38.916	38.9525	38.6725	38.71	10102308.0
2017-06-06 15:30:00	AAPL	Stock	38.7102	38.715	38.5475	38.6125	13297280.0
2017-06-06 16:00:00	AAPL	Stock	38.6125	38.838	38.6	38.6125	9568128.0
2017-06-06 16:30:00	AAPL	Stock	38.6125	38.6175	38.6075	38.6075	22916.0
2017-06-06 17:00:00	AAPL	Stock	38.6125	38.6175	38.6075	38.6125	13900.0
2017-06-06 17:30:00	AAPL	Stock	38.6125	38.6175	38.6125	38.6125	27812.0
2017-06-06 18:00:00	AAPL	Stock	38.6125	38.6175	38.61	38.6125	13924.0
2017-06-06 18:30:00	AAPL	Stock	38.6075	38.625	38.6	38.62	4608.0
2017-06-06 19:00:00	AAPL	Stock	38.625	38.625	38.6025	38.6125	28852.0
2017-06-06 19:30:00	AAPL	Stock	38.62	38.635	38.6175	38.635	11300.0
2017-06-06 04:00:00	MSFT	Stock	72.28	72.28	72.28	72.28	200.0
2017-06-06 05:30:00	MSFT	Stock	72.26	72.26	72.26	72.26	1800.0
2017-06-06 06:00:00	MSFT	Stock	72.35	72.39	72.35	72.39	2331.0
2017-06-06 07:00:00	MSFT	Stock	72.21	72.21	72.21	72.21	1298.0
2017-06-06 07:30:00	MSFT	Stock	72.23	72.25	72.23	72.25	1800.0
2017-06-06 08:00:00	MSFT	Stock	72.22	72.22	72.16	72.22	14392.0
2017-06-06 08:30:00	MSFT	Stock	72.22	72.29	72.18	72.28	9964.0
2017-06-06 09:00:00	MSFT	Stock	72.27	72.38	72.15	72.3	31285.0
2017-06-06 09:30:00	MSFT	Stock	72.3	72.54	72.27	72.49	3645219.0
2017-06-06 10:00:00	MSFT	Stock	72.49	72.62	72.405	72.515	2872698.0
2017-06-06 10:30:00	MSFT	Stock	72.514	72.6	72.48	72.565	1607992.0
2017-06-06 11:00:00	MSFT	Stock	72.565	72.59	72.47	72.54	1651075.0
2017-06-06 11:30:00	MSFT	Stock	72.535	72.575	72.43	72.44	1629359.0
2017-06-06 12:00:00	MSFT	Stock	72.435	72.45	72.31	72.335	1191612.0
2017-06-06 12:30:00	MSFT	Stock	72.34	72.37	72.31	72.37	1041210.0
2017-06-06 13:00:00	MSFT	Stock	72.363	72.46	72.29	72.32	874817.0
2017-06-06 13:30:00	MSFT	Stock	72.316	72.36	72.29	72.331	604014.0
2017-06-06 14:00:00	MSFT	Stock	72.34	72.43	72.31	72.4	970481.0
2017-06-06 14:30:00	MSFT	Stock	72.39	72.59	72.39	72.555	1882821.0
2017-06-06 15:00:00	MSFT	Stock	72.55	72.615	72.42	72.44	2170145.0

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

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