PREVIEW / stock_30min / 2023-07-25

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-07-25.parquet
  size:    2.1 MB
  rows:    100,760
  symbols: 1,538

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-25 04:00:00	AAPL	Stock	193.58	193.66	193.4	193.66	9560.0
2023-07-25 04:30:00	AAPL	Stock	193.66	193.66	193.44	193.55	3239.0
2023-07-25 05:00:00	AAPL	Stock	193.46	193.57	193.45	193.51	3980.0
2023-07-25 05:30:00	AAPL	Stock	193.55	193.56	193.55	193.56	1935.0
2023-07-25 06:00:00	AAPL	Stock	193.54	193.54	193.3	193.4	5865.0
2023-07-25 06:30:00	AAPL	Stock	193.42	193.5	193.33	193.33	6595.0
2023-07-25 07:00:00	AAPL	Stock	193.4	193.51	193.4	193.43	5981.0
2023-07-25 07:30:00	AAPL	Stock	193.48	193.54	193.43	193.54	8273.0
2023-07-25 08:00:00	AAPL	Stock	193.48	193.77	193.4	193.54	65776.0
2023-07-25 08:30:00	AAPL	Stock	193.58	193.69	193.49	193.58	39215.0
2023-07-25 09:00:00	AAPL	Stock	193.59	193.66	193.25	193.37	93482.0
2023-07-25 09:30:00	AAPL	Stock	193.39	194.02	192.915	193.95	4131985.0
2023-07-25 10:00:00	AAPL	Stock	193.955	194.2	193.33	193.395	2151347.0
2023-07-25 10:30:00	AAPL	Stock	193.395	193.58	193.23	193.28	1678731.0
2023-07-25 11:00:00	AAPL	Stock	193.2722	193.98	193.25	193.82	1594838.0
2023-07-25 11:30:00	AAPL	Stock	193.83	194.13	193.73	193.765	1359623.0
2023-07-25 12:00:00	AAPL	Stock	193.765	193.9655	193.61	193.7647	1235905.0
2023-07-25 12:30:00	AAPL	Stock	193.75	193.95	193.615	193.92	846133.0
2023-07-25 13:00:00	AAPL	Stock	193.9188	194.23	193.84	194.2	1276704.0
2023-07-25 13:30:00	AAPL	Stock	194.21	194.24	193.92	193.975	968765.0
2023-07-25 14:00:00	AAPL	Stock	193.97	194.26	193.87	194.1212	1022488.0
2023-07-25 14:30:00	AAPL	Stock	194.13	194.44	193.93	193.94	1428601.0
2023-07-25 15:00:00	AAPL	Stock	193.945	194.42	193.91	194.275	1994863.0
2023-07-25 15:30:00	AAPL	Stock	194.27	194.32	193.6	193.62	3687486.0
2023-07-25 16:00:00	AAPL	Stock	193.63	193.98	193.31	193.58	5562081.0
2023-07-25 16:30:00	AAPL	Stock	193.58	193.8	193.41	193.51	108510.0
2023-07-25 17:00:00	AAPL	Stock	193.52	193.8	193.45	193.8	55581.0
2023-07-25 17:30:00	AAPL	Stock	193.81	193.94	193.51	193.78	28045.0
2023-07-25 18:00:00	AAPL	Stock	193.81	193.81	193.21	193.3	71423.0
2023-07-25 18:30:00	AAPL	Stock	193.32	193.4342	193.3	193.4	9055.0
2023-07-25 19:00:00	AAPL	Stock	193.42	193.44	193.34	193.42	8429.0
2023-07-25 19:30:00	AAPL	Stock	193.41	193.57	193.41	193.53	20461.0
2023-07-25 04:00:00	MSFT	Stock	347.0	347.5	346.9	347.46	9448.0
2023-07-25 04:30:00	MSFT	Stock	347.46	347.59	347.01	347.25	9169.0
2023-07-25 05:00:00	MSFT	Stock	347.25	347.79	347.22	347.7	11778.0
2023-07-25 05:30:00	MSFT	Stock	347.6	348.0	347.5	347.92	11299.0
2023-07-25 06:00:00	MSFT	Stock	348.0	348.5	347.67	347.7	18042.0
2023-07-25 06:30:00	MSFT	Stock	347.51	347.89	347.5	347.85	6102.0
2023-07-25 07:00:00	MSFT	Stock	347.79	348.2	347.73	348.15	15461.0
2023-07-25 07:30:00	MSFT	Stock	348.18	348.2	348.0	348.15	19822.0
2023-07-25 08:00:00	MSFT	Stock	346.85	349.9	346.75	348.47	118742.0
2023-07-25 08:30:00	MSFT	Stock	348.4687	348.65	348.15	348.2805	23061.0
2023-07-25 09:00:00	MSFT	Stock	348.28	348.49	346.7	347.04	107708.0
2023-07-25 09:30:00	MSFT	Stock	347.16	348.32	345.07	347.9	2869632.0
2023-07-25 10:00:00	MSFT	Stock	347.88	347.99	346.4	346.75	1543216.0
2023-07-25 10:30:00	MSFT	Stock	346.74	347.13	345.85	346.14	1232505.0
2023-07-25 11:00:00	MSFT	Stock	346.19	347.84	346.1162	347.41	989739.0
2023-07-25 11:30:00	MSFT	Stock	347.4139	349.25	347.25	348.57	1359913.0
2023-07-25 12:00:00	MSFT	Stock	348.6	349.96	348.2001	348.788	1420001.0
2023-07-25 12:30:00	MSFT	Stock	348.77	350.41	348.49	350.1757	1224071.0

> showing 50 of 100,760 rows — these rows as CSV

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