PREVIEW / stock_30min / 2021-07-12

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-07-12.parquet
  size:    2.2 MB
  rows:    109,744
  symbols: 2,884

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-07-12 04:00:00	AAPL	Stock	144.8	145.47	144.75	145.44	23198.0
2021-07-12 04:30:00	AAPL	Stock	145.48	145.54	145.43	145.53	7331.0
2021-07-12 05:00:00	AAPL	Stock	145.54	145.61	145.5	145.51	15259.0
2021-07-12 05:30:00	AAPL	Stock	145.49	145.65	145.49	145.55	6130.0
2021-07-12 06:00:00	AAPL	Stock	145.54	145.54	145.3	145.48	11888.0
2021-07-12 06:30:00	AAPL	Stock	145.45	145.48	145.35	145.35	14484.0
2021-07-12 07:00:00	AAPL	Stock	145.37	145.71	145.3	145.66	144870.0
2021-07-12 07:30:00	AAPL	Stock	145.65	145.85	145.63	145.78	112178.0
2021-07-12 08:00:00	AAPL	Stock	145.4501	146.2	144.748	146.16	479227.0
2021-07-12 08:30:00	AAPL	Stock	146.14	146.2	145.98	146.11	260311.0
2021-07-12 09:00:00	AAPL	Stock	146.11	146.24	146.07	146.21	264722.0
2021-07-12 09:30:00	AAPL	Stock	146.21	146.32	144.09	144.6298	16771622.0
2021-07-12 10:00:00	AAPL	Stock	144.625	144.86	144.0	144.615	7212518.0
2021-07-12 10:30:00	AAPL	Stock	144.62	145.25	144.43	144.9893	6072749.0
2021-07-12 11:00:00	AAPL	Stock	144.985	145.155	144.69	144.75	3952657.0
2021-07-12 11:30:00	AAPL	Stock	144.76	144.94	144.575	144.85	2781118.0
2021-07-12 12:00:00	AAPL	Stock	144.86	145.075	144.76	144.835	2247788.0
2021-07-12 12:30:00	AAPL	Stock	144.83	144.87	144.63	144.7086	1749138.0
2021-07-12 13:00:00	AAPL	Stock	144.705	144.76	144.5	144.577	2197736.0
2021-07-12 13:30:00	AAPL	Stock	144.5708	144.59	144.16	144.4	2573535.0
2021-07-12 14:00:00	AAPL	Stock	144.4	144.68	144.35	144.66	2317162.0
2021-07-12 14:30:00	AAPL	Stock	144.655	144.75	144.61	144.7434	2117994.0
2021-07-12 15:00:00	AAPL	Stock	144.75	144.8	144.5101	144.62	2633739.0
2021-07-12 15:30:00	AAPL	Stock	144.63	144.66	144.42	144.51	5740686.0
2021-07-12 16:00:00	AAPL	Stock	144.5	144.77	144.35	144.55	7084599.0
2021-07-12 16:30:00	AAPL	Stock	144.55	144.58	144.51	144.57	20263.0
2021-07-12 17:00:00	AAPL	Stock	144.55	144.55	144.41	144.46	26224.0
2021-07-12 17:30:00	AAPL	Stock	144.46	144.48	144.43	144.43	13434.0
2021-07-12 18:00:00	AAPL	Stock	144.45	144.46	144.42	144.42	12755.0
2021-07-12 18:30:00	AAPL	Stock	144.42	144.48	144.4	144.46	17429.0
2021-07-12 19:00:00	AAPL	Stock	144.45	144.48	144.42	144.45	9492.0
2021-07-12 19:30:00	AAPL	Stock	144.46	144.47	144.41	144.41	36173.0
2021-07-12 04:00:00	MSFT	Stock	277.63	278.47	277.63	278.47	210.0
2021-07-12 04:30:00	MSFT	Stock	278.2	278.2	277.84	278.2	1137.0
2021-07-12 05:00:00	MSFT	Stock	278.5	278.5	278.5	278.5	221.0
2021-07-12 05:30:00	MSFT	Stock	278.5	278.7	278.5	278.7	2829.0
2021-07-12 06:00:00	MSFT	Stock	278.5	278.5	277.98	278.15	5098.0
2021-07-12 06:30:00	MSFT	Stock	278.14	278.7	278.14	278.49	3351.0
2021-07-12 07:00:00	MSFT	Stock	278.22	278.78	278.22	278.76	20554.0
2021-07-12 07:30:00	MSFT	Stock	278.77	278.95	278.77	278.84	10425.0
2021-07-12 08:00:00	MSFT	Stock	278.5	279.5	278.4	279.5	21285.0
2021-07-12 08:30:00	MSFT	Stock	279.4	279.43	279.25	279.35	11109.0
2021-07-12 09:00:00	MSFT	Stock	279.33	279.61	278.99	278.99	16985.0
2021-07-12 09:30:00	MSFT	Stock	278.94	279.77	277.6	277.92	2006476.0
2021-07-12 10:00:00	MSFT	Stock	277.93	277.93	276.95	277.145	1074632.0
2021-07-12 10:30:00	MSFT	Stock	277.16	277.94	276.825	277.72	756486.0
2021-07-12 11:00:00	MSFT	Stock	277.72	277.97	277.33	277.4	569177.0
2021-07-12 11:30:00	MSFT	Stock	277.42	277.4495	276.77	277.22	520568.0
2021-07-12 12:00:00	MSFT	Stock	277.23	277.32	276.58	277.03	598460.0
2021-07-12 12:30:00	MSFT	Stock	277.07	277.46	277.03	277.2617	387980.0

> showing 50 of 109,744 rows — these rows as CSV

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