PREVIEW / stock_30min / 2020-07-31

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-31.parquet
  size:    1.9 MB
  rows:    98,361
  symbols: 2,464

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-31 04:00:00	AAPL	Stock	102.335	102.375	101.8325	102.2475	86492.0
2020-07-31 04:30:00	AAPL	Stock	102.195	102.39	101.75	102.135	103392.0
2020-07-31 05:00:00	AAPL	Stock	102.1575	102.2625	102.1425	102.225	11896.0
2020-07-31 05:30:00	AAPL	Stock	102.25	102.275	102.0875	102.115	20244.0
2020-07-31 06:00:00	AAPL	Stock	102.0975	102.175	101.9325	102.175	29756.0
2020-07-31 06:30:00	AAPL	Stock	102.1275	102.235	101.965	102.1375	48276.0
2020-07-31 07:00:00	AAPL	Stock	102.125	103.4875	102.125	103.245	1317780.0
2020-07-31 07:30:00	AAPL	Stock	103.225	103.35	103.025	103.2925	888732.0
2020-07-31 08:00:00	AAPL	Stock	103.175	103.4925	102.25	103.085	1748516.0
2020-07-31 08:30:00	AAPL	Stock	103.075	103.1875	102.3525	102.375	1476436.0
2020-07-31 09:00:00	AAPL	Stock	102.355	103.0	102.15	102.8725	1622420.0
2020-07-31 09:30:00	AAPL	Stock	102.875	103.0	100.825	102.625	55340028.0
2020-07-31 10:00:00	AAPL	Stock	102.6238	102.645	101.0225	101.44	23708808.0
2020-07-31 10:30:00	AAPL	Stock	101.4415	102.3375	101.395	102.31	15078492.0
2020-07-31 11:00:00	AAPL	Stock	102.3188	102.955	102.175	102.6525	16437516.0
2020-07-31 11:30:00	AAPL	Stock	102.665	103.055	102.425	102.5975	13287580.0
2020-07-31 12:00:00	AAPL	Stock	102.5925	102.83	102.235	102.6625	8518680.0
2020-07-31 12:30:00	AAPL	Stock	102.6637	102.6637	102.0375	102.2275	9256832.0
2020-07-31 13:00:00	AAPL	Stock	102.22	102.9	102.165	102.895	9488468.0
2020-07-31 13:30:00	AAPL	Stock	102.8925	103.17	102.76	103.0	11212700.0
2020-07-31 14:00:00	AAPL	Stock	102.9975	103.3325	102.9075	103.2725	12053176.0
2020-07-31 14:30:00	AAPL	Stock	103.2725	104.4375	103.21	104.17	20406320.0
2020-07-31 15:00:00	AAPL	Stock	104.1575	105.5925	104.1075	105.3072	30654220.0
2020-07-31 15:30:00	AAPL	Stock	105.307	106.415	105.25	106.2975	44668288.0
2020-07-31 16:00:00	AAPL	Stock	106.2975	106.61	106.2	106.61	13614332.0
2020-07-31 16:30:00	AAPL	Stock	106.61	106.7	106.4	106.55	868732.0
2020-07-31 17:00:00	AAPL	Stock	106.5625	106.985	106.55	106.8625	709080.0
2020-07-31 17:30:00	AAPL	Stock	106.875	106.9625	106.6875	106.825	267788.0
2020-07-31 18:00:00	AAPL	Stock	106.83	106.9225	106.7625	106.9025	111688.0
2020-07-31 18:30:00	AAPL	Stock	106.9125	106.94	106.835	106.91	150036.0
2020-07-31 19:00:00	AAPL	Stock	106.8875	106.95	106.7875	106.925	212396.0
2020-07-31 19:30:00	AAPL	Stock	106.9225	106.9625	106.86	106.86	242172.0
2020-07-31 04:00:00	MSFT	Stock	204.75	205.0	204.75	205.0	600.0
2020-07-31 04:30:00	MSFT	Stock	204.85	205.2	204.6	205.2	3848.0
2020-07-31 05:00:00	MSFT	Stock	205.11	205.11	204.61	204.98	2332.0
2020-07-31 05:30:00	MSFT	Stock	205.2	205.46	204.52	204.52	1194.0
2020-07-31 06:00:00	MSFT	Stock	204.8	205.0	204.8	205.0	1800.0
2020-07-31 06:30:00	MSFT	Stock	205.0	205.0	204.85	205.0	3598.0
2020-07-31 07:00:00	MSFT	Stock	204.99	205.0	204.54	204.78	20602.0
2020-07-31 07:30:00	MSFT	Stock	204.62	204.8	204.45	204.8	10758.0
2020-07-31 08:00:00	MSFT	Stock	204.862	205.0	204.4	204.86	56343.0
2020-07-31 08:30:00	MSFT	Stock	204.86	205.11	204.75	204.91	40838.0
2020-07-31 09:00:00	MSFT	Stock	204.893	204.94	204.1	204.4	73276.0
2020-07-31 09:30:00	MSFT	Stock	204.4	204.7	200.13	200.97	6036797.0
2020-07-31 10:00:00	MSFT	Stock	200.96	201.01	199.01	199.473	4150817.0
2020-07-31 10:30:00	MSFT	Stock	199.47	200.9	199.4	200.86	2405104.0
2020-07-31 11:00:00	MSFT	Stock	200.87	202.55	200.7	201.94	2010377.0
2020-07-31 11:30:00	MSFT	Stock	201.95	202.25	201.08	201.225	1465147.0
2020-07-31 12:00:00	MSFT	Stock	201.21	201.469	200.57	201.24	1336188.0
2020-07-31 12:30:00	MSFT	Stock	201.22	201.22	199.88	200.06	1273512.0

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

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