PREVIEW / stock_30min / 2016-09-23

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-09-23.parquet
  size:    1.6 MB
  rows:    80,386
  symbols: 3,222

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-09-23 04:00:00	AAPL	Stock	28.6125	28.6125	28.6125	28.6125	644.0
2016-09-23 05:00:00	AAPL	Stock	28.6125	28.6125	28.6125	28.6125	400.0
2016-09-23 06:00:00	AAPL	Stock	28.5675	28.62	28.5675	28.5825	4924.0
2016-09-23 06:30:00	AAPL	Stock	28.59	28.59	28.5825	28.5825	2400.0
2016-09-23 07:00:00	AAPL	Stock	28.5875	28.61	28.5875	28.605	5260.0
2016-09-23 07:30:00	AAPL	Stock	28.605	28.62	28.595	28.6125	16920.0
2016-09-23 08:00:00	AAPL	Stock	28.6	28.6225	28.585	28.6075	139044.0
2016-09-23 08:30:00	AAPL	Stock	28.605	28.655	28.605	28.6225	122620.0
2016-09-23 09:00:00	AAPL	Stock	28.6175	28.7275	28.605	28.64	431272.0
2016-09-23 09:30:00	AAPL	Stock	28.605	28.6975	28.535	28.5355	15774484.0
2016-09-23 10:00:00	AAPL	Stock	28.5375	28.6138	28.525	28.595	8257928.0
2016-09-23 10:30:00	AAPL	Stock	28.5962	28.6225	28.5625	28.585	4921412.0
2016-09-23 11:00:00	AAPL	Stock	28.585	28.6562	28.5788	28.615	5356544.0
2016-09-23 11:30:00	AAPL	Stock	28.6125	28.6575	28.6075	28.625	4242420.0
2016-09-23 12:00:00	AAPL	Stock	28.625	28.6475	28.615	28.6375	3208696.0
2016-09-23 12:30:00	AAPL	Stock	28.6375	28.6738	28.6175	28.6688	3115572.0
2016-09-23 13:00:00	AAPL	Stock	28.6678	28.675	28.6325	28.6475	3671564.0
2016-09-23 13:30:00	AAPL	Stock	28.6475	28.65	27.8875	27.9825	44169544.0
2016-09-23 14:00:00	AAPL	Stock	27.9825	28.2425	27.9	28.14	44968180.0
2016-09-23 14:30:00	AAPL	Stock	28.1412	28.27	28.066	28.2075	19623452.0
2016-09-23 15:00:00	AAPL	Stock	28.2075	28.3025	28.1675	28.245	14117148.0
2016-09-23 15:30:00	AAPL	Stock	28.2475	28.295	28.17	28.1762	16724432.0
2016-09-23 16:00:00	AAPL	Stock	28.175	28.6322	28.075	28.1125	10038824.0
2016-09-23 16:30:00	AAPL	Stock	28.1125	28.1775	28.1	28.1125	140264.0
2016-09-23 17:00:00	AAPL	Stock	28.1075	28.11	28.055	28.07	138012.0
2016-09-23 17:30:00	AAPL	Stock	28.0575	28.0925	28.0575	28.065	62284.0
2016-09-23 18:00:00	AAPL	Stock	28.0625	28.0725	28.05	28.06	63000.0
2016-09-23 18:30:00	AAPL	Stock	28.06	28.065	28.05	28.055	11520.0
2016-09-23 19:00:00	AAPL	Stock	28.0625	28.0725	28.05	28.05	39336.0
2016-09-23 19:30:00	AAPL	Stock	28.0575	28.07	28.05	28.0575	75932.0
2016-09-23 08:30:00	MSFT	Stock	57.82	57.82	57.75	57.8	2740.0
2016-09-23 09:00:00	MSFT	Stock	57.8	57.9	57.78	57.9	7477.0
2016-09-23 09:30:00	MSFT	Stock	57.9	57.91	57.5	57.5	3012543.0
2016-09-23 10:00:00	MSFT	Stock	57.51	57.6	57.46	57.51	1470304.0
2016-09-23 10:30:00	MSFT	Stock	57.52	57.53	57.41	57.447	1007721.0
2016-09-23 11:00:00	MSFT	Stock	57.44	57.5	57.42	57.485	998983.0
2016-09-23 11:30:00	MSFT	Stock	57.485	57.51	57.41	57.45	1038733.0
2016-09-23 12:00:00	MSFT	Stock	57.455	57.5	57.43	57.465	736568.0
2016-09-23 12:30:00	MSFT	Stock	57.47	57.54	57.45	57.535	791673.0
2016-09-23 13:00:00	MSFT	Stock	57.54	57.55	57.45	57.495	765010.0
2016-09-23 13:30:00	MSFT	Stock	57.495	57.54	57.38	57.49	996957.0
2016-09-23 14:00:00	MSFT	Stock	57.49	57.63	57.459	57.58	954759.0
2016-09-23 14:30:00	MSFT	Stock	57.575	57.6	57.53	57.545	934443.0
2016-09-23 15:00:00	MSFT	Stock	57.54	57.57	57.46	57.57	870804.0
2016-09-23 15:30:00	MSFT	Stock	57.57	57.6	57.43	57.44	2442252.0
2016-09-23 16:00:00	MSFT	Stock	57.43	57.46	57.37	57.46	2518927.0
2016-09-23 16:30:00	MSFT	Stock	57.43	57.43	57.4	57.4	93142.0
2016-09-23 18:00:00	MSFT	Stock	57.39	57.39	57.39	57.39	130.0
2016-09-23 18:30:00	MSFT	Stock	57.4	57.4	57.4	57.4	1000.0
2016-09-23 07:00:00	NVDA	Stock	1.6238	1.6238	1.6238	1.6238	4000.0

> showing 50 of 80,386 rows — these rows as CSV

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