PREVIEW / stock_30min / 2019-01-30

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-01-30.parquet
  size:    1.7 MB
  rows:    84,819
  symbols: 2,691

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-01-30 04:00:00	AAPL	Stock	40.825	40.825	40.6125	40.75	98924.0
2019-01-30 04:30:00	AAPL	Stock	40.75	40.75	40.6075	40.6275	64624.0
2019-01-30 05:00:00	AAPL	Stock	40.625	40.8375	40.625	40.8	69668.0
2019-01-30 05:30:00	AAPL	Stock	40.85	40.9225	40.825	40.825	105944.0
2019-01-30 06:00:00	AAPL	Stock	40.8375	40.875	40.75	40.75	121276.0
2019-01-30 06:30:00	AAPL	Stock	40.7625	40.875	40.75	40.8	77940.0
2019-01-30 07:00:00	AAPL	Stock	40.85	40.875	40.6425	40.725	545368.0
2019-01-30 07:30:00	AAPL	Stock	40.725	40.83	40.65	40.675	496804.0
2019-01-30 08:00:00	AAPL	Stock	40.6975	40.875	40.37	40.4025	1751232.0
2019-01-30 08:30:00	AAPL	Stock	40.42	40.5675	40.2775	40.5025	1147188.0
2019-01-30 09:00:00	AAPL	Stock	40.5	40.845	40.49	40.8175	2267504.0
2019-01-30 09:30:00	AAPL	Stock	40.8125	40.8325	40.165	40.1945	40641860.0
2019-01-30 10:00:00	AAPL	Stock	40.1938	40.5705	40.0575	40.5225	20418592.0
2019-01-30 10:30:00	AAPL	Stock	40.5325	40.67	40.45	40.635	13792772.0
2019-01-30 11:00:00	AAPL	Stock	40.6375	40.7838	40.5875	40.665	14076484.0
2019-01-30 11:30:00	AAPL	Stock	40.6625	40.675	40.4625	40.576	9183384.0
2019-01-30 12:00:00	AAPL	Stock	40.5775	40.62	40.475	40.58	8532836.0
2019-01-30 12:30:00	AAPL	Stock	40.578	40.75	40.495	40.7138	9863996.0
2019-01-30 13:00:00	AAPL	Stock	40.7138	40.8125	40.605	40.735	8392912.0
2019-01-30 13:30:00	AAPL	Stock	40.738	40.8	40.695	40.755	6296036.0
2019-01-30 14:00:00	AAPL	Stock	40.7575	41.2525	40.7475	41.2175	22210888.0
2019-01-30 14:30:00	AAPL	Stock	41.215	41.5375	41.115	41.5125	15316724.0
2019-01-30 15:00:00	AAPL	Stock	41.52	41.5225	41.265	41.395	13143768.0
2019-01-30 15:30:00	AAPL	Stock	41.3955	41.4	40.95	41.31	20510720.0
2019-01-30 16:00:00	AAPL	Stock	41.3125	41.4375	41.25	41.3125	10838936.0
2019-01-30 16:30:00	AAPL	Stock	41.3875	41.445	41.3625	41.425	103496.0
2019-01-30 17:00:00	AAPL	Stock	41.42	41.465	41.35	41.375	128204.0
2019-01-30 17:30:00	AAPL	Stock	41.3775	41.3925	41.3125	41.345	76916.0
2019-01-30 18:00:00	AAPL	Stock	41.3475	41.425	41.325	41.3875	49116.0
2019-01-30 18:30:00	AAPL	Stock	41.395	41.4375	41.3875	41.4375	69176.0
2019-01-30 19:00:00	AAPL	Stock	41.4375	41.4375	41.3725	41.3725	68232.0
2019-01-30 19:30:00	AAPL	Stock	41.38	41.3875	41.355	41.375	36924.0
2019-01-30 04:00:00	MSFT	Stock	103.8	103.8	103.8	103.8	200.0
2019-01-30 04:30:00	MSFT	Stock	104.05	104.05	103.93	103.95	1016.0
2019-01-30 05:00:00	MSFT	Stock	103.93	104.0	103.74	103.81	7910.0
2019-01-30 05:30:00	MSFT	Stock	103.9	104.01	103.8	103.97	1881.0
2019-01-30 06:00:00	MSFT	Stock	103.9	103.91	103.71	103.9	1546.0
2019-01-30 06:30:00	MSFT	Stock	103.88	103.88	103.8	103.85	460.0
2019-01-30 07:00:00	MSFT	Stock	103.99	104.3	103.99	104.2	21965.0
2019-01-30 07:30:00	MSFT	Stock	104.25	104.54	104.25	104.5	58036.0
2019-01-30 08:00:00	MSFT	Stock	104.5	104.69	104.15	104.36	70363.0
2019-01-30 08:30:00	MSFT	Stock	104.39	104.65	104.39	104.605	60729.0
2019-01-30 09:00:00	MSFT	Stock	104.61	104.75	104.57	104.61	25027.0
2019-01-30 09:30:00	MSFT	Stock	104.61	104.95	104.33	104.93	4225551.0
2019-01-30 10:00:00	MSFT	Stock	104.925	105.01	104.64	104.822	2492819.0
2019-01-30 10:30:00	MSFT	Stock	104.82	104.9	104.41	104.5	1796195.0
2019-01-30 11:00:00	MSFT	Stock	104.51	104.98	104.51	104.91	1658199.0
2019-01-30 11:30:00	MSFT	Stock	104.907	105.49	104.907	105.475	2152756.0
2019-01-30 12:00:00	MSFT	Stock	105.48	106.07	105.45	105.88	2345725.0
2019-01-30 12:30:00	MSFT	Stock	105.87	105.94	105.5	105.54	1508910.0

> showing 50 of 84,819 rows — these rows as CSV

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