PREVIEW / stock_30min / 2018-01-16

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-01-16.parquet
  size:    1.8 MB
  rows:    88,176
  symbols: 2,914

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-01-16 04:00:00	AAPL	Stock	44.35	44.6	44.35	44.5625	65468.0
2018-01-16 04:30:00	AAPL	Stock	44.575	44.575	44.5625	44.5625	2000.0
2018-01-16 05:00:00	AAPL	Stock	44.525	44.55	44.5	44.5	4184.0
2018-01-16 05:30:00	AAPL	Stock	44.5025	44.55	44.5	44.5175	3504.0
2018-01-16 06:00:00	AAPL	Stock	44.5375	44.575	44.5375	44.5425	42568.0
2018-01-16 06:30:00	AAPL	Stock	44.5625	44.5975	44.5375	44.5975	21228.0
2018-01-16 07:00:00	AAPL	Stock	44.56	44.5975	44.5	44.535	104068.0
2018-01-16 07:30:00	AAPL	Stock	44.5375	44.63	44.5375	44.625	96732.0
2018-01-16 08:00:00	AAPL	Stock	44.5375	44.6625	44.515	44.5975	210580.0
2018-01-16 08:30:00	AAPL	Stock	44.585	44.6375	44.555	44.585	121508.0
2018-01-16 09:00:00	AAPL	Stock	44.575	44.6	44.47	44.475	396856.0
2018-01-16 09:30:00	AAPL	Stock	44.4775	44.7775	44.3	44.74	17852916.0
2018-01-16 10:00:00	AAPL	Stock	44.74	44.8475	44.6825	44.75	8797848.0
2018-01-16 10:30:00	AAPL	Stock	44.75	44.7525	44.5425	44.565	7803832.0
2018-01-16 11:00:00	AAPL	Stock	44.5638	44.5662	44.3325	44.4775	8061624.0
2018-01-16 11:30:00	AAPL	Stock	44.4788	44.525	44.3525	44.3775	4823712.0
2018-01-16 12:00:00	AAPL	Stock	44.38	44.4718	44.3775	44.3875	3166100.0
2018-01-16 12:30:00	AAPL	Stock	44.3925	44.415	44.2875	44.3312	3430160.0
2018-01-16 13:00:00	AAPL	Stock	44.3322	44.382	44.2525	44.355	4445256.0
2018-01-16 13:30:00	AAPL	Stock	44.3575	44.395	44.26	44.267	3419356.0
2018-01-16 14:00:00	AAPL	Stock	44.2688	44.31	44.18	44.195	7666944.0
2018-01-16 14:30:00	AAPL	Stock	44.1975	44.2475	44.035	44.1125	7484100.0
2018-01-16 15:00:00	AAPL	Stock	44.1145	44.22	44.075	44.2075	5679784.0
2018-01-16 15:30:00	AAPL	Stock	44.2075	44.2375	44.0475	44.05	9993688.0
2018-01-16 16:00:00	AAPL	Stock	44.0475	44.085	44.0475	44.07	13390464.0
2018-01-16 16:30:00	AAPL	Stock	44.08	44.1708	44.0475	44.075	48828.0
2018-01-16 17:00:00	AAPL	Stock	44.0575	44.0725	44.0	44.0	61200.0
2018-01-16 17:30:00	AAPL	Stock	44.0	44.0025	43.9625	44.0	29440.0
2018-01-16 18:00:00	AAPL	Stock	44.0	44.0125	43.96	43.96	47932.0
2018-01-16 18:30:00	AAPL	Stock	43.95	43.9625	43.9375	43.9625	23772.0
2018-01-16 19:00:00	AAPL	Stock	43.9625	43.9625	43.925	43.9525	55836.0
2018-01-16 19:30:00	AAPL	Stock	43.975	43.975	43.9375	43.9375	14920.0
2018-01-16 04:00:00	MSFT	Stock	89.9	90.03	89.9	90.03	402.0
2018-01-16 04:30:00	MSFT	Stock	90.16	90.17	90.1	90.1	1386.0
2018-01-16 05:00:00	MSFT	Stock	90.2	90.34	90.2	90.34	812.0
2018-01-16 05:30:00	MSFT	Stock	90.55	90.59	90.55	90.59	553.0
2018-01-16 06:00:00	MSFT	Stock	90.38	90.5	90.34	90.4	5420.0
2018-01-16 06:30:00	MSFT	Stock	90.4	90.4	90.39	90.39	1130.0
2018-01-16 07:00:00	MSFT	Stock	90.3	90.4	90.17	90.17	12777.0
2018-01-16 07:30:00	MSFT	Stock	90.33	90.33	90.2	90.3	1701.0
2018-01-16 08:00:00	MSFT	Stock	90.17	90.4	90.15	90.35	8544.0
2018-01-16 08:30:00	MSFT	Stock	90.37	90.37	90.2	90.25	7514.0
2018-01-16 09:00:00	MSFT	Stock	90.3	90.54	90.1	90.33	64324.0
2018-01-16 09:30:00	MSFT	Stock	90.1	90.79	90.1	90.55	4149796.0
2018-01-16 10:00:00	MSFT	Stock	90.55	90.6	90.275	90.43	1943703.0
2018-01-16 10:30:00	MSFT	Stock	90.43	90.45	89.76	89.805	2540105.0
2018-01-16 11:00:00	MSFT	Stock	89.805	89.95	89.47	89.94	2179547.0
2018-01-16 11:30:00	MSFT	Stock	89.935	89.97	89.42	89.425	2017354.0
2018-01-16 12:00:00	MSFT	Stock	89.43	89.64	89.425	89.53	1274625.0
2018-01-16 12:30:00	MSFT	Stock	89.53	89.59	89.22	89.355	1236467.0

> showing 50 of 88,176 rows — these rows as CSV

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