PREVIEW / stock_30min / 2019-10-10

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-10.parquet
  size:    1.7 MB
  rows:    82,016
  symbols: 2,522

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-10 04:00:00	AAPL	Stock	56.6725	57.0375	56.5525	56.965	44560.0
2019-10-10 04:30:00	AAPL	Stock	56.92	56.94	56.8825	56.93	19892.0
2019-10-10 05:00:00	AAPL	Stock	56.915	56.95	56.8375	56.8375	22024.0
2019-10-10 05:30:00	AAPL	Stock	56.84	56.88	56.8075	56.875	19688.0
2019-10-10 06:00:00	AAPL	Stock	56.9375	57.075	56.9375	57.02	33204.0
2019-10-10 06:30:00	AAPL	Stock	57.055	57.075	57.0075	57.025	57908.0
2019-10-10 07:00:00	AAPL	Stock	56.97	57.05	56.7625	56.875	167368.0
2019-10-10 07:30:00	AAPL	Stock	56.875	56.9	56.705	56.825	118676.0
2019-10-10 08:00:00	AAPL	Stock	56.9125	57.0	56.6175	56.8775	251784.0
2019-10-10 08:30:00	AAPL	Stock	56.8775	57.0	56.8775	56.9325	185036.0
2019-10-10 09:00:00	AAPL	Stock	56.94	57.0125	56.85	56.9575	129500.0
2019-10-10 09:30:00	AAPL	Stock	56.975	57.55	56.825	57.4655	17803152.0
2019-10-10 10:00:00	AAPL	Stock	57.465	57.4825	57.2375	57.37	9395352.0
2019-10-10 10:30:00	AAPL	Stock	57.375	57.5475	57.3375	57.5338	7333948.0
2019-10-10 11:00:00	AAPL	Stock	57.535	57.61	57.47	57.568	6780436.0
2019-10-10 11:30:00	AAPL	Stock	57.5675	57.595	57.4725	57.5175	4990000.0
2019-10-10 12:00:00	AAPL	Stock	57.5175	57.575	57.4125	57.4555	5528096.0
2019-10-10 12:30:00	AAPL	Stock	57.455	57.485	57.3125	57.475	4449548.0
2019-10-10 13:00:00	AAPL	Stock	57.4725	57.48	57.41	57.43	2410708.0
2019-10-10 13:30:00	AAPL	Stock	57.4275	57.4775	57.2755	57.435	4105332.0
2019-10-10 14:00:00	AAPL	Stock	57.4362	57.4775	57.075	57.3925	6628704.0
2019-10-10 14:30:00	AAPL	Stock	57.39	57.4725	57.3375	57.4425	4009868.0
2019-10-10 15:00:00	AAPL	Stock	57.4425	57.54	57.435	57.5375	5841000.0
2019-10-10 15:30:00	AAPL	Stock	57.54	57.575	57.43	57.5225	9820812.0
2019-10-10 16:00:00	AAPL	Stock	57.5225	57.5625	57.4005	57.5475	4970092.0
2019-10-10 16:30:00	AAPL	Stock	57.55	57.725	57.5225	57.6875	296592.0
2019-10-10 17:00:00	AAPL	Stock	57.705	57.73	57.6875	57.6975	119828.0
2019-10-10 17:30:00	AAPL	Stock	57.71	57.7475	56.7575	57.71	64676.0
2019-10-10 18:00:00	AAPL	Stock	57.71	57.7175	57.6375	57.68	111984.0
2019-10-10 18:30:00	AAPL	Stock	57.6725	57.77	57.6725	57.745	121408.0
2019-10-10 19:00:00	AAPL	Stock	57.75	57.75	57.7125	57.75	33840.0
2019-10-10 19:30:00	AAPL	Stock	57.75	57.8125	57.69	57.8125	126748.0
2019-10-10 04:00:00	MSFT	Stock	137.88	138.4	137.75	138.3	7089.0
2019-10-10 05:00:00	MSFT	Stock	138.33	138.33	138.32	138.33	1796.0
2019-10-10 05:30:00	MSFT	Stock	138.0	138.0	138.0	138.0	252.0
2019-10-10 06:00:00	MSFT	Stock	138.23	138.49	138.22	138.46	9255.0
2019-10-10 06:30:00	MSFT	Stock	138.46	138.46	138.25	138.25	2192.0
2019-10-10 07:00:00	MSFT	Stock	138.24	138.26	138.0	138.2	14682.0
2019-10-10 07:30:00	MSFT	Stock	138.05	138.34	137.88	138.05	11386.0
2019-10-10 08:00:00	MSFT	Stock	138.1	138.39	138.0	138.3	15064.0
2019-10-10 08:30:00	MSFT	Stock	138.29	138.4	138.11	138.34	10136.0
2019-10-10 09:00:00	MSFT	Stock	138.26	138.55	138.1	138.45	20943.0
2019-10-10 09:30:00	MSFT	Stock	138.47	139.39	138.25	139.33	2344068.0
2019-10-10 10:00:00	MSFT	Stock	139.34	139.4	138.93	139.14	1326215.0
2019-10-10 10:30:00	MSFT	Stock	139.15	139.285	138.6	139.285	1014882.0
2019-10-10 11:00:00	MSFT	Stock	139.29	139.665	139.22	139.53	1200986.0
2019-10-10 11:30:00	MSFT	Stock	139.55	139.65	139.38	139.62	780281.0
2019-10-10 12:00:00	MSFT	Stock	139.615	139.67	139.04	139.085	672715.0
2019-10-10 12:30:00	MSFT	Stock	139.08	139.23	138.82	139.2	473420.0
2019-10-10 13:00:00	MSFT	Stock	139.19	139.2	139.0	139.01	489464.0

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

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