PREVIEW / stock_30min / 2021-08-26

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-08-26.parquet
  size:    2.2 MB
  rows:    107,509
  symbols: 2,756

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
2021-08-26 04:00:00	AAPL	Stock	148.0	148.13	147.92	148.1	1746.0
2021-08-26 04:30:00	AAPL	Stock	148.08	148.11	148.08	148.11	852.0
2021-08-26 05:00:00	AAPL	Stock	148.04	148.08	148.0	148.07	1454.0
2021-08-26 05:30:00	AAPL	Stock	148.07	148.07	148.05	148.05	1160.0
2021-08-26 06:00:00	AAPL	Stock	148.07	148.15	148.07	148.09	566.0
2021-08-26 06:30:00	AAPL	Stock	148.07	148.1	148.05	148.1	2469.0
2021-08-26 07:00:00	AAPL	Stock	148.14	148.35	148.11	148.29	24485.0
2021-08-26 07:30:00	AAPL	Stock	148.29	148.29	148.13	148.27	19750.0
2021-08-26 08:00:00	AAPL	Stock	148.3201	148.58	147.99	148.54	166883.0
2021-08-26 08:30:00	AAPL	Stock	148.58	148.59	148.1	148.33	262847.0
2021-08-26 09:00:00	AAPL	Stock	148.33	148.38	148.21	148.34	77656.0
2021-08-26 09:30:00	AAPL	Stock	148.33	149.12	148.2	148.31	6934948.0
2021-08-26 10:00:00	AAPL	Stock	148.3	148.73	147.73	147.8965	4799326.0
2021-08-26 10:30:00	AAPL	Stock	147.9	148.22	147.72	148.03	3454272.0
2021-08-26 11:00:00	AAPL	Stock	148.02	148.35	147.595	148.1935	3308469.0
2021-08-26 11:30:00	AAPL	Stock	148.2	148.29	147.93	148.14	2142177.0
2021-08-26 12:00:00	AAPL	Stock	148.135	148.65	148.13	148.635	2533341.0
2021-08-26 12:30:00	AAPL	Stock	148.635	148.65	148.22	148.33	1791767.0
2021-08-26 13:00:00	AAPL	Stock	148.335	148.35	147.9799	148.09	1725209.0
2021-08-26 13:30:00	AAPL	Stock	148.0841	148.287	148.03	148.085	1343390.0
2021-08-26 14:00:00	AAPL	Stock	148.09	148.09	147.83	147.98	1989816.0
2021-08-26 14:30:00	AAPL	Stock	147.98	148.04	147.71	147.74	1786569.0
2021-08-26 15:00:00	AAPL	Stock	147.74	147.84	147.51	147.72	2719233.0
2021-08-26 15:30:00	AAPL	Stock	147.725	147.9579	147.52	147.55	4580990.0
2021-08-26 16:00:00	AAPL	Stock	147.54	147.72	147.51	147.57	3301974.0
2021-08-26 16:30:00	AAPL	Stock	147.59	147.59	147.54	147.58	23126.0
2021-08-26 17:00:00	AAPL	Stock	147.58	147.62	147.56	147.6	14100.0
2021-08-26 17:30:00	AAPL	Stock	147.6	147.6499	147.57	147.6	9559.0
2021-08-26 18:00:00	AAPL	Stock	147.59	147.66	147.55	147.55	11074.0
2021-08-26 18:30:00	AAPL	Stock	147.555	147.62	147.54	147.55	15304.0
2021-08-26 19:00:00	AAPL	Stock	147.55	147.56	147.53	147.56	9177.0
2021-08-26 19:30:00	AAPL	Stock	147.56	147.58	147.52	147.58	12674.0
2021-08-26 04:00:00	MSFT	Stock	301.52	301.54	301.52	301.54	499.0
2021-08-26 05:00:00	MSFT	Stock	301.68	301.7	301.68	301.7	324.0
2021-08-26 05:30:00	MSFT	Stock	301.54	301.54	301.54	301.54	157.0
2021-08-26 07:00:00	MSFT	Stock	301.67	302.0	301.65	302.0	3412.0
2021-08-26 07:30:00	MSFT	Stock	302.15	302.15	301.8	301.8	4442.0
2021-08-26 08:00:00	MSFT	Stock	301.7	302.3194	301.6	301.8	7066.0
2021-08-26 08:30:00	MSFT	Stock	301.72	301.75	300.65	301.0	23931.0
2021-08-26 09:00:00	MSFT	Stock	301.08	301.63	300.68	300.94	22031.0
2021-08-26 09:30:00	MSFT	Stock	300.99	302.429	300.89	301.12	1489532.0
2021-08-26 10:00:00	MSFT	Stock	301.09	301.93	299.86	300.19	1405651.0
2021-08-26 10:30:00	MSFT	Stock	300.19	300.61	299.63	300.24	1589362.0
2021-08-26 11:00:00	MSFT	Stock	300.15	301.05	299.63	300.24	928745.0
2021-08-26 11:30:00	MSFT	Stock	300.24	300.5	299.98	300.425	716417.0
2021-08-26 12:00:00	MSFT	Stock	300.48	301.03	300.44	300.91	487096.0
2021-08-26 12:30:00	MSFT	Stock	300.905	301.0099	300.6	300.8211	365311.0
2021-08-26 13:00:00	MSFT	Stock	300.8	300.96	300.6	300.77	366059.0
2021-08-26 13:30:00	MSFT	Stock	300.75	301.11	300.62	300.65	396873.0
2021-08-26 14:00:00	MSFT	Stock	300.64	300.71	300.24	300.41	404324.0

> showing 50 of 107,509 rows — these rows as CSV

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