PREVIEW / stock_30min / 2020-08-19

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-08-19.parquet
  size:    1.9 MB
  rows:    96,765
  symbols: 2,463

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-08-19 04:00:00	AAPL	Stock	115.97	115.9825	115.8675	115.8675	5780.0
2020-08-19 04:30:00	AAPL	Stock	115.9625	116.0275	115.9625	116.025	5780.0
2020-08-19 05:00:00	AAPL	Stock	116.07	116.125	116.07	116.125	800.0
2020-08-19 05:30:00	AAPL	Stock	116.095	116.1	116.05	116.05	2336.0
2020-08-19 06:00:00	AAPL	Stock	116.0325	116.0625	115.9525	116.0	20696.0
2020-08-19 06:30:00	AAPL	Stock	116.0575	116.06	116.055	116.0575	5864.0
2020-08-19 07:00:00	AAPL	Stock	116.04	116.075	115.5625	115.6375	175620.0
2020-08-19 07:30:00	AAPL	Stock	115.625	115.795	115.575	115.795	57792.0
2020-08-19 08:00:00	AAPL	Stock	115.9	116.0625	115.4625	115.5	255620.0
2020-08-19 08:30:00	AAPL	Stock	115.525	115.6425	115.4525	115.625	165092.0
2020-08-19 09:00:00	AAPL	Stock	115.6225	116.0	115.5625	115.9525	325792.0
2020-08-19 09:30:00	AAPL	Stock	115.99	116.594	115.6175	116.1628	15471924.0
2020-08-19 10:00:00	AAPL	Stock	116.165	116.8	116.1588	116.7175	8813932.0
2020-08-19 10:30:00	AAPL	Stock	116.7212	117.0225	116.6	116.9815	10829340.0
2020-08-19 11:00:00	AAPL	Stock	116.98	117.1625	116.6375	116.8825	9391432.0
2020-08-19 11:30:00	AAPL	Stock	116.9025	117.0175	116.6462	117.005	4536976.0
2020-08-19 12:00:00	AAPL	Stock	117.0025	117.11	116.7075	116.785	5285408.0
2020-08-19 12:30:00	AAPL	Stock	116.8	116.985	116.6738	116.9688	4175496.0
2020-08-19 13:00:00	AAPL	Stock	116.9725	117.025	116.815	116.82	3303948.0
2020-08-19 13:30:00	AAPL	Stock	116.8218	116.9625	116.61	116.775	5402304.0
2020-08-19 14:00:00	AAPL	Stock	116.775	116.825	115.61	116.025	11234848.0
2020-08-19 14:30:00	AAPL	Stock	116.0262	116.5375	115.95	116.3712	7572160.0
2020-08-19 15:00:00	AAPL	Stock	116.3725	116.4625	116.0775	116.195	6560000.0
2020-08-19 15:30:00	AAPL	Stock	116.1938	116.26	115.61	115.7062	11455908.0
2020-08-19 16:00:00	AAPL	Stock	115.7075	116.4695	115.7075	115.8375	7840808.0
2020-08-19 16:30:00	AAPL	Stock	115.8375	116.95	115.7075	115.95	125392.0
2020-08-19 17:00:00	AAPL	Stock	115.975	116.1875	115.8175	115.8175	104816.0
2020-08-19 17:30:00	AAPL	Stock	115.875	115.95	115.805	115.92	71356.0
2020-08-19 18:00:00	AAPL	Stock	115.8625	116.05	115.8625	115.9725	20120.0
2020-08-19 18:30:00	AAPL	Stock	115.9975	115.9975	115.875	115.95	44476.0
2020-08-19 19:00:00	AAPL	Stock	115.9375	115.9375	115.7875	115.7875	48120.0
2020-08-19 19:30:00	AAPL	Stock	115.7875	115.7875	115.5875	115.615	164136.0
2020-08-19 04:00:00	MSFT	Stock	211.55	211.6	211.55	211.6	2073.0
2020-08-19 04:30:00	MSFT	Stock	211.61	211.61	211.61	211.61	200.0
2020-08-19 05:00:00	MSFT	Stock	211.7	211.9	211.7	211.9	945.0
2020-08-19 05:30:00	MSFT	Stock	211.68	211.9	211.68	211.85	900.0
2020-08-19 06:00:00	MSFT	Stock	211.81	211.89	211.81	211.89	249.0
2020-08-19 06:30:00	MSFT	Stock	211.73	211.73	211.61	211.61	1291.0
2020-08-19 07:00:00	MSFT	Stock	211.75	211.75	211.36	211.4	11713.0
2020-08-19 07:30:00	MSFT	Stock	211.35	211.4	211.3	211.33	5279.0
2020-08-19 08:00:00	MSFT	Stock	211.366	211.6	210.84	210.98	70893.0
2020-08-19 08:30:00	MSFT	Stock	211.0	211.195	210.8	211.0	11695.0
2020-08-19 09:00:00	MSFT	Stock	210.997	211.68	210.8	211.64	31834.0
2020-08-19 09:30:00	MSFT	Stock	211.64	211.92	209.45	210.1	2244889.0
2020-08-19 10:00:00	MSFT	Stock	210.03	210.9	209.56	210.85	1146968.0
2020-08-19 10:30:00	MSFT	Stock	210.85	210.886	210.13	210.39	708310.0
2020-08-19 11:00:00	MSFT	Stock	210.39	211.14	210.12	210.93	795641.0
2020-08-19 11:30:00	MSFT	Stock	210.9	211.82	210.88	211.69	1082697.0
2020-08-19 12:00:00	MSFT	Stock	211.683	211.97	211.345	211.61	792262.0
2020-08-19 12:30:00	MSFT	Stock	211.6	211.99	211.4	211.99	896430.0

> showing 50 of 96,765 rows — these rows as CSV

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