PREVIEW / stock_30min / 2018-12-17

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-12-17.parquet
  size:    1.7 MB
  rows:    85,976
  symbols: 2,730

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-17 04:00:00	AAPL	Stock	41.42	41.5725	41.4	41.495	20176.0
2018-12-17 04:30:00	AAPL	Stock	41.4225	41.47	41.375	41.47	5300.0
2018-12-17 05:00:00	AAPL	Stock	41.47	41.47	41.4425	41.4425	1200.0
2018-12-17 05:30:00	AAPL	Stock	41.4525	41.47	41.375	41.47	6456.0
2018-12-17 06:00:00	AAPL	Stock	41.38	41.4025	41.375	41.4025	6560.0
2018-12-17 06:30:00	AAPL	Stock	41.4025	41.4025	41.125	41.275	50580.0
2018-12-17 07:00:00	AAPL	Stock	41.275	41.375	41.2275	41.3725	113064.0
2018-12-17 07:30:00	AAPL	Stock	41.3725	41.395	41.25	41.25	48276.0
2018-12-17 08:00:00	AAPL	Stock	41.37	41.395	41.2275	41.245	175184.0
2018-12-17 08:30:00	AAPL	Stock	41.25	41.26	41.1525	41.1875	278196.0
2018-12-17 09:00:00	AAPL	Stock	41.19	41.395	41.19	41.3575	217004.0
2018-12-17 09:30:00	AAPL	Stock	41.3625	41.865	41.335	41.625	21346944.0
2018-12-17 10:00:00	AAPL	Stock	41.623	41.9675	41.5275	41.8525	12780972.0
2018-12-17 10:30:00	AAPL	Stock	41.855	41.9725	41.6425	41.9222	8575648.0
2018-12-17 11:00:00	AAPL	Stock	41.9225	42.0875	41.8675	41.9662	7462392.0
2018-12-17 11:30:00	AAPL	Stock	41.9675	42.0125	41.805	42.01	5823228.0
2018-12-17 12:00:00	AAPL	Stock	42.0125	42.0725	41.7728	41.8415	5714020.0
2018-12-17 12:30:00	AAPL	Stock	41.8375	41.8495	41.505	41.5208	6341364.0
2018-12-17 13:00:00	AAPL	Stock	41.52	41.555	41.345	41.3625	8970896.0
2018-12-17 13:30:00	AAPL	Stock	41.3662	41.4175	41.1475	41.1875	9870524.0
2018-12-17 14:00:00	AAPL	Stock	41.1925	41.26	41.075	41.0825	7357156.0
2018-12-17 14:30:00	AAPL	Stock	41.085	41.2775	41.0375	41.1272	6695052.0
2018-12-17 15:00:00	AAPL	Stock	41.125	41.155	40.89	40.9848	10788628.0
2018-12-17 15:30:00	AAPL	Stock	40.985	41.105	40.6825	41.0525	24078768.0
2018-12-17 16:00:00	AAPL	Stock	40.985	41.0775	40.965	41.019	17243700.0
2018-12-17 16:30:00	AAPL	Stock	40.9775	41.0625	40.95	41.0225	100260.0
2018-12-17 17:00:00	AAPL	Stock	41.015	41.05	41.0125	41.025	60996.0
2018-12-17 17:30:00	AAPL	Stock	41.02	41.06	41.02	41.06	32160.0
2018-12-17 18:00:00	AAPL	Stock	41.0675	41.1725	41.0625	41.125	89248.0
2018-12-17 18:30:00	AAPL	Stock	41.1125	41.18	41.1	41.155	46224.0
2018-12-17 19:00:00	AAPL	Stock	41.1575	41.175	41.1125	41.125	43680.0
2018-12-17 19:30:00	AAPL	Stock	41.1125	41.1825	41.0875	41.175	41296.0
2018-12-17 04:00:00	MSFT	Stock	106.3	106.3	106.19	106.21	1900.0
2018-12-17 04:30:00	MSFT	Stock	106.4	106.4	106.3	106.3	900.0
2018-12-17 05:00:00	MSFT	Stock	106.5	106.51	106.45	106.5	400.0
2018-12-17 06:00:00	MSFT	Stock	106.51	106.51	106.25	106.25	1028.0
2018-12-17 06:30:00	MSFT	Stock	106.2	106.3	106.2	106.3	3001.0
2018-12-17 07:00:00	MSFT	Stock	106.06	106.3	105.99	105.99	6910.0
2018-12-17 07:30:00	MSFT	Stock	106.02	106.12	106.02	106.08	900.0
2018-12-17 08:00:00	MSFT	Stock	106.19	106.193	105.62	105.63	11474.0
2018-12-17 08:30:00	MSFT	Stock	105.85	105.85	105.43	105.43	29849.0
2018-12-17 09:00:00	MSFT	Stock	105.45	105.82	105.33	105.46	35268.0
2018-12-17 09:30:00	MSFT	Stock	105.57	105.57	103.87	104.41	5084315.0
2018-12-17 10:00:00	MSFT	Stock	104.42	105.25	104.2	104.99	2499788.0
2018-12-17 10:30:00	MSFT	Stock	104.98	105.358	104.38	105.05	1863734.0
2018-12-17 11:00:00	MSFT	Stock	105.05	105.59	105.02	105.09	1838925.0
2018-12-17 11:30:00	MSFT	Stock	105.09	105.34	104.75	105.33	1340587.0
2018-12-17 12:00:00	MSFT	Stock	105.35	105.8	105.197	105.33	1775544.0
2018-12-17 12:30:00	MSFT	Stock	105.32	105.32	104.23	104.33	1774418.0
2018-12-17 13:00:00	MSFT	Stock	104.32	104.58	103.76	103.835	2287995.0

> showing 50 of 85,976 rows — these rows as CSV

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