PREVIEW / stock_30min / 2020-08-03

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-08-03.parquet
  size:    2.0 MB
  rows:    99,200
  symbols: 2,452

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-08-03 04:00:00	AAPL	Stock	106.86	107.325	106.86	107.0	58356.0
2020-08-03 04:30:00	AAPL	Stock	107.0	107.0	106.825	106.87	30568.0
2020-08-03 05:00:00	AAPL	Stock	106.9925	107.0	106.875	106.9975	13968.0
2020-08-03 05:30:00	AAPL	Stock	106.945	106.945	106.765	106.765	13848.0
2020-08-03 06:00:00	AAPL	Stock	106.765	107.12	106.765	107.1125	59272.0
2020-08-03 06:30:00	AAPL	Stock	107.11	107.37	107.0325	107.3	101432.0
2020-08-03 07:00:00	AAPL	Stock	107.3	108.07	107.3	107.875	950116.0
2020-08-03 07:30:00	AAPL	Stock	107.905	108.2925	107.815	107.875	620080.0
2020-08-03 08:00:00	AAPL	Stock	107.82	108.295	107.375	107.98	1257392.0
2020-08-03 08:30:00	AAPL	Stock	107.98	108.2375	107.9225	108.15	734992.0
2020-08-03 09:00:00	AAPL	Stock	108.1692	108.5	107.75	108.3125	1425004.0
2020-08-03 09:30:00	AAPL	Stock	108.3075	111.18	107.8925	110.545	56296792.0
2020-08-03 10:00:00	AAPL	Stock	110.53	111.6365	109.735	109.8275	33982880.0
2020-08-03 10:30:00	AAPL	Stock	109.8265	110.32	109.07	109.55	26971016.0
2020-08-03 11:00:00	AAPL	Stock	109.5575	110.165	109.43	109.8175	14455460.0
2020-08-03 11:30:00	AAPL	Stock	109.8312	109.8525	109.2275	109.846	10255516.0
2020-08-03 12:00:00	AAPL	Stock	109.8525	109.915	109.485	109.7092	8309164.0
2020-08-03 12:30:00	AAPL	Stock	109.7075	109.795	108.845	109.185	12377508.0
2020-08-03 13:00:00	AAPL	Stock	109.181	109.4075	108.925	109.0275	9147080.0
2020-08-03 13:30:00	AAPL	Stock	109.0375	109.1072	108.65	108.98	8594048.0
2020-08-03 14:00:00	AAPL	Stock	108.995	109.65	108.925	109.5532	10594684.0
2020-08-03 14:30:00	AAPL	Stock	109.5562	109.9075	109.09	109.6425	12067772.0
2020-08-03 15:00:00	AAPL	Stock	109.6575	109.7225	109.015	109.2088	12554916.0
2020-08-03 15:30:00	AAPL	Stock	109.245	109.5098	108.77	108.915	14244164.0
2020-08-03 16:00:00	AAPL	Stock	108.9375	109.6525	108.75	108.7625	7755984.0
2020-08-03 16:30:00	AAPL	Stock	108.785	108.925	108.7825	108.9225	87080.0
2020-08-03 17:00:00	AAPL	Stock	108.905	108.9125	108.8125	108.8125	43100.0
2020-08-03 17:30:00	AAPL	Stock	108.8325	108.8375	108.75	108.8375	47676.0
2020-08-03 18:00:00	AAPL	Stock	108.8375	108.87	108.8375	108.85	44300.0
2020-08-03 18:30:00	AAPL	Stock	108.8375	108.85	108.75	108.75	30968.0
2020-08-03 19:00:00	AAPL	Stock	108.7625	108.7875	108.635	108.635	51792.0
2020-08-03 19:30:00	AAPL	Stock	108.6325	108.93	108.6	108.9	126264.0
2020-08-03 04:00:00	MSFT	Stock	207.71	209.58	205.5	209.0	123701.0
2020-08-03 04:30:00	MSFT	Stock	209.2	210.0	209.0	209.71	54620.0
2020-08-03 05:00:00	MSFT	Stock	210.0	210.34	208.38	208.38	29815.0
2020-08-03 05:30:00	MSFT	Stock	208.49	209.38	208.49	208.89	10568.0
2020-08-03 06:00:00	MSFT	Stock	208.95	209.4	208.31	209.3	12293.0
2020-08-03 06:30:00	MSFT	Stock	209.33	209.74	208.3	209.46	61555.0
2020-08-03 07:00:00	MSFT	Stock	209.58	211.74	209.3	210.8	263869.0
2020-08-03 07:30:00	MSFT	Stock	210.9	211.0	209.85	210.5	129414.0
2020-08-03 08:00:00	MSFT	Stock	211.23	211.75	209.5	211.65	507524.0
2020-08-03 08:30:00	MSFT	Stock	211.65	211.73	211.01	211.524	267199.0
2020-08-03 09:00:00	MSFT	Stock	211.52	212.0	209.8	211.55	550267.0
2020-08-03 09:30:00	MSFT	Stock	211.55	215.16	210.44	212.955	13540221.0
2020-08-03 10:00:00	MSFT	Stock	212.97	214.04	212.35	213.26	4450697.0
2020-08-03 10:30:00	MSFT	Stock	213.27	213.72	211.38	212.445	3639384.0
2020-08-03 11:00:00	MSFT	Stock	212.44	213.54	212.27	213.47	2538501.0
2020-08-03 11:30:00	MSFT	Stock	213.47	214.13	213.24	214.115	2310690.0
2020-08-03 12:00:00	MSFT	Stock	214.116	214.27	213.42	213.88	1792977.0
2020-08-03 12:30:00	MSFT	Stock	213.86	214.29	213.18	213.73	1540495.0

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

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