PREVIEW / stock_30min / 2020-04-20

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-04-20.parquet
  size:    1.9 MB
  rows:    94,170
  symbols: 2,395

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-04-20 04:00:00	AAPL	Stock	70.68	70.68	70.0	70.0	19060.0
2020-04-20 04:30:00	AAPL	Stock	70.0025	70.0875	70.0025	70.0875	2940.0
2020-04-20 05:00:00	AAPL	Stock	70.25	70.25	70.09	70.1575	4056.0
2020-04-20 05:30:00	AAPL	Stock	70.0875	70.0875	70.075	70.075	3072.0
2020-04-20 06:00:00	AAPL	Stock	69.8775	69.8775	69.55	69.55	9164.0
2020-04-20 06:30:00	AAPL	Stock	69.6175	69.855	69.6175	69.655	12524.0
2020-04-20 07:00:00	AAPL	Stock	69.75	69.95	69.65	69.8975	172516.0
2020-04-20 07:30:00	AAPL	Stock	69.9	69.9375	69.6375	69.7325	177056.0
2020-04-20 08:00:00	AAPL	Stock	69.825	69.948	69.6	69.7875	356588.0
2020-04-20 08:30:00	AAPL	Stock	69.75	69.75	69.5475	69.6	267616.0
2020-04-20 09:00:00	AAPL	Stock	69.58	69.7	69.395	69.44	368168.0
2020-04-20 09:30:00	AAPL	Stock	69.44	70.0625	69.3902	69.5675	16271236.0
2020-04-20 10:00:00	AAPL	Stock	69.5725	70.1625	69.48	70.0875	9134460.0
2020-04-20 10:30:00	AAPL	Stock	70.0875	70.42	70.0775	70.2225	7130848.0
2020-04-20 11:00:00	AAPL	Stock	70.2175	70.385	70.025	70.07	5516736.0
2020-04-20 11:30:00	AAPL	Stock	70.065	70.3123	69.95	70.068	4863812.0
2020-04-20 12:00:00	AAPL	Stock	70.0675	70.175	69.855	69.8825	5249952.0
2020-04-20 12:30:00	AAPL	Stock	69.8818	70.1162	69.842	69.89	4161136.0
2020-04-20 13:00:00	AAPL	Stock	69.89	69.8982	69.615	69.8328	5106332.0
2020-04-20 13:30:00	AAPL	Stock	69.8375	70.05	69.6875	70.015	4335220.0
2020-04-20 14:00:00	AAPL	Stock	70.0075	70.075	69.595	69.6225	4495400.0
2020-04-20 14:30:00	AAPL	Stock	69.6292	69.8912	69.4375	69.48	6475000.0
2020-04-20 15:00:00	AAPL	Stock	69.4875	69.7068	69.325	69.5725	7694632.0
2020-04-20 15:30:00	AAPL	Stock	69.575	69.7425	69.2125	69.2125	12078364.0
2020-04-20 16:00:00	AAPL	Stock	69.215	69.28	69.0	69.07	9838320.0
2020-04-20 16:30:00	AAPL	Stock	69.075	69.165	69.0125	69.1	77648.0
2020-04-20 17:00:00	AAPL	Stock	69.1	69.2325	69.05	69.1075	111804.0
2020-04-20 17:30:00	AAPL	Stock	69.11	69.1125	69.0625	69.1125	22600.0
2020-04-20 18:00:00	AAPL	Stock	69.1	69.2325	69.1	69.18	41016.0
2020-04-20 18:30:00	AAPL	Stock	69.18	69.465	69.18	69.4375	62372.0
2020-04-20 19:00:00	AAPL	Stock	69.4125	69.4725	69.4	69.4125	23244.0
2020-04-20 19:30:00	AAPL	Stock	69.4125	69.4125	69.2625	69.275	42804.0
2020-04-20 04:00:00	MSFT	Stock	178.1	178.1	177.06	177.06	2759.0
2020-04-20 04:30:00	MSFT	Stock	177.01	177.5	177.0	177.3	2086.0
2020-04-20 05:00:00	MSFT	Stock	177.5	177.7	177.3	177.7	2289.0
2020-04-20 05:30:00	MSFT	Stock	177.8	177.8	177.24	177.27	3988.0
2020-04-20 06:00:00	MSFT	Stock	177.01	177.01	175.51	176.09	3898.0
2020-04-20 06:30:00	MSFT	Stock	176.37	176.72	176.1	176.27	2268.0
2020-04-20 07:00:00	MSFT	Stock	176.49	176.67	175.77	175.9	20693.0
2020-04-20 07:30:00	MSFT	Stock	175.9	176.99	175.88	176.0	38471.0
2020-04-20 08:00:00	MSFT	Stock	176.35	176.87	175.75	176.25	78096.0
2020-04-20 08:30:00	MSFT	Stock	176.25	176.33	175.95	176.2	49029.0
2020-04-20 09:00:00	MSFT	Stock	176.29	176.8	176.05	176.63	64809.0
2020-04-20 09:30:00	MSFT	Stock	176.63	177.79	176.2	176.68	4749695.0
2020-04-20 10:00:00	MSFT	Stock	176.65	178.29	176.52	177.88	2679292.0
2020-04-20 10:30:00	MSFT	Stock	177.88	178.18	177.04	177.76	1923675.0
2020-04-20 11:00:00	MSFT	Stock	177.75	178.39	177.613	178.11	1555407.0
2020-04-20 11:30:00	MSFT	Stock	178.11	178.75	177.82	178.395	1535913.0
2020-04-20 12:00:00	MSFT	Stock	178.39	178.45	177.765	177.8	1235525.0
2020-04-20 12:30:00	MSFT	Stock	177.805	178.2	177.805	177.91	961841.0

> showing 50 of 94,170 rows — these rows as CSV

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