PREVIEW / stock_30min / 2018-11-01

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-11-01.parquet
  size:    1.7 MB
  rows:    85,061
  symbols: 2,769

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-01 04:00:00	AAPL	Stock	54.745	54.825	54.625	54.825	19968.0
2018-11-01 04:30:00	AAPL	Stock	54.875	54.955	54.875	54.955	9560.0
2018-11-01 05:00:00	AAPL	Stock	54.9	54.9475	54.85	54.8725	17752.0
2018-11-01 05:30:00	AAPL	Stock	54.9075	54.9375	54.855	54.9375	34276.0
2018-11-01 06:00:00	AAPL	Stock	54.9875	55.045	54.9775	54.995	20824.0
2018-11-01 06:30:00	AAPL	Stock	55.0	55.0975	54.995	55.0025	100024.0
2018-11-01 07:00:00	AAPL	Stock	55.0	55.125	54.95	55.08	351356.0
2018-11-01 07:30:00	AAPL	Stock	55.0875	55.11	54.925	54.9825	371628.0
2018-11-01 08:00:00	AAPL	Stock	55.0	55.125	54.925	54.99	459228.0
2018-11-01 08:30:00	AAPL	Stock	54.9825	55.0025	54.7075	54.765	630668.0
2018-11-01 09:00:00	AAPL	Stock	54.7525	54.7912	54.5425	54.7625	785316.0
2018-11-01 09:30:00	AAPL	Stock	54.7675	55.0	54.3	54.4275	20081348.0
2018-11-01 10:00:00	AAPL	Stock	54.4475	54.6675	54.2025	54.485	10059052.0
2018-11-01 10:30:00	AAPL	Stock	54.485	54.595	54.2375	54.375	8522316.0
2018-11-01 11:00:00	AAPL	Stock	54.375	54.7675	54.3	54.75	7899308.0
2018-11-01 11:30:00	AAPL	Stock	54.7525	54.98	54.735	54.815	8234716.0
2018-11-01 12:00:00	AAPL	Stock	54.8125	54.9975	54.7225	54.7575	5427636.0
2018-11-01 12:30:00	AAPL	Stock	54.7675	54.85	54.66	54.8115	4780244.0
2018-11-01 13:00:00	AAPL	Stock	54.805	55.215	54.765	55.1325	10157948.0
2018-11-01 13:30:00	AAPL	Stock	55.131	55.1625	54.95	55.1025	8001228.0
2018-11-01 14:00:00	AAPL	Stock	55.1	55.1175	54.7675	54.7725	6480232.0
2018-11-01 14:30:00	AAPL	Stock	54.7725	54.895	54.5575	54.875	9230692.0
2018-11-01 15:00:00	AAPL	Stock	54.8725	55.21	54.8125	55.1988	11612900.0
2018-11-01 15:30:00	AAPL	Stock	55.2	55.59	55.175	55.515	26606680.0
2018-11-01 16:00:00	AAPL	Stock	55.525	55.8725	55.4	55.625	9534348.0
2018-11-01 16:30:00	AAPL	Stock	55.65	55.65	52.6375	53.25	23858960.0
2018-11-01 17:00:00	AAPL	Stock	53.25	53.275	52.17	52.175	9094852.0
2018-11-01 17:30:00	AAPL	Stock	52.1825	52.3075	51.29	51.8375	10065796.0
2018-11-01 18:00:00	AAPL	Stock	51.8475	52.025	51.53	51.9525	2336696.0
2018-11-01 18:30:00	AAPL	Stock	51.9675	52.26	51.9	52.0375	1670640.0
2018-11-01 19:00:00	AAPL	Stock	52.0625	52.08	51.825	51.875	1340984.0
2018-11-01 19:30:00	AAPL	Stock	51.875	51.96	51.7125	51.9525	1305308.0
2018-11-01 04:30:00	MSFT	Stock	107.06	107.06	107.06	107.06	100.0
2018-11-01 05:00:00	MSFT	Stock	107.11	107.11	107.11	107.11	150.0
2018-11-01 06:30:00	MSFT	Stock	107.37	107.5	107.37	107.41	980.0
2018-11-01 07:00:00	MSFT	Stock	107.6	107.71	107.45	107.47	4944.0
2018-11-01 07:30:00	MSFT	Stock	107.47	107.6	107.27	107.3	11948.0
2018-11-01 08:00:00	MSFT	Stock	107.7	107.8	106.86	107.0	22692.0
2018-11-01 08:30:00	MSFT	Stock	107.249	107.249	106.7	106.8	12822.0
2018-11-01 09:00:00	MSFT	Stock	106.81	107.14	106.5	107.08	16634.0
2018-11-01 09:30:00	MSFT	Stock	107.08	107.32	105.85	106.25	3552465.0
2018-11-01 10:00:00	MSFT	Stock	106.23	106.6	105.57	106.121	2867412.0
2018-11-01 10:30:00	MSFT	Stock	106.13	106.73	106.03	106.45	1794441.0
2018-11-01 11:00:00	MSFT	Stock	106.45	106.54	106.13	106.41	1739954.0
2018-11-01 11:30:00	MSFT	Stock	106.407	106.588	106.01	106.155	1904092.0
2018-11-01 12:00:00	MSFT	Stock	106.15	106.45	105.88	106.12	1700229.0
2018-11-01 12:30:00	MSFT	Stock	106.13	106.56	106.06	106.54	1463293.0
2018-11-01 13:00:00	MSFT	Stock	106.54	106.545	106.2	106.46	1148088.0
2018-11-01 13:30:00	MSFT	Stock	106.46	106.59	106.29	106.348	1327569.0
2018-11-01 14:00:00	MSFT	Stock	106.35	106.39	106.035	106.32	1184164.0

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

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