PREVIEW / stock_30min / 2023-04-19

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-04-19.parquet
  size:    2.1 MB
  rows:    101,114
  symbols: 1,706

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-19 04:00:00	AAPL	Stock	165.98	165.98	165.09	165.51	28446.0
2023-04-19 04:30:00	AAPL	Stock	165.53	165.55	165.38	165.38	8017.0
2023-04-19 05:00:00	AAPL	Stock	165.4	165.49	165.01	165.46	13847.0
2023-04-19 05:30:00	AAPL	Stock	165.39	165.44	165.12	165.17	6695.0
2023-04-19 06:00:00	AAPL	Stock	165.24	165.39	165.24	165.36	3313.0
2023-04-19 06:30:00	AAPL	Stock	165.4	165.64	165.38	165.49	4392.0
2023-04-19 07:00:00	AAPL	Stock	165.55	165.7	165.46	165.46	18527.0
2023-04-19 07:30:00	AAPL	Stock	165.6	165.61	165.4	165.56	9750.0
2023-04-19 08:00:00	AAPL	Stock	165.5592	166.054	165.0	165.52	97754.0
2023-04-19 08:30:00	AAPL	Stock	165.44	165.45	165.06	165.34	62127.0
2023-04-19 09:00:00	AAPL	Stock	165.35	165.94	165.15	165.91	76533.0
2023-04-19 09:30:00	AAPL	Stock	165.82	166.54	165.54	166.16	5147670.0
2023-04-19 10:00:00	AAPL	Stock	166.15	166.65	166.11	166.64	2968686.0
2023-04-19 10:30:00	AAPL	Stock	166.6395	167.205	166.58	166.93	3316815.0
2023-04-19 11:00:00	AAPL	Stock	166.9301	167.38	166.9099	167.14	2480212.0
2023-04-19 11:30:00	AAPL	Stock	167.14	167.79	167.0028	167.59	2971267.0
2023-04-19 12:00:00	AAPL	Stock	167.61	167.89	167.41	167.815	2007830.0
2023-04-19 12:30:00	AAPL	Stock	167.82	168.16	167.8101	167.8401	2586914.0
2023-04-19 13:00:00	AAPL	Stock	167.845	168.09	167.63	167.92	1841718.0
2023-04-19 13:30:00	AAPL	Stock	167.93	168.01	167.675	167.81	1340038.0
2023-04-19 14:00:00	AAPL	Stock	167.81	168.05	167.59	167.9	1672041.0
2023-04-19 14:30:00	AAPL	Stock	167.9	168.08	167.71	167.925	1733164.0
2023-04-19 15:00:00	AAPL	Stock	167.925	167.94	167.67	167.77	1742612.0
2023-04-19 15:30:00	AAPL	Stock	167.76	167.86	167.17	167.62	4327511.0
2023-04-19 16:00:00	AAPL	Stock	167.61	167.65	167.19	167.42	5663816.0
2023-04-19 16:30:00	AAPL	Stock	167.4	167.63	167.4	167.48	40299.0
2023-04-19 17:00:00	AAPL	Stock	167.46	167.52	167.42	167.42	20787.0
2023-04-19 17:30:00	AAPL	Stock	167.3878	167.47	167.37	167.4	10564.0
2023-04-19 18:00:00	AAPL	Stock	167.4	167.48	167.38	167.4	3575.0
2023-04-19 18:30:00	AAPL	Stock	167.3202	167.4	167.32	167.3944	13676.0
2023-04-19 19:00:00	AAPL	Stock	167.35	167.39	167.19	167.36	19044.0
2023-04-19 19:30:00	AAPL	Stock	167.33	167.34	167.08	167.25	23272.0
2023-04-19 04:00:00	MSFT	Stock	287.51	287.51	286.69	286.99	3767.0
2023-04-19 04:30:00	MSFT	Stock	286.9	287.0	286.85	286.85	981.0
2023-04-19 05:00:00	MSFT	Stock	286.7	286.7	286.51	286.7	3071.0
2023-04-19 05:30:00	MSFT	Stock	286.55	286.55	285.85	285.85	926.0
2023-04-19 06:00:00	MSFT	Stock	286.0	286.4	286.0	286.25	2875.0
2023-04-19 06:30:00	MSFT	Stock	286.49	286.53	286.3	286.48	1083.0
2023-04-19 07:00:00	MSFT	Stock	286.35	286.73	286.31	286.69	3241.0
2023-04-19 07:30:00	MSFT	Stock	286.7	286.86	286.41	286.5	5721.0
2023-04-19 08:00:00	MSFT	Stock	287.65	288.28	285.86	286.66	23720.0
2023-04-19 08:30:00	MSFT	Stock	286.0	286.33	285.98	286.0006	7473.0
2023-04-19 09:00:00	MSFT	Stock	286.12	286.65	285.6	285.62	17108.0
2023-04-19 09:30:00	MSFT	Stock	285.99	286.98	284.54	285.25	2182400.0
2023-04-19 10:00:00	MSFT	Stock	285.24	286.05	285.15	285.7899	1042757.0
2023-04-19 10:30:00	MSFT	Stock	285.77	286.9799	285.59	286.88	754829.0
2023-04-19 11:00:00	MSFT	Stock	286.9	287.59	286.9	287.485	804129.0
2023-04-19 11:30:00	MSFT	Stock	287.456	288.01	287.16	287.915	766963.0
2023-04-19 12:00:00	MSFT	Stock	287.94	288.81	287.87	288.55	925159.0
2023-04-19 12:30:00	MSFT	Stock	288.56	289.05	288.3801	288.47	642365.0

> showing 50 of 101,114 rows — these rows as CSV

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