PREVIEW / stock_30min / 2023-02-14

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-02-14.parquet
  size:    2.1 MB
  rows:    101,588
  symbols: 1,869

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-02-14 04:00:00	AAPL	Stock	153.5	154.05	153.4	153.76	8552.0
2023-02-14 04:30:00	AAPL	Stock	153.7	153.76	153.63	153.72	3886.0
2023-02-14 05:00:00	AAPL	Stock	153.75	153.78	153.72	153.75	1799.0
2023-02-14 05:30:00	AAPL	Stock	153.86	154.2	153.84	154.09	4833.0
2023-02-14 06:00:00	AAPL	Stock	154.15	154.34	154.15	154.24	5318.0
2023-02-14 06:30:00	AAPL	Stock	154.24	154.26	154.0	154.0	4751.0
2023-02-14 07:00:00	AAPL	Stock	154.0	154.15	153.95	154.08	35861.0
2023-02-14 07:30:00	AAPL	Stock	154.08	154.09	153.98	154.04	15036.0
2023-02-14 08:00:00	AAPL	Stock	153.65	154.2515	153.03	154.0	122391.0
2023-02-14 08:30:00	AAPL	Stock	154.0	155.2	152.75	153.07	486113.0
2023-02-14 09:00:00	AAPL	Stock	153.09	153.24	152.04	152.07	317345.0
2023-02-14 09:30:00	AAPL	Stock	152.12	153.0	151.0	152.8399	8744312.0
2023-02-14 10:00:00	AAPL	Stock	152.84	153.77	152.8	152.94	4734984.0
2023-02-14 10:30:00	AAPL	Stock	152.94	153.08	150.86	151.87	4911147.0
2023-02-14 11:00:00	AAPL	Stock	151.88	152.59	151.44	151.5418	3566874.0
2023-02-14 11:30:00	AAPL	Stock	151.55	151.83	151.04	151.7	3083269.0
2023-02-14 12:00:00	AAPL	Stock	151.695	152.23	151.57	151.8899	2250204.0
2023-02-14 12:30:00	AAPL	Stock	151.8853	152.34	151.75	152.105	1819777.0
2023-02-14 13:00:00	AAPL	Stock	152.11	153.22	152.06	152.75	2814116.0
2023-02-14 13:30:00	AAPL	Stock	152.77	153.21	152.53	153.04	1796801.0
2023-02-14 14:00:00	AAPL	Stock	153.04	153.3	152.43	153.135	2135757.0
2023-02-14 14:30:00	AAPL	Stock	153.13	153.57	153.125	153.24	1791022.0
2023-02-14 15:00:00	AAPL	Stock	153.245	153.47	152.9499	153.265	1888965.0
2023-02-14 15:30:00	AAPL	Stock	153.27	153.73	153.08	153.1	4493318.0
2023-02-14 16:00:00	AAPL	Stock	153.1399	153.2	152.85	153.15	7681128.0
2023-02-14 16:30:00	AAPL	Stock	153.2	153.2	153.07	153.09	56080.0
2023-02-14 17:00:00	AAPL	Stock	153.08	153.12	153.0166	153.11	13825.0
2023-02-14 17:30:00	AAPL	Stock	153.1	153.2	153.03	153.18	25216.0
2023-02-14 18:00:00	AAPL	Stock	153.2	153.2	153.06	153.09	25563.0
2023-02-14 18:30:00	AAPL	Stock	153.09	153.09	153.07	153.09	8509.0
2023-02-14 19:00:00	AAPL	Stock	153.08	153.09	152.82	153.03	15259.0
2023-02-14 19:30:00	AAPL	Stock	153.01	153.02	152.7	152.84	26786.0
2023-02-14 04:00:00	MSFT	Stock	272.09	272.65	271.74	271.98	2659.0
2023-02-14 04:30:00	MSFT	Stock	272.1	272.67	272.1	272.54	2829.0
2023-02-14 05:00:00	MSFT	Stock	272.58	273.56	272.58	273.4	7430.0
2023-02-14 05:30:00	MSFT	Stock	273.7	273.95	272.71	272.88	6138.0
2023-02-14 06:00:00	MSFT	Stock	272.89	273.3	272.89	272.93	1780.0
2023-02-14 06:30:00	MSFT	Stock	273.18	273.18	272.81	272.9	2188.0
2023-02-14 07:00:00	MSFT	Stock	273.0	273.18	272.8	272.99	20830.0
2023-02-14 07:30:00	MSFT	Stock	272.98	273.1	272.48	272.48	9626.0
2023-02-14 08:00:00	MSFT	Stock	273.17	273.9015	270.72	272.7	112121.0
2023-02-14 08:30:00	MSFT	Stock	272.31	275.0	269.8	271.9857	291226.0
2023-02-14 09:00:00	MSFT	Stock	271.81	273.0	270.69	272.7	112735.0
2023-02-14 09:30:00	MSFT	Stock	272.64	272.86	270.01	271.75	4663256.0
2023-02-14 10:00:00	MSFT	Stock	271.71	274.97	271.69	272.59	3007390.0
2023-02-14 10:30:00	MSFT	Stock	272.5628	272.86	269.28	270.83	2759987.0
2023-02-14 11:00:00	MSFT	Stock	270.81	271.92	270.24	270.5	1783593.0
2023-02-14 11:30:00	MSFT	Stock	270.56	270.85	269.51	270.6866	1658353.0
2023-02-14 12:00:00	MSFT	Stock	270.65	271.3055	270.4697	270.5792	1248229.0
2023-02-14 12:30:00	MSFT	Stock	270.605	271.18	270.19	270.95	884895.0

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

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