PREVIEW / stock_30min / 2020-04-13

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-04-13.parquet
  size:    1.8 MB
  rows:    93,249
  symbols: 2,382

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
2020-04-13 04:00:00	AAPL	Stock	66.375	66.45	66.1975	66.2625	15080.0
2020-04-13 04:30:00	AAPL	Stock	66.2625	66.2625	66.125	66.125	2924.0
2020-04-13 05:00:00	AAPL	Stock	66.5125	66.625	66.5125	66.625	800.0
2020-04-13 05:30:00	AAPL	Stock	66.6125	66.6225	66.425	66.4525	2812.0
2020-04-13 06:00:00	AAPL	Stock	66.5	66.5	66.5	66.5	1072.0
2020-04-13 06:30:00	AAPL	Stock	66.475	66.605	66.475	66.605	3600.0
2020-04-13 07:00:00	AAPL	Stock	66.6	66.9025	66.475	66.875	171512.0
2020-04-13 07:30:00	AAPL	Stock	66.93	67.0375	66.7825	67.0	129604.0
2020-04-13 08:00:00	AAPL	Stock	66.7032	67.275	66.5625	67.025	336532.0
2020-04-13 08:30:00	AAPL	Stock	67.0625	67.1875	67.0	67.0825	179416.0
2020-04-13 09:00:00	AAPL	Stock	67.0132	67.2575	67.0025	67.0775	248276.0
2020-04-13 09:30:00	AAPL	Stock	67.0775	67.43	66.7525	66.825	13696024.0
2020-04-13 10:00:00	AAPL	Stock	66.8325	67.286	66.805	66.9125	8086296.0
2020-04-13 10:30:00	AAPL	Stock	66.91	67.07	66.6375	66.705	6327100.0
2020-04-13 11:00:00	AAPL	Stock	66.7025	67.08	66.4575	66.9918	8046804.0
2020-04-13 11:30:00	AAPL	Stock	66.9925	67.25	66.86	66.9525	6761576.0
2020-04-13 12:00:00	AAPL	Stock	66.9525	67.275	66.9025	67.059	5780548.0
2020-04-13 12:30:00	AAPL	Stock	67.0525	67.1525	66.9225	67.0945	4183000.0
2020-04-13 13:00:00	AAPL	Stock	67.09	67.09	66.8525	67.0475	3040976.0
2020-04-13 13:30:00	AAPL	Stock	67.0475	67.395	66.989	67.366	4495732.0
2020-04-13 14:00:00	AAPL	Stock	67.3675	67.4475	67.1875	67.3512	4697556.0
2020-04-13 14:30:00	AAPL	Stock	67.355	67.5	67.2225	67.47	6250008.0
2020-04-13 15:00:00	AAPL	Stock	67.465	67.8625	67.2305	67.8575	8575224.0
2020-04-13 15:30:00	AAPL	Stock	67.855	68.425	67.775	68.3075	18138608.0
2020-04-13 16:00:00	AAPL	Stock	68.3072	68.3525	68.185	68.315	7034080.0
2020-04-13 16:30:00	AAPL	Stock	68.325	68.3475	68.25	68.3475	56140.0
2020-04-13 17:00:00	AAPL	Stock	68.335	68.335	68.2775	68.33	74120.0
2020-04-13 17:30:00	AAPL	Stock	68.3325	68.3875	68.3125	68.3875	49468.0
2020-04-13 18:00:00	AAPL	Stock	68.3875	68.5375	68.385	68.4825	106088.0
2020-04-13 18:30:00	AAPL	Stock	68.4975	68.695	68.4975	68.6325	76640.0
2020-04-13 19:00:00	AAPL	Stock	68.65	68.7375	68.575	68.6925	51976.0
2020-04-13 19:30:00	AAPL	Stock	68.7	68.71	68.6125	68.6625	120444.0
2020-04-13 04:00:00	MSFT	Stock	163.84	163.84	163.0	163.5	3086.0
2020-04-13 04:30:00	MSFT	Stock	163.3	163.3	163.21	163.21	200.0
2020-04-13 05:00:00	MSFT	Stock	163.38	163.49	163.0	163.49	2167.0
2020-04-13 05:30:00	MSFT	Stock	163.75	163.79	163.75	163.79	998.0
2020-04-13 06:00:00	MSFT	Stock	163.83	164.13	163.41	163.41	1016.0
2020-04-13 06:30:00	MSFT	Stock	163.8	164.09	163.8	164.08	1378.0
2020-04-13 07:00:00	MSFT	Stock	163.95	164.4	163.5	164.28	21694.0
2020-04-13 07:30:00	MSFT	Stock	164.3	164.9	164.3	164.73	20297.0
2020-04-13 08:00:00	MSFT	Stock	164.0	165.1	163.5	164.7	48055.0
2020-04-13 08:30:00	MSFT	Stock	164.78	165.14	164.36	164.6	28061.0
2020-04-13 09:00:00	MSFT	Stock	164.75	165.1	164.37	164.38	47663.0
2020-04-13 09:30:00	MSFT	Stock	164.35	165.5	163.35	163.555	5057768.0
2020-04-13 10:00:00	MSFT	Stock	163.58	164.55	163.11	163.59	3068848.0
2020-04-13 10:30:00	MSFT	Stock	163.57	163.785	162.89	163.37	2198995.0
2020-04-13 11:00:00	MSFT	Stock	163.36	163.36	162.3	163.14	2326593.0
2020-04-13 11:30:00	MSFT	Stock	163.15	163.4	162.58	163.004	1737109.0
2020-04-13 12:00:00	MSFT	Stock	163.01	163.49	162.87	162.99	1937893.0
2020-04-13 12:30:00	MSFT	Stock	162.988	163.15	162.53	162.71	1465326.0

> showing 50 of 93,249 rows — these rows as CSV

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