PREVIEW / stock_30min / 2021-12-09

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-12-09.parquet
  size:    2.2 MB
  rows:    110,566
  symbols: 2,662

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-12-09 04:00:00	AAPL	Stock	175.58	175.58	174.4	174.5	23559.0
2021-12-09 04:30:00	AAPL	Stock	174.6	174.7	174.48	174.56	3706.0
2021-12-09 05:00:00	AAPL	Stock	174.56	174.56	173.8	173.94	45814.0
2021-12-09 05:30:00	AAPL	Stock	173.95	174.0	173.7	173.85	14396.0
2021-12-09 06:00:00	AAPL	Stock	173.85	173.9	173.61	173.68	17664.0
2021-12-09 06:30:00	AAPL	Stock	173.73	173.85	173.67	173.85	8284.0
2021-12-09 07:00:00	AAPL	Stock	173.85	174.43	173.85	174.22	93877.0
2021-12-09 07:30:00	AAPL	Stock	174.24	174.69	174.23	174.57	79519.0
2021-12-09 08:00:00	AAPL	Stock	174.1001	174.71	173.82	174.38	264074.0
2021-12-09 08:30:00	AAPL	Stock	174.36	174.77	174.18	174.69	175863.0
2021-12-09 09:00:00	AAPL	Stock	174.73	175.45	174.63	174.85	574141.0
2021-12-09 09:30:00	AAPL	Stock	174.9	176.75	174.55	176.11	14312469.0
2021-12-09 10:00:00	AAPL	Stock	176.13	176.18	173.92	174.04	10770113.0
2021-12-09 10:30:00	AAPL	Stock	174.035	176.2	173.96	175.92	9399255.0
2021-12-09 11:00:00	AAPL	Stock	175.92	175.95	174.7901	175.5903	7294493.0
2021-12-09 11:30:00	AAPL	Stock	175.5978	175.705	174.68	174.7183	4437913.0
2021-12-09 12:00:00	AAPL	Stock	174.725	175.31	174.48	175.115	5235693.0
2021-12-09 12:30:00	AAPL	Stock	175.12	175.815	174.96	175.5	4416137.0
2021-12-09 13:00:00	AAPL	Stock	175.5	175.9	175.27	175.32	3622260.0
2021-12-09 13:30:00	AAPL	Stock	175.32	175.9599	175.1306	175.645	3991448.0
2021-12-09 14:00:00	AAPL	Stock	175.65	175.96	175.29	175.7	3772501.0
2021-12-09 14:30:00	AAPL	Stock	175.69	175.795	175.16	175.36	3687221.0
2021-12-09 15:00:00	AAPL	Stock	175.37	175.7199	174.57	174.94	5335190.0
2021-12-09 15:30:00	AAPL	Stock	174.94	175.345	174.19	174.62	9065480.0
2021-12-09 16:00:00	AAPL	Stock	174.58	174.64	174.01	174.28	9606207.0
2021-12-09 16:30:00	AAPL	Stock	174.34	174.56	174.2	174.2	45785.0
2021-12-09 17:00:00	AAPL	Stock	174.29	174.36	174.11	174.18	41703.0
2021-12-09 17:30:00	AAPL	Stock	174.2	174.33	174.11	174.23	26513.0
2021-12-09 18:00:00	AAPL	Stock	174.23	174.36	174.22	174.23	16166.0
2021-12-09 18:30:00	AAPL	Stock	174.23	174.35	174.2	174.27	17631.0
2021-12-09 19:00:00	AAPL	Stock	174.29	174.33	174.12	174.33	13201.0
2021-12-09 19:30:00	AAPL	Stock	174.33	174.34	174.14	174.15	27469.0
2021-12-09 04:00:00	MSFT	Stock	334.33	334.78	334.16	334.61	1781.0
2021-12-09 05:00:00	MSFT	Stock	334.64	334.64	334.0	334.0	571.0
2021-12-09 05:30:00	MSFT	Stock	334.0	334.0	334.0	334.0	860.0
2021-12-09 06:00:00	MSFT	Stock	333.98	334.01	333.5	333.5	852.0
2021-12-09 06:30:00	MSFT	Stock	333.97	333.97	333.9	333.9	300.0
2021-12-09 07:00:00	MSFT	Stock	333.9	334.08	333.7	334.08	4700.0
2021-12-09 07:30:00	MSFT	Stock	334.18	334.18	333.9	333.95	1857.0
2021-12-09 08:00:00	MSFT	Stock	334.97	334.97	333.4	333.5	11547.0
2021-12-09 08:30:00	MSFT	Stock	333.5	333.98	333.4	333.79	7704.0
2021-12-09 09:00:00	MSFT	Stock	333.89	334.7	333.89	334.69	20913.0
2021-12-09 09:30:00	MSFT	Stock	334.68	336.489	333.945	334.62	1930976.0
2021-12-09 10:00:00	MSFT	Stock	334.61	335.0299	333.49	333.6225	980250.0
2021-12-09 10:30:00	MSFT	Stock	333.63	334.2921	332.89	333.93	663129.0
2021-12-09 11:00:00	MSFT	Stock	333.9418	335.1785	333.35	335.1	588498.0
2021-12-09 11:30:00	MSFT	Stock	335.11	335.3273	334.06	334.32	663896.0
2021-12-09 12:00:00	MSFT	Stock	334.3269	334.6	333.49	333.88	533904.0
2021-12-09 12:30:00	MSFT	Stock	333.88	334.845	333.6201	334.7768	526814.0
2021-12-09 13:00:00	MSFT	Stock	334.77	334.97	333.94	334.63	473519.0

> showing 50 of 110,566 rows — these rows as CSV

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