PREVIEW / stock_30min / 2019-06-21

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-06-21.parquet
  size:    1.7 MB
  rows:    85,593
  symbols: 2,597

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
2019-06-21 04:00:00	AAPL	Stock	49.6875	49.6875	49.565	49.65	7968.0
2019-06-21 04:30:00	AAPL	Stock	49.65	49.675	49.65	49.675	1200.0
2019-06-21 05:00:00	AAPL	Stock	49.625	49.65	49.625	49.65	4120.0
2019-06-21 05:30:00	AAPL	Stock	49.6525	49.655	49.6525	49.655	1600.0
2019-06-21 06:00:00	AAPL	Stock	49.5375	49.5375	49.5375	49.5375	400.0
2019-06-21 06:30:00	AAPL	Stock	49.5225	49.5725	49.5	49.5725	10928.0
2019-06-21 07:00:00	AAPL	Stock	49.5525	49.675	49.495	49.5	73512.0
2019-06-21 07:30:00	AAPL	Stock	49.47	49.54	49.465	49.515	113040.0
2019-06-21 08:00:00	AAPL	Stock	49.515	49.6625	49.4375	49.53	173220.0
2019-06-21 08:30:00	AAPL	Stock	49.5425	49.6425	49.5125	49.6225	80332.0
2019-06-21 09:00:00	AAPL	Stock	49.625	49.75	49.575	49.6225	436240.0
2019-06-21 09:30:00	AAPL	Stock	49.615	49.8325	49.5375	49.7625	26810588.0
2019-06-21 10:00:00	AAPL	Stock	49.7625	49.955	49.7575	49.95	4879644.0
2019-06-21 10:30:00	AAPL	Stock	49.9475	50.0625	49.935	49.97	6223396.0
2019-06-21 11:00:00	AAPL	Stock	49.975	50.185	49.9675	50.0622	6239012.0
2019-06-21 11:30:00	AAPL	Stock	50.0608	50.1	49.9275	49.9825	3306712.0
2019-06-21 12:00:00	AAPL	Stock	49.98	50.0225	49.9025	49.98	3084360.0
2019-06-21 12:30:00	AAPL	Stock	49.975	50.1125	49.935	50.1015	3258240.0
2019-06-21 13:00:00	AAPL	Stock	50.1018	50.2125	50.085	50.144	4290512.0
2019-06-21 13:30:00	AAPL	Stock	50.1475	50.1575	50.0575	50.12	1882952.0
2019-06-21 14:00:00	AAPL	Stock	50.1175	50.1525	49.9925	50.008	2599356.0
2019-06-21 14:30:00	AAPL	Stock	50.01	50.02	49.96	49.9725	3270616.0
2019-06-21 15:00:00	AAPL	Stock	49.975	50.0175	49.9225	49.9353	4008100.0
2019-06-21 15:30:00	AAPL	Stock	49.935	49.995	49.6575	49.7	13124264.0
2019-06-21 16:00:00	AAPL	Stock	49.695	49.7375	49.565	49.6125	62573340.0
2019-06-21 16:30:00	AAPL	Stock	49.625	49.7	49.6	49.6625	317728.0
2019-06-21 17:00:00	AAPL	Stock	49.64	49.655	49.625	49.625	53548.0
2019-06-21 17:30:00	AAPL	Stock	49.66	49.695	49.625	49.625	473000.0
2019-06-21 18:00:00	AAPL	Stock	49.625	49.65	49.615	49.615	9744.0
2019-06-21 18:30:00	AAPL	Stock	49.6025	49.625	49.5625	49.5825	20720.0
2019-06-21 19:00:00	AAPL	Stock	49.61	49.6175	49.5625	49.575	7924.0
2019-06-21 19:30:00	AAPL	Stock	49.5525	49.59	49.45	49.525	42592.0
2019-06-21 05:00:00	MSFT	Stock	136.78	136.83	136.78	136.83	200.0
2019-06-21 05:30:00	MSFT	Stock	136.92	136.92	136.92	136.92	300.0
2019-06-21 07:00:00	MSFT	Stock	136.55	136.62	136.32	136.4	8933.0
2019-06-21 07:30:00	MSFT	Stock	136.43	136.59	136.42	136.59	3801.0
2019-06-21 08:00:00	MSFT	Stock	136.619	137.29	135.3	135.3	102889.0
2019-06-21 08:30:00	MSFT	Stock	135.57	135.96	135.5	135.92	27098.0
2019-06-21 09:00:00	MSFT	Stock	135.8	136.95	135.8	136.58	216051.0
2019-06-21 09:30:00	MSFT	Stock	136.53	136.99	136.46	136.99	9074382.0
2019-06-21 10:00:00	MSFT	Stock	137.0	137.382	136.8	137.005	1630414.0
2019-06-21 10:30:00	MSFT	Stock	137.01	137.47	136.97	137.18	1636785.0
2019-06-21 11:00:00	MSFT	Stock	137.19	137.73	137.175	137.39	1632509.0
2019-06-21 11:30:00	MSFT	Stock	137.39	137.57	137.12	137.245	941513.0
2019-06-21 12:00:00	MSFT	Stock	137.24	137.38	136.95	137.095	820929.0
2019-06-21 12:30:00	MSFT	Stock	137.09	137.22	136.92	137.19	535007.0
2019-06-21 13:00:00	MSFT	Stock	137.2	137.35	137.09	137.125	729659.0
2019-06-21 13:30:00	MSFT	Stock	137.121	137.21	136.93	137.0	716610.0
2019-06-21 14:00:00	MSFT	Stock	137.0	137.16	136.72	136.83	886397.0
2019-06-21 14:30:00	MSFT	Stock	136.84	137.13	136.8	137.06	708595.0

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

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