PREVIEW / stock_30min / 2017-11-01

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-11-01.parquet
  size:    1.6 MB
  rows:    82,305
  symbols: 2,928

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
2017-11-01 04:00:00	AAPL	Stock	42.375	42.4625	42.375	42.435	27216.0
2017-11-01 04:30:00	AAPL	Stock	42.4375	42.4375	42.39	42.39	4064.0
2017-11-01 05:00:00	AAPL	Stock	42.405	42.405	42.405	42.405	800.0
2017-11-01 05:30:00	AAPL	Stock	42.38	42.5	42.38	42.405	26148.0
2017-11-01 06:00:00	AAPL	Stock	42.485	42.5475	42.485	42.52	50228.0
2017-11-01 06:30:00	AAPL	Stock	42.52	42.52	42.425	42.4325	34228.0
2017-11-01 07:00:00	AAPL	Stock	42.4375	42.5225	42.4175	42.485	266744.0
2017-11-01 07:30:00	AAPL	Stock	42.49	42.5025	42.2	42.275	371216.0
2017-11-01 08:00:00	AAPL	Stock	42.2775	42.525	42.2275	42.34	398164.0
2017-11-01 08:30:00	AAPL	Stock	42.3475	42.4175	42.3425	42.3925	170208.0
2017-11-01 09:00:00	AAPL	Stock	42.3775	42.47	42.3475	42.47	457932.0
2017-11-01 09:30:00	AAPL	Stock	42.4675	42.485	41.8275	41.9625	23317156.0
2017-11-01 10:00:00	AAPL	Stock	41.9525	41.965	41.6425	41.8025	17601900.0
2017-11-01 10:30:00	AAPL	Stock	41.8	41.8675	41.6575	41.762	9545560.0
2017-11-01 11:00:00	AAPL	Stock	41.765	41.9	41.7575	41.7968	5515832.0
2017-11-01 11:30:00	AAPL	Stock	41.8	41.8225	41.545	41.5575	8487396.0
2017-11-01 12:00:00	AAPL	Stock	41.5625	41.7675	41.545	41.7225	5686660.0
2017-11-01 12:30:00	AAPL	Stock	41.723	41.745	41.62	41.64	3755992.0
2017-11-01 13:00:00	AAPL	Stock	41.64	41.65	41.4025	41.5475	8543296.0
2017-11-01 13:30:00	AAPL	Stock	41.555	41.7918	41.455	41.5575	3952608.0
2017-11-01 14:00:00	AAPL	Stock	41.5575	41.6765	41.525	41.6008	5841568.0
2017-11-01 14:30:00	AAPL	Stock	41.6012	41.6875	41.5655	41.6698	4346780.0
2017-11-01 15:00:00	AAPL	Stock	41.6682	41.7225	41.6325	41.6588	4730272.0
2017-11-01 15:30:00	AAPL	Stock	41.66	41.7225	41.6282	41.7175	10203056.0
2017-11-01 16:00:00	AAPL	Stock	41.7225	41.775	41.655	41.75	6715600.0
2017-11-01 16:30:00	AAPL	Stock	41.7325	41.8475	41.7275	41.835	280952.0
2017-11-01 17:00:00	AAPL	Stock	41.825	41.825	41.7225	41.7525	207952.0
2017-11-01 17:30:00	AAPL	Stock	41.7375	41.8175	41.7225	41.7825	212112.0
2017-11-01 18:00:00	AAPL	Stock	41.7825	41.8125	41.7325	41.7625	69044.0
2017-11-01 18:30:00	AAPL	Stock	41.7525	41.775	41.7375	41.7375	36192.0
2017-11-01 19:00:00	AAPL	Stock	41.735	41.745	41.6925	41.725	95652.0
2017-11-01 19:30:00	AAPL	Stock	41.7	41.735	41.68	41.68	121332.0
2017-11-01 04:00:00	MSFT	Stock	83.49	83.5	83.49	83.5	1100.0
2017-11-01 06:00:00	MSFT	Stock	83.67	83.74	83.67	83.73	1679.0
2017-11-01 06:30:00	MSFT	Stock	83.72	83.73	83.7	83.7	955.0
2017-11-01 07:00:00	MSFT	Stock	83.69	83.69	83.54	83.67	20431.0
2017-11-01 07:30:00	MSFT	Stock	83.6	83.6	83.53	83.54	1910.0
2017-11-01 08:00:00	MSFT	Stock	83.6	83.68	83.56	83.58	2791.0
2017-11-01 08:30:00	MSFT	Stock	83.57	83.68	83.53	83.55	3755.0
2017-11-01 09:00:00	MSFT	Stock	83.6	83.72	83.4	83.7	26387.0
2017-11-01 09:30:00	MSFT	Stock	83.7	83.76	83.45	83.675	1908242.0
2017-11-01 10:00:00	MSFT	Stock	83.675	83.69	83.51	83.54	1963101.0
2017-11-01 10:30:00	MSFT	Stock	83.54	83.62	83.15	83.171	1511252.0
2017-11-01 11:00:00	MSFT	Stock	83.18	83.31	83.15	83.16	1068702.0
2017-11-01 11:30:00	MSFT	Stock	83.16	83.19	82.88	82.96	1601166.0
2017-11-01 12:00:00	MSFT	Stock	82.97	83.28	82.96	83.245	850519.0
2017-11-01 12:30:00	MSFT	Stock	83.25	83.27	83.17	83.22	775287.0
2017-11-01 13:00:00	MSFT	Stock	83.22	83.23	83.0	83.19	1004154.0
2017-11-01 13:30:00	MSFT	Stock	83.195	83.21	83.06	83.155	804471.0
2017-11-01 14:00:00	MSFT	Stock	83.16	83.22	83.06	83.09	1183018.0

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

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