PREVIEW / stock_30min / 2023-04-05

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-04-05.parquet
  size:    2.0 MB
  rows:    98,478
  symbols: 1,703

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-05 04:00:00	AAPL	Stock	165.68	165.68	165.29	165.32	10574.0
2023-04-05 04:30:00	AAPL	Stock	165.31	165.35	165.1	165.34	2443.0
2023-04-05 05:00:00	AAPL	Stock	165.29	165.35	165.23	165.24	8212.0
2023-04-05 05:30:00	AAPL	Stock	165.24	165.33	165.17	165.2	8621.0
2023-04-05 06:00:00	AAPL	Stock	165.25	165.37	165.24	165.35	7573.0
2023-04-05 06:30:00	AAPL	Stock	165.38	165.39	165.22	165.38	8331.0
2023-04-05 07:00:00	AAPL	Stock	165.32	165.79	165.3	165.65	32681.0
2023-04-05 07:30:00	AAPL	Stock	165.69	165.77	165.52	165.6	26965.0
2023-04-05 08:00:00	AAPL	Stock	165.46	165.8	165.06	165.43	94341.0
2023-04-05 08:30:00	AAPL	Stock	165.465	165.5	165.12	165.18	81370.0
2023-04-05 09:00:00	AAPL	Stock	165.18	165.2999	164.52	164.75	191976.0
2023-04-05 09:30:00	AAPL	Stock	164.74	165.05	164.21	164.6201	5528698.0
2023-04-05 10:00:00	AAPL	Stock	164.65	164.92	163.98	164.1201	3618597.0
2023-04-05 10:30:00	AAPL	Stock	164.12	164.1801	163.2699	163.29	2947846.0
2023-04-05 11:00:00	AAPL	Stock	163.28	163.77	163.2001	163.28	2488584.0
2023-04-05 11:30:00	AAPL	Stock	163.28	163.52	162.68	162.9601	2735747.0
2023-04-05 12:00:00	AAPL	Stock	162.98	163.0	162.11	162.23	3040930.0
2023-04-05 12:30:00	AAPL	Stock	162.2	162.49	161.8	162.33	2775962.0
2023-04-05 13:00:00	AAPL	Stock	162.33	162.97	162.26	162.87	2389361.0
2023-04-05 13:30:00	AAPL	Stock	162.87	163.095	162.65	162.945	1922244.0
2023-04-05 14:00:00	AAPL	Stock	162.95	163.1192	162.65	162.6976	1775069.0
2023-04-05 14:30:00	AAPL	Stock	162.69	163.305	162.67	163.2388	1855939.0
2023-04-05 15:00:00	AAPL	Stock	163.24	163.4	162.93	163.255	2274585.0
2023-04-05 15:30:00	AAPL	Stock	163.26	163.95	163.21	163.76	5114478.0
2023-04-05 16:00:00	AAPL	Stock	163.76	163.86	163.2983	163.74	5626954.0
2023-04-05 16:30:00	AAPL	Stock	163.74	163.76	163.61	163.65	57792.0
2023-04-05 17:00:00	AAPL	Stock	163.63	163.76	163.49	163.49	34322.0
2023-04-05 17:30:00	AAPL	Stock	163.49	163.6	163.32	163.6	27314.0
2023-04-05 18:00:00	AAPL	Stock	163.5	163.5899	163.35	163.5899	6574.0
2023-04-05 18:30:00	AAPL	Stock	163.43	163.58	163.42	163.47	14244.0
2023-04-05 19:00:00	AAPL	Stock	163.46	163.55	163.03	163.45	15995.0
2023-04-05 19:30:00	AAPL	Stock	163.45	163.61	163.42	163.55	10939.0
2023-04-05 04:00:00	MSFT	Stock	287.55	287.87	286.82	287.11	3610.0
2023-04-05 04:30:00	MSFT	Stock	286.77	286.82	286.65	286.65	400.0
2023-04-05 05:00:00	MSFT	Stock	286.5	286.99	286.49	286.99	1376.0
2023-04-05 05:30:00	MSFT	Stock	286.61	286.89	286.61	286.88	400.0
2023-04-05 06:00:00	MSFT	Stock	286.98	286.99	286.72	286.85	2945.0
2023-04-05 06:30:00	MSFT	Stock	286.99	287.18	286.9	287.18	875.0
2023-04-05 07:00:00	MSFT	Stock	287.16	287.2	286.4	286.6	10061.0
2023-04-05 07:30:00	MSFT	Stock	286.72	287.0	286.62	286.85	5268.0
2023-04-05 08:00:00	MSFT	Stock	286.36	287.35	286.22	287.0	19100.0
2023-04-05 08:30:00	MSFT	Stock	286.95	286.95	286.2	286.54	10920.0
2023-04-05 09:00:00	MSFT	Stock	286.68	286.76	285.3	285.99	39708.0
2023-04-05 09:30:00	MSFT	Stock	285.85	287.15	284.82	285.7	2442245.0
2023-04-05 10:00:00	MSFT	Stock	285.7	286.3	284.742	284.765	1267416.0
2023-04-05 10:30:00	MSFT	Stock	284.74	285.295	283.31	283.58	1404317.0
2023-04-05 11:00:00	MSFT	Stock	283.55	284.23	283.33	283.71	1242181.0
2023-04-05 11:30:00	MSFT	Stock	283.705	284.33	283.51	284.18	946426.0
2023-04-05 12:00:00	MSFT	Stock	284.18	284.28	282.98	283.1785	974105.0
2023-04-05 12:30:00	MSFT	Stock	283.19	283.67	282.95	283.47	641809.0

> showing 50 of 98,478 rows — these rows as CSV

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