PREVIEW / stock_30min / 2023-04-27

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-04-27.parquet
  size:    2.1 MB
  rows:    99,668
  symbols: 1,656

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
2023-04-27 04:00:00	AAPL	Stock	164.12	164.87	164.12	164.49	10950.0
2023-04-27 04:30:00	AAPL	Stock	164.46	164.52	164.34	164.35	14055.0
2023-04-27 05:00:00	AAPL	Stock	164.56	164.56	164.39	164.39	3597.0
2023-04-27 05:30:00	AAPL	Stock	164.35	164.48	164.35	164.48	1138.0
2023-04-27 06:00:00	AAPL	Stock	164.32	164.42	164.29	164.42	1899.0
2023-04-27 06:30:00	AAPL	Stock	164.29	164.93	164.29	164.64	6147.0
2023-04-27 07:00:00	AAPL	Stock	164.62	164.94	164.54	164.88	47031.0
2023-04-27 07:30:00	AAPL	Stock	164.92	165.07	164.7	165.05	23124.0
2023-04-27 08:00:00	AAPL	Stock	164.58	165.28	163.54	165.19	178617.0
2023-04-27 08:30:00	AAPL	Stock	165.1	165.22	164.62	164.99	144190.0
2023-04-27 09:00:00	AAPL	Stock	165.0	165.21	164.75	165.13	110734.0
2023-04-27 09:30:00	AAPL	Stock	165.14	166.149	165.14	165.42	6551155.0
2023-04-27 10:00:00	AAPL	Stock	165.435	166.41	165.35	166.255	3956445.0
2023-04-27 10:30:00	AAPL	Stock	166.27	166.62	166.22	166.2242	2585268.0
2023-04-27 11:00:00	AAPL	Stock	166.2225	166.905	166.12	166.6899	2849638.0
2023-04-27 11:30:00	AAPL	Stock	166.71	166.85	166.4	166.6886	2066757.0
2023-04-27 12:00:00	AAPL	Stock	166.685	167.09	166.68	166.765	2323757.0
2023-04-27 12:30:00	AAPL	Stock	166.77	167.02	166.715	167.01	1468521.0
2023-04-27 13:00:00	AAPL	Stock	167.01	167.345	166.895	167.29	1899719.0
2023-04-27 13:30:00	AAPL	Stock	167.29	167.46	167.23	167.25	2103544.0
2023-04-27 14:00:00	AAPL	Stock	167.25	167.49	167.14	167.45	2090205.0
2023-04-27 14:30:00	AAPL	Stock	167.455	167.95	167.44	167.8701	2659661.0
2023-04-27 15:00:00	AAPL	Stock	167.875	168.53	167.83	168.285	4207455.0
2023-04-27 15:30:00	AAPL	Stock	168.28	168.56	168.22	168.4	8351928.0
2023-04-27 16:00:00	AAPL	Stock	168.41	169.054	167.5955	167.97	11744679.0
2023-04-27 16:30:00	AAPL	Stock	168.0	168.45	167.85	167.87	273284.0
2023-04-27 17:00:00	AAPL	Stock	167.89	168.15	167.85	168.09	51103.0
2023-04-27 17:30:00	AAPL	Stock	168.09	168.18	167.5	167.65	74904.0
2023-04-27 18:00:00	AAPL	Stock	167.7	167.98	167.36	167.69	122736.0
2023-04-27 18:30:00	AAPL	Stock	167.7	167.8	167.62	167.67	27016.0
2023-04-27 19:00:00	AAPL	Stock	167.74	167.94	167.67	167.9	15173.0
2023-04-27 19:30:00	AAPL	Stock	167.87	167.94	167.8	167.94	16073.0
2023-04-27 04:00:00	MSFT	Stock	296.45	296.6	295.88	296.05	4300.0
2023-04-27 04:30:00	MSFT	Stock	295.99	295.99	295.47	295.78	2412.0
2023-04-27 05:00:00	MSFT	Stock	295.71	295.8	295.5	295.51	4095.0
2023-04-27 05:30:00	MSFT	Stock	295.43	295.51	294.35	294.61	7944.0
2023-04-27 06:00:00	MSFT	Stock	294.6	295.0	294.6	294.87	2103.0
2023-04-27 06:30:00	MSFT	Stock	294.89	295.0	294.75	295.0	2924.0
2023-04-27 07:00:00	MSFT	Stock	295.0	295.8	294.85	295.6	8857.0
2023-04-27 07:30:00	MSFT	Stock	295.53	295.53	295.05	295.19	7946.0
2023-04-27 08:00:00	MSFT	Stock	294.86	296.36	294.8	295.85	44118.0
2023-04-27 08:30:00	MSFT	Stock	295.85	296.0	294.6	295.1	39165.0
2023-04-27 09:00:00	MSFT	Stock	295.05	296.05	294.645	295.77	48517.0
2023-04-27 09:30:00	MSFT	Stock	295.76	301.4	295.25	300.325	6447952.0
2023-04-27 10:00:00	MSFT	Stock	300.32	301.94	300.18	301.61	3460332.0
2023-04-27 10:30:00	MSFT	Stock	301.63	303.16	301.48	302.6108	3209601.0
2023-04-27 11:00:00	MSFT	Stock	302.62	303.5	302.01	303.085	1978483.0
2023-04-27 11:30:00	MSFT	Stock	303.09	303.75	302.575	302.715	1639961.0
2023-04-27 12:00:00	MSFT	Stock	302.72	303.0	302.41	302.78	1203291.0
2023-04-27 12:30:00	MSFT	Stock	302.79	303.07	302.59	302.648	1151098.0

> showing 50 of 99,668 rows — these rows as CSV

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