PREVIEW / stock_30min / 2021-11-03

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-11-03.parquet
  size:    2.3 MB
  rows:    113,684
  symbols: 2,717

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-11-03 04:00:00	AAPL	Stock	150.05	150.39	150.05	150.34	8017.0
2021-11-03 04:30:00	AAPL	Stock	150.25	150.3	150.07	150.19	2154.0
2021-11-03 05:00:00	AAPL	Stock	150.1	150.21	150.07	150.14	3665.0
2021-11-03 05:30:00	AAPL	Stock	150.09	150.09	150.05	150.08	1857.0
2021-11-03 06:00:00	AAPL	Stock	150.01	150.11	149.99	150.04	11948.0
2021-11-03 06:30:00	AAPL	Stock	150.07	150.1	150.0	150.0	1926.0
2021-11-03 07:00:00	AAPL	Stock	150.0	150.23	149.98	150.19	25514.0
2021-11-03 07:30:00	AAPL	Stock	150.21	150.26	150.12	150.23	18185.0
2021-11-03 08:00:00	AAPL	Stock	149.95	150.28	149.95	150.15	129107.0
2021-11-03 08:30:00	AAPL	Stock	150.19	150.45	150.12	150.33	66182.0
2021-11-03 09:00:00	AAPL	Stock	150.34	150.65	150.27	150.39	215616.0
2021-11-03 09:30:00	AAPL	Stock	150.37	150.97	149.82	150.72	6283922.0
2021-11-03 10:00:00	AAPL	Stock	150.73	150.82	150.3623	150.615	2654854.0
2021-11-03 10:30:00	AAPL	Stock	150.62	150.64	150.1103	150.2684	2390882.0
2021-11-03 11:00:00	AAPL	Stock	150.265	150.55	150.16	150.36	1993295.0
2021-11-03 11:30:00	AAPL	Stock	150.355	150.58	150.27	150.515	1398287.0
2021-11-03 12:00:00	AAPL	Stock	150.51	150.63	150.43	150.56	1514176.0
2021-11-03 12:30:00	AAPL	Stock	150.57	150.7	150.35	150.3795	1247634.0
2021-11-03 13:00:00	AAPL	Stock	150.38	150.4	150.23	150.32	1143605.0
2021-11-03 13:30:00	AAPL	Stock	150.3101	150.45	150.19	150.36	1248890.0
2021-11-03 14:00:00	AAPL	Stock	150.37	150.99	150.21	150.845	3602354.0
2021-11-03 14:30:00	AAPL	Stock	150.8499	151.41	150.62	151.22	3546387.0
2021-11-03 15:00:00	AAPL	Stock	151.22	151.495	151.04	151.49	2909405.0
2021-11-03 15:30:00	AAPL	Stock	151.49	151.97	151.37	151.49	5871142.0
2021-11-03 16:00:00	AAPL	Stock	151.48	151.52	151.39	151.45	8591761.0
2021-11-03 16:30:00	AAPL	Stock	151.47	151.5	151.4	151.47	115633.0
2021-11-03 17:00:00	AAPL	Stock	151.45	151.46	151.4	151.43	32043.0
2021-11-03 17:30:00	AAPL	Stock	151.43	151.43	151.38	151.39	19045.0
2021-11-03 18:00:00	AAPL	Stock	151.41	151.58	151.38	151.57	25061.0
2021-11-03 18:30:00	AAPL	Stock	151.57	151.62	151.51	151.6	23936.0
2021-11-03 19:00:00	AAPL	Stock	151.62	152.0	151.61	151.89	69771.0
2021-11-03 19:30:00	AAPL	Stock	151.875	152.0	151.7	151.77	41360.0
2021-11-03 04:00:00	MSFT	Stock	333.15	334.46	333.15	334.1	3212.0
2021-11-03 04:30:00	MSFT	Stock	334.13	334.19	334.13	334.19	607.0
2021-11-03 05:30:00	MSFT	Stock	334.4	334.45	334.4	334.41	388.0
2021-11-03 06:00:00	MSFT	Stock	334.58	334.58	334.25	334.45	1415.0
2021-11-03 06:30:00	MSFT	Stock	334.5	334.5	334.01	334.01	1038.0
2021-11-03 07:00:00	MSFT	Stock	334.0	334.01	333.78	333.95	2454.0
2021-11-03 07:30:00	MSFT	Stock	334.0	334.35	334.0	334.35	849.0
2021-11-03 08:00:00	MSFT	Stock	334.0	334.4	333.78	333.865	21847.0
2021-11-03 08:30:00	MSFT	Stock	333.94	334.0	333.6	333.9	15285.0
2021-11-03 09:00:00	MSFT	Stock	333.8401	334.58	333.73	334.11	21254.0
2021-11-03 09:30:00	MSFT	Stock	334.15	334.15	331.36	332.85	1866812.0
2021-11-03 10:00:00	MSFT	Stock	332.91	332.97	330.85	330.86	1068335.0
2021-11-03 10:30:00	MSFT	Stock	330.88	331.56	330.7798	331.48	799106.0
2021-11-03 11:00:00	MSFT	Stock	331.49	331.53	330.65	331.24	648784.0
2021-11-03 11:30:00	MSFT	Stock	331.26	332.03	330.75	331.99	560591.0
2021-11-03 12:00:00	MSFT	Stock	331.97	332.06	331.645	331.71	459584.0
2021-11-03 12:30:00	MSFT	Stock	331.705	331.88	331.168	331.75	508359.0
2021-11-03 13:00:00	MSFT	Stock	331.77	332.12	331.43	332.04	412327.0

> showing 50 of 113,684 rows — these rows as CSV

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