PREVIEW / stock_30min / 2020-05-14

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-05-14.parquet
  size:    1.9 MB
  rows:    94,865
  symbols: 2,397

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-05-14 04:00:00	AAPL	Stock	77.0	77.0	76.9075	76.9625	4044.0
2020-05-14 04:30:00	AAPL	Stock	76.975	76.975	76.8275	76.925	28968.0
2020-05-14 05:00:00	AAPL	Stock	76.9675	77.0575	76.965	77.0575	16552.0
2020-05-14 05:30:00	AAPL	Stock	77.095	77.28	77.095	77.2525	9684.0
2020-05-14 06:00:00	AAPL	Stock	77.2	77.2	76.8	76.9125	16036.0
2020-05-14 06:30:00	AAPL	Stock	76.9575	77.0	76.7825	76.7825	20552.0
2020-05-14 07:00:00	AAPL	Stock	76.8175	77.0	76.455	76.4675	145620.0
2020-05-14 07:30:00	AAPL	Stock	76.44	76.5625	76.1275	76.1675	122232.0
2020-05-14 08:00:00	AAPL	Stock	76.9	77.0	75.9002	75.9975	338556.0
2020-05-14 08:30:00	AAPL	Stock	75.995	76.12	75.5575	75.8125	662796.0
2020-05-14 09:00:00	AAPL	Stock	75.825	76.22	75.681	76.165	597540.0
2020-05-14 09:30:00	AAPL	Stock	76.165	76.755	75.3825	75.6465	17425060.0
2020-05-14 10:00:00	AAPL	Stock	75.6625	76.144	75.425	75.45	11815940.0
2020-05-14 10:30:00	AAPL	Stock	75.4575	76.105	75.395	75.91	10821624.0
2020-05-14 11:00:00	AAPL	Stock	75.915	76.665	75.8575	76.0955	10579140.0
2020-05-14 11:30:00	AAPL	Stock	76.105	76.516	75.975	76.0625	7368304.0
2020-05-14 12:00:00	AAPL	Stock	76.0675	76.265	75.735	76.06	6834720.0
2020-05-14 12:30:00	AAPL	Stock	76.055	76.5925	76.0125	76.5188	6256888.0
2020-05-14 13:00:00	AAPL	Stock	76.5225	76.7425	76.3922	76.7288	6315152.0
2020-05-14 13:30:00	AAPL	Stock	76.7295	76.88	76.4463	76.5325	7948812.0
2020-05-14 14:00:00	AAPL	Stock	76.5225	76.625	76.245	76.625	5781856.0
2020-05-14 14:30:00	AAPL	Stock	76.6238	76.66	76.165	76.485	6994924.0
2020-05-14 15:00:00	AAPL	Stock	76.4912	77.09	76.445	76.9628	9987136.0
2020-05-14 15:30:00	AAPL	Stock	76.9625	77.4475	76.6975	77.425	14787420.0
2020-05-14 16:00:00	AAPL	Stock	77.385	77.54	76.3278	77.425	10086492.0
2020-05-14 16:30:00	AAPL	Stock	77.4525	77.6	77.385	77.475	66556.0
2020-05-14 17:00:00	AAPL	Stock	77.475	77.56	77.465	77.465	63980.0
2020-05-14 17:30:00	AAPL	Stock	77.4625	77.485	77.4	77.4	46068.0
2020-05-14 18:00:00	AAPL	Stock	77.465	77.5375	77.3325	77.5	52088.0
2020-05-14 18:30:00	AAPL	Stock	77.3875	77.45	77.31	77.3975	35168.0
2020-05-14 19:00:00	AAPL	Stock	77.3625	77.4425	77.34	77.375	7096.0
2020-05-14 19:30:00	AAPL	Stock	77.4	77.5725	77.4	77.55	162696.0
2020-05-14 04:00:00	MSFT	Stock	180.25	180.25	180.1	180.11	4419.0
2020-05-14 04:30:00	MSFT	Stock	180.01	180.01	180.0	180.0	600.0
2020-05-14 05:00:00	MSFT	Stock	180.42	180.86	180.42	180.54	1824.0
2020-05-14 05:30:00	MSFT	Stock	180.89	181.4	180.6	180.6	2543.0
2020-05-14 06:00:00	MSFT	Stock	180.4	180.4	180.25	180.25	1140.0
2020-05-14 06:30:00	MSFT	Stock	180.25	180.75	179.95	179.95	1045.0
2020-05-14 07:00:00	MSFT	Stock	180.31	180.35	179.11	179.11	12172.0
2020-05-14 07:30:00	MSFT	Stock	179.08	179.5	178.52	178.75	18775.0
2020-05-14 08:00:00	MSFT	Stock	179.26	180.305	177.8	178.15	47086.0
2020-05-14 08:30:00	MSFT	Stock	178.24	178.5	177.31	178.0	52895.0
2020-05-14 09:00:00	MSFT	Stock	178.01	178.4	177.47	177.57	48034.0
2020-05-14 09:30:00	MSFT	Stock	177.57	178.89	176.61	177.0	4031917.0
2020-05-14 10:00:00	MSFT	Stock	177.01	178.03	175.736	175.79	3385999.0
2020-05-14 10:30:00	MSFT	Stock	175.8	176.904	175.68	176.37	2596487.0
2020-05-14 11:00:00	MSFT	Stock	176.36	177.94	176.3	177.26	2669356.0
2020-05-14 11:30:00	MSFT	Stock	177.28	178.17	176.413	176.58	1930778.0
2020-05-14 12:00:00	MSFT	Stock	176.59	177.25	176.0	176.86	2095838.0
2020-05-14 12:30:00	MSFT	Stock	176.857	177.64	176.45	177.497	1507291.0

> showing 50 of 94,865 rows — these rows as CSV

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