PREVIEW / stock_30min / 2016-08-16

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-16.parquet
  size:    1.6 MB
  rows:    82,362
  symbols: 3,276

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
2016-08-16 04:00:00	AAPL	Stock	27.4975	27.4975	27.4275	27.4975	38820.0
2016-08-16 04:30:00	AAPL	Stock	27.4975	27.4975	27.475	27.475	25396.0
2016-08-16 05:00:00	AAPL	Stock	27.4975	27.4975	27.495	27.4975	3600.0
2016-08-16 05:30:00	AAPL	Stock	27.4975	27.4975	27.465	27.465	5780.0
2016-08-16 06:00:00	AAPL	Stock	27.465	27.475	27.44	27.445	45016.0
2016-08-16 06:30:00	AAPL	Stock	27.415	27.485	27.415	27.485	30400.0
2016-08-16 07:00:00	AAPL	Stock	27.4825	27.4975	27.4675	27.4675	101128.0
2016-08-16 07:30:00	AAPL	Stock	27.475	27.475	27.4	27.435	105684.0
2016-08-16 08:00:00	AAPL	Stock	27.435	27.485	27.43	27.43	225340.0
2016-08-16 08:30:00	AAPL	Stock	27.4475	27.4675	27.4	27.4325	229088.0
2016-08-16 09:00:00	AAPL	Stock	27.4225	27.435	27.39	27.42	147424.0
2016-08-16 09:30:00	AAPL	Stock	27.4075	27.53	27.375	27.5	26626340.0
2016-08-16 10:00:00	AAPL	Stock	27.505	27.5575	27.4475	27.4762	12624844.0
2016-08-16 10:30:00	AAPL	Stock	27.4775	27.5375	27.46	27.4715	7030568.0
2016-08-16 11:00:00	AAPL	Stock	27.47	27.5	27.46	27.485	5037596.0
2016-08-16 11:30:00	AAPL	Stock	27.4838	27.4975	27.4625	27.4875	4176016.0
2016-08-16 12:00:00	AAPL	Stock	27.485	27.495	27.4575	27.4875	4883388.0
2016-08-16 12:30:00	AAPL	Stock	27.4875	27.4925	27.45	27.4612	5231952.0
2016-08-16 13:00:00	AAPL	Stock	27.4612	27.4625	27.3275	27.365	7346684.0
2016-08-16 13:30:00	AAPL	Stock	27.3625	27.395	27.3425	27.3678	5338404.0
2016-08-16 14:00:00	AAPL	Stock	27.3675	27.38	27.3025	27.3225	4995124.0
2016-08-16 14:30:00	AAPL	Stock	27.32	27.42	27.3175	27.41	6409388.0
2016-08-16 15:00:00	AAPL	Stock	27.41	27.445	27.3775	27.4275	5662236.0
2016-08-16 15:30:00	AAPL	Stock	27.4275	27.4375	27.34	27.345	11632288.0
2016-08-16 16:00:00	AAPL	Stock	27.345	27.37	27.34	27.34	9119796.0
2016-08-16 16:30:00	AAPL	Stock	27.345	27.35	27.3325	27.35	56756.0
2016-08-16 17:00:00	AAPL	Stock	27.35	27.37	27.34	27.35	30200.0
2016-08-16 17:30:00	AAPL	Stock	27.34	27.35	27.34	27.35	7096.0
2016-08-16 18:00:00	AAPL	Stock	27.35	27.35	27.3175	27.3175	36416.0
2016-08-16 18:30:00	AAPL	Stock	27.32	27.3575	27.32	27.3525	16532.0
2016-08-16 19:00:00	AAPL	Stock	27.35	27.35	27.35	27.35	764.0
2016-08-16 19:30:00	AAPL	Stock	27.3575	27.3575	27.345	27.345	26580.0
2016-08-16 04:00:00	MSFT	Stock	58.06	58.06	58.06	58.06	965.0
2016-08-16 04:30:00	MSFT	Stock	57.89	57.89	57.89	57.89	463.0
2016-08-16 07:00:00	MSFT	Stock	57.89	57.89	57.89	57.89	300.0
2016-08-16 07:30:00	MSFT	Stock	57.8	57.8	57.77	57.78	1415.0
2016-08-16 08:00:00	MSFT	Stock	57.8	57.8	57.75	57.75	1550.0
2016-08-16 08:30:00	MSFT	Stock	57.75	57.78	57.7	57.7	5705.0
2016-08-16 09:00:00	MSFT	Stock	57.75	57.75	57.6	57.61	10367.0
2016-08-16 09:30:00	MSFT	Stock	57.61	57.62	57.27	57.295	2888205.0
2016-08-16 10:00:00	MSFT	Stock	57.29	57.505	57.29	57.45	1608223.0
2016-08-16 10:30:00	MSFT	Stock	57.445	57.55	57.43	57.48	1091641.0
2016-08-16 11:00:00	MSFT	Stock	57.475	57.57	57.47	57.49	1305865.0
2016-08-16 11:30:00	MSFT	Stock	57.49	57.51	57.413	57.43	1141648.0
2016-08-16 12:00:00	MSFT	Stock	57.42	57.43	57.37	57.38	829542.0
2016-08-16 12:30:00	MSFT	Stock	57.38	57.5	57.38	57.495	800375.0
2016-08-16 13:00:00	MSFT	Stock	57.495	57.5	57.39	57.41	661749.0
2016-08-16 13:30:00	MSFT	Stock	57.405	57.48	57.39	57.45	684941.0
2016-08-16 14:00:00	MSFT	Stock	57.455	57.48	57.37	57.391	815442.0
2016-08-16 14:30:00	MSFT	Stock	57.4	57.46	57.38	57.445	863969.0

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

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