PREVIEW / stock_30min / 2018-10-08

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-08.parquet
  size:    1.7 MB
  rows:    83,602
  symbols: 2,761

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
2018-10-08 04:00:00	AAPL	Stock	55.9975	55.9975	55.805	55.805	2256.0
2018-10-08 04:30:00	AAPL	Stock	55.805	55.805	55.72	55.72	2920.0
2018-10-08 05:00:00	AAPL	Stock	55.75	55.75	55.75	55.75	1396.0
2018-10-08 05:30:00	AAPL	Stock	55.7775	55.94	55.7775	55.9375	19664.0
2018-10-08 06:00:00	AAPL	Stock	55.97	56.0	55.9	55.9125	21716.0
2018-10-08 06:30:00	AAPL	Stock	55.9175	55.9475	55.8675	55.9475	11064.0
2018-10-08 07:00:00	AAPL	Stock	55.945	56.1875	55.8275	56.125	213016.0
2018-10-08 07:30:00	AAPL	Stock	56.13	56.1725	56.03	56.09	125720.0
2018-10-08 08:00:00	AAPL	Stock	55.9462	56.1425	55.8275	56.0625	180944.0
2018-10-08 08:30:00	AAPL	Stock	56.045	56.0475	55.9	55.9375	133696.0
2018-10-08 09:00:00	AAPL	Stock	55.9625	55.9625	55.515	55.6725	519064.0
2018-10-08 09:30:00	AAPL	Stock	55.64	55.86	55.255	55.71	16113096.0
2018-10-08 10:00:00	AAPL	Stock	55.715	56.075	55.6325	55.9725	8200268.0
2018-10-08 10:30:00	AAPL	Stock	55.97	55.98	55.6175	55.78	5138004.0
2018-10-08 11:00:00	AAPL	Stock	55.78	55.8025	55.555	55.62	4882712.0
2018-10-08 11:30:00	AAPL	Stock	55.6175	55.6775	55.05	55.39	9248084.0
2018-10-08 12:00:00	AAPL	Stock	55.385	55.5575	55.1375	55.5225	5289376.0
2018-10-08 12:30:00	AAPL	Stock	55.52	55.5925	55.2225	55.2425	3743560.0
2018-10-08 13:00:00	AAPL	Stock	55.235	55.5875	55.235	55.4525	3811576.0
2018-10-08 13:30:00	AAPL	Stock	55.455	55.82	55.4425	55.6225	4504108.0
2018-10-08 14:00:00	AAPL	Stock	55.62	55.9375	55.6	55.6375	4722312.0
2018-10-08 14:30:00	AAPL	Stock	55.638	55.9025	55.638	55.8525	3609020.0
2018-10-08 15:00:00	AAPL	Stock	55.8488	56.05	55.8325	55.94	5367680.0
2018-10-08 15:30:00	AAPL	Stock	55.9425	56.2	55.9375	55.94	9785212.0
2018-10-08 16:00:00	AAPL	Stock	55.9425	56.01	55.94	55.9825	10309920.0
2018-10-08 16:30:00	AAPL	Stock	56.005	56.0125	55.985	55.985	4964.0
2018-10-08 17:00:00	AAPL	Stock	55.98	56.01	55.955	55.975	16584.0
2018-10-08 17:30:00	AAPL	Stock	55.975	55.975	55.95	55.95	24308.0
2018-10-08 18:00:00	AAPL	Stock	55.9675	55.9925	55.9675	55.9775	10756.0
2018-10-08 18:30:00	AAPL	Stock	55.9775	56.0	55.9675	55.97	14488.0
2018-10-08 19:00:00	AAPL	Stock	55.97	55.975	55.955	55.955	20148.0
2018-10-08 19:30:00	AAPL	Stock	55.96	55.96	55.95	55.96	17792.0
2018-10-08 05:00:00	MSFT	Stock	111.77	111.77	111.77	111.77	196.0
2018-10-08 05:30:00	MSFT	Stock	111.77	111.95	111.77	111.91	1849.0
2018-10-08 06:00:00	MSFT	Stock	111.97	111.97	111.97	111.97	200.0
2018-10-08 07:00:00	MSFT	Stock	111.98	112.0	111.84	111.95	4107.0
2018-10-08 07:30:00	MSFT	Stock	111.98	112.29	111.98	112.27	6261.0
2018-10-08 08:00:00	MSFT	Stock	111.81	112.35	111.81	112.14	5934.0
2018-10-08 08:30:00	MSFT	Stock	112.15	112.16	111.85	111.99	19056.0
2018-10-08 09:00:00	MSFT	Stock	111.86	112.0	111.5	111.61	43060.0
2018-10-08 09:30:00	MSFT	Stock	111.73	112.03	111.35	111.92	2864165.0
2018-10-08 10:00:00	MSFT	Stock	111.93	112.0	111.539	111.75	1720544.0
2018-10-08 10:30:00	MSFT	Stock	111.76	111.885	111.15	111.5	908678.0
2018-10-08 11:00:00	MSFT	Stock	111.5	111.505	110.8	110.83	1449126.0
2018-10-08 11:30:00	MSFT	Stock	110.83	110.875	109.34	110.44	3767893.0
2018-10-08 12:00:00	MSFT	Stock	110.44	110.45	109.65	110.229	1445581.0
2018-10-08 12:30:00	MSFT	Stock	110.225	110.285	109.51	109.57	1143733.0
2018-10-08 13:00:00	MSFT	Stock	109.57	110.158	109.52	109.95	1269534.0
2018-10-08 13:30:00	MSFT	Stock	109.945	110.73	109.945	110.398	1231873.0
2018-10-08 14:00:00	MSFT	Stock	110.4	110.8	110.39	110.56	1415020.0

> showing 50 of 83,602 rows — these rows as CSV

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