PREVIEW / stock_30min / 2019-07-26

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-26.parquet
  size:    1.7 MB
  rows:    85,068
  symbols: 2,578

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
2019-07-26 04:00:00	AAPL	Stock	51.9	51.9	51.9	51.9	1624.0
2019-07-26 04:30:00	AAPL	Stock	51.85	51.95	51.85	51.95	5896.0
2019-07-26 05:00:00	AAPL	Stock	51.9	51.9	51.9	51.9	1828.0
2019-07-26 06:00:00	AAPL	Stock	51.95	51.95	51.905	51.905	2468.0
2019-07-26 06:30:00	AAPL	Stock	51.885	51.95	51.8575	51.8575	5208.0
2019-07-26 07:00:00	AAPL	Stock	51.9375	51.95	51.8575	51.8575	15992.0
2019-07-26 07:30:00	AAPL	Stock	51.8825	51.9025	51.8525	51.8525	29444.0
2019-07-26 08:00:00	AAPL	Stock	51.89	51.95	51.8325	51.9075	83816.0
2019-07-26 08:30:00	AAPL	Stock	51.9075	51.9075	51.8125	51.9	35304.0
2019-07-26 09:00:00	AAPL	Stock	51.8938	51.95	51.85	51.85	56540.0
2019-07-26 09:30:00	AAPL	Stock	51.85	52.1975	51.8475	52.1575	9662916.0
2019-07-26 10:00:00	AAPL	Stock	52.1575	52.4325	51.785	52.045	11561944.0
2019-07-26 10:30:00	AAPL	Stock	52.045	52.0825	51.9375	52.06	3484696.0
2019-07-26 11:00:00	AAPL	Stock	52.0575	52.1375	51.9912	52.0525	2825616.0
2019-07-26 11:30:00	AAPL	Stock	52.05	52.105	51.9938	52.0255	2657828.0
2019-07-26 12:00:00	AAPL	Stock	52.0275	52.0725	51.9775	51.9875	2217996.0
2019-07-26 12:30:00	AAPL	Stock	51.9875	52.0062	51.955	51.9625	1428712.0
2019-07-26 13:00:00	AAPL	Stock	51.9625	52.01	51.9392	51.99	1563596.0
2019-07-26 13:30:00	AAPL	Stock	51.985	52.0075	51.965	52.0012	1298884.0
2019-07-26 14:00:00	AAPL	Stock	52.0012	52.035	51.97	51.9862	2099128.0
2019-07-26 14:30:00	AAPL	Stock	51.985	52.0725	51.9775	52.0425	2044736.0
2019-07-26 15:00:00	AAPL	Stock	52.0425	52.0425	51.9752	52.0375	2491464.0
2019-07-26 15:30:00	AAPL	Stock	52.0375	52.13	51.935	51.9375	6859624.0
2019-07-26 16:00:00	AAPL	Stock	51.9375	52.303	51.8975	51.96	6954500.0
2019-07-26 16:30:00	AAPL	Stock	51.9525	52.0037	51.875	51.875	63988.0
2019-07-26 17:00:00	AAPL	Stock	51.875	51.935	51.875	51.915	28748.0
2019-07-26 17:30:00	AAPL	Stock	51.9325	51.9525	51.9125	51.9375	32288.0
2019-07-26 18:00:00	AAPL	Stock	51.925	51.935	51.9075	51.915	13320.0
2019-07-26 18:30:00	AAPL	Stock	51.915	51.9325	51.9	51.9125	23160.0
2019-07-26 19:00:00	AAPL	Stock	51.9125	51.9325	51.9125	51.9325	8064.0
2019-07-26 19:30:00	AAPL	Stock	51.925	51.9475	51.925	51.9475	14904.0
2019-07-26 04:00:00	MSFT	Stock	140.49	140.54	140.49	140.54	400.0
2019-07-26 04:30:00	MSFT	Stock	140.66	140.66	140.48	140.57	340.0
2019-07-26 05:30:00	MSFT	Stock	140.6	140.66	140.6	140.66	227.0
2019-07-26 06:00:00	MSFT	Stock	140.66	140.66	140.66	140.66	134.0
2019-07-26 06:30:00	MSFT	Stock	140.65	140.65	140.18	140.27	2882.0
2019-07-26 07:00:00	MSFT	Stock	140.18	140.4	140.18	140.32	1430.0
2019-07-26 07:30:00	MSFT	Stock	140.32	140.62	140.32	140.48	21270.0
2019-07-26 08:00:00	MSFT	Stock	140.38	140.62	140.27	140.3	17279.0
2019-07-26 08:30:00	MSFT	Stock	140.3	140.49	140.25	140.36	9112.0
2019-07-26 09:00:00	MSFT	Stock	140.26	140.53	140.26	140.29	17737.0
2019-07-26 09:30:00	MSFT	Stock	140.37	140.95	140.3	140.81	1705444.0
2019-07-26 10:00:00	MSFT	Stock	140.8	140.87	140.4	140.84	1164137.0
2019-07-26 10:30:00	MSFT	Stock	140.84	140.84	140.54	140.72	895304.0
2019-07-26 11:00:00	MSFT	Stock	140.71	140.92	140.57	140.89	832168.0
2019-07-26 11:30:00	MSFT	Stock	140.89	141.23	140.87	141.16	1019224.0
2019-07-26 12:00:00	MSFT	Stock	141.165	141.275	141.09	141.22	742385.0
2019-07-26 12:30:00	MSFT	Stock	141.21	141.24	141.015	141.16	539105.0
2019-07-26 13:00:00	MSFT	Stock	141.17	141.47	141.12	141.43	707075.0
2019-07-26 13:30:00	MSFT	Stock	141.43	141.5	141.32	141.49	597719.0

> showing 50 of 85,068 rows — these rows as CSV

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