PREVIEW / stock_30min / 2021-01-12

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-01-12.parquet
  size:    2.3 MB
  rows:    114,331
  symbols: 2,697

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-12 04:00:00	AAPL	Stock	129.1	129.4	129.0	129.23	12301.0
2021-01-12 04:30:00	AAPL	Stock	129.24	129.63	129.23	129.62	11768.0
2021-01-12 05:00:00	AAPL	Stock	129.62	129.9	129.45	129.45	9521.0
2021-01-12 05:30:00	AAPL	Stock	129.56	129.56	129.13	129.41	5578.0
2021-01-12 06:00:00	AAPL	Stock	129.49	129.66	129.3	129.66	10262.0
2021-01-12 06:30:00	AAPL	Stock	129.66	129.87	129.5	129.5	24320.0
2021-01-12 07:00:00	AAPL	Stock	129.49	129.97	129.4	129.83	194564.0
2021-01-12 07:30:00	AAPL	Stock	129.81	129.81	129.57	129.65	75973.0
2021-01-12 08:00:00	AAPL	Stock	129.428	129.95	129.1	129.22	376134.0
2021-01-12 08:30:00	AAPL	Stock	129.2	129.34	128.61	128.88	298266.0
2021-01-12 09:00:00	AAPL	Stock	128.86	128.96	128.51	128.52	348233.0
2021-01-12 09:30:00	AAPL	Stock	128.52	129.69	128.08	128.36	12040857.0
2021-01-12 10:00:00	AAPL	Stock	128.36	129.13	128.18	129.0	6278320.0
2021-01-12 10:30:00	AAPL	Stock	129.03	129.33	128.76	128.91	5549844.0
2021-01-12 11:00:00	AAPL	Stock	128.91	129.18	128.6	128.714	4617797.0
2021-01-12 11:30:00	AAPL	Stock	128.71	128.72	128.15	128.355	4834733.0
2021-01-12 12:00:00	AAPL	Stock	128.358	128.39	126.86	127.6	9774891.0
2021-01-12 12:30:00	AAPL	Stock	127.605	127.99	127.48	127.945	3842901.0
2021-01-12 13:00:00	AAPL	Stock	127.95	128.38	127.71	128.283	3994148.0
2021-01-12 13:30:00	AAPL	Stock	128.282	128.44	128.08	128.195	3048692.0
2021-01-12 14:00:00	AAPL	Stock	128.195	128.64	128.17	128.491	3720732.0
2021-01-12 14:30:00	AAPL	Stock	128.49	128.79	128.08	128.4	4077199.0
2021-01-12 15:00:00	AAPL	Stock	128.4	128.67	128.2	128.54	3753666.0
2021-01-12 15:30:00	AAPL	Stock	128.53	129.19	128.47	128.82	7166860.0
2021-01-12 16:00:00	AAPL	Stock	128.8	129.0	127.895	128.76	5152615.0
2021-01-12 16:30:00	AAPL	Stock	128.79	128.97	128.76	128.95	87185.0
2021-01-12 17:00:00	AAPL	Stock	128.94	128.96	128.8	128.94	746308.0
2021-01-12 17:30:00	AAPL	Stock	128.92	128.99	128.87	128.9	53875.0
2021-01-12 18:00:00	AAPL	Stock	128.9	128.98	128.81	128.94	43242.0
2021-01-12 18:30:00	AAPL	Stock	128.94	129.0	128.8	129.0	39042.0
2021-01-12 19:00:00	AAPL	Stock	128.99	129.15	128.95	129.14	52679.0
2021-01-12 19:30:00	AAPL	Stock	129.12	129.23	129.03	129.22	67629.0
2021-01-12 04:00:00	MSFT	Stock	217.68	217.78	217.51	217.52	982.0
2021-01-12 04:30:00	MSFT	Stock	217.76	218.09	217.76	218.09	411.0
2021-01-12 05:00:00	MSFT	Stock	218.06	218.06	217.51	217.56	922.0
2021-01-12 05:30:00	MSFT	Stock	217.69	218.0	217.51	217.51	2210.0
2021-01-12 06:00:00	MSFT	Stock	217.51	217.51	217.5	217.5	1221.0
2021-01-12 07:00:00	MSFT	Stock	217.8	217.81	217.5	217.55	11435.0
2021-01-12 07:30:00	MSFT	Stock	217.56	217.85	217.5	217.5	6530.0
2021-01-12 08:00:00	MSFT	Stock	217.985	217.99	216.95	217.0	27655.0
2021-01-12 08:30:00	MSFT	Stock	216.94	217.15	216.01	216.73	23469.0
2021-01-12 09:00:00	MSFT	Stock	216.51	217.0	216.25	216.6	23473.0
2021-01-12 09:30:00	MSFT	Stock	216.56	217.1	214.365	215.03	2748935.0
2021-01-12 10:00:00	MSFT	Stock	215.06	215.66	214.392	215.405	1410854.0
2021-01-12 10:30:00	MSFT	Stock	215.41	215.758	214.73	214.79	1333455.0
2021-01-12 11:00:00	MSFT	Stock	214.8	215.56	214.57	215.0	1305387.0
2021-01-12 11:30:00	MSFT	Stock	215.03	215.285	214.55	214.66	1079741.0
2021-01-12 12:00:00	MSFT	Stock	214.65	214.7	213.32	213.935	1527830.0
2021-01-12 12:30:00	MSFT	Stock	213.93	214.51	213.75	214.42	684295.0
2021-01-12 13:00:00	MSFT	Stock	214.419	215.38	214.33	215.062	647198.0

> showing 50 of 114,331 rows — these rows as CSV

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