PREVIEW / stock_30min / 2017-12-08

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-12-08.parquet
  size:    1.6 MB
  rows:    83,321
  symbols: 2,937

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-12-08 04:00:00	AAPL	Stock	42.4875	42.55	42.4875	42.525	7200.0
2017-12-08 04:30:00	AAPL	Stock	42.5475	42.5475	42.5475	42.5475	400.0
2017-12-08 05:00:00	AAPL	Stock	42.5025	42.5275	42.475	42.5275	10200.0
2017-12-08 05:30:00	AAPL	Stock	42.55	42.55	42.5	42.5125	4980.0
2017-12-08 06:00:00	AAPL	Stock	42.5225	42.5625	42.5225	42.5625	52128.0
2017-12-08 06:30:00	AAPL	Stock	42.535	42.535	42.535	42.535	4884.0
2017-12-08 07:00:00	AAPL	Stock	42.535	42.6	42.535	42.6	53796.0
2017-12-08 07:30:00	AAPL	Stock	42.5875	42.5925	42.535	42.5625	46856.0
2017-12-08 08:00:00	AAPL	Stock	42.5	42.6	42.425	42.55	106012.0
2017-12-08 08:30:00	AAPL	Stock	42.5	42.61	42.4775	42.6	165784.0
2017-12-08 09:00:00	AAPL	Stock	42.605	42.6075	42.4975	42.5575	230688.0
2017-12-08 09:30:00	AAPL	Stock	42.6225	42.75	42.4802	42.5248	15548664.0
2017-12-08 10:00:00	AAPL	Stock	42.525	42.6312	42.4625	42.5475	7671172.0
2017-12-08 10:30:00	AAPL	Stock	42.5475	42.5575	42.4775	42.554	4568800.0
2017-12-08 11:00:00	AAPL	Stock	42.555	42.5975	42.4325	42.4675	4815720.0
2017-12-08 11:30:00	AAPL	Stock	42.465	42.5075	42.4075	42.475	3704676.0
2017-12-08 12:00:00	AAPL	Stock	42.475	42.5225	42.43	42.4963	2930404.0
2017-12-08 12:30:00	AAPL	Stock	42.4965	42.515	42.4625	42.4762	2426836.0
2017-12-08 13:00:00	AAPL	Stock	42.4775	42.505	42.4585	42.4785	1985332.0
2017-12-08 13:30:00	AAPL	Stock	42.4775	42.49	42.425	42.4662	2381368.0
2017-12-08 14:00:00	AAPL	Stock	42.4675	42.4825	42.2725	42.3525	4750892.0
2017-12-08 14:30:00	AAPL	Stock	42.3562	42.36	42.24	42.3425	4524844.0
2017-12-08 15:00:00	AAPL	Stock	42.345	42.3762	42.2962	42.325	4201764.0
2017-12-08 15:30:00	AAPL	Stock	42.3245	42.3425	42.205	42.34	12679844.0
2017-12-08 16:00:00	AAPL	Stock	42.3425	42.3425	42.2875	42.3125	11969356.0
2017-12-08 16:30:00	AAPL	Stock	42.3225	42.3425	42.305	42.32	393444.0
2017-12-08 17:00:00	AAPL	Stock	42.3125	42.3225	42.3	42.32	39048.0
2017-12-08 17:30:00	AAPL	Stock	42.32	42.345	42.32	42.345	12504.0
2017-12-08 18:00:00	AAPL	Stock	42.345	42.345	42.3425	42.345	4496.0
2017-12-08 18:30:00	AAPL	Stock	42.33	42.34	42.33	42.34	2064.0
2017-12-08 19:00:00	AAPL	Stock	42.34	42.34	42.33	42.33	3568.0
2017-12-08 19:30:00	AAPL	Stock	42.3375	42.3425	42.33	42.3425	18028.0
2017-12-08 04:00:00	MSFT	Stock	82.49	82.49	82.49	82.49	176.0
2017-12-08 06:30:00	MSFT	Stock	82.87	82.87	82.87	82.87	300.0
2017-12-08 07:00:00	MSFT	Stock	82.88	82.9	82.88	82.9	4140.0
2017-12-08 07:30:00	MSFT	Stock	82.9	83.08	82.9	83.0	10174.0
2017-12-08 08:00:00	MSFT	Stock	82.94	83.2	82.94	83.1	12799.0
2017-12-08 08:30:00	MSFT	Stock	83.15	83.39	83.1	83.24	26771.0
2017-12-08 09:00:00	MSFT	Stock	83.16	83.4	83.16	83.4	16171.0
2017-12-08 09:30:00	MSFT	Stock	83.42	84.58	83.33	83.94	4442036.0
2017-12-08 10:00:00	MSFT	Stock	83.94	84.46	83.91	84.41	2386945.0
2017-12-08 10:30:00	MSFT	Stock	84.42	84.43	84.21	84.25	1252501.0
2017-12-08 11:00:00	MSFT	Stock	84.249	84.27	83.87	83.88	1198032.0
2017-12-08 11:30:00	MSFT	Stock	83.89	83.9	83.63	83.73	920848.0
2017-12-08 12:00:00	MSFT	Stock	83.725	84.225	83.69	84.225	1144177.0
2017-12-08 12:30:00	MSFT	Stock	84.225	84.26	84.0	84.019	1023707.0
2017-12-08 13:00:00	MSFT	Stock	84.02	84.27	84.0	84.16	1025704.0
2017-12-08 13:30:00	MSFT	Stock	84.17	84.24	84.05	84.114	706416.0
2017-12-08 14:00:00	MSFT	Stock	84.115	84.17	83.914	84.045	1318355.0
2017-12-08 14:30:00	MSFT	Stock	84.05	84.15	83.97	84.06	794751.0

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

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