PREVIEW / stock_30min / 2021-09-28

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-09-28.parquet
  size:    2.2 MB
  rows:    111,673
  symbols: 2,683

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-09-28 04:00:00	AAPL	Stock	143.64	144.0	142.95	143.26	44662.0
2021-09-28 04:30:00	AAPL	Stock	143.42	143.66	143.35	143.35	15107.0
2021-09-28 05:00:00	AAPL	Stock	143.35	143.55	143.21	143.55	13099.0
2021-09-28 05:30:00	AAPL	Stock	143.42	143.42	142.8	142.89	28694.0
2021-09-28 06:00:00	AAPL	Stock	142.85	143.02	142.75	142.88	13468.0
2021-09-28 06:30:00	AAPL	Stock	143.04	143.05	142.75	142.95	9324.0
2021-09-28 07:00:00	AAPL	Stock	142.98	143.24	142.77	142.92	152985.0
2021-09-28 07:30:00	AAPL	Stock	142.91	143.2	142.72	143.17	150930.0
2021-09-28 08:00:00	AAPL	Stock	142.8901	145.733	142.75	143.0	542177.0
2021-09-28 08:30:00	AAPL	Stock	143.0	143.16	142.85	143.0	296795.0
2021-09-28 09:00:00	AAPL	Stock	142.99	143.49	142.0	143.26	577205.0
2021-09-28 09:30:00	AAPL	Stock	143.27	144.75	142.94	144.6001	13135024.0
2021-09-28 10:00:00	AAPL	Stock	144.6	144.6	143.14	143.71	7842537.0
2021-09-28 10:30:00	AAPL	Stock	143.7	143.75	142.77	142.87	6276381.0
2021-09-28 11:00:00	AAPL	Stock	142.87	143.08	142.4218	142.7135	5714885.0
2021-09-28 11:30:00	AAPL	Stock	142.72	143.09	142.42	142.75	5227013.0
2021-09-28 12:00:00	AAPL	Stock	142.74	142.94	142.38	142.7612	4509238.0
2021-09-28 12:30:00	AAPL	Stock	142.76	142.76	141.91	141.9901	5154953.0
2021-09-28 13:00:00	AAPL	Stock	141.99	142.4	141.81	142.3299	5233384.0
2021-09-28 13:30:00	AAPL	Stock	142.327	142.47	141.9	141.94	3579873.0
2021-09-28 14:00:00	AAPL	Stock	141.95	142.57	141.69	142.5475	4503873.0
2021-09-28 14:30:00	AAPL	Stock	142.54	142.77	142.12	142.655	4573208.0
2021-09-28 15:00:00	AAPL	Stock	142.65	142.88	142.34	142.345	4678641.0
2021-09-28 15:30:00	AAPL	Stock	142.35	142.665	141.76	141.92	11309161.0
2021-09-28 16:00:00	AAPL	Stock	141.9	142.41	141.75	141.95	14110646.0
2021-09-28 16:30:00	AAPL	Stock	141.9	142.06	141.77	142.0299	100535.0
2021-09-28 17:00:00	AAPL	Stock	142.01	142.05	141.9	141.92	39828.0
2021-09-28 17:30:00	AAPL	Stock	141.92	142.0	141.9	141.96	23347.0
2021-09-28 18:00:00	AAPL	Stock	141.96	142.24	141.95	142.06	41072.0
2021-09-28 18:30:00	AAPL	Stock	142.04	142.21	142.0	142.08	29990.0
2021-09-28 19:00:00	AAPL	Stock	142.06	142.2	142.03	142.07	13933.0
2021-09-28 19:30:00	AAPL	Stock	142.065	142.4	141.97	142.4	45231.0
2021-09-28 04:00:00	MSFT	Stock	291.21	291.47	289.78	290.11	6601.0
2021-09-28 04:30:00	MSFT	Stock	290.16	290.74	290.16	290.74	947.0
2021-09-28 05:00:00	MSFT	Stock	290.51	290.51	290.0	290.43	9314.0
2021-09-28 05:30:00	MSFT	Stock	290.64	290.64	289.5	289.5	3098.0
2021-09-28 06:00:00	MSFT	Stock	289.61	290.5	289.0	289.21	4596.0
2021-09-28 06:30:00	MSFT	Stock	289.35	289.4	288.74	288.74	2247.0
2021-09-28 07:00:00	MSFT	Stock	289.97	290.48	288.51	289.32	32782.0
2021-09-28 07:30:00	MSFT	Stock	289.44	289.97	288.76	289.6	12109.0
2021-09-28 08:00:00	MSFT	Stock	289.5243	289.9	288.5	289.25	56558.0
2021-09-28 08:30:00	MSFT	Stock	289.25	289.45	288.8	289.4	41399.0
2021-09-28 09:00:00	MSFT	Stock	289.4	290.65	289.3209	289.87	47955.0
2021-09-28 09:30:00	MSFT	Stock	289.87	290.78	287.54	288.91	3470701.0
2021-09-28 10:00:00	MSFT	Stock	288.9	288.9	286.11	286.8499	2375678.0
2021-09-28 10:30:00	MSFT	Stock	286.83	286.83	285.21	285.61	2081046.0
2021-09-28 11:00:00	MSFT	Stock	285.61	285.8499	284.36	284.82	2172676.0
2021-09-28 11:30:00	MSFT	Stock	284.82	285.84	284.51	285.69	1627576.0
2021-09-28 12:00:00	MSFT	Stock	285.7	286.44	284.97	286.12	1659776.0
2021-09-28 12:30:00	MSFT	Stock	286.14	286.14	284.8	285.04	997772.0

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

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