PREVIEW / stock_30min / 2021-03-24

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-03-24.parquet
  size:    2.3 MB
  rows:    116,430
  symbols: 2,934

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
2021-03-24 04:00:00	AAPL	Stock	122.64	123.19	122.5	123.19	10131.0
2021-03-24 04:30:00	AAPL	Stock	123.16	123.43	123.16	123.43	6970.0
2021-03-24 05:00:00	AAPL	Stock	123.47	123.52	123.2	123.21	10303.0
2021-03-24 05:30:00	AAPL	Stock	123.25	123.4	123.25	123.39	11192.0
2021-03-24 06:00:00	AAPL	Stock	123.38	123.38	123.24	123.25	3358.0
2021-03-24 06:30:00	AAPL	Stock	123.3	123.3	123.07	123.15	2794.0
2021-03-24 07:00:00	AAPL	Stock	123.06	123.18	122.91	123.07	63252.0
2021-03-24 07:30:00	AAPL	Stock	123.06	123.09	122.95	123.039	53978.0
2021-03-24 08:00:00	AAPL	Stock	123.05	123.2	122.846	123.05	180380.0
2021-03-24 08:30:00	AAPL	Stock	123.03	123.15	122.82	122.83	90253.0
2021-03-24 09:00:00	AAPL	Stock	122.82	123.01	122.78	122.79	181668.0
2021-03-24 09:30:00	AAPL	Stock	122.79	122.9	121.605	121.63	8774972.0
2021-03-24 10:00:00	AAPL	Stock	121.635	122.02	121.11	121.4599	6890718.0
2021-03-24 10:30:00	AAPL	Stock	121.455	121.765	121.26	121.71	5028240.0
2021-03-24 11:00:00	AAPL	Stock	121.71	122.44	121.67	122.22	4707814.0
2021-03-24 11:30:00	AAPL	Stock	122.22	122.245	121.44	121.56	3776097.0
2021-03-24 12:00:00	AAPL	Stock	121.56	121.72	121.32	121.575	3576813.0
2021-03-24 12:30:00	AAPL	Stock	121.57	121.595	121.11	121.13	3749085.0
2021-03-24 13:00:00	AAPL	Stock	121.13	121.1698	120.65	121.1343	6363964.0
2021-03-24 13:30:00	AAPL	Stock	121.13	121.49	120.91	121.435	3815761.0
2021-03-24 14:00:00	AAPL	Stock	121.43	121.55	121.065	121.0943	3277727.0
2021-03-24 14:30:00	AAPL	Stock	121.09	121.21	120.522	120.56	4413833.0
2021-03-24 15:00:00	AAPL	Stock	120.565	120.8455	120.45	120.76	4530364.0
2021-03-24 15:30:00	AAPL	Stock	120.76	120.81	120.065	120.0776	10048326.0
2021-03-24 16:00:00	AAPL	Stock	120.09	120.1901	119.99	120.18	6347069.0
2021-03-24 16:30:00	AAPL	Stock	120.17	120.199	120.01	120.12	75334.0
2021-03-24 17:00:00	AAPL	Stock	120.12	120.12	120.06	120.12	36421.0
2021-03-24 17:30:00	AAPL	Stock	120.1101	120.15	120.1	120.11	24766.0
2021-03-24 18:00:00	AAPL	Stock	120.14	120.2	120.06	120.1	35426.0
2021-03-24 18:30:00	AAPL	Stock	120.14	120.29	120.1	120.21	31155.0
2021-03-24 19:00:00	AAPL	Stock	120.22	120.3	120.17	120.19	30995.0
2021-03-24 19:30:00	AAPL	Stock	120.19	120.22	120.01	120.13	104304.0
2021-03-24 04:00:00	MSFT	Stock	238.66	239.01	238.66	239.01	346.0
2021-03-24 04:30:00	MSFT	Stock	239.63	239.97	239.63	239.9	1777.0
2021-03-24 05:00:00	MSFT	Stock	240.0	240.02	239.96	239.96	425.0
2021-03-24 05:30:00	MSFT	Stock	239.95	239.96	239.95	239.96	2826.0
2021-03-24 06:00:00	MSFT	Stock	239.47	239.47	239.47	239.47	210.0
2021-03-24 06:30:00	MSFT	Stock	239.05	239.05	238.73	238.88	675.0
2021-03-24 07:00:00	MSFT	Stock	238.81	239.29	238.81	239.25	3557.0
2021-03-24 07:30:00	MSFT	Stock	239.15	239.15	238.92	238.94	13751.0
2021-03-24 08:00:00	MSFT	Stock	238.73	239.29	236.987	238.86	16839.0
2021-03-24 08:30:00	MSFT	Stock	238.86	239.0	238.55	238.67	14673.0
2021-03-24 09:00:00	MSFT	Stock	238.7	238.75	237.81	237.81	27017.0
2021-03-24 09:30:00	MSFT	Stock	237.8	238.0	235.7199	236.0	2408700.0
2021-03-24 10:00:00	MSFT	Stock	236.0	236.46	235.32	235.745	1562090.0
2021-03-24 10:30:00	MSFT	Stock	235.76	236.9	235.41	236.725	1425340.0
2021-03-24 11:00:00	MSFT	Stock	236.73	237.905	236.61	237.49	1253124.0
2021-03-24 11:30:00	MSFT	Stock	237.49	237.55	236.29	236.49	868804.0
2021-03-24 12:00:00	MSFT	Stock	236.49	236.9	236.16	236.63	707206.0
2021-03-24 12:30:00	MSFT	Stock	236.6	236.71	236.11	236.157	696513.0

> showing 50 of 116,430 rows — these rows as CSV

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