PREVIEW / stock_30min / 2018-11-29

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-11-29.parquet
  size:    1.7 MB
  rows:    84,566
  symbols: 2,751

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-11-29 04:00:00	AAPL	Stock	45.425	45.5	45.05	45.1225	114460.0
2018-11-29 04:30:00	AAPL	Stock	45.1675	45.21	45.135	45.2	43024.0
2018-11-29 05:00:00	AAPL	Stock	45.1675	45.2	45.125	45.175	22856.0
2018-11-29 05:30:00	AAPL	Stock	45.175	45.2125	45.15	45.15	15028.0
2018-11-29 06:00:00	AAPL	Stock	45.15	45.1875	45.0625	45.1225	61944.0
2018-11-29 06:30:00	AAPL	Stock	45.1025	45.105	45.0	45.105	36092.0
2018-11-29 07:00:00	AAPL	Stock	45.105	45.45	45.075	45.38	186140.0
2018-11-29 07:30:00	AAPL	Stock	45.35	45.4	45.275	45.355	170916.0
2018-11-29 08:00:00	AAPL	Stock	45.42	45.475	45.0725	45.475	636436.0
2018-11-29 08:30:00	AAPL	Stock	45.485	45.7	45.4625	45.5875	861032.0
2018-11-29 09:00:00	AAPL	Stock	45.5875	45.6875	45.4775	45.67	684880.0
2018-11-29 09:30:00	AAPL	Stock	45.6575	45.7	44.8125	44.9575	23730872.0
2018-11-29 10:00:00	AAPL	Stock	44.9575	44.9725	44.5625	44.6575	13705684.0
2018-11-29 10:30:00	AAPL	Stock	44.6575	44.905	44.505	44.58	10341848.0
2018-11-29 11:00:00	AAPL	Stock	44.579	44.6725	44.425	44.5725	11380764.0
2018-11-29 11:30:00	AAPL	Stock	44.57	44.7625	44.475	44.738	8156080.0
2018-11-29 12:00:00	AAPL	Stock	44.74	44.7425	44.4825	44.5575	5193868.0
2018-11-29 12:30:00	AAPL	Stock	44.5595	44.895	44.55	44.8932	7215620.0
2018-11-29 13:00:00	AAPL	Stock	44.8925	44.8925	44.64	44.6575	4266052.0
2018-11-29 13:30:00	AAPL	Stock	44.65	44.7225	44.585	44.666	3543724.0
2018-11-29 14:00:00	AAPL	Stock	44.6665	44.9325	44.6025	44.8875	6895284.0
2018-11-29 14:30:00	AAPL	Stock	44.8875	45.08	44.875	45.0725	6873280.0
2018-11-29 15:00:00	AAPL	Stock	45.07	45.0925	44.85	44.965	8720300.0
2018-11-29 15:30:00	AAPL	Stock	44.9625	45.0125	44.875	44.8875	12492768.0
2018-11-29 16:00:00	AAPL	Stock	44.8875	44.9	44.8125	44.85	8821936.0
2018-11-29 16:30:00	AAPL	Stock	44.85	44.87	44.78	44.8225	35328.0
2018-11-29 17:00:00	AAPL	Stock	44.8	44.8875	44.79	44.8875	99524.0
2018-11-29 17:30:00	AAPL	Stock	44.81	44.869	44.81	44.8575	36664.0
2018-11-29 18:00:00	AAPL	Stock	44.84	44.85	44.7825	44.8	20420.0
2018-11-29 18:30:00	AAPL	Stock	44.8125	44.86	44.7725	44.8225	15764.0
2018-11-29 19:00:00	AAPL	Stock	44.8125	44.8225	44.7075	44.7075	40616.0
2018-11-29 19:30:00	AAPL	Stock	44.735	44.7375	44.6375	44.6375	89104.0
2018-11-29 04:00:00	MSFT	Stock	110.5	111.0	110.5	111.0	2310.0
2018-11-29 04:30:00	MSFT	Stock	110.84	110.84	110.77	110.77	700.0
2018-11-29 05:00:00	MSFT	Stock	110.76	110.76	110.76	110.76	225.0
2018-11-29 05:30:00	MSFT	Stock	110.5	110.5	110.46	110.46	400.0
2018-11-29 06:00:00	MSFT	Stock	110.49	110.49	110.49	110.49	391.0
2018-11-29 06:30:00	MSFT	Stock	110.31	110.51	110.19	110.5	4398.0
2018-11-29 07:00:00	MSFT	Stock	110.52	110.9	110.25	110.71	5757.0
2018-11-29 07:30:00	MSFT	Stock	110.81	110.81	110.45	110.75	10095.0
2018-11-29 08:00:00	MSFT	Stock	110.48	110.75	110.31	110.67	14937.0
2018-11-29 08:30:00	MSFT	Stock	110.58	110.85	110.56	110.62	39543.0
2018-11-29 09:00:00	MSFT	Stock	110.69	110.69	110.18	110.21	44506.0
2018-11-29 09:30:00	MSFT	Stock	110.33	110.87	110.17	110.41	2853192.0
2018-11-29 10:00:00	MSFT	Stock	110.4	110.63	109.91	109.93	1928437.0
2018-11-29 10:30:00	MSFT	Stock	109.92	110.54	109.03	109.14	3241293.0
2018-11-29 11:00:00	MSFT	Stock	109.145	109.8	109.12	109.55	2355196.0
2018-11-29 11:30:00	MSFT	Stock	109.56	110.22	109.45	110.01	1424975.0
2018-11-29 12:00:00	MSFT	Stock	110.01	110.01	109.65	109.933	911661.0
2018-11-29 12:30:00	MSFT	Stock	109.94	110.2	109.78	110.11	775200.0

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

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