PREVIEW / stock_30min / 2023-02-16

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-02-16.parquet
  size:    2.1 MB
  rows:    103,113
  symbols: 1,882

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-16 04:00:00	AAPL	Stock	155.41	155.41	155.09	155.15	10422.0
2023-02-16 04:30:00	AAPL	Stock	155.2	155.2	155.02	155.03	11269.0
2023-02-16 05:00:00	AAPL	Stock	155.02	155.1	155.0	155.1	2085.0
2023-02-16 05:30:00	AAPL	Stock	155.15	155.2	155.1	155.1	3086.0
2023-02-16 06:00:00	AAPL	Stock	155.06	155.29	155.06	155.22	12739.0
2023-02-16 06:30:00	AAPL	Stock	155.26	155.33	155.2	155.3	12268.0
2023-02-16 07:00:00	AAPL	Stock	155.29	155.42	154.85	154.9	30160.0
2023-02-16 07:30:00	AAPL	Stock	154.9	154.97	154.9	154.94	2856.0
2023-02-16 08:00:00	AAPL	Stock	154.93	155.7	154.6414	154.75	111151.0
2023-02-16 08:30:00	AAPL	Stock	154.68	154.68	153.1	153.49	277039.0
2023-02-16 09:00:00	AAPL	Stock	153.46	153.78	153.02	153.3	235219.0
2023-02-16 09:30:00	AAPL	Stock	153.43	154.6571	153.3475	154.08	7098539.0
2023-02-16 10:00:00	AAPL	Stock	154.075	154.925	153.8	154.75	4213771.0
2023-02-16 10:30:00	AAPL	Stock	154.745	155.22	154.56	155.15	3458522.0
2023-02-16 11:00:00	AAPL	Stock	155.16	155.46	154.8889	155.2499	3274872.0
2023-02-16 11:30:00	AAPL	Stock	155.25	155.5	155.01	155.07	2468242.0
2023-02-16 12:00:00	AAPL	Stock	155.065	155.5	154.75	155.41	2607586.0
2023-02-16 12:30:00	AAPL	Stock	155.4195	156.17	155.36	155.93	3356652.0
2023-02-16 13:00:00	AAPL	Stock	155.94	156.19	155.535	155.8499	2847489.0
2023-02-16 13:30:00	AAPL	Stock	155.86	156.151	155.76	155.95	1947499.0
2023-02-16 14:00:00	AAPL	Stock	155.95	156.24	155.72	156.1474	2470022.0
2023-02-16 14:30:00	AAPL	Stock	156.145	156.33	156.06	156.19	2433197.0
2023-02-16 15:00:00	AAPL	Stock	156.2	156.2499	154.3	154.32	4347967.0
2023-02-16 15:30:00	AAPL	Stock	154.31	154.4	153.59	153.69	6599036.0
2023-02-16 16:00:00	AAPL	Stock	153.71	153.73	153.06	153.1	8713516.0
2023-02-16 16:30:00	AAPL	Stock	153.0601	153.71	153.0601	153.27	78563.0
2023-02-16 17:00:00	AAPL	Stock	153.29	153.29	153.2	153.25	29349.0
2023-02-16 17:30:00	AAPL	Stock	153.27	153.32	153.23	153.27	15906.0
2023-02-16 18:00:00	AAPL	Stock	153.3	153.38	152.8	152.88	88433.0
2023-02-16 18:30:00	AAPL	Stock	152.9	153.0	152.75	152.98	14809.0
2023-02-16 19:00:00	AAPL	Stock	152.97	153.08	152.88	152.91	16929.0
2023-02-16 19:30:00	AAPL	Stock	152.95	153.01	152.81	152.81	22457.0
2023-02-16 04:00:00	MSFT	Stock	270.08	270.33	269.95	270.25	1876.0
2023-02-16 04:30:00	MSFT	Stock	270.39	270.39	270.0	270.0	2818.0
2023-02-16 05:00:00	MSFT	Stock	269.83	269.92	269.69	269.91	621.0
2023-02-16 05:30:00	MSFT	Stock	269.98	270.0	269.96	270.0	1202.0
2023-02-16 06:00:00	MSFT	Stock	270.0	270.0	268.61	268.61	4339.0
2023-02-16 06:30:00	MSFT	Stock	268.92	268.92	268.41	268.41	8084.0
2023-02-16 07:00:00	MSFT	Stock	268.75	269.19	268.1	268.3	10654.0
2023-02-16 07:30:00	MSFT	Stock	268.5	268.55	268.47	268.52	3652.0
2023-02-16 08:00:00	MSFT	Stock	269.12	270.91	267.8001	268.0	38057.0
2023-02-16 08:30:00	MSFT	Stock	267.78	267.79	264.51	265.031	88448.0
2023-02-16 09:00:00	MSFT	Stock	265.03	265.5	264.0	264.02	103570.0
2023-02-16 09:30:00	MSFT	Stock	264.08	265.15	263.1	264.37	3499557.0
2023-02-16 10:00:00	MSFT	Stock	264.35	266.18	264.07	265.81	1570483.0
2023-02-16 10:30:00	MSFT	Stock	265.785	266.74	265.37	265.74	1133567.0
2023-02-16 11:00:00	MSFT	Stock	265.8	266.29	264.82	265.1899	1017281.0
2023-02-16 11:30:00	MSFT	Stock	265.185	265.55	264.72	264.83	944876.0
2023-02-16 12:00:00	MSFT	Stock	264.825	265.46	264.43	265.28	745229.0
2023-02-16 12:30:00	MSFT	Stock	265.29	266.41	265.22	265.9608	735323.0

> showing 50 of 103,113 rows — these rows as CSV

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