PREVIEW / stock_30min / 2022-02-07

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-02-07.parquet
  size:    2.2 MB
  rows:    106,737
  symbols: 2,596

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
2022-02-07 04:00:00	AAPL	Stock	172.39	172.68	172.16	172.25	11954.0
2022-02-07 04:30:00	AAPL	Stock	172.35	172.5	171.8	172.44	4256.0
2022-02-07 05:00:00	AAPL	Stock	172.43	172.5	172.26	172.44	4365.0
2022-02-07 05:30:00	AAPL	Stock	172.38	172.91	172.2	172.2	6240.0
2022-02-07 06:00:00	AAPL	Stock	172.2	172.41	172.16	172.4	1704.0
2022-02-07 06:30:00	AAPL	Stock	172.81	172.81	172.58	172.74	2111.0
2022-02-07 07:00:00	AAPL	Stock	172.69	173.19	172.59	173.02	48545.0
2022-02-07 07:30:00	AAPL	Stock	173.07	173.34	172.95	173.3	30659.0
2022-02-07 08:00:00	AAPL	Stock	172.9	173.7	172.35	173.35	165624.0
2022-02-07 08:30:00	AAPL	Stock	173.35	173.42	173.02	173.22	64837.0
2022-02-07 09:00:00	AAPL	Stock	173.25	173.25	172.52	172.87	176518.0
2022-02-07 09:30:00	AAPL	Stock	172.84	173.94	172.39	173.43	7409917.0
2022-02-07 10:00:00	AAPL	Stock	173.45	173.64	172.82	173.28	4188196.0
2022-02-07 10:30:00	AAPL	Stock	173.29	173.9458	172.89	172.995	3493520.0
2022-02-07 11:00:00	AAPL	Stock	173.0	173.19	172.39	172.62	3542270.0
2022-02-07 11:30:00	AAPL	Stock	172.6276	172.68	171.73	172.065	3361888.0
2022-02-07 12:00:00	AAPL	Stock	172.06	172.44	171.8	171.84	2425936.0
2022-02-07 12:30:00	AAPL	Stock	171.83	172.05	171.53	171.87	2411821.0
2022-02-07 13:00:00	AAPL	Stock	171.86	172.63	171.74	172.558	2121944.0
2022-02-07 13:30:00	AAPL	Stock	172.56	172.72	172.15	172.6099	1949755.0
2022-02-07 14:00:00	AAPL	Stock	172.6186	172.62	171.97	172.61	2149183.0
2022-02-07 14:30:00	AAPL	Stock	172.61	172.83	172.36	172.605	2239844.0
2022-02-07 15:00:00	AAPL	Stock	172.6016	173.04	172.2	172.26	2816877.0
2022-02-07 15:30:00	AAPL	Stock	172.26	172.515	170.95	171.71	6731348.0
2022-02-07 16:00:00	AAPL	Stock	171.66	172.16	171.66	171.8	6367100.0
2022-02-07 16:30:00	AAPL	Stock	171.85	172.07	171.66	172.01	1899804.0
2022-02-07 17:00:00	AAPL	Stock	172.0	172.1	171.66	171.9099	34256.0
2022-02-07 17:30:00	AAPL	Stock	171.9	172.57	171.9	172.31	83969.0
2022-02-07 18:00:00	AAPL	Stock	172.42	172.58	172.2	172.55	22395.0
2022-02-07 18:30:00	AAPL	Stock	172.33	172.53	172.33	172.43	14731.0
2022-02-07 19:00:00	AAPL	Stock	172.4	172.5	172.1	172.25	33102.0
2022-02-07 19:30:00	AAPL	Stock	172.4	172.48	172.31	172.4	17648.0
2022-02-07 04:00:00	MSFT	Stock	305.7	305.7	304.77	305.06	1398.0
2022-02-07 04:30:00	MSFT	Stock	305.0	305.5	305.0	305.5	1784.0
2022-02-07 05:00:00	MSFT	Stock	305.62	305.87	305.5	305.5	952.0
2022-02-07 05:30:00	MSFT	Stock	305.27	305.85	305.27	305.85	1489.0
2022-02-07 06:30:00	MSFT	Stock	305.81	305.81	305.81	305.81	243.0
2022-02-07 07:00:00	MSFT	Stock	305.75	306.76	305.75	306.27	4069.0
2022-02-07 07:30:00	MSFT	Stock	306.41	306.9	306.0	306.9	4910.0
2022-02-07 08:00:00	MSFT	Stock	306.4584	311.01	305.85	307.0	20285.0
2022-02-07 08:30:00	MSFT	Stock	306.77	307.18	306.03	307.09	10470.0
2022-02-07 09:00:00	MSFT	Stock	307.21	307.4	305.5	306.21	15279.0
2022-02-07 09:30:00	MSFT	Stock	306.08	307.84	305.03	305.372	2164717.0
2022-02-07 10:00:00	MSFT	Stock	305.4	306.25	304.72	305.95	1262393.0
2022-02-07 10:30:00	MSFT	Stock	305.95	306.7552	304.9486	305.32	997317.0
2022-02-07 11:00:00	MSFT	Stock	305.31	305.53	304.0	304.35	1028538.0
2022-02-07 11:30:00	MSFT	Stock	304.31	304.41	302.3275	303.13	1125678.0
2022-02-07 12:00:00	MSFT	Stock	303.13	303.43	302.38	302.4	843228.0
2022-02-07 12:30:00	MSFT	Stock	302.4064	302.78	301.82	302.08	952553.0
2022-02-07 13:00:00	MSFT	Stock	302.055	303.74	301.95	303.497	901032.0

> showing 50 of 106,737 rows — these rows as CSV

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