PREVIEW / stock_30min / 2022-04-01

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-04-01.parquet
  size:    2.2 MB
  rows:    108,511
  symbols: 2,494

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-01 04:00:00	AAPL	Stock	175.25	175.88	175.1	175.35	19892.0
2022-04-01 04:30:00	AAPL	Stock	175.32	175.37	175.26	175.26	4525.0
2022-04-01 05:00:00	AAPL	Stock	175.32	175.32	175.06	175.18	5460.0
2022-04-01 05:30:00	AAPL	Stock	175.2	175.38	175.04	175.31	8232.0
2022-04-01 06:00:00	AAPL	Stock	175.43	175.54	175.33	175.5	45974.0
2022-04-01 06:30:00	AAPL	Stock	175.5	175.72	175.45	175.5	44083.0
2022-04-01 07:00:00	AAPL	Stock	175.54	175.6	174.8	174.8	106407.0
2022-04-01 07:30:00	AAPL	Stock	174.76	174.98	174.69	174.82	56576.0
2022-04-01 08:00:00	AAPL	Stock	175.49	175.52	174.174	174.88	228813.0
2022-04-01 08:30:00	AAPL	Stock	174.89	174.96	173.35	173.6	507203.0
2022-04-01 09:00:00	AAPL	Stock	173.65	174.02	173.26	173.99	411943.0
2022-04-01 09:30:00	AAPL	Stock	173.99	174.88	172.6	172.84	9778272.0
2022-04-01 10:00:00	AAPL	Stock	172.83	174.17	172.51	173.25	6147426.0
2022-04-01 10:30:00	AAPL	Stock	173.24	174.02	173.0	173.9	4068411.0
2022-04-01 11:00:00	AAPL	Stock	173.9	174.0199	172.765	172.925	3691910.0
2022-04-01 11:30:00	AAPL	Stock	172.9206	172.9379	171.94	172.2	4378301.0
2022-04-01 12:00:00	AAPL	Stock	172.19	172.88	172.07	172.85	3023683.0
2022-04-01 12:30:00	AAPL	Stock	172.84	172.84	172.27	172.2721	2506818.0
2022-04-01 13:00:00	AAPL	Stock	172.27	172.52	172.1	172.335	2681650.0
2022-04-01 13:30:00	AAPL	Stock	172.335	172.8	172.2	172.5399	2393741.0
2022-04-01 14:00:00	AAPL	Stock	172.53	173.405	172.46	173.355	3557863.0
2022-04-01 14:30:00	AAPL	Stock	173.35	173.74	173.16	173.2	3217669.0
2022-04-01 15:00:00	AAPL	Stock	173.2	173.5554	172.88	173.035	3405178.0
2022-04-01 15:30:00	AAPL	Stock	173.0311	174.645	172.77	174.26	9018917.0
2022-04-01 16:00:00	AAPL	Stock	174.31	174.33	173.95	174.15	7471543.0
2022-04-01 16:30:00	AAPL	Stock	174.1	174.41	173.92	174.1	91704.0
2022-04-01 17:00:00	AAPL	Stock	174.1	174.31	173.9	174.09	38997.0
2022-04-01 17:30:00	AAPL	Stock	174.1	174.1	173.92	174.04	14059.0
2022-04-01 18:00:00	AAPL	Stock	174.1	174.11	174.01	174.01	2404.0
2022-04-01 18:30:00	AAPL	Stock	174.03	174.11	174.0	174.1	6525.0
2022-04-01 19:00:00	AAPL	Stock	174.14	174.15	173.92	173.92	14059.0
2022-04-01 19:30:00	AAPL	Stock	173.97	174.04	173.9299	174.0	18015.0
2022-04-01 04:00:00	MSFT	Stock	310.37	310.5	309.8	309.8	807.0
2022-04-01 04:30:00	MSFT	Stock	310.0	310.1	309.92	309.92	1443.0
2022-04-01 05:00:00	MSFT	Stock	309.66	309.75	309.2	309.75	1836.0
2022-04-01 05:30:00	MSFT	Stock	309.77	310.1	309.74	310.01	1671.0
2022-04-01 06:00:00	MSFT	Stock	310.03	310.03	310.03	310.03	590.0
2022-04-01 06:30:00	MSFT	Stock	310.28	310.28	310.03	310.11	1457.0
2022-04-01 07:00:00	MSFT	Stock	310.3	310.41	310.2	310.31	3157.0
2022-04-01 07:30:00	MSFT	Stock	310.2	310.6	310.2	310.6	3461.0
2022-04-01 08:00:00	MSFT	Stock	310.2	310.6	307.54	310.2	30669.0
2022-04-01 08:30:00	MSFT	Stock	310.02	310.42	309.31	309.7	54891.0
2022-04-01 09:00:00	MSFT	Stock	309.64	309.9	308.31	309.46	75454.0
2022-04-01 09:30:00	MSFT	Stock	309.46	310.13	306.82	306.945	2419394.0
2022-04-01 10:00:00	MSFT	Stock	306.94	308.94	306.272	308.5593	1406270.0
2022-04-01 10:30:00	MSFT	Stock	308.52	309.45	307.43	308.75	1067829.0
2022-04-01 11:00:00	MSFT	Stock	308.73	308.99	307.64	307.83	809823.0
2022-04-01 11:30:00	MSFT	Stock	307.815	307.89	305.61	305.8615	1231844.0
2022-04-01 12:00:00	MSFT	Stock	305.83	306.82	305.54	306.695	676020.0
2022-04-01 12:30:00	MSFT	Stock	306.68	306.69	305.86	306.0406	759895.0

> showing 50 of 108,511 rows — these rows as CSV

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