PREVIEW / stock_30min / 2023-05-10

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-05-10.parquet
  size:    2.1 MB
  rows:    101,786
  symbols: 1,658

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-10 04:00:00	AAPL	Stock	171.63	171.63	170.85	171.18	14776.0
2023-05-10 04:30:00	AAPL	Stock	171.2	171.29	171.15	171.25	3206.0
2023-05-10 05:00:00	AAPL	Stock	171.21	171.21	171.18	171.18	200.0
2023-05-10 05:30:00	AAPL	Stock	171.18	171.37	171.18	171.23	2759.0
2023-05-10 06:00:00	AAPL	Stock	171.26	171.26	171.26	171.26	378.0
2023-05-10 06:30:00	AAPL	Stock	171.31	171.41	171.31	171.41	718.0
2023-05-10 07:00:00	AAPL	Stock	171.41	171.75	171.41	171.72	15466.0
2023-05-10 07:30:00	AAPL	Stock	171.7	171.8	171.58	171.7	15683.0
2023-05-10 08:00:00	AAPL	Stock	171.5987	171.86	171.19	171.7807	60489.0
2023-05-10 08:30:00	AAPL	Stock	171.79	173.23	171.79	173.11	511622.0
2023-05-10 09:00:00	AAPL	Stock	173.12	173.44	172.7	173.01	310909.0
2023-05-10 09:30:00	AAPL	Stock	173.01	174.03	172.55	172.986	6346112.0
2023-05-10 10:00:00	AAPL	Stock	172.985	173.71	172.95	173.0519	3745201.0
2023-05-10 10:30:00	AAPL	Stock	173.055	173.42	172.29	172.555	3498720.0
2023-05-10 11:00:00	AAPL	Stock	172.56	173.37	172.55	173.2901	2265857.0
2023-05-10 11:30:00	AAPL	Stock	173.3	173.83	173.3	173.49	2459762.0
2023-05-10 12:00:00	AAPL	Stock	173.4866	173.4866	172.79	173.1775	2207340.0
2023-05-10 12:30:00	AAPL	Stock	173.1721	173.3	172.73	172.81	1739991.0
2023-05-10 13:00:00	AAPL	Stock	172.8	172.9499	171.98	172.03	2143575.0
2023-05-10 13:30:00	AAPL	Stock	172.02	172.49	171.9	172.28	1885032.0
2023-05-10 14:00:00	AAPL	Stock	172.275	172.84	172.26	172.62	1636736.0
2023-05-10 14:30:00	AAPL	Stock	172.625	173.16	172.61	173.065	1819530.0
2023-05-10 15:00:00	AAPL	Stock	173.07	173.84	172.945	173.63	2922960.0
2023-05-10 15:30:00	AAPL	Stock	173.64	173.91	173.34	173.5504	4631700.0
2023-05-10 16:00:00	AAPL	Stock	173.55	173.63	173.47	173.53	7209179.0
2023-05-10 16:30:00	AAPL	Stock	173.52	173.56	173.31	173.38	53058.0
2023-05-10 17:00:00	AAPL	Stock	173.39	173.44	173.38	173.44	6458.0
2023-05-10 17:30:00	AAPL	Stock	173.41	173.42	173.4	173.42	4595.0
2023-05-10 18:00:00	AAPL	Stock	173.42	173.51	173.32	173.51	14964.0
2023-05-10 18:30:00	AAPL	Stock	173.52	173.55	173.43	173.46	8640.0
2023-05-10 19:00:00	AAPL	Stock	173.46	173.5	173.4	173.5	11846.0
2023-05-10 19:30:00	AAPL	Stock	173.4999	173.65	173.48	173.65	9013.0
2023-05-10 04:00:00	MSFT	Stock	306.48	306.48	305.45	305.95	5040.0
2023-05-10 04:30:00	MSFT	Stock	305.86	305.86	305.5	305.5	856.0
2023-05-10 05:00:00	MSFT	Stock	305.72	305.72	305.3	305.3	293.0
2023-05-10 05:30:00	MSFT	Stock	305.48	305.79	305.48	305.55	1237.0
2023-05-10 06:00:00	MSFT	Stock	305.4	305.4	305.4	305.4	100.0
2023-05-10 06:30:00	MSFT	Stock	305.45	305.99	305.45	305.99	324.0
2023-05-10 07:00:00	MSFT	Stock	306.14	306.79	306.0	306.69	5150.0
2023-05-10 07:30:00	MSFT	Stock	306.76	307.2	306.58	307.06	5637.0
2023-05-10 08:00:00	MSFT	Stock	306.0	307.6715	305.2315	307.6	17850.0
2023-05-10 08:30:00	MSFT	Stock	307.79	309.24	307.79	308.88	134209.0
2023-05-10 09:00:00	MSFT	Stock	308.81	309.19	308.2	308.74	135795.0
2023-05-10 09:30:00	MSFT	Stock	308.62	310.34	307.67	309.94	2920429.0
2023-05-10 10:00:00	MSFT	Stock	310.0	311.58	309.98	310.34	1899818.0
2023-05-10 10:30:00	MSFT	Stock	310.36	310.93	308.62	309.84	1486809.0
2023-05-10 11:00:00	MSFT	Stock	309.87	310.81	309.49	310.5847	786424.0
2023-05-10 11:30:00	MSFT	Stock	310.58	311.339	310.57	311.1	860925.0
2023-05-10 12:00:00	MSFT	Stock	311.11	311.11	310.03	310.38	851348.0
2023-05-10 12:30:00	MSFT	Stock	310.39	311.2	310.21	310.61	875496.0

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

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