PREVIEW / stock_30min / 2017-10-02

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-10-02.parquet
  size:    1.6 MB
  rows:    82,317
  symbols: 2,955

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-10-02 04:00:00	AAPL	Stock	38.53	38.53	38.53	38.53	400.0
2017-10-02 04:30:00	AAPL	Stock	38.535	38.535	38.535	38.535	400.0
2017-10-02 05:00:00	AAPL	Stock	38.5375	38.5375	38.53	38.53	42000.0
2017-10-02 06:00:00	AAPL	Stock	38.5475	38.5475	38.5475	38.5475	1200.0
2017-10-02 06:30:00	AAPL	Stock	38.5	38.5625	38.5	38.56	37668.0
2017-10-02 07:00:00	AAPL	Stock	38.5525	38.6225	38.5525	38.585	56876.0
2017-10-02 07:30:00	AAPL	Stock	38.585	38.625	38.575	38.6	122700.0
2017-10-02 08:00:00	AAPL	Stock	38.6125	38.62	38.565	38.565	193296.0
2017-10-02 08:30:00	AAPL	Stock	38.5875	38.595	38.5375	38.55	80936.0
2017-10-02 09:00:00	AAPL	Stock	38.5625	38.58	38.54	38.55	101944.0
2017-10-02 09:30:00	AAPL	Stock	38.565	38.6125	38.355	38.4825	9393448.0
2017-10-02 10:00:00	AAPL	Stock	38.485	38.4875	38.3662	38.41	5875956.0
2017-10-02 10:30:00	AAPL	Stock	38.41	38.4625	38.395	38.4422	4462176.0
2017-10-02 11:00:00	AAPL	Stock	38.445	38.4725	38.4	38.445	3240316.0
2017-10-02 11:30:00	AAPL	Stock	38.4475	38.4525	38.25	38.2575	5895252.0
2017-10-02 12:00:00	AAPL	Stock	38.2575	38.275	38.18	38.2475	6068480.0
2017-10-02 12:30:00	AAPL	Stock	38.245	38.2825	38.23	38.2775	2288452.0
2017-10-02 13:00:00	AAPL	Stock	38.2775	38.35	38.245	38.3488	3029248.0
2017-10-02 13:30:00	AAPL	Stock	38.35	38.435	38.325	38.4302	3426556.0
2017-10-02 14:00:00	AAPL	Stock	38.435	38.475	38.395	38.47	3564216.0
2017-10-02 14:30:00	AAPL	Stock	38.47	38.505	38.385	38.4162	3743868.0
2017-10-02 15:00:00	AAPL	Stock	38.4175	38.4487	38.38	38.4025	3606000.0
2017-10-02 15:30:00	AAPL	Stock	38.4025	38.4875	38.3958	38.4525	8172300.0
2017-10-02 16:00:00	AAPL	Stock	38.4525	38.46	38.3365	38.44	3883668.0
2017-10-02 16:30:00	AAPL	Stock	38.4275	38.4525	38.4175	38.4325	16312.0
2017-10-02 17:00:00	AAPL	Stock	38.4425	38.445	38.4425	38.445	1400.0
2017-10-02 17:30:00	AAPL	Stock	38.44	38.445	38.435	38.4375	9800.0
2017-10-02 18:00:00	AAPL	Stock	38.4375	38.4425	38.4375	38.4425	5372.0
2017-10-02 18:30:00	AAPL	Stock	38.4375	38.4375	38.425	38.425	4000.0
2017-10-02 19:00:00	AAPL	Stock	38.435	38.435	38.425	38.425	24020.0
2017-10-02 19:30:00	AAPL	Stock	38.425	38.4375	38.425	38.4375	8264.0
2017-10-02 07:30:00	MSFT	Stock	74.7	74.7	74.7	74.7	200.0
2017-10-02 08:00:00	MSFT	Stock	74.65	74.65	74.65	74.65	300.0
2017-10-02 08:30:00	MSFT	Stock	74.49	74.67	74.49	74.62	5119.0
2017-10-02 09:00:00	MSFT	Stock	74.62	74.71	74.55	74.71	11844.0
2017-10-02 09:30:00	MSFT	Stock	74.71	74.96	74.68	74.88	1633715.0
2017-10-02 10:00:00	MSFT	Stock	74.89	75.01	74.7	74.93	1457310.0
2017-10-02 10:30:00	MSFT	Stock	74.93	75.0	74.85	74.89	716233.0
2017-10-02 11:00:00	MSFT	Stock	74.885	74.99	74.795	74.82	721102.0
2017-10-02 11:30:00	MSFT	Stock	74.812	74.815	74.42	74.435	1046294.0
2017-10-02 12:00:00	MSFT	Stock	74.435	74.58	74.295	74.49	682200.0
2017-10-02 12:30:00	MSFT	Stock	74.485	74.6	74.45	74.595	470610.0
2017-10-02 13:00:00	MSFT	Stock	74.59	74.63	74.51	74.56	443182.0
2017-10-02 13:30:00	MSFT	Stock	74.555	74.66	74.52	74.625	572826.0
2017-10-02 14:00:00	MSFT	Stock	74.625	74.76	74.58	74.75	600544.0
2017-10-02 14:30:00	MSFT	Stock	74.74	74.81	74.68	74.75	571593.0
2017-10-02 15:00:00	MSFT	Stock	74.74	74.74	74.56	74.67	671385.0
2017-10-02 15:30:00	MSFT	Stock	74.66	74.69	74.55	74.6	1817827.0
2017-10-02 16:00:00	MSFT	Stock	74.61	74.61	74.55	74.59	1628315.0
2017-10-02 16:30:00	MSFT	Stock	74.61	74.61	74.59	74.6	811.0

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

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