PREVIEW / stock_30min / 2020-07-15

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-15.parquet
  size:    2.0 MB
  rows:    99,567
  symbols: 2,454

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-07-15 04:00:00	AAPL	Stock	97.6	97.6	97.185	97.375	23588.0
2020-07-15 04:30:00	AAPL	Stock	97.475	97.5025	97.43	97.43	4100.0
2020-07-15 05:00:00	AAPL	Stock	97.425	98.375	97.425	98.375	105432.0
2020-07-15 05:30:00	AAPL	Stock	98.38	98.565	98.1275	98.25	78824.0
2020-07-15 06:00:00	AAPL	Stock	98.225	98.71	98.18	98.63	29064.0
2020-07-15 06:30:00	AAPL	Stock	98.675	98.73	98.505	98.725	33924.0
2020-07-15 07:00:00	AAPL	Stock	98.7275	99.47	98.6675	98.85	427844.0
2020-07-15 07:30:00	AAPL	Stock	98.875	98.925	98.25	98.39	272704.0
2020-07-15 08:00:00	AAPL	Stock	99.1225	99.475	98.25	98.625	962180.0
2020-07-15 08:30:00	AAPL	Stock	98.665	98.825	97.0575	98.6475	319544.0
2020-07-15 09:00:00	AAPL	Stock	98.6625	99.0	98.305	98.995	617480.0
2020-07-15 09:30:00	AAPL	Stock	98.9975	99.2475	98.0875	98.6075	20800964.0
2020-07-15 10:00:00	AAPL	Stock	98.6075	98.915	98.38	98.7225	7952184.0
2020-07-15 10:30:00	AAPL	Stock	98.7375	98.8	97.5675	97.7268	8501392.0
2020-07-15 11:00:00	AAPL	Stock	97.7375	97.815	96.845	97.6	17392904.0
2020-07-15 11:30:00	AAPL	Stock	97.595	97.715	96.7025	96.7212	10592004.0
2020-07-15 12:00:00	AAPL	Stock	96.7275	97.2725	96.49	97.2102	7820796.0
2020-07-15 12:30:00	AAPL	Stock	97.2125	97.5475	96.85	97.4525	5088472.0
2020-07-15 13:00:00	AAPL	Stock	97.46	97.8375	97.1275	97.52	6205592.0
2020-07-15 13:30:00	AAPL	Stock	97.525	97.7625	97.345	97.3882	4109364.0
2020-07-15 14:00:00	AAPL	Stock	97.385	97.9575	97.2675	97.7875	5296296.0
2020-07-15 14:30:00	AAPL	Stock	97.8	97.92	97.165	97.215	5206748.0
2020-07-15 15:00:00	AAPL	Stock	97.2175	97.585	96.9775	97.5675	5876408.0
2020-07-15 15:30:00	AAPL	Stock	97.5713	97.9175	97.47	97.7275	8262272.0
2020-07-15 16:00:00	AAPL	Stock	97.7475	97.79	97.6525	97.695	4931672.0
2020-07-15 16:30:00	AAPL	Stock	97.675	97.74	97.6725	97.7375	31560.0
2020-07-15 17:00:00	AAPL	Stock	97.74	97.75	97.6875	97.6875	32500.0
2020-07-15 17:30:00	AAPL	Stock	97.69	97.75	97.6875	97.705	6604.0
2020-07-15 18:00:00	AAPL	Stock	97.725	97.8125	97.7	97.7	121736.0
2020-07-15 18:30:00	AAPL	Stock	97.6875	97.6875	97.25	97.25	72744.0
2020-07-15 19:00:00	AAPL	Stock	97.2425	97.3725	97.125	97.325	45768.0
2020-07-15 19:30:00	AAPL	Stock	97.325	97.425	97.155	97.21	121480.0
2020-07-15 04:00:00	MSFT	Stock	209.74	209.74	208.99	209.0	3320.0
2020-07-15 04:30:00	MSFT	Stock	209.03	209.03	208.8	208.8	4042.0
2020-07-15 05:00:00	MSFT	Stock	208.7	208.8	208.35	208.53	4963.0
2020-07-15 05:30:00	MSFT	Stock	208.0	208.12	207.62	207.89	4784.0
2020-07-15 06:00:00	MSFT	Stock	207.88	209.0	207.87	208.88	7207.0
2020-07-15 06:30:00	MSFT	Stock	208.87	209.45	208.6	209.27	4729.0
2020-07-15 07:00:00	MSFT	Stock	209.13	209.6	208.61	209.28	57213.0
2020-07-15 07:30:00	MSFT	Stock	209.33	209.33	208.58	209.18	22062.0
2020-07-15 08:00:00	MSFT	Stock	209.15	209.6	208.5	209.34	71579.0
2020-07-15 08:30:00	MSFT	Stock	209.02	209.25	208.75	209.11	33195.0
2020-07-15 09:00:00	MSFT	Stock	209.14	209.84	208.75	209.77	80177.0
2020-07-15 09:30:00	MSFT	Stock	209.77	211.33	208.68	209.915	3879481.0
2020-07-15 10:00:00	MSFT	Stock	209.93	210.66	209.55	210.35	1781595.0
2020-07-15 10:30:00	MSFT	Stock	210.31	210.8	209.18	209.25	1467931.0
2020-07-15 11:00:00	MSFT	Stock	209.24	209.43	206.86	208.77	2408945.0
2020-07-15 11:30:00	MSFT	Stock	208.74	208.86	206.18	206.2	1800261.0
2020-07-15 12:00:00	MSFT	Stock	206.18	206.52	205.03	206.076	2158729.0
2020-07-15 12:30:00	MSFT	Stock	206.07	207.27	205.15	207.11	1317624.0

> showing 50 of 99,567 rows — these rows as CSV

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