PREVIEW / stock_30min / 2022-05-23

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-05-23.parquet
  size:    2.1 MB
  rows:    106,422
  symbols: 2,378

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-05-23 04:00:00	AAPL	Stock	138.75	139.37	138.1	138.45	33827.0
2022-05-23 04:30:00	AAPL	Stock	138.44	138.44	137.8	138.0	16694.0
2022-05-23 05:00:00	AAPL	Stock	138.1	138.22	138.01	138.22	34159.0
2022-05-23 05:30:00	AAPL	Stock	138.25	138.45	138.0	138.01	17242.0
2022-05-23 06:00:00	AAPL	Stock	137.98	138.18	137.95	138.11	13430.0
2022-05-23 06:30:00	AAPL	Stock	138.15	138.87	138.15	138.72	28024.0
2022-05-23 07:00:00	AAPL	Stock	138.72	138.85	138.39	138.55	76573.0
2022-05-23 07:30:00	AAPL	Stock	138.47	138.59	137.91	138.39	74760.0
2022-05-23 08:00:00	AAPL	Stock	138.7435	139.48	137.91	138.34	640573.0
2022-05-23 08:30:00	AAPL	Stock	138.37	138.37	137.81	137.94	321147.0
2022-05-23 09:00:00	AAPL	Stock	137.9449	138.1458	137.51	137.84	320171.0
2022-05-23 09:30:00	AAPL	Stock	137.79	141.03	137.65	139.79	15117560.0
2022-05-23 10:00:00	AAPL	Stock	139.8	140.44	138.69	140.1614	9151121.0
2022-05-23 10:30:00	AAPL	Stock	140.17	141.68	140.01	140.47	8767729.0
2022-05-23 11:00:00	AAPL	Stock	140.49	141.55	140.26	141.285	6496927.0
2022-05-23 11:30:00	AAPL	Stock	141.29	142.08	141.04	141.98	6449926.0
2022-05-23 12:00:00	AAPL	Stock	141.99	143.26	141.81	142.565	7874326.0
2022-05-23 12:30:00	AAPL	Stock	142.57	142.795	141.95	142.3765	5276923.0
2022-05-23 13:00:00	AAPL	Stock	142.385	142.46	141.5207	141.95	5147272.0
2022-05-23 13:30:00	AAPL	Stock	141.9401	142.8656	141.68	142.64	4432837.0
2022-05-23 14:00:00	AAPL	Stock	142.6501	142.89	142.33	142.49	4002164.0
2022-05-23 14:30:00	AAPL	Stock	142.495	142.9199	142.0633	142.215	4200886.0
2022-05-23 15:00:00	AAPL	Stock	142.219	142.7627	142.13	142.4	5523454.0
2022-05-23 15:30:00	AAPL	Stock	142.3959	143.25	141.895	143.15	10230880.0
2022-05-23 16:00:00	AAPL	Stock	143.14	143.45	143.05	143.29	8212213.0
2022-05-23 16:30:00	AAPL	Stock	143.2701	143.34	143.11	143.28	165558.0
2022-05-23 17:00:00	AAPL	Stock	143.28	143.28	141.7	141.85	180328.0
2022-05-23 17:30:00	AAPL	Stock	141.89	141.94	140.66	140.98	261382.0
2022-05-23 18:00:00	AAPL	Stock	141.1	141.1	140.5	140.79	132813.0
2022-05-23 18:30:00	AAPL	Stock	140.77	141.26	140.77	141.25	57198.0
2022-05-23 19:00:00	AAPL	Stock	141.25	141.4	141.0	141.1	52272.0
2022-05-23 19:30:00	AAPL	Stock	141.1	141.32	141.0	141.19	64699.0
2022-05-23 04:00:00	MSFT	Stock	255.01	256.5	254.14	254.14	3692.0
2022-05-23 04:30:00	MSFT	Stock	254.01	254.01	253.8	253.83	1556.0
2022-05-23 05:00:00	MSFT	Stock	254.0	254.98	254.0	254.98	3490.0
2022-05-23 05:30:00	MSFT	Stock	255.15	255.45	253.0	253.9	14896.0
2022-05-23 06:00:00	MSFT	Stock	253.83	253.99	253.7	253.98	2284.0
2022-05-23 06:30:00	MSFT	Stock	253.99	255.88	253.99	255.71	12300.0
2022-05-23 07:00:00	MSFT	Stock	255.45	255.94	254.9	255.01	15157.0
2022-05-23 07:30:00	MSFT	Stock	255.0	255.7	254.61	255.5	10663.0
2022-05-23 08:00:00	MSFT	Stock	255.7497	256.25	254.55	255.85	58335.0
2022-05-23 08:30:00	MSFT	Stock	255.51	256.0	254.58	255.0023	26965.0
2022-05-23 09:00:00	MSFT	Stock	255.2	256.11	254.57	255.52	19774.0
2022-05-23 09:30:00	MSFT	Stock	255.85	258.08	253.43	256.715	3147482.0
2022-05-23 10:00:00	MSFT	Stock	256.715	257.73	255.0601	257.6578	2019920.0
2022-05-23 10:30:00	MSFT	Stock	257.68	258.84	256.72	257.56	2037871.0
2022-05-23 11:00:00	MSFT	Stock	257.58	259.66	257.14	259.17	1573936.0
2022-05-23 11:30:00	MSFT	Stock	259.17	260.35	258.93	260.08	1362354.0
2022-05-23 12:00:00	MSFT	Stock	260.11	261.5	259.955	260.9067	1368638.0
2022-05-23 12:30:00	MSFT	Stock	260.915	260.995	259.75	260.04	989565.0

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

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