PREVIEW / stock_30min / 2020-05-20

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-05-20.parquet
  size:    1.9 MB
  rows:    95,340
  symbols: 2,378

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-20 04:00:00	AAPL	Stock	78.755	79.0475	78.755	79.0475	22152.0
2020-05-20 05:00:00	AAPL	Stock	79.0675	79.0675	79.0675	79.0675	800.0
2020-05-20 05:30:00	AAPL	Stock	79.19	79.1925	79.19	79.1925	6400.0
2020-05-20 06:00:00	AAPL	Stock	79.13	79.2975	79.13	79.225	13056.0
2020-05-20 06:30:00	AAPL	Stock	79.295	79.375	79.2075	79.3625	19048.0
2020-05-20 07:00:00	AAPL	Stock	79.3075	79.375	79.1625	79.1875	158176.0
2020-05-20 07:30:00	AAPL	Stock	79.1875	79.2375	79.075	79.2225	58788.0
2020-05-20 08:00:00	AAPL	Stock	79.2	79.36	79.0625	79.205	274536.0
2020-05-20 08:30:00	AAPL	Stock	79.1925	79.205	78.285	79.1375	113532.0
2020-05-20 09:00:00	AAPL	Stock	79.2	79.25	79.0975	79.135	247112.0
2020-05-20 09:30:00	AAPL	Stock	79.17	79.7575	79.05	79.7175	16415996.0
2020-05-20 10:00:00	AAPL	Stock	79.7225	79.765	79.4635	79.4825	7557248.0
2020-05-20 10:30:00	AAPL	Stock	79.485	79.655	79.38	79.6212	5568588.0
2020-05-20 11:00:00	AAPL	Stock	79.6225	79.88	79.5725	79.8525	7102600.0
2020-05-20 11:30:00	AAPL	Stock	79.86	79.8775	79.74	79.8125	4296564.0
2020-05-20 12:00:00	AAPL	Stock	79.8175	79.87	79.4775	79.5875	6019092.0
2020-05-20 12:30:00	AAPL	Stock	79.5925	79.6565	79.2775	79.655	5093732.0
2020-05-20 13:00:00	AAPL	Stock	79.655	79.715	79.355	79.455	4276432.0
2020-05-20 13:30:00	AAPL	Stock	79.4675	79.645	79.43	79.5312	3625764.0
2020-05-20 14:00:00	AAPL	Stock	79.535	79.6298	79.33	79.4375	4872676.0
2020-05-20 14:30:00	AAPL	Stock	79.435	79.7375	79.39	79.7	4945652.0
2020-05-20 15:00:00	AAPL	Stock	79.7	79.8	79.505	79.745	5905756.0
2020-05-20 15:30:00	AAPL	Stock	79.7475	79.84	79.57	79.79	8381240.0
2020-05-20 16:00:00	AAPL	Stock	79.8075	79.8775	79.7575	79.8325	8871112.0
2020-05-20 16:30:00	AAPL	Stock	79.86	79.8875	79.8075	79.875	67948.0
2020-05-20 17:00:00	AAPL	Stock	79.8875	79.8875	79.775	79.8125	36704.0
2020-05-20 17:30:00	AAPL	Stock	79.8375	79.8975	79.835	79.88	8608.0
2020-05-20 18:00:00	AAPL	Stock	79.88	79.9	79.775	79.81	40448.0
2020-05-20 18:30:00	AAPL	Stock	79.77	79.8375	79.7625	79.8075	23572.0
2020-05-20 19:00:00	AAPL	Stock	79.8125	79.8125	79.72	79.75	15396.0
2020-05-20 19:30:00	AAPL	Stock	79.7675	79.8125	79.755	79.79	41564.0
2020-05-20 04:00:00	MSFT	Stock	184.15	185.08	184.15	185.08	878.0
2020-05-20 04:30:00	MSFT	Stock	185.2	185.5	185.12	185.45	802.0
2020-05-20 05:00:00	MSFT	Stock	185.14	185.14	185.14	185.14	562.0
2020-05-20 05:30:00	MSFT	Stock	185.24	185.6	185.24	185.6	2837.0
2020-05-20 06:00:00	MSFT	Stock	185.55	185.6	185.31	185.6	1844.0
2020-05-20 06:30:00	MSFT	Stock	185.55	185.55	185.32	185.55	1746.0
2020-05-20 07:00:00	MSFT	Stock	185.25	185.4	185.19	185.2	11926.0
2020-05-20 07:30:00	MSFT	Stock	185.28	185.35	185.0	185.09	12530.0
2020-05-20 08:00:00	MSFT	Stock	185.196	185.43	184.7	185.22	31647.0
2020-05-20 08:30:00	MSFT	Stock	185.28	185.3	183.12	185.19	13627.0
2020-05-20 09:00:00	MSFT	Stock	185.2	185.3	184.73	184.73	34492.0
2020-05-20 09:30:00	MSFT	Stock	184.81	185.295	184.5	185.005	3438879.0
2020-05-20 10:00:00	MSFT	Stock	185.0	185.1	184.51	184.95	1884027.0
2020-05-20 10:30:00	MSFT	Stock	184.96	185.16	184.31	184.36	1783360.0
2020-05-20 11:00:00	MSFT	Stock	184.36	184.95	184.34	184.87	1610757.0
2020-05-20 11:30:00	MSFT	Stock	184.87	185.0	184.64	184.87	1156610.0
2020-05-20 12:00:00	MSFT	Stock	184.88	185.01	184.55	184.72	1176935.0
2020-05-20 12:30:00	MSFT	Stock	184.73	184.79	183.94	184.5	1389077.0
2020-05-20 13:00:00	MSFT	Stock	184.51	184.69	184.17	184.47	1193069.0

> showing 50 of 95,340 rows — these rows as CSV

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