PREVIEW / stock_30min / 2021-07-14

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-07-14.parquet
  size:    2.2 MB
  rows:    110,995
  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-14 04:00:00	AAPL	Stock	146.7	147.4	146.11	147.23	73336.0
2021-07-14 04:30:00	AAPL	Stock	147.29	147.62	147.23	147.45	45421.0
2021-07-14 05:00:00	AAPL	Stock	147.4	147.79	147.4	147.65	27842.0
2021-07-14 05:30:00	AAPL	Stock	147.65	148.09	147.65	147.97	26778.0
2021-07-14 06:00:00	AAPL	Stock	147.95	148.0	147.8	147.99	24646.0
2021-07-14 06:30:00	AAPL	Stock	147.95	148.09	147.88	148.0	74032.0
2021-07-14 07:00:00	AAPL	Stock	147.88	148.48	147.7	148.48	388285.0
2021-07-14 07:30:00	AAPL	Stock	148.48	148.78	148.35	148.62	222745.0
2021-07-14 08:00:00	AAPL	Stock	147.7499	148.77	145.276	148.151	737075.0
2021-07-14 08:30:00	AAPL	Stock	148.14	148.61	148.05	148.41	612422.0
2021-07-14 09:00:00	AAPL	Stock	148.41	148.45	145.6022	148.05	626562.0
2021-07-14 09:30:00	AAPL	Stock	148.05	148.96	147.68	148.35	20457883.0
2021-07-14 10:00:00	AAPL	Stock	148.37	148.94	148.11	148.31	10357388.0
2021-07-14 10:30:00	AAPL	Stock	148.32	149.32	148.17	149.3184	10610653.0
2021-07-14 11:00:00	AAPL	Stock	149.315	149.45	148.63	148.7998	8376596.0
2021-07-14 11:30:00	AAPL	Stock	148.795	148.9799	147.93	148.015	7805353.0
2021-07-14 12:00:00	AAPL	Stock	148.015	149.09	147.9745	148.905	7043711.0
2021-07-14 12:30:00	AAPL	Stock	148.9075	149.2083	148.64	148.93	4099792.0
2021-07-14 13:00:00	AAPL	Stock	148.93	149.1	148.6	148.735	3118870.0
2021-07-14 13:30:00	AAPL	Stock	148.73	149.09	148.67	148.9561	3288738.0
2021-07-14 14:00:00	AAPL	Stock	148.95	149.41	148.895	149.25	4388672.0
2021-07-14 14:30:00	AAPL	Stock	149.25	149.46	149.11	149.312	3992714.0
2021-07-14 15:00:00	AAPL	Stock	149.3142	149.56	148.96	149.4007	6634265.0
2021-07-14 15:30:00	AAPL	Stock	149.407	149.57	148.82	149.21	12027158.0
2021-07-14 16:00:00	AAPL	Stock	149.15	149.25	149.02	149.09	9130019.0
2021-07-14 16:30:00	AAPL	Stock	149.14	149.32	149.0901	149.26	101178.0
2021-07-14 17:00:00	AAPL	Stock	149.3	149.44	149.28	149.4	50137.0
2021-07-14 17:30:00	AAPL	Stock	149.4	149.54	149.37	149.43	82553.0
2021-07-14 18:00:00	AAPL	Stock	149.41	149.42	149.27	149.31	45831.0
2021-07-14 18:30:00	AAPL	Stock	149.31	149.49	149.3	149.49	43995.0
2021-07-14 19:00:00	AAPL	Stock	149.49	149.5	149.43	149.47	20653.0
2021-07-14 19:30:00	AAPL	Stock	149.48	149.52	149.4301	149.51	48594.0
2021-07-14 04:00:00	MSFT	Stock	281.0	281.5	280.79	281.45	1982.0
2021-07-14 04:30:00	MSFT	Stock	281.5	281.57	281.3	281.57	1059.0
2021-07-14 05:00:00	MSFT	Stock	281.7	282.17	281.7	282.0	10794.0
2021-07-14 05:30:00	MSFT	Stock	282.19	282.5	282.19	282.2	4240.0
2021-07-14 06:00:00	MSFT	Stock	282.07	282.25	281.95	282.25	1546.0
2021-07-14 06:30:00	MSFT	Stock	282.15	282.15	282.0	282.04	4723.0
2021-07-14 07:00:00	MSFT	Stock	282.05	282.25	281.61	281.62	10898.0
2021-07-14 07:30:00	MSFT	Stock	281.6	282.18	281.31	282.16	13148.0
2021-07-14 08:00:00	MSFT	Stock	281.92	282.28	281.58	281.85	15246.0
2021-07-14 08:30:00	MSFT	Stock	281.98	282.99	281.89	282.27	23198.0
2021-07-14 09:00:00	MSFT	Stock	282.38	282.55	282.28	282.28	10720.0
2021-07-14 09:30:00	MSFT	Stock	282.27	282.75	280.55	282.12	2428807.0
2021-07-14 10:00:00	MSFT	Stock	282.13	283.54	282.079	282.695	1461628.0
2021-07-14 10:30:00	MSFT	Stock	282.7	283.26	282.57	283.205	1271921.0
2021-07-14 11:00:00	MSFT	Stock	283.21	283.66	282.54	282.64	1330289.0
2021-07-14 11:30:00	MSFT	Stock	282.63	282.7	281.6167	281.69	961817.0
2021-07-14 12:00:00	MSFT	Stock	281.67	282.71	281.66	282.53	732772.0
2021-07-14 12:30:00	MSFT	Stock	282.5155	283.05	282.24	282.57	619343.0

> showing 50 of 110,995 rows — these rows as CSV

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