PREVIEW / stock_30min / 2021-01-04

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-01-04.parquet
  size:    2.2 MB
  rows:    112,779
  symbols: 2,673

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-04 04:00:00	AAPL	Stock	133.31	134.01	133.02	134.0	67557.0
2021-01-04 04:30:00	AAPL	Stock	134.0	134.0	133.5	133.6	20404.0
2021-01-04 05:00:00	AAPL	Stock	133.6	133.95	133.43	133.53	47712.0
2021-01-04 05:30:00	AAPL	Stock	133.59	134.43	133.59	134.3	100216.0
2021-01-04 06:00:00	AAPL	Stock	134.22	134.35	134.05	134.1	9826.0
2021-01-04 06:30:00	AAPL	Stock	134.19	134.35	133.6	133.99	23117.0
2021-01-04 07:00:00	AAPL	Stock	133.92	134.0	133.54	133.74	282886.0
2021-01-04 07:30:00	AAPL	Stock	133.75	133.98	133.75	133.95	141368.0
2021-01-04 08:00:00	AAPL	Stock	133.93	134.1	133.53	133.8	359294.0
2021-01-04 08:30:00	AAPL	Stock	133.79	133.9	133.71	133.83	150237.0
2021-01-04 09:00:00	AAPL	Stock	133.83	133.87	133.35	133.52	287497.0
2021-01-04 09:30:00	AAPL	Stock	133.52	133.612	131.294	131.449	13501196.0
2021-01-04 10:00:00	AAPL	Stock	131.45	131.67	130.38	131.054	8874206.0
2021-01-04 10:30:00	AAPL	Stock	131.055	131.31	130.45	130.968	7786662.0
2021-01-04 11:00:00	AAPL	Stock	130.97	131.31	129.4	129.883	9127269.0
2021-01-04 11:30:00	AAPL	Stock	129.89	130.09	128.79	128.82	7772760.0
2021-01-04 12:00:00	AAPL	Stock	128.81	128.919	126.76	128.25	11717925.0
2021-01-04 12:30:00	AAPL	Stock	128.247	128.595	127.63	128.42	5928357.0
2021-01-04 13:00:00	AAPL	Stock	128.41	129.11	128.05	129.04	6371335.0
2021-01-04 13:30:00	AAPL	Stock	129.04	129.2	128.595	129.178	4051542.0
2021-01-04 14:00:00	AAPL	Stock	129.17	129.2	128.62	128.96	5237490.0
2021-01-04 14:30:00	AAPL	Stock	128.96	129.579	128.64	129.492	5854587.0
2021-01-04 15:00:00	AAPL	Stock	129.48	129.58	128.81	129.07	5475505.0
2021-01-04 15:30:00	AAPL	Stock	129.06	129.74	128.76	129.41	10959536.0
2021-01-04 16:00:00	AAPL	Stock	129.41	129.69	129.16	129.35	17631271.0
2021-01-04 16:30:00	AAPL	Stock	129.34	129.45	129.34	129.37	82397.0
2021-01-04 17:00:00	AAPL	Stock	129.39	129.4	129.26	129.28	46843.0
2021-01-04 17:30:00	AAPL	Stock	129.28	129.7	129.26	129.33	87436.0
2021-01-04 18:00:00	AAPL	Stock	129.37	129.38	129.15	129.25	86331.0
2021-01-04 18:30:00	AAPL	Stock	129.3	129.33	129.22	129.24	36384.0
2021-01-04 19:00:00	AAPL	Stock	129.25	129.36	129.14	129.24	34773.0
2021-01-04 19:30:00	AAPL	Stock	129.24	129.41	129.11	129.39	51631.0
2021-01-04 04:00:00	MSFT	Stock	222.75	223.4	222.75	223.39	2683.0
2021-01-04 04:30:00	MSFT	Stock	223.38	223.4	223.01	223.15	2219.0
2021-01-04 05:00:00	MSFT	Stock	223.01	223.29	223.0	223.0	2825.0
2021-01-04 05:30:00	MSFT	Stock	223.0	223.0	222.52	222.52	1906.0
2021-01-04 06:00:00	MSFT	Stock	222.59	222.6	222.4	222.42	4554.0
2021-01-04 06:30:00	MSFT	Stock	222.4	222.83	222.28	222.62	9123.0
2021-01-04 07:00:00	MSFT	Stock	222.83	222.9	222.51	222.78	10274.0
2021-01-04 07:30:00	MSFT	Stock	222.83	223.15	222.73	223.1	7769.0
2021-01-04 08:00:00	MSFT	Stock	222.78	223.24	222.53	222.95	19842.0
2021-01-04 08:30:00	MSFT	Stock	222.85	223.1	222.66	222.96	9557.0
2021-01-04 09:00:00	MSFT	Stock	222.65	222.71	222.42	222.53	20125.0
2021-01-04 09:30:00	MSFT	Stock	222.53	223.0	219.283	219.79	3099721.0
2021-01-04 10:00:00	MSFT	Stock	219.81	220.61	219.52	220.51	1420654.0
2021-01-04 10:30:00	MSFT	Stock	220.5	220.95	218.87	218.93	1550656.0
2021-01-04 11:00:00	MSFT	Stock	218.95	219.23	217.42	218.08	1807265.0
2021-01-04 11:30:00	MSFT	Stock	218.05	218.05	216.14	216.27	1547609.0
2021-01-04 12:00:00	MSFT	Stock	216.27	216.57	214.81	216.076	2423786.0
2021-01-04 12:30:00	MSFT	Stock	216.07	216.07	214.95	215.6	1178554.0

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

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