PREVIEW / stock_30min / 2019-11-04

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-11-04.parquet
  size:    1.8 MB
  rows:    85,873
  symbols: 2,498

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-11-04 04:00:00	AAPL	Stock	64.1375	64.3725	64.1375	64.3	12832.0
2019-11-04 04:30:00	AAPL	Stock	64.325	64.325	64.2425	64.2975	12820.0
2019-11-04 05:00:00	AAPL	Stock	64.2975	64.37	64.25	64.35	28040.0
2019-11-04 05:30:00	AAPL	Stock	64.35	64.375	64.3	64.375	23036.0
2019-11-04 06:00:00	AAPL	Stock	64.38	64.4475	64.2875	64.31	35336.0
2019-11-04 06:30:00	AAPL	Stock	64.3175	64.3775	64.3175	64.325	29080.0
2019-11-04 07:00:00	AAPL	Stock	64.3625	64.4375	64.3325	64.3325	199156.0
2019-11-04 07:30:00	AAPL	Stock	64.335	64.47	64.325	64.435	288448.0
2019-11-04 08:00:00	AAPL	Stock	64.4	64.4975	64.3325	64.45	388360.0
2019-11-04 08:30:00	AAPL	Stock	64.4425	64.5	64.4	64.45	328884.0
2019-11-04 09:00:00	AAPL	Stock	64.45	64.45	64.3375	64.35	379232.0
2019-11-04 09:30:00	AAPL	Stock	64.3425	64.4475	63.845	64.116	23732036.0
2019-11-04 10:00:00	AAPL	Stock	64.115	64.3625	64.0775	64.3025	8691972.0
2019-11-04 10:30:00	AAPL	Stock	64.3035	64.3035	64.1125	64.2388	5721992.0
2019-11-04 11:00:00	AAPL	Stock	64.2388	64.285	64.14	64.22	4653948.0
2019-11-04 11:30:00	AAPL	Stock	64.2222	64.26	64.05	64.0675	4319312.0
2019-11-04 12:00:00	AAPL	Stock	64.065	64.125	63.995	64.0018	3681884.0
2019-11-04 12:30:00	AAPL	Stock	64.0025	64.095	63.855	64.0912	4398852.0
2019-11-04 13:00:00	AAPL	Stock	64.0898	64.1625	64.05	64.162	2507736.0
2019-11-04 13:30:00	AAPL	Stock	64.1625	64.25	64.12	64.2025	3127456.0
2019-11-04 14:00:00	AAPL	Stock	64.2	64.2365	64.1412	64.18	2556836.0
2019-11-04 14:30:00	AAPL	Stock	64.1775	64.3425	64.1725	64.3425	3603776.0
2019-11-04 15:00:00	AAPL	Stock	64.3388	64.385	64.2275	64.31	4703912.0
2019-11-04 15:30:00	AAPL	Stock	64.3075	64.4613	64.2875	64.37	8193596.0
2019-11-04 16:00:00	AAPL	Stock	64.375	64.375	64.2875	64.375	7010308.0
2019-11-04 16:30:00	AAPL	Stock	64.375	64.4	64.3575	64.375	47980.0
2019-11-04 17:00:00	AAPL	Stock	64.375	64.395	64.375	64.385	18904.0
2019-11-04 17:30:00	AAPL	Stock	64.385	64.385	64.35	64.35	50768.0
2019-11-04 18:00:00	AAPL	Stock	64.35	64.375	64.325	64.325	17016.0
2019-11-04 18:30:00	AAPL	Stock	64.3	64.575	64.3	64.53	197092.0
2019-11-04 19:00:00	AAPL	Stock	64.53	64.53	64.4825	64.5	62700.0
2019-11-04 19:30:00	AAPL	Stock	64.5125	64.55	64.475	64.4975	74732.0
2019-11-04 04:00:00	MSFT	Stock	144.05	144.53	144.05	144.53	1297.0
2019-11-04 04:30:00	MSFT	Stock	144.5	144.77	144.5	144.77	300.0
2019-11-04 05:00:00	MSFT	Stock	144.7	144.8	144.7	144.8	580.0
2019-11-04 05:30:00	MSFT	Stock	144.78	144.8	144.65	144.75	4524.0
2019-11-04 06:00:00	MSFT	Stock	144.75	144.75	144.6	144.6	200.0
2019-11-04 06:30:00	MSFT	Stock	144.73	144.75	144.6	144.6	680.0
2019-11-04 07:00:00	MSFT	Stock	144.6	144.67	144.51	144.6	8674.0
2019-11-04 07:30:00	MSFT	Stock	144.56	144.6	144.51	144.53	7674.0
2019-11-04 08:00:00	MSFT	Stock	144.63	144.67	144.5	144.56	47826.0
2019-11-04 08:30:00	MSFT	Stock	144.57	144.74	144.51	144.55	36276.0
2019-11-04 09:00:00	MSFT	Stock	144.52	144.9	144.36	144.84	49688.0
2019-11-04 09:30:00	MSFT	Stock	144.83	145.0	144.22	144.415	2230201.0
2019-11-04 10:00:00	MSFT	Stock	144.41	144.64	144.16	144.601	1163057.0
2019-11-04 10:30:00	MSFT	Stock	144.605	144.73	144.37	144.43	899213.0
2019-11-04 11:00:00	MSFT	Stock	144.44	144.62	144.39	144.515	849439.0
2019-11-04 11:30:00	MSFT	Stock	144.515	144.75	144.5	144.6	816384.0
2019-11-04 12:00:00	MSFT	Stock	144.6	144.71	144.524	144.65	612614.0
2019-11-04 12:30:00	MSFT	Stock	144.645	144.8	144.6	144.76	685794.0

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

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