PREVIEW / stock_30min / 2021-05-14

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-05-14.parquet
  size:    2.2 MB
  rows:    109,414
  symbols: 2,966

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-05-14 04:00:00	AAPL	Stock	126.0	126.18	125.82	125.96	10600.0
2021-05-14 04:30:00	AAPL	Stock	126.0	126.33	126.0	126.3	3344.0
2021-05-14 05:00:00	AAPL	Stock	126.3	126.68	126.3	126.63	12847.0
2021-05-14 05:30:00	AAPL	Stock	126.63	126.67	126.49	126.49	3771.0
2021-05-14 06:00:00	AAPL	Stock	126.41	126.55	126.38	126.5	3103.0
2021-05-14 06:30:00	AAPL	Stock	126.55	126.55	126.4	126.45	8653.0
2021-05-14 07:00:00	AAPL	Stock	126.48	126.6	126.3	126.53	118382.0
2021-05-14 07:30:00	AAPL	Stock	126.55	126.62	126.35	126.47	93595.0
2021-05-14 08:00:00	AAPL	Stock	126.4501	126.62	126.29	126.62	211232.0
2021-05-14 08:30:00	AAPL	Stock	126.57	126.6	126.1	126.5	350432.0
2021-05-14 09:00:00	AAPL	Stock	126.5	126.7	126.27	126.27	244735.0
2021-05-14 09:30:00	AAPL	Stock	126.27	127.15	125.98	126.398	11824437.0
2021-05-14 10:00:00	AAPL	Stock	126.38	126.78	125.85	126.38	7213964.0
2021-05-14 10:30:00	AAPL	Stock	126.3812	126.76	126.21	126.76	4797001.0
2021-05-14 11:00:00	AAPL	Stock	126.755	126.79	126.5	126.5499	3665900.0
2021-05-14 11:30:00	AAPL	Stock	126.55	126.645	126.4011	126.52	3174718.0
2021-05-14 12:00:00	AAPL	Stock	126.53	126.96	126.47	126.91	3086331.0
2021-05-14 12:30:00	AAPL	Stock	126.91	127.17	126.85	127.145	3067146.0
2021-05-14 13:00:00	AAPL	Stock	127.145	127.2599	126.973	127.2276	2883949.0
2021-05-14 13:30:00	AAPL	Stock	127.225	127.285	127.03	127.22	2754873.0
2021-05-14 14:00:00	AAPL	Stock	127.21	127.44	127.15	127.31	2861935.0
2021-05-14 14:30:00	AAPL	Stock	127.32	127.7311	127.3171	127.53	3926668.0
2021-05-14 15:00:00	AAPL	Stock	127.53	127.54	127.25	127.3899	3843376.0
2021-05-14 15:30:00	AAPL	Stock	127.38	127.89	127.16	127.45	8393825.0
2021-05-14 16:00:00	AAPL	Stock	127.55	127.55	127.25	127.47	11280376.0
2021-05-14 16:30:00	AAPL	Stock	127.49	127.55	127.47	127.55	52699.0
2021-05-14 17:00:00	AAPL	Stock	127.55	127.6	127.52	127.52	36627.0
2021-05-14 17:30:00	AAPL	Stock	127.51	127.64	127.51	127.61	19722.0
2021-05-14 18:00:00	AAPL	Stock	127.61	127.64	127.55	127.58	24171.0
2021-05-14 18:30:00	AAPL	Stock	127.61	127.65	127.59	127.61	17249.0
2021-05-14 19:00:00	AAPL	Stock	127.61	127.65	127.6	127.6	19116.0
2021-05-14 19:30:00	AAPL	Stock	127.62	127.8	127.61	127.79	53436.0
2021-05-14 04:00:00	MSFT	Stock	244.64	245.23	244.64	245.23	419.0
2021-05-14 04:30:00	MSFT	Stock	245.05	245.05	245.05	245.05	259.0
2021-05-14 05:00:00	MSFT	Stock	245.47	246.6	245.47	246.6	1883.0
2021-05-14 05:30:00	MSFT	Stock	246.55	246.55	246.0	246.0	1023.0
2021-05-14 06:00:00	MSFT	Stock	246.0	246.0	245.9	246.0	1683.0
2021-05-14 06:30:00	MSFT	Stock	246.2	246.2	245.66	245.87	2889.0
2021-05-14 07:00:00	MSFT	Stock	245.75	246.05	245.31	245.83	13169.0
2021-05-14 07:30:00	MSFT	Stock	245.93	246.03	245.65	245.65	8688.0
2021-05-14 08:00:00	MSFT	Stock	245.31	245.98	245.3	245.75	19382.0
2021-05-14 08:30:00	MSFT	Stock	245.48	245.76	245.0	245.7	17189.0
2021-05-14 09:00:00	MSFT	Stock	245.36	245.88	245.36	245.66	16962.0
2021-05-14 09:30:00	MSFT	Stock	245.54	248.66	245.49	247.75	3053197.0
2021-05-14 10:00:00	MSFT	Stock	247.74	247.95	246.26	246.925	1385967.0
2021-05-14 10:30:00	MSFT	Stock	246.91	247.4699	246.385	247.3701	1107464.0
2021-05-14 11:00:00	MSFT	Stock	247.3933	247.93	247.19	247.79	880393.0
2021-05-14 11:30:00	MSFT	Stock	247.8	248.19	247.57	247.62	879055.0
2021-05-14 12:00:00	MSFT	Stock	247.61	248.13	247.48	247.9649	592362.0
2021-05-14 12:30:00	MSFT	Stock	247.97	248.37	247.89	248.29	593386.0

> showing 50 of 109,414 rows — these rows as CSV

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