PREVIEW / stock_30min / 2020-06-04

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-04.parquet
  size:    1.9 MB
  rows:    98,178
  symbols: 2,398

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-04 04:00:00	AAPL	Stock	81.2025	81.2025	81.0825	81.085	3820.0
2020-06-04 04:30:00	AAPL	Stock	81.085	81.085	81.015	81.07	3592.0
2020-06-04 05:00:00	AAPL	Stock	81.025	81.025	80.9025	80.905	4784.0
2020-06-04 06:00:00	AAPL	Stock	80.925	81.0575	80.925	81.0575	10788.0
2020-06-04 06:30:00	AAPL	Stock	81.0575	81.0575	80.925	81.0175	9156.0
2020-06-04 07:00:00	AAPL	Stock	81.045	81.085	81.0075	81.0375	29948.0
2020-06-04 07:30:00	AAPL	Stock	81.035	81.1925	81.005	81.1725	45348.0
2020-06-04 08:00:00	AAPL	Stock	81.0278	81.2188	81.005	81.1378	93452.0
2020-06-04 08:30:00	AAPL	Stock	81.1425	81.1925	80.8975	81.07	227068.0
2020-06-04 09:00:00	AAPL	Stock	81.025	81.1622	81.025	81.1275	109844.0
2020-06-04 09:30:00	AAPL	Stock	81.155	81.4028	81.045	81.1742	8810740.0
2020-06-04 10:00:00	AAPL	Stock	81.18	81.315	81.1078	81.275	5551396.0
2020-06-04 10:30:00	AAPL	Stock	81.285	81.405	81.1425	81.1675	4975752.0
2020-06-04 11:00:00	AAPL	Stock	81.1675	81.1975	80.7125	80.8625	6112040.0
2020-06-04 11:30:00	AAPL	Stock	80.86	81.0675	80.8	81.03	3415784.0
2020-06-04 12:00:00	AAPL	Stock	81.035	81.09	80.8775	80.965	2531016.0
2020-06-04 12:30:00	AAPL	Stock	80.9725	80.975	80.6125	80.6275	3856820.0
2020-06-04 13:00:00	AAPL	Stock	80.6262	80.83	80.61	80.685	2854020.0
2020-06-04 13:30:00	AAPL	Stock	80.6875	80.9825	80.68	80.9175	2930504.0
2020-06-04 14:00:00	AAPL	Stock	80.9052	80.9625	80.7625	80.788	2231452.0
2020-06-04 14:30:00	AAPL	Stock	80.79	80.815	80.2175	80.2175	5561696.0
2020-06-04 15:00:00	AAPL	Stock	80.2212	80.4725	80.195	80.43	5641928.0
2020-06-04 15:30:00	AAPL	Stock	80.44	80.59	80.2625	80.58	7531112.0
2020-06-04 16:00:00	AAPL	Stock	80.58	80.595	80.4175	80.5125	5506520.0
2020-06-04 16:30:00	AAPL	Stock	80.5225	80.7375	80.5	80.68	130060.0
2020-06-04 17:00:00	AAPL	Stock	80.6625	80.7125	80.4625	80.65	52960.0
2020-06-04 17:30:00	AAPL	Stock	80.5342	80.6598	80.5075	80.65	7852.0
2020-06-04 18:00:00	AAPL	Stock	80.65	80.6925	80.6	80.675	11404.0
2020-06-04 18:30:00	AAPL	Stock	80.675	80.7	80.625	80.6875	13184.0
2020-06-04 19:00:00	AAPL	Stock	80.67	80.67	80.5025	80.6375	27412.0
2020-06-04 19:30:00	AAPL	Stock	80.61	80.6225	80.5	80.525	22612.0
2020-06-04 04:00:00	MSFT	Stock	184.6	184.99	184.6	184.99	611.0
2020-06-04 05:00:00	MSFT	Stock	184.56	184.56	184.56	184.56	875.0
2020-06-04 05:30:00	MSFT	Stock	184.53	184.55	184.52	184.52	302.0
2020-06-04 06:00:00	MSFT	Stock	184.45	184.5	184.3	184.5	3664.0
2020-06-04 06:30:00	MSFT	Stock	184.55	184.55	184.5	184.55	6250.0
2020-06-04 07:00:00	MSFT	Stock	184.65	184.97	184.65	184.77	3712.0
2020-06-04 07:30:00	MSFT	Stock	184.75	184.88	184.52	184.75	8688.0
2020-06-04 08:00:00	MSFT	Stock	184.74	184.9	184.51	184.6	12905.0
2020-06-04 08:30:00	MSFT	Stock	184.69	184.73	184.27	184.5	28399.0
2020-06-04 09:00:00	MSFT	Stock	184.38	184.83	184.2	184.37	37458.0
2020-06-04 09:30:00	MSFT	Stock	184.38	185.84	184.03	185.31	2820214.0
2020-06-04 10:00:00	MSFT	Stock	185.31	185.34	184.59	184.83	1809902.0
2020-06-04 10:30:00	MSFT	Stock	184.84	185.08	184.25	184.37	1640909.0
2020-06-04 11:00:00	MSFT	Stock	184.365	184.48	183.305	183.618	2098873.0
2020-06-04 11:30:00	MSFT	Stock	183.62	184.2	183.475	183.81	1243599.0
2020-06-04 12:00:00	MSFT	Stock	183.82	183.899	183.37	183.624	884548.0
2020-06-04 12:30:00	MSFT	Stock	183.63	183.653	182.88	182.95	1281508.0
2020-06-04 13:00:00	MSFT	Stock	182.94	183.365	182.91	183.04	941123.0
2020-06-04 13:30:00	MSFT	Stock	183.035	183.76	183.0	183.575	930958.0

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

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