PREVIEW / stock_30min / 2018-07-09

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-07-09.parquet
  size:    1.7 MB
  rows:    84,783
  symbols: 2,830

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
2018-07-09 03:30:00	AAPL	Stock	47.225	47.225	47.225	47.225	400.0
2018-07-09 04:00:00	AAPL	Stock	47.25	47.25	47.25	47.25	800.0
2018-07-09 04:30:00	AAPL	Stock	47.25	47.25	47.25	47.25	3108.0
2018-07-09 05:00:00	AAPL	Stock	47.2525	47.2525	47.2	47.2	24308.0
2018-07-09 05:30:00	AAPL	Stock	47.2125	47.2125	47.2125	47.2125	7256.0
2018-07-09 06:30:00	AAPL	Stock	47.2175	47.245	47.2175	47.225	2192.0
2018-07-09 07:00:00	AAPL	Stock	47.2475	47.285	47.2375	47.2375	106600.0
2018-07-09 07:30:00	AAPL	Stock	47.225	47.2875	47.215	47.2875	44892.0
2018-07-09 08:00:00	AAPL	Stock	47.2625	47.425	47.225	47.4225	388192.0
2018-07-09 08:30:00	AAPL	Stock	47.4025	47.4375	47.34	47.34	150532.0
2018-07-09 09:00:00	AAPL	Stock	47.34	47.39	47.3325	47.3575	94204.0
2018-07-09 09:30:00	AAPL	Stock	47.375	47.67	47.325	47.5525	14343116.0
2018-07-09 10:00:00	AAPL	Stock	47.555	47.605	47.36	47.4275	7445016.0
2018-07-09 10:30:00	AAPL	Stock	47.4275	47.54	47.42	47.52	4336404.0
2018-07-09 11:00:00	AAPL	Stock	47.52	47.59	47.5022	47.5838	3581292.0
2018-07-09 11:30:00	AAPL	Stock	47.5825	47.61	47.5025	47.5792	3256476.0
2018-07-09 12:00:00	AAPL	Stock	47.5838	47.622	47.5037	47.515	2994720.0
2018-07-09 12:30:00	AAPL	Stock	47.515	47.525	47.4825	47.4925	2537808.0
2018-07-09 13:00:00	AAPL	Stock	47.4975	47.565	47.435	47.555	2504252.0
2018-07-09 13:30:00	AAPL	Stock	47.555	47.595	47.495	47.57	2267684.0
2018-07-09 14:00:00	AAPL	Stock	47.5725	47.5825	47.5125	47.545	1766848.0
2018-07-09 14:30:00	AAPL	Stock	47.545	47.6275	47.525	47.6112	2976508.0
2018-07-09 15:00:00	AAPL	Stock	47.6125	47.635	47.5625	47.62	3037528.0
2018-07-09 15:30:00	AAPL	Stock	47.6175	47.665	47.5875	47.6525	7661452.0
2018-07-09 16:00:00	AAPL	Stock	47.645	47.6925	47.4345	47.6925	9843848.0
2018-07-09 16:30:00	AAPL	Stock	47.6875	47.7125	47.6042	47.685	252044.0
2018-07-09 17:00:00	AAPL	Stock	47.685	47.775	47.6325	47.635	154060.0
2018-07-09 17:30:00	AAPL	Stock	47.635	47.675	47.525	47.575	89808.0
2018-07-09 18:00:00	AAPL	Stock	47.5625	47.575	47.475	47.5225	76232.0
2018-07-09 18:30:00	AAPL	Stock	47.56	47.605	47.5225	47.605	19524.0
2018-07-09 19:00:00	AAPL	Stock	47.5875	47.635	47.5875	47.6125	28240.0
2018-07-09 19:30:00	AAPL	Stock	47.6125	47.645	47.605	47.635	36696.0
2018-07-09 03:30:00	MSFT	Stock	101.54	101.54	101.54	101.54	100.0
2018-07-09 04:00:00	MSFT	Stock	101.6	101.6	101.6	101.6	200.0
2018-07-09 05:00:00	MSFT	Stock	101.84	101.84	101.84	101.84	147.0
2018-07-09 06:00:00	MSFT	Stock	102.0	102.0	102.0	102.0	100.0
2018-07-09 06:30:00	MSFT	Stock	101.85	101.85	101.6	101.6	689.0
2018-07-09 07:00:00	MSFT	Stock	101.6	101.89	101.55	101.85	5310.0
2018-07-09 07:30:00	MSFT	Stock	101.8	101.88	101.7	101.74	1575.0
2018-07-09 08:00:00	MSFT	Stock	101.74	101.9	101.5	101.85	12016.0
2018-07-09 08:30:00	MSFT	Stock	101.85	101.88	101.69	101.7	8504.0
2018-07-09 09:00:00	MSFT	Stock	101.8	101.879	101.39	101.57	30843.0
2018-07-09 09:30:00	MSFT	Stock	101.57	102.25	101.545	101.61	3135540.0
2018-07-09 10:00:00	MSFT	Stock	101.609	101.66	101.251	101.4	1288245.0
2018-07-09 10:30:00	MSFT	Stock	101.405	101.57	101.27	101.54	1003255.0
2018-07-09 11:00:00	MSFT	Stock	101.545	101.85	101.545	101.688	837729.0
2018-07-09 11:30:00	MSFT	Stock	101.68	101.79	101.5	101.74	641260.0
2018-07-09 12:00:00	MSFT	Stock	101.74	101.82	101.66	101.692	525638.0
2018-07-09 12:30:00	MSFT	Stock	101.69	101.7	101.58	101.605	481520.0
2018-07-09 13:00:00	MSFT	Stock	101.605	101.695	101.467	101.57	581992.0

> showing 50 of 84,783 rows — these rows as CSV

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