PREVIEW / stock_30min / 2019-08-30

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-30.parquet
  size:    1.7 MB
  rows:    83,824
  symbols: 2,571

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-08-30 04:00:00	AAPL	Stock	52.4175	52.5	52.4	52.5	17876.0
2019-08-30 04:30:00	AAPL	Stock	52.48	52.575	52.4625	52.5025	17888.0
2019-08-30 05:00:00	AAPL	Stock	52.625	52.755	52.625	52.755	10768.0
2019-08-30 05:30:00	AAPL	Stock	52.73	52.7475	52.625	52.7	16152.0
2019-08-30 06:00:00	AAPL	Stock	52.7025	52.725	52.625	52.675	10316.0
2019-08-30 06:30:00	AAPL	Stock	52.675	52.6975	52.6125	52.6975	11128.0
2019-08-30 07:00:00	AAPL	Stock	52.6975	52.6975	52.4875	52.4875	93660.0
2019-08-30 07:30:00	AAPL	Stock	52.5125	52.6575	52.5125	52.6375	83576.0
2019-08-30 08:00:00	AAPL	Stock	52.595	52.655	52.4875	52.615	147596.0
2019-08-30 08:30:00	AAPL	Stock	52.615	52.6572	52.575	52.6125	77060.0
2019-08-30 09:00:00	AAPL	Stock	52.6075	52.6375	52.5	52.54	250620.0
2019-08-30 09:30:00	AAPL	Stock	52.54	52.6125	52.3025	52.3402	9902008.0
2019-08-30 10:00:00	AAPL	Stock	52.335	52.4425	52.095	52.175	5429644.0
2019-08-30 10:30:00	AAPL	Stock	52.174	52.3425	52.1675	52.1725	4191348.0
2019-08-30 11:00:00	AAPL	Stock	52.17	52.2125	51.8	51.9	5493628.0
2019-08-30 11:30:00	AAPL	Stock	51.9	52.0375	51.8625	51.9875	3131468.0
2019-08-30 12:00:00	AAPL	Stock	51.9908	52.0142	51.825	51.9175	3462636.0
2019-08-30 12:30:00	AAPL	Stock	51.9225	51.9735	51.8425	51.9538	2151780.0
2019-08-30 13:00:00	AAPL	Stock	51.9535	51.9825	51.8462	51.9142	1841428.0
2019-08-30 13:30:00	AAPL	Stock	51.9175	51.9525	51.875	51.9225	1797548.0
2019-08-30 14:00:00	AAPL	Stock	51.9212	51.9875	51.905	51.965	1923904.0
2019-08-30 14:30:00	AAPL	Stock	51.97	52.0125	51.8575	51.91	2647044.0
2019-08-30 15:00:00	AAPL	Stock	51.9125	52.0075	51.8025	51.97	2996004.0
2019-08-30 15:30:00	AAPL	Stock	51.97	52.1875	51.865	52.185	11323704.0
2019-08-30 16:00:00	AAPL	Stock	52.185	52.2	51.945	52.0375	12034564.0
2019-08-30 16:30:00	AAPL	Stock	52.0375	52.11	52.035	52.0375	47116.0
2019-08-30 17:00:00	AAPL	Stock	52.185	52.185	52.04	52.07	223460.0
2019-08-30 17:30:00	AAPL	Stock	52.0525	52.1	52.0525	52.0875	12392.0
2019-08-30 18:00:00	AAPL	Stock	52.0675	52.0725	52.0375	52.0625	10492.0
2019-08-30 18:30:00	AAPL	Stock	52.0375	52.0375	52.0375	52.0375	15280.0
2019-08-30 19:00:00	AAPL	Stock	52.0375	52.05	52.025	52.025	5752.0
2019-08-30 19:30:00	AAPL	Stock	52.05	52.1125	52.0	52.0375	43472.0
2019-08-30 04:00:00	MSFT	Stock	138.4	138.64	138.4	138.63	572.0
2019-08-30 04:30:00	MSFT	Stock	138.78	139.0	138.68	139.0	2176.0
2019-08-30 05:00:00	MSFT	Stock	139.03	139.03	138.92	138.94	400.0
2019-08-30 05:30:00	MSFT	Stock	139.1	139.1	139.1	139.1	386.0
2019-08-30 06:00:00	MSFT	Stock	139.1	139.1	139.1	139.1	1163.0
2019-08-30 06:30:00	MSFT	Stock	139.22	139.38	139.19	139.37	1700.0
2019-08-30 07:00:00	MSFT	Stock	139.2	139.25	138.8	138.87	10091.0
2019-08-30 07:30:00	MSFT	Stock	138.88	139.1	138.85	139.0	11293.0
2019-08-30 08:00:00	MSFT	Stock	139.0	139.24	138.8	139.02	31445.0
2019-08-30 08:30:00	MSFT	Stock	139.09	139.15	138.95	139.001	20876.0
2019-08-30 09:00:00	MSFT	Stock	139.001	139.18	138.8	139.17	34306.0
2019-08-30 09:30:00	MSFT	Stock	139.15	139.18	138.28	138.42	1739046.0
2019-08-30 10:00:00	MSFT	Stock	138.41	138.59	137.54	137.65	1185736.0
2019-08-30 10:30:00	MSFT	Stock	137.64	137.94	137.63	137.69	850267.0
2019-08-30 11:00:00	MSFT	Stock	137.68	137.78	136.27	136.6	1412578.0
2019-08-30 11:30:00	MSFT	Stock	136.6	137.29	136.6	137.078	856676.0
2019-08-30 12:00:00	MSFT	Stock	137.1	137.26	136.81	137.2	620797.0
2019-08-30 12:30:00	MSFT	Stock	137.21	137.27	136.92	137.156	506785.0

> showing 50 of 83,824 rows — these rows as CSV

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