PREVIEW / stock_30min / 2020-06-19

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-19.parquet
  size:    2.0 MB
  rows:    99,981
  symbols: 2,446

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
2020-06-19 04:00:00	AAPL	Stock	88.5125	88.6	88.39	88.39	7316.0
2020-06-19 04:30:00	AAPL	Stock	88.3375	88.475	88.3375	88.475	1572.0
2020-06-19 05:00:00	AAPL	Stock	88.575	88.6	88.495	88.5	12328.0
2020-06-19 05:30:00	AAPL	Stock	88.625	88.625	88.455	88.455	12592.0
2020-06-19 06:00:00	AAPL	Stock	88.475	88.5725	88.475	88.49	15556.0
2020-06-19 06:30:00	AAPL	Stock	88.4875	88.4875	88.3875	88.47	16964.0
2020-06-19 07:00:00	AAPL	Stock	88.47	88.595	88.3525	88.51	194208.0
2020-06-19 07:30:00	AAPL	Stock	88.5125	88.7125	88.495	88.7125	114240.0
2020-06-19 08:00:00	AAPL	Stock	88.715	88.8875	88.375	88.68	380440.0
2020-06-19 08:30:00	AAPL	Stock	88.715	88.9125	88.68	88.9	348836.0
2020-06-19 09:00:00	AAPL	Stock	88.9	89.2375	88.61	88.635	1331252.0
2020-06-19 09:30:00	AAPL	Stock	88.635	89.14	88.6125	88.7525	29418048.0
2020-06-19 10:00:00	AAPL	Stock	88.7575	88.9475	88.53	88.67	7981468.0
2020-06-19 10:30:00	AAPL	Stock	88.67	88.6825	88.315	88.5275	5797140.0
2020-06-19 11:00:00	AAPL	Stock	88.5325	88.7675	88.24	88.4275	5999716.0
2020-06-19 11:30:00	AAPL	Stock	88.42	88.4585	88.243	88.3062	4108416.0
2020-06-19 12:00:00	AAPL	Stock	88.3075	88.335	87.03	87.4012	17652016.0
2020-06-19 12:30:00	AAPL	Stock	87.395	87.79	87.205	87.745	9063732.0
2020-06-19 13:00:00	AAPL	Stock	87.7415	87.755	87.14	87.1725	6463240.0
2020-06-19 13:30:00	AAPL	Stock	87.1688	87.3225	86.79	86.7975	10119760.0
2020-06-19 14:00:00	AAPL	Stock	86.7975	86.9975	86.4225	86.45	10371624.0
2020-06-19 14:30:00	AAPL	Stock	86.4538	86.9375	86.2875	86.8375	10625500.0
2020-06-19 15:00:00	AAPL	Stock	86.85	87.2125	86.5425	86.94	10316168.0
2020-06-19 15:30:00	AAPL	Stock	86.94	87.58	86.78	87.3875	22226952.0
2020-06-19 16:00:00	AAPL	Stock	87.3775	87.4925	86.9075	87.0375	57517264.0
2020-06-19 16:30:00	AAPL	Stock	87.04	87.43	86.8575	86.9	193628.0
2020-06-19 17:00:00	AAPL	Stock	86.9125	87.0525	86.8625	87.0	67384.0
2020-06-19 17:30:00	AAPL	Stock	87.0	87.075	83.75	87.075	1225884.0
2020-06-19 18:00:00	AAPL	Stock	87.075	87.075	87.0125	87.0175	15928.0
2020-06-19 18:30:00	AAPL	Stock	87.025	87.025	86.875	86.9	40748.0
2020-06-19 19:00:00	AAPL	Stock	86.9375	86.9375	86.8875	86.8875	16116.0
2020-06-19 19:30:00	AAPL	Stock	86.8875	86.925	86.765	86.7675	44444.0
2020-06-19 04:00:00	MSFT	Stock	197.04	197.04	197.04	197.04	480.0
2020-06-19 04:30:00	MSFT	Stock	197.09	197.1	197.09	197.1	995.0
2020-06-19 05:30:00	MSFT	Stock	197.49	197.5	197.39	197.39	2722.0
2020-06-19 06:00:00	MSFT	Stock	197.49	197.49	197.21	197.21	693.0
2020-06-19 06:30:00	MSFT	Stock	197.5	197.5	197.5	197.5	210.0
2020-06-19 07:00:00	MSFT	Stock	197.3	197.88	197.21	197.81	27166.0
2020-06-19 07:30:00	MSFT	Stock	197.92	198.0	197.61	197.98	13423.0
2020-06-19 08:00:00	MSFT	Stock	197.69	198.5	197.355	198.29	96922.0
2020-06-19 08:30:00	MSFT	Stock	198.28	198.85	198.28	198.65	47026.0
2020-06-19 09:00:00	MSFT	Stock	198.61	199.84	198.25	198.29	382549.0
2020-06-19 09:30:00	MSFT	Stock	198.29	199.23	198.19	198.43	9965406.0
2020-06-19 10:00:00	MSFT	Stock	198.435	199.29	198.33	198.62	1783657.0
2020-06-19 10:30:00	MSFT	Stock	198.645	198.76	197.8	197.98	1449407.0
2020-06-19 11:00:00	MSFT	Stock	197.985	198.469	197.49	197.785	1369245.0
2020-06-19 11:30:00	MSFT	Stock	197.81	197.935	196.94	197.019	1127890.0
2020-06-19 12:00:00	MSFT	Stock	197.015	197.14	194.37	195.707	3064837.0
2020-06-19 12:30:00	MSFT	Stock	195.66	196.93	195.59	196.882	1644445.0
2020-06-19 13:00:00	MSFT	Stock	196.9	196.94	195.6	195.91	1196696.0

> showing 50 of 99,981 rows — these rows as CSV

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