PREVIEW / stock_30min / 2023-06-05

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-06-05.parquet
  size:    2.1 MB
  rows:    103,147
  symbols: 1,620

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-05 04:00:00	AAPL	Stock	181.22	182.0	181.11	181.65	27872.0
2023-06-05 04:30:00	AAPL	Stock	181.6	181.88	181.6	181.68	41129.0
2023-06-05 05:00:00	AAPL	Stock	181.67	181.93	181.61	181.92	31805.0
2023-06-05 05:30:00	AAPL	Stock	181.87	182.1	181.81	182.09	19945.0
2023-06-05 06:00:00	AAPL	Stock	182.14	182.15	181.98	182.15	7764.0
2023-06-05 06:30:00	AAPL	Stock	182.2	182.88	182.2	182.77	32080.0
2023-06-05 07:00:00	AAPL	Stock	182.65	182.8	182.4	182.64	103050.0
2023-06-05 07:30:00	AAPL	Stock	182.7	182.7	182.25	182.6	42261.0
2023-06-05 08:00:00	AAPL	Stock	182.61	182.85	181.0	182.54	285726.0
2023-06-05 08:30:00	AAPL	Stock	182.53	182.8681	182.44	182.61	162876.0
2023-06-05 09:00:00	AAPL	Stock	182.62	182.93	182.37	182.68	330818.0
2023-06-05 09:30:00	AAPL	Stock	182.63	183.86	181.97	183.38	11513995.0
2023-06-05 10:00:00	AAPL	Stock	183.4	183.99	183.25	183.71	6123479.0
2023-06-05 10:30:00	AAPL	Stock	183.72	184.36	183.63	184.26	6290094.0
2023-06-05 11:00:00	AAPL	Stock	184.26	184.3	183.93	184.23	3644089.0
2023-06-05 11:30:00	AAPL	Stock	184.225	184.35	184.07	184.0871	2883455.0
2023-06-05 12:00:00	AAPL	Stock	184.085	184.72	183.99	184.5504	5048665.0
2023-06-05 12:30:00	AAPL	Stock	184.56	184.72	184.17	184.565	3410685.0
2023-06-05 13:00:00	AAPL	Stock	184.57	184.951	183.91	184.1115	5834467.0
2023-06-05 13:30:00	AAPL	Stock	184.115	184.315	182.03	182.78	7287480.0
2023-06-05 14:00:00	AAPL	Stock	182.8085	183.69	182.27	183.0683	8899996.0
2023-06-05 14:30:00	AAPL	Stock	183.07	183.16	180.08	181.67	13924912.0
2023-06-05 15:00:00	AAPL	Stock	181.6899	181.78	178.035	179.525	13960866.0
2023-06-05 15:30:00	AAPL	Stock	179.53	179.79	178.77	179.6	8741073.0
2023-06-05 16:00:00	AAPL	Stock	179.61	179.7	179.35	179.38	4714530.0
2023-06-05 16:30:00	AAPL	Stock	179.38	179.58	179.37	179.53	82024.0
2023-06-05 17:00:00	AAPL	Stock	179.52	179.68	179.43	179.67	52519.0
2023-06-05 17:30:00	AAPL	Stock	179.68	180.1	179.65	180.01	102102.0
2023-06-05 18:00:00	AAPL	Stock	180.0	180.0	179.6	179.69	42642.0
2023-06-05 18:30:00	AAPL	Stock	179.73	179.73	179.0	179.13	87380.0
2023-06-05 19:00:00	AAPL	Stock	179.07	179.18	179.01	179.15	43610.0
2023-06-05 19:30:00	AAPL	Stock	179.15	179.24	179.0	179.12	83584.0
2023-06-05 04:00:00	MSFT	Stock	334.96	334.96	333.4	334.0	1889.0
2023-06-05 04:30:00	MSFT	Stock	333.98	334.3	333.98	334.2	2024.0
2023-06-05 05:00:00	MSFT	Stock	333.81	333.92	333.8	333.8	1027.0
2023-06-05 05:30:00	MSFT	Stock	334.1	334.1	333.1	333.1	1241.0
2023-06-05 06:00:00	MSFT	Stock	333.02	333.14	333.02	333.13	1174.0
2023-06-05 06:30:00	MSFT	Stock	333.65	333.98	333.65	333.98	1000.0
2023-06-05 07:00:00	MSFT	Stock	334.01	334.39	333.8	333.8	6684.0
2023-06-05 07:30:00	MSFT	Stock	333.78	333.81	333.57	333.65	2885.0
2023-06-05 08:00:00	MSFT	Stock	333.9	334.2499	333.25	333.78	26829.0
2023-06-05 08:30:00	MSFT	Stock	333.84	334.07	333.7	333.9799	7291.0
2023-06-05 09:00:00	MSFT	Stock	334.0	335.38	333.53	335.09	28800.0
2023-06-05 09:30:00	MSFT	Stock	335.22	337.37	334.6601	335.26	2007145.0
2023-06-05 10:00:00	MSFT	Stock	335.31	336.48	335.31	336.39	1045180.0
2023-06-05 10:30:00	MSFT	Stock	336.41	337.79	335.62	337.36	1184791.0
2023-06-05 11:00:00	MSFT	Stock	337.365	337.7	336.7401	337.58	671424.0
2023-06-05 11:30:00	MSFT	Stock	337.5631	338.5599	337.41	337.99	969273.0
2023-06-05 12:00:00	MSFT	Stock	337.99	338.34	337.44	337.8931	614785.0
2023-06-05 12:30:00	MSFT	Stock	337.8893	338.3897	337.62	338.3175	466628.0

> showing 50 of 103,147 rows — these rows as CSV

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