PREVIEW / stock_30min / 2018-01-18

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-01-18.parquet
  size:    1.7 MB
  rows:    84,802
  symbols: 2,898

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-01-18 04:00:00	AAPL	Stock	44.815	44.815	44.7	44.7175	31036.0
2018-01-18 04:30:00	AAPL	Stock	44.7125	44.825	44.7125	44.8	5700.0
2018-01-18 05:30:00	AAPL	Stock	44.775	44.8	44.775	44.8	8352.0
2018-01-18 06:00:00	AAPL	Stock	44.7775	44.8725	44.7725	44.8725	33604.0
2018-01-18 06:30:00	AAPL	Stock	44.8725	44.8725	44.85	44.87	5240.0
2018-01-18 07:00:00	AAPL	Stock	44.87	44.9325	44.87	44.8725	104408.0
2018-01-18 07:30:00	AAPL	Stock	44.875	44.875	44.7375	44.7375	123880.0
2018-01-18 08:00:00	AAPL	Stock	44.75	44.9325	44.6775	44.7875	241508.0
2018-01-18 08:30:00	AAPL	Stock	44.775	44.7875	44.7025	44.7375	298240.0
2018-01-18 09:00:00	AAPL	Stock	44.7525	44.8875	44.7275	44.8425	493956.0
2018-01-18 09:30:00	AAPL	Stock	44.8425	45.0125	44.6775	44.9263	21238008.0
2018-01-18 10:00:00	AAPL	Stock	44.9275	44.93	44.5625	44.7925	13510548.0
2018-01-18 10:30:00	AAPL	Stock	44.7912	44.9538	44.7775	44.7875	8329564.0
2018-01-18 11:00:00	AAPL	Stock	44.788	44.935	44.7725	44.855	5291444.0
2018-01-18 11:30:00	AAPL	Stock	44.8425	44.9025	44.735	44.8215	4501064.0
2018-01-18 12:00:00	AAPL	Stock	44.82	44.885	44.775	44.85	3891548.0
2018-01-18 12:30:00	AAPL	Stock	44.8525	44.9425	44.82	44.93	4756220.0
2018-01-18 13:00:00	AAPL	Stock	44.93	44.9538	44.855	44.87	3350256.0
2018-01-18 13:30:00	AAPL	Stock	44.8675	45.005	44.8675	44.9825	4200752.0
2018-01-18 14:00:00	AAPL	Stock	44.9775	45.025	44.955	44.9875	4492224.0
2018-01-18 14:30:00	AAPL	Stock	44.99	45.0125	44.93	44.99	3573932.0
2018-01-18 15:00:00	AAPL	Stock	44.9908	44.9925	44.835	44.8625	5144152.0
2018-01-18 15:30:00	AAPL	Stock	44.8625	44.8638	44.7525	44.8175	10337868.0
2018-01-18 16:00:00	AAPL	Stock	44.815	44.94	44.6975	44.745	17644252.0
2018-01-18 16:30:00	AAPL	Stock	44.73	44.815	44.6875	44.7125	107444.0
2018-01-18 17:00:00	AAPL	Stock	44.7125	44.815	44.7125	44.745	83324.0
2018-01-18 17:30:00	AAPL	Stock	44.745	44.775	44.745	44.7675	14696.0
2018-01-18 18:00:00	AAPL	Stock	44.745	44.7775	44.745	44.7775	15804.0
2018-01-18 18:30:00	AAPL	Stock	44.7875	44.815	44.0625	44.675	241616.0
2018-01-18 19:00:00	AAPL	Stock	44.6675	44.725	44.6675	44.7	36008.0
2018-01-18 19:30:00	AAPL	Stock	44.7	44.745	44.69	44.735	84656.0
2018-01-18 06:00:00	MSFT	Stock	90.15	90.15	90.15	90.15	100.0
2018-01-18 07:00:00	MSFT	Stock	90.44	90.44	90.35	90.35	1300.0
2018-01-18 07:30:00	MSFT	Stock	90.23	90.23	90.12	90.12	2519.0
2018-01-18 08:00:00	MSFT	Stock	90.2	90.2	89.89	90.05	8954.0
2018-01-18 08:30:00	MSFT	Stock	90.06	90.14	89.98	90.0	6602.0
2018-01-18 09:00:00	MSFT	Stock	90.0	90.09	89.77	89.8	16147.0
2018-01-18 09:30:00	MSFT	Stock	89.77	90.39	89.66	90.364	2121065.0
2018-01-18 10:00:00	MSFT	Stock	90.36	90.54	90.2	90.26	1596245.0
2018-01-18 10:30:00	MSFT	Stock	90.265	90.55	90.21	90.31	1191480.0
2018-01-18 11:00:00	MSFT	Stock	90.31	90.67	90.25	90.52	1044270.0
2018-01-18 11:30:00	MSFT	Stock	90.52	90.57	90.3	90.55	623981.0
2018-01-18 12:00:00	MSFT	Stock	90.55	90.66	90.53	90.565	722236.0
2018-01-18 12:30:00	MSFT	Stock	90.566	90.62	90.49	90.55	595659.0
2018-01-18 13:00:00	MSFT	Stock	90.555	90.6	90.49	90.525	952117.0
2018-01-18 13:30:00	MSFT	Stock	90.53	90.56	90.47	90.505	987419.0
2018-01-18 14:00:00	MSFT	Stock	90.505	90.61	90.464	90.52	1728625.0
2018-01-18 14:30:00	MSFT	Stock	90.51	90.592	90.46	90.485	1348476.0
2018-01-18 15:00:00	MSFT	Stock	90.48	90.54	90.25	90.28	1152946.0
2018-01-18 15:30:00	MSFT	Stock	90.28	90.29	90.05	90.12	3529737.0

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

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