PREVIEW / stock_30min / 2020-04-30

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-04-30.parquet
  size:    1.9 MB
  rows:    96,815
  symbols: 2,387

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-30 04:00:00	AAPL	Stock	73.375	73.375	72.975	72.9775	14484.0
2020-04-30 04:30:00	AAPL	Stock	73.0	73.075	72.775	72.775	13608.0
2020-04-30 05:00:00	AAPL	Stock	72.775	72.925	72.775	72.925	12684.0
2020-04-30 05:30:00	AAPL	Stock	72.9975	73.0	72.9875	73.0	7316.0
2020-04-30 06:00:00	AAPL	Stock	73.0	73.075	72.75	72.75	15208.0
2020-04-30 06:30:00	AAPL	Stock	72.8	72.8	72.44	72.5	17640.0
2020-04-30 07:00:00	AAPL	Stock	72.575	72.8425	72.5	72.6425	192696.0
2020-04-30 07:30:00	AAPL	Stock	72.645	72.875	72.55	72.55	140572.0
2020-04-30 08:00:00	AAPL	Stock	72.7645	72.875	72.5	72.7	377704.0
2020-04-30 08:30:00	AAPL	Stock	72.7	72.8	72.0775	72.13	432780.0
2020-04-30 09:00:00	AAPL	Stock	72.13	72.5	71.8025	72.49	556832.0
2020-04-30 09:30:00	AAPL	Stock	72.49	73.33	72.0875	73.095	19039124.0
2020-04-30 10:00:00	AAPL	Stock	73.1	73.2675	72.5888	73.0488	10581712.0
2020-04-30 10:30:00	AAPL	Stock	73.0525	73.1112	72.5875	72.885	7061180.0
2020-04-30 11:00:00	AAPL	Stock	72.895	73.105	72.7275	72.7648	4829724.0
2020-04-30 11:30:00	AAPL	Stock	72.7575	72.85	72.55	72.5525	5701260.0
2020-04-30 12:00:00	AAPL	Stock	72.5575	72.5923	72.22	72.3725	7622820.0
2020-04-30 12:30:00	AAPL	Stock	72.365	72.67	72.195	72.6125	4734764.0
2020-04-30 13:00:00	AAPL	Stock	72.6175	72.745	72.4695	72.6375	4102404.0
2020-04-30 13:30:00	AAPL	Stock	72.635	72.8625	72.6	72.7275	4974100.0
2020-04-30 14:00:00	AAPL	Stock	72.7325	72.81	72.5925	72.7932	4639800.0
2020-04-30 14:30:00	AAPL	Stock	72.79	72.9575	72.66	72.7325	7498896.0
2020-04-30 15:00:00	AAPL	Stock	72.735	73.125	72.7185	72.9788	8497112.0
2020-04-30 15:30:00	AAPL	Stock	72.9795	73.6325	72.75	73.4975	21787836.0
2020-04-30 16:00:00	AAPL	Stock	73.4975	73.52	72.5	72.675	12628700.0
2020-04-30 16:30:00	AAPL	Stock	72.675	75.3698	71.8625	72.0625	14102964.0
2020-04-30 17:00:00	AAPL	Stock	72.0925	72.8	71.865	72.2	2572116.0
2020-04-30 17:30:00	AAPL	Stock	72.25	72.5625	71.5	71.5625	1389780.0
2020-04-30 18:00:00	AAPL	Stock	71.5625	71.745	71.1875	71.685	836864.0
2020-04-30 18:30:00	AAPL	Stock	71.685	71.8375	71.5	71.6475	276700.0
2020-04-30 19:00:00	AAPL	Stock	71.625	71.625	71.5075	71.5075	164088.0
2020-04-30 19:30:00	AAPL	Stock	71.5075	71.615	71.5	71.575	343228.0
2020-04-30 04:00:00	MSFT	Stock	181.35	182.0	181.09	181.54	6997.0
2020-04-30 04:30:00	MSFT	Stock	181.8	182.21	181.8	181.82	5786.0
2020-04-30 05:00:00	MSFT	Stock	181.6	182.0	181.6	181.9	1488.0
2020-04-30 05:30:00	MSFT	Stock	181.9	182.0	181.66	181.66	3116.0
2020-04-30 06:00:00	MSFT	Stock	181.75	182.15	181.5	182.01	5228.0
2020-04-30 06:30:00	MSFT	Stock	182.15	182.15	180.34	180.8	6980.0
2020-04-30 07:00:00	MSFT	Stock	180.8	181.3	179.4	180.02	71190.0
2020-04-30 07:30:00	MSFT	Stock	180.05	181.19	180.0	180.75	109392.0
2020-04-30 08:00:00	MSFT	Stock	181.0	181.28	179.6	180.0	172309.0
2020-04-30 08:30:00	MSFT	Stock	179.92	180.19	179.01	179.5	221339.0
2020-04-30 09:00:00	MSFT	Stock	179.5	180.8	178.0	179.98	330333.0
2020-04-30 09:30:00	MSFT	Stock	180.0	180.4	176.23	178.999	10870228.0
2020-04-30 10:00:00	MSFT	Stock	178.995	179.57	178.224	179.289	4132698.0
2020-04-30 10:30:00	MSFT	Stock	179.3	179.55	178.38	179.04	2560596.0
2020-04-30 11:00:00	MSFT	Stock	179.06	179.75	179.06	179.32	2439342.0
2020-04-30 11:30:00	MSFT	Stock	179.31	179.39	177.518	177.57	2538084.0
2020-04-30 12:00:00	MSFT	Stock	177.56	177.8	176.85	177.66	2402414.0
2020-04-30 12:30:00	MSFT	Stock	177.655	178.4	177.16	178.37	1668451.0

> showing 50 of 96,815 rows — these rows as CSV

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