PREVIEW / stock_30min / 2022-08-09

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-08-09.parquet
  size:    2.1 MB
  rows:    106,062
  symbols: 2,309

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
2022-08-09 04:00:00	AAPL	Stock	165.0	165.15	164.31	164.88	15871.0
2022-08-09 04:30:00	AAPL	Stock	164.93	165.1	164.8	164.8	4485.0
2022-08-09 05:00:00	AAPL	Stock	164.95	164.95	164.75	164.75	2483.0
2022-08-09 05:30:00	AAPL	Stock	164.72	164.72	164.6	164.65	1077.0
2022-08-09 06:00:00	AAPL	Stock	164.68	164.68	163.89	163.99	27801.0
2022-08-09 06:30:00	AAPL	Stock	163.91	164.01	163.88	164.01	8301.0
2022-08-09 07:00:00	AAPL	Stock	164.09	164.3	164.0	164.04	47217.0
2022-08-09 07:30:00	AAPL	Stock	164.02	164.2	163.61	163.75	29327.0
2022-08-09 08:00:00	AAPL	Stock	164.2751	165.0	163.5	163.8444	229381.0
2022-08-09 08:30:00	AAPL	Stock	163.78	163.99	163.69	163.82	114053.0
2022-08-09 09:00:00	AAPL	Stock	163.8	164.87	163.48	164.01	178078.0
2022-08-09 09:30:00	AAPL	Stock	164.0	164.81	163.25	163.9001	5922571.0
2022-08-09 10:00:00	AAPL	Stock	163.9	164.4	163.77	164.4	3468065.0
2022-08-09 10:30:00	AAPL	Stock	164.4	164.99	164.19	164.5101	3297197.0
2022-08-09 11:00:00	AAPL	Stock	164.52	165.32	164.01	165.065	3726387.0
2022-08-09 11:30:00	AAPL	Stock	165.065	165.82	164.96	165.1001	5162456.0
2022-08-09 12:00:00	AAPL	Stock	165.11	165.32	164.46	164.52	2520164.0
2022-08-09 12:30:00	AAPL	Stock	164.51	165.06	164.48	164.99	2082602.0
2022-08-09 13:00:00	AAPL	Stock	165.0	165.33	164.845	165.28	2037712.0
2022-08-09 13:30:00	AAPL	Stock	165.28	165.55	164.905	165.39	2178630.0
2022-08-09 14:00:00	AAPL	Stock	165.385	165.6	164.935	164.995	2456585.0
2022-08-09 14:30:00	AAPL	Stock	164.99	165.43	164.865	165.135	2270558.0
2022-08-09 15:00:00	AAPL	Stock	165.14	165.4446	164.92	165.265	2423603.0
2022-08-09 15:30:00	AAPL	Stock	165.26	165.275	164.51	164.93	5254977.0
2022-08-09 16:00:00	AAPL	Stock	164.92	165.05	164.82	165.0	7814755.0
2022-08-09 16:30:00	AAPL	Stock	164.9701	165.05	164.92	165.05	14502.0
2022-08-09 17:00:00	AAPL	Stock	165.05	165.11	164.93	164.97	16307.0
2022-08-09 17:30:00	AAPL	Stock	164.91	165.0	164.88	164.93	9015.0
2022-08-09 18:00:00	AAPL	Stock	165.0	165.1	164.95	165.03	9839.0
2022-08-09 18:30:00	AAPL	Stock	165.06	165.09	164.95	164.96	7340.0
2022-08-09 19:00:00	AAPL	Stock	164.96	165.06	164.96	165.02	4814.0
2022-08-09 19:30:00	AAPL	Stock	165.02	165.05	164.96	165.01	17415.0
2022-08-09 04:00:00	MSFT	Stock	280.64	280.73	280.3	280.35	1015.0
2022-08-09 04:30:00	MSFT	Stock	280.8	280.8	280.8	280.8	100.0
2022-08-09 05:00:00	MSFT	Stock	280.61	280.61	280.31	280.31	867.0
2022-08-09 05:30:00	MSFT	Stock	280.35	280.5	280.3	280.3	1291.0
2022-08-09 06:00:00	MSFT	Stock	280.25	280.25	279.04	279.04	4002.0
2022-08-09 06:30:00	MSFT	Stock	278.45	278.5	278.35	278.5	1975.0
2022-08-09 07:00:00	MSFT	Stock	279.0	279.5	279.0	279.0	9468.0
2022-08-09 07:30:00	MSFT	Stock	279.02	279.49	278.65	278.93	7682.0
2022-08-09 08:00:00	MSFT	Stock	279.49	280.34	278.55	279.0	30755.0
2022-08-09 08:30:00	MSFT	Stock	279.1	279.3139	278.5609	278.9	5607.0
2022-08-09 09:00:00	MSFT	Stock	278.8	279.67	278.55	279.6	21246.0
2022-08-09 09:30:00	MSFT	Stock	279.7	280.33	277.61	277.88	1592350.0
2022-08-09 10:00:00	MSFT	Stock	277.9	280.06	277.88	280.06	1144899.0
2022-08-09 10:30:00	MSFT	Stock	280.07	281.36	279.45	280.64	990344.0
2022-08-09 11:00:00	MSFT	Stock	280.67	281.9336	279.6001	281.49	731712.0
2022-08-09 11:30:00	MSFT	Stock	281.51	281.73	280.87	280.9971	575086.0
2022-08-09 12:00:00	MSFT	Stock	280.97	281.16	279.89	279.95	504694.0
2022-08-09 12:30:00	MSFT	Stock	279.9	280.5	279.895	280.26	518307.0

> showing 50 of 106,062 rows — these rows as CSV

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