PREVIEW / stock_30min / 2020-05-08

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-05-08.parquet
  size:    1.9 MB
  rows:    94,113
  symbols: 2,384

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
2020-05-08 04:00:00	AAPL	Stock	76.6275	76.6625	76.35	76.375	47384.0
2020-05-08 04:30:00	AAPL	Stock	76.3925	76.45	76.375	76.45	10256.0
2020-05-08 05:00:00	AAPL	Stock	76.555	76.575	76.555	76.575	3168.0
2020-05-08 05:30:00	AAPL	Stock	76.5	76.655	76.5	76.655	13772.0
2020-05-08 06:00:00	AAPL	Stock	76.6425	76.7475	76.6325	76.665	15084.0
2020-05-08 06:30:00	AAPL	Stock	76.7	76.7475	76.6325	76.72	18576.0
2020-05-08 07:00:00	AAPL	Stock	76.6525	76.6775	76.48	76.64	110140.0
2020-05-08 07:30:00	AAPL	Stock	76.6475	76.6475	76.5125	76.56	48292.0
2020-05-08 08:00:00	AAPL	Stock	76.6232	76.645	76.1225	76.45	236344.0
2020-05-08 08:30:00	AAPL	Stock	76.4875	76.7668	76.45	76.6325	559588.0
2020-05-08 09:00:00	AAPL	Stock	76.6125	76.6825	76.335	76.375	510076.0
2020-05-08 09:30:00	AAPL	Stock	76.41	76.535	76.0725	76.215	12806976.0
2020-05-08 10:00:00	AAPL	Stock	76.225	76.57	76.215	76.57	9015632.0
2020-05-08 10:30:00	AAPL	Stock	76.565	76.6825	76.5075	76.5825	7018796.0
2020-05-08 11:00:00	AAPL	Stock	76.595	76.655	76.475	76.5842	4019296.0
2020-05-08 11:30:00	AAPL	Stock	76.5825	77.0	76.5775	76.9975	7272248.0
2020-05-08 12:00:00	AAPL	Stock	76.9925	77.095	76.935	77.025	6510452.0
2020-05-08 12:30:00	AAPL	Stock	77.02	77.1175	76.98	77.0625	3788664.0
2020-05-08 13:00:00	AAPL	Stock	77.06	77.125	76.8382	76.9012	4282292.0
2020-05-08 13:30:00	AAPL	Stock	76.9025	76.9925	76.69	76.77	4225300.0
2020-05-08 14:00:00	AAPL	Stock	76.7675	76.9575	76.66	76.915	4012724.0
2020-05-08 14:30:00	AAPL	Stock	76.9225	76.9825	76.835	76.9317	3339624.0
2020-05-08 15:00:00	AAPL	Stock	76.93	77.4625	76.92	77.3988	17071552.0
2020-05-08 15:30:00	AAPL	Stock	77.395	77.5875	77.36	77.537	17004492.0
2020-05-08 16:00:00	AAPL	Stock	77.4375	77.5875	76.9925	77.5125	8670644.0
2020-05-08 16:30:00	AAPL	Stock	77.5125	77.595	77.4825	77.595	182984.0
2020-05-08 17:00:00	AAPL	Stock	77.58	77.6175	77.525	77.565	88340.0
2020-05-08 17:30:00	AAPL	Stock	77.5675	77.6375	77.55	77.6375	62600.0
2020-05-08 18:00:00	AAPL	Stock	77.625	77.6375	77.5875	77.625	33032.0
2020-05-08 18:30:00	AAPL	Stock	77.605	77.685	77.6	77.65	36568.0
2020-05-08 19:00:00	AAPL	Stock	77.6775	77.685	77.6375	77.6625	61228.0
2020-05-08 19:30:00	AAPL	Stock	77.66	77.675	77.6375	77.6375	54896.0
2020-05-08 04:00:00	MSFT	Stock	185.33	185.4	185.0	185.19	1560.0
2020-05-08 04:30:00	MSFT	Stock	185.18	185.46	185.18	185.23	3185.0
2020-05-08 05:00:00	MSFT	Stock	185.39	185.84	185.39	185.7	2100.0
2020-05-08 05:30:00	MSFT	Stock	185.63	186.0	185.62	186.0	2189.0
2020-05-08 06:00:00	MSFT	Stock	186.0	186.17	185.88	186.0	2715.0
2020-05-08 06:30:00	MSFT	Stock	185.95	185.95	185.75	185.82	5531.0
2020-05-08 07:00:00	MSFT	Stock	185.55	185.8	185.4	185.69	27751.0
2020-05-08 07:30:00	MSFT	Stock	185.58	185.6	185.35	185.48	20441.0
2020-05-08 08:00:00	MSFT	Stock	185.75	185.75	184.05	184.86	45565.0
2020-05-08 08:30:00	MSFT	Stock	184.84	185.8	184.84	185.09	101323.0
2020-05-08 09:00:00	MSFT	Stock	185.07	185.24	184.47	184.86	90218.0
2020-05-08 09:30:00	MSFT	Stock	184.86	184.98	183.38	183.726	4025873.0
2020-05-08 10:00:00	MSFT	Stock	183.725	184.59	183.36	184.4	2609150.0
2020-05-08 10:30:00	MSFT	Stock	184.41	184.65	183.89	184.399	1591745.0
2020-05-08 11:00:00	MSFT	Stock	184.4	184.45	183.96	184.288	1248427.0
2020-05-08 11:30:00	MSFT	Stock	184.28	184.75	184.25	184.52	1289062.0
2020-05-08 12:00:00	MSFT	Stock	184.526	184.7	184.275	184.375	1016300.0
2020-05-08 12:30:00	MSFT	Stock	184.38	184.94	184.35	184.92	1041524.0

> showing 50 of 94,113 rows — these rows as CSV

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