PREVIEW / stock_30min / 2023-03-21

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-03-21.parquet
  size:    2.1 MB
  rows:    102,463
  symbols: 1,776

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-21 04:00:00	AAPL	Stock	157.45	157.69	157.25	157.46	6591.0
2023-03-21 04:30:00	AAPL	Stock	157.54	157.55	157.19	157.2	6651.0
2023-03-21 05:00:00	AAPL	Stock	157.2	157.24	157.01	157.06	5556.0
2023-03-21 05:30:00	AAPL	Stock	157.06	157.28	156.73	157.13	10381.0
2023-03-21 06:00:00	AAPL	Stock	157.22	157.46	157.0	157.4	12940.0
2023-03-21 06:30:00	AAPL	Stock	157.32	157.35	157.09	157.14	4258.0
2023-03-21 07:00:00	AAPL	Stock	157.14	157.57	157.03	157.57	41662.0
2023-03-21 07:30:00	AAPL	Stock	157.62	157.76	157.36	157.52	26456.0
2023-03-21 08:00:00	AAPL	Stock	157.4592	157.73	156.97	157.32	157873.0
2023-03-21 08:30:00	AAPL	Stock	157.33	157.33	157.03	157.15	85858.0
2023-03-21 09:00:00	AAPL	Stock	157.1	157.32	156.93	157.25	168917.0
2023-03-21 09:30:00	AAPL	Stock	157.28	158.39	157.0	157.65	7946080.0
2023-03-21 10:00:00	AAPL	Stock	157.66	157.97	157.09	157.385	4625149.0
2023-03-21 10:30:00	AAPL	Stock	157.385	157.4185	156.54	156.905	3605381.0
2023-03-21 11:00:00	AAPL	Stock	156.91	157.69	156.851	157.56	3811069.0
2023-03-21 11:30:00	AAPL	Stock	157.57	157.65	157.045	157.43	3257057.0
2023-03-21 12:00:00	AAPL	Stock	157.43	158.1	157.35	157.99	2779831.0
2023-03-21 12:30:00	AAPL	Stock	157.99	158.29	157.65	158.1933	2702388.0
2023-03-21 13:00:00	AAPL	Stock	158.2	158.82	158.08	158.685	3387990.0
2023-03-21 13:30:00	AAPL	Stock	158.69	159.1	158.595	158.6	3226630.0
2023-03-21 14:00:00	AAPL	Stock	158.6099	158.75	158.33	158.475	2386112.0
2023-03-21 14:30:00	AAPL	Stock	158.48	159.0	158.41	158.8999	2717470.0
2023-03-21 15:00:00	AAPL	Stock	158.89	159.06	158.6	158.915	3530732.0
2023-03-21 15:30:00	AAPL	Stock	158.92	159.4	158.7701	159.4	6506029.0
2023-03-21 16:00:00	AAPL	Stock	159.38	159.38	159.16	159.28	14882650.0
2023-03-21 16:30:00	AAPL	Stock	159.25	159.28	159.19	159.21	38191.0
2023-03-21 17:00:00	AAPL	Stock	159.19	159.21	158.86	159.02	36866.0
2023-03-21 17:30:00	AAPL	Stock	159.04	159.04	158.86	158.86	12280.0
2023-03-21 18:00:00	AAPL	Stock	158.95	159.0	158.89	159.0	9966.0
2023-03-21 18:30:00	AAPL	Stock	158.9601	159.05	158.94	159.05	4530.0
2023-03-21 19:00:00	AAPL	Stock	159.05	159.27	159.02	159.21	19327.0
2023-03-21 19:30:00	AAPL	Stock	159.21	159.24	158.94	158.97	18490.0
2023-03-21 04:00:00	MSFT	Stock	272.42	272.79	272.3	272.58	2405.0
2023-03-21 04:30:00	MSFT	Stock	272.59	272.59	272.21	272.59	1554.0
2023-03-21 05:00:00	MSFT	Stock	272.51	272.51	272.11	272.14	2332.0
2023-03-21 05:30:00	MSFT	Stock	272.16	272.22	271.6	271.79	3891.0
2023-03-21 06:00:00	MSFT	Stock	271.79	272.96	271.0	272.21	14241.0
2023-03-21 06:30:00	MSFT	Stock	272.5	272.8	271.46	271.5	9585.0
2023-03-21 07:00:00	MSFT	Stock	271.5	273.5	271.4	273.5	19355.0
2023-03-21 07:30:00	MSFT	Stock	273.37	273.89	273.37	273.5	29368.0
2023-03-21 08:00:00	MSFT	Stock	273.5	273.8	271.35	272.79	79366.0
2023-03-21 08:30:00	MSFT	Stock	272.7	273.78	272.69	273.6	57006.0
2023-03-21 09:00:00	MSFT	Stock	273.59	275.4	273.49	274.76	93849.0
2023-03-21 09:30:00	MSFT	Stock	274.89	275.0	272.81	273.8762	2675615.0
2023-03-21 10:00:00	MSFT	Stock	273.89	274.34	270.17	270.36	2367288.0
2023-03-21 10:30:00	MSFT	Stock	270.365	271.04	269.5191	270.8801	2054592.0
2023-03-21 11:00:00	MSFT	Stock	270.9	271.5	270.43	270.68	1354127.0
2023-03-21 11:30:00	MSFT	Stock	270.68	271.1145	269.68	270.23	1317050.0
2023-03-21 12:00:00	MSFT	Stock	270.24	271.77	270.04	271.51	1048803.0
2023-03-21 12:30:00	MSFT	Stock	271.52	272.04	271.18	271.88	1102804.0

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

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