PREVIEW / stock_30min / 2016-08-18

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-18.parquet
  size:    1.6 MB
  rows:    80,968
  symbols: 3,253

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-18 04:30:00	AAPL	Stock	27.33	27.345	27.33	27.345	1164.0
2016-08-18 06:00:00	AAPL	Stock	27.3475	27.3475	27.325	27.325	5820.0
2016-08-18 06:30:00	AAPL	Stock	27.3275	27.3275	27.3275	27.3275	2384.0
2016-08-18 07:00:00	AAPL	Stock	27.325	27.325	27.3	27.3	8000.0
2016-08-18 07:30:00	AAPL	Stock	27.295	27.295	27.265	27.265	10316.0
2016-08-18 08:00:00	AAPL	Stock	27.2875	27.2975	27.2625	27.275	71120.0
2016-08-18 08:30:00	AAPL	Stock	27.275	27.275	27.26	27.26	13092.0
2016-08-18 09:00:00	AAPL	Stock	27.275	27.305	27.2625	27.305	98084.0
2016-08-18 09:30:00	AAPL	Stock	27.3075	27.4	27.295	27.331	12003824.0
2016-08-18 10:00:00	AAPL	Stock	27.335	27.3545	27.285	27.3262	7048180.0
2016-08-18 10:30:00	AAPL	Stock	27.3275	27.3725	27.3088	27.3625	4346768.0
2016-08-18 11:00:00	AAPL	Stock	27.3625	27.3725	27.3175	27.3688	4299604.0
2016-08-18 11:30:00	AAPL	Stock	27.37	27.3775	27.345	27.3612	3399268.0
2016-08-18 12:00:00	AAPL	Stock	27.36	27.3675	27.3075	27.315	2646084.0
2016-08-18 12:30:00	AAPL	Stock	27.3125	27.3125	27.2575	27.2875	4766908.0
2016-08-18 13:00:00	AAPL	Stock	27.2875	27.3125	27.28	27.2825	3308528.0
2016-08-18 13:30:00	AAPL	Stock	27.2825	27.325	27.2775	27.295	3156176.0
2016-08-18 14:00:00	AAPL	Stock	27.2975	27.32	27.295	27.305	3119296.0
2016-08-18 14:30:00	AAPL	Stock	27.3025	27.35	27.2875	27.3462	4368348.0
2016-08-18 15:00:00	AAPL	Stock	27.3465	27.375	27.34	27.345	4648068.0
2016-08-18 15:30:00	AAPL	Stock	27.3438	27.365	27.255	27.2702	10700160.0
2016-08-18 16:00:00	AAPL	Stock	27.27	27.339	27.265	27.2725	11250268.0
2016-08-18 16:30:00	AAPL	Stock	27.2725	27.2825	27.2725	27.2725	12252.0
2016-08-18 17:00:00	AAPL	Stock	27.2725	27.2775	27.2675	27.2675	19876.0
2016-08-18 17:30:00	AAPL	Stock	27.275	27.3	27.275	27.3	79600.0
2016-08-18 18:00:00	AAPL	Stock	27.28	27.295	27.28	27.295	7200.0
2016-08-18 18:30:00	AAPL	Stock	27.3	27.3025	27.29	27.295	14480.0
2016-08-18 19:00:00	AAPL	Stock	27.2825	27.2825	27.27	27.275	20340.0
2016-08-18 19:30:00	AAPL	Stock	27.28	27.2975	27.2775	27.2975	14960.0
2016-08-18 07:30:00	MSFT	Stock	57.49	57.49	57.49	57.49	359.0
2016-08-18 08:00:00	MSFT	Stock	57.56	57.56	57.56	57.56	100.0
2016-08-18 09:30:00	MSFT	Stock	57.42	57.53	57.27	57.31	1366413.0
2016-08-18 10:00:00	MSFT	Stock	57.315	57.57	57.3	57.51	1083040.0
2016-08-18 10:30:00	MSFT	Stock	57.52	57.56	57.44	57.47	691999.0
2016-08-18 11:00:00	MSFT	Stock	57.47	57.49	57.385	57.43	952826.0
2016-08-18 11:30:00	MSFT	Stock	57.435	57.5	57.42	57.44	653684.0
2016-08-18 12:00:00	MSFT	Stock	57.443	57.45	57.35	57.36	615218.0
2016-08-18 12:30:00	MSFT	Stock	57.35	57.42	57.28	57.403	679055.0
2016-08-18 13:00:00	MSFT	Stock	57.41	57.48	57.39	57.47	392341.0
2016-08-18 13:30:00	MSFT	Stock	57.47	57.57	57.47	57.529	558952.0
2016-08-18 14:00:00	MSFT	Stock	57.53	57.59	57.52	57.585	612220.0
2016-08-18 14:30:00	MSFT	Stock	57.59	57.63	57.52	57.63	594205.0
2016-08-18 15:00:00	MSFT	Stock	57.62	57.7	57.61	57.65	824437.0
2016-08-18 15:30:00	MSFT	Stock	57.65	57.66	57.58	57.6	1588312.0
2016-08-18 16:00:00	MSFT	Stock	57.6	57.6	57.6	57.6	2631281.0
2016-08-18 18:00:00	MSFT	Stock	57.56	57.56	57.56	57.56	300.0
2016-08-18 19:30:00	MSFT	Stock	57.63	57.63	57.63	57.63	1800.0
2016-08-18 07:30:00	NVDA	Stock	1.536	1.536	1.536	1.536	4000.0
2016-08-18 08:00:00	NVDA	Stock	1.5373	1.5373	1.5288	1.5312	46000.0
2016-08-18 08:30:00	NVDA	Stock	1.5275	1.5278	1.5168	1.5225	118280.0

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

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