PREVIEW / stock_30min / 2023-05-09

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-05-09.parquet
  size:    2.1 MB
  rows:    101,189
  symbols: 1,650

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-05-09 04:00:00	AAPL	Stock	173.43	173.43	172.92	173.0	7488.0
2023-05-09 04:30:00	AAPL	Stock	172.94	172.96	172.64	172.82	7461.0
2023-05-09 05:00:00	AAPL	Stock	172.85	172.85	172.8	172.8	1701.0
2023-05-09 05:30:00	AAPL	Stock	172.71	172.8	172.7	172.72	6627.0
2023-05-09 06:00:00	AAPL	Stock	172.8	172.9	172.78	172.78	2494.0
2023-05-09 06:30:00	AAPL	Stock	172.75	172.8	172.64	172.8	2463.0
2023-05-09 07:00:00	AAPL	Stock	172.85	172.98	172.6	172.67	21742.0
2023-05-09 07:30:00	AAPL	Stock	172.71	172.73	172.5	172.73	20570.0
2023-05-09 08:00:00	AAPL	Stock	172.84	173.02	172.51	172.85	47181.0
2023-05-09 08:30:00	AAPL	Stock	172.85	172.85	172.55	172.55	43232.0
2023-05-09 09:00:00	AAPL	Stock	172.56	173.13	172.23	173.13	175681.0
2023-05-09 09:30:00	AAPL	Stock	173.13	173.54	172.31	172.775	5961296.0
2023-05-09 10:00:00	AAPL	Stock	172.78	172.89	172.26	172.52	2746316.0
2023-05-09 10:30:00	AAPL	Stock	172.53	172.6	172.145	172.515	2533460.0
2023-05-09 11:00:00	AAPL	Stock	172.51	172.64	172.1691	172.2804	1960576.0
2023-05-09 11:30:00	AAPL	Stock	172.29	172.3999	171.82	171.855	2271812.0
2023-05-09 12:00:00	AAPL	Stock	171.85	172.2	171.81	172.0591	1513288.0
2023-05-09 12:30:00	AAPL	Stock	172.055	172.43	172.02	172.369	1438240.0
2023-05-09 13:00:00	AAPL	Stock	172.37	172.48	172.18	172.205	1252828.0
2023-05-09 13:30:00	AAPL	Stock	172.21	172.3	171.96	172.085	1331313.0
2023-05-09 14:00:00	AAPL	Stock	172.09	172.3398	172.0776	172.27	1315775.0
2023-05-09 14:30:00	AAPL	Stock	172.27	172.3576	171.92	172.072	1371302.0
2023-05-09 15:00:00	AAPL	Stock	172.075	172.17	171.85	171.965	1513167.0
2023-05-09 15:30:00	AAPL	Stock	171.97	172.235	171.6	171.78	5343755.0
2023-05-09 16:00:00	AAPL	Stock	171.8	171.87	171.64	171.7	4847406.0
2023-05-09 16:30:00	AAPL	Stock	171.71	171.87	171.7	171.75	87385.0
2023-05-09 17:00:00	AAPL	Stock	171.75	171.76	171.67	171.67	10279.0
2023-05-09 17:30:00	AAPL	Stock	171.66	171.74	171.66	171.71	4928.0
2023-05-09 18:00:00	AAPL	Stock	171.71	171.81	171.7	171.7	6712.0
2023-05-09 18:30:00	AAPL	Stock	171.81	171.908	171.81	171.85	10287.0
2023-05-09 19:00:00	AAPL	Stock	171.88	171.94	171.7601	171.8	6820.0
2023-05-09 19:30:00	AAPL	Stock	171.8	171.97	171.7801	171.94	10237.0
2023-05-09 04:00:00	MSFT	Stock	307.5	308.3	307.48	307.99	2529.0
2023-05-09 04:30:00	MSFT	Stock	307.39	307.45	307.0	307.04	518.0
2023-05-09 05:00:00	MSFT	Stock	307.29	307.29	306.76	306.76	750.0
2023-05-09 05:30:00	MSFT	Stock	307.04	307.04	307.04	307.04	200.0
2023-05-09 06:00:00	MSFT	Stock	307.0	307.0	306.77	306.77	200.0
2023-05-09 06:30:00	MSFT	Stock	306.81	306.81	306.8	306.81	300.0
2023-05-09 07:00:00	MSFT	Stock	306.99	307.0	306.74	306.74	1791.0
2023-05-09 07:30:00	MSFT	Stock	306.65	307.0	306.65	307.0	2931.0
2023-05-09 08:00:00	MSFT	Stock	306.85	307.72	306.8	307.4	15496.0
2023-05-09 08:30:00	MSFT	Stock	307.31	307.31	306.62	306.62	19420.0
2023-05-09 09:00:00	MSFT	Stock	306.5019	308.32	306.44	308.04	86643.0
2023-05-09 09:30:00	MSFT	Stock	308.04	310.04	307.675	308.978	2671242.0
2023-05-09 10:00:00	MSFT	Stock	308.98	309.3531	308.05	308.62	1124203.0
2023-05-09 10:30:00	MSFT	Stock	308.67	309.0	307.9531	308.11	1159653.0
2023-05-09 11:00:00	MSFT	Stock	308.1	308.43	307.22	307.74	1012076.0
2023-05-09 11:30:00	MSFT	Stock	307.79	307.875	307.06	307.28	735587.0
2023-05-09 12:00:00	MSFT	Stock	307.27	307.5	306.61	306.89	603643.0
2023-05-09 12:30:00	MSFT	Stock	306.91	307.83	306.75	307.7093	639065.0

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

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