PREVIEW / stock_30min / 2019-10-16

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-16.parquet
  size:    1.7 MB
  rows:    83,351
  symbols: 2,517

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-10-16 04:00:00	AAPL	Stock	58.75	58.75	58.6325	58.65	13384.0
2019-10-16 04:30:00	AAPL	Stock	58.675	58.675	58.675	58.675	800.0
2019-10-16 05:00:00	AAPL	Stock	58.655	58.6625	58.6	58.6625	5320.0
2019-10-16 05:30:00	AAPL	Stock	58.6075	58.6075	58.565	58.565	22696.0
2019-10-16 06:00:00	AAPL	Stock	58.65	58.6625	58.65	58.6625	5108.0
2019-10-16 06:30:00	AAPL	Stock	58.6	58.6	58.6	58.6	8400.0
2019-10-16 07:00:00	AAPL	Stock	58.625	58.6875	58.61	58.6875	42048.0
2019-10-16 07:30:00	AAPL	Stock	58.6825	58.7125	58.635	58.66	35964.0
2019-10-16 08:00:00	AAPL	Stock	58.625	58.785	58.625	58.68	130080.0
2019-10-16 08:30:00	AAPL	Stock	58.66	58.6925	58.625	58.6725	100288.0
2019-10-16 09:00:00	AAPL	Stock	58.6875	58.6925	58.3125	58.335	515048.0
2019-10-16 09:30:00	AAPL	Stock	58.3425	58.81	58.3	58.64	12382640.0
2019-10-16 10:00:00	AAPL	Stock	58.6325	58.665	58.4	58.485	6494312.0
2019-10-16 10:30:00	AAPL	Stock	58.4875	58.65	58.45	58.615	4709488.0
2019-10-16 11:00:00	AAPL	Stock	58.61	58.6842	58.4875	58.495	3593556.0
2019-10-16 11:30:00	AAPL	Stock	58.4975	58.6275	58.4425	58.59	3667264.0
2019-10-16 12:00:00	AAPL	Stock	58.5925	58.6225	58.475	58.4975	2628708.0
2019-10-16 12:30:00	AAPL	Stock	58.4962	58.5	58.3988	58.425	2965644.0
2019-10-16 13:00:00	AAPL	Stock	58.426	58.515	58.415	58.435	2195692.0
2019-10-16 13:30:00	AAPL	Stock	58.4338	58.5	58.405	58.4275	2456240.0
2019-10-16 14:00:00	AAPL	Stock	58.425	58.495	58.4125	58.4625	1907504.0
2019-10-16 14:30:00	AAPL	Stock	58.465	58.5375	58.465	58.4962	2282288.0
2019-10-16 15:00:00	AAPL	Stock	58.4975	58.5275	58.4275	58.4825	2610408.0
2019-10-16 15:30:00	AAPL	Stock	58.4825	58.645	58.4688	58.5975	6375984.0
2019-10-16 16:00:00	AAPL	Stock	58.5975	58.7	58.5875	58.6375	6712512.0
2019-10-16 16:30:00	AAPL	Stock	58.6275	58.6625	58.5925	58.6625	55680.0
2019-10-16 17:00:00	AAPL	Stock	58.6625	58.7	58.6625	58.6675	17980.0
2019-10-16 17:30:00	AAPL	Stock	58.675	58.6825	58.675	58.6825	7584.0
2019-10-16 18:00:00	AAPL	Stock	58.695	58.6975	58.63	58.65	53048.0
2019-10-16 18:30:00	AAPL	Stock	58.6325	58.6325	58.61	58.61	12140.0
2019-10-16 19:00:00	AAPL	Stock	58.6475	58.6475	58.615	58.625	5300.0
2019-10-16 19:30:00	AAPL	Stock	58.6225	58.6225	58.5625	58.5875	65076.0
2019-10-16 05:00:00	MSFT	Stock	141.36	141.36	141.36	141.36	100.0
2019-10-16 06:00:00	MSFT	Stock	141.29	141.3	141.29	141.3	1322.0
2019-10-16 06:30:00	MSFT	Stock	141.3	141.3	141.3	141.3	217.0
2019-10-16 07:00:00	MSFT	Stock	141.28	141.3	141.23	141.23	1200.0
2019-10-16 07:30:00	MSFT	Stock	141.3	141.36	141.3	141.34	2145.0
2019-10-16 08:00:00	MSFT	Stock	141.3	141.5	141.19	141.43	12626.0
2019-10-16 08:30:00	MSFT	Stock	141.32	141.32	141.0	141.01	6422.0
2019-10-16 09:00:00	MSFT	Stock	141.1	141.208	140.75	140.77	31617.0
2019-10-16 09:30:00	MSFT	Stock	140.74	140.99	139.53	139.695	3321142.0
2019-10-16 10:00:00	MSFT	Stock	139.67	140.37	139.59	140.29	1581186.0
2019-10-16 10:30:00	MSFT	Stock	140.3	140.69	140.19	140.51	1602159.0
2019-10-16 11:00:00	MSFT	Stock	140.5	140.64	140.01	140.105	1174078.0
2019-10-16 11:30:00	MSFT	Stock	140.105	140.2	139.86	139.97	968494.0
2019-10-16 12:00:00	MSFT	Stock	139.96	140.1	139.93	140.095	597591.0
2019-10-16 12:30:00	MSFT	Stock	140.09	140.16	139.77	139.92	705330.0
2019-10-16 13:00:00	MSFT	Stock	139.92	140.01	139.79	139.958	662373.0
2019-10-16 13:30:00	MSFT	Stock	139.97	140.14	139.85	139.88	855136.0
2019-10-16 14:00:00	MSFT	Stock	139.88	140.13	139.82	140.05	700034.0

> showing 50 of 83,351 rows — these rows as CSV

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