PREVIEW / stock_30min / 2023-06-28

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-06-28.parquet
  size:    2.0 MB
  rows:    100,112
  symbols: 1,567

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-06-28 04:00:00	AAPL	Stock	187.98	188.3	187.86	188.13	9036.0
2023-06-28 04:30:00	AAPL	Stock	188.14	188.14	187.88	187.91	3544.0
2023-06-28 05:00:00	AAPL	Stock	187.9	187.95	187.8	187.84	4524.0
2023-06-28 05:30:00	AAPL	Stock	187.82	187.83	187.72	187.8	9849.0
2023-06-28 06:00:00	AAPL	Stock	187.8	187.8	187.75	187.8	9889.0
2023-06-28 06:30:00	AAPL	Stock	187.79	187.79	187.7	187.78	6605.0
2023-06-28 07:00:00	AAPL	Stock	187.9	187.93	187.75	187.75	14805.0
2023-06-28 07:30:00	AAPL	Stock	187.75	187.8	187.6	187.6	29714.0
2023-06-28 08:00:00	AAPL	Stock	187.9	188.14	187.6	187.98	85491.0
2023-06-28 08:30:00	AAPL	Stock	187.99	188.01	187.66	187.81	60951.0
2023-06-28 09:00:00	AAPL	Stock	187.85	188.04	187.75	188.01	82650.0
2023-06-28 09:30:00	AAPL	Stock	187.97	188.63	187.6	188.16	5571684.0
2023-06-28 10:00:00	AAPL	Stock	188.165	188.58	187.8	188.42	3049869.0
2023-06-28 10:30:00	AAPL	Stock	188.42	189.34	188.265	189.1378	3439816.0
2023-06-28 11:00:00	AAPL	Stock	189.14	189.4297	188.945	189.015	2677761.0
2023-06-28 11:30:00	AAPL	Stock	189.02	189.56	188.96	189.3824	1932639.0
2023-06-28 12:00:00	AAPL	Stock	189.38	189.9	189.2412	189.295	2181855.0
2023-06-28 12:30:00	AAPL	Stock	189.3	189.3	188.285	188.525	2637681.0
2023-06-28 13:00:00	AAPL	Stock	188.52	189.08	188.34	189.07	1814065.0
2023-06-28 13:30:00	AAPL	Stock	189.08	189.2299	188.81	188.95	1533459.0
2023-06-28 14:00:00	AAPL	Stock	188.955	189.53	188.9	189.365	1513981.0
2023-06-28 14:30:00	AAPL	Stock	189.37	189.45	188.9	188.96	1718158.0
2023-06-28 15:00:00	AAPL	Stock	188.97	189.1579	188.365	189.02	2146860.0
2023-06-28 15:30:00	AAPL	Stock	189.01	189.29	188.62	189.28	4983286.0
2023-06-28 16:00:00	AAPL	Stock	189.29	189.65	189.01	189.41	5735006.0
2023-06-28 16:30:00	AAPL	Stock	189.44	189.47	189.16	189.26	84698.0
2023-06-28 17:00:00	AAPL	Stock	189.22	189.2594	189.13	189.17	12722.0
2023-06-28 17:30:00	AAPL	Stock	189.17	189.29	189.14	189.2	13585.0
2023-06-28 18:00:00	AAPL	Stock	189.18	189.55	189.18	189.51	8532.0
2023-06-28 18:30:00	AAPL	Stock	189.55	189.75	189.53	189.71	21757.0
2023-06-28 19:00:00	AAPL	Stock	189.73	189.74	189.5	189.7	9412.0
2023-06-28 19:30:00	AAPL	Stock	189.61	189.71	189.55	189.6594	19945.0
2023-06-28 04:00:00	MSFT	Stock	334.57	335.5	334.29	335.2	6416.0
2023-06-28 04:30:00	MSFT	Stock	335.02	335.46	334.62	335.19	1448.0
2023-06-28 05:00:00	MSFT	Stock	335.06	335.24	335.0	335.0	1586.0
2023-06-28 05:30:00	MSFT	Stock	335.08	335.08	334.5	334.65	4626.0
2023-06-28 06:00:00	MSFT	Stock	335.28	335.49	335.23	335.49	1307.0
2023-06-28 06:30:00	MSFT	Stock	335.43	335.7	335.43	335.7	1015.0
2023-06-28 07:00:00	MSFT	Stock	335.37	336.89	335.37	336.46	14144.0
2023-06-28 07:30:00	MSFT	Stock	336.02	336.26	335.26	335.26	7269.0
2023-06-28 08:00:00	MSFT	Stock	335.65	336.88	334.0	335.07	29920.0
2023-06-28 08:30:00	MSFT	Stock	335.32	335.59	334.66	335.22	14276.0
2023-06-28 09:00:00	MSFT	Stock	335.17	335.33	333.9	334.7	17734.0
2023-06-28 09:30:00	MSFT	Stock	334.66	336.81	334.08	335.52	1699315.0
2023-06-28 10:00:00	MSFT	Stock	335.5	336.69	333.935	336.59	1043320.0
2023-06-28 10:30:00	MSFT	Stock	336.55	337.98	336.405	337.27	1026958.0
2023-06-28 11:00:00	MSFT	Stock	337.28	337.87	335.23	335.91	706608.0
2023-06-28 11:30:00	MSFT	Stock	335.919	337.16	335.8	337.1399	554800.0
2023-06-28 12:00:00	MSFT	Stock	337.11	337.94	336.31	336.48	605234.0
2023-06-28 12:30:00	MSFT	Stock	336.48	336.48	334.57	335.0484	753004.0

> showing 50 of 100,112 rows — these rows as CSV

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