PREVIEW / stock_30min / 2020-09-21

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-09-21.parquet
  size:    2.0 MB
  rows:    100,457
  symbols: 2,496

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-09-21 04:00:00	AAPL	Stock	105.64	105.68	104.38	104.72	138016.0
2020-09-21 04:30:00	AAPL	Stock	104.79	104.8	103.92	104.37	113976.0
2020-09-21 05:00:00	AAPL	Stock	104.36	105.23	104.2	104.43	63040.0
2020-09-21 05:30:00	AAPL	Stock	104.65	104.7	103.91	104.05	96082.0
2020-09-21 06:00:00	AAPL	Stock	104.08	105.0	104.0	104.66	58444.0
2020-09-21 06:30:00	AAPL	Stock	104.65	105.2	104.65	105.2	103454.0
2020-09-21 07:00:00	AAPL	Stock	105.15	105.44	103.36	103.59	943277.0
2020-09-21 07:30:00	AAPL	Stock	103.56	104.74	103.43	104.49	540665.0
2020-09-21 08:00:00	AAPL	Stock	104.52	105.35	103.38	104.0	1246891.0
2020-09-21 08:30:00	AAPL	Stock	103.99	104.66	103.64	104.47	816622.0
2020-09-21 09:00:00	AAPL	Stock	104.44	104.65	104.0	104.52	846061.0
2020-09-21 09:30:00	AAPL	Stock	104.53	107.85	103.1	107.36	28492881.0
2020-09-21 10:00:00	AAPL	Stock	107.36	107.7	105.29	105.43	16905356.0
2020-09-21 10:30:00	AAPL	Stock	105.42	105.86	104.56	105.22	14039315.0
2020-09-21 11:00:00	AAPL	Stock	105.225	106.04	104.9	105.583	10175400.0
2020-09-21 11:30:00	AAPL	Stock	105.586	106.51	105.18	106.47	8738444.0
2020-09-21 12:00:00	AAPL	Stock	106.471	107.57	106.471	107.369	10857355.0
2020-09-21 12:30:00	AAPL	Stock	107.38	107.46	106.65	106.785	7395789.0
2020-09-21 13:00:00	AAPL	Stock	106.78	107.65	106.3	107.232	8333865.0
2020-09-21 13:30:00	AAPL	Stock	107.23	107.8	106.72	107.099	7865437.0
2020-09-21 14:00:00	AAPL	Stock	107.1	107.365	106.68	107.145	6382595.0
2020-09-21 14:30:00	AAPL	Stock	107.14	107.45	106.461	107.34	6537846.0
2020-09-21 15:00:00	AAPL	Stock	107.33	108.7	107.23	108.445	12659347.0
2020-09-21 15:30:00	AAPL	Stock	108.45	110.19	108.33	110.13	21162641.0
2020-09-21 16:00:00	AAPL	Stock	110.08	110.7	106.909	109.9	9157954.0
2020-09-21 16:30:00	AAPL	Stock	109.98	110.32	109.92	110.04	434257.0
2020-09-21 17:00:00	AAPL	Stock	110.06	110.17	109.44	110.05	354753.0
2020-09-21 17:30:00	AAPL	Stock	110.0	110.08	109.69	109.86	178939.0
2020-09-21 18:00:00	AAPL	Stock	109.92	110.36	109.88	110.15	172773.0
2020-09-21 18:30:00	AAPL	Stock	110.12	110.15	110.0	110.1	124918.0
2020-09-21 19:00:00	AAPL	Stock	110.1	110.47	109.94	110.47	123730.0
2020-09-21 19:30:00	AAPL	Stock	110.49	111.0	110.4	110.95	238323.0
2020-09-21 04:00:00	MSFT	Stock	198.79	198.79	196.95	197.0	19970.0
2020-09-21 04:30:00	MSFT	Stock	197.0	197.0	196.1	196.5	10403.0
2020-09-21 05:00:00	MSFT	Stock	196.45	198.0	196.31	197.5	14288.0
2020-09-21 05:30:00	MSFT	Stock	197.22	197.26	195.59	196.34	9216.0
2020-09-21 06:00:00	MSFT	Stock	196.1	197.36	195.9	196.5	22581.0
2020-09-21 06:30:00	MSFT	Stock	197.1	197.52	196.55	197.01	10913.0
2020-09-21 07:00:00	MSFT	Stock	197.01	197.45	195.0	195.5	79283.0
2020-09-21 07:30:00	MSFT	Stock	195.66	197.85	195.35	197.19	38200.0
2020-09-21 08:00:00	MSFT	Stock	195.8	197.56	195.139	196.78	104925.0
2020-09-21 08:30:00	MSFT	Stock	196.73	197.38	196.05	196.62	48006.0
2020-09-21 09:00:00	MSFT	Stock	196.79	197.47	196.51	196.85	89394.0
2020-09-21 09:30:00	MSFT	Stock	196.81	198.75	196.5	197.99	4431914.0
2020-09-21 10:00:00	MSFT	Stock	197.98	198.2	196.51	197.18	2617241.0
2020-09-21 10:30:00	MSFT	Stock	197.15	197.98	196.38	197.727	2353336.0
2020-09-21 11:00:00	MSFT	Stock	197.72	198.84	196.91	197.375	1976267.0
2020-09-21 11:30:00	MSFT	Stock	197.36	199.24	196.89	199.174	1586785.0
2020-09-21 12:00:00	MSFT	Stock	199.19	200.01	198.9	199.95	1603310.0
2020-09-21 12:30:00	MSFT	Stock	199.96	200.39	199.2	199.54	1266047.0

> showing 50 of 100,457 rows — these rows as CSV

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