PREVIEW / stock_30min / 2016-12-05

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-12-05.parquet
  size:    1.6 MB
  rows:    83,083
  symbols: 3,172

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-12-05 04:00:00	AAPL	Stock	27.5025	27.58	27.5	27.58	8780.0
2016-12-05 05:00:00	AAPL	Stock	27.6375	27.6375	27.6375	27.6375	500.0
2016-12-05 05:30:00	AAPL	Stock	27.635	27.635	27.635	27.635	400.0
2016-12-05 06:30:00	AAPL	Stock	27.6	27.6125	27.6	27.6125	6500.0
2016-12-05 07:00:00	AAPL	Stock	27.6	27.61	27.5	27.5	38852.0
2016-12-05 07:30:00	AAPL	Stock	27.4825	27.5375	27.475	27.525	15024.0
2016-12-05 08:00:00	AAPL	Stock	27.5375	27.64	27.5125	27.5625	69848.0
2016-12-05 08:30:00	AAPL	Stock	27.5625	27.57	27.54	27.5525	41204.0
2016-12-05 09:00:00	AAPL	Stock	27.5525	27.5525	27.5	27.5225	135120.0
2016-12-05 09:30:00	AAPL	Stock	27.5	27.5075	27.0625	27.255	26694900.0
2016-12-05 10:00:00	AAPL	Stock	27.255	27.405	27.2375	27.4	11309888.0
2016-12-05 10:30:00	AAPL	Stock	27.4	27.4462	27.3325	27.3425	7669676.0
2016-12-05 11:00:00	AAPL	Stock	27.345	27.3675	27.2908	27.3082	6232236.0
2016-12-05 11:30:00	AAPL	Stock	27.3075	27.3215	27.2112	27.2418	7369004.0
2016-12-05 12:00:00	AAPL	Stock	27.2412	27.3	27.2075	27.245	6130528.0
2016-12-05 12:30:00	AAPL	Stock	27.245	27.315	27.235	27.294	4601968.0
2016-12-05 13:00:00	AAPL	Stock	27.295	27.34	27.28	27.3225	4261248.0
2016-12-05 13:30:00	AAPL	Stock	27.3225	27.3275	27.2725	27.2775	4217572.0
2016-12-05 14:00:00	AAPL	Stock	27.28	27.3145	27.2575	27.3062	4203484.0
2016-12-05 14:30:00	AAPL	Stock	27.3062	27.3388	27.2875	27.325	4609480.0
2016-12-05 15:00:00	AAPL	Stock	27.3225	27.3575	27.3125	27.3162	4370120.0
2016-12-05 15:30:00	AAPL	Stock	27.3162	27.3175	27.2425	27.275	15921376.0
2016-12-05 16:00:00	AAPL	Stock	27.28	27.2875	27.2625	27.2775	14091520.0
2016-12-05 16:30:00	AAPL	Stock	27.29	27.29	27.2875	27.2875	8232.0
2016-12-05 17:00:00	AAPL	Stock	27.2875	27.2925	27.2775	27.28	9292.0
2016-12-05 17:30:00	AAPL	Stock	27.2775	27.2775	27.2775	27.2775	1696.0
2016-12-05 18:00:00	AAPL	Stock	27.2875	27.2875	27.2875	27.2875	600.0
2016-12-05 18:30:00	AAPL	Stock	27.2775	27.3	27.2775	27.295	15600.0
2016-12-05 19:00:00	AAPL	Stock	27.305	27.3125	27.3	27.3	12540.0
2016-12-05 19:30:00	AAPL	Stock	27.3125	27.3125	27.2775	27.2775	7380.0
2016-12-05 04:00:00	MSFT	Stock	59.53	59.53	59.53	59.53	272.0
2016-12-05 07:00:00	MSFT	Stock	59.58	59.58	59.58	59.58	100.0
2016-12-05 07:30:00	MSFT	Stock	59.58	59.58	59.58	59.58	1000.0
2016-12-05 08:00:00	MSFT	Stock	59.36	59.36	59.36	59.36	300.0
2016-12-05 08:30:00	MSFT	Stock	59.36	59.36	59.36	59.36	300.0
2016-12-05 09:00:00	MSFT	Stock	59.54	59.73	59.54	59.68	12912.0
2016-12-05 09:30:00	MSFT	Stock	59.7	60.13	59.56	59.989	2791037.0
2016-12-05 10:00:00	MSFT	Stock	59.985	60.4	59.985	60.4	2117790.0
2016-12-05 10:30:00	MSFT	Stock	60.4	60.585	60.35	60.515	1518068.0
2016-12-05 11:00:00	MSFT	Stock	60.52	60.54	60.34	60.42	1076560.0
2016-12-05 11:30:00	MSFT	Stock	60.41	60.41	60.15	60.175	1394256.0
2016-12-05 12:00:00	MSFT	Stock	60.17	60.21	59.93	60.08	1377526.0
2016-12-05 12:30:00	MSFT	Stock	60.07	60.226	60.05	60.18	906503.0
2016-12-05 13:00:00	MSFT	Stock	60.18	60.2	60.08	60.095	736199.0
2016-12-05 13:30:00	MSFT	Stock	60.095	60.17	60.09	60.1	856614.0
2016-12-05 14:00:00	MSFT	Stock	60.1	60.115	60.0	60.08	946999.0
2016-12-05 14:30:00	MSFT	Stock	60.07	60.11	59.995	60.06	804637.0
2016-12-05 15:00:00	MSFT	Stock	60.06	60.095	60.01	60.08	926755.0
2016-12-05 15:30:00	MSFT	Stock	60.084	60.28	60.05	60.21	2563489.0
2016-12-05 16:00:00	MSFT	Stock	60.22	60.3	60.205	60.3	3958913.0

> showing 50 of 83,083 rows — these rows as CSV

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