PREVIEW / stock_30min / 2022-04-14

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-04-14.parquet
  size:    2.1 MB
  rows:    105,577
  symbols: 2,463

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-14 04:00:00	AAPL	Stock	170.52	170.7	170.1	170.1	17908.0
2022-04-14 04:30:00	AAPL	Stock	170.11	170.28	170.1	170.28	7212.0
2022-04-14 05:00:00	AAPL	Stock	170.17	170.21	170.05	170.16	3301.0
2022-04-14 05:30:00	AAPL	Stock	170.12	170.29	170.1	170.29	3319.0
2022-04-14 06:00:00	AAPL	Stock	170.34	170.45	170.1	170.1	4251.0
2022-04-14 06:30:00	AAPL	Stock	170.11	170.22	170.0	170.22	8242.0
2022-04-14 07:00:00	AAPL	Stock	170.2	170.48	170.2	170.3	13722.0
2022-04-14 07:30:00	AAPL	Stock	170.27	170.66	170.06	170.13	53043.0
2022-04-14 08:00:00	AAPL	Stock	170.2299	170.93	169.974	170.39	123226.0
2022-04-14 08:30:00	AAPL	Stock	170.49	170.6	170.1	170.16	131490.0
2022-04-14 09:00:00	AAPL	Stock	170.17	171.19	170.1	170.63	334485.0
2022-04-14 09:30:00	AAPL	Stock	170.73	171.27	169.27	169.37	9219804.0
2022-04-14 10:00:00	AAPL	Stock	169.37	169.615	168.09	168.47	5602819.0
2022-04-14 10:30:00	AAPL	Stock	168.4717	168.72	167.76	168.0101	3692730.0
2022-04-14 11:00:00	AAPL	Stock	168.0	168.32	167.59	168.265	3154806.0
2022-04-14 11:30:00	AAPL	Stock	168.265	168.35	167.35	167.46	3014086.0
2022-04-14 12:00:00	AAPL	Stock	167.45	167.8481	166.86	166.96	3300780.0
2022-04-14 12:30:00	AAPL	Stock	166.965	167.07	166.57	166.8501	2864037.0
2022-04-14 13:00:00	AAPL	Stock	166.85	166.9599	166.555	166.56	2411775.0
2022-04-14 13:30:00	AAPL	Stock	166.57	167.165	166.45	167.1401	3068106.0
2022-04-14 14:00:00	AAPL	Stock	167.145	167.39	166.55	166.6693	2920939.0
2022-04-14 14:30:00	AAPL	Stock	166.68	166.7911	165.9236	165.94	3205309.0
2022-04-14 15:00:00	AAPL	Stock	165.9401	166.2715	165.7201	165.82	4098389.0
2022-04-14 15:30:00	AAPL	Stock	165.83	165.99	165.04	165.28	8793668.0
2022-04-14 16:00:00	AAPL	Stock	165.28	165.37	165.18	165.35	8847091.0
2022-04-14 16:30:00	AAPL	Stock	165.34	165.48	165.29	165.39	194906.0
2022-04-14 17:00:00	AAPL	Stock	165.43	165.43	165.18	165.19	57167.0
2022-04-14 17:30:00	AAPL	Stock	165.19	165.37	165.16	165.2	21571.0
2022-04-14 18:00:00	AAPL	Stock	165.2	165.25	165.16	165.16	15338.0
2022-04-14 18:30:00	AAPL	Stock	165.23	165.25	165.2	165.22	8361.0
2022-04-14 19:00:00	AAPL	Stock	165.24	165.24	165.08	165.12	11049.0
2022-04-14 19:30:00	AAPL	Stock	165.08	165.11	165.0	165.0	25416.0
2022-04-14 04:00:00	MSFT	Stock	288.51	288.73	288.35	288.35	1422.0
2022-04-14 04:30:00	MSFT	Stock	288.1	288.1	288.1	288.1	100.0
2022-04-14 05:30:00	MSFT	Stock	287.9	287.9	287.9	287.9	348.0
2022-04-14 06:00:00	MSFT	Stock	288.26	288.26	288.17	288.17	754.0
2022-04-14 06:30:00	MSFT	Stock	287.75	287.75	287.75	287.75	117.0
2022-04-14 07:00:00	MSFT	Stock	288.0	288.26	287.62	287.62	11873.0
2022-04-14 07:30:00	MSFT	Stock	287.25	287.5	286.7	286.7	10480.0
2022-04-14 08:00:00	MSFT	Stock	287.8005	288.3099	286.9	287.7	12436.0
2022-04-14 08:30:00	MSFT	Stock	287.62	287.7	287.17	287.17	21373.0
2022-04-14 09:00:00	MSFT	Stock	287.18	289.45	287.14	287.86	113106.0
2022-04-14 09:30:00	MSFT	Stock	288.08	288.305	284.72	285.12	2714604.0
2022-04-14 10:00:00	MSFT	Stock	285.12	285.43	283.0268	283.68	1603233.0
2022-04-14 10:30:00	MSFT	Stock	283.67	283.9734	282.64	283.68	1175515.0
2022-04-14 11:00:00	MSFT	Stock	283.66	284.75	283.4	284.35	706364.0
2022-04-14 11:30:00	MSFT	Stock	284.3521	284.3763	283.0	283.17	531130.0
2022-04-14 12:00:00	MSFT	Stock	283.17	283.38	282.13	282.24	841739.0
2022-04-14 12:30:00	MSFT	Stock	282.24	282.36	281.46	282.15	878914.0
2022-04-14 13:00:00	MSFT	Stock	282.13	282.49	281.91	282.33	588164.0

> showing 50 of 105,577 rows — these rows as CSV

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