PREVIEW / stock_30min / 2018-10-26

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-26.parquet
  size:    1.7 MB
  rows:    84,752
  symbols: 2,748

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-10-26 04:00:00	AAPL	Stock	54.625	54.625	54.1575	54.225	62704.0
2018-10-26 04:30:00	AAPL	Stock	54.25	54.25	54.1075	54.1075	26604.0
2018-10-26 05:00:00	AAPL	Stock	54.13	54.1375	53.75	53.75	90224.0
2018-10-26 05:30:00	AAPL	Stock	53.675	53.725	53.5	53.725	133460.0
2018-10-26 06:00:00	AAPL	Stock	53.6975	53.87	53.65	53.775	167348.0
2018-10-26 06:30:00	AAPL	Stock	53.8425	53.9625	53.7925	53.8275	63664.0
2018-10-26 07:00:00	AAPL	Stock	53.8125	54.22	53.8125	54.1	317096.0
2018-10-26 07:30:00	AAPL	Stock	54.1575	54.165	53.9075	54.025	279068.0
2018-10-26 08:00:00	AAPL	Stock	53.975	54.2075	53.85	53.95	478136.0
2018-10-26 08:30:00	AAPL	Stock	53.9775	54.24	53.9675	54.125	511936.0
2018-10-26 09:00:00	AAPL	Stock	54.12	54.1725	53.875	53.91	653964.0
2018-10-26 09:30:00	AAPL	Stock	53.91	54.455	53.6875	54.0925	21359664.0
2018-10-26 10:00:00	AAPL	Stock	54.0875	54.14	53.6525	53.85	13831568.0
2018-10-26 10:30:00	AAPL	Stock	53.8425	53.9425	53.1975	53.2175	17844660.0
2018-10-26 11:00:00	AAPL	Stock	53.2075	54.055	53.1675	53.9625	12382240.0
2018-10-26 11:30:00	AAPL	Stock	53.9825	54.2225	53.8825	54.0862	7708324.0
2018-10-26 12:00:00	AAPL	Stock	54.09	54.3675	54.055	54.2522	6433108.0
2018-10-26 12:30:00	AAPL	Stock	54.2442	54.85	54.2025	54.7175	9187460.0
2018-10-26 13:00:00	AAPL	Stock	54.71	55.0475	54.5502	54.577	7526680.0
2018-10-26 13:30:00	AAPL	Stock	54.575	54.7175	54.19	54.6725	7502288.0
2018-10-26 14:00:00	AAPL	Stock	54.6732	54.7625	54.2575	54.4675	6206300.0
2018-10-26 14:30:00	AAPL	Stock	54.4625	54.61	53.8575	53.9398	6533212.0
2018-10-26 15:00:00	AAPL	Stock	53.925	54.1222	53.6525	54.0055	9399996.0
2018-10-26 15:30:00	AAPL	Stock	54.004	54.28	53.745	54.0075	17599548.0
2018-10-26 16:00:00	AAPL	Stock	54.0075	54.24	53.9725	54.1975	13537540.0
2018-10-26 16:30:00	AAPL	Stock	54.1975	54.2	54.075	54.1925	234836.0
2018-10-26 17:00:00	AAPL	Stock	54.1375	54.19	54.13	54.135	47432.0
2018-10-26 17:30:00	AAPL	Stock	54.13	54.1925	54.075	54.075	120200.0
2018-10-26 18:00:00	AAPL	Stock	54.1925	54.245	54.175	54.2125	34672.0
2018-10-26 18:30:00	AAPL	Stock	54.2475	54.2475	54.225	54.24	13128.0
2018-10-26 19:00:00	AAPL	Stock	54.2375	54.2375	54.2125	54.225	11348.0
2018-10-26 19:30:00	AAPL	Stock	54.2175	54.27	54.165	54.27	51228.0
2018-10-26 04:00:00	MSFT	Stock	106.59	106.59	105.47	105.9	6398.0
2018-10-26 04:30:00	MSFT	Stock	105.82	106.0	105.51	106.0	4487.0
2018-10-26 05:00:00	MSFT	Stock	105.81	105.97	105.5	105.5	13356.0
2018-10-26 05:30:00	MSFT	Stock	105.1	105.14	104.51	104.77	33474.0
2018-10-26 06:00:00	MSFT	Stock	104.77	105.28	104.5	105.28	19444.0
2018-10-26 06:30:00	MSFT	Stock	105.26	105.3	104.46	104.51	10349.0
2018-10-26 07:00:00	MSFT	Stock	104.88	105.67	104.65	105.5	41809.0
2018-10-26 07:30:00	MSFT	Stock	105.5	105.69	105.1	105.17	72697.0
2018-10-26 08:00:00	MSFT	Stock	105.24	105.68	104.8	105.45	89015.0
2018-10-26 08:30:00	MSFT	Stock	105.51	105.95	104.9	105.57	168740.0
2018-10-26 09:00:00	MSFT	Stock	105.57	105.99	104.98	105.55	164926.0
2018-10-26 09:30:00	MSFT	Stock	105.55	107.545	105.5	106.77	5502765.0
2018-10-26 10:00:00	MSFT	Stock	106.5	106.75	105.47	105.7	3977366.0
2018-10-26 10:30:00	MSFT	Stock	105.7	105.94	104.76	104.92	3760693.0
2018-10-26 11:00:00	MSFT	Stock	104.91	106.47	104.829	106.27	3427688.0
2018-10-26 11:30:00	MSFT	Stock	106.27	107.2	106.16	106.86	2618267.0
2018-10-26 12:00:00	MSFT	Stock	106.84	107.84	106.81	107.72	2740254.0
2018-10-26 12:30:00	MSFT	Stock	107.73	108.73	107.57	108.2	2466476.0

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

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