PREVIEW / stock_30min / 2021-08-27

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-08-27.parquet
  size:    2.2 MB
  rows:    108,563
  symbols: 2,733

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-27 04:00:00	AAPL	Stock	148.13	148.39	147.69	147.8	13443.0
2021-08-27 04:30:00	AAPL	Stock	147.82	148.11	147.82	148.11	4280.0
2021-08-27 05:00:00	AAPL	Stock	148.15	148.15	147.88	148.08	4956.0
2021-08-27 05:30:00	AAPL	Stock	148.01	148.4	147.88	148.3	4334.0
2021-08-27 06:00:00	AAPL	Stock	148.29	148.32	148.18	148.31	4273.0
2021-08-27 06:30:00	AAPL	Stock	148.28	148.28	148.24	148.27	2408.0
2021-08-27 07:00:00	AAPL	Stock	148.2	148.29	147.8	148.1	78127.0
2021-08-27 07:30:00	AAPL	Stock	148.1	148.22	147.9	148.02	35441.0
2021-08-27 08:00:00	AAPL	Stock	148.0	148.23	147.172	147.99	114682.0
2021-08-27 08:30:00	AAPL	Stock	148.03	148.14	147.9	147.91	146720.0
2021-08-27 09:00:00	AAPL	Stock	147.9	147.97	147.31	147.46	235566.0
2021-08-27 09:30:00	AAPL	Stock	147.46	147.87	146.83	147.18	6902190.0
2021-08-27 10:00:00	AAPL	Stock	147.18	148.42	146.88	147.93	6964455.0
2021-08-27 10:30:00	AAPL	Stock	147.94	148.1837	147.48	148.0175	3828650.0
2021-08-27 11:00:00	AAPL	Stock	148.02	148.095	147.77	147.787	2899524.0
2021-08-27 11:30:00	AAPL	Stock	147.775	148.52	147.775	148.51	3142577.0
2021-08-27 12:00:00	AAPL	Stock	148.515	148.635	148.18	148.1999	2345984.0
2021-08-27 12:30:00	AAPL	Stock	148.185	148.42	148.15	148.41	1790817.0
2021-08-27 13:00:00	AAPL	Stock	148.4	148.71	148.3318	148.5886	1915249.0
2021-08-27 13:30:00	AAPL	Stock	148.58	148.75	148.55	148.666	1609256.0
2021-08-27 14:00:00	AAPL	Stock	148.6631	148.74	148.5044	148.645	1727812.0
2021-08-27 14:30:00	AAPL	Stock	148.645	148.7099	148.5	148.545	1380115.0
2021-08-27 15:00:00	AAPL	Stock	148.545	148.67	148.46	148.535	1769373.0
2021-08-27 15:30:00	AAPL	Stock	148.5316	148.67	148.39	148.6	4798351.0
2021-08-27 16:00:00	AAPL	Stock	148.6	148.67	148.48	148.51	5969764.0
2021-08-27 16:30:00	AAPL	Stock	148.51	148.52	148.43	148.48	28153.0
2021-08-27 17:00:00	AAPL	Stock	148.46	148.49	148.41	148.42	24532.0
2021-08-27 17:30:00	AAPL	Stock	148.42	148.49	148.41	148.48	10140.0
2021-08-27 18:00:00	AAPL	Stock	148.48	148.49	148.43	148.46	11395.0
2021-08-27 18:30:00	AAPL	Stock	148.46	148.5	148.45	148.5	10325.0
2021-08-27 19:00:00	AAPL	Stock	148.52	148.52	148.47	148.48	2943.0
2021-08-27 19:30:00	AAPL	Stock	148.47	148.5	148.4	148.48	24516.0
2021-08-27 04:00:00	MSFT	Stock	299.65	299.83	299.39	299.79	4352.0
2021-08-27 04:30:00	MSFT	Stock	300.0	300.05	300.0	300.05	462.0
2021-08-27 05:00:00	MSFT	Stock	300.09	300.09	300.09	300.09	118.0
2021-08-27 05:30:00	MSFT	Stock	300.07	300.3	300.0	300.3	1124.0
2021-08-27 06:00:00	MSFT	Stock	300.37	300.39	300.29	300.36	1230.0
2021-08-27 07:00:00	MSFT	Stock	300.41	300.68	299.98	300.55	15413.0
2021-08-27 07:30:00	MSFT	Stock	300.5	300.5	300.11	300.16	3551.0
2021-08-27 08:00:00	MSFT	Stock	300.3802	300.7	299.837	300.02	15466.0
2021-08-27 08:30:00	MSFT	Stock	300.15	300.42	300.01	300.2	4879.0
2021-08-27 09:00:00	MSFT	Stock	300.2	300.25	298.8	299.12	46250.0
2021-08-27 09:30:00	MSFT	Stock	299.13	299.67	296.83	297.6184	2270253.0
2021-08-27 10:00:00	MSFT	Stock	297.65	300.87	297.31	299.65	2441051.0
2021-08-27 10:30:00	MSFT	Stock	299.65	300.07	298.96	299.59	1073027.0
2021-08-27 11:00:00	MSFT	Stock	299.58	299.77	298.72	298.78	654435.0
2021-08-27 11:30:00	MSFT	Stock	298.8	299.86	298.8	299.7	797257.0
2021-08-27 12:00:00	MSFT	Stock	299.71	299.78	299.14	299.27	511847.0
2021-08-27 12:30:00	MSFT	Stock	299.27	299.42	299.12	299.42	413942.0
2021-08-27 13:00:00	MSFT	Stock	299.41	299.96	299.32	299.89	518875.0

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

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