PREVIEW / stock_30min / 2018-12-12

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-12-12.parquet
  size:    1.7 MB
  rows:    84,756
  symbols: 2,742

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
2018-12-12 04:00:00	AAPL	Stock	42.4375	42.65	42.4375	42.65	1516.0
2018-12-12 04:30:00	AAPL	Stock	42.725	42.725	42.6875	42.7	13976.0
2018-12-12 05:00:00	AAPL	Stock	42.7	42.74	42.65	42.65	4000.0
2018-12-12 05:30:00	AAPL	Stock	42.65	42.715	42.65	42.705	10700.0
2018-12-12 06:00:00	AAPL	Stock	42.65	42.67	42.625	42.67	3800.0
2018-12-12 06:30:00	AAPL	Stock	42.7	42.715	42.515	42.6075	48708.0
2018-12-12 07:00:00	AAPL	Stock	42.6	42.6	42.505	42.6	62476.0
2018-12-12 07:30:00	AAPL	Stock	42.605	42.685	42.55	42.5525	120276.0
2018-12-12 08:00:00	AAPL	Stock	42.525	42.69	42.45	42.45	354264.0
2018-12-12 08:30:00	AAPL	Stock	42.4975	42.7625	42.3925	42.6125	581492.0
2018-12-12 09:00:00	AAPL	Stock	42.6275	42.6875	42.525	42.5975	443680.0
2018-12-12 09:30:00	AAPL	Stock	42.5975	42.6932	42.29	42.624	16911784.0
2018-12-12 10:00:00	AAPL	Stock	42.6175	42.82	42.5925	42.615	11375996.0
2018-12-12 10:30:00	AAPL	Stock	42.615	42.7525	42.4425	42.695	8341904.0
2018-12-12 11:00:00	AAPL	Stock	42.6975	42.89	42.6352	42.75	7554632.0
2018-12-12 11:30:00	AAPL	Stock	42.7525	42.8575	42.6515	42.8275	6179412.0
2018-12-12 12:00:00	AAPL	Stock	42.835	42.87	42.665	42.7622	5416152.0
2018-12-12 12:30:00	AAPL	Stock	42.7625	42.84	42.67	42.8365	4594236.0
2018-12-12 13:00:00	AAPL	Stock	42.84	42.98	42.766	42.95	6618492.0
2018-12-12 13:30:00	AAPL	Stock	42.955	42.9638	42.8	42.845	4113976.0
2018-12-12 14:00:00	AAPL	Stock	42.845	42.8675	42.425	42.4665	8444256.0
2018-12-12 14:30:00	AAPL	Stock	42.465	42.5822	42.38	42.4975	8100208.0
2018-12-12 15:00:00	AAPL	Stock	42.5	42.5825	42.3045	42.32	7800412.0
2018-12-12 15:30:00	AAPL	Stock	42.32	42.52	42.255	42.2725	13175564.0
2018-12-12 16:00:00	AAPL	Stock	42.275	42.3325	42.22	42.3125	11856976.0
2018-12-12 16:30:00	AAPL	Stock	42.295	42.3	42.25	42.3	33568.0
2018-12-12 17:00:00	AAPL	Stock	42.31	42.3875	42.28	42.35	143028.0
2018-12-12 17:30:00	AAPL	Stock	42.335	42.355	42.29	42.35	41848.0
2018-12-12 18:00:00	AAPL	Stock	42.35	42.3975	42.35	42.385	16420.0
2018-12-12 18:30:00	AAPL	Stock	42.3875	42.395	42.3575	42.375	30500.0
2018-12-12 19:00:00	AAPL	Stock	42.375	42.395	42.325	42.395	49492.0
2018-12-12 19:30:00	AAPL	Stock	42.4125	42.415	42.375	42.375	27780.0
2018-12-12 04:00:00	MSFT	Stock	109.15	109.5	109.15	109.5	200.0
2018-12-12 04:30:00	MSFT	Stock	109.95	110.16	109.95	110.15	600.0
2018-12-12 05:00:00	MSFT	Stock	110.13	110.13	110.1	110.1	1851.0
2018-12-12 05:30:00	MSFT	Stock	110.1	110.23	109.94	109.94	2995.0
2018-12-12 06:30:00	MSFT	Stock	109.95	109.95	109.75	109.91	500.0
2018-12-12 07:00:00	MSFT	Stock	109.85	109.9	109.77	109.9	4032.0
2018-12-12 07:30:00	MSFT	Stock	109.9	110.2	109.88	109.93	19909.0
2018-12-12 08:00:00	MSFT	Stock	109.75	110.4	108.59	110.1	117199.0
2018-12-12 08:30:00	MSFT	Stock	110.09	110.9	109.91	110.8	61996.0
2018-12-12 09:00:00	MSFT	Stock	110.8	110.92	110.6	110.84	64395.0
2018-12-12 09:30:00	MSFT	Stock	110.89	111.18	109.91	110.42	3738549.0
2018-12-12 10:00:00	MSFT	Stock	110.41	110.93	110.32	110.53	2277518.0
2018-12-12 10:30:00	MSFT	Stock	110.54	111.065	110.47	111.0	2305725.0
2018-12-12 11:00:00	MSFT	Stock	111.01	111.22	110.758	111.11	2141354.0
2018-12-12 11:30:00	MSFT	Stock	111.12	111.27	110.91	111.06	1547581.0
2018-12-12 12:00:00	MSFT	Stock	111.07	111.22	110.6	110.65	1552103.0
2018-12-12 12:30:00	MSFT	Stock	110.66	110.73	110.41	110.61	1193608.0
2018-12-12 13:00:00	MSFT	Stock	110.62	110.71	110.24	110.55	1263197.0

> showing 50 of 84,756 rows — these rows as CSV

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