PREVIEW / stock_30min / 2023-03-27

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-03-27.parquet
  size:    2.0 MB
  rows:    100,222
  symbols: 1,770

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-03-27 04:00:00	AAPL	Stock	160.25	160.25	159.38	159.73	15945.0
2023-03-27 04:30:00	AAPL	Stock	159.77	159.85	159.73	159.82	4721.0
2023-03-27 05:00:00	AAPL	Stock	159.79	159.81	159.52	159.7	5622.0
2023-03-27 05:30:00	AAPL	Stock	159.7	159.87	159.6	159.6	7204.0
2023-03-27 06:00:00	AAPL	Stock	159.77	160.11	159.77	159.85	6949.0
2023-03-27 06:30:00	AAPL	Stock	159.8	159.9	159.66	159.84	1412.0
2023-03-27 07:00:00	AAPL	Stock	159.88	160.22	159.84	160.18	39333.0
2023-03-27 07:30:00	AAPL	Stock	160.15	160.15	159.92	160.12	58742.0
2023-03-27 08:00:00	AAPL	Stock	160.11	160.25	159.8	159.92	123801.0
2023-03-27 08:30:00	AAPL	Stock	159.92	159.953	159.72	159.8	161344.0
2023-03-27 09:00:00	AAPL	Stock	159.8	160.0	159.61	159.93	113839.0
2023-03-27 09:30:00	AAPL	Stock	159.93	160.77	159.45	160.365	6428060.0
2023-03-27 10:00:00	AAPL	Stock	160.37	160.72	159.895	159.93	3463447.0
2023-03-27 10:30:00	AAPL	Stock	159.92	160.08	159.62	159.7605	2729898.0
2023-03-27 11:00:00	AAPL	Stock	159.76	159.83	159.39	159.4977	2254315.0
2023-03-27 11:30:00	AAPL	Stock	159.5	159.56	158.4	158.44	2806834.0
2023-03-27 12:00:00	AAPL	Stock	158.4365	158.77	158.22	158.7699	2385814.0
2023-03-27 12:30:00	AAPL	Stock	158.7687	158.83	158.04	158.2789	1786667.0
2023-03-27 13:00:00	AAPL	Stock	158.28	158.47	157.87	158.35	2093198.0
2023-03-27 13:30:00	AAPL	Stock	158.37	158.5997	158.2	158.29	1817016.0
2023-03-27 14:00:00	AAPL	Stock	158.3	158.84	158.11	158.6355	1694280.0
2023-03-27 14:30:00	AAPL	Stock	158.64	159.0634	158.6334	159.06	2054743.0
2023-03-27 15:00:00	AAPL	Stock	159.06	159.21	158.77	158.93	2285653.0
2023-03-27 15:30:00	AAPL	Stock	158.93	158.97	157.97	158.3	4761173.0
2023-03-27 16:00:00	AAPL	Stock	158.31	158.38	158.09	158.3	6675802.0
2023-03-27 16:30:00	AAPL	Stock	158.29	158.36	158.2	158.25	32918.0
2023-03-27 17:00:00	AAPL	Stock	158.25	158.25	158.12	158.15	9759.0
2023-03-27 17:30:00	AAPL	Stock	158.18	158.28	158.15	158.2	17562.0
2023-03-27 18:00:00	AAPL	Stock	158.18	158.21	158.07	158.1	9830.0
2023-03-27 18:30:00	AAPL	Stock	158.1	158.18	158.03	158.18	16979.0
2023-03-27 19:00:00	AAPL	Stock	158.18	158.34	158.18	158.32	15369.0
2023-03-27 19:30:00	AAPL	Stock	158.34	158.48	158.26	158.37	15025.0
2023-03-27 04:00:00	MSFT	Stock	280.19	280.94	280.0	280.72	6203.0
2023-03-27 04:30:00	MSFT	Stock	280.95	281.5	280.95	281.29	2990.0
2023-03-27 05:00:00	MSFT	Stock	281.2	281.22	280.91	280.91	1370.0
2023-03-27 05:30:00	MSFT	Stock	281.09	281.5	281.04	281.04	2635.0
2023-03-27 06:00:00	MSFT	Stock	281.4	281.68	281.4	281.5	3366.0
2023-03-27 06:30:00	MSFT	Stock	281.5	281.79	281.5	281.5	6658.0
2023-03-27 07:00:00	MSFT	Stock	281.5	281.82	281.3	281.51	20053.0
2023-03-27 07:30:00	MSFT	Stock	281.4	281.4	280.73	280.75	13393.0
2023-03-27 08:00:00	MSFT	Stock	280.88	281.99	279.869	280.8	58762.0
2023-03-27 08:30:00	MSFT	Stock	280.8	280.8	280.05	280.25	16865.0
2023-03-27 09:00:00	MSFT	Stock	280.4	280.8	280.18	280.5	56436.0
2023-03-27 09:30:00	MSFT	Stock	280.5	281.4589	278.51	280.1908	2918170.0
2023-03-27 10:00:00	MSFT	Stock	280.19	281.4	279.69	279.875	1647457.0
2023-03-27 10:30:00	MSFT	Stock	279.86	279.87	278.22	278.27	1388393.0
2023-03-27 11:00:00	MSFT	Stock	278.27	278.315	277.29	277.93	1538340.0
2023-03-27 11:30:00	MSFT	Stock	277.96	278.0892	275.73	275.9373	1301452.0
2023-03-27 12:00:00	MSFT	Stock	275.95	276.87	275.57	276.8327	1133171.0
2023-03-27 12:30:00	MSFT	Stock	276.88	276.9135	275.98	276.42	694512.0

> showing 50 of 100,222 rows — these rows as CSV

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