PREVIEW / stock_30min / 2018-06-01

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-06-01.parquet
  size:    1.7 MB
  rows:    84,373
  symbols: 2,833

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-06-01 04:00:00	AAPL	Stock	46.8825	46.8825	46.8825	46.8825	1200.0
2018-06-01 04:30:00	AAPL	Stock	46.855	46.8875	46.855	46.8875	13204.0
2018-06-01 05:00:00	AAPL	Stock	46.8775	46.8775	46.85	46.85	10132.0
2018-06-01 05:30:00	AAPL	Stock	46.8875	46.9	46.8875	46.9	10000.0
2018-06-01 06:00:00	AAPL	Stock	46.9	46.9175	46.8525	46.9175	25340.0
2018-06-01 06:30:00	AAPL	Stock	46.9525	46.985	46.9375	46.95	4276.0
2018-06-01 07:00:00	AAPL	Stock	46.9375	46.9675	46.925	46.96	59300.0
2018-06-01 07:30:00	AAPL	Stock	46.965	46.9825	46.95	46.9625	36512.0
2018-06-01 08:00:00	AAPL	Stock	46.95	46.99	46.9375	46.99	63796.0
2018-06-01 08:30:00	AAPL	Stock	46.925	47.035	46.9175	47.03	215320.0
2018-06-01 09:00:00	AAPL	Stock	47.03	47.0375	46.9725	46.9825	158880.0
2018-06-01 09:30:00	AAPL	Stock	46.9978	47.17	46.9375	47.1175	9999868.0
2018-06-01 10:00:00	AAPL	Stock	47.1225	47.275	46.9843	47.1975	8374884.0
2018-06-01 10:30:00	AAPL	Stock	47.195	47.32	47.1575	47.2975	5968340.0
2018-06-01 11:00:00	AAPL	Stock	47.2975	47.37	47.295	47.3525	4729276.0
2018-06-01 11:30:00	AAPL	Stock	47.3525	47.475	47.3525	47.435	5383992.0
2018-06-01 12:00:00	AAPL	Stock	47.4375	47.475	47.4025	47.4162	3056080.0
2018-06-01 12:30:00	AAPL	Stock	47.4165	47.5	47.39	47.47	4236412.0
2018-06-01 13:00:00	AAPL	Stock	47.4725	47.5025	47.465	47.4808	3410296.0
2018-06-01 13:30:00	AAPL	Stock	47.4825	47.5298	47.47	47.5225	5839396.0
2018-06-01 14:00:00	AAPL	Stock	47.525	47.53	47.4325	47.4725	4215764.0
2018-06-01 14:30:00	AAPL	Stock	47.4725	47.51	47.4392	47.4875	3189104.0
2018-06-01 15:00:00	AAPL	Stock	47.4875	47.4875	47.3775	47.4487	4351520.0
2018-06-01 15:30:00	AAPL	Stock	47.4487	47.565	47.4425	47.5575	13107416.0
2018-06-01 16:00:00	AAPL	Stock	47.5575	47.59	47.535	47.575	7063624.0
2018-06-01 16:30:00	AAPL	Stock	47.5775	47.5875	47.5575	47.565	252860.0
2018-06-01 17:00:00	AAPL	Stock	47.5825	47.5875	47.57	47.5875	22488.0
2018-06-01 17:30:00	AAPL	Stock	47.585	47.59	47.55	47.575	87936.0
2018-06-01 18:00:00	AAPL	Stock	47.565	47.575	47.565	47.575	10676.0
2018-06-01 18:30:00	AAPL	Stock	47.575	47.58	47.565	47.565	5520.0
2018-06-01 19:00:00	AAPL	Stock	47.5825	47.625	47.575	47.625	98416.0
2018-06-01 19:30:00	AAPL	Stock	47.6175	47.625	47.59	47.6225	12168.0
2018-06-01 04:00:00	MSFT	Stock	98.99	99.19	98.99	99.19	1200.0
2018-06-01 04:30:00	MSFT	Stock	99.15	99.15	99.15	99.15	100.0
2018-06-01 06:00:00	MSFT	Stock	99.15	99.16	99.15	99.16	1100.0
2018-06-01 06:30:00	MSFT	Stock	99.1	99.18	99.1	99.18	2580.0
2018-06-01 07:00:00	MSFT	Stock	99.15	99.18	99.07	99.09	5904.0
2018-06-01 07:30:00	MSFT	Stock	99.14	99.18	99.14	99.17	1858.0
2018-06-01 08:00:00	MSFT	Stock	99.06	99.2	99.06	99.1	27686.0
2018-06-01 08:30:00	MSFT	Stock	99.1	99.27	98.84	99.27	42081.0
2018-06-01 09:00:00	MSFT	Stock	99.29	99.34	99.13	99.25	37337.0
2018-06-01 09:30:00	MSFT	Stock	99.24	99.78	99.17	99.63	2603157.0
2018-06-01 10:00:00	MSFT	Stock	99.63	100.19	99.54	100.0	2717076.0
2018-06-01 10:30:00	MSFT	Stock	99.99	100.33	99.81	100.205	2095207.0
2018-06-01 11:00:00	MSFT	Stock	100.195	100.415	100.1	100.288	1343109.0
2018-06-01 11:30:00	MSFT	Stock	100.29	100.74	100.28	100.65	1350976.0
2018-06-01 12:00:00	MSFT	Stock	100.66	100.86	100.64	100.684	1326336.0
2018-06-01 12:30:00	MSFT	Stock	100.69	100.7	100.38	100.49	1190352.0
2018-06-01 13:00:00	MSFT	Stock	100.496	100.71	100.455	100.58	1088483.0
2018-06-01 13:30:00	MSFT	Stock	100.58	100.61	100.505	100.57	685627.0

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

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