PREVIEW / stock_30min / 2019-06-05

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-06-05.parquet
  size:    1.7 MB
  rows:    84,049
  symbols: 2,592

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-06-05 04:00:00	AAPL	Stock	45.4975	45.4975	45.42	45.42	19868.0
2019-06-05 04:30:00	AAPL	Stock	45.5	45.5	45.435	45.5	10244.0
2019-06-05 05:00:00	AAPL	Stock	45.495	45.675	45.415	45.625	95136.0
2019-06-05 05:30:00	AAPL	Stock	45.6125	45.675	45.6125	45.625	9744.0
2019-06-05 06:00:00	AAPL	Stock	45.6875	45.6875	45.595	45.6	13464.0
2019-06-05 06:30:00	AAPL	Stock	45.6125	45.75	45.6	45.665	40824.0
2019-06-05 07:00:00	AAPL	Stock	45.6675	45.7925	45.65	45.725	221632.0
2019-06-05 07:30:00	AAPL	Stock	45.72	45.97	45.6375	45.9575	286540.0
2019-06-05 08:00:00	AAPL	Stock	45.725	46.0875	45.6355	45.7875	913872.0
2019-06-05 08:30:00	AAPL	Stock	45.8175	45.97	45.75	45.8725	372768.0
2019-06-05 09:00:00	AAPL	Stock	45.875	46.0675	45.8575	46.0625	555556.0
2019-06-05 09:30:00	AAPL	Stock	46.0625	46.2475	45.695	46.0625	23935984.0
2019-06-05 10:00:00	AAPL	Stock	46.065	46.125	45.575	45.61	12236808.0
2019-06-05 10:30:00	AAPL	Stock	45.61	45.62	45.285	45.4225	9300568.0
2019-06-05 11:00:00	AAPL	Stock	45.4225	45.803	45.3475	45.755	7340428.0
2019-06-05 11:30:00	AAPL	Stock	45.7575	45.8775	45.5875	45.735	6426412.0
2019-06-05 12:00:00	AAPL	Stock	45.725	45.775	45.4925	45.605	4374564.0
2019-06-05 12:30:00	AAPL	Stock	45.5975	45.62	45.475	45.5025	3577564.0
2019-06-05 13:00:00	AAPL	Stock	45.51	45.6775	45.51	45.6025	2860012.0
2019-06-05 13:30:00	AAPL	Stock	45.605	45.665	45.49	45.5725	2850584.0
2019-06-05 14:00:00	AAPL	Stock	45.57	45.66	45.5	45.625	2851772.0
2019-06-05 14:30:00	AAPL	Stock	45.624	45.6705	45.5025	45.58	2637888.0
2019-06-05 15:00:00	AAPL	Stock	45.58	45.655	45.495	45.5975	4016808.0
2019-06-05 15:30:00	AAPL	Stock	45.5975	45.735	45.395	45.6352	9434624.0
2019-06-05 16:00:00	AAPL	Stock	45.6325	45.7228	45.6	45.615	9453320.0
2019-06-05 16:30:00	AAPL	Stock	45.64	45.6725	45.625	45.665	11188.0
2019-06-05 17:00:00	AAPL	Stock	45.6812	45.6825	45.6375	45.6375	10836.0
2019-06-05 17:30:00	AAPL	Stock	45.65	45.655	45.5	45.5	26864.0
2019-06-05 18:00:00	AAPL	Stock	45.56	45.56	45.3875	45.39	40384.0
2019-06-05 18:30:00	AAPL	Stock	45.3875	45.4625	45.305	45.365	56528.0
2019-06-05 19:00:00	AAPL	Stock	45.4025	45.45	45.4	45.405	9644.0
2019-06-05 19:30:00	AAPL	Stock	45.45	45.5	45.44	45.46	18712.0
2019-06-05 04:00:00	MSFT	Stock	124.35	124.35	124.17	124.17	300.0
2019-06-05 04:30:00	MSFT	Stock	124.1	124.1	123.99	124.08	500.0
2019-06-05 05:00:00	MSFT	Stock	123.97	124.22	123.9	124.22	3920.0
2019-06-05 05:30:00	MSFT	Stock	124.53	124.53	124.42	124.53	1493.0
2019-06-05 06:00:00	MSFT	Stock	124.67	124.8	124.64	124.73	2400.0
2019-06-05 06:30:00	MSFT	Stock	124.89	124.89	124.65	124.66	5352.0
2019-06-05 07:00:00	MSFT	Stock	124.69	124.73	124.5	124.55	22060.0
2019-06-05 07:30:00	MSFT	Stock	124.68	124.68	124.42	124.58	4820.0
2019-06-05 08:00:00	MSFT	Stock	124.65	124.83	124.12	124.3	36574.0
2019-06-05 08:30:00	MSFT	Stock	124.18	124.63	124.11	124.4	24480.0
2019-06-05 09:00:00	MSFT	Stock	124.3	125.02	124.29	125.01	26738.0
2019-06-05 09:30:00	MSFT	Stock	124.96	125.46	124.64	125.41	3152845.0
2019-06-05 10:00:00	MSFT	Stock	125.415	125.67	124.66	124.78	1923144.0
2019-06-05 10:30:00	MSFT	Stock	124.78	125.02	124.21	124.52	1472348.0
2019-06-05 11:00:00	MSFT	Stock	124.53	125.34	124.39	125.28	1107348.0
2019-06-05 11:30:00	MSFT	Stock	125.285	125.42	125.0	125.25	1038272.0
2019-06-05 12:00:00	MSFT	Stock	125.24	125.37	124.7	125.04	937480.0
2019-06-05 12:30:00	MSFT	Stock	125.034	125.07	124.69	124.85	840392.0

> showing 50 of 84,049 rows — these rows as CSV

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