PREVIEW / stock_30min / 2020-07-06

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-06.parquet
  size:    2.0 MB
  rows:    100,053
  symbols: 2,445

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-07-06 04:00:00	AAPL	Stock	92.255	92.75	92.255	92.6275	42428.0
2020-07-06 04:30:00	AAPL	Stock	92.6675	92.6675	92.4775	92.4875	10080.0
2020-07-06 05:00:00	AAPL	Stock	92.475	92.58	92.375	92.475	15000.0
2020-07-06 05:30:00	AAPL	Stock	92.545	92.5675	92.525	92.5625	3984.0
2020-07-06 06:00:00	AAPL	Stock	92.55	92.625	92.55	92.575	5196.0
2020-07-06 06:30:00	AAPL	Stock	92.575	92.625	92.5	92.6	19508.0
2020-07-06 07:00:00	AAPL	Stock	92.55	92.55	92.28	92.3875	157996.0
2020-07-06 07:30:00	AAPL	Stock	92.39	92.475	92.3575	92.4425	145220.0
2020-07-06 08:00:00	AAPL	Stock	92.2812	92.495	92.2775	92.45	241388.0
2020-07-06 08:30:00	AAPL	Stock	92.46	92.475	92.3275	92.3565	123108.0
2020-07-06 09:00:00	AAPL	Stock	92.3625	92.5075	92.325	92.5075	301816.0
2020-07-06 09:30:00	AAPL	Stock	92.5	93.375	92.4675	93.2975	18127096.0
2020-07-06 10:00:00	AAPL	Stock	93.305	93.475	92.9775	93.2915	9049732.0
2020-07-06 10:30:00	AAPL	Stock	93.29	93.75	93.2525	93.745	7618188.0
2020-07-06 11:00:00	AAPL	Stock	93.745	93.89	93.6475	93.8075	7048428.0
2020-07-06 11:30:00	AAPL	Stock	93.81	93.945	93.555	93.5988	5604816.0
2020-07-06 12:00:00	AAPL	Stock	93.595	93.6625	93.3275	93.4	4760656.0
2020-07-06 12:30:00	AAPL	Stock	93.4	93.7	93.325	93.5312	3497576.0
2020-07-06 13:00:00	AAPL	Stock	93.5375	93.5525	93.3075	93.4525	3371932.0
2020-07-06 13:30:00	AAPL	Stock	93.4625	93.5475	93.335	93.3655	3011116.0
2020-07-06 14:00:00	AAPL	Stock	93.3675	93.38	92.99	93.1925	4236836.0
2020-07-06 14:30:00	AAPL	Stock	93.1845	93.3775	93.105	93.2645	3769644.0
2020-07-06 15:00:00	AAPL	Stock	93.2575	93.3488	93.0025	93.3262	4121164.0
2020-07-06 15:30:00	AAPL	Stock	93.3225	93.6025	93.3225	93.4525	8927176.0
2020-07-06 16:00:00	AAPL	Stock	93.4625	93.5575	93.375	93.5325	10190696.0
2020-07-06 16:30:00	AAPL	Stock	93.5425	93.55	93.4625	93.4975	17212.0
2020-07-06 17:00:00	AAPL	Stock	93.4625	93.525	93.45	93.495	267092.0
2020-07-06 17:30:00	AAPL	Stock	93.48	93.525	93.4375	93.475	15664.0
2020-07-06 18:00:00	AAPL	Stock	93.4175	93.4925	93.4125	93.425	13052.0
2020-07-06 18:30:00	AAPL	Stock	93.425	93.5625	93.4075	93.5625	39344.0
2020-07-06 19:00:00	AAPL	Stock	93.575	93.75	93.575	93.7425	51676.0
2020-07-06 19:30:00	AAPL	Stock	93.725	93.8725	93.6375	93.8625	117236.0
2020-07-06 04:00:00	MSFT	Stock	208.2	209.36	208.2	209.3	4105.0
2020-07-06 04:30:00	MSFT	Stock	209.1	209.1	208.77	209.03	1506.0
2020-07-06 05:00:00	MSFT	Stock	209.03	209.05	208.98	208.98	1356.0
2020-07-06 05:30:00	MSFT	Stock	209.1	209.1	209.02	209.1	863.0
2020-07-06 06:00:00	MSFT	Stock	209.1	209.49	209.1	209.49	3033.0
2020-07-06 06:30:00	MSFT	Stock	209.35	209.5	208.99	209.36	8082.0
2020-07-06 07:00:00	MSFT	Stock	209.1	209.51	208.8	209.0	35219.0
2020-07-06 07:30:00	MSFT	Stock	208.99	209.23	208.99	209.08	37870.0
2020-07-06 08:00:00	MSFT	Stock	209.094	209.5	208.8	209.4	38549.0
2020-07-06 08:30:00	MSFT	Stock	209.35	209.45	209.19	209.244	29679.0
2020-07-06 09:00:00	MSFT	Stock	209.24	209.35	208.5	208.7	29765.0
2020-07-06 09:30:00	MSFT	Stock	208.71	209.35	208.09	209.025	3696785.0
2020-07-06 10:00:00	MSFT	Stock	209.03	210.06	208.75	209.3	2761166.0
2020-07-06 10:30:00	MSFT	Stock	209.32	210.01	209.17	209.955	1424625.0
2020-07-06 11:00:00	MSFT	Stock	209.95	210.895	209.83	210.82	1479263.0
2020-07-06 11:30:00	MSFT	Stock	210.85	211.13	210.342	210.585	1308043.0
2020-07-06 12:00:00	MSFT	Stock	210.584	210.819	209.62	210.17	1439600.0
2020-07-06 12:30:00	MSFT	Stock	210.16	211.07	210.05	210.927	1342528.0

> showing 50 of 100,053 rows — these rows as CSV

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