PREVIEW / stock_30min / 2020-01-03

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-01-03.parquet
  size:    1.8 MB
  rows:    88,346
  symbols: 2,458

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-01-03 04:00:00	AAPL	Stock	74.3375	74.3375	73.925	73.975	141220.0
2020-01-03 04:30:00	AAPL	Stock	74.0525	74.0675	73.9	74.05	38224.0
2020-01-03 05:00:00	AAPL	Stock	74.045	74.15	73.9	74.0	39184.0
2020-01-03 05:30:00	AAPL	Stock	73.9825	73.985	73.595	73.71	105020.0
2020-01-03 06:00:00	AAPL	Stock	73.71	73.9	73.7075	73.9	91080.0
2020-01-03 06:30:00	AAPL	Stock	73.955	73.975	73.825	73.9175	87004.0
2020-01-03 07:00:00	AAPL	Stock	73.9475	74.375	73.9	74.3	558392.0
2020-01-03 07:30:00	AAPL	Stock	74.285	74.55	74.2775	74.5125	462708.0
2020-01-03 08:00:00	AAPL	Stock	74.5025	74.65	73.9125	74.5	1132972.0
2020-01-03 08:30:00	AAPL	Stock	74.5075	74.5075	74.3275	74.3975	534416.0
2020-01-03 09:00:00	AAPL	Stock	74.38	74.4625	74.13	74.2825	787296.0
2020-01-03 09:30:00	AAPL	Stock	74.2825	75.1425	74.125	74.8005	27496476.0
2020-01-03 10:00:00	AAPL	Stock	74.795	74.9	74.4	74.8675	11696968.0
2020-01-03 10:30:00	AAPL	Stock	74.8625	74.8688	74.56	74.66	7183628.0
2020-01-03 11:00:00	AAPL	Stock	74.6675	74.69	74.485	74.555	5287780.0
2020-01-03 11:30:00	AAPL	Stock	74.5525	74.96	74.5325	74.8375	7524968.0
2020-01-03 12:00:00	AAPL	Stock	74.8375	75.0375	74.8275	74.8625	5507832.0
2020-01-03 12:30:00	AAPL	Stock	74.8565	75.145	74.8425	75.0475	6534760.0
2020-01-03 13:00:00	AAPL	Stock	75.055	75.0975	74.9325	74.9875	4393344.0
2020-01-03 13:30:00	AAPL	Stock	74.995	75.0425	74.6925	74.8465	5957020.0
2020-01-03 14:00:00	AAPL	Stock	74.844	74.9	74.7075	74.7825	3521948.0
2020-01-03 14:30:00	AAPL	Stock	74.775	74.985	74.7625	74.9562	3910540.0
2020-01-03 15:00:00	AAPL	Stock	74.9525	75.01	74.6348	74.6425	6945536.0
2020-01-03 15:30:00	AAPL	Stock	74.6375	74.65	74.3375	74.345	12827360.0
2020-01-03 16:00:00	AAPL	Stock	74.3575	74.47	74.3575	74.3925	13968780.0
2020-01-03 16:30:00	AAPL	Stock	74.3825	74.42	74.3575	74.38	146700.0
2020-01-03 17:00:00	AAPL	Stock	74.4125	74.4125	74.375	74.3775	64832.0
2020-01-03 17:30:00	AAPL	Stock	74.375	74.415	74.3675	74.4	43180.0
2020-01-03 18:00:00	AAPL	Stock	74.4075	74.4225	74.4075	74.415	23496.0
2020-01-03 18:30:00	AAPL	Stock	74.415	74.45	74.415	74.425	35056.0
2020-01-03 19:00:00	AAPL	Stock	74.4125	74.4125	74.37	74.37	54172.0
2020-01-03 19:30:00	AAPL	Stock	74.3625	74.3725	74.3275	74.33	67948.0
2020-01-03 04:00:00	MSFT	Stock	159.06	159.06	158.5	158.5	9176.0
2020-01-03 04:30:00	MSFT	Stock	158.75	158.8	158.5	158.74	3748.0
2020-01-03 05:00:00	MSFT	Stock	158.74	158.97	158.74	158.76	4149.0
2020-01-03 05:30:00	MSFT	Stock	158.7	158.7	157.6	157.88	5205.0
2020-01-03 06:00:00	MSFT	Stock	157.97	158.39	157.97	158.0	6478.0
2020-01-03 06:30:00	MSFT	Stock	158.0	158.7	157.9	158.42	21790.0
2020-01-03 07:00:00	MSFT	Stock	158.53	158.82	158.37	158.8	42647.0
2020-01-03 07:30:00	MSFT	Stock	158.69	158.81	158.45	158.5	24620.0
2020-01-03 08:00:00	MSFT	Stock	158.55	159.04	158.4	159.0	55467.0
2020-01-03 08:30:00	MSFT	Stock	159.04	159.04	158.83	158.89	29042.0
2020-01-03 09:00:00	MSFT	Stock	158.9	158.97	158.08	158.3	66007.0
2020-01-03 09:30:00	MSFT	Stock	158.32	159.93	158.06	159.673	3128112.0
2020-01-03 10:00:00	MSFT	Stock	159.67	159.67	159.175	159.555	1349043.0
2020-01-03 10:30:00	MSFT	Stock	159.55	159.71	159.25	159.31	1053871.0
2020-01-03 11:00:00	MSFT	Stock	159.31	159.42	159.07	159.388	749405.0
2020-01-03 11:30:00	MSFT	Stock	159.38	159.595	159.35	159.595	698441.0
2020-01-03 12:00:00	MSFT	Stock	159.59	159.945	159.45	159.51	848961.0
2020-01-03 12:30:00	MSFT	Stock	159.51	159.86	159.48	159.71	451011.0

> showing 50 of 88,346 rows — these rows as CSV

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