PREVIEW / stock_30min / 2021-07-22

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-07-22.parquet
  size:    2.2 MB
  rows:    107,954
  symbols: 2,846

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-22 04:00:00	AAPL	Stock	145.64	145.85	145.6	145.69	4474.0
2021-07-22 04:30:00	AAPL	Stock	145.7	145.71	145.65	145.65	2043.0
2021-07-22 05:00:00	AAPL	Stock	145.66	145.79	145.62	145.79	2096.0
2021-07-22 05:30:00	AAPL	Stock	145.72	145.74	145.7	145.7	2909.0
2021-07-22 06:00:00	AAPL	Stock	145.66	145.67	145.51	145.6	4991.0
2021-07-22 06:30:00	AAPL	Stock	145.67	145.7	145.67	145.7	1064.0
2021-07-22 07:00:00	AAPL	Stock	145.69	145.75	145.62	145.631	46822.0
2021-07-22 07:30:00	AAPL	Stock	145.61	145.9	145.55	145.68	79677.0
2021-07-22 08:00:00	AAPL	Stock	145.71	145.93	145.6	145.91	225606.0
2021-07-22 08:30:00	AAPL	Stock	145.91	146.2	145.82	146.11	198694.0
2021-07-22 09:00:00	AAPL	Stock	146.12	146.15	145.85	145.91	141986.0
2021-07-22 09:30:00	AAPL	Stock	145.93	147.0	145.81	146.83	11232567.0
2021-07-22 10:00:00	AAPL	Stock	146.83	147.55	146.83	147.465	7064505.0
2021-07-22 10:30:00	AAPL	Stock	147.47	147.97	147.33	147.74	6060055.0
2021-07-22 11:00:00	AAPL	Stock	147.735	148.195	147.16	147.3601	6595459.0
2021-07-22 11:30:00	AAPL	Stock	147.3714	147.6	147.13	147.331	3481329.0
2021-07-22 12:00:00	AAPL	Stock	147.33	147.44	146.66	147.04	3859467.0
2021-07-22 12:30:00	AAPL	Stock	147.03	147.32	146.85	147.21	2674255.0
2021-07-22 13:00:00	AAPL	Stock	147.2	147.64	147.152	147.57	2566295.0
2021-07-22 13:30:00	AAPL	Stock	147.56	147.67	147.22	147.2211	2213410.0
2021-07-22 14:00:00	AAPL	Stock	147.225	147.3699	147.1	147.3	2387806.0
2021-07-22 14:30:00	AAPL	Stock	147.3	147.365	146.94	147.12	2271383.0
2021-07-22 15:00:00	AAPL	Stock	147.129	147.15	146.87	146.97	2465564.0
2021-07-22 15:30:00	AAPL	Stock	146.97	146.98	146.48	146.8	5578666.0
2021-07-22 16:00:00	AAPL	Stock	146.79	147.0	146.71	147.0	3949618.0
2021-07-22 16:30:00	AAPL	Stock	146.99	147.09	146.86	147.09	90952.0
2021-07-22 17:00:00	AAPL	Stock	147.07	147.19	147.07	147.12	76968.0
2021-07-22 17:30:00	AAPL	Stock	147.15	147.19	147.1	147.15	38451.0
2021-07-22 18:00:00	AAPL	Stock	147.14	147.19	147.01	147.08	12983.0
2021-07-22 18:30:00	AAPL	Stock	147.1	147.12	147.06	147.09	12445.0
2021-07-22 19:00:00	AAPL	Stock	147.12	147.15	147.0	147.13	34928.0
2021-07-22 19:30:00	AAPL	Stock	147.12	147.25	147.06	147.25	29650.0
2021-07-22 04:00:00	MSFT	Stock	282.0	282.45	281.6	282.26	1738.0
2021-07-22 04:30:00	MSFT	Stock	282.26	282.58	282.26	282.5	1470.0
2021-07-22 05:30:00	MSFT	Stock	282.88	282.89	282.6	282.6	1882.0
2021-07-22 06:00:00	MSFT	Stock	282.62	282.72	282.2	282.2	2581.0
2021-07-22 06:30:00	MSFT	Stock	282.29	282.3	282.21	282.3	429.0
2021-07-22 07:00:00	MSFT	Stock	282.48	284.0	282.48	283.6	27283.0
2021-07-22 07:30:00	MSFT	Stock	283.7	284.44	283.62	284.0	27585.0
2021-07-22 08:00:00	MSFT	Stock	282.65	284.48	282.3	283.95	22963.0
2021-07-22 08:30:00	MSFT	Stock	283.95	284.02	283.57	283.68	29240.0
2021-07-22 09:00:00	MSFT	Stock	283.7	284.0	283.47	283.8	32008.0
2021-07-22 09:30:00	MSFT	Stock	283.74	286.06	283.42	285.24	2990399.0
2021-07-22 10:00:00	MSFT	Stock	285.24	285.7361	284.77	285.6301	1305988.0
2021-07-22 10:30:00	MSFT	Stock	285.63	286.41	285.52	285.9163	1271499.0
2021-07-22 11:00:00	MSFT	Stock	285.919	286.32	285.37	285.71	1095003.0
2021-07-22 11:30:00	MSFT	Stock	285.705	285.75	284.8501	285.35	738795.0
2021-07-22 12:00:00	MSFT	Stock	285.385	285.41	284.48	284.86	804232.0
2021-07-22 12:30:00	MSFT	Stock	284.86	285.16	284.56	284.9063	497368.0
2021-07-22 13:00:00	MSFT	Stock	284.91	285.07	284.63	284.7101	532891.0

> showing 50 of 107,954 rows — these rows as CSV

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