PREVIEW / stock_30min / 2019-04-01

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-04-01.parquet
  size:    1.8 MB
  rows:    86,704
  symbols: 2,639

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-04-01 04:00:00	AAPL	Stock	47.885	48.07	47.885	47.905	23756.0
2019-04-01 04:30:00	AAPL	Stock	48.025	48.0675	47.995	48.0125	18552.0
2019-04-01 05:00:00	AAPL	Stock	48.0	48.0	47.955	47.955	3740.0
2019-04-01 05:30:00	AAPL	Stock	47.975	48.0375	47.975	47.9775	4020.0
2019-04-01 06:00:00	AAPL	Stock	48.0	48.0	47.955	47.955	2376.0
2019-04-01 06:30:00	AAPL	Stock	47.985	48.035	47.965	48.035	14284.0
2019-04-01 07:00:00	AAPL	Stock	48.005	48.0375	47.89	47.9475	58824.0
2019-04-01 07:30:00	AAPL	Stock	47.925	47.965	47.895	47.9375	52212.0
2019-04-01 08:00:00	AAPL	Stock	47.95	48.0	47.6075	47.9	248876.0
2019-04-01 08:30:00	AAPL	Stock	47.8875	47.925	47.84	47.86	130312.0
2019-04-01 09:00:00	AAPL	Stock	47.837	47.9175	47.837	47.91	413748.0
2019-04-01 09:30:00	AAPL	Stock	47.91	47.92	47.425	47.5372	13936796.0
2019-04-01 10:00:00	AAPL	Stock	47.5375	47.6225	47.14	47.2375	13391164.0
2019-04-01 10:30:00	AAPL	Stock	47.235	47.4075	47.095	47.35	7959208.0
2019-04-01 11:00:00	AAPL	Stock	47.35	47.6	47.35	47.5525	7429060.0
2019-04-01 11:30:00	AAPL	Stock	47.555	47.5625	47.42	47.5525	4163576.0
2019-04-01 12:00:00	AAPL	Stock	47.5515	47.6025	47.4625	47.5675	3820420.0
2019-04-01 12:30:00	AAPL	Stock	47.5725	47.645	47.5338	47.64	2862572.0
2019-04-01 13:00:00	AAPL	Stock	47.6425	47.6725	47.4825	47.5485	3718060.0
2019-04-01 13:30:00	AAPL	Stock	47.5475	47.695	47.5325	47.6805	3053096.0
2019-04-01 14:00:00	AAPL	Stock	47.68	47.7075	47.62	47.655	3388372.0
2019-04-01 14:30:00	AAPL	Stock	47.6555	47.7725	47.6425	47.7712	3681248.0
2019-04-01 15:00:00	AAPL	Stock	47.772	47.7875	47.69	47.7825	4209296.0
2019-04-01 15:30:00	AAPL	Stock	47.7825	47.865	47.7325	47.81	10410124.0
2019-04-01 16:00:00	AAPL	Stock	47.81	47.8375	47.7625	47.8375	12463172.0
2019-04-01 16:30:00	AAPL	Stock	47.8125	47.8475	47.81	47.825	571568.0
2019-04-01 17:00:00	AAPL	Stock	47.8075	47.8075	47.775	47.8	11136.0
2019-04-01 17:30:00	AAPL	Stock	47.79	47.79	47.78	47.78	8924.0
2019-04-01 18:00:00	AAPL	Stock	47.79	47.8125	47.79	47.805	11844.0
2019-04-01 18:30:00	AAPL	Stock	47.795	47.8	47.765	47.7825	14272.0
2019-04-01 19:00:00	AAPL	Stock	47.795	47.795	47.785	47.7875	2688.0
2019-04-01 19:30:00	AAPL	Stock	47.7875	47.85	47.7875	47.85	39724.0
2019-04-01 04:00:00	MSFT	Stock	118.81	119.2	118.81	119.05	3173.0
2019-04-01 04:30:00	MSFT	Stock	119.31	119.31	119.31	119.31	100.0
2019-04-01 05:00:00	MSFT	Stock	119.48	119.48	119.1	119.1	559.0
2019-04-01 05:30:00	MSFT	Stock	119.06	119.06	119.02	119.02	1645.0
2019-04-01 06:00:00	MSFT	Stock	118.9	118.9	118.9	118.9	336.0
2019-04-01 06:30:00	MSFT	Stock	119.05	119.4	119.05	119.4	4880.0
2019-04-01 07:00:00	MSFT	Stock	119.17	119.3	119.06	119.11	7843.0
2019-04-01 07:30:00	MSFT	Stock	119.12	119.14	119.0	119.0	2087.0
2019-04-01 08:00:00	MSFT	Stock	119.25	119.3	118.95	119.0	30940.0
2019-04-01 08:30:00	MSFT	Stock	118.9	119.01	117.94	118.99	13019.0
2019-04-01 09:00:00	MSFT	Stock	118.809	119.02	118.3	118.3	38367.0
2019-04-01 09:30:00	MSFT	Stock	118.57	118.98	118.37	118.565	2566870.0
2019-04-01 10:00:00	MSFT	Stock	118.57	118.81	118.1	118.299	1258500.0
2019-04-01 10:30:00	MSFT	Stock	118.295	118.495	118.2	118.45	814236.0
2019-04-01 11:00:00	MSFT	Stock	118.46	118.89	118.43	118.7	1048648.0
2019-04-01 11:30:00	MSFT	Stock	118.695	118.864	118.65	118.667	665951.0
2019-04-01 12:00:00	MSFT	Stock	118.666	118.71	118.495	118.68	699517.0
2019-04-01 12:30:00	MSFT	Stock	118.68	118.94	118.66	118.915	583178.0

> showing 50 of 86,704 rows — these rows as CSV

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