PREVIEW / stock_30min / 2023-03-13

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-03-13.parquet
  size:    2.2 MB
  rows:    108,263
  symbols: 1,763

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
2023-03-13 04:00:00	AAPL	Stock	150.55	150.73	150.21	150.21	41872.0
2023-03-13 04:30:00	AAPL	Stock	150.13	150.2	149.16	149.16	20155.0
2023-03-13 05:00:00	AAPL	Stock	149.11	149.44	148.35	148.85	28456.0
2023-03-13 05:30:00	AAPL	Stock	148.85	149.9	148.61	149.03	24077.0
2023-03-13 06:00:00	AAPL	Stock	149.0	149.49	148.81	149.18	12048.0
2023-03-13 06:30:00	AAPL	Stock	149.25	150.0	148.96	149.79	22780.0
2023-03-13 07:00:00	AAPL	Stock	149.52	150.1	149.33	149.47	41906.0
2023-03-13 07:30:00	AAPL	Stock	149.53	149.74	148.94	149.3	49191.0
2023-03-13 08:00:00	AAPL	Stock	149.8	150.95	148.129	148.43	224376.0
2023-03-13 08:30:00	AAPL	Stock	148.49	148.57	146.28	147.63	198588.0
2023-03-13 09:00:00	AAPL	Stock	147.622	148.0371	146.8	147.87	267957.0
2023-03-13 09:30:00	AAPL	Stock	147.805	151.14	147.7	150.74	8965809.0
2023-03-13 10:00:00	AAPL	Stock	150.74	151.47	150.27	150.85	6504525.0
2023-03-13 10:30:00	AAPL	Stock	150.87	151.87	150.19	151.5611	6199640.0
2023-03-13 11:00:00	AAPL	Stock	151.565	152.66	151.3401	152.56	6103049.0
2023-03-13 11:30:00	AAPL	Stock	152.56	153.14	152.23	152.61	5045323.0
2023-03-13 12:00:00	AAPL	Stock	152.61	153.1	151.98	152.24	4069455.0
2023-03-13 12:30:00	AAPL	Stock	152.23	152.5846	151.47	151.8	3366098.0
2023-03-13 13:00:00	AAPL	Stock	151.8	151.9	150.99	151.24	3329868.0
2023-03-13 13:30:00	AAPL	Stock	151.23	152.04	150.88	151.9044	2975737.0
2023-03-13 14:00:00	AAPL	Stock	151.92	152.54	151.76	152.23	3260137.0
2023-03-13 14:30:00	AAPL	Stock	152.22	152.7	151.73	152.1144	3204304.0
2023-03-13 15:00:00	AAPL	Stock	152.11	152.35	150.82	151.03	4006950.0
2023-03-13 15:30:00	AAPL	Stock	151.05	151.62	150.35	150.46	6588385.0
2023-03-13 16:00:00	AAPL	Stock	150.45	150.7	150.31	150.51	8476233.0
2023-03-13 16:30:00	AAPL	Stock	150.5	150.67	150.13	150.64	51936.0
2023-03-13 17:00:00	AAPL	Stock	150.52	150.61	150.44	150.5326	11874.0
2023-03-13 17:30:00	AAPL	Stock	150.55	150.67	150.55	150.61	12289.0
2023-03-13 18:00:00	AAPL	Stock	150.64	150.77	150.47	150.77	28247.0
2023-03-13 18:30:00	AAPL	Stock	150.76	150.94	150.75	150.94	11765.0
2023-03-13 19:00:00	AAPL	Stock	150.94	150.96	150.65	150.66	11307.0
2023-03-13 19:30:00	AAPL	Stock	150.7	150.9	150.7	150.9	12815.0
2023-03-13 04:00:00	MSFT	Stock	251.5	252.5	250.94	251.73	28502.0
2023-03-13 04:30:00	MSFT	Stock	251.74	251.88	250.1	250.1	4715.0
2023-03-13 05:00:00	MSFT	Stock	250.39	250.5	248.89	249.48	6467.0
2023-03-13 05:30:00	MSFT	Stock	249.0	251.43	248.67	249.84	10612.0
2023-03-13 06:00:00	MSFT	Stock	250.32	250.49	248.5	250.0	20375.0
2023-03-13 06:30:00	MSFT	Stock	250.34	252.81	250.0	252.46	7425.0
2023-03-13 07:00:00	MSFT	Stock	251.83	252.99	251.0	251.1	14535.0
2023-03-13 07:30:00	MSFT	Stock	251.12	251.74	250.41	251.74	15271.0
2023-03-13 08:00:00	MSFT	Stock	252.12	253.56	247.969	250.41	29807.0
2023-03-13 08:30:00	MSFT	Stock	250.5	250.5	245.0	247.99	39852.0
2023-03-13 09:00:00	MSFT	Stock	248.06	249.8	246.79	247.56	59229.0
2023-03-13 09:30:00	MSFT	Stock	247.22	251.13	245.73	250.4	2798488.0
2023-03-13 10:00:00	MSFT	Stock	250.39	252.07	249.81	251.09	1781322.0
2023-03-13 10:30:00	MSFT	Stock	251.1	254.34	250.92	254.03	1897078.0
2023-03-13 11:00:00	MSFT	Stock	254.06	256.06	253.71	255.87	1957221.0
2023-03-13 11:30:00	MSFT	Stock	255.84	256.46	254.67	255.85	1393911.0
2023-03-13 12:00:00	MSFT	Stock	255.88	256.79	254.72	255.75	1228428.0
2023-03-13 12:30:00	MSFT	Stock	255.84	256.6	254.73	255.255	1021522.0

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

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