PREVIEW / stock_30min / 2020-06-30

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-30.parquet
  size:    1.9 MB
  rows:    98,159
  symbols: 2,456

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-30 04:00:00	AAPL	Stock	90.675	90.675	90.57	90.665	15940.0
2020-06-30 04:30:00	AAPL	Stock	90.665	90.665	90.5575	90.5575	3904.0
2020-06-30 05:00:00	AAPL	Stock	90.565	90.565	90.565	90.565	1348.0
2020-06-30 05:30:00	AAPL	Stock	90.685	90.6875	90.5275	90.5275	4320.0
2020-06-30 06:00:00	AAPL	Stock	90.535	90.555	89.75	89.9375	57628.0
2020-06-30 06:30:00	AAPL	Stock	89.9425	89.975	89.625	89.65	82388.0
2020-06-30 07:00:00	AAPL	Stock	89.7875	90.375	89.7875	90.225	128284.0
2020-06-30 07:30:00	AAPL	Stock	90.25	90.435	90.1625	90.1625	84340.0
2020-06-30 08:00:00	AAPL	Stock	90.355	90.4245	89.7775	90.055	150160.0
2020-06-30 08:30:00	AAPL	Stock	90.03	90.0625	89.8925	90.015	126516.0
2020-06-30 09:00:00	AAPL	Stock	90.05	90.125	89.8875	90.015	121892.0
2020-06-30 09:30:00	AAPL	Stock	90.0175	91.045	90.0	90.9575	13602364.0
2020-06-30 10:00:00	AAPL	Stock	90.9425	91.28	90.8875	91.0525	10293580.0
2020-06-30 10:30:00	AAPL	Stock	91.0425	91.385	90.8875	91.323	7645760.0
2020-06-30 11:00:00	AAPL	Stock	91.325	91.47	91.29	91.295	5198616.0
2020-06-30 11:30:00	AAPL	Stock	91.285	91.3425	91.054	91.3425	4999484.0
2020-06-30 12:00:00	AAPL	Stock	91.3425	91.3925	91.215	91.216	3437356.0
2020-06-30 12:30:00	AAPL	Stock	91.2125	91.2775	90.8125	90.855	4795392.0
2020-06-30 13:00:00	AAPL	Stock	90.85	90.9175	90.4325	90.79	5801732.0
2020-06-30 13:30:00	AAPL	Stock	90.7925	90.8525	90.5425	90.76	4364332.0
2020-06-30 14:00:00	AAPL	Stock	90.7582	90.76	90.295	90.6488	6062832.0
2020-06-30 14:30:00	AAPL	Stock	90.6475	90.8962	90.5125	90.88	4609584.0
2020-06-30 15:00:00	AAPL	Stock	90.8825	90.965	90.5625	90.8975	5680548.0
2020-06-30 15:30:00	AAPL	Stock	90.9025	91.495	90.8325	91.15	15687284.0
2020-06-30 16:00:00	AAPL	Stock	91.1625	91.2525	90.9725	91.215	14756832.0
2020-06-30 16:30:00	AAPL	Stock	91.25	91.2625	91.1875	91.19	29944.0
2020-06-30 17:00:00	AAPL	Stock	91.1875	91.195	91.1575	91.18	25284.0
2020-06-30 17:30:00	AAPL	Stock	91.1575	91.18	91.05	91.1025	51904.0
2020-06-30 18:00:00	AAPL	Stock	91.1	91.18	91.1	91.1525	15224.0
2020-06-30 18:30:00	AAPL	Stock	91.1875	91.1875	91.0875	91.1125	24956.0
2020-06-30 19:00:00	AAPL	Stock	91.0	91.1	91.0	91.025	28300.0
2020-06-30 19:30:00	AAPL	Stock	91.025	91.025	91.0	91.0025	33716.0
2020-06-30 04:00:00	MSFT	Stock	199.06	199.29	199.06	199.29	300.0
2020-06-30 04:30:00	MSFT	Stock	198.92	198.92	198.87	198.87	664.0
2020-06-30 05:00:00	MSFT	Stock	198.53	198.8	198.53	198.8	306.0
2020-06-30 06:30:00	MSFT	Stock	198.99	199.0	198.96	198.96	412.0
2020-06-30 07:00:00	MSFT	Stock	198.82	199.1	198.6	198.88	14263.0
2020-06-30 07:30:00	MSFT	Stock	199.0	199.1	198.5	198.53	7545.0
2020-06-30 08:00:00	MSFT	Stock	199.0	199.0	198.51	198.65	6372.0
2020-06-30 08:30:00	MSFT	Stock	198.56	198.56	197.72	197.92	11047.0
2020-06-30 09:00:00	MSFT	Stock	197.829	198.21	197.675	197.9	16728.0
2020-06-30 09:30:00	MSFT	Stock	197.882	200.03	197.74	199.68	2391756.0
2020-06-30 10:00:00	MSFT	Stock	199.7	200.38	199.67	199.93	1602608.0
2020-06-30 10:30:00	MSFT	Stock	199.92	201.36	199.86	201.35	1738898.0
2020-06-30 11:00:00	MSFT	Stock	201.36	201.622	200.97	201.32	1249604.0
2020-06-30 11:30:00	MSFT	Stock	201.32	201.527	200.94	201.2	968670.0
2020-06-30 12:00:00	MSFT	Stock	201.2	201.85	201.04	201.65	879587.0
2020-06-30 12:30:00	MSFT	Stock	201.64	201.83	200.88	201.37	1056894.0
2020-06-30 13:00:00	MSFT	Stock	201.38	201.73	200.815	201.26	1100832.0
2020-06-30 13:30:00	MSFT	Stock	201.25	201.42	200.81	201.21	693284.0

> showing 50 of 98,159 rows — these rows as CSV

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