PREVIEW / stock_30min / 2020-10-21

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-10-21.parquet
  size:    1.9 MB
  rows:    97,294
  symbols: 2,514

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-10-21 04:00:00	AAPL	Stock	117.61	117.88	116.64	116.73	24735.0
2020-10-21 04:30:00	AAPL	Stock	117.0	117.3	116.53	116.59	23916.0
2020-10-21 05:00:00	AAPL	Stock	116.65	117.23	116.5	117.23	18636.0
2020-10-21 05:30:00	AAPL	Stock	117.25	117.79	117.2	117.4	11199.0
2020-10-21 06:00:00	AAPL	Stock	117.5	117.86	117.25	117.6	20092.0
2020-10-21 06:30:00	AAPL	Stock	117.6	117.94	117.33	117.33	17784.0
2020-10-21 07:00:00	AAPL	Stock	117.35	117.5	116.9	117.0	126939.0
2020-10-21 07:30:00	AAPL	Stock	117.03	117.04	116.77	116.82	90921.0
2020-10-21 08:00:00	AAPL	Stock	117.12	117.5	116.8	117.25	262898.0
2020-10-21 08:30:00	AAPL	Stock	117.19	117.4	117.11	117.17	146347.0
2020-10-21 09:00:00	AAPL	Stock	117.19	117.29	116.5	116.59	528664.0
2020-10-21 09:30:00	AAPL	Stock	116.63	118.27	116.45	118.13	10924922.0
2020-10-21 10:00:00	AAPL	Stock	118.13	118.35	117.76	118.199	5706486.0
2020-10-21 10:30:00	AAPL	Stock	118.195	118.705	117.97	118.08	6333272.0
2020-10-21 11:00:00	AAPL	Stock	118.07	118.2	117.26	117.485	5495125.0
2020-10-21 11:30:00	AAPL	Stock	117.485	117.99	117.17	117.385	4846223.0
2020-10-21 12:00:00	AAPL	Stock	117.381	118.1	116.93	117.5	6591859.0
2020-10-21 12:30:00	AAPL	Stock	117.496	117.57	116.74	116.89	5134378.0
2020-10-21 13:00:00	AAPL	Stock	116.89	117.44	116.8	117.301	3747630.0
2020-10-21 13:30:00	AAPL	Stock	117.3	117.51	116.97	117.12	3687029.0
2020-10-21 14:00:00	AAPL	Stock	117.12	117.56	116.99	117.41	3938029.0
2020-10-21 14:30:00	AAPL	Stock	117.419	117.95	117.36	117.94	4112922.0
2020-10-21 15:00:00	AAPL	Stock	117.95	118.05	117.5	117.85	4702977.0
2020-10-21 15:30:00	AAPL	Stock	117.85	117.98	116.81	116.86	8419256.0
2020-10-21 16:00:00	AAPL	Stock	116.87	117.05	116.75	116.77	7039420.0
2020-10-21 16:30:00	AAPL	Stock	116.76	117.0	116.72	116.9	108034.0
2020-10-21 17:00:00	AAPL	Stock	116.931	116.94	116.85	116.9	49142.0
2020-10-21 17:30:00	AAPL	Stock	116.9	116.93	116.63	116.82	113818.0
2020-10-21 18:00:00	AAPL	Stock	116.81	116.81	116.5	116.69	145602.0
2020-10-21 18:30:00	AAPL	Stock	116.68	116.69	116.58	116.59	79480.0
2020-10-21 19:00:00	AAPL	Stock	116.6	116.68	116.51	116.57	92542.0
2020-10-21 19:30:00	AAPL	Stock	116.56	116.57	116.0	116.39	217629.0
2020-10-21 04:00:00	MSFT	Stock	215.46	215.46	213.81	213.81	5780.0
2020-10-21 04:30:00	MSFT	Stock	214.03	214.03	213.0	213.0	3701.0
2020-10-21 05:00:00	MSFT	Stock	212.6	214.0	212.6	213.81	7735.0
2020-10-21 05:30:00	MSFT	Stock	214.2	214.89	214.2	214.61	2451.0
2020-10-21 06:00:00	MSFT	Stock	214.8	214.88	214.58	214.8	1593.0
2020-10-21 06:30:00	MSFT	Stock	214.76	215.0	214.75	215.0	997.0
2020-10-21 07:00:00	MSFT	Stock	214.96	214.97	213.64	213.8	11368.0
2020-10-21 07:30:00	MSFT	Stock	213.9	213.9	213.12	213.15	17263.0
2020-10-21 08:00:00	MSFT	Stock	214.402	214.402	213.05	213.836	32000.0
2020-10-21 08:30:00	MSFT	Stock	213.83	214.2	213.83	213.88	31510.0
2020-10-21 09:00:00	MSFT	Stock	214.0	214.25	213.0	213.23	60452.0
2020-10-21 09:30:00	MSFT	Stock	213.45	216.29	213.12	216.22	2818761.0
2020-10-21 10:00:00	MSFT	Stock	216.24	216.46	215.57	215.8	1101295.0
2020-10-21 10:30:00	MSFT	Stock	215.799	215.93	214.91	215.22	926235.0
2020-10-21 11:00:00	MSFT	Stock	215.22	215.49	213.69	214.48	1122368.0
2020-10-21 11:30:00	MSFT	Stock	214.48	215.26	214.0	214.2	915657.0
2020-10-21 12:00:00	MSFT	Stock	214.225	215.718	213.79	214.81	1126886.0
2020-10-21 12:30:00	MSFT	Stock	214.808	214.94	213.71	214.16	730095.0

> showing 50 of 97,294 rows — these rows as CSV

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