PREVIEW / stock_30min / 2022-04-18

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-04-18.parquet
  size:    2.2 MB
  rows:    106,917
  symbols: 2,512

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-18 04:00:00	AAPL	Stock	165.0	165.0	163.0	164.24	24601.0
2022-04-18 04:30:00	AAPL	Stock	164.25	164.31	164.11	164.11	965.0
2022-04-18 05:00:00	AAPL	Stock	164.03	164.03	163.51	163.58	3592.0
2022-04-18 05:30:00	AAPL	Stock	163.81	164.29	163.81	164.1	4312.0
2022-04-18 06:00:00	AAPL	Stock	164.26	164.29	164.21	164.21	1133.0
2022-04-18 06:30:00	AAPL	Stock	164.25	164.37	164.25	164.33	1837.0
2022-04-18 07:00:00	AAPL	Stock	164.35	164.96	164.31	164.96	33314.0
2022-04-18 07:30:00	AAPL	Stock	164.75	164.75	164.36	164.49	35355.0
2022-04-18 08:00:00	AAPL	Stock	164.5203	164.89	164.0	164.3299	231732.0
2022-04-18 08:30:00	AAPL	Stock	164.27	164.95	164.24	164.7	64425.0
2022-04-18 09:00:00	AAPL	Stock	164.68	164.94	163.62	163.86	389920.0
2022-04-18 09:30:00	AAPL	Stock	163.91	165.7392	163.57	164.4897	9992704.0
2022-04-18 10:00:00	AAPL	Stock	164.48	166.3555	164.09	166.15	5710655.0
2022-04-18 10:30:00	AAPL	Stock	166.15	166.5984	165.31	165.51	3652007.0
2022-04-18 11:00:00	AAPL	Stock	165.51	165.63	164.51	164.63	3311738.0
2022-04-18 11:30:00	AAPL	Stock	164.62	164.79	164.29	164.745	2920520.0
2022-04-18 12:00:00	AAPL	Stock	164.745	164.8453	163.69	163.7502	2990859.0
2022-04-18 12:30:00	AAPL	Stock	163.75	164.1899	163.7	163.98	2455112.0
2022-04-18 13:00:00	AAPL	Stock	163.99	164.5176	163.8	164.505	2414927.0
2022-04-18 13:30:00	AAPL	Stock	164.5	165.61	164.425	165.32	3264966.0
2022-04-18 14:00:00	AAPL	Stock	165.32	165.8296	164.89	165.47	3133314.0
2022-04-18 14:30:00	AAPL	Stock	165.465	165.6699	165.2	165.25	2242074.0
2022-04-18 15:00:00	AAPL	Stock	165.2516	165.325	164.79	164.82	2455224.0
2022-04-18 15:30:00	AAPL	Stock	164.81	165.12	163.98	165.11	5414183.0
2022-04-18 16:00:00	AAPL	Stock	165.09	165.99	165.07	165.87	5312686.0
2022-04-18 16:30:00	AAPL	Stock	165.85	165.9	165.07	165.7001	43653.0
2022-04-18 17:00:00	AAPL	Stock	165.7	165.86	165.61	165.7	27444.0
2022-04-18 17:30:00	AAPL	Stock	165.63	165.84	165.62	165.84	7148.0
2022-04-18 18:00:00	AAPL	Stock	165.79	165.85	165.69	165.75	19657.0
2022-04-18 18:30:00	AAPL	Stock	165.78	165.85	165.69	165.75	16718.0
2022-04-18 19:00:00	AAPL	Stock	165.73	165.79	165.63	165.7	23568.0
2022-04-18 19:30:00	AAPL	Stock	165.72	166.35	165.72	166.22	62215.0
2022-04-18 04:00:00	MSFT	Stock	277.0	279.1	277.0	278.75	1877.0
2022-04-18 04:30:00	MSFT	Stock	278.4	278.4	278.4	278.4	753.0
2022-04-18 05:00:00	MSFT	Stock	278.01	278.01	277.36	277.41	790.0
2022-04-18 05:30:00	MSFT	Stock	277.62	277.78	277.62	277.78	515.0
2022-04-18 06:00:00	MSFT	Stock	278.02	278.5	278.02	278.5	357.0
2022-04-18 06:30:00	MSFT	Stock	278.35	278.79	278.35	278.79	1322.0
2022-04-18 07:00:00	MSFT	Stock	279.1	279.58	279.1	279.2	2627.0
2022-04-18 07:30:00	MSFT	Stock	279.22	279.24	278.71	279.16	9206.0
2022-04-18 08:00:00	MSFT	Stock	279.0001	279.58	277.2612	278.39	27742.0
2022-04-18 08:30:00	MSFT	Stock	278.57	279.35	278.57	279.15	8838.0
2022-04-18 09:00:00	MSFT	Stock	278.87	279.5	278.55	279.0	25659.0
2022-04-18 09:30:00	MSFT	Stock	278.99	281.9	278.79	279.85	2398540.0
2022-04-18 10:00:00	MSFT	Stock	279.86	282.39	279.6795	281.99	1536656.0
2022-04-18 10:30:00	MSFT	Stock	281.99	282.46	280.56	281.04	889099.0
2022-04-18 11:00:00	MSFT	Stock	281.04	281.39	279.75	280.01	892492.0
2022-04-18 11:30:00	MSFT	Stock	280.01	280.16	279.36	279.96	683558.0
2022-04-18 12:00:00	MSFT	Stock	279.96	280.07	278.75	278.8	882126.0
2022-04-18 12:30:00	MSFT	Stock	278.77	279.41	278.64	278.89	719625.0

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

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