PREVIEW / stock_30min / 2021-01-07

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-01-07.parquet
  size:    2.2 MB
  rows:    112,717
  symbols: 2,676

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
2021-01-07 04:00:00	AAPL	Stock	128.0	128.64	127.82	128.37	50568.0
2021-01-07 04:30:00	AAPL	Stock	128.34	128.34	127.51	127.68	25743.0
2021-01-07 05:00:00	AAPL	Stock	127.58	128.2	127.55	128.09	29167.0
2021-01-07 05:30:00	AAPL	Stock	127.85	128.29	127.56	127.75	24444.0
2021-01-07 06:00:00	AAPL	Stock	127.54	127.96	127.42	127.96	17012.0
2021-01-07 06:30:00	AAPL	Stock	127.99	127.99	127.75	127.78	6552.0
2021-01-07 07:00:00	AAPL	Stock	127.69	128.3	127.69	128.27	258591.0
2021-01-07 07:30:00	AAPL	Stock	128.27	128.31	128.1	128.28	123694.0
2021-01-07 08:00:00	AAPL	Stock	128.11	128.64	127.87	128.5	490228.0
2021-01-07 08:30:00	AAPL	Stock	128.51	128.54	128.17	128.23	325445.0
2021-01-07 09:00:00	AAPL	Stock	128.24	128.55	128.22	128.38	318382.0
2021-01-07 09:30:00	AAPL	Stock	128.4	129.14	127.86	129.01	16227298.0
2021-01-07 10:00:00	AAPL	Stock	129.03	130.315	128.88	129.83	10905126.0
2021-01-07 10:30:00	AAPL	Stock	129.84	130.56	129.69	130.541	7121767.0
2021-01-07 11:00:00	AAPL	Stock	130.545	131.03	130.31	130.56	7532919.0
2021-01-07 11:30:00	AAPL	Stock	130.57	130.96	130.14	130.32	5359453.0
2021-01-07 12:00:00	AAPL	Stock	130.33	130.425	129.85	130.07	4530676.0
2021-01-07 12:30:00	AAPL	Stock	130.06	130.65	130.06	130.465	3281914.0
2021-01-07 13:00:00	AAPL	Stock	130.465	130.55	130.02	130.36	3350111.0
2021-01-07 13:30:00	AAPL	Stock	130.37	130.56	130.21	130.31	3083004.0
2021-01-07 14:00:00	AAPL	Stock	130.305	130.64	130.28	130.617	3138478.0
2021-01-07 14:30:00	AAPL	Stock	130.614	130.78	130.414	130.775	3547372.0
2021-01-07 15:00:00	AAPL	Stock	130.772	131.215	130.46	131.21	6613332.0
2021-01-07 15:30:00	AAPL	Stock	131.21	131.63	130.82	130.85	9926453.0
2021-01-07 16:00:00	AAPL	Stock	130.92	131.0	130.66	130.8	11214647.0
2021-01-07 16:30:00	AAPL	Stock	130.8	130.92	130.61	130.63	64058.0
2021-01-07 17:00:00	AAPL	Stock	130.66	130.75	130.42	130.59	95223.0
2021-01-07 17:30:00	AAPL	Stock	130.59	130.73	130.51	130.72	35909.0
2021-01-07 18:00:00	AAPL	Stock	130.72	130.92	130.5	130.74	90559.0
2021-01-07 18:30:00	AAPL	Stock	130.63	131.16	130.61	131.03	86038.0
2021-01-07 19:00:00	AAPL	Stock	131.04	131.54	130.96	131.54	135812.0
2021-01-07 19:30:00	AAPL	Stock	131.5	131.95	131.5	131.68	263965.0
2021-01-07 04:00:00	MSFT	Stock	214.0	214.38	213.32	214.01	5622.0
2021-01-07 04:30:00	MSFT	Stock	214.0	214.01	213.57	213.95	14105.0
2021-01-07 05:00:00	MSFT	Stock	213.85	213.85	213.55	213.8	2509.0
2021-01-07 05:30:00	MSFT	Stock	213.8	214.15	213.75	213.75	8077.0
2021-01-07 06:00:00	MSFT	Stock	213.3	213.75	213.15	213.67	4084.0
2021-01-07 06:30:00	MSFT	Stock	213.89	213.89	213.5	213.75	935.0
2021-01-07 07:00:00	MSFT	Stock	213.68	214.2	213.5	213.75	23392.0
2021-01-07 07:30:00	MSFT	Stock	213.8	214.24	213.72	214.14	24673.0
2021-01-07 08:00:00	MSFT	Stock	214.0	214.28	213.6	214.04	45604.0
2021-01-07 08:30:00	MSFT	Stock	214.1	214.2	213.8	213.98	27595.0
2021-01-07 09:00:00	MSFT	Stock	213.84	214.32	213.8	214.04	47453.0
2021-01-07 09:30:00	MSFT	Stock	214.03	217.19	213.71	216.91	3759715.0
2021-01-07 10:00:00	MSFT	Stock	216.92	218.1	216.8	217.03	1834959.0
2021-01-07 10:30:00	MSFT	Stock	217.022	218.14	216.79	218.107	1289067.0
2021-01-07 11:00:00	MSFT	Stock	218.09	218.36	217.41	218.24	1076922.0
2021-01-07 11:30:00	MSFT	Stock	218.27	218.78	218.16	218.29	1098051.0
2021-01-07 12:00:00	MSFT	Stock	218.33	218.46	217.76	217.99	663297.0
2021-01-07 12:30:00	MSFT	Stock	218.0	218.4	217.97	218.16	553676.0

> showing 50 of 112,717 rows — these rows as CSV

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