PREVIEW / stock_30min / 2023-07-05

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-07-05.parquet
  size:    2.1 MB
  rows:    101,904
  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-07-05 04:00:00	AAPL	Stock	192.71	192.71	191.8	191.83	8768.0
2023-07-05 04:30:00	AAPL	Stock	191.83	191.89	191.5	191.5	1995.0
2023-07-05 05:00:00	AAPL	Stock	191.42	191.43	191.11	191.2	4884.0
2023-07-05 05:30:00	AAPL	Stock	191.16	191.22	191.02	191.22	3980.0
2023-07-05 06:00:00	AAPL	Stock	191.2	191.3	190.99	191.16	6399.0
2023-07-05 06:30:00	AAPL	Stock	191.27	191.64	191.27	191.54	10430.0
2023-07-05 07:00:00	AAPL	Stock	191.58	191.77	191.36	191.48	18008.0
2023-07-05 07:30:00	AAPL	Stock	191.48	191.6	191.27	191.27	18178.0
2023-07-05 08:00:00	AAPL	Stock	191.6	192.88	191.08	191.28	92226.0
2023-07-05 08:30:00	AAPL	Stock	191.28	191.48	191.26	191.48	48099.0
2023-07-05 09:00:00	AAPL	Stock	191.48	191.75	191.39	191.53	97901.0
2023-07-05 09:30:00	AAPL	Stock	191.57	192.98	191.55	192.235	6325415.0
2023-07-05 10:00:00	AAPL	Stock	192.24	192.69	192.11	192.35	3229977.0
2023-07-05 10:30:00	AAPL	Stock	192.35	192.7399	192.03	192.3599	2247608.0
2023-07-05 11:00:00	AAPL	Stock	192.36	192.365	191.39	191.435	2456356.0
2023-07-05 11:30:00	AAPL	Stock	191.44	191.66	190.91	190.93	2826690.0
2023-07-05 12:00:00	AAPL	Stock	190.92	191.2	190.6779	191.1416	1896083.0
2023-07-05 12:30:00	AAPL	Stock	191.15	191.305	190.87	191.135	1264499.0
2023-07-05 13:00:00	AAPL	Stock	191.13	191.29	190.9	190.99	1280561.0
2023-07-05 13:30:00	AAPL	Stock	190.985	191.065	190.865	190.9305	1102263.0
2023-07-05 14:00:00	AAPL	Stock	190.94	191.105	190.62	190.95	2097236.0
2023-07-05 14:30:00	AAPL	Stock	190.95	191.43	190.91	191.305	1516021.0
2023-07-05 15:00:00	AAPL	Stock	191.3	191.44	191.22	191.355	1398077.0
2023-07-05 15:30:00	AAPL	Stock	191.36	191.4899	191.235	191.33	3207481.0
2023-07-05 16:00:00	AAPL	Stock	191.33	191.34	191.17	191.3	5020841.0
2023-07-05 16:30:00	AAPL	Stock	191.3	191.33	191.26	191.3099	32810.0
2023-07-05 17:00:00	AAPL	Stock	191.3	191.33	191.29	191.3	13048.0
2023-07-05 17:30:00	AAPL	Stock	191.31	191.32	191.3	191.32	4080.0
2023-07-05 18:00:00	AAPL	Stock	191.31	191.33	191.25	191.26	9613.0
2023-07-05 18:30:00	AAPL	Stock	191.28	191.37	191.27	191.35	16147.0
2023-07-05 19:00:00	AAPL	Stock	191.3	191.31	191.22	191.25	8133.0
2023-07-05 19:30:00	AAPL	Stock	191.26	191.33	191.21	191.25	16287.0
2023-07-05 04:00:00	MSFT	Stock	336.67	336.67	336.0	336.0	1909.0
2023-07-05 04:30:00	MSFT	Stock	336.27	336.27	335.9	335.9	571.0
2023-07-05 05:00:00	MSFT	Stock	335.87	335.87	335.35	335.35	250.0
2023-07-05 05:30:00	MSFT	Stock	335.03	335.51	335.03	335.32	5780.0
2023-07-05 06:00:00	MSFT	Stock	335.65	335.65	335.65	335.65	100.0
2023-07-05 06:30:00	MSFT	Stock	335.65	336.0	335.65	335.89	1137.0
2023-07-05 07:00:00	MSFT	Stock	336.19	336.32	335.7	335.71	5358.0
2023-07-05 07:30:00	MSFT	Stock	335.58	335.58	335.12	335.12	3550.0
2023-07-05 08:00:00	MSFT	Stock	336.29	338.67	334.9	337.99	29877.0
2023-07-05 08:30:00	MSFT	Stock	334.92	335.19	334.8	334.89	24851.0
2023-07-05 09:00:00	MSFT	Stock	335.05	335.5	334.9	335.23	21776.0
2023-07-05 09:30:00	MSFT	Stock	335.13	340.355	334.7276	338.68	2375862.0
2023-07-05 10:00:00	MSFT	Stock	338.71	340.7086	338.5	340.43	927252.0
2023-07-05 10:30:00	MSFT	Stock	340.44	341.65	339.66	340.94	996812.0
2023-07-05 11:00:00	MSFT	Stock	340.955	340.98	338.72	338.73	689896.0
2023-07-05 11:30:00	MSFT	Stock	338.74	339.35	338.63	338.86	564563.0
2023-07-05 12:00:00	MSFT	Stock	338.86	339.355	338.58	339.1399	465960.0
2023-07-05 12:30:00	MSFT	Stock	339.14	339.2	338.17	338.7015	462457.0

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

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