PREVIEW / stock_30min / 2017-03-14

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-14.parquet
  size:    1.6 MB
  rows:    81,331
  symbols: 3,066

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-03-14 04:00:00	AAPL	Stock	34.75	34.75	34.75	34.75	1152.0
2017-03-14 05:00:00	AAPL	Stock	34.75	34.75	34.75	34.75	420.0
2017-03-14 05:30:00	AAPL	Stock	34.75	34.75	34.75	34.75	560.0
2017-03-14 06:30:00	AAPL	Stock	34.7875	34.7875	34.7875	34.7875	400.0
2017-03-14 07:00:00	AAPL	Stock	34.79	34.7925	34.79	34.7925	3600.0
2017-03-14 07:30:00	AAPL	Stock	34.78	34.78	34.7675	34.7675	2400.0
2017-03-14 08:00:00	AAPL	Stock	34.8	34.8	34.7125	34.7125	73768.0
2017-03-14 08:30:00	AAPL	Stock	34.735	34.7475	34.725	34.7375	11804.0
2017-03-14 09:00:00	AAPL	Stock	34.7475	34.825	34.745	34.8225	84492.0
2017-03-14 09:30:00	AAPL	Stock	34.825	34.9125	34.8125	34.8625	11055916.0
2017-03-14 10:00:00	AAPL	Stock	34.8625	34.8625	34.73	34.773	5302240.0
2017-03-14 10:30:00	AAPL	Stock	34.7725	34.7788	34.71	34.76	4474128.0
2017-03-14 11:00:00	AAPL	Stock	34.758	34.785	34.725	34.7575	3760088.0
2017-03-14 11:30:00	AAPL	Stock	34.7575	34.8025	34.7325	34.8013	2892496.0
2017-03-14 12:00:00	AAPL	Stock	34.8025	34.81	34.745	34.7752	3231336.0
2017-03-14 12:30:00	AAPL	Stock	34.7775	34.78	34.7452	34.76	1675412.0
2017-03-14 13:00:00	AAPL	Stock	34.76	34.79	34.7525	34.765	2206196.0
2017-03-14 13:30:00	AAPL	Stock	34.7638	34.7765	34.7375	34.7525	2539024.0
2017-03-14 14:00:00	AAPL	Stock	34.7512	34.76	34.715	34.735	2302992.0
2017-03-14 14:30:00	AAPL	Stock	34.7375	34.76	34.7125	34.7398	2370448.0
2017-03-14 15:00:00	AAPL	Stock	34.7388	34.775	34.7375	34.765	2790768.0
2017-03-14 15:30:00	AAPL	Stock	34.7625	34.7675	34.7275	34.745	4534356.0
2017-03-14 16:00:00	AAPL	Stock	34.7475	34.77	34.7475	34.75	4852524.0
2017-03-14 16:30:00	AAPL	Stock	34.7475	34.7575	34.7475	34.75	29976.0
2017-03-14 17:00:00	AAPL	Stock	34.7475	34.75	34.7475	34.75	3252.0
2017-03-14 17:30:00	AAPL	Stock	34.755	34.755	34.755	34.755	2952.0
2017-03-14 18:00:00	AAPL	Stock	34.7375	34.75	34.7375	34.745	8128.0
2017-03-14 18:30:00	AAPL	Stock	34.7475	34.75	34.7475	34.75	1600.0
2017-03-14 19:00:00	AAPL	Stock	34.7525	34.7525	34.75	34.75	12796.0
2017-03-14 19:30:00	AAPL	Stock	34.7525	34.7525	34.735	34.7375	38504.0
2017-03-14 07:00:00	MSFT	Stock	64.52	64.52	64.52	64.52	230.0
2017-03-14 08:00:00	MSFT	Stock	64.71	64.71	64.58	64.58	6200.0
2017-03-14 08:30:00	MSFT	Stock	64.52	64.61	64.52	64.61	200.0
2017-03-14 09:00:00	MSFT	Stock	64.61	64.7	64.53	64.53	1391.0
2017-03-14 09:30:00	MSFT	Stock	64.53	64.55	64.35	64.405	1524157.0
2017-03-14 10:00:00	MSFT	Stock	64.4	64.43	64.22	64.22	1262311.0
2017-03-14 10:30:00	MSFT	Stock	64.22	64.347	64.15	64.315	1161399.0
2017-03-14 11:00:00	MSFT	Stock	64.32	64.39	64.26	64.36	698908.0
2017-03-14 11:30:00	MSFT	Stock	64.36	64.41	64.305	64.37	696608.0
2017-03-14 12:00:00	MSFT	Stock	64.38	64.4	64.23	64.305	796395.0
2017-03-14 12:30:00	MSFT	Stock	64.31	64.36	64.3	64.355	388875.0
2017-03-14 13:00:00	MSFT	Stock	64.36	64.5	64.34	64.48	518327.0
2017-03-14 13:30:00	MSFT	Stock	64.48	64.51	64.4	64.42	575806.0
2017-03-14 14:00:00	MSFT	Stock	64.42	64.43	64.35	64.36	475212.0
2017-03-14 14:30:00	MSFT	Stock	64.36	64.425	64.335	64.365	537059.0
2017-03-14 15:00:00	MSFT	Stock	64.37	64.46	64.364	64.46	497434.0
2017-03-14 15:30:00	MSFT	Stock	64.455	64.46	64.38	64.39	1549656.0
2017-03-14 16:00:00	MSFT	Stock	64.41	64.48	64.36	64.48	2263616.0
2017-03-14 16:30:00	MSFT	Stock	64.39	64.48	64.39	64.48	16249.0
2017-03-14 04:00:00	NVDA	Stock	2.5485	2.5485	2.5485	2.5485	6360.0

> showing 50 of 81,331 rows — these rows as CSV

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