PREVIEW / stock_30min / 2023-01-13

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-01-13.parquet
  size:    2.1 MB
  rows:    103,821
  symbols: 1,924

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-01-13 04:00:00	AAPL	Stock	133.43	133.6	133.15	133.15	15213.0
2023-01-13 04:30:00	AAPL	Stock	133.06	133.37	133.06	133.37	5657.0
2023-01-13 05:00:00	AAPL	Stock	133.3	133.34	133.26	133.26	2846.0
2023-01-13 05:30:00	AAPL	Stock	133.24	133.26	133.14	133.16	1605.0
2023-01-13 06:00:00	AAPL	Stock	133.06	133.12	133.0	133.0	4447.0
2023-01-13 06:30:00	AAPL	Stock	132.9	132.9	132.6	132.78	11179.0
2023-01-13 07:00:00	AAPL	Stock	132.89	132.89	132.4	132.4	25300.0
2023-01-13 07:30:00	AAPL	Stock	132.44	132.52	132.13	132.15	26030.0
2023-01-13 08:00:00	AAPL	Stock	132.8	133.41	132.05	132.2	284153.0
2023-01-13 08:30:00	AAPL	Stock	132.23	132.3	131.82	132.02	175891.0
2023-01-13 09:00:00	AAPL	Stock	132.02	132.15	131.84	131.95	152641.0
2023-01-13 09:30:00	AAPL	Stock	131.95	132.9328	131.66	132.565	6896162.0
2023-01-13 10:00:00	AAPL	Stock	132.54	133.55	132.4	133.51	4963325.0
2023-01-13 10:30:00	AAPL	Stock	133.51	133.97	133.24	133.75	3872914.0
2023-01-13 11:00:00	AAPL	Stock	133.75	133.96	132.97	133.04	3616360.0
2023-01-13 11:30:00	AAPL	Stock	133.04	133.25	132.755	133.2131	2481523.0
2023-01-13 12:00:00	AAPL	Stock	133.21	133.6	133.1301	133.5101	1826567.0
2023-01-13 12:30:00	AAPL	Stock	133.52	133.6	133.16	133.539	1958938.0
2023-01-13 13:00:00	AAPL	Stock	133.54	133.71	133.3	133.645	1888077.0
2023-01-13 13:30:00	AAPL	Stock	133.66	134.38	133.63	134.1365	3007657.0
2023-01-13 14:00:00	AAPL	Stock	134.14	134.28	133.89	134.2457	2433888.0
2023-01-13 14:30:00	AAPL	Stock	134.25	134.42	134.04	134.1309	2262735.0
2023-01-13 15:00:00	AAPL	Stock	134.14	134.61	134.07	134.605	2705787.0
2023-01-13 15:30:00	AAPL	Stock	134.605	134.92	134.46	134.7	5865375.0
2023-01-13 16:00:00	AAPL	Stock	134.7	134.78	134.42	134.55	6391535.0
2023-01-13 16:30:00	AAPL	Stock	134.55	134.76	134.51	134.52	77461.0
2023-01-13 17:00:00	AAPL	Stock	134.59	134.63	134.52	134.52	14957.0
2023-01-13 17:30:00	AAPL	Stock	134.5426	134.6	134.53	134.59	4986.0
2023-01-13 18:00:00	AAPL	Stock	134.58	134.59	134.55	134.55	3631.0
2023-01-13 18:30:00	AAPL	Stock	134.56	134.59	134.52	134.56	6032.0
2023-01-13 19:00:00	AAPL	Stock	134.53	134.58	134.53	134.57	13098.0
2023-01-13 19:30:00	AAPL	Stock	134.58	134.6	134.5	134.55	18247.0
2023-01-13 04:00:00	MSFT	Stock	238.65	238.65	237.98	237.98	4579.0
2023-01-13 04:30:00	MSFT	Stock	238.26	238.44	238.2	238.44	600.0
2023-01-13 05:00:00	MSFT	Stock	238.89	238.89	238.78	238.78	599.0
2023-01-13 05:30:00	MSFT	Stock	238.86	239.0	238.76	238.76	1300.0
2023-01-13 06:00:00	MSFT	Stock	238.74	238.76	238.49	238.49	2802.0
2023-01-13 06:30:00	MSFT	Stock	238.38	238.44	237.8	237.82	7149.0
2023-01-13 07:00:00	MSFT	Stock	237.95	238.1	237.32	237.35	6626.0
2023-01-13 07:30:00	MSFT	Stock	237.25	237.56	236.95	236.95	14602.0
2023-01-13 08:00:00	MSFT	Stock	237.9	238.1	236.6	236.96	23372.0
2023-01-13 08:30:00	MSFT	Stock	236.75	237.15	236.5401	236.5401	20313.0
2023-01-13 09:00:00	MSFT	Stock	236.65	237.5	236.37	237.13	28172.0
2023-01-13 09:30:00	MSFT	Stock	237.04	237.26	234.92	236.56	1969248.0
2023-01-13 10:00:00	MSFT	Stock	236.53	237.57	236.2	236.76	1288723.0
2023-01-13 10:30:00	MSFT	Stock	236.78	236.99	236.18	236.65	803283.0
2023-01-13 11:00:00	MSFT	Stock	236.61	236.75	235.11	235.9	1251562.0
2023-01-13 11:30:00	MSFT	Stock	235.96	235.96	234.98	235.595	682345.0
2023-01-13 12:00:00	MSFT	Stock	235.5401	236.25	235.47	236.13	575927.0
2023-01-13 12:30:00	MSFT	Stock	236.1283	236.48	235.88	236.42	507579.0

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

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