PREVIEW / stock_30min / 2019-10-25

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-25.parquet
  size:    1.7 MB
  rows:    82,526
  symbols: 2,501

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-10-25 05:00:00	AAPL	Stock	60.75	60.75	60.75	60.75	800.0
2019-10-25 06:30:00	AAPL	Stock	60.85	60.9275	60.85	60.895	15584.0
2019-10-25 07:00:00	AAPL	Stock	60.93	60.94	60.8825	60.8825	14420.0
2019-10-25 07:30:00	AAPL	Stock	60.8625	60.8925	60.84	60.84	24088.0
2019-10-25 08:00:00	AAPL	Stock	60.935	60.95	60.745	60.815	112004.0
2019-10-25 08:30:00	AAPL	Stock	60.8025	60.8325	60.75	60.765	106356.0
2019-10-25 09:00:00	AAPL	Stock	60.7875	60.825	60.75	60.815	67740.0
2019-10-25 09:30:00	AAPL	Stock	60.7925	61.025	60.72	60.87	6564564.0
2019-10-25 10:00:00	AAPL	Stock	60.865	61.1375	60.81	61.1375	5281908.0
2019-10-25 10:30:00	AAPL	Stock	61.1375	61.1725	60.9525	61.1315	4166840.0
2019-10-25 11:00:00	AAPL	Stock	61.1325	61.463	61.085	61.3825	6678868.0
2019-10-25 11:30:00	AAPL	Stock	61.38	61.415	61.2825	61.3425	4135044.0
2019-10-25 12:00:00	AAPL	Stock	61.3432	61.42	61.265	61.378	3296392.0
2019-10-25 12:30:00	AAPL	Stock	61.3875	61.412	61.2712	61.315	1982712.0
2019-10-25 13:00:00	AAPL	Stock	61.3202	61.3525	61.275	61.3288	1610020.0
2019-10-25 13:30:00	AAPL	Stock	61.3288	61.39	61.3	61.315	1867280.0
2019-10-25 14:00:00	AAPL	Stock	61.3175	61.3375	61.175	61.3155	2968724.0
2019-10-25 14:30:00	AAPL	Stock	61.315	61.37	61.2725	61.3525	2126568.0
2019-10-25 15:00:00	AAPL	Stock	61.3475	61.455	61.335	61.4125	3299180.0
2019-10-25 15:30:00	AAPL	Stock	61.415	61.6825	61.3925	61.645	10526856.0
2019-10-25 16:00:00	AAPL	Stock	61.645	61.6875	61.63	61.66	6831004.0
2019-10-25 16:30:00	AAPL	Stock	61.645	61.75	61.645	61.7125	268544.0
2019-10-25 17:00:00	AAPL	Stock	61.7125	61.72	61.6825	61.6975	27908.0
2019-10-25 17:30:00	AAPL	Stock	61.71	61.7125	61.675	61.7	33824.0
2019-10-25 18:00:00	AAPL	Stock	61.69	61.7075	61.675	61.6825	40788.0
2019-10-25 18:30:00	AAPL	Stock	61.6575	61.675	61.655	61.675	9700.0
2019-10-25 19:00:00	AAPL	Stock	61.675	61.685	61.65	61.675	60228.0
2019-10-25 19:30:00	AAPL	Stock	61.6725	61.6875	61.6725	61.6875	55728.0
2019-10-25 05:00:00	MSFT	Stock	139.31	139.8	139.31	139.8	799.0
2019-10-25 06:30:00	MSFT	Stock	139.85	139.94	139.85	139.94	400.0
2019-10-25 07:00:00	MSFT	Stock	139.82	139.94	139.77	139.82	3832.0
2019-10-25 07:30:00	MSFT	Stock	139.78	139.8	139.76	139.78	5546.0
2019-10-25 08:00:00	MSFT	Stock	139.85	140.28	139.62	139.705	10944.0
2019-10-25 08:30:00	MSFT	Stock	139.61	139.66	139.4	139.51	13255.0
2019-10-25 09:00:00	MSFT	Stock	139.46	139.69	139.278	139.3	28648.0
2019-10-25 09:30:00	MSFT	Stock	139.35	140.38	139.2	140.315	2857591.0
2019-10-25 10:00:00	MSFT	Stock	140.31	141.07	140.29	140.62	2789367.0
2019-10-25 10:30:00	MSFT	Stock	140.64	140.87	140.47	140.77	1524133.0
2019-10-25 11:00:00	MSFT	Stock	140.78	141.14	140.6	140.95	1745905.0
2019-10-25 11:30:00	MSFT	Stock	140.95	141.08	140.73	140.86	1038402.0
2019-10-25 12:00:00	MSFT	Stock	140.86	140.93	140.55	140.74	820369.0
2019-10-25 12:30:00	MSFT	Stock	140.735	140.76	140.5	140.62	790253.0
2019-10-25 13:00:00	MSFT	Stock	140.635	140.87	140.59	140.655	673750.0
2019-10-25 13:30:00	MSFT	Stock	140.66	140.72	140.5	140.56	743366.0
2019-10-25 14:00:00	MSFT	Stock	140.56	140.62	140.36	140.415	643338.0
2019-10-25 14:30:00	MSFT	Stock	140.414	140.47	140.18	140.44	857178.0
2019-10-25 15:00:00	MSFT	Stock	140.43	140.59	140.32	140.46	892312.0
2019-10-25 15:30:00	MSFT	Stock	140.465	140.814	140.31	140.73	2689022.0
2019-10-25 16:00:00	MSFT	Stock	140.74	140.8	140.63	140.67	3838754.0
2019-10-25 16:30:00	MSFT	Stock	140.73	140.78	140.65	140.75	116367.0

> showing 50 of 82,526 rows — these rows as CSV

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