PREVIEW / stock_30min / 2023-04-13

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-04-13.parquet
  size:    2.0 MB
  rows:    99,839
  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-13 04:00:00	AAPL	Stock	160.05	160.82	160.05	160.59	14390.0
2023-04-13 04:30:00	AAPL	Stock	160.6	160.66	160.5	160.5	1329.0
2023-04-13 05:00:00	AAPL	Stock	160.55	161.27	160.55	160.66	13045.0
2023-04-13 05:30:00	AAPL	Stock	160.79	160.86	160.79	160.86	1536.0
2023-04-13 06:00:00	AAPL	Stock	160.89	160.98	160.53	160.71	6337.0
2023-04-13 06:30:00	AAPL	Stock	160.71	161.0	160.71	160.8	4564.0
2023-04-13 07:00:00	AAPL	Stock	160.67	160.98	160.67	160.9	16692.0
2023-04-13 07:30:00	AAPL	Stock	160.95	160.95	160.45	160.5	16409.0
2023-04-13 08:00:00	AAPL	Stock	160.9087	160.98	159.7	160.8502	64414.0
2023-04-13 08:30:00	AAPL	Stock	160.85	161.5	160.8	161.45	153141.0
2023-04-13 09:00:00	AAPL	Stock	161.3644	161.68	160.99	161.59	175167.0
2023-04-13 09:30:00	AAPL	Stock	161.63	163.24	161.42	162.8847	8595241.0
2023-04-13 10:00:00	AAPL	Stock	162.89	163.58	162.71	163.4378	4004042.0
2023-04-13 10:30:00	AAPL	Stock	163.44	163.68	163.11	163.175	2891659.0
2023-04-13 11:00:00	AAPL	Stock	163.18	163.56	163.14	163.43	2044967.0
2023-04-13 11:30:00	AAPL	Stock	163.43	163.79	163.31	163.7711	2351248.0
2023-04-13 12:00:00	AAPL	Stock	163.78	163.99	163.55	163.9499	2034103.0
2023-04-13 12:30:00	AAPL	Stock	163.9449	164.19	163.905	164.1185	2491517.0
2023-04-13 13:00:00	AAPL	Stock	164.11	164.43	163.89	164.425	3047241.0
2023-04-13 13:30:00	AAPL	Stock	164.43	164.93	164.43	164.8825	2927182.0
2023-04-13 14:00:00	AAPL	Stock	164.89	165.38	164.8	165.19	3936238.0
2023-04-13 14:30:00	AAPL	Stock	165.19	165.25	164.95	165.18	2416608.0
2023-04-13 15:00:00	AAPL	Stock	165.19	165.58	165.11	165.47	3314485.0
2023-04-13 15:30:00	AAPL	Stock	165.47	165.8	165.2201	165.59	8277721.0
2023-04-13 16:00:00	AAPL	Stock	165.6	165.6	165.05	165.22	10543926.0
2023-04-13 16:30:00	AAPL	Stock	165.21	165.56	165.07	165.07	111991.0
2023-04-13 17:00:00	AAPL	Stock	165.07	165.35	165.07	165.18	21151.0
2023-04-13 17:30:00	AAPL	Stock	165.18	165.25	165.1406	165.19	8584.0
2023-04-13 18:00:00	AAPL	Stock	165.19	165.24	165.11	165.22	28835.0
2023-04-13 18:30:00	AAPL	Stock	165.18	165.3	165.13	165.2	12430.0
2023-04-13 19:00:00	AAPL	Stock	165.19	165.28	165.15	165.22	16015.0
2023-04-13 19:30:00	AAPL	Stock	165.22	165.3499	165.15	165.34	19248.0
2023-04-13 04:00:00	MSFT	Stock	283.99	284.7	283.49	283.87	2211.0
2023-04-13 04:30:00	MSFT	Stock	283.5	283.99	283.5	283.62	1873.0
2023-04-13 05:00:00	MSFT	Stock	283.8	284.98	283.8	284.98	2454.0
2023-04-13 05:30:00	MSFT	Stock	284.3	284.49	284.29	284.49	800.0
2023-04-13 06:00:00	MSFT	Stock	284.43	284.43	283.87	283.9	870.0
2023-04-13 06:30:00	MSFT	Stock	284.04	284.04	283.66	283.66	466.0
2023-04-13 07:00:00	MSFT	Stock	283.67	283.92	283.63	283.8	2767.0
2023-04-13 07:30:00	MSFT	Stock	283.95	283.96	283.15	283.15	9331.0
2023-04-13 08:00:00	MSFT	Stock	283.804	284.0	282.6904	283.16	18100.0
2023-04-13 08:30:00	MSFT	Stock	283.0	284.23	282.9119	283.5058	42459.0
2023-04-13 09:00:00	MSFT	Stock	283.66	283.9581	282.58	283.34	40509.0
2023-04-13 09:30:00	MSFT	Stock	283.59	286.2	283.17	285.7756	2288086.0
2023-04-13 10:00:00	MSFT	Stock	285.79	287.91	285.7301	287.725	1775864.0
2023-04-13 10:30:00	MSFT	Stock	287.75	288.04	287.07	287.6	1185761.0
2023-04-13 11:00:00	MSFT	Stock	287.615	288.19	287.59	287.88	976606.0
2023-04-13 11:30:00	MSFT	Stock	287.88	287.89	287.09	287.51	621252.0
2023-04-13 12:00:00	MSFT	Stock	287.5	287.79	287.35	287.72	509118.0
2023-04-13 12:30:00	MSFT	Stock	287.71	288.02	287.5301	287.8915	487530.0

> showing 50 of 99,839 rows — these rows as CSV

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