PREVIEW / stock_30min / 2018-12-10

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-12-10.parquet
  size:    1.7 MB
  rows:    84,872
  symbols: 2,731

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-10 04:00:00	AAPL	Stock	41.7	41.85	41.7	41.7525	33144.0
2018-12-10 04:30:00	AAPL	Stock	41.7	41.85	41.7	41.85	29500.0
2018-12-10 05:00:00	AAPL	Stock	41.825	41.8475	41.825	41.8475	4056.0
2018-12-10 05:30:00	AAPL	Stock	41.825	41.825	41.775	41.81	3600.0
2018-12-10 06:00:00	AAPL	Stock	41.8125	42.05	41.8125	41.965	35296.0
2018-12-10 06:30:00	AAPL	Stock	41.9875	41.9875	41.95	41.9725	15624.0
2018-12-10 07:00:00	AAPL	Stock	41.9875	42.0125	41.8125	41.875	99968.0
2018-12-10 07:30:00	AAPL	Stock	41.865	42.055	41.8375	41.99	277960.0
2018-12-10 08:00:00	AAPL	Stock	41.9775	42.0675	41.816	41.9125	691604.0
2018-12-10 08:30:00	AAPL	Stock	41.8875	41.95	41.57	41.625	1113104.0
2018-12-10 09:00:00	AAPL	Stock	41.625	41.6875	41.125	41.2425	3868204.0
2018-12-10 09:30:00	AAPL	Stock	41.2425	41.6225	40.8325	41.1125	38709824.0
2018-12-10 10:00:00	AAPL	Stock	41.1075	41.5825	41.055	41.4025	18410856.0
2018-12-10 10:30:00	AAPL	Stock	41.4	41.72	41.2275	41.4462	15429708.0
2018-12-10 11:00:00	AAPL	Stock	41.44	41.4625	41.1375	41.3	14581128.0
2018-12-10 11:30:00	AAPL	Stock	41.3025	41.3625	41.1425	41.2712	11592864.0
2018-12-10 12:00:00	AAPL	Stock	41.2675	41.355	41.0975	41.2218	11156972.0
2018-12-10 12:30:00	AAPL	Stock	41.2222	42.3775	41.1975	42.08	27050684.0
2018-12-10 13:00:00	AAPL	Stock	42.085	42.31	41.95	42.01	13112400.0
2018-12-10 13:30:00	AAPL	Stock	42.01	42.4625	41.965	42.2425	13353712.0
2018-12-10 14:00:00	AAPL	Stock	42.245	42.37	42.0925	42.2675	8991672.0
2018-12-10 14:30:00	AAPL	Stock	42.27	42.5225	42.22	42.25	9281460.0
2018-12-10 15:00:00	AAPL	Stock	42.246	42.34	42.0825	42.2125	7421460.0
2018-12-10 15:30:00	AAPL	Stock	42.215	42.47	42.215	42.4025	14365948.0
2018-12-10 16:00:00	AAPL	Stock	42.4	42.56	42.4	42.525	13149264.0
2018-12-10 16:30:00	AAPL	Stock	42.505	42.5625	42.4	42.525	143628.0
2018-12-10 17:00:00	AAPL	Stock	42.5225	42.575	42.5125	42.5425	101916.0
2018-12-10 17:30:00	AAPL	Stock	42.55	42.5625	42.53	42.545	25380.0
2018-12-10 18:00:00	AAPL	Stock	42.5525	42.5525	42.44	42.4625	89788.0
2018-12-10 18:30:00	AAPL	Stock	42.4575	42.4625	42.425	42.425	68228.0
2018-12-10 19:00:00	AAPL	Stock	42.425	42.4625	42.33	42.385	44104.0
2018-12-10 19:30:00	AAPL	Stock	42.35	42.3725	42.2675	42.2875	79940.0
2018-12-10 04:00:00	MSFT	Stock	104.33	104.4	104.33	104.4	300.0
2018-12-10 04:30:00	MSFT	Stock	104.4	104.4	104.4	104.4	217.0
2018-12-10 05:00:00	MSFT	Stock	104.4	104.4	104.4	104.4	200.0
2018-12-10 05:30:00	MSFT	Stock	104.61	104.61	104.61	104.61	100.0
2018-12-10 06:30:00	MSFT	Stock	104.7	104.7	104.7	104.7	100.0
2018-12-10 07:00:00	MSFT	Stock	104.52	104.7	104.42	104.42	3965.0
2018-12-10 07:30:00	MSFT	Stock	104.58	105.38	104.58	105.17	16099.0
2018-12-10 08:00:00	MSFT	Stock	104.5	105.88	104.42	105.63	39701.0
2018-12-10 08:30:00	MSFT	Stock	105.52	105.64	105.0	105.12	19188.0
2018-12-10 09:00:00	MSFT	Stock	105.11	105.11	104.8	104.8	40220.0
2018-12-10 09:30:00	MSFT	Stock	104.8	106.66	104.58	105.09	3887191.0
2018-12-10 10:00:00	MSFT	Stock	105.08	106.29	105.01	105.63	2490900.0
2018-12-10 10:30:00	MSFT	Stock	105.639	105.82	104.4	104.74	2948829.0
2018-12-10 11:00:00	MSFT	Stock	104.74	104.79	103.89	104.65	2922764.0
2018-12-10 11:30:00	MSFT	Stock	104.64	105.22	104.45	104.705	2442540.0
2018-12-10 12:00:00	MSFT	Stock	104.67	104.97	104.21	104.44	1627089.0
2018-12-10 12:30:00	MSFT	Stock	104.42	105.97	104.42	105.855	2040488.0
2018-12-10 13:00:00	MSFT	Stock	105.86	106.275	105.64	105.7	1718964.0

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

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