PREVIEW / stock_30min / 2022-04-25

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-04-25.parquet
  size:    2.2 MB
  rows:    109,805
  symbols: 2,487

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
2022-04-25 04:00:00	AAPL	Stock	160.99	161.39	160.59	161.1	31085.0
2022-04-25 04:30:00	AAPL	Stock	161.04	161.15	160.11	160.37	31981.0
2022-04-25 05:00:00	AAPL	Stock	160.37	160.49	159.61	159.99	65414.0
2022-04-25 05:30:00	AAPL	Stock	159.96	160.54	159.96	160.12	26135.0
2022-04-25 06:00:00	AAPL	Stock	160.2	160.5	160.08	160.29	10753.0
2022-04-25 06:30:00	AAPL	Stock	160.24	160.25	159.84	160.19	19563.0
2022-04-25 07:00:00	AAPL	Stock	160.33	160.59	159.15	159.41	166568.0
2022-04-25 07:30:00	AAPL	Stock	159.48	160.5	159.48	159.97	72570.0
2022-04-25 08:00:00	AAPL	Stock	159.97	160.84	159.21	160.469	710735.0
2022-04-25 08:30:00	AAPL	Stock	160.49	161.49	160.32	161.41	589232.0
2022-04-25 09:00:00	AAPL	Stock	161.33	161.45	160.72	161.11	353501.0
2022-04-25 09:30:00	AAPL	Stock	161.18	161.26	159.07	159.36	13331547.0
2022-04-25 10:00:00	AAPL	Stock	159.37	161.07	159.0	160.9	6981810.0
2022-04-25 10:30:00	AAPL	Stock	160.91	161.78	159.71	159.759	5403102.0
2022-04-25 11:00:00	AAPL	Stock	159.76	160.63	158.5	159.62	3913928.0
2022-04-25 11:30:00	AAPL	Stock	159.63	160.12	158.46	158.88	5146850.0
2022-04-25 12:00:00	AAPL	Stock	158.87	160.32	158.6	159.7081	4366530.0
2022-04-25 12:30:00	AAPL	Stock	159.715	160.56	159.54	159.69	3797968.0
2022-04-25 13:00:00	AAPL	Stock	159.68	160.45	159.27	160.12	3218399.0
2022-04-25 13:30:00	AAPL	Stock	160.13	160.64	159.66	159.875	3245459.0
2022-04-25 14:00:00	AAPL	Stock	159.86	161.12	159.41	161.0109	4082809.0
2022-04-25 14:30:00	AAPL	Stock	161.02	161.947	160.7012	161.43	4767631.0
2022-04-25 15:00:00	AAPL	Stock	161.42	162.31	160.4539	162.21	5303342.0
2022-04-25 15:30:00	AAPL	Stock	162.19	163.17	162.04	162.88	8962289.0
2022-04-25 16:00:00	AAPL	Stock	162.88	163.3	162.88	163.1392	7875302.0
2022-04-25 16:30:00	AAPL	Stock	163.1458	163.24	163.06	163.09	54753.0
2022-04-25 17:00:00	AAPL	Stock	163.09	163.1676	163.0	163.12	35048.0
2022-04-25 17:30:00	AAPL	Stock	163.1144	163.25	162.88	163.24	34827.0
2022-04-25 18:00:00	AAPL	Stock	163.13	163.13	162.88	162.9	22043.0
2022-04-25 18:30:00	AAPL	Stock	162.94	163.1	162.85	163.0	11696.0
2022-04-25 19:00:00	AAPL	Stock	163.06	163.23	162.95	163.16	7965.0
2022-04-25 19:30:00	AAPL	Stock	163.16	163.2	162.87	162.9	27745.0
2022-04-25 04:00:00	MSFT	Stock	271.4	272.99	271.4	272.7	8156.0
2022-04-25 04:30:00	MSFT	Stock	272.89	272.9	271.5	271.5	3403.0
2022-04-25 05:00:00	MSFT	Stock	271.91	271.99	271.3	271.62	3496.0
2022-04-25 05:30:00	MSFT	Stock	271.49	272.14	271.49	272.0	5601.0
2022-04-25 06:00:00	MSFT	Stock	271.91	272.0	271.45	271.81	1677.0
2022-04-25 06:30:00	MSFT	Stock	271.7	271.8	271.4	271.62	2102.0
2022-04-25 07:00:00	MSFT	Stock	271.78	271.8	270.75	271.0	17528.0
2022-04-25 07:30:00	MSFT	Stock	271.19	271.8	271.11	271.56	8458.0
2022-04-25 08:00:00	MSFT	Stock	271.7	273.345	270.0	271.8	46122.0
2022-04-25 08:30:00	MSFT	Stock	271.85	273.43	271.78	273.31	154617.0
2022-04-25 09:00:00	MSFT	Stock	273.4	273.71	272.2	273.56	49043.0
2022-04-25 09:30:00	MSFT	Stock	273.29	275.18	270.77	272.59	3595366.0
2022-04-25 10:00:00	MSFT	Stock	272.5837	277.28	272.47	276.9	2357184.0
2022-04-25 10:30:00	MSFT	Stock	276.93	278.02	275.41	275.5702	1441256.0
2022-04-25 11:00:00	MSFT	Stock	275.58	276.05	273.8	274.8	1318947.0
2022-04-25 11:30:00	MSFT	Stock	274.8	275.8	272.82	274.015	1146532.0
2022-04-25 12:00:00	MSFT	Stock	273.98	276.24	273.56	275.66	992085.0
2022-04-25 12:30:00	MSFT	Stock	275.6	277.15	275.33	275.8	968739.0

> showing 50 of 109,805 rows — these rows as CSV

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