PREVIEW / stock_30min / 2018-11-23

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-11-23.parquet
  size:    1.0 MB
  rows:    49,421
  symbols: 2,622

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-11-23 04:00:00	AAPL	Stock	43.9725	43.9725	43.875	43.875	15156.0
2018-11-23 04:30:00	AAPL	Stock	43.9	43.925	43.9	43.925	7384.0
2018-11-23 05:00:00	AAPL	Stock	43.925	43.925	43.925	43.925	1200.0
2018-11-23 05:30:00	AAPL	Stock	43.8775	43.91	43.675	43.7775	8140.0
2018-11-23 06:00:00	AAPL	Stock	43.75	43.825	43.7375	43.7375	3912.0
2018-11-23 06:30:00	AAPL	Stock	43.775	43.7875	43.77	43.7875	2340.0
2018-11-23 07:00:00	AAPL	Stock	43.8225	43.925	43.7875	43.915	55656.0
2018-11-23 07:30:00	AAPL	Stock	43.8825	43.9875	43.8825	43.9875	49760.0
2018-11-23 08:00:00	AAPL	Stock	43.93	44.0	43.795	43.85	174808.0
2018-11-23 08:30:00	AAPL	Stock	43.85	43.86	43.6225	43.725	331844.0
2018-11-23 09:00:00	AAPL	Stock	43.7425	43.75	43.625	43.73	636468.0
2018-11-23 09:30:00	AAPL	Stock	43.725	44.1488	43.5	43.9175	17810904.0
2018-11-23 10:00:00	AAPL	Stock	43.9025	43.965	43.5225	43.5525	9884408.0
2018-11-23 10:30:00	AAPL	Stock	43.55	43.6325	43.425	43.5525	9447592.0
2018-11-23 11:00:00	AAPL	Stock	43.55	43.573	43.4	43.405	6993532.0
2018-11-23 11:30:00	AAPL	Stock	43.4025	43.45	43.175	43.2125	8799224.0
2018-11-23 12:00:00	AAPL	Stock	43.2075	43.3298	43.0525	43.185	10079032.0
2018-11-23 12:30:00	AAPL	Stock	43.1825	43.2325	43.025	43.0725	11355856.0
2018-11-23 13:00:00	AAPL	Stock	43.0725	43.075	42.9625	43.045	6087540.0
2018-11-23 13:30:00	AAPL	Stock	43.05	43.06	43.0	43.0075	95424.0
2018-11-23 14:00:00	AAPL	Stock	43.025	43.0725	42.9998	43.0125	95400.0
2018-11-23 14:30:00	AAPL	Stock	43.0125	43.025	43.0025	43.0175	44756.0
2018-11-23 15:00:00	AAPL	Stock	43.0025	43.0175	42.98	42.9975	17004.0
2018-11-23 15:30:00	AAPL	Stock	42.9963	43.0725	42.975	42.9925	84148.0
2018-11-23 16:00:00	AAPL	Stock	42.9875	43.0125	42.975	43.0125	36680.0
2018-11-23 16:30:00	AAPL	Stock	43.0125	43.0425	43.0025	43.0025	23452.0
2018-11-23 04:00:00	MSFT	Stock	103.0	103.0	102.57	102.57	2506.0
2018-11-23 05:00:00	MSFT	Stock	102.65	102.65	102.65	102.65	957.0
2018-11-23 05:30:00	MSFT	Stock	102.51	102.51	102.26	102.26	2825.0
2018-11-23 06:30:00	MSFT	Stock	102.6	102.6	102.3	102.3	300.0
2018-11-23 07:00:00	MSFT	Stock	102.4	102.59	102.3	102.4	6572.0
2018-11-23 07:30:00	MSFT	Stock	102.42	102.7	102.42	102.7	10604.0
2018-11-23 08:00:00	MSFT	Stock	102.332	102.6	102.23	102.25	8919.0
2018-11-23 08:30:00	MSFT	Stock	102.25	102.25	101.65	101.99	35316.0
2018-11-23 09:00:00	MSFT	Stock	102.1	102.2	101.748	102.05	22639.0
2018-11-23 09:30:00	MSFT	Stock	102.21	103.77	102.0	103.56	2551115.0
2018-11-23 10:00:00	MSFT	Stock	103.56	103.81	103.27	103.41	1345791.0
2018-11-23 10:30:00	MSFT	Stock	103.4	103.59	102.99	103.35	1235956.0
2018-11-23 11:00:00	MSFT	Stock	103.355	103.45	103.07	103.09	1044857.0
2018-11-23 11:30:00	MSFT	Stock	103.09	103.24	102.805	102.84	1066146.0
2018-11-23 12:00:00	MSFT	Stock	102.83	103.15	102.73	103.02	1066217.0
2018-11-23 12:30:00	MSFT	Stock	103.02	103.26	102.9	103.07	1847595.0
2018-11-23 13:00:00	MSFT	Stock	103.07	103.07	102.9	102.9	1973123.0
2018-11-23 13:30:00	MSFT	Stock	103.0	103.0	102.85	102.87	1909.0
2018-11-23 14:00:00	MSFT	Stock	102.86	103.07	102.86	103.07	15246.0
2018-11-23 14:30:00	MSFT	Stock	103.07	103.07	102.86	102.86	135800.0
2018-11-23 15:00:00	MSFT	Stock	102.86	102.86	102.81	102.81	1469.0
2018-11-23 15:30:00	MSFT	Stock	102.81	103.0	102.81	102.867	2400.0
2018-11-23 16:00:00	MSFT	Stock	102.98	102.98	102.98	102.98	100.0
2018-11-23 16:30:00	MSFT	Stock	102.9	102.9	102.9	102.9	845.0

> showing 50 of 49,421 rows — these rows as CSV

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