PREVIEW / stock_30min / 2021-06-14

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-06-14.parquet
  size:    2.3 MB
  rows:    114,529
  symbols: 2,968

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-06-14 04:00:00	AAPL	Stock	127.4	127.75	127.4	127.5	10438.0
2021-06-14 04:30:00	AAPL	Stock	127.5	127.61	127.5	127.6	2906.0
2021-06-14 05:00:00	AAPL	Stock	127.6	127.7	127.6	127.68	2549.0
2021-06-14 05:30:00	AAPL	Stock	127.68	127.72	127.65	127.65	3434.0
2021-06-14 06:00:00	AAPL	Stock	127.65	127.86	127.65	127.84	5063.0
2021-06-14 06:30:00	AAPL	Stock	127.79	127.99	127.78	127.94	4801.0
2021-06-14 07:00:00	AAPL	Stock	127.87	128.19	127.76	127.9	110248.0
2021-06-14 07:30:00	AAPL	Stock	127.9	127.9	127.75	127.81	35449.0
2021-06-14 08:00:00	AAPL	Stock	127.8399	128.0799	127.74	127.75	155519.0
2021-06-14 08:30:00	AAPL	Stock	127.78	127.82	127.56	127.66	93245.0
2021-06-14 09:00:00	AAPL	Stock	127.645	128.0	127.43	127.8	166090.0
2021-06-14 09:30:00	AAPL	Stock	127.82	129.34	127.07	129.12	13064937.0
2021-06-14 10:00:00	AAPL	Stock	129.12	129.17	128.47	129.1441	6115136.0
2021-06-14 10:30:00	AAPL	Stock	129.145	129.6	128.75	129.58	5787447.0
2021-06-14 11:00:00	AAPL	Stock	129.5724	129.78	129.25	129.69	4913286.0
2021-06-14 11:30:00	AAPL	Stock	129.69	129.88	129.35	129.4799	3537008.0
2021-06-14 12:00:00	AAPL	Stock	129.475	129.53	129.35	129.48	2934301.0
2021-06-14 12:30:00	AAPL	Stock	129.4757	129.59	129.2626	129.565	3448759.0
2021-06-14 13:00:00	AAPL	Stock	129.565	129.96	129.525	129.925	3468718.0
2021-06-14 13:30:00	AAPL	Stock	129.9201	130.0	129.85	129.9191	2714073.0
2021-06-14 14:00:00	AAPL	Stock	129.915	130.225	129.81	130.1001	4602312.0
2021-06-14 14:30:00	AAPL	Stock	130.105	130.4	130.0	130.075	3545025.0
2021-06-14 15:00:00	AAPL	Stock	130.07	130.115	129.74	130.06	3725680.0
2021-06-14 15:30:00	AAPL	Stock	130.06	130.49	129.795	130.49	9009332.0
2021-06-14 16:00:00	AAPL	Stock	130.485	130.54	130.21	130.43	19195135.0
2021-06-14 16:30:00	AAPL	Stock	130.43	130.45	130.34	130.38	41407.0
2021-06-14 17:00:00	AAPL	Stock	130.39	130.48	130.17	130.23	74172.0
2021-06-14 17:30:00	AAPL	Stock	130.25	130.3	130.22	130.28	33231.0
2021-06-14 18:00:00	AAPL	Stock	130.28	130.2999	130.22	130.22	16086.0
2021-06-14 18:30:00	AAPL	Stock	130.21	130.35	130.21	130.28	27828.0
2021-06-14 19:00:00	AAPL	Stock	130.28	130.34	130.22	130.25	23686.0
2021-06-14 19:30:00	AAPL	Stock	130.26	130.27	130.18	130.2	44656.0
2021-06-14 04:00:00	MSFT	Stock	258.29	258.5	258.25	258.5	464.0
2021-06-14 05:00:00	MSFT	Stock	258.6	258.6	258.6	258.6	100.0
2021-06-14 05:30:00	MSFT	Stock	258.6	258.6	258.6	258.6	100.0
2021-06-14 06:00:00	MSFT	Stock	258.69	258.69	258.68	258.69	2791.0
2021-06-14 06:30:00	MSFT	Stock	258.69	258.9	258.69	258.9	1370.0
2021-06-14 07:00:00	MSFT	Stock	258.54	258.87	258.5	258.71	6080.0
2021-06-14 07:30:00	MSFT	Stock	258.68	258.68	258.5	258.65	3115.0
2021-06-14 08:00:00	MSFT	Stock	258.7999	258.8	258.46	258.52	4484.0
2021-06-14 08:30:00	MSFT	Stock	258.52	258.52	258.23	258.33	1947.0
2021-06-14 09:00:00	MSFT	Stock	258.39	258.39	257.8	257.8	13419.0
2021-06-14 09:30:00	MSFT	Stock	257.9	258.65	256.8	257.74	1799022.0
2021-06-14 10:00:00	MSFT	Stock	257.75	257.84	256.94	257.33	918015.0
2021-06-14 10:30:00	MSFT	Stock	257.34	257.725	257.17	257.67	619011.0
2021-06-14 11:00:00	MSFT	Stock	257.66	257.99	257.52	257.9	623298.0
2021-06-14 11:30:00	MSFT	Stock	257.91	257.99	257.63	257.925	417054.0
2021-06-14 12:00:00	MSFT	Stock	257.915	258.14	257.79	257.81	439748.0
2021-06-14 12:30:00	MSFT	Stock	257.8	257.95	257.6583	257.925	304040.0
2021-06-14 13:00:00	MSFT	Stock	257.93	258.205	257.86	258.16	412896.0

> showing 50 of 114,529 rows — these rows as CSV

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