PREVIEW / stock_30min / 2018-03-22

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-03-22.parquet
  size:    1.7 MB
  rows:    83,425
  symbols: 2,869

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-03-22 04:00:00	AAPL	Stock	42.825	42.825	42.4975	42.5725	112348.0
2018-03-22 04:30:00	AAPL	Stock	42.5475	42.62	42.5375	42.555	11880.0
2018-03-22 05:00:00	AAPL	Stock	42.5525	42.575	42.425	42.425	23912.0
2018-03-22 05:30:00	AAPL	Stock	42.41	42.525	42.395	42.525	7100.0
2018-03-22 06:00:00	AAPL	Stock	42.4775	42.5625	42.475	42.5375	7828.0
2018-03-22 06:30:00	AAPL	Stock	42.525	42.525	42.4	42.4975	10696.0
2018-03-22 07:00:00	AAPL	Stock	42.5	42.6375	42.5	42.5525	88764.0
2018-03-22 07:30:00	AAPL	Stock	42.5625	42.675	42.55	42.5575	153380.0
2018-03-22 08:00:00	AAPL	Stock	42.575	42.7025	42.5	42.6275	153224.0
2018-03-22 08:30:00	AAPL	Stock	42.655	42.6575	42.4275	42.4725	502628.0
2018-03-22 09:00:00	AAPL	Stock	42.44	42.55	42.325	42.51	571844.0
2018-03-22 09:30:00	AAPL	Stock	42.5125	42.59	42.345	42.4475	20513592.0
2018-03-22 10:00:00	AAPL	Stock	42.4425	42.6	42.355	42.46	10127240.0
2018-03-22 10:30:00	AAPL	Stock	42.46	42.5225	42.295	42.33	9235464.0
2018-03-22 11:00:00	AAPL	Stock	42.3325	42.4925	42.3325	42.415	8926456.0
2018-03-22 11:30:00	AAPL	Stock	42.4138	42.4688	42.2325	42.395	9577820.0
2018-03-22 12:00:00	AAPL	Stock	42.3925	42.695	42.325	42.665	9965396.0
2018-03-22 12:30:00	AAPL	Stock	42.6625	42.825	42.5775	42.65	8310412.0
2018-03-22 13:00:00	AAPL	Stock	42.6425	42.9875	42.52	42.9675	7552280.0
2018-03-22 13:30:00	AAPL	Stock	42.9688	43.17	42.9325	43.025	11458644.0
2018-03-22 14:00:00	AAPL	Stock	43.0225	43.1025	42.7325	42.734	6720072.0
2018-03-22 14:30:00	AAPL	Stock	42.7275	42.9155	42.685	42.705	6056684.0
2018-03-22 15:00:00	AAPL	Stock	42.705	42.835	42.6075	42.645	7716992.0
2018-03-22 15:30:00	AAPL	Stock	42.645	42.66	42.15	42.1875	23102996.0
2018-03-22 16:00:00	AAPL	Stock	42.2125	42.25	42.1375	42.1875	8988032.0
2018-03-22 16:30:00	AAPL	Stock	42.205	42.225	42.15	42.2	121308.0
2018-03-22 17:00:00	AAPL	Stock	42.205	42.25	42.2	42.25	36544.0
2018-03-22 17:30:00	AAPL	Stock	42.2375	42.25	42.175	42.175	29704.0
2018-03-22 18:00:00	AAPL	Stock	42.1725	42.2	42.15	42.15	16688.0
2018-03-22 18:30:00	AAPL	Stock	42.125	42.1875	42.0	42.05	120804.0
2018-03-22 19:00:00	AAPL	Stock	42.015	42.015	41.895	41.895	103280.0
2018-03-22 19:30:00	AAPL	Stock	41.92	41.9425	41.8875	41.925	126740.0
2018-03-22 04:00:00	MSFT	Stock	92.65	92.65	91.94	91.94	1576.0
2018-03-22 04:30:00	MSFT	Stock	92.0	92.0	92.0	92.0	531.0
2018-03-22 05:00:00	MSFT	Stock	92.01	92.01	91.68	91.68	428.0
2018-03-22 06:00:00	MSFT	Stock	91.8	91.8	91.8	91.8	176.0
2018-03-22 06:30:00	MSFT	Stock	91.56	91.56	91.34	91.34	480.0
2018-03-22 07:00:00	MSFT	Stock	91.74	91.8	91.5	91.8	7294.0
2018-03-22 07:30:00	MSFT	Stock	91.79	91.84	91.51	91.51	10143.0
2018-03-22 08:00:00	MSFT	Stock	91.65	91.84	91.5	91.68	15124.0
2018-03-22 08:30:00	MSFT	Stock	91.67	91.67	91.37	91.49	18581.0
2018-03-22 09:00:00	MSFT	Stock	91.389	91.45	91.1	91.37	19872.0
2018-03-22 09:30:00	MSFT	Stock	91.3	91.62	90.56	91.28	3731226.0
2018-03-22 10:00:00	MSFT	Stock	91.27	91.75	91.13	91.5	1883115.0
2018-03-22 10:30:00	MSFT	Stock	91.5	91.505	90.7	90.79	2060421.0
2018-03-22 11:00:00	MSFT	Stock	90.79	90.915	90.36	90.425	2523171.0
2018-03-22 11:30:00	MSFT	Stock	90.43	90.606	90.09	90.39	2253748.0
2018-03-22 12:00:00	MSFT	Stock	90.395	91.1	90.25	90.99	1931694.0
2018-03-22 12:30:00	MSFT	Stock	91.0	91.26	90.88	91.03	1575119.0
2018-03-22 13:00:00	MSFT	Stock	91.03	91.27	90.64	91.26	1466751.0

> showing 50 of 83,425 rows — these rows as CSV

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