PREVIEW / stock_30min / 2023-10-23

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-10-23.parquet
  size:    2.0 MB
  rows:    97,612
  symbols: 1,356

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-10-23 04:00:00	AAPL	Stock	172.6	172.6	171.68	171.75	33127.0
2023-10-23 04:30:00	AAPL	Stock	171.76	171.86	171.7	171.7	9114.0
2023-10-23 05:00:00	AAPL	Stock	171.67	171.67	170.0	170.6	46123.0
2023-10-23 05:30:00	AAPL	Stock	170.61	170.61	170.2	170.2	25828.0
2023-10-23 06:00:00	AAPL	Stock	170.22	170.49	170.2	170.36	15038.0
2023-10-23 06:30:00	AAPL	Stock	170.39	170.7	170.39	170.66	8601.0
2023-10-23 07:00:00	AAPL	Stock	170.6	171.17	170.6	170.92	25056.0
2023-10-23 07:30:00	AAPL	Stock	170.98	171.32	170.7	170.81	57332.0
2023-10-23 08:00:00	AAPL	Stock	171.04	173.08	170.6	171.4	115563.0
2023-10-23 08:30:00	AAPL	Stock	171.25	171.4172	170.61	170.8709	48002.0
2023-10-23 09:00:00	AAPL	Stock	170.85	171.15	170.26	171.01	157938.0
2023-10-23 09:30:00	AAPL	Stock	170.91	171.68	169.93	171.3799	8730359.0
2023-10-23 10:00:00	AAPL	Stock	171.37	171.91	171.09	171.59	4293392.0
2023-10-23 10:30:00	AAPL	Stock	171.59	172.23	171.17	172.21	3190485.0
2023-10-23 11:00:00	AAPL	Stock	172.22	172.9103	172.02	172.81	2747574.0
2023-10-23 11:30:00	AAPL	Stock	172.81	172.985	172.41	172.58	2174798.0
2023-10-23 12:00:00	AAPL	Stock	172.6	172.9	172.28	172.84	2179148.0
2023-10-23 12:30:00	AAPL	Stock	172.86	173.62	172.64	173.6	2098347.0
2023-10-23 13:00:00	AAPL	Stock	173.61	173.64	173.1131	173.31	1953721.0
2023-10-23 13:30:00	AAPL	Stock	173.31	174.01	173.21	173.521	2290309.0
2023-10-23 14:00:00	AAPL	Stock	173.52	173.8129	173.139	173.38	1942199.0
2023-10-23 14:30:00	AAPL	Stock	173.39	173.62	173.21	173.5	1881622.0
2023-10-23 15:00:00	AAPL	Stock	173.5	173.725	173.085	173.133	2609646.0
2023-10-23 15:30:00	AAPL	Stock	173.145	173.26	172.72	172.96	4487978.0
2023-10-23 16:00:00	AAPL	Stock	173.12	173.12	172.78	172.96	4232436.0
2023-10-23 16:30:00	AAPL	Stock	172.95	173.23	172.86	173.01	42412.0
2023-10-23 17:00:00	AAPL	Stock	173.02	173.04	172.76	172.85	44164.0
2023-10-23 17:30:00	AAPL	Stock	172.8011	172.99	172.8011	172.95	15867.0
2023-10-23 18:00:00	AAPL	Stock	172.95	172.96	172.71	172.77	12158.0
2023-10-23 18:30:00	AAPL	Stock	172.83	172.94	172.8	172.94	5801.0
2023-10-23 19:00:00	AAPL	Stock	172.85	172.97	172.66	172.72	5460.0
2023-10-23 19:30:00	AAPL	Stock	172.76	173.23	172.75	173.23	13673.0
2023-10-23 04:00:00	MSFT	Stock	328.28	328.28	327.8	327.85	330.0
2023-10-23 04:30:00	MSFT	Stock	327.34	327.56	327.1	327.11	3314.0
2023-10-23 05:00:00	MSFT	Stock	327.05	327.05	325.72	325.72	3287.0
2023-10-23 05:30:00	MSFT	Stock	325.6	325.6	324.27	324.44	4971.0
2023-10-23 06:00:00	MSFT	Stock	324.94	324.99	324.5	324.99	2687.0
2023-10-23 06:30:00	MSFT	Stock	324.91	325.21	324.73	325.21	2461.0
2023-10-23 07:00:00	MSFT	Stock	325.21	325.72	325.11	325.5	11721.0
2023-10-23 07:30:00	MSFT	Stock	325.69	326.78	325.69	326.14	4998.0
2023-10-23 08:00:00	MSFT	Stock	325.0	328.44	325.0	326.7	34509.0
2023-10-23 08:30:00	MSFT	Stock	326.7	327.21	326.65	326.74	11680.0
2023-10-23 09:00:00	MSFT	Stock	326.96	327.2	324.72	325.51	72420.0
2023-10-23 09:30:00	MSFT	Stock	325.51	329.13	324.39	327.59	2897839.0
2023-10-23 10:00:00	MSFT	Stock	327.5796	328.05	326.5901	327.3	1070721.0
2023-10-23 10:30:00	MSFT	Stock	327.25	328.32	326.5201	328.28	756715.0
2023-10-23 11:00:00	MSFT	Stock	328.32	329.5724	327.92	329.1625	776415.0
2023-10-23 11:30:00	MSFT	Stock	329.12	329.42	328.66	329.41	561932.0
2023-10-23 12:00:00	MSFT	Stock	329.41	330.8791	329.05	330.51	963399.0
2023-10-23 12:30:00	MSFT	Stock	330.515	332.68	330.12	332.68	1141663.0

> showing 50 of 97,612 rows — these rows as CSV

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