PREVIEW / stock_30min / 2022-11-18

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-11-18.parquet
  size:    2.1 MB
  rows:    102,113
  symbols: 2,090

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-18 04:00:00	AAPL	Stock	150.17	151.0	150.17	151.0	19619.0
2022-11-18 04:30:00	AAPL	Stock	151.01	151.22	150.8	150.8	18719.0
2022-11-18 05:00:00	AAPL	Stock	150.81	151.35	150.73	150.94	19810.0
2022-11-18 05:30:00	AAPL	Stock	151.0	151.68	151.0	151.6	11377.0
2022-11-18 06:00:00	AAPL	Stock	151.5	151.58	151.28	151.38	12081.0
2022-11-18 06:30:00	AAPL	Stock	151.39	151.45	151.3	151.3	19689.0
2022-11-18 07:00:00	AAPL	Stock	151.31	152.07	151.29	151.71	62173.0
2022-11-18 07:30:00	AAPL	Stock	151.82	151.83	151.53	151.55	34934.0
2022-11-18 08:00:00	AAPL	Stock	151.57	152.0885	151.3	151.87	100664.0
2022-11-18 08:30:00	AAPL	Stock	151.831	151.94	151.74	151.9	74326.0
2022-11-18 09:00:00	AAPL	Stock	151.92	152.5	151.83	152.3	222530.0
2022-11-18 09:30:00	AAPL	Stock	152.17	152.7	150.775	151.48	8494057.0
2022-11-18 10:00:00	AAPL	Stock	151.48	151.5199	149.97	150.55	5640552.0
2022-11-18 10:30:00	AAPL	Stock	150.5536	151.3042	150.28	150.9905	4344348.0
2022-11-18 11:00:00	AAPL	Stock	150.99	151.82	150.57	151.62	4428784.0
2022-11-18 11:30:00	AAPL	Stock	151.62	151.98	150.99	151.42	4011927.0
2022-11-18 12:00:00	AAPL	Stock	151.41	151.59	150.46	150.77	3291675.0
2022-11-18 12:30:00	AAPL	Stock	150.76	150.86	150.35	150.65	2287678.0
2022-11-18 13:00:00	AAPL	Stock	150.6509	151.215	150.54	151.19	2934367.0
2022-11-18 13:30:00	AAPL	Stock	151.19	151.2799	150.78	150.99	2131483.0
2022-11-18 14:00:00	AAPL	Stock	150.995	151.22	150.92	151.02	2252257.0
2022-11-18 14:30:00	AAPL	Stock	151.03	151.3079	150.86	151.21	2909941.0
2022-11-18 15:00:00	AAPL	Stock	151.22	151.74	151.195	151.72	3827539.0
2022-11-18 15:30:00	AAPL	Stock	151.73	151.91	150.78	151.31	8210263.0
2022-11-18 16:00:00	AAPL	Stock	151.32	151.37	151.04	151.13	10471748.0
2022-11-18 16:30:00	AAPL	Stock	151.11	151.29	150.97	151.11	72169.0
2022-11-18 17:00:00	AAPL	Stock	151.09	151.29	151.04	151.18	250159.0
2022-11-18 17:30:00	AAPL	Stock	151.14	151.17	151.0	151.0034	11174.0
2022-11-18 18:00:00	AAPL	Stock	151.03	151.09	151.0	151.0	4259.0
2022-11-18 18:30:00	AAPL	Stock	150.91	150.97	150.9	150.95	8106.0
2022-11-18 19:00:00	AAPL	Stock	150.91	150.98	150.91	150.97	3566.0
2022-11-18 19:30:00	AAPL	Stock	150.95	150.97	150.85	150.88	11771.0
2022-11-18 04:00:00	MSFT	Stock	241.68	242.0	241.68	241.89	2937.0
2022-11-18 04:30:00	MSFT	Stock	242.15	242.15	241.93	241.93	310.0
2022-11-18 05:00:00	MSFT	Stock	241.65	242.35	241.65	242.35	465.0
2022-11-18 05:30:00	MSFT	Stock	242.99	243.5	242.92	243.4	1555.0
2022-11-18 06:00:00	MSFT	Stock	243.49	243.5	243.24	243.24	400.0
2022-11-18 06:30:00	MSFT	Stock	243.46	243.49	243.46	243.49	235.0
2022-11-18 07:00:00	MSFT	Stock	243.3	243.57	242.88	243.49	9293.0
2022-11-18 07:30:00	MSFT	Stock	243.59	243.6	243.21	243.42	3330.0
2022-11-18 08:00:00	MSFT	Stock	243.014	243.7	241.076	243.55	14050.0
2022-11-18 08:30:00	MSFT	Stock	243.72	243.72	243.5	243.69	4760.0
2022-11-18 09:00:00	MSFT	Stock	243.75	244.7	243.05	243.31	58664.0
2022-11-18 09:30:00	MSFT	Stock	243.37	243.74	240.07	241.69	3294922.0
2022-11-18 10:00:00	MSFT	Stock	241.72	241.86	240.07	240.88	1086130.0
2022-11-18 10:30:00	MSFT	Stock	240.89	241.15	239.03	239.8	834447.0
2022-11-18 11:00:00	MSFT	Stock	239.82	240.49	239.06	240.15	861943.0
2022-11-18 11:30:00	MSFT	Stock	240.17	240.4655	239.27	239.9825	572378.0
2022-11-18 12:00:00	MSFT	Stock	239.99	240.22	239.2	239.65	862298.0
2022-11-18 12:30:00	MSFT	Stock	239.615	239.85	239.15	239.545	524780.0

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

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