PREVIEW / stock_30min / 2020-11-10

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-11-10.parquet
  size:    2.0 MB
  rows:    101,734
  symbols: 2,528

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-11-10 04:00:00	AAPL	Stock	116.84	117.0	115.55	116.19	100352.0
2020-11-10 04:30:00	AAPL	Stock	116.23	116.28	115.84	115.84	88315.0
2020-11-10 05:00:00	AAPL	Stock	115.84	115.96	115.03	115.44	32539.0
2020-11-10 05:30:00	AAPL	Stock	115.46	115.56	114.02	114.02	122007.0
2020-11-10 06:00:00	AAPL	Stock	114.02	114.79	114.0	114.39	73560.0
2020-11-10 06:30:00	AAPL	Stock	114.48	115.09	114.26	114.95	55940.0
2020-11-10 07:00:00	AAPL	Stock	115.05	115.7	114.72	115.25	336164.0
2020-11-10 07:30:00	AAPL	Stock	115.28	115.39	114.77	114.81	330154.0
2020-11-10 08:00:00	AAPL	Stock	114.9	115.7	114.5	115.18	580154.0
2020-11-10 08:30:00	AAPL	Stock	115.15	115.45	114.7	115.43	319579.0
2020-11-10 09:00:00	AAPL	Stock	115.4	115.75	115.179	115.56	334033.0
2020-11-10 09:30:00	AAPL	Stock	115.56	117.59	115.36	115.805	15167971.0
2020-11-10 10:00:00	AAPL	Stock	115.8	116.94	115.47	115.49	9075890.0
2020-11-10 10:30:00	AAPL	Stock	115.48	115.82	114.13	115.0	10101201.0
2020-11-10 11:00:00	AAPL	Stock	115.0	116.59	114.9	116.562	7296429.0
2020-11-10 11:30:00	AAPL	Stock	116.56	117.33	116.31	116.674	6833998.0
2020-11-10 12:00:00	AAPL	Stock	116.678	117.47	116.62	116.811	6161568.0
2020-11-10 12:30:00	AAPL	Stock	116.81	117.1	115.81	116.92	6411054.0
2020-11-10 13:00:00	AAPL	Stock	116.93	117.59	116.03	116.58	7588356.0
2020-11-10 13:30:00	AAPL	Stock	116.57	117.07	115.88	116.87	7122814.0
2020-11-10 14:00:00	AAPL	Stock	116.85	117.29	115.99	116.395	7852892.0
2020-11-10 14:30:00	AAPL	Stock	116.39	117.28	116.34	116.75	7368889.0
2020-11-10 15:00:00	AAPL	Stock	116.74	116.99	116.19	116.93	6261360.0
2020-11-10 15:30:00	AAPL	Stock	116.93	117.018	115.73	115.97	10961024.0
2020-11-10 16:00:00	AAPL	Stock	115.97	116.913	115.95	115.99	9558171.0
2020-11-10 16:30:00	AAPL	Stock	115.99	116.15	115.97	116.06	96598.0
2020-11-10 17:00:00	AAPL	Stock	116.04	116.13	116.01	116.1	31924.0
2020-11-10 17:30:00	AAPL	Stock	116.1	116.12	115.99	116.04	38127.0
2020-11-10 18:00:00	AAPL	Stock	116.03	116.24	116.0	116.08	94044.0
2020-11-10 18:30:00	AAPL	Stock	116.05	116.11	115.9	115.94	111303.0
2020-11-10 19:00:00	AAPL	Stock	115.95	115.95	115.68	115.76	110883.0
2020-11-10 19:30:00	AAPL	Stock	115.81	116.08	115.76	116.05	60269.0
2020-11-10 04:00:00	MSFT	Stock	218.0	218.0	215.69	216.39	12487.0
2020-11-10 04:30:00	MSFT	Stock	216.53	217.0	216.41	216.5	7213.0
2020-11-10 05:00:00	MSFT	Stock	216.67	216.7	215.69	215.78	12800.0
2020-11-10 05:30:00	MSFT	Stock	215.71	215.71	214.12	214.29	19670.0
2020-11-10 06:00:00	MSFT	Stock	214.05	214.61	213.9	214.46	15142.0
2020-11-10 06:30:00	MSFT	Stock	214.31	215.0	214.05	214.54	14222.0
2020-11-10 07:00:00	MSFT	Stock	214.55	215.33	213.58	214.3	80662.0
2020-11-10 07:30:00	MSFT	Stock	214.13	215.0	213.7	213.9	36486.0
2020-11-10 08:00:00	MSFT	Stock	214.343	215.4	213.8	214.7	75271.0
2020-11-10 08:30:00	MSFT	Stock	214.79	215.27	213.82	215.11	49522.0
2020-11-10 09:00:00	MSFT	Stock	215.1	215.68	214.41	214.43	125446.0
2020-11-10 09:30:00	MSFT	Stock	214.43	216.5	212.9	213.904	4051172.0
2020-11-10 10:00:00	MSFT	Stock	213.945	214.59	211.0	211.08	3132474.0
2020-11-10 10:30:00	MSFT	Stock	211.07	211.645	210.3	211.21	2922747.0
2020-11-10 11:00:00	MSFT	Stock	211.195	212.8	210.74	212.77	2152920.0
2020-11-10 11:30:00	MSFT	Stock	212.78	213.21	211.079	211.08	1994754.0
2020-11-10 12:00:00	MSFT	Stock	211.088	213.2	211.04	212.059	1890722.0
2020-11-10 12:30:00	MSFT	Stock	212.05	212.97	211.73	212.43	1044298.0

> showing 50 of 101,734 rows — these rows as CSV

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