PREVIEW / stock_30min / 2023-10-20

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-10-20.parquet
  size:    2.0 MB
  rows:    96,304
  symbols: 1,347

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-20 04:00:00	AAPL	Stock	174.95	175.01	174.56	175.01	6800.0
2023-10-20 04:30:00	AAPL	Stock	175.06	175.32	175.06	175.14	2264.0
2023-10-20 05:00:00	AAPL	Stock	175.07	175.16	174.75	174.75	8312.0
2023-10-20 05:30:00	AAPL	Stock	174.71	174.97	174.71	174.97	8023.0
2023-10-20 06:00:00	AAPL	Stock	174.93	174.93	174.73	174.73	1676.0
2023-10-20 06:30:00	AAPL	Stock	174.72	174.74	174.7	174.72	1322.0
2023-10-20 07:00:00	AAPL	Stock	174.71	175.1	174.7	174.95	10591.0
2023-10-20 07:30:00	AAPL	Stock	174.9	175.18	174.85	175.1	6790.0
2023-10-20 08:00:00	AAPL	Stock	174.77	175.2	174.49	174.646	40538.0
2023-10-20 08:30:00	AAPL	Stock	174.65	174.84	174.63	174.68	14678.0
2023-10-20 09:00:00	AAPL	Stock	174.77	175.8	174.42	175.41	274079.0
2023-10-20 09:30:00	AAPL	Stock	175.37	175.42	174.67	175.1016	7898669.0
2023-10-20 10:00:00	AAPL	Stock	175.105	175.32	174.07	174.24	3192025.0
2023-10-20 10:30:00	AAPL	Stock	174.24	174.26	173.34	173.365	3791100.0
2023-10-20 11:00:00	AAPL	Stock	173.36	173.68	172.64	172.8699	3421907.0
2023-10-20 11:30:00	AAPL	Stock	172.88	173.68	172.67	173.64	3305476.0
2023-10-20 12:00:00	AAPL	Stock	173.65	173.84	173.4	173.56	2222657.0
2023-10-20 12:30:00	AAPL	Stock	173.57	174.36	173.56	174.315	1866211.0
2023-10-20 13:00:00	AAPL	Stock	174.32	174.72	173.98	174.18	2916688.0
2023-10-20 13:30:00	AAPL	Stock	174.185	174.38	173.8877	174.305	1695507.0
2023-10-20 14:00:00	AAPL	Stock	174.3	174.39	173.46	173.58	1942902.0
2023-10-20 14:30:00	AAPL	Stock	173.56	173.86	173.255	173.51	1840121.0
2023-10-20 15:00:00	AAPL	Stock	173.53	173.755	173.125	173.38	2147733.0
2023-10-20 15:30:00	AAPL	Stock	173.37	173.49	172.8	172.84	5857282.0
2023-10-20 16:00:00	AAPL	Stock	172.84	173.14	172.84	173.0	8734946.0
2023-10-20 16:30:00	AAPL	Stock	173.01	173.29	172.9	172.97	85741.0
2023-10-20 17:00:00	AAPL	Stock	172.9406	172.99	172.88	172.92	38432.0
2023-10-20 17:30:00	AAPL	Stock	172.93	172.93	172.86	172.87	12944.0
2023-10-20 18:00:00	AAPL	Stock	172.86	172.88	172.82	172.85	5788.0
2023-10-20 18:30:00	AAPL	Stock	172.81	172.87	172.7	172.73	6535.0
2023-10-20 19:00:00	AAPL	Stock	172.76	172.7799	172.71	172.72	5933.0
2023-10-20 19:30:00	AAPL	Stock	172.72	172.8	172.64	172.78	10144.0
2023-10-20 04:00:00	MSFT	Stock	330.88	331.98	330.8	331.98	1948.0
2023-10-20 04:30:00	MSFT	Stock	331.68	332.05	331.64	332.0	675.0
2023-10-20 05:00:00	MSFT	Stock	332.0	332.0	331.29	331.29	1168.0
2023-10-20 05:30:00	MSFT	Stock	330.96	330.96	330.96	330.96	222.0
2023-10-20 06:00:00	MSFT	Stock	330.87	330.87	330.87	330.87	300.0
2023-10-20 06:30:00	MSFT	Stock	330.31	330.31	330.26	330.26	538.0
2023-10-20 07:00:00	MSFT	Stock	330.65	331.24	330.65	331.2	4812.0
2023-10-20 07:30:00	MSFT	Stock	331.05	331.19	330.76	331.19	1972.0
2023-10-20 08:00:00	MSFT	Stock	330.61	331.39	330.15	330.31	14642.0
2023-10-20 08:30:00	MSFT	Stock	330.5	331.25	330.5	330.75	22060.0
2023-10-20 09:00:00	MSFT	Stock	330.74	332.88	330.63	331.77	99435.0
2023-10-20 09:30:00	MSFT	Stock	331.77	331.92	329.31	329.74	3646176.0
2023-10-20 10:00:00	MSFT	Stock	329.72	330.41	328.25	328.33	1161065.0
2023-10-20 10:30:00	MSFT	Stock	328.32	328.4	325.523	325.55	1481718.0
2023-10-20 11:00:00	MSFT	Stock	325.54	326.99	325.45	326.39	989246.0
2023-10-20 11:30:00	MSFT	Stock	326.41	327.6	325.89	327.36	766341.0
2023-10-20 12:00:00	MSFT	Stock	327.38	327.52	326.3509	326.86	561634.0
2023-10-20 12:30:00	MSFT	Stock	326.88	328.27	326.87	328.25	566182.0

> showing 50 of 96,304 rows — these rows as CSV

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