PREVIEW / stock_30min / 2018-04-20

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-04-20.parquet
  size:    1.6 MB
  rows:    81,176
  symbols: 2,839

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-04-20 04:00:00	AAPL	Stock	43.075	43.075	43.0	43.0	16548.0
2018-04-20 04:30:00	AAPL	Stock	43.0	43.0025	43.0	43.0025	1600.0
2018-04-20 05:00:00	AAPL	Stock	43.05	43.0725	43.05	43.0725	2872.0
2018-04-20 05:30:00	AAPL	Stock	43.075	43.075	43.0	43.0	24112.0
2018-04-20 06:00:00	AAPL	Stock	42.9375	43.0	42.9375	43.0	22572.0
2018-04-20 06:30:00	AAPL	Stock	42.96	43.0325	42.8875	43.0325	35296.0
2018-04-20 07:00:00	AAPL	Stock	43.03	43.1275	43.015	43.0425	81604.0
2018-04-20 07:30:00	AAPL	Stock	43.0625	43.28	43.04	43.0625	86204.0
2018-04-20 08:00:00	AAPL	Stock	43.105	43.225	42.9825	43.0	321716.0
2018-04-20 08:30:00	AAPL	Stock	42.995	43.025	42.9225	42.9875	379908.0
2018-04-20 09:00:00	AAPL	Stock	42.9875	43.125	42.6225	42.6425	1565252.0
2018-04-20 09:30:00	AAPL	Stock	42.6488	42.8045	41.715	41.85	58600576.0
2018-04-20 10:00:00	AAPL	Stock	41.85	41.9425	41.6825	41.8575	25840900.0
2018-04-20 10:30:00	AAPL	Stock	41.8575	42.025	41.72	41.7375	19295444.0
2018-04-20 11:00:00	AAPL	Stock	41.7375	41.7725	41.6325	41.7088	13542360.0
2018-04-20 11:30:00	AAPL	Stock	41.71	41.82	41.6925	41.725	9396172.0
2018-04-20 12:00:00	AAPL	Stock	41.7275	41.7495	41.4675	41.4925	13012932.0
2018-04-20 12:30:00	AAPL	Stock	41.4925	41.5275	41.3975	41.485	11348268.0
2018-04-20 13:00:00	AAPL	Stock	41.48	41.6125	41.42	41.5225	8264224.0
2018-04-20 13:30:00	AAPL	Stock	41.5225	41.565	41.4525	41.4625	6116040.0
2018-04-20 14:00:00	AAPL	Stock	41.4625	41.525	41.4125	41.4238	6676540.0
2018-04-20 14:30:00	AAPL	Stock	41.4238	41.5025	41.38	41.46	7828416.0
2018-04-20 15:00:00	AAPL	Stock	41.46	41.4775	41.3575	41.4125	10787216.0
2018-04-20 15:30:00	AAPL	Stock	41.414	41.6	41.375	41.43	20647720.0
2018-04-20 16:00:00	AAPL	Stock	41.43	41.497	41.4	41.415	16131160.0
2018-04-20 16:30:00	AAPL	Stock	41.42	41.45	41.4	41.45	50452.0
2018-04-20 17:00:00	AAPL	Stock	41.475	41.475	41.45	41.4625	68640.0
2018-04-20 17:30:00	AAPL	Stock	41.4625	41.4925	41.4575	41.4825	12544.0
2018-04-20 18:00:00	AAPL	Stock	41.4825	41.51	41.465	41.51	48908.0
2018-04-20 18:30:00	AAPL	Stock	41.5125	41.5375	41.51	41.5375	58784.0
2018-04-20 19:00:00	AAPL	Stock	41.5375	41.545	41.52	41.545	17384.0
2018-04-20 19:30:00	AAPL	Stock	41.545	41.5625	41.525	41.525	58432.0
2018-04-20 04:30:00	MSFT	Stock	95.72	95.72	95.72	95.72	100.0
2018-04-20 05:30:00	MSFT	Stock	95.7	95.7	95.7	95.7	100.0
2018-04-20 06:00:00	MSFT	Stock	95.61	95.61	95.61	95.61	200.0
2018-04-20 06:30:00	MSFT	Stock	95.8	95.9	95.8	95.9	848.0
2018-04-20 07:00:00	MSFT	Stock	96.05	96.14	96.0	96.05	4621.0
2018-04-20 07:30:00	MSFT	Stock	96.3	96.3	96.05	96.05	4442.0
2018-04-20 08:00:00	MSFT	Stock	96.3	96.3	95.8	95.8	14183.0
2018-04-20 08:30:00	MSFT	Stock	95.76	95.9	95.63	95.9	9553.0
2018-04-20 09:00:00	MSFT	Stock	95.78	95.9	95.78	95.84	7370.0
2018-04-20 09:30:00	MSFT	Stock	95.9	96.11	94.97	95.05	4411369.0
2018-04-20 10:00:00	MSFT	Stock	95.05	95.5	94.88	95.44	1933594.0
2018-04-20 10:30:00	MSFT	Stock	95.44	95.54	94.7	94.79	1934496.0
2018-04-20 11:00:00	MSFT	Stock	94.8	94.84	94.05	94.11	1920632.0
2018-04-20 11:30:00	MSFT	Stock	94.11	94.52	94.08	94.31	1236083.0
2018-04-20 12:00:00	MSFT	Stock	94.31	94.56	94.23	94.435	1257522.0
2018-04-20 12:30:00	MSFT	Stock	94.45	94.525	94.23	94.45	963136.0
2018-04-20 13:00:00	MSFT	Stock	94.44	95.04	94.34	95.04	1475701.0
2018-04-20 13:30:00	MSFT	Stock	95.03	95.33	94.99	95.115	1291450.0

> showing 50 of 81,176 rows — these rows as CSV

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