PREVIEW / stock_30min / 2020-04-27

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-04-27.parquet
  size:    1.9 MB
  rows:    94,678
  symbols: 2,398

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-27 04:00:00	AAPL	Stock	71.35	71.625	71.35	71.5075	22104.0
2020-04-27 04:30:00	AAPL	Stock	71.45	71.525	71.45	71.525	3024.0
2020-04-27 05:00:00	AAPL	Stock	71.5	71.6	71.5	71.6	10624.0
2020-04-27 05:30:00	AAPL	Stock	71.53	71.65	71.4975	71.4975	9360.0
2020-04-27 06:00:00	AAPL	Stock	71.575	71.575	71.4375	71.4375	9856.0
2020-04-27 06:30:00	AAPL	Stock	71.4975	71.4975	70.65	70.75	166192.0
2020-04-27 07:00:00	AAPL	Stock	70.79	71.2925	70.565	71.125	477552.0
2020-04-27 07:30:00	AAPL	Stock	71.1325	71.2125	71.0875	71.125	146840.0
2020-04-27 08:00:00	AAPL	Stock	70.665	71.25	70.655	70.9275	467684.0
2020-04-27 08:30:00	AAPL	Stock	70.925	71.0625	70.7575	70.7575	325112.0
2020-04-27 09:00:00	AAPL	Stock	70.7575	70.875	70.4	70.4575	755620.0
2020-04-27 09:30:00	AAPL	Stock	70.4575	71.0575	69.9875	71.0475	17960700.0
2020-04-27 10:00:00	AAPL	Stock	71.0425	71.135	70.6625	70.785	9283640.0
2020-04-27 10:30:00	AAPL	Stock	70.7875	70.81	70.2625	70.3425	8037816.0
2020-04-27 11:00:00	AAPL	Stock	70.3375	70.8288	70.1775	70.7775	7162468.0
2020-04-27 11:30:00	AAPL	Stock	70.7775	70.8325	70.5275	70.5578	4486964.0
2020-04-27 12:00:00	AAPL	Stock	70.56	70.615	70.275	70.4375	5339700.0
2020-04-27 12:30:00	AAPL	Stock	70.4425	70.605	70.37	70.45	3320900.0
2020-04-27 13:00:00	AAPL	Stock	70.4515	70.455	70.088	70.2625	4284008.0
2020-04-27 13:30:00	AAPL	Stock	70.265	70.4925	70.14	70.4298	3887228.0
2020-04-27 14:00:00	AAPL	Stock	70.4238	70.6625	70.4238	70.615	3569184.0
2020-04-27 14:30:00	AAPL	Stock	70.6212	70.755	70.5875	70.6465	4520612.0
2020-04-27 15:00:00	AAPL	Stock	70.65	70.795	70.5825	70.6388	5179416.0
2020-04-27 15:30:00	AAPL	Stock	70.6475	70.905	70.6025	70.8125	9580872.0
2020-04-27 16:00:00	AAPL	Stock	70.79	70.7925	70.621	70.7275	6833352.0
2020-04-27 16:30:00	AAPL	Stock	70.7125	70.7925	70.6875	70.7	33456.0
2020-04-27 17:00:00	AAPL	Stock	70.7	70.7275	70.6875	70.6875	18256.0
2020-04-27 17:30:00	AAPL	Stock	70.6875	70.75	70.6875	70.75	10116.0
2020-04-27 18:00:00	AAPL	Stock	70.7525	70.8375	70.73	70.8375	44024.0
2020-04-27 18:30:00	AAPL	Stock	70.8275	70.8725	70.8	70.825	40464.0
2020-04-27 19:00:00	AAPL	Stock	70.815	70.9125	70.815	70.9125	20472.0
2020-04-27 19:30:00	AAPL	Stock	70.9	70.91	70.8025	70.8475	22292.0
2020-04-27 04:00:00	MSFT	Stock	176.55	176.85	176.11	176.69	5306.0
2020-04-27 04:30:00	MSFT	Stock	176.7	177.0	176.7	177.0	2015.0
2020-04-27 05:00:00	MSFT	Stock	176.81	176.99	176.77	176.99	700.0
2020-04-27 05:30:00	MSFT	Stock	177.1	177.2	176.8	177.09	1658.0
2020-04-27 06:00:00	MSFT	Stock	176.8	177.0	176.76	176.93	4366.0
2020-04-27 06:30:00	MSFT	Stock	176.7	176.75	176.5	176.6	6804.0
2020-04-27 07:00:00	MSFT	Stock	176.59	176.8	176.15	176.55	25214.0
2020-04-27 07:30:00	MSFT	Stock	176.65	176.95	176.6	176.82	13616.0
2020-04-27 08:00:00	MSFT	Stock	176.5	176.95	176.2	176.7	76214.0
2020-04-27 08:30:00	MSFT	Stock	176.7	176.94	176.6	176.7	42990.0
2020-04-27 09:00:00	MSFT	Stock	176.8	177.04	176.5	176.75	77399.0
2020-04-27 09:30:00	MSFT	Stock	176.66	176.9	175.37	176.03	3867947.0
2020-04-27 10:00:00	MSFT	Stock	176.035	176.19	175.23	175.36	2225550.0
2020-04-27 10:30:00	MSFT	Stock	175.36	175.48	174.26	174.339	2104305.0
2020-04-27 11:00:00	MSFT	Stock	174.32	175.61	174.05	175.517	1944209.0
2020-04-27 11:30:00	MSFT	Stock	175.5	175.79	175.02	175.144	1556103.0
2020-04-27 12:00:00	MSFT	Stock	175.15	175.25	174.15	174.3	1796066.0
2020-04-27 12:30:00	MSFT	Stock	174.29	174.87	173.3	174.07	1737286.0

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

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