PREVIEW / stock_30min / 2022-04-26

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-04-26.parquet
  size:    2.2 MB
  rows:    107,464
  symbols: 2,435

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-04-26 04:00:00	AAPL	Stock	162.46	162.7	161.88	162.7	13398.0
2022-04-26 04:30:00	AAPL	Stock	162.67	162.85	162.36	162.85	6671.0
2022-04-26 05:00:00	AAPL	Stock	162.86	163.0	162.67	162.71	6780.0
2022-04-26 05:30:00	AAPL	Stock	162.82	162.82	162.52	162.73	3990.0
2022-04-26 06:00:00	AAPL	Stock	162.75	162.75	162.26	162.4	3560.0
2022-04-26 06:30:00	AAPL	Stock	162.51	162.6	162.23	162.23	8088.0
2022-04-26 07:00:00	AAPL	Stock	162.39	162.54	162.08	162.54	33247.0
2022-04-26 07:30:00	AAPL	Stock	162.5	162.5	162.06	162.44	29666.0
2022-04-26 08:00:00	AAPL	Stock	162.11	163.77	162.06	162.4372	207352.0
2022-04-26 08:30:00	AAPL	Stock	162.45	162.5599	162.01	162.27	159840.0
2022-04-26 09:00:00	AAPL	Stock	162.27	162.88	161.83	162.18	275385.0
2022-04-26 09:30:00	AAPL	Stock	162.25	162.34	160.14	160.6579	8180993.0
2022-04-26 10:00:00	AAPL	Stock	160.65	160.82	159.28	159.58	6909884.0
2022-04-26 10:30:00	AAPL	Stock	159.58	159.73	158.71	158.71	5525163.0
2022-04-26 11:00:00	AAPL	Stock	158.7	159.3999	158.28	159.03	4972108.0
2022-04-26 11:30:00	AAPL	Stock	159.03	159.36	158.07	158.19	4615957.0
2022-04-26 12:00:00	AAPL	Stock	158.2	159.65	158.17	159.45	3824595.0
2022-04-26 12:30:00	AAPL	Stock	159.43	159.92	158.94	159.63	3426371.0
2022-04-26 13:00:00	AAPL	Stock	159.63	159.65	158.33	158.465	3090632.0
2022-04-26 13:30:00	AAPL	Stock	158.46	159.14	158.34	158.4185	3239311.0
2022-04-26 14:00:00	AAPL	Stock	158.41	158.92	158.17	158.73	3577532.0
2022-04-26 14:30:00	AAPL	Stock	158.71	159.03	158.13	158.9	3789727.0
2022-04-26 15:00:00	AAPL	Stock	158.91	159.14	157.025	157.35	6872839.0
2022-04-26 15:30:00	AAPL	Stock	157.345	157.9	156.72	156.72	11755847.0
2022-04-26 16:00:00	AAPL	Stock	156.795	157.4	155.0	155.35	10153889.0
2022-04-26 16:30:00	AAPL	Stock	155.35	156.8	153.85	154.15	480759.0
2022-04-26 17:00:00	AAPL	Stock	154.15	154.97	154.0	154.9	139167.0
2022-04-26 17:30:00	AAPL	Stock	154.9	155.41	154.81	155.41	132647.0
2022-04-26 18:00:00	AAPL	Stock	155.43	156.8101	155.15	156.8101	264899.0
2022-04-26 18:30:00	AAPL	Stock	156.81	156.92	155.67	155.7	144309.0
2022-04-26 19:00:00	AAPL	Stock	155.76	156.2	155.7	155.87	73747.0
2022-04-26 19:30:00	AAPL	Stock	155.88	156.24	155.8799	156.12	96429.0
2022-04-26 04:00:00	MSFT	Stock	280.45	280.7	279.07	280.65	3341.0
2022-04-26 04:30:00	MSFT	Stock	280.59	280.59	280.06	280.06	1558.0
2022-04-26 05:00:00	MSFT	Stock	280.7	280.76	280.5	280.5	1545.0
2022-04-26 05:30:00	MSFT	Stock	280.53	280.84	280.3	280.7	3526.0
2022-04-26 06:00:00	MSFT	Stock	280.21	280.21	279.58	279.58	1854.0
2022-04-26 06:30:00	MSFT	Stock	280.12	280.12	279.75	279.8	1731.0
2022-04-26 07:00:00	MSFT	Stock	280.0	280.25	279.46	280.21	9151.0
2022-04-26 07:30:00	MSFT	Stock	280.21	280.21	279.4	279.84	5388.0
2022-04-26 08:00:00	MSFT	Stock	279.8	282.53	279.11	279.95	31102.0
2022-04-26 08:30:00	MSFT	Stock	279.9899	280.01	278.86	279.15	37288.0
2022-04-26 09:00:00	MSFT	Stock	279.2	279.2	276.6	277.48	47239.0
2022-04-26 09:30:00	MSFT	Stock	277.5	278.3599	275.0	275.2	3037847.0
2022-04-26 10:00:00	MSFT	Stock	275.18	276.48	274.11	274.76	1750683.0
2022-04-26 10:30:00	MSFT	Stock	274.765	275.3299	273.0501	273.065	1494018.0
2022-04-26 11:00:00	MSFT	Stock	273.05	273.36	272.0	272.81	1574295.0
2022-04-26 11:30:00	MSFT	Stock	272.8	273.46	272.12	272.24	1140530.0
2022-04-26 12:00:00	MSFT	Stock	272.27	275.24	272.27	274.87	1534965.0
2022-04-26 12:30:00	MSFT	Stock	274.87	275.057	273.77	274.755	1028773.0

> showing 50 of 107,464 rows — these rows as CSV

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