PREVIEW / stock_30min / 2023-04-17

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-04-17.parquet
  size:    2.1 MB
  rows:    102,179
  symbols: 1,700

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
2023-04-17 04:00:00	AAPL	Stock	165.25	165.62	165.25	165.41	22876.0
2023-04-17 04:30:00	AAPL	Stock	165.3	165.4	165.25	165.39	2645.0
2023-04-17 05:00:00	AAPL	Stock	165.39	165.39	165.13	165.14	2603.0
2023-04-17 05:30:00	AAPL	Stock	165.14	165.19	164.95	164.95	5827.0
2023-04-17 06:00:00	AAPL	Stock	165.01	165.35	165.0	165.3	8441.0
2023-04-17 06:30:00	AAPL	Stock	165.37	165.65	165.37	165.65	14654.0
2023-04-17 07:00:00	AAPL	Stock	165.52	165.99	165.5	165.5	29420.0
2023-04-17 07:30:00	AAPL	Stock	165.53	165.79	165.2	165.79	20533.0
2023-04-17 08:00:00	AAPL	Stock	165.65	166.15	164.48	165.94	132971.0
2023-04-17 08:30:00	AAPL	Stock	165.94	166.19	165.63	166.05	184021.0
2023-04-17 09:00:00	AAPL	Stock	166.05	166.2	164.91	165.09	505876.0
2023-04-17 09:30:00	AAPL	Stock	165.09	165.39	164.03	164.675	6460785.0
2023-04-17 10:00:00	AAPL	Stock	164.69	165.06	164.29	164.51	2896960.0
2023-04-17 10:30:00	AAPL	Stock	164.515	164.63	164.0745	164.5659	2369507.0
2023-04-17 11:00:00	AAPL	Stock	164.57	164.95	164.37	164.59	1885182.0
2023-04-17 11:30:00	AAPL	Stock	164.57	164.61	164.27	164.47	1890265.0
2023-04-17 12:00:00	AAPL	Stock	164.4653	164.55	164.05	164.2401	1564457.0
2023-04-17 12:30:00	AAPL	Stock	164.25	164.54	164.145	164.515	1182948.0
2023-04-17 13:00:00	AAPL	Stock	164.52	164.75	164.362	164.6298	1351189.0
2023-04-17 13:30:00	AAPL	Stock	164.6212	164.76	164.365	164.38	995903.0
2023-04-17 14:00:00	AAPL	Stock	164.385	164.475	164.245	164.4	1101407.0
2023-04-17 14:30:00	AAPL	Stock	164.39	164.71	164.2401	164.66	1666834.0
2023-04-17 15:00:00	AAPL	Stock	164.66	165.2	164.66	165.1848	2202136.0
2023-04-17 15:30:00	AAPL	Stock	165.18	165.34	165.1	165.27	3884452.0
2023-04-17 16:00:00	AAPL	Stock	165.28	165.28	165.1	165.18	5029267.0
2023-04-17 16:30:00	AAPL	Stock	165.16	165.23	165.07	165.1	15012.0
2023-04-17 17:00:00	AAPL	Stock	165.1	165.11	165.04	165.0924	24551.0
2023-04-17 17:30:00	AAPL	Stock	165.0892	165.23	165.08	165.12	25264.0
2023-04-17 18:00:00	AAPL	Stock	165.1	165.13	165.07	165.11	8235.0
2023-04-17 18:30:00	AAPL	Stock	165.11	165.14	165.0836	165.09	4417.0
2023-04-17 19:00:00	AAPL	Stock	165.12	165.15	165.09	165.15	3483.0
2023-04-17 19:30:00	AAPL	Stock	165.19	165.22	165.09	165.22	8848.0
2023-04-17 04:00:00	MSFT	Stock	287.89	290.0	287.0	287.85	5967.0
2023-04-17 04:30:00	MSFT	Stock	287.68	288.05	287.4	288.05	3489.0
2023-04-17 05:00:00	MSFT	Stock	288.37	288.56	287.55	288.4	6654.0
2023-04-17 05:30:00	MSFT	Stock	288.32	288.32	287.85	287.85	791.0
2023-04-17 06:00:00	MSFT	Stock	288.02	290.0	288.02	290.0	6469.0
2023-04-17 06:30:00	MSFT	Stock	290.0	291.0	289.9	290.46	16174.0
2023-04-17 07:00:00	MSFT	Stock	290.5	291.25	290.1	290.5	28873.0
2023-04-17 07:30:00	MSFT	Stock	290.5	291.65	290.5	291.5	56449.0
2023-04-17 08:00:00	MSFT	Stock	291.3523	292.45	285.425	291.3	166549.0
2023-04-17 08:30:00	MSFT	Stock	291.2	291.73	290.5	290.5	63950.0
2023-04-17 09:00:00	MSFT	Stock	290.63	291.0	289.5	289.88	96929.0
2023-04-17 09:30:00	MSFT	Stock	289.93	291.6	287.96	288.6395	3294434.0
2023-04-17 10:00:00	MSFT	Stock	288.64	289.33	287.51	287.7	1309817.0
2023-04-17 10:30:00	MSFT	Stock	287.71	288.02	287.105	287.465	1106922.0
2023-04-17 11:00:00	MSFT	Stock	287.47	288.43	287.36	287.61	939598.0
2023-04-17 11:30:00	MSFT	Stock	287.6	287.6	286.75	287.07	841589.0
2023-04-17 12:00:00	MSFT	Stock	287.08	287.15	286.16	286.795	831463.0
2023-04-17 12:30:00	MSFT	Stock	286.79	287.2	286.68	287.06	643743.0

> showing 50 of 102,179 rows — these rows as CSV

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