PREVIEW / stock_30min / 2021-08-20

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-08-20.parquet
  size:    2.2 MB
  rows:    109,187
  symbols: 2,822

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-20 04:00:00	AAPL	Stock	146.0	146.49	145.9	146.1	8792.0
2021-08-20 04:30:00	AAPL	Stock	146.1	146.31	146.05	146.24	6527.0
2021-08-20 05:00:00	AAPL	Stock	146.22	146.5	146.15	146.5	9176.0
2021-08-20 05:30:00	AAPL	Stock	146.44	146.5	146.4	146.43	3752.0
2021-08-20 06:00:00	AAPL	Stock	146.35	146.45	146.3	146.4	871.0
2021-08-20 06:30:00	AAPL	Stock	146.4	146.49	146.4	146.48	1502.0
2021-08-20 07:00:00	AAPL	Stock	146.46	146.5	146.11	146.47	52585.0
2021-08-20 07:30:00	AAPL	Stock	146.48	146.65	146.45	146.5	33821.0
2021-08-20 08:00:00	AAPL	Stock	146.5133	146.97	146.15	146.82	152452.0
2021-08-20 08:30:00	AAPL	Stock	146.83	147.4	146.8	147.34	246551.0
2021-08-20 09:00:00	AAPL	Stock	147.35	147.98	146.7	147.47	755907.0
2021-08-20 09:30:00	AAPL	Stock	147.44	147.8299	146.78	147.49	9168716.0
2021-08-20 10:00:00	AAPL	Stock	147.5	148.33	147.35	148.08	5274797.0
2021-08-20 10:30:00	AAPL	Stock	148.08	148.5	147.79	147.8707	4105772.0
2021-08-20 11:00:00	AAPL	Stock	147.87	147.99	147.7	147.755	2417080.0
2021-08-20 11:30:00	AAPL	Stock	147.75	148.035	147.12	147.35	3280791.0
2021-08-20 12:00:00	AAPL	Stock	147.345	147.81	147.24	147.8	2467006.0
2021-08-20 12:30:00	AAPL	Stock	147.8095	148.07	147.76	147.895	2486754.0
2021-08-20 13:00:00	AAPL	Stock	147.91	148.0299	147.83	147.9177	1399314.0
2021-08-20 13:30:00	AAPL	Stock	147.912	147.995	147.55	147.7467	1878139.0
2021-08-20 14:00:00	AAPL	Stock	147.74	147.89	147.68	147.72	1532023.0
2021-08-20 14:30:00	AAPL	Stock	147.715	147.96	147.56	147.9599	2013890.0
2021-08-20 15:00:00	AAPL	Stock	147.9592	148.1659	147.8	148.0848	2160021.0
2021-08-20 15:30:00	AAPL	Stock	148.087	148.29	147.945	148.19	5458554.0
2021-08-20 16:00:00	AAPL	Stock	148.19	148.24	148.12	148.16	7401922.0
2021-08-20 16:30:00	AAPL	Stock	148.13	148.3	148.06	148.1501	108310.0
2021-08-20 17:00:00	AAPL	Stock	148.16	148.28	148.12	148.2	284988.0
2021-08-20 17:30:00	AAPL	Stock	148.16	148.22	148.16	148.19	5453.0
2021-08-20 18:00:00	AAPL	Stock	148.19	148.4	148.18	148.25	28426.0
2021-08-20 18:30:00	AAPL	Stock	148.25	148.29	148.17	148.2	4613.0
2021-08-20 19:00:00	AAPL	Stock	148.16	148.24	148.15	148.2	13292.0
2021-08-20 19:30:00	AAPL	Stock	148.21	148.31	148.2	148.31	23929.0
2021-08-20 04:00:00	MSFT	Stock	295.0	295.79	295.0	295.3	4717.0
2021-08-20 04:30:00	MSFT	Stock	295.7	295.76	295.44	295.76	700.0
2021-08-20 05:00:00	MSFT	Stock	295.45	296.02	295.45	296.0	2537.0
2021-08-20 05:30:00	MSFT	Stock	296.03	296.04	295.99	295.99	1698.0
2021-08-20 06:00:00	MSFT	Stock	295.9	296.18	295.9	296.02	1139.0
2021-08-20 06:30:00	MSFT	Stock	296.03	296.2	296.03	296.14	2943.0
2021-08-20 07:00:00	MSFT	Stock	296.12	296.3	295.82	296.3	14933.0
2021-08-20 07:30:00	MSFT	Stock	296.42	296.77	296.39	296.39	5844.0
2021-08-20 08:00:00	MSFT	Stock	296.0	297.5	295.82	297.2	24670.0
2021-08-20 08:30:00	MSFT	Stock	297.2	298.84	297.2	298.84	49575.0
2021-08-20 09:00:00	MSFT	Stock	298.74	300.04	298.41	299.85	194401.0
2021-08-20 09:30:00	MSFT	Stock	299.85	303.54	298.06	302.58	6156588.0
2021-08-20 10:00:00	MSFT	Stock	302.5969	305.66	302.32	304.77	4898706.0
2021-08-20 10:30:00	MSFT	Stock	304.76	305.84	304.01	304.125	3461979.0
2021-08-20 11:00:00	MSFT	Stock	304.12	304.3	303.42	303.53	2024688.0
2021-08-20 11:30:00	MSFT	Stock	303.54	304.1	303.15	303.74	1878371.0
2021-08-20 12:00:00	MSFT	Stock	303.72	304.7149	303.57	304.6899	1778821.0
2021-08-20 12:30:00	MSFT	Stock	304.67	305.0999	304.05	304.24	1254115.0

> showing 50 of 109,187 rows — these rows as CSV

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