PREVIEW / stock_30min / 2018-06-12

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-06-12.parquet
  size:    1.7 MB
  rows:    84,156
  symbols: 2,823

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-06-12 04:00:00	AAPL	Stock	47.8725	47.8725	47.8425	47.8425	1200.0
2018-06-12 04:30:00	AAPL	Stock	47.83	47.83	47.83	47.83	400.0
2018-06-12 07:00:00	AAPL	Stock	47.75	47.83	47.75	47.7625	31372.0
2018-06-12 07:30:00	AAPL	Stock	47.8	47.825	47.755	47.825	27768.0
2018-06-12 08:00:00	AAPL	Stock	47.8075	47.9125	47.7525	47.825	138564.0
2018-06-12 08:30:00	AAPL	Stock	47.835	47.8875	47.8275	47.885	91688.0
2018-06-12 09:00:00	AAPL	Stock	47.875	47.9125	47.83	47.85	68428.0
2018-06-12 09:30:00	AAPL	Stock	47.8462	47.9475	47.7875	47.8075	8046880.0
2018-06-12 10:00:00	AAPL	Stock	47.8075	47.9725	47.8	47.8775	4692924.0
2018-06-12 10:30:00	AAPL	Stock	47.8775	47.93	47.835	47.871	3688572.0
2018-06-12 11:00:00	AAPL	Stock	47.8725	47.885	47.8	47.85	2860468.0
2018-06-12 11:30:00	AAPL	Stock	47.855	47.935	47.825	47.9225	2777108.0
2018-06-12 12:00:00	AAPL	Stock	47.9225	47.955	47.9075	47.9225	2668368.0
2018-06-12 12:30:00	AAPL	Stock	47.9225	47.965	47.9225	47.955	2340192.0
2018-06-12 13:00:00	AAPL	Stock	47.955	48.1528	47.9538	48.1317	4379620.0
2018-06-12 13:30:00	AAPL	Stock	48.1345	48.15	48.025	48.106	3323800.0
2018-06-12 14:00:00	AAPL	Stock	48.105	48.105	47.865	47.89	3262128.0
2018-06-12 14:30:00	AAPL	Stock	47.89	47.8975	47.8225	47.8275	3437188.0
2018-06-12 15:00:00	AAPL	Stock	47.8285	47.9638	47.82	47.945	3083812.0
2018-06-12 15:30:00	AAPL	Stock	47.9425	48.085	47.9	48.0625	6734696.0
2018-06-12 16:00:00	AAPL	Stock	48.07	48.075	48.015	48.05	7777988.0
2018-06-12 16:30:00	AAPL	Stock	48.05	48.0875	48.05	48.0875	45168.0
2018-06-12 17:00:00	AAPL	Stock	48.07	48.075	48.0625	48.075	5656.0
2018-06-12 17:30:00	AAPL	Stock	48.0675	48.0675	48.0575	48.06	11644.0
2018-06-12 18:00:00	AAPL	Stock	48.075	48.075	48.055	48.075	18692.0
2018-06-12 18:30:00	AAPL	Stock	48.0625	48.0875	48.0625	48.0875	2500.0
2018-06-12 19:00:00	AAPL	Stock	48.0875	48.09	48.075	48.09	14820.0
2018-06-12 19:30:00	AAPL	Stock	48.0775	48.125	48.0775	48.125	43164.0
2018-06-12 04:00:00	MSFT	Stock	101.0	101.0	101.0	101.0	102.0
2018-06-12 04:30:00	MSFT	Stock	101.06	101.06	101.06	101.06	207.0
2018-06-12 06:00:00	MSFT	Stock	101.06	101.06	101.06	101.06	100.0
2018-06-12 06:30:00	MSFT	Stock	101.05	101.05	101.05	101.05	100.0
2018-06-12 07:00:00	MSFT	Stock	101.15	101.15	101.0	101.0	1298.0
2018-06-12 07:30:00	MSFT	Stock	101.1	101.15	101.09	101.09	400.0
2018-06-12 08:00:00	MSFT	Stock	101.2	101.34	101.05	101.15	12045.0
2018-06-12 08:30:00	MSFT	Stock	101.15	101.27	101.1	101.24	2688.0
2018-06-12 09:00:00	MSFT	Stock	101.19	101.3	101.11	101.11	6498.0
2018-06-12 09:30:00	MSFT	Stock	101.1	101.449	101.05	101.09	1826077.0
2018-06-12 10:00:00	MSFT	Stock	101.08	101.215	101.025	101.05	994819.0
2018-06-12 10:30:00	MSFT	Stock	101.05	101.21	101.0	101.17	1073734.0
2018-06-12 11:00:00	MSFT	Stock	101.175	101.39	100.89	101.135	1413487.0
2018-06-12 11:30:00	MSFT	Stock	101.14	101.356	101.05	101.325	638493.0
2018-06-12 12:00:00	MSFT	Stock	101.325	101.4	101.07	101.08	734714.0
2018-06-12 12:30:00	MSFT	Stock	101.08	101.2	101.04	101.185	545108.0
2018-06-12 13:00:00	MSFT	Stock	101.185	101.29	101.124	101.2	702246.0
2018-06-12 13:30:00	MSFT	Stock	101.21	101.29	101.18	101.205	876135.0
2018-06-12 14:00:00	MSFT	Stock	101.2	101.23	100.764	100.82	829106.0
2018-06-12 14:30:00	MSFT	Stock	100.81	100.98	100.75	100.835	927685.0
2018-06-12 15:00:00	MSFT	Stock	100.83	101.205	100.82	101.196	1071952.0
2018-06-12 15:30:00	MSFT	Stock	101.2	101.44	101.18	101.3	2360329.0

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

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