PREVIEW / stock_30min / 2023-06-22

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-06-22.parquet
  size:    2.0 MB
  rows:    99,890
  symbols: 1,584

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-22 04:00:00	AAPL	Stock	183.66	183.78	183.3	183.5	7653.0
2023-06-22 04:30:00	AAPL	Stock	183.49	183.52	183.32	183.4	3806.0
2023-06-22 05:00:00	AAPL	Stock	183.4	183.77	183.4	183.55	3521.0
2023-06-22 05:30:00	AAPL	Stock	183.51	183.55	183.51	183.55	2398.0
2023-06-22 06:00:00	AAPL	Stock	183.55	183.58	183.25	183.53	6659.0
2023-06-22 06:30:00	AAPL	Stock	183.52	183.6	183.35	183.5	7115.0
2023-06-22 07:00:00	AAPL	Stock	183.58	183.58	183.2	183.25	19386.0
2023-06-22 07:30:00	AAPL	Stock	183.25	183.44	183.22	183.38	4211.0
2023-06-22 08:00:00	AAPL	Stock	183.4383	183.96	183.07	183.26	61412.0
2023-06-22 08:30:00	AAPL	Stock	183.26	183.6	183.26	183.42	88195.0
2023-06-22 09:00:00	AAPL	Stock	183.396	183.74	183.16	183.68	170797.0
2023-06-22 09:30:00	AAPL	Stock	183.74	185.555	183.67	185.4399	5791328.0
2023-06-22 10:00:00	AAPL	Stock	185.44	185.88	185.02	185.77	3610260.0
2023-06-22 10:30:00	AAPL	Stock	185.77	185.99	185.41	185.93	3183078.0
2023-06-22 11:00:00	AAPL	Stock	185.93	186.67	185.895	186.25	3815033.0
2023-06-22 11:30:00	AAPL	Stock	186.24	186.73	186.105	186.34	2465887.0
2023-06-22 12:00:00	AAPL	Stock	186.35	186.36	185.732	186.07	1871769.0
2023-06-22 12:30:00	AAPL	Stock	186.07	186.24	185.93	186.13	1230980.0
2023-06-22 13:00:00	AAPL	Stock	186.135	186.14	185.6	185.75	1446417.0
2023-06-22 13:30:00	AAPL	Stock	185.75	186.49	185.6106	186.445	1758510.0
2023-06-22 14:00:00	AAPL	Stock	186.445	186.57	186.295	186.425	1504940.0
2023-06-22 14:30:00	AAPL	Stock	186.425	186.73	186.21	186.7011	1789575.0
2023-06-22 15:00:00	AAPL	Stock	186.71	186.73	186.4	186.415	1934708.0
2023-06-22 15:30:00	AAPL	Stock	186.42	187.045	186.2832	186.97	5538947.0
2023-06-22 16:00:00	AAPL	Stock	186.96	187.15	186.93	187.11	5651430.0
2023-06-22 16:30:00	AAPL	Stock	187.08	187.24	187.0	187.1026	138249.0
2023-06-22 17:00:00	AAPL	Stock	187.14	187.21	187.11	187.11	37144.0
2023-06-22 17:30:00	AAPL	Stock	187.12	187.24	187.08	187.19	21707.0
2023-06-22 18:00:00	AAPL	Stock	187.19	187.22	187.12	187.19	15765.0
2023-06-22 18:30:00	AAPL	Stock	187.19	187.2	187.14	187.18	15526.0
2023-06-22 19:00:00	AAPL	Stock	187.2	187.21	187.1	187.13	25400.0
2023-06-22 19:30:00	AAPL	Stock	187.13	187.18	187.01	187.02	17541.0
2023-06-22 04:00:00	MSFT	Stock	333.1	333.79	333.0	333.58	8623.0
2023-06-22 04:30:00	MSFT	Stock	333.39	333.39	333.39	333.39	227.0
2023-06-22 05:00:00	MSFT	Stock	333.49	333.97	333.49	333.96	987.0
2023-06-22 05:30:00	MSFT	Stock	334.25	334.36	333.97	333.99	2427.0
2023-06-22 06:00:00	MSFT	Stock	333.98	333.98	333.61	333.89	3010.0
2023-06-22 06:30:00	MSFT	Stock	333.89	334.18	333.61	333.9	2051.0
2023-06-22 07:00:00	MSFT	Stock	333.8	334.63	333.8	334.32	14953.0
2023-06-22 07:30:00	MSFT	Stock	334.2	335.05	334.02	334.8	5641.0
2023-06-22 08:00:00	MSFT	Stock	333.81	334.9885	333.12	334.79	25024.0
2023-06-22 08:30:00	MSFT	Stock	334.87	335.5	334.01	334.39	21341.0
2023-06-22 09:00:00	MSFT	Stock	334.39	334.89	333.85	334.05	26803.0
2023-06-22 09:30:00	MSFT	Stock	334.12	337.385	333.34	336.71	2488710.0
2023-06-22 10:00:00	MSFT	Stock	336.68	338.56	336.625	337.41	1770259.0
2023-06-22 10:30:00	MSFT	Stock	337.3962	337.57	335.45	335.885	1060965.0
2023-06-22 11:00:00	MSFT	Stock	335.87	337.98	335.86	336.69	978141.0
2023-06-22 11:30:00	MSFT	Stock	336.62	338.755	336.4175	338.05	912369.0
2023-06-22 12:00:00	MSFT	Stock	338.04	338.06	336.7	337.24	658055.0
2023-06-22 12:30:00	MSFT	Stock	337.28	337.65	336.8	337.12	488005.0

> showing 50 of 99,890 rows — these rows as CSV

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