PREVIEW / stock_30min / 2018-09-06

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-09-06.parquet
  size:    1.7 MB
  rows:    82,441
  symbols: 2,780

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-09-06 04:00:00	AAPL	Stock	56.67	56.7025	56.6	56.7	19352.0
2018-09-06 04:30:00	AAPL	Stock	56.875	56.875	56.8625	56.875	18512.0
2018-09-06 05:00:00	AAPL	Stock	56.875	57.0	56.875	57.0	21328.0
2018-09-06 05:30:00	AAPL	Stock	56.97	56.97	56.97	56.97	428.0
2018-09-06 06:00:00	AAPL	Stock	56.8025	56.8875	56.8	56.8875	7100.0
2018-09-06 06:30:00	AAPL	Stock	56.825	56.825	56.76	56.8125	11196.0
2018-09-06 07:00:00	AAPL	Stock	56.7575	56.8	56.6675	56.74	54928.0
2018-09-06 07:30:00	AAPL	Stock	56.7475	56.7925	56.7375	56.7925	43836.0
2018-09-06 08:00:00	AAPL	Stock	56.725	56.9075	56.6675	56.9075	244112.0
2018-09-06 08:30:00	AAPL	Stock	56.9075	56.9225	56.835	56.92	172280.0
2018-09-06 09:00:00	AAPL	Stock	56.92	56.925	56.555	56.5575	352140.0
2018-09-06 09:30:00	AAPL	Stock	56.5575	56.8375	56.1075	56.5825	14757836.0
2018-09-06 10:00:00	AAPL	Stock	56.5825	56.6075	56.0775	56.2525	9717772.0
2018-09-06 10:30:00	AAPL	Stock	56.2525	56.2525	55.545	55.76	17433236.0
2018-09-06 11:00:00	AAPL	Stock	55.77	55.8025	55.325	55.7175	14221544.0
2018-09-06 11:30:00	AAPL	Stock	55.7162	55.9025	55.645	55.88	8662736.0
2018-09-06 12:00:00	AAPL	Stock	55.8775	55.975	55.765	55.82	5377632.0
2018-09-06 12:30:00	AAPL	Stock	55.82	55.8725	55.66	55.6992	4818944.0
2018-09-06 13:00:00	AAPL	Stock	55.6975	55.9625	55.5825	55.7812	6149596.0
2018-09-06 13:30:00	AAPL	Stock	55.7775	55.905	55.715	55.7425	3741268.0
2018-09-06 14:00:00	AAPL	Stock	55.745	55.8362	55.6125	55.63	4990852.0
2018-09-06 14:30:00	AAPL	Stock	55.6275	55.8225	55.62	55.7275	3861452.0
2018-09-06 15:00:00	AAPL	Stock	55.7275	55.885	55.675	55.78	5742924.0
2018-09-06 15:30:00	AAPL	Stock	55.7825	55.8775	55.701	55.78	9622652.0
2018-09-06 16:00:00	AAPL	Stock	55.7775	55.8125	55.76	55.7725	6919956.0
2018-09-06 16:30:00	AAPL	Stock	55.7725	55.7825	55.6745	55.775	638716.0
2018-09-06 17:00:00	AAPL	Stock	55.775	55.8175	55.755	55.775	21132.0
2018-09-06 17:30:00	AAPL	Stock	55.8	55.855	55.8	55.825	19952.0
2018-09-06 18:00:00	AAPL	Stock	55.835	55.8475	55.8225	55.8325	12020.0
2018-09-06 18:30:00	AAPL	Stock	55.8425	55.8425	55.8175	55.825	32724.0
2018-09-06 19:00:00	AAPL	Stock	55.8375	55.855	55.8175	55.82	13608.0
2018-09-06 19:30:00	AAPL	Stock	55.82	55.875	55.8175	55.875	52136.0
2018-09-06 04:00:00	MSFT	Stock	108.5	108.6	108.5	108.6	2101.0
2018-09-06 05:30:00	MSFT	Stock	108.8	108.8	108.8	108.8	1179.0
2018-09-06 06:30:00	MSFT	Stock	108.6	108.6	108.49	108.56	2602.0
2018-09-06 07:00:00	MSFT	Stock	108.69	108.71	108.49	108.49	1760.0
2018-09-06 07:30:00	MSFT	Stock	108.47	108.63	108.46	108.48	2983.0
2018-09-06 08:00:00	MSFT	Stock	108.65	108.88	108.49	108.65	21478.0
2018-09-06 08:30:00	MSFT	Stock	108.6	108.6	108.5	108.6	8472.0
2018-09-06 09:00:00	MSFT	Stock	108.7	108.8	108.36	108.59	30673.0
2018-09-06 09:30:00	MSFT	Stock	108.56	108.99	108.25	108.7	2344249.0
2018-09-06 10:00:00	MSFT	Stock	108.71	108.78	107.817	108.185	1723424.0
2018-09-06 10:30:00	MSFT	Stock	108.18	108.18	107.51	107.82	1722917.0
2018-09-06 11:00:00	MSFT	Stock	107.82	108.175	107.52	108.05	1535487.0
2018-09-06 11:30:00	MSFT	Stock	108.06	108.435	108.01	108.29	1393028.0
2018-09-06 12:00:00	MSFT	Stock	108.27	108.36	107.95	108.19	789401.0
2018-09-06 12:30:00	MSFT	Stock	108.18	108.26	107.975	108.0	871901.0
2018-09-06 13:00:00	MSFT	Stock	108.0	108.58	107.77	108.38	947615.0
2018-09-06 13:30:00	MSFT	Stock	108.38	108.565	108.27	108.35	724212.0
2018-09-06 14:00:00	MSFT	Stock	108.345	108.51	108.06	108.12	804114.0

> showing 50 of 82,441 rows — these rows as CSV

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