PREVIEW / stock_30min / 2022-07-13

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-07-13.parquet
  size:    2.0 MB
  rows:    101,753
  symbols: 2,304

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-07-13 04:00:00	AAPL	Stock	146.09	146.37	145.98	146.2	5056.0
2022-07-13 04:30:00	AAPL	Stock	146.31	146.44	146.3	146.3	1900.0
2022-07-13 05:00:00	AAPL	Stock	146.3	146.35	146.24	146.33	8070.0
2022-07-13 05:30:00	AAPL	Stock	146.32	146.32	146.19	146.19	700.0
2022-07-13 06:00:00	AAPL	Stock	146.13	146.24	146.06	146.09	3454.0
2022-07-13 06:30:00	AAPL	Stock	146.09	146.2	146.02	146.02	3425.0
2022-07-13 07:00:00	AAPL	Stock	146.09	146.4	146.02	146.31	25598.0
2022-07-13 07:30:00	AAPL	Stock	146.32	146.59	146.2	146.5	22289.0
2022-07-13 08:00:00	AAPL	Stock	146.4	147.8	145.496	147.8	219336.0
2022-07-13 08:30:00	AAPL	Stock	147.8	147.8	142.37	143.45	801395.0
2022-07-13 09:00:00	AAPL	Stock	143.4	143.8005	142.9	142.95	415415.0
2022-07-13 09:30:00	AAPL	Stock	142.99	145.32	142.1201	145.04	10860620.0
2022-07-13 10:00:00	AAPL	Stock	145.04	145.16	143.86	144.4699	5524896.0
2022-07-13 10:30:00	AAPL	Stock	144.46	146.42	144.24	145.63	5551302.0
2022-07-13 11:00:00	AAPL	Stock	145.63	146.11	145.23	145.32	3228509.0
2022-07-13 11:30:00	AAPL	Stock	145.32	145.53	144.79	145.22	2612429.0
2022-07-13 12:00:00	AAPL	Stock	145.22	145.82	145.15	145.76	2313820.0
2022-07-13 12:30:00	AAPL	Stock	145.77	146.02	145.56	145.995	2146618.0
2022-07-13 13:00:00	AAPL	Stock	146.0	146.45	145.6	145.78	2798667.0
2022-07-13 13:30:00	AAPL	Stock	145.79	146.21	145.42	146.141	1977327.0
2022-07-13 14:00:00	AAPL	Stock	146.1483	146.1483	145.2	146.0301	2651060.0
2022-07-13 14:30:00	AAPL	Stock	146.03	146.42	145.7501	146.3901	2514932.0
2022-07-13 15:00:00	AAPL	Stock	146.4	146.42	145.7818	145.93	2578506.0
2022-07-13 15:30:00	AAPL	Stock	145.91	146.03	145.4	145.45	5860423.0
2022-07-13 16:00:00	AAPL	Stock	145.45	145.69	145.15	145.18	7599874.0
2022-07-13 16:30:00	AAPL	Stock	145.21	145.49	145.03	145.1701	34181.0
2022-07-13 17:00:00	AAPL	Stock	145.1621	145.22	145.1471	145.22	10978.0
2022-07-13 17:30:00	AAPL	Stock	145.22	145.22	145.13	145.2	17803.0
2022-07-13 18:00:00	AAPL	Stock	145.17	145.17	144.91	145.05	18673.0
2022-07-13 18:30:00	AAPL	Stock	145.06	145.06	144.63	144.88	17662.0
2022-07-13 19:00:00	AAPL	Stock	144.83	144.93	144.68	144.71	11649.0
2022-07-13 19:30:00	AAPL	Stock	144.71	144.72	144.3	144.35	30238.0
2022-07-13 04:00:00	MSFT	Stock	254.5	254.58	254.0	254.02	2466.0
2022-07-13 04:30:00	MSFT	Stock	254.61	254.81	254.61	254.81	620.0
2022-07-13 05:00:00	MSFT	Stock	255.3	255.49	255.11	255.49	2712.0
2022-07-13 05:30:00	MSFT	Stock	255.36	255.36	255.23	255.23	500.0
2022-07-13 06:00:00	MSFT	Stock	255.1	255.1	255.01	255.01	1922.0
2022-07-13 06:30:00	MSFT	Stock	254.6	254.82	254.5	254.82	2007.0
2022-07-13 07:00:00	MSFT	Stock	254.97	255.05	254.18	254.77	13850.0
2022-07-13 07:30:00	MSFT	Stock	254.72	255.42	254.62	255.11	10774.0
2022-07-13 08:00:00	MSFT	Stock	254.6413	256.65	254.08	256.65	56886.0
2022-07-13 08:30:00	MSFT	Stock	256.65	256.65	247.0	250.26	174048.0
2022-07-13 09:00:00	MSFT	Stock	250.02	250.44	248.4143	250.0	197274.0
2022-07-13 09:30:00	MSFT	Stock	249.9	252.36	248.85	250.13	3661836.0
2022-07-13 10:00:00	MSFT	Stock	250.12	250.485	248.11	249.1854	1837976.0
2022-07-13 10:30:00	MSFT	Stock	249.17	250.92	248.91	250.5	1909412.0
2022-07-13 11:00:00	MSFT	Stock	250.51	251.92	250.12	250.43	1145637.0
2022-07-13 11:30:00	MSFT	Stock	250.4387	250.9	249.33	250.55	751039.0
2022-07-13 12:00:00	MSFT	Stock	250.56	251.62	250.5	251.46	659041.0
2022-07-13 12:30:00	MSFT	Stock	251.47	252.8	251.385	252.77	735112.0

> showing 50 of 101,753 rows — these rows as CSV

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