PREVIEW / stock_30min / 2021-05-04

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-05-04.parquet
  size:    2.2 MB
  rows:    112,613
  symbols: 2,987

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
2021-05-04 04:00:00	AAPL	Stock	131.88	132.08	131.76	132.08	15647.0
2021-05-04 04:30:00	AAPL	Stock	132.07	132.07	131.6	131.83	7234.0
2021-05-04 05:00:00	AAPL	Stock	131.83	131.94	131.71	131.71	8867.0
2021-05-04 05:30:00	AAPL	Stock	131.83	132.04	131.83	131.97	7122.0
2021-05-04 06:00:00	AAPL	Stock	131.99	132.01	131.72	131.78	9037.0
2021-05-04 06:30:00	AAPL	Stock	131.81	131.88	131.63	131.88	15223.0
2021-05-04 07:00:00	AAPL	Stock	131.92	132.08	131.83	131.94	55628.0
2021-05-04 07:30:00	AAPL	Stock	131.93	131.93	131.0	131.07	208790.0
2021-05-04 08:00:00	AAPL	Stock	131.94	132.08	130.87	131.0	449545.0
2021-05-04 08:30:00	AAPL	Stock	130.99	131.31	130.92	131.15	147317.0
2021-05-04 09:00:00	AAPL	Stock	131.169	131.47	130.9	131.2	317535.0
2021-05-04 09:30:00	AAPL	Stock	131.18	131.4899	128.391	128.53	16834309.0
2021-05-04 10:00:00	AAPL	Stock	128.5313	128.82	127.84	128.3	12502428.0
2021-05-04 10:30:00	AAPL	Stock	128.305	128.44	127.9	128.195	7768051.0
2021-05-04 11:00:00	AAPL	Stock	128.195	128.27	127.34	127.55	8421385.0
2021-05-04 11:30:00	AAPL	Stock	127.55	127.675	126.73	126.9301	9086754.0
2021-05-04 12:00:00	AAPL	Stock	126.93	127.48	126.88	127.435	7316882.0
2021-05-04 12:30:00	AAPL	Stock	127.435	127.44	126.84	126.87	5028512.0
2021-05-04 13:00:00	AAPL	Stock	126.87	127.2999	126.7	127.0546	6460282.0
2021-05-04 13:30:00	AAPL	Stock	127.05	127.1799	126.76	126.99	5217720.0
2021-05-04 14:00:00	AAPL	Stock	126.98	127.5	126.87	127.1906	4937513.0
2021-05-04 14:30:00	AAPL	Stock	127.19	127.59	127.13	127.4219	4229720.0
2021-05-04 15:00:00	AAPL	Stock	127.43	127.66	127.14	127.325	5547035.0
2021-05-04 15:30:00	AAPL	Stock	127.32	128.0	127.18	127.94	13340033.0
2021-05-04 16:00:00	AAPL	Stock	127.92	127.96	127.62	127.73	10269832.0
2021-05-04 16:30:00	AAPL	Stock	127.71	127.85	127.6	127.68	97241.0
2021-05-04 17:00:00	AAPL	Stock	127.67	127.79	127.67	127.71	58316.0
2021-05-04 17:30:00	AAPL	Stock	127.71	127.85	127.7	127.79	55492.0
2021-05-04 18:00:00	AAPL	Stock	127.78	127.79	127.6	127.67	44550.0
2021-05-04 18:30:00	AAPL	Stock	127.65	127.73	127.62	127.68	40125.0
2021-05-04 19:00:00	AAPL	Stock	127.69	127.85	127.55	127.59	32230.0
2021-05-04 19:30:00	AAPL	Stock	127.55	127.7	127.52	127.7	69000.0
2021-05-04 04:00:00	MSFT	Stock	251.03	251.17	251.03	251.17	2945.0
2021-05-04 04:30:00	MSFT	Stock	251.26	251.26	250.88	250.88	3909.0
2021-05-04 05:00:00	MSFT	Stock	251.05	251.18	251.05	251.17	1806.0
2021-05-04 06:00:00	MSFT	Stock	251.38	251.38	251.18	251.18	512.0
2021-05-04 06:30:00	MSFT	Stock	251.14	251.33	251.1	251.25	3104.0
2021-05-04 07:00:00	MSFT	Stock	251.28	251.36	251.1	251.23	10721.0
2021-05-04 07:30:00	MSFT	Stock	251.19	251.19	249.24	250.1	56954.0
2021-05-04 08:00:00	MSFT	Stock	250.2	251.28	249.31	249.83	32045.0
2021-05-04 08:30:00	MSFT	Stock	249.94	250.3	249.37	250.1	34467.0
2021-05-04 09:00:00	MSFT	Stock	250.0	251.0	249.7	250.98	60182.0
2021-05-04 09:30:00	MSFT	Stock	250.97	251.21	248.8904	249.131	2279009.0
2021-05-04 10:00:00	MSFT	Stock	249.155	249.41	248.34	248.76	1677262.0
2021-05-04 10:30:00	MSFT	Stock	248.76	249.14	247.761	247.955	1441363.0
2021-05-04 11:00:00	MSFT	Stock	247.95	248.0	246.33	246.96	1805011.0
2021-05-04 11:30:00	MSFT	Stock	246.98	247.09	245.76	246.11	1279238.0
2021-05-04 12:00:00	MSFT	Stock	246.11	246.76	246.0	246.72	1163637.0
2021-05-04 12:30:00	MSFT	Stock	246.73	246.755	245.78	245.93	694271.0
2021-05-04 13:00:00	MSFT	Stock	245.91	247.09	245.8376	246.89	901417.0

> showing 50 of 112,613 rows — these rows as CSV

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