PREVIEW / stock_30min / 2022-07-20

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-07-20.parquet
  size:    2.1 MB
  rows:    103,759
  symbols: 2,299

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-20 04:00:00	AAPL	Stock	151.6	151.6	151.16	151.28	22218.0
2022-07-20 04:30:00	AAPL	Stock	151.28	151.42	151.12	151.4	7718.0
2022-07-20 05:00:00	AAPL	Stock	151.41	151.45	151.27	151.27	2943.0
2022-07-20 05:30:00	AAPL	Stock	151.26	151.62	151.26	151.62	9939.0
2022-07-20 06:00:00	AAPL	Stock	151.55	151.56	151.4	151.55	5973.0
2022-07-20 06:30:00	AAPL	Stock	151.4	151.4	150.6	151.02	26707.0
2022-07-20 07:00:00	AAPL	Stock	151.04	151.2	150.88	151.19	45754.0
2022-07-20 07:30:00	AAPL	Stock	151.2	151.47	150.93	151.41	32929.0
2022-07-20 08:00:00	AAPL	Stock	151.09	153.0	150.623	151.24	191509.0
2022-07-20 08:30:00	AAPL	Stock	151.2	151.79	151.0	151.45	180890.0
2022-07-20 09:00:00	AAPL	Stock	151.49	151.58	150.73	151.01	188907.0
2022-07-20 09:30:00	AAPL	Stock	151.07	151.73	150.37	151.05	7158131.0
2022-07-20 10:00:00	AAPL	Stock	151.05	151.99	150.83	151.905	4782131.0
2022-07-20 10:30:00	AAPL	Stock	151.9	153.6	151.88	153.38	6259166.0
2022-07-20 11:00:00	AAPL	Stock	153.38	153.39	152.87	153.264	3633680.0
2022-07-20 11:30:00	AAPL	Stock	153.26	153.4821	152.96	153.175	2594347.0
2022-07-20 12:00:00	AAPL	Stock	153.18	153.72	153.1101	153.16	2404740.0
2022-07-20 12:30:00	AAPL	Stock	153.165	153.63	152.6305	153.135	2960213.0
2022-07-20 13:00:00	AAPL	Stock	153.13	153.28	152.08	152.7101	3089307.0
2022-07-20 13:30:00	AAPL	Stock	152.71	152.98	152.15	152.1811	2185568.0
2022-07-20 14:00:00	AAPL	Stock	152.19	153.14	152.16	153.051	3087170.0
2022-07-20 14:30:00	AAPL	Stock	153.055	153.37	152.92	153.2774	2815876.0
2022-07-20 15:00:00	AAPL	Stock	153.275	153.6899	153.19	153.55	2906413.0
2022-07-20 15:30:00	AAPL	Stock	153.5477	153.5799	152.85	153.03	5844807.0
2022-07-20 16:00:00	AAPL	Stock	153.03	153.38	152.6	152.63	5975014.0
2022-07-20 16:30:00	AAPL	Stock	152.63	153.04	152.34	152.43	74858.0
2022-07-20 17:00:00	AAPL	Stock	152.41	152.58	152.3	152.53	17419.0
2022-07-20 17:30:00	AAPL	Stock	152.57	152.6891	152.4752	152.5006	12466.0
2022-07-20 18:00:00	AAPL	Stock	152.58	152.68	152.43	152.49	24548.0
2022-07-20 18:30:00	AAPL	Stock	152.5	152.5	152.16	152.36	16119.0
2022-07-20 19:00:00	AAPL	Stock	152.53	152.69	152.33	152.67	6533.0
2022-07-20 19:30:00	AAPL	Stock	152.6	152.67	152.51	152.65	8474.0
2022-07-20 04:00:00	MSFT	Stock	259.31	259.63	259.05	259.33	5016.0
2022-07-20 04:30:00	MSFT	Stock	259.38	259.43	259.25	259.39	672.0
2022-07-20 05:00:00	MSFT	Stock	259.57	259.57	259.57	259.57	100.0
2022-07-20 05:30:00	MSFT	Stock	259.5	259.79	259.5	259.79	538.0
2022-07-20 06:00:00	MSFT	Stock	259.65	259.77	259.65	259.77	508.0
2022-07-20 06:30:00	MSFT	Stock	259.55	259.55	258.03	258.31	4591.0
2022-07-20 07:00:00	MSFT	Stock	258.68	258.75	258.4	258.6	6117.0
2022-07-20 07:30:00	MSFT	Stock	258.6	258.6	258.32	258.32	1531.0
2022-07-20 08:00:00	MSFT	Stock	258.79	258.882	258.0	258.29	30741.0
2022-07-20 08:30:00	MSFT	Stock	258.32	258.995	258.2	258.78	16797.0
2022-07-20 09:00:00	MSFT	Stock	258.8	259.8	258.75	259.7	39199.0
2022-07-20 09:30:00	MSFT	Stock	259.89	261.71	258.91	260.08	1981127.0
2022-07-20 10:00:00	MSFT	Stock	260.13	261.42	259.6	261.32	880743.0
2022-07-20 10:30:00	MSFT	Stock	261.31	263.16	261.16	263.1595	1014105.0
2022-07-20 11:00:00	MSFT	Stock	263.15	263.18	262.08	263.11	847153.0
2022-07-20 11:30:00	MSFT	Stock	263.13	263.79	263.01	263.77	738711.0
2022-07-20 12:00:00	MSFT	Stock	263.77	264.87	263.725	264.1231	868078.0
2022-07-20 12:30:00	MSFT	Stock	264.12	264.3894	261.92	262.92	1066085.0

> showing 50 of 103,759 rows — these rows as CSV

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