PREVIEW / stock_30min / 2020-04-21

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-04-21.parquet
  size:    1.8 MB
  rows:    92,551
  symbols: 2,369

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-21 04:00:00	AAPL	Stock	68.72	68.845	68.69	68.75	14712.0
2020-04-21 04:30:00	AAPL	Stock	68.725	68.75	68.725	68.75	10204.0
2020-04-21 05:00:00	AAPL	Stock	68.77	68.775	68.625	68.625	4024.0
2020-04-21 05:30:00	AAPL	Stock	68.52	68.6	68.45	68.4725	7596.0
2020-04-21 06:00:00	AAPL	Stock	68.4725	68.475	67.875	67.875	13228.0
2020-04-21 06:30:00	AAPL	Stock	67.95	68.1825	67.95	68.0175	25848.0
2020-04-21 07:00:00	AAPL	Stock	68.215	68.325	68.0125	68.18	108696.0
2020-04-21 07:30:00	AAPL	Stock	68.175	68.2	67.955	68.0375	105024.0
2020-04-21 08:00:00	AAPL	Stock	68.2275	69.47	67.8875	69.125	640312.0
2020-04-21 08:30:00	AAPL	Stock	69.125	69.62	68.5775	68.75	1135156.0
2020-04-21 09:00:00	AAPL	Stock	68.7125	69.1	68.5	69.065	505384.0
2020-04-21 09:30:00	AAPL	Stock	69.07	69.3125	67.955	68.295	20470960.0
2020-04-21 10:00:00	AAPL	Stock	68.295	68.355	67.5425	67.6637	11273724.0
2020-04-21 10:30:00	AAPL	Stock	67.6625	67.6912	66.975	67.235	10690744.0
2020-04-21 11:00:00	AAPL	Stock	67.23	67.45	66.8475	66.9525	9617116.0
2020-04-21 11:30:00	AAPL	Stock	66.95	67.0875	66.3575	66.93	10246468.0
2020-04-21 12:00:00	AAPL	Stock	66.93	66.9625	66.605	66.75	5808672.0
2020-04-21 12:30:00	AAPL	Stock	66.75	66.98	66.5855	66.974	4819516.0
2020-04-21 13:00:00	AAPL	Stock	66.9738	67.3888	66.915	67.3575	6917948.0
2020-04-21 13:30:00	AAPL	Stock	67.3575	67.5375	67.1725	67.24	5552228.0
2020-04-21 14:00:00	AAPL	Stock	67.245	67.845	67.08	67.6575	6453228.0
2020-04-21 14:30:00	AAPL	Stock	67.66	67.7125	67.03	67.2125	7846860.0
2020-04-21 15:00:00	AAPL	Stock	67.2075	67.8142	67.01	67.47	9367036.0
2020-04-21 15:30:00	AAPL	Stock	67.47	67.755	67.005	67.09	16711676.0
2020-04-21 16:00:00	AAPL	Stock	67.111	67.2925	67.0875	67.1252	14115280.0
2020-04-21 16:30:00	AAPL	Stock	67.145	67.2	67.125	67.1925	47020.0
2020-04-21 17:00:00	AAPL	Stock	67.185	67.325	67.1305	67.3	52932.0
2020-04-21 17:30:00	AAPL	Stock	67.3625	67.465	67.34	67.395	23892.0
2020-04-21 18:00:00	AAPL	Stock	67.4325	67.53	67.375	67.525	69792.0
2020-04-21 18:30:00	AAPL	Stock	67.55	67.575	67.0925	67.4025	44352.0
2020-04-21 19:00:00	AAPL	Stock	67.44	67.45	67.25	67.425	33852.0
2020-04-21 19:30:00	AAPL	Stock	67.325	67.5625	67.325	67.5625	43412.0
2020-04-21 04:00:00	MSFT	Stock	174.6	174.6	173.89	173.89	5156.0
2020-04-21 04:30:00	MSFT	Stock	174.45	174.45	174.42	174.42	200.0
2020-04-21 05:00:00	MSFT	Stock	174.45	174.45	173.89	173.89	1151.0
2020-04-21 05:30:00	MSFT	Stock	173.74	173.74	173.34	173.34	200.0
2020-04-21 06:00:00	MSFT	Stock	173.43	173.52	172.3	172.5	11017.0
2020-04-21 06:30:00	MSFT	Stock	172.5	172.99	172.5	172.7	5395.0
2020-04-21 07:00:00	MSFT	Stock	172.99	173.35	172.75	172.88	21946.0
2020-04-21 07:30:00	MSFT	Stock	172.84	173.09	172.51	173.02	17464.0
2020-04-21 08:00:00	MSFT	Stock	172.95	175.49	172.34	172.9	72311.0
2020-04-21 08:30:00	MSFT	Stock	172.9	173.0	172.5	172.52	83461.0
2020-04-21 09:00:00	MSFT	Stock	172.535	173.55	172.535	173.44	23305.0
2020-04-21 09:30:00	MSFT	Stock	173.41	173.67	170.71	172.19	6073088.0
2020-04-21 10:00:00	MSFT	Stock	172.21	172.293	170.51	170.954	3520480.0
2020-04-21 10:30:00	MSFT	Stock	170.95	171.03	166.41	166.69	5829256.0
2020-04-21 11:00:00	MSFT	Stock	166.67	167.43	166.26	166.78	3689770.0
2020-04-21 11:30:00	MSFT	Stock	166.77	167.87	166.11	167.815	2634578.0
2020-04-21 12:00:00	MSFT	Stock	167.81	168.537	167.4	167.75	2225486.0
2020-04-21 12:30:00	MSFT	Stock	167.765	167.92	167.0	167.35	1907253.0

> showing 50 of 92,551 rows — these rows as CSV

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