PREVIEW / stock_30min / 2022-04-29

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-04-29.parquet
  size:    2.2 MB
  rows:    107,478
  symbols: 2,477

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-04-29 04:00:00	AAPL	Stock	161.0	161.5	159.91	160.1	115371.0
2022-04-29 04:30:00	AAPL	Stock	160.18	160.2	159.63	159.9	33827.0
2022-04-29 05:00:00	AAPL	Stock	159.87	159.98	159.35	159.6	50553.0
2022-04-29 05:30:00	AAPL	Stock	159.52	159.68	158.97	159.23	37867.0
2022-04-29 06:00:00	AAPL	Stock	159.24	159.65	159.02	159.16	31376.0
2022-04-29 06:30:00	AAPL	Stock	159.3	159.56	159.1	159.2	25815.0
2022-04-29 07:00:00	AAPL	Stock	159.25	160.49	159.0	160.14	191076.0
2022-04-29 07:30:00	AAPL	Stock	160.15	161.56	159.41	160.73	210201.0
2022-04-29 08:00:00	AAPL	Stock	159.35	162.85	159.01	162.42	881915.0
2022-04-29 08:30:00	AAPL	Stock	162.4895	162.49	160.85	161.76	834237.0
2022-04-29 09:00:00	AAPL	Stock	161.71	162.0	160.51	161.88	752677.0
2022-04-29 09:30:00	AAPL	Stock	161.84	165.99	160.79	165.9899	18447195.0
2022-04-29 10:00:00	AAPL	Stock	165.985	166.2	162.83	163.12	10378148.0
2022-04-29 10:30:00	AAPL	Stock	163.13	163.39	161.72	162.3542	7212424.0
2022-04-29 11:00:00	AAPL	Stock	162.34	162.35	161.15	162.0015	5185023.0
2022-04-29 11:30:00	AAPL	Stock	162.0	162.5708	161.48	161.54	4387624.0
2022-04-29 12:00:00	AAPL	Stock	161.5309	161.64	160.3133	160.4	4617508.0
2022-04-29 12:30:00	AAPL	Stock	160.3806	160.5301	159.8	160.07	4233556.0
2022-04-29 13:00:00	AAPL	Stock	160.06	160.72	159.59	160.1	4312524.0
2022-04-29 13:30:00	AAPL	Stock	160.105	160.7299	159.68	160.01	3399980.0
2022-04-29 14:00:00	AAPL	Stock	160.0	160.39	159.6	159.97	4089108.0
2022-04-29 14:30:00	AAPL	Stock	159.96	160.165	159.285	159.785	4560432.0
2022-04-29 15:00:00	AAPL	Stock	159.78	159.78	158.71	158.75	6567353.0
2022-04-29 15:30:00	AAPL	Stock	158.74	159.225	157.25	157.71	15111914.0
2022-04-29 16:00:00	AAPL	Stock	157.67	157.95	157.31	157.74	17719652.0
2022-04-29 16:30:00	AAPL	Stock	157.73	157.95	157.65	157.9	248493.0
2022-04-29 17:00:00	AAPL	Stock	157.89	157.92	157.8	157.88	65211.0
2022-04-29 17:30:00	AAPL	Stock	157.8342	157.94	157.75	157.86	72777.0
2022-04-29 18:00:00	AAPL	Stock	157.85	157.85	157.8	157.83	17823.0
2022-04-29 18:30:00	AAPL	Stock	157.82	157.93	157.82	157.9	38904.0
2022-04-29 19:00:00	AAPL	Stock	157.8701	157.99	157.86	157.99	21402.0
2022-04-29 19:30:00	AAPL	Stock	157.96	158.15	157.9	157.93	55153.0
2022-04-29 04:00:00	MSFT	Stock	289.99	290.94	289.14	290.58	5920.0
2022-04-29 04:30:00	MSFT	Stock	290.39	290.39	289.31	289.69	2937.0
2022-04-29 05:00:00	MSFT	Stock	289.53	289.84	289.16	289.16	7537.0
2022-04-29 05:30:00	MSFT	Stock	289.16	289.32	289.15	289.15	1988.0
2022-04-29 06:00:00	MSFT	Stock	289.01	289.15	289.0	289.01	1171.0
2022-04-29 06:30:00	MSFT	Stock	289.2	289.58	289.15	289.58	3684.0
2022-04-29 07:00:00	MSFT	Stock	289.15	289.5	288.95	289.25	3142.0
2022-04-29 07:30:00	MSFT	Stock	288.9	288.93	288.0	288.5	9560.0
2022-04-29 08:00:00	MSFT	Stock	289.0015	290.69	288.0	289.3	22353.0
2022-04-29 08:30:00	MSFT	Stock	289.07	289.41	288.17	288.5001	15468.0
2022-04-29 09:00:00	MSFT	Stock	288.53	289.08	288.0	288.44	67892.0
2022-04-29 09:30:00	MSFT	Stock	288.41	289.88	286.681	287.39	2664828.0
2022-04-29 10:00:00	MSFT	Stock	287.39	287.54	284.76	285.07	1483388.0
2022-04-29 10:30:00	MSFT	Stock	285.09	285.62	283.79	284.57	1384264.0
2022-04-29 11:00:00	MSFT	Stock	284.56	285.0	283.4069	284.81	1005664.0
2022-04-29 11:30:00	MSFT	Stock	284.78	285.58	284.1	284.12	1059567.0
2022-04-29 12:00:00	MSFT	Stock	284.17	284.265	283.02	283.71	938941.0
2022-04-29 12:30:00	MSFT	Stock	283.7	284.0699	282.9	283.1999	642532.0

> showing 50 of 107,478 rows — these rows as CSV

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