PREVIEW / stock_30min / 2020-04-14

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-04-14.parquet
  size:    1.9 MB
  rows:    94,619
  symbols: 2,422

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-14 04:00:00	AAPL	Stock	69.375	69.4375	69.0775	69.4375	46228.0
2020-04-14 04:30:00	AAPL	Stock	69.4375	69.5	69.3325	69.4	19164.0
2020-04-14 05:00:00	AAPL	Stock	69.45	69.7975	69.4175	69.7975	39872.0
2020-04-14 05:30:00	AAPL	Stock	69.68	69.8125	69.6	69.75	8368.0
2020-04-14 06:00:00	AAPL	Stock	69.75	69.75	69.625	69.75	21588.0
2020-04-14 06:30:00	AAPL	Stock	69.7125	69.725	69.4325	69.46	23800.0
2020-04-14 07:00:00	AAPL	Stock	69.5925	69.5925	69.2725	69.435	298012.0
2020-04-14 07:30:00	AAPL	Stock	69.415	69.5875	69.325	69.575	238968.0
2020-04-14 08:00:00	AAPL	Stock	69.4	69.7175	69.3175	69.7025	415980.0
2020-04-14 08:30:00	AAPL	Stock	69.7175	69.8125	69.655	69.79	409920.0
2020-04-14 09:00:00	AAPL	Stock	69.775	70.005	69.775	70.005	614176.0
2020-04-14 09:30:00	AAPL	Stock	70.0025	71.495	69.5125	71.47	29896932.0
2020-04-14 10:00:00	AAPL	Stock	71.4738	71.55	70.9	71.1875	17021868.0
2020-04-14 10:30:00	AAPL	Stock	71.1815	71.4125	71.025	71.0465	11240232.0
2020-04-14 11:00:00	AAPL	Stock	71.0475	71.23	70.6575	70.975	10597524.0
2020-04-14 11:30:00	AAPL	Stock	70.9675	71.205	70.965	71.0642	6727852.0
2020-04-14 12:00:00	AAPL	Stock	71.07	71.5775	71.07	71.4275	8361076.0
2020-04-14 12:30:00	AAPL	Stock	71.4275	71.6338	71.3862	71.5	7163536.0
2020-04-14 13:00:00	AAPL	Stock	71.5025	71.585	71.315	71.58	5119648.0
2020-04-14 13:30:00	AAPL	Stock	71.5825	71.9325	71.5625	71.8225	8001516.0
2020-04-14 14:00:00	AAPL	Stock	71.8275	72.01	71.76	71.91	5662648.0
2020-04-14 14:30:00	AAPL	Stock	71.91	72.0	71.6725	71.95	6518108.0
2020-04-14 15:00:00	AAPL	Stock	71.95	71.95	71.4175	71.7475	9231608.0
2020-04-14 15:30:00	AAPL	Stock	71.7375	72.0625	71.5537	71.7675	15857940.0
2020-04-14 16:00:00	AAPL	Stock	71.7625	71.85	70.855	71.825	15137408.0
2020-04-14 16:30:00	AAPL	Stock	71.8025	72.05	71.775	72.035	159388.0
2020-04-14 17:00:00	AAPL	Stock	72.0275	72.0275	71.8025	71.82	167328.0
2020-04-14 17:30:00	AAPL	Stock	71.85	71.9125	71.85	71.8725	57368.0
2020-04-14 18:00:00	AAPL	Stock	71.875	71.875	71.775	71.86	95944.0
2020-04-14 18:30:00	AAPL	Stock	71.86	71.99	71.855	71.945	81264.0
2020-04-14 19:00:00	AAPL	Stock	71.925	71.97	71.5825	71.65	174084.0
2020-04-14 19:30:00	AAPL	Stock	71.65	71.65	71.355	71.475	140424.0
2020-04-14 04:00:00	MSFT	Stock	168.11	168.5	167.12	167.92	25970.0
2020-04-14 04:30:00	MSFT	Stock	168.0	168.32	168.0	168.26	9746.0
2020-04-14 05:00:00	MSFT	Stock	168.0	168.6	167.9	168.6	11555.0
2020-04-14 05:30:00	MSFT	Stock	168.6	168.7	168.5	168.69	7818.0
2020-04-14 06:00:00	MSFT	Stock	168.6	168.9	168.5	168.9	10466.0
2020-04-14 06:30:00	MSFT	Stock	168.9	168.9	168.25	168.79	9899.0
2020-04-14 07:00:00	MSFT	Stock	168.6	168.78	167.9	168.2	50427.0
2020-04-14 07:30:00	MSFT	Stock	168.21	168.6	168.0	168.58	33281.0
2020-04-14 08:00:00	MSFT	Stock	168.26	169.95	165.92	169.11	159244.0
2020-04-14 08:30:00	MSFT	Stock	169.32	169.32	168.55	168.79	91930.0
2020-04-14 09:00:00	MSFT	Stock	168.79	169.5	168.702	169.0	107791.0
2020-04-14 09:30:00	MSFT	Stock	169.0	170.71	168.0	170.658	6401783.0
2020-04-14 10:00:00	MSFT	Stock	170.66	170.82	169.93	170.737	3362470.0
2020-04-14 10:30:00	MSFT	Stock	170.73	171.02	170.31	170.65	2719442.0
2020-04-14 11:00:00	MSFT	Stock	170.66	171.0	170.15	170.49	2885068.0
2020-04-14 11:30:00	MSFT	Stock	170.49	171.19	170.49	170.99	2346378.0
2020-04-14 12:00:00	MSFT	Stock	170.995	172.07	170.995	171.85	2512938.0
2020-04-14 12:30:00	MSFT	Stock	171.86	172.969	171.6	172.73	2308120.0

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

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