PREVIEW / stock_30min / 2023-03-20

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-03-20.parquet
  size:    2.1 MB
  rows:    103,650
  symbols: 1,759

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-20 04:00:00	AAPL	Stock	154.38	154.49	151.75	154.11	48661.0
2023-03-20 04:30:00	AAPL	Stock	153.99	154.66	153.85	154.62	14072.0
2023-03-20 05:00:00	AAPL	Stock	154.64	154.88	154.21	154.65	25638.0
2023-03-20 05:30:00	AAPL	Stock	154.74	156.0	154.72	155.5	22932.0
2023-03-20 06:00:00	AAPL	Stock	155.31	155.65	155.03	155.2	13978.0
2023-03-20 06:30:00	AAPL	Stock	155.2	155.5	155.14	155.5	6473.0
2023-03-20 07:00:00	AAPL	Stock	155.41	155.5	154.77	155.44	29659.0
2023-03-20 07:30:00	AAPL	Stock	155.3	155.56	154.7	155.1	23809.0
2023-03-20 08:00:00	AAPL	Stock	155.15	155.45	153.68	155.22	77927.0
2023-03-20 08:30:00	AAPL	Stock	155.22	155.75	155.05	155.19	107091.0
2023-03-20 09:00:00	AAPL	Stock	155.24	155.28	154.61	155.03	126779.0
2023-03-20 09:30:00	AAPL	Stock	155.07	155.43	154.15	154.46	7206094.0
2023-03-20 10:00:00	AAPL	Stock	154.46	155.4	154.42	155.3467	3989028.0
2023-03-20 10:30:00	AAPL	Stock	155.33	156.31	155.08	156.2099	3994544.0
2023-03-20 11:00:00	AAPL	Stock	156.2	156.88	155.99	156.8301	3808179.0
2023-03-20 11:30:00	AAPL	Stock	156.83	156.88	156.055	156.275	3399137.0
2023-03-20 12:00:00	AAPL	Stock	156.28	156.44	155.735	155.96	2911205.0
2023-03-20 12:30:00	AAPL	Stock	155.95	156.87	155.915	156.74	2906996.0
2023-03-20 13:00:00	AAPL	Stock	156.75	157.55	156.69	157.4199	4688499.0
2023-03-20 13:30:00	AAPL	Stock	157.4125	157.77	157.3	157.385	3076996.0
2023-03-20 14:00:00	AAPL	Stock	157.3834	157.805	157.083	157.5313	3130041.0
2023-03-20 14:30:00	AAPL	Stock	157.535	157.82	157.12	157.43	3178042.0
2023-03-20 15:00:00	AAPL	Stock	157.41	157.5062	157.17	157.3405	2798015.0
2023-03-20 15:30:00	AAPL	Stock	157.33	157.82	157.2	157.46	6485717.0
2023-03-20 16:00:00	AAPL	Stock	157.4	157.82	157.4	157.44	12987097.0
2023-03-20 16:30:00	AAPL	Stock	157.43	157.5	157.4	157.49	63661.0
2023-03-20 17:00:00	AAPL	Stock	157.4969	157.58	157.4444	157.53	14944.0
2023-03-20 17:30:00	AAPL	Stock	157.56	157.56	157.5	157.53	4608.0
2023-03-20 18:00:00	AAPL	Stock	157.53	157.56	157.36	157.38	19512.0
2023-03-20 18:30:00	AAPL	Stock	157.38	157.5	157.38	157.43	11697.0
2023-03-20 19:00:00	AAPL	Stock	157.42	157.42	157.34	157.38	8515.0
2023-03-20 19:30:00	AAPL	Stock	157.38	157.41	157.33	157.41	26350.0
2023-03-20 04:00:00	MSFT	Stock	275.83	279.99	275.83	277.94	24538.0
2023-03-20 04:30:00	MSFT	Stock	277.52	279.8	277.51	279.8	8212.0
2023-03-20 05:00:00	MSFT	Stock	279.97	281.19	279.97	279.97	24990.0
2023-03-20 05:30:00	MSFT	Stock	280.38	280.98	280.12	280.5	8683.0
2023-03-20 06:00:00	MSFT	Stock	280.52	280.7	279.47	279.65	26981.0
2023-03-20 06:30:00	MSFT	Stock	279.51	280.97	279.36	280.07	6963.0
2023-03-20 07:00:00	MSFT	Stock	280.14	280.43	279.0	279.0	22450.0
2023-03-20 07:30:00	MSFT	Stock	278.95	279.28	278.12	278.7	14177.0
2023-03-20 08:00:00	MSFT	Stock	279.7	280.43	277.1	278.85	46410.0
2023-03-20 08:30:00	MSFT	Stock	278.98	279.4	278.5	278.9	46446.0
2023-03-20 09:00:00	MSFT	Stock	278.63	278.85	276.56	276.77	75565.0
2023-03-20 09:30:00	MSFT	Stock	277.05	277.48	271.17	271.555	4762034.0
2023-03-20 10:00:00	MSFT	Stock	271.56	273.4	271.4	271.58	3084247.0
2023-03-20 10:30:00	MSFT	Stock	271.56	272.39	269.85	270.56	2834794.0
2023-03-20 11:00:00	MSFT	Stock	270.57	273.53	270.312	273.5	2528613.0
2023-03-20 11:30:00	MSFT	Stock	273.49	273.8309	270.8201	271.045	1760307.0
2023-03-20 12:00:00	MSFT	Stock	271.04	271.23	269.92	271.15	1561609.0
2023-03-20 12:30:00	MSFT	Stock	271.13	271.34	270.6	270.8	1287060.0

> showing 50 of 103,650 rows — these rows as CSV

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