PREVIEW / stock_30min / 2016-11-14

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-11-14.parquet
  size:    1.7 MB
  rows:    85,658
  symbols: 3,183

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-11-14 04:00:00	AAPL	Stock	27.195	27.195	27.195	27.195	400.0
2016-11-14 04:30:00	AAPL	Stock	27.195	27.195	27.195	27.195	7140.0
2016-11-14 05:00:00	AAPL	Stock	27.2125	27.2125	27.21	27.21	2400.0
2016-11-14 05:30:00	AAPL	Stock	27.205	27.205	27.1725	27.1725	4568.0
2016-11-14 06:00:00	AAPL	Stock	27.1425	27.1425	27.0575	27.075	7932.0
2016-11-14 06:30:00	AAPL	Stock	27.0325	27.0725	27.0325	27.0725	2800.0
2016-11-14 07:00:00	AAPL	Stock	27.055	27.085	27.055	27.085	12352.0
2016-11-14 07:30:00	AAPL	Stock	27.075	27.11	27.05	27.11	15128.0
2016-11-14 08:00:00	AAPL	Stock	27.1	27.11	27.025	27.065	152228.0
2016-11-14 08:30:00	AAPL	Stock	27.065	27.07	27.01	27.0125	170128.0
2016-11-14 09:00:00	AAPL	Stock	27.0125	27.03	26.9225	26.94	312876.0
2016-11-14 09:30:00	AAPL	Stock	26.9275	26.9522	26.5	26.51	24401576.0
2016-11-14 10:00:00	AAPL	Stock	26.5125	26.58	26.3475	26.4078	25043056.0
2016-11-14 10:30:00	AAPL	Stock	26.4075	26.44	26.195	26.2125	21313120.0
2016-11-14 11:00:00	AAPL	Stock	26.215	26.35	26.02	26.2092	24786064.0
2016-11-14 11:30:00	AAPL	Stock	26.2087	26.39	26.205	26.3312	12465784.0
2016-11-14 12:00:00	AAPL	Stock	26.3362	26.36	26.16	26.1775	9150256.0
2016-11-14 12:30:00	AAPL	Stock	26.1775	26.325	26.14	26.315	8423276.0
2016-11-14 13:00:00	AAPL	Stock	26.3158	26.4325	26.305	26.4	7748876.0
2016-11-14 13:30:00	AAPL	Stock	26.4	26.485	26.315	26.36	8651956.0
2016-11-14 14:00:00	AAPL	Stock	26.36	26.3875	26.2875	26.2975	7173332.0
2016-11-14 14:30:00	AAPL	Stock	26.2975	26.555	26.2775	26.55	9504772.0
2016-11-14 15:00:00	AAPL	Stock	26.55	26.575	26.39	26.4125	8002800.0
2016-11-14 15:30:00	AAPL	Stock	26.415	26.465	26.35	26.425	13155428.0
2016-11-14 16:00:00	AAPL	Stock	26.425	26.435	26.4025	26.43	6953188.0
2016-11-14 16:30:00	AAPL	Stock	26.425	26.4625	26.4125	26.4625	73620.0
2016-11-14 17:00:00	AAPL	Stock	26.44	26.475	26.4275	26.465	39516.0
2016-11-14 17:30:00	AAPL	Stock	26.475	26.475	26.44	26.4475	23232.0
2016-11-14 18:00:00	AAPL	Stock	26.4375	26.465	26.43	26.43	17220.0
2016-11-14 18:30:00	AAPL	Stock	26.43	26.45	26.4125	26.4125	708560.0
2016-11-14 19:00:00	AAPL	Stock	26.42	26.4275	26.3675	26.3775	44280.0
2016-11-14 19:30:00	AAPL	Stock	26.38	26.4	26.3375	26.375	47080.0
2016-11-14 04:30:00	MSFT	Stock	59.11	59.11	59.11	59.11	340.0
2016-11-14 06:00:00	MSFT	Stock	59.16	59.19	59.05	59.19	4500.0
2016-11-14 06:30:00	MSFT	Stock	59.1	59.1	59.1	59.1	700.0
2016-11-14 07:00:00	MSFT	Stock	59.1	59.1	59.1	59.1	369.0
2016-11-14 07:30:00	MSFT	Stock	59.1	59.15	59.08	59.08	3668.0
2016-11-14 08:00:00	MSFT	Stock	59.15	59.15	58.95	58.95	34331.0
2016-11-14 08:30:00	MSFT	Stock	59.06	59.2	59.06	59.2	16185.0
2016-11-14 09:00:00	MSFT	Stock	59.17	59.2	58.98	59.07	20980.0
2016-11-14 09:30:00	MSFT	Stock	59.1	59.1	58.36	58.41	3943248.0
2016-11-14 10:00:00	MSFT	Stock	58.4	58.665	58.25	58.35	3097563.0
2016-11-14 10:30:00	MSFT	Stock	58.355	58.45	57.69	57.69	4171347.0
2016-11-14 11:00:00	MSFT	Stock	57.7	58.04	57.28	57.8	4095943.0
2016-11-14 11:30:00	MSFT	Stock	57.79	58.136	57.732	57.965	2268644.0
2016-11-14 12:00:00	MSFT	Stock	57.97	58.015	57.77	57.815	1789853.0
2016-11-14 12:30:00	MSFT	Stock	57.815	57.86	57.62	57.82	2165473.0
2016-11-14 13:00:00	MSFT	Stock	57.83	57.91	57.74	57.9	1290681.0
2016-11-14 13:30:00	MSFT	Stock	57.9	58.075	57.9	57.945	2086819.0
2016-11-14 14:00:00	MSFT	Stock	57.945	58.09	57.925	57.995	1575223.0

> showing 50 of 85,658 rows — these rows as CSV

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