PREVIEW / stock_30min / 2019-10-02

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-02.parquet
  size:    1.7 MB
  rows:    84,362
  symbols: 2,503

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-10-02 04:00:00	AAPL	Stock	55.9375	55.9375	55.775	55.9	40240.0
2019-10-02 04:30:00	AAPL	Stock	55.875	55.875	55.7325	55.75	49208.0
2019-10-02 05:00:00	AAPL	Stock	55.75	55.825	55.665	55.675	54816.0
2019-10-02 05:30:00	AAPL	Stock	55.7	55.75	55.625	55.6525	77284.0
2019-10-02 06:00:00	AAPL	Stock	55.65	55.725	55.625	55.6625	17424.0
2019-10-02 06:30:00	AAPL	Stock	55.71	55.775	55.6875	55.6875	31900.0
2019-10-02 07:00:00	AAPL	Stock	55.69	55.7725	55.6325	55.725	184796.0
2019-10-02 07:30:00	AAPL	Stock	55.695	55.7875	55.6875	55.7875	33316.0
2019-10-02 08:00:00	AAPL	Stock	55.715	55.8375	55.645	55.77	240136.0
2019-10-02 08:30:00	AAPL	Stock	55.8175	55.8175	55.6325	55.67	108220.0
2019-10-02 09:00:00	AAPL	Stock	55.6632	55.835	55.625	55.7725	171324.0
2019-10-02 09:30:00	AAPL	Stock	55.7725	55.895	55.1825	55.3275	17798120.0
2019-10-02 10:00:00	AAPL	Stock	55.325	55.365	55.085	55.1175	10344152.0
2019-10-02 10:30:00	AAPL	Stock	55.1175	55.1175	54.84	54.9475	12040324.0
2019-10-02 11:00:00	AAPL	Stock	54.9425	55.14	54.8825	54.9262	6157084.0
2019-10-02 11:30:00	AAPL	Stock	54.93	54.9625	54.7175	54.8025	6631004.0
2019-10-02 12:00:00	AAPL	Stock	54.8	54.8132	54.6412	54.7062	4463560.0
2019-10-02 12:30:00	AAPL	Stock	54.7062	54.73	54.4825	54.6108	5514820.0
2019-10-02 13:00:00	AAPL	Stock	54.61	54.8725	54.57	54.785	6615300.0
2019-10-02 13:30:00	AAPL	Stock	54.78	54.815	54.6448	54.675	4396084.0
2019-10-02 14:00:00	AAPL	Stock	54.6762	54.9402	54.6325	54.8025	6017724.0
2019-10-02 14:30:00	AAPL	Stock	54.8025	54.9125	54.7175	54.8125	4849040.0
2019-10-02 15:00:00	AAPL	Stock	54.8125	54.9875	54.72	54.845	7036128.0
2019-10-02 15:30:00	AAPL	Stock	54.8425	54.965	54.71	54.74	11263104.0
2019-10-02 16:00:00	AAPL	Stock	54.74	54.956	54.5125	54.54	9548128.0
2019-10-02 16:30:00	AAPL	Stock	54.565	54.74	54.5375	54.625	160176.0
2019-10-02 17:00:00	AAPL	Stock	54.6125	54.625	54.5825	54.6125	65648.0
2019-10-02 17:30:00	AAPL	Stock	54.6075	54.625	54.6	54.625	38748.0
2019-10-02 18:00:00	AAPL	Stock	54.6125	54.6375	54.565	54.6125	50108.0
2019-10-02 18:30:00	AAPL	Stock	54.6125	54.6675	54.575	54.6575	39180.0
2019-10-02 19:00:00	AAPL	Stock	54.625	54.75	54.625	54.75	38772.0
2019-10-02 19:30:00	AAPL	Stock	54.74	54.7525	54.625	54.625	54360.0
2019-10-02 04:00:00	MSFT	Stock	136.65	136.65	136.3	136.3	3278.0
2019-10-02 04:30:00	MSFT	Stock	136.13	136.13	136.13	136.13	300.0
2019-10-02 05:00:00	MSFT	Stock	136.06	136.18	136.0	136.01	980.0
2019-10-02 05:30:00	MSFT	Stock	135.84	136.0	135.8	135.8	623.0
2019-10-02 06:00:00	MSFT	Stock	135.97	135.97	135.97	135.97	250.0
2019-10-02 07:00:00	MSFT	Stock	136.08	136.3	136.0	136.22	15160.0
2019-10-02 07:30:00	MSFT	Stock	136.22	136.26	136.16	136.26	3031.0
2019-10-02 08:00:00	MSFT	Stock	136.25	136.36	136.05	136.36	16038.0
2019-10-02 08:30:00	MSFT	Stock	136.301	136.46	136.05	136.175	38451.0
2019-10-02 09:00:00	MSFT	Stock	136.082	136.36	136.01	136.26	20290.0
2019-10-02 09:30:00	MSFT	Stock	136.26	136.37	134.87	135.14	3253938.0
2019-10-02 10:00:00	MSFT	Stock	135.13	135.18	134.26	134.37	2627160.0
2019-10-02 10:30:00	MSFT	Stock	134.373	134.373	133.63	134.07	2569045.0
2019-10-02 11:00:00	MSFT	Stock	134.06	134.43	133.89	134.185	1656126.0
2019-10-02 11:30:00	MSFT	Stock	134.19	134.41	133.9	134.288	1497250.0
2019-10-02 12:00:00	MSFT	Stock	134.28	134.37	133.97	134.06	974119.0
2019-10-02 12:30:00	MSFT	Stock	134.07	134.12	133.58	133.78	1093707.0
2019-10-02 13:00:00	MSFT	Stock	133.78	134.28	133.644	134.19	880383.0

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

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