PREVIEW / stock_30min / 2018-10-31

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-31.parquet
  size:    1.7 MB
  rows:    86,007
  symbols: 2,789

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-31 04:00:00	AAPL	Stock	54.0	54.0	53.975	54.0	10940.0
2018-10-31 04:30:00	AAPL	Stock	54.1875	54.1875	54.1175	54.1725	9496.0
2018-10-31 05:00:00	AAPL	Stock	54.1625	54.1725	54.0625	54.1175	15960.0
2018-10-31 05:30:00	AAPL	Stock	54.125	54.155	54.0075	54.0375	17952.0
2018-10-31 06:00:00	AAPL	Stock	53.9775	53.995	53.8625	53.8625	36556.0
2018-10-31 06:30:00	AAPL	Stock	53.8625	53.985	53.8375	53.9275	56428.0
2018-10-31 07:00:00	AAPL	Stock	53.975	53.9825	53.6	53.6	677664.0
2018-10-31 07:30:00	AAPL	Stock	53.65	53.875	53.6025	53.7875	216016.0
2018-10-31 08:00:00	AAPL	Stock	53.9245	54.0625	53.625	53.95	527216.0
2018-10-31 08:30:00	AAPL	Stock	53.93	54.07	53.93	54.005	392528.0
2018-10-31 09:00:00	AAPL	Stock	54.0325	54.225	54.0125	54.225	364760.0
2018-10-31 09:30:00	AAPL	Stock	54.2175	54.5225	54.155	54.4238	16738500.0
2018-10-31 10:00:00	AAPL	Stock	54.425	54.8	54.37	54.69	10794084.0
2018-10-31 10:30:00	AAPL	Stock	54.69	54.7425	54.5325	54.5675	7275944.0
2018-10-31 11:00:00	AAPL	Stock	54.5725	54.97	54.4825	54.9475	8211476.0
2018-10-31 11:30:00	AAPL	Stock	54.945	54.9775	54.5	54.6365	6965564.0
2018-10-31 12:00:00	AAPL	Stock	54.64	54.86	54.4625	54.7902	4910616.0
2018-10-31 12:30:00	AAPL	Stock	54.7975	54.9875	54.7425	54.926	6028712.0
2018-10-31 13:00:00	AAPL	Stock	54.93	55.1125	54.885	54.9175	7913548.0
2018-10-31 13:30:00	AAPL	Stock	54.9225	54.9675	54.7525	54.8925	5446332.0
2018-10-31 14:00:00	AAPL	Stock	54.9	55.11	54.7925	54.9745	5709768.0
2018-10-31 14:30:00	AAPL	Stock	54.9772	54.9925	54.8225	54.97	5176048.0
2018-10-31 15:00:00	AAPL	Stock	54.9625	55.0675	54.8675	54.958	7399444.0
2018-10-31 15:30:00	AAPL	Stock	54.96	55.0	54.6725	54.6975	16501548.0
2018-10-31 16:00:00	AAPL	Stock	54.69	54.8225	54.6375	54.7125	19188860.0
2018-10-31 16:30:00	AAPL	Stock	54.7125	54.72	54.6475	54.695	255556.0
2018-10-31 17:00:00	AAPL	Stock	54.7	54.715	54.6625	54.695	1206540.0
2018-10-31 17:30:00	AAPL	Stock	54.7075	54.715	54.5	54.5875	208992.0
2018-10-31 18:00:00	AAPL	Stock	54.6175	54.7425	54.53	54.715	864040.0
2018-10-31 18:30:00	AAPL	Stock	54.7375	54.75	54.7175	54.75	52628.0
2018-10-31 19:00:00	AAPL	Stock	54.75	54.75	54.7325	54.745	58104.0
2018-10-31 19:30:00	AAPL	Stock	54.725	54.8	54.725	54.7925	112836.0
2018-10-31 04:00:00	MSFT	Stock	104.0	104.89	104.0	104.89	3450.0
2018-10-31 04:30:00	MSFT	Stock	104.89	105.1	104.75	105.1	3065.0
2018-10-31 05:00:00	MSFT	Stock	104.94	104.94	104.7	104.89	3450.0
2018-10-31 05:30:00	MSFT	Stock	104.88	104.94	104.71	104.71	4150.0
2018-10-31 06:00:00	MSFT	Stock	104.61	104.75	104.41	104.5	14599.0
2018-10-31 06:30:00	MSFT	Stock	104.5	104.6	104.49	104.55	23171.0
2018-10-31 07:00:00	MSFT	Stock	104.34	104.81	104.11	104.11	35997.0
2018-10-31 07:30:00	MSFT	Stock	104.17	104.74	104.1	104.6	32267.0
2018-10-31 08:00:00	MSFT	Stock	104.53	105.18	104.2	105.0	51603.0
2018-10-31 08:30:00	MSFT	Stock	105.0	105.18	104.85	105.1	70184.0
2018-10-31 09:00:00	MSFT	Stock	105.1	105.5	105.01	105.5	145686.0
2018-10-31 09:30:00	MSFT	Stock	105.42	107.35	105.39	106.93	7541653.0
2018-10-31 10:00:00	MSFT	Stock	106.93	107.925	106.79	107.74	4257541.0
2018-10-31 10:30:00	MSFT	Stock	107.75	108.107	107.05	107.145	3096893.0
2018-10-31 11:00:00	MSFT	Stock	107.17	107.87	106.68	107.685	2941466.0
2018-10-31 11:30:00	MSFT	Stock	107.69	107.75	106.42	106.8	1918932.0
2018-10-31 12:00:00	MSFT	Stock	106.8	107.57	106.3	107.32	1862888.0
2018-10-31 12:30:00	MSFT	Stock	107.35	107.75	107.28	107.46	1694943.0

> showing 50 of 86,007 rows — these rows as CSV

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