PREVIEW / stock_30min / 2018-01-05

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-01-05.parquet
  size:    1.7 MB
  rows:    84,974
  symbols: 2,925

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-05 04:00:00	AAPL	Stock	43.175	43.175	43.175	43.175	5476.0
2018-01-05 04:30:00	AAPL	Stock	43.25	43.25	43.25	43.25	10800.0
2018-01-05 05:30:00	AAPL	Stock	43.25	43.36	43.25	43.36	24420.0
2018-01-05 06:00:00	AAPL	Stock	43.375	43.4	43.35	43.35	10652.0
2018-01-05 06:30:00	AAPL	Stock	43.33	43.33	43.315	43.325	20120.0
2018-01-05 07:00:00	AAPL	Stock	43.33	43.345	43.2875	43.325	62016.0
2018-01-05 07:30:00	AAPL	Stock	43.3225	43.3875	43.3225	43.3525	43920.0
2018-01-05 08:00:00	AAPL	Stock	43.375	43.4125	43.325	43.4125	110852.0
2018-01-05 08:30:00	AAPL	Stock	43.4125	43.455	43.365	43.44	218824.0
2018-01-05 09:00:00	AAPL	Stock	43.41	43.4325	43.3325	43.3525	249084.0
2018-01-05 09:30:00	AAPL	Stock	43.36	43.5475	43.2625	43.52	12842480.0
2018-01-05 10:00:00	AAPL	Stock	43.525	43.735	43.445	43.6725	9452828.0
2018-01-05 10:30:00	AAPL	Stock	43.6725	43.7975	43.6375	43.7838	7257484.0
2018-01-05 11:00:00	AAPL	Stock	43.7838	43.7938	43.72	43.7375	4738436.0
2018-01-05 11:30:00	AAPL	Stock	43.7375	43.75	43.6825	43.735	3562952.0
2018-01-05 12:00:00	AAPL	Stock	43.735	43.735	43.6755	43.6768	3153276.0
2018-01-05 12:30:00	AAPL	Stock	43.6775	43.73	43.64	43.715	4222216.0
2018-01-05 13:00:00	AAPL	Stock	43.7158	43.755	43.69	43.7075	2674884.0
2018-01-05 13:30:00	AAPL	Stock	43.7075	43.7575	43.6885	43.7525	2659372.0
2018-01-05 14:00:00	AAPL	Stock	43.7585	43.77	43.72	43.7385	2740484.0
2018-01-05 14:30:00	AAPL	Stock	43.74	43.7525	43.6625	43.7125	3618116.0
2018-01-05 15:00:00	AAPL	Stock	43.71	43.7375	43.6875	43.7325	3523572.0
2018-01-05 15:30:00	AAPL	Stock	43.7325	43.8425	43.72	43.74	13234364.0
2018-01-05 16:00:00	AAPL	Stock	43.75	43.755	43.7425	43.75	9681172.0
2018-01-05 16:30:00	AAPL	Stock	43.7525	43.7575	43.7475	43.7475	296404.0
2018-01-05 17:00:00	AAPL	Stock	43.7475	43.775	43.7475	43.775	43384.0
2018-01-05 17:30:00	AAPL	Stock	43.775	43.775	43.75	43.75	203668.0
2018-01-05 18:00:00	AAPL	Stock	43.745	43.7675	43.7425	43.75	19268.0
2018-01-05 18:30:00	AAPL	Stock	43.7525	43.7625	43.745	43.745	4680.0
2018-01-05 19:00:00	AAPL	Stock	43.745	43.765	43.745	43.765	11860.0
2018-01-05 19:30:00	AAPL	Stock	43.75	43.7675	43.75	43.7675	13172.0
2018-01-05 04:30:00	MSFT	Stock	87.35	87.35	87.35	87.35	100.0
2018-01-05 05:00:00	MSFT	Stock	87.45	87.45	87.45	87.45	400.0
2018-01-05 05:30:00	MSFT	Stock	87.65	87.65	87.65	87.65	150.0
2018-01-05 06:00:00	MSFT	Stock	87.65	87.65	87.65	87.65	344.0
2018-01-05 06:30:00	MSFT	Stock	87.6	87.6	87.6	87.6	500.0
2018-01-05 07:00:00	MSFT	Stock	87.59	87.59	87.59	87.59	600.0
2018-01-05 07:30:00	MSFT	Stock	87.54	87.55	87.54	87.55	420.0
2018-01-05 08:00:00	MSFT	Stock	87.45	87.56	87.45	87.56	3663.0
2018-01-05 08:30:00	MSFT	Stock	87.56	87.65	87.37	87.5	9716.0
2018-01-05 09:00:00	MSFT	Stock	87.55	87.69	87.41	87.56	14232.0
2018-01-05 09:30:00	MSFT	Stock	87.66	88.035	87.43	88.03	2637321.0
2018-01-05 10:00:00	MSFT	Stock	88.035	88.19	87.92	88.055	1460642.0
2018-01-05 10:30:00	MSFT	Stock	88.055	88.21	87.915	88.12	1301907.0
2018-01-05 11:00:00	MSFT	Stock	88.13	88.41	88.12	88.285	1252117.0
2018-01-05 11:30:00	MSFT	Stock	88.285	88.3	88.1	88.155	707870.0
2018-01-05 12:00:00	MSFT	Stock	88.16	88.23	88.06	88.14	869879.0
2018-01-05 12:30:00	MSFT	Stock	88.14	88.15	88.055	88.11	765075.0
2018-01-05 13:00:00	MSFT	Stock	88.105	88.161	88.05	88.14	496310.0
2018-01-05 13:30:00	MSFT	Stock	88.135	88.15	88.053	88.126	641357.0

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

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