PREVIEW / stock_30min / 2021-08-23

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-08-23.parquet
  size:    2.2 MB
  rows:    111,450
  symbols: 2,835

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-23 04:00:00	AAPL	Stock	148.56	148.65	148.2	148.65	8088.0
2021-08-23 04:30:00	AAPL	Stock	148.63	148.85	148.6	148.83	6435.0
2021-08-23 05:00:00	AAPL	Stock	148.85	148.85	148.58	148.58	6361.0
2021-08-23 05:30:00	AAPL	Stock	148.57	148.59	148.44	148.52	5081.0
2021-08-23 06:00:00	AAPL	Stock	148.52	148.52	148.35	148.44	8399.0
2021-08-23 06:30:00	AAPL	Stock	148.44	148.54	148.44	148.54	3250.0
2021-08-23 07:00:00	AAPL	Stock	148.53	148.7	148.44	148.66	70008.0
2021-08-23 07:30:00	AAPL	Stock	148.69	148.79	148.6	148.65	66918.0
2021-08-23 08:00:00	AAPL	Stock	148.69	148.79	147.82	148.54	157539.0
2021-08-23 08:30:00	AAPL	Stock	148.57	148.61	148.34	148.47	82521.0
2021-08-23 09:00:00	AAPL	Stock	148.52	148.54	148.1	148.2	178488.0
2021-08-23 09:30:00	AAPL	Stock	148.24	148.82	147.89	148.6357	8106460.0
2021-08-23 10:00:00	AAPL	Stock	148.65	149.55	148.49	149.325	5771579.0
2021-08-23 10:30:00	AAPL	Stock	149.33	149.77	149.24	149.47	3591620.0
2021-08-23 11:00:00	AAPL	Stock	149.48	149.7	149.411	149.65	2633546.0
2021-08-23 11:30:00	AAPL	Stock	149.645	149.94	149.62	149.8895	3200182.0
2021-08-23 12:00:00	AAPL	Stock	149.885	149.97	149.6601	149.814	2302084.0
2021-08-23 12:30:00	AAPL	Stock	149.8126	149.97	149.592	149.8266	2689760.0
2021-08-23 13:00:00	AAPL	Stock	149.83	150.15	149.6345	149.7088	3618394.0
2021-08-23 13:30:00	AAPL	Stock	149.7	150.01	149.66	149.905	2216493.0
2021-08-23 14:00:00	AAPL	Stock	149.91	150.07	149.86	149.89	1980996.0
2021-08-23 14:30:00	AAPL	Stock	149.8844	150.19	149.88	150.0291	2082115.0
2021-08-23 15:00:00	AAPL	Stock	150.03	150.1	149.83	149.965	2370731.0
2021-08-23 15:30:00	AAPL	Stock	149.96	150.08	149.5788	149.7	4585906.0
2021-08-23 16:00:00	AAPL	Stock	149.71	149.75	149.6	149.69	5749158.0
2021-08-23 16:30:00	AAPL	Stock	149.69	149.74	149.66	149.66	28118.0
2021-08-23 17:00:00	AAPL	Stock	149.7	149.71	149.66	149.68	16226.0
2021-08-23 17:30:00	AAPL	Stock	149.68	149.72	149.67	149.71	16519.0
2021-08-23 18:00:00	AAPL	Stock	149.71	149.75	149.7	149.72	24640.0
2021-08-23 18:30:00	AAPL	Stock	149.72	149.75	149.71	149.75	8365.0
2021-08-23 19:00:00	AAPL	Stock	149.73	149.76	149.71	149.72	23521.0
2021-08-23 19:30:00	AAPL	Stock	149.75	149.77	149.5	149.73	33519.0
2021-08-23 04:00:00	MSFT	Stock	304.6	306.09	304.6	305.9	5064.0
2021-08-23 04:30:00	MSFT	Stock	305.83	305.89	305.75	305.75	1879.0
2021-08-23 05:00:00	MSFT	Stock	305.75	305.75	305.5	305.5	1821.0
2021-08-23 05:30:00	MSFT	Stock	305.5	305.5	305.21	305.25	2914.0
2021-08-23 06:00:00	MSFT	Stock	305.2	305.2	304.69	305.2	3606.0
2021-08-23 06:30:00	MSFT	Stock	305.1	305.1	304.92	305.0	7897.0
2021-08-23 07:00:00	MSFT	Stock	304.76	305.4	304.3	304.76	27818.0
2021-08-23 07:30:00	MSFT	Stock	304.76	305.17	303.9	304.16	33988.0
2021-08-23 08:00:00	MSFT	Stock	305.0	305.41	303.9	304.01	40351.0
2021-08-23 08:30:00	MSFT	Stock	304.08	304.18	303.62	303.8	21226.0
2021-08-23 09:00:00	MSFT	Stock	303.7	304.0	303.0	303.12	61519.0
2021-08-23 09:30:00	MSFT	Stock	303.26	305.4	301.85	304.01	3085957.0
2021-08-23 10:00:00	MSFT	Stock	303.99	304.88	303.35	304.0327	1789587.0
2021-08-23 10:30:00	MSFT	Stock	304.07	305.14	304.0232	304.25	1475383.0
2021-08-23 11:00:00	MSFT	Stock	304.25	304.46	303.98	304.09	862834.0
2021-08-23 11:30:00	MSFT	Stock	304.0891	304.4675	304.05	304.185	804092.0
2021-08-23 12:00:00	MSFT	Stock	304.18	304.29	303.55	303.59	789153.0
2021-08-23 12:30:00	MSFT	Stock	303.58	304.13	303.58	304.0958	598103.0

> showing 50 of 111,450 rows — these rows as CSV

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