PREVIEW / stock_30min / 2022-11-08

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-11-08.parquet
  size:    2.1 MB
  rows:    102,510
  symbols: 2,080

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-11-08 04:00:00	AAPL	Stock	139.04	139.3	138.64	139.29	8591.0
2022-11-08 04:30:00	AAPL	Stock	139.34	139.49	139.28	139.4	16316.0
2022-11-08 05:00:00	AAPL	Stock	139.35	139.65	139.34	139.45	10876.0
2022-11-08 05:30:00	AAPL	Stock	139.47	139.47	139.2	139.2	2782.0
2022-11-08 06:00:00	AAPL	Stock	139.27	139.61	139.27	139.61	6613.0
2022-11-08 06:30:00	AAPL	Stock	139.55	139.93	139.5	139.75	86051.0
2022-11-08 07:00:00	AAPL	Stock	139.7	139.75	139.22	139.3	82628.0
2022-11-08 07:30:00	AAPL	Stock	139.3	139.74	139.3	139.74	27433.0
2022-11-08 08:00:00	AAPL	Stock	139.675	139.8	138.6515	139.47	156300.0
2022-11-08 08:30:00	AAPL	Stock	139.5	140.08	139.499	139.94	126803.0
2022-11-08 09:00:00	AAPL	Stock	139.95	140.42	139.93	140.29	225678.0
2022-11-08 09:30:00	AAPL	Stock	140.4	140.49	138.44	139.16	7813930.0
2022-11-08 10:00:00	AAPL	Stock	139.16	139.21	138.04	138.44	5915709.0
2022-11-08 10:30:00	AAPL	Stock	138.45	139.52	138.385	139.4913	4344223.0
2022-11-08 11:00:00	AAPL	Stock	139.49	140.31	139.2	140.2679	4171284.0
2022-11-08 11:30:00	AAPL	Stock	140.27	140.89	140.17	140.875	4526198.0
2022-11-08 12:00:00	AAPL	Stock	140.88	141.15	140.39	140.8	3933227.0
2022-11-08 12:30:00	AAPL	Stock	140.81	141.32	140.71	141.1105	3364769.0
2022-11-08 13:00:00	AAPL	Stock	141.1209	141.43	139.45	139.64	4461944.0
2022-11-08 13:30:00	AAPL	Stock	139.64	140.1297	138.5	138.77	4579232.0
2022-11-08 14:00:00	AAPL	Stock	138.76	139.16	137.64	137.6809	4478282.0
2022-11-08 14:30:00	AAPL	Stock	137.69	139.06	137.49	138.615	4173722.0
2022-11-08 15:00:00	AAPL	Stock	138.62	139.93	138.55	139.9145	4248808.0
2022-11-08 15:30:00	AAPL	Stock	139.91	140.64	139.37	139.51	6964561.0
2022-11-08 16:00:00	AAPL	Stock	139.5	139.55	139.1001	139.53	8346589.0
2022-11-08 16:30:00	AAPL	Stock	139.57	139.65	139.4	139.52	51261.0
2022-11-08 17:00:00	AAPL	Stock	139.54	139.66	139.5	139.6	32318.0
2022-11-08 17:30:00	AAPL	Stock	139.59	139.59	139.51	139.59	6816.0
2022-11-08 18:00:00	AAPL	Stock	139.59	139.85	139.59	139.85	21122.0
2022-11-08 18:30:00	AAPL	Stock	139.86	139.9	139.8	139.83	16519.0
2022-11-08 19:00:00	AAPL	Stock	139.85	139.85	139.55	139.65	12932.0
2022-11-08 19:30:00	AAPL	Stock	139.69	140.0	139.69	139.98	21930.0
2022-11-08 04:00:00	MSFT	Stock	227.77	227.77	227.14	227.37	1195.0
2022-11-08 04:30:00	MSFT	Stock	228.45	228.71	228.35	228.71	858.0
2022-11-08 05:00:00	MSFT	Stock	228.66	229.36	228.66	228.9	2102.0
2022-11-08 05:30:00	MSFT	Stock	228.7	228.7	228.0	228.1	760.0
2022-11-08 06:00:00	MSFT	Stock	228.4	228.4	228.4	228.4	225.0
2022-11-08 06:30:00	MSFT	Stock	228.5	229.1	228.5	229.0	8158.0
2022-11-08 07:00:00	MSFT	Stock	229.0	229.15	228.67	228.79	11794.0
2022-11-08 07:30:00	MSFT	Stock	228.76	228.88	228.44	228.88	4275.0
2022-11-08 08:00:00	MSFT	Stock	229.0999	229.1896	228.42	228.948	26214.0
2022-11-08 08:30:00	MSFT	Stock	228.85	229.55	228.74	229.1	13434.0
2022-11-08 09:00:00	MSFT	Stock	229.37	229.8752	228.47	228.5	29071.0
2022-11-08 09:30:00	MSFT	Stock	228.59	230.41	227.5285	229.65	2563229.0
2022-11-08 10:00:00	MSFT	Stock	229.58	230.73	228.68	229.54	1509131.0
2022-11-08 10:30:00	MSFT	Stock	229.5421	230.21	229.07	229.35	1037308.0
2022-11-08 11:00:00	MSFT	Stock	229.37	230.58	228.45	230.415	1194604.0
2022-11-08 11:30:00	MSFT	Stock	230.415	231.54	230.415	231.025	1192642.0
2022-11-08 12:00:00	MSFT	Stock	231.03	231.65	230.68	230.9487	956181.0
2022-11-08 12:30:00	MSFT	Stock	230.95	231.13	230.38	230.82	731418.0

> showing 50 of 102,510 rows — these rows as CSV

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