PREVIEW / stock_30min / 2019-12-27

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-12-27.parquet
  size:    1.7 MB
  rows:    85,608
  symbols: 2,465

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
2019-12-27 04:00:00	AAPL	Stock	72.7	72.75	72.6525	72.7125	14108.0
2019-12-27 04:30:00	AAPL	Stock	72.6875	72.725	72.675	72.675	14988.0
2019-12-27 05:00:00	AAPL	Stock	72.675	72.675	72.675	72.675	2840.0
2019-12-27 05:30:00	AAPL	Stock	72.725	72.8175	72.725	72.8125	15160.0
2019-12-27 06:00:00	AAPL	Stock	72.7625	72.8	72.76	72.76	3180.0
2019-12-27 06:30:00	AAPL	Stock	72.7525	72.795	72.7375	72.795	14548.0
2019-12-27 07:00:00	AAPL	Stock	72.7975	72.995	72.795	72.995	393060.0
2019-12-27 07:30:00	AAPL	Stock	72.9875	72.99	72.875	72.925	168792.0
2019-12-27 08:00:00	AAPL	Stock	72.925	72.9975	72.7975	72.9675	670704.0
2019-12-27 08:30:00	AAPL	Stock	72.9625	72.985	72.785	72.825	359908.0
2019-12-27 09:00:00	AAPL	Stock	72.8275	72.8875	72.4775	72.7775	345704.0
2019-12-27 09:30:00	AAPL	Stock	72.78	73.4925	72.525	72.562	29092028.0
2019-12-27 10:00:00	AAPL	Stock	72.56	73.08	72.525	72.8875	13536908.0
2019-12-27 10:30:00	AAPL	Stock	72.89	73.075	72.795	72.805	7790556.0
2019-12-27 11:00:00	AAPL	Stock	72.8125	72.9918	72.8052	72.8828	5416020.0
2019-12-27 11:30:00	AAPL	Stock	72.8852	72.945	72.6625	72.6725	5089348.0
2019-12-27 12:00:00	AAPL	Stock	72.6702	72.735	72.5525	72.6607	5658180.0
2019-12-27 12:30:00	AAPL	Stock	72.665	72.6875	72.4525	72.525	5274008.0
2019-12-27 13:00:00	AAPL	Stock	72.5275	72.545	72.0375	72.05	12158228.0
2019-12-27 13:30:00	AAPL	Stock	72.05	72.5175	72.03	72.449	6464716.0
2019-12-27 14:00:00	AAPL	Stock	72.4475	72.645	72.4275	72.54	5399808.0
2019-12-27 14:30:00	AAPL	Stock	72.5395	72.6	72.5025	72.5775	2953868.0
2019-12-27 15:00:00	AAPL	Stock	72.5773	72.61	72.345	72.395	4239620.0
2019-12-27 15:30:00	AAPL	Stock	72.3925	72.4925	72.125	72.4575	10916852.0
2019-12-27 16:00:00	AAPL	Stock	72.4575	72.485	72.4075	72.485	12218744.0
2019-12-27 16:30:00	AAPL	Stock	72.485	72.485	72.3875	72.45	94828.0
2019-12-27 17:00:00	AAPL	Stock	72.45	72.45	72.425	72.445	254416.0
2019-12-27 17:30:00	AAPL	Stock	72.4475	72.4625	72.4475	72.455	20988.0
2019-12-27 18:00:00	AAPL	Stock	72.45	72.45	72.45	72.45	21860.0
2019-12-27 18:30:00	AAPL	Stock	72.45	72.45	72.4275	72.45	21920.0
2019-12-27 19:00:00	AAPL	Stock	72.45	72.48	72.45	72.455	10468.0
2019-12-27 19:30:00	AAPL	Stock	72.46	72.5	72.4525	72.5	49496.0
2019-12-27 04:00:00	MSFT	Stock	159.25	159.3	159.2	159.2	850.0
2019-12-27 04:30:00	MSFT	Stock	159.05	159.05	159.05	159.05	103.0
2019-12-27 05:00:00	MSFT	Stock	159.29	159.29	159.29	159.29	100.0
2019-12-27 05:30:00	MSFT	Stock	159.29	159.39	159.29	159.33	1840.0
2019-12-27 06:00:00	MSFT	Stock	159.33	159.35	159.32	159.35	1279.0
2019-12-27 06:30:00	MSFT	Stock	159.35	159.38	159.35	159.38	650.0
2019-12-27 07:00:00	MSFT	Stock	159.46	159.58	159.39	159.58	8097.0
2019-12-27 07:30:00	MSFT	Stock	159.52	159.52	159.36	159.36	6164.0
2019-12-27 08:00:00	MSFT	Stock	159.4	159.55	159.33	159.5	22761.0
2019-12-27 08:30:00	MSFT	Stock	159.53	159.53	159.27	159.27	6591.0
2019-12-27 09:00:00	MSFT	Stock	159.27	159.49	158.67	159.49	32291.0
2019-12-27 09:30:00	MSFT	Stock	159.38	159.55	158.23	158.25	2305329.0
2019-12-27 10:00:00	MSFT	Stock	158.24	158.96	158.22	158.788	1276506.0
2019-12-27 10:30:00	MSFT	Stock	158.79	158.88	158.56	158.76	691563.0
2019-12-27 11:00:00	MSFT	Stock	158.76	158.93	158.714	158.893	627319.0
2019-12-27 11:30:00	MSFT	Stock	158.9	159.0	158.61	158.62	606727.0
2019-12-27 12:00:00	MSFT	Stock	158.63	158.86	158.63	158.665	423727.0
2019-12-27 12:30:00	MSFT	Stock	158.67	158.72	158.47	158.64	433708.0

> showing 50 of 85,608 rows — these rows as CSV

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