PREVIEW / stock_30min / 2023-06-30

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-06-30.parquet
  size:    2.1 MB
  rows:    101,432
  symbols: 1,557

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-06-30 04:00:00	AAPL	Stock	190.37	190.8	190.37	190.59	14157.0
2023-06-30 04:30:00	AAPL	Stock	190.59	190.95	190.58	190.95	7877.0
2023-06-30 05:00:00	AAPL	Stock	190.91	191.2	190.8	191.19	10785.0
2023-06-30 05:30:00	AAPL	Stock	191.2	191.2	191.12	191.12	14900.0
2023-06-30 06:00:00	AAPL	Stock	191.04	191.04	190.83	190.89	16024.0
2023-06-30 06:30:00	AAPL	Stock	190.85	191.2	190.85	190.88	10989.0
2023-06-30 07:00:00	AAPL	Stock	190.87	191.14	190.87	191.03	46937.0
2023-06-30 07:30:00	AAPL	Stock	191.05	191.25	191.05	191.24	29824.0
2023-06-30 08:00:00	AAPL	Stock	190.98	191.74	190.32	191.46	309038.0
2023-06-30 08:30:00	AAPL	Stock	191.45	192.21	191.43	192.11	424932.0
2023-06-30 09:00:00	AAPL	Stock	192.14	192.19	191.5	191.65	382319.0
2023-06-30 09:30:00	AAPL	Stock	191.63	192.64	191.26	192.485	9410549.0
2023-06-30 10:00:00	AAPL	Stock	192.47	193.15	192.1591	192.69	5796163.0
2023-06-30 10:30:00	AAPL	Stock	192.685	192.86	192.335	192.54	3408823.0
2023-06-30 11:00:00	AAPL	Stock	192.54	192.82	192.35	192.385	2577386.0
2023-06-30 11:30:00	AAPL	Stock	192.385	192.5	191.98	192.3387	2891292.0
2023-06-30 12:00:00	AAPL	Stock	192.34	192.65	192.22	192.59	2101373.0
2023-06-30 12:30:00	AAPL	Stock	192.585	192.88	192.5	192.68	1729379.0
2023-06-30 13:00:00	AAPL	Stock	192.68	192.985	192.635	192.925	2023322.0
2023-06-30 13:30:00	AAPL	Stock	192.9297	193.12	192.92	193.09	2540474.0
2023-06-30 14:00:00	AAPL	Stock	193.09	193.185	192.815	193.025	2321605.0
2023-06-30 14:30:00	AAPL	Stock	193.03	193.15	192.89	193.01	1935111.0
2023-06-30 15:00:00	AAPL	Stock	193.01	193.5399	192.9	193.49	3552456.0
2023-06-30 15:30:00	AAPL	Stock	193.49	194.48	193.28	193.8	11184965.0
2023-06-30 16:00:00	AAPL	Stock	193.79	194.03	193.75	193.83	16659839.0
2023-06-30 16:30:00	AAPL	Stock	193.85	193.99	193.8	193.84	240643.0
2023-06-30 17:00:00	AAPL	Stock	193.85	193.97	193.83	193.9	127247.0
2023-06-30 17:30:00	AAPL	Stock	193.88	193.95	193.81	193.87	43218.0
2023-06-30 18:00:00	AAPL	Stock	193.89	193.89	193.84	193.86	18769.0
2023-06-30 18:30:00	AAPL	Stock	193.87	193.9	193.81	193.85	31556.0
2023-06-30 19:00:00	AAPL	Stock	193.85	194.1	193.8494	194.0	36114.0
2023-06-30 19:30:00	AAPL	Stock	194.01	194.28	194.0	194.28	46360.0
2023-06-30 04:00:00	MSFT	Stock	336.4	336.4	335.71	335.71	1741.0
2023-06-30 05:00:00	MSFT	Stock	336.39	336.39	336.39	336.39	229.0
2023-06-30 06:00:00	MSFT	Stock	336.2	336.2	336.2	336.2	188.0
2023-06-30 06:30:00	MSFT	Stock	336.2	336.39	336.2	336.39	1776.0
2023-06-30 07:00:00	MSFT	Stock	336.26	336.66	336.19	336.31	2976.0
2023-06-30 07:30:00	MSFT	Stock	336.35	336.42	336.24	336.24	1826.0
2023-06-30 08:00:00	MSFT	Stock	336.27	336.628	335.1	336.35	13813.0
2023-06-30 08:30:00	MSFT	Stock	336.63	339.0	336.63	338.43	40067.0
2023-06-30 09:00:00	MSFT	Stock	338.51	339.0	337.3	337.42	53413.0
2023-06-30 09:30:00	MSFT	Stock	337.69	340.99	337.2	340.74	2382707.0
2023-06-30 10:00:00	MSFT	Stock	340.75	342.73	340.31	342.15	1465450.0
2023-06-30 10:30:00	MSFT	Stock	342.17	342.5	341.36	341.4112	1019110.0
2023-06-30 11:00:00	MSFT	Stock	341.4	341.95	340.8001	341.1	803112.0
2023-06-30 11:30:00	MSFT	Stock	341.1	341.13	339.66	340.2	900645.0
2023-06-30 12:00:00	MSFT	Stock	340.23	340.64	339.8301	340.35	619574.0
2023-06-30 12:30:00	MSFT	Stock	340.39	341.3	340.29	341.21	598345.0
2023-06-30 13:00:00	MSFT	Stock	341.23	341.47	340.42	340.62	599441.0
2023-06-30 13:30:00	MSFT	Stock	340.61	341.07	340.6001	340.9175	477554.0

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

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