PREVIEW / stock_30min / 2023-03-16

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-03-16.parquet
  size:    2.1 MB
  rows:    102,805
  symbols: 1,743

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-03-16 04:00:00	AAPL	Stock	152.88	153.44	152.85	153.25	11432.0
2023-03-16 04:30:00	AAPL	Stock	153.29	153.35	153.02	153.02	6801.0
2023-03-16 05:00:00	AAPL	Stock	153.15	153.2	152.76	153.02	5905.0
2023-03-16 05:30:00	AAPL	Stock	153.02	153.02	152.69	152.99	8146.0
2023-03-16 06:00:00	AAPL	Stock	152.94	153.03	152.84	152.93	5310.0
2023-03-16 06:30:00	AAPL	Stock	152.99	153.03	152.71	152.76	6181.0
2023-03-16 07:00:00	AAPL	Stock	152.9	152.9	152.51	152.6	10053.0
2023-03-16 07:30:00	AAPL	Stock	152.69	153.25	152.69	152.96	19390.0
2023-03-16 08:00:00	AAPL	Stock	152.55	153.22	152.28	152.9501	65458.0
2023-03-16 08:30:00	AAPL	Stock	152.9	153.163	152.11	152.55	129832.0
2023-03-16 09:00:00	AAPL	Stock	152.58	152.77	152.01	152.15	139309.0
2023-03-16 09:30:00	AAPL	Stock	152.15	153.22	151.64	153.155	5474765.0
2023-03-16 10:00:00	AAPL	Stock	153.14	153.53	152.74	153.23	3943086.0
2023-03-16 10:30:00	AAPL	Stock	153.21	154.2959	152.84	154.088	5172435.0
2023-03-16 11:00:00	AAPL	Stock	154.08	154.59	153.71	154.36	4640307.0
2023-03-16 11:30:00	AAPL	Stock	154.3867	155.49	154.05	155.2	5450738.0
2023-03-16 12:00:00	AAPL	Stock	155.18	155.34	154.28	154.81	4067675.0
2023-03-16 12:30:00	AAPL	Stock	154.81	155.2	154.36	155.1071	3836977.0
2023-03-16 13:00:00	AAPL	Stock	155.1	155.26	154.4	155.0	3092705.0
2023-03-16 13:30:00	AAPL	Stock	155.0	155.4	154.75	155.31	2543369.0
2023-03-16 14:00:00	AAPL	Stock	155.31	155.5	154.9	155.4768	2631647.0
2023-03-16 14:30:00	AAPL	Stock	155.47	155.95	155.06	155.915	3537469.0
2023-03-16 15:00:00	AAPL	Stock	155.915	156.46	155.86	156.255	4685581.0
2023-03-16 15:30:00	AAPL	Stock	156.255	156.32	155.6	155.91	8158030.0
2023-03-16 16:00:00	AAPL	Stock	155.91	155.97	155.59	155.8401	8964445.0
2023-03-16 16:30:00	AAPL	Stock	155.84	155.95	155.76	155.95	69948.0
2023-03-16 17:00:00	AAPL	Stock	155.92	155.99	155.8	155.95	19375.0
2023-03-16 17:30:00	AAPL	Stock	155.98	155.99	155.87	155.93	9727.0
2023-03-16 18:00:00	AAPL	Stock	155.88	155.88	155.69	155.69	9742.0
2023-03-16 18:30:00	AAPL	Stock	155.75	155.9	155.67	155.86	22483.0
2023-03-16 19:00:00	AAPL	Stock	155.87	155.96	155.85	155.91	16837.0
2023-03-16 19:30:00	AAPL	Stock	155.9	155.93	155.73	155.81	31204.0
2023-03-16 04:00:00	MSFT	Stock	267.0	267.28	265.8	266.3	5216.0
2023-03-16 04:30:00	MSFT	Stock	266.38	266.49	266.19	266.28	2212.0
2023-03-16 05:00:00	MSFT	Stock	266.35	266.35	265.62	266.1	5015.0
2023-03-16 05:30:00	MSFT	Stock	266.45	266.5	265.8	266.0	3621.0
2023-03-16 06:00:00	MSFT	Stock	266.07	266.16	265.76	266.16	2513.0
2023-03-16 06:30:00	MSFT	Stock	266.08	266.08	265.35	265.65	14248.0
2023-03-16 07:00:00	MSFT	Stock	265.85	265.98	265.5	265.75	26090.0
2023-03-16 07:30:00	MSFT	Stock	266.0	266.0	265.69	265.69	8857.0
2023-03-16 08:00:00	MSFT	Stock	265.9	266.5	264.777	265.793	32381.0
2023-03-16 08:30:00	MSFT	Stock	265.57	265.6888	264.84	265.4	21615.0
2023-03-16 09:00:00	MSFT	Stock	265.2754	265.9	264.54	265.19	24804.0
2023-03-16 09:30:00	MSFT	Stock	265.19	265.4	263.43	264.53	2897285.0
2023-03-16 10:00:00	MSFT	Stock	264.5438	265.0556	263.62	264.005	1595963.0
2023-03-16 10:30:00	MSFT	Stock	264.0	266.63	263.28	266.54	2221286.0
2023-03-16 11:00:00	MSFT	Stock	266.55	270.26	266.12	270.23	3182980.0
2023-03-16 11:30:00	MSFT	Stock	270.24	273.94	270.13	273.1	4884515.0
2023-03-16 12:00:00	MSFT	Stock	273.11	275.4	272.54	275.36	3203980.0
2023-03-16 12:30:00	MSFT	Stock	275.3599	276.52	274.39	275.175	3035176.0

> showing 50 of 102,805 rows — these rows as CSV

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