PREVIEW / stock_30min / 2023-04-24

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-04-24.parquet
  size:    2.0 MB
  rows:    99,360
  symbols: 1,668

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-24 04:00:00	AAPL	Stock	164.84	164.84	164.19	164.27	3176.0
2023-04-24 04:30:00	AAPL	Stock	164.25	164.27	164.06	164.2	5237.0
2023-04-24 05:00:00	AAPL	Stock	164.25	164.5	164.25	164.5	6071.0
2023-04-24 05:30:00	AAPL	Stock	164.5	164.61	164.5	164.61	1579.0
2023-04-24 06:00:00	AAPL	Stock	164.56	164.56	164.39	164.39	986.0
2023-04-24 06:30:00	AAPL	Stock	164.39	164.57	164.33	164.57	5080.0
2023-04-24 07:00:00	AAPL	Stock	164.5	164.96	164.5	164.93	12451.0
2023-04-24 07:30:00	AAPL	Stock	164.95	164.98	164.68	164.73	40417.0
2023-04-24 08:00:00	AAPL	Stock	164.7	164.99	163.86	164.68	57611.0
2023-04-24 08:30:00	AAPL	Stock	164.67	164.81	164.57	164.67	97903.0
2023-04-24 09:00:00	AAPL	Stock	164.67	165.0	164.4	164.95	117734.0
2023-04-24 09:30:00	AAPL	Stock	164.98	165.47	164.41	165.16	4387154.0
2023-04-24 10:00:00	AAPL	Stock	165.16	165.4279	164.815	165.2988	2493544.0
2023-04-24 10:30:00	AAPL	Stock	165.29	165.37	164.03	164.04	2764762.0
2023-04-24 11:00:00	AAPL	Stock	164.035	164.41	163.89	164.18	1689966.0
2023-04-24 11:30:00	AAPL	Stock	164.18	164.3341	164.0	164.125	1509138.0
2023-04-24 12:00:00	AAPL	Stock	164.14	164.35	164.04	164.34	1199156.0
2023-04-24 12:30:00	AAPL	Stock	164.33	164.62	164.289	164.5117	1351003.0
2023-04-24 13:00:00	AAPL	Stock	164.515	164.88	164.38	164.78	1718215.0
2023-04-24 13:30:00	AAPL	Stock	164.78	165.2199	164.73	165.1324	1694630.0
2023-04-24 14:00:00	AAPL	Stock	165.15	165.44	165.1	165.1722	1767535.0
2023-04-24 14:30:00	AAPL	Stock	165.18	165.3076	164.98	165.2942	1347581.0
2023-04-24 15:00:00	AAPL	Stock	165.3	165.44	165.23	165.345	1617066.0
2023-04-24 15:30:00	AAPL	Stock	165.345	165.6	165.09	165.36	4714371.0
2023-04-24 16:00:00	AAPL	Stock	165.35	165.45	165.0	165.34	3278717.0
2023-04-24 16:30:00	AAPL	Stock	165.3395	165.3395	165.12	165.14	25456.0
2023-04-24 17:00:00	AAPL	Stock	165.16	165.16	165.07	165.13	24073.0
2023-04-24 17:30:00	AAPL	Stock	165.0905	165.13	165.05	165.08	11779.0
2023-04-24 18:00:00	AAPL	Stock	165.12	165.27	165.1101	165.2	15477.0
2023-04-24 18:30:00	AAPL	Stock	165.13	165.2184	165.13	165.13	2336.0
2023-04-24 19:00:00	AAPL	Stock	165.16	165.19	165.11	165.16	2605.0
2023-04-24 19:30:00	AAPL	Stock	165.16	165.27	165.15	165.22	6901.0
2023-04-24 04:00:00	MSFT	Stock	284.35	285.28	284.1	284.39	5448.0
2023-04-24 04:30:00	MSFT	Stock	284.44	284.44	284.44	284.44	100.0
2023-04-24 05:00:00	MSFT	Stock	284.8	285.69	284.8	285.69	1524.0
2023-04-24 05:30:00	MSFT	Stock	285.58	285.58	285.5	285.5	543.0
2023-04-24 06:00:00	MSFT	Stock	285.24	285.24	284.6	284.6	1632.0
2023-04-24 06:30:00	MSFT	Stock	285.01	285.01	284.9	284.9	4661.0
2023-04-24 07:00:00	MSFT	Stock	285.35	285.7	285.3	285.6	2760.0
2023-04-24 07:30:00	MSFT	Stock	285.6	285.6	283.63	283.99	29321.0
2023-04-24 08:00:00	MSFT	Stock	285.35	285.7213	283.7	284.07	32080.0
2023-04-24 08:30:00	MSFT	Stock	284.08	284.35	283.7902	283.99	38483.0
2023-04-24 09:00:00	MSFT	Stock	283.99	284.1	281.79	282.07	98380.0
2023-04-24 09:30:00	MSFT	Stock	282.07	284.95	281.2535	284.04	2794279.0
2023-04-24 10:00:00	MSFT	Stock	284.03	284.22	283.32	283.83	1248540.0
2023-04-24 10:30:00	MSFT	Stock	283.84	284.02	282.4	283.63	1297186.0
2023-04-24 11:00:00	MSFT	Stock	283.62	283.82	281.625	281.76	1163798.0
2023-04-24 11:30:00	MSFT	Stock	281.73	282.02	278.72	279.36	2390978.0
2023-04-24 12:00:00	MSFT	Stock	279.39	280.43	279.25	280.04	1154754.0
2023-04-24 12:30:00	MSFT	Stock	280.04	280.56	279.7469	280.47	1045298.0

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

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