PREVIEW / stock_30min / 2021-07-15

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-07-15.parquet
  size:    2.2 MB
  rows:    110,414
  symbols: 2,878

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
2021-07-15 04:00:00	AAPL	Stock	149.67	149.9	149.67	149.9	33957.0
2021-07-15 04:30:00	AAPL	Stock	149.9	149.95	149.51	149.95	26324.0
2021-07-15 05:00:00	AAPL	Stock	149.95	150.0	149.78	149.8	21305.0
2021-07-15 05:30:00	AAPL	Stock	149.75	149.87	149.65	149.87	13055.0
2021-07-15 06:00:00	AAPL	Stock	149.84	149.85	149.35	149.4	16461.0
2021-07-15 06:30:00	AAPL	Stock	149.35	149.68	149.22	149.4	13805.0
2021-07-15 07:00:00	AAPL	Stock	149.4	149.59	148.83	149.0	150405.0
2021-07-15 07:30:00	AAPL	Stock	148.98	149.3	148.88	149.23	118727.0
2021-07-15 08:00:00	AAPL	Stock	149.15	149.5	148.778	149.24	446506.0
2021-07-15 08:30:00	AAPL	Stock	149.2	149.57	149.18	149.3	303162.0
2021-07-15 09:00:00	AAPL	Stock	149.32	149.57	149.2	149.25	321691.0
2021-07-15 09:30:00	AAPL	Stock	149.24	150.0	148.12	149.775	16530450.0
2021-07-15 10:00:00	AAPL	Stock	149.78	149.8	148.46	148.75	9691654.0
2021-07-15 10:30:00	AAPL	Stock	148.76	149.26	147.91	148.185	8885508.0
2021-07-15 11:00:00	AAPL	Stock	148.19	148.735	147.795	148.6	6528220.0
2021-07-15 11:30:00	AAPL	Stock	148.6	148.88	147.98	148.13	5131326.0
2021-07-15 12:00:00	AAPL	Stock	148.12	148.15	147.43	148.0	6220231.0
2021-07-15 12:30:00	AAPL	Stock	147.99	148.24	147.64	147.9001	3653158.0
2021-07-15 13:00:00	AAPL	Stock	147.9	148.08	147.7	147.9	3464638.0
2021-07-15 13:30:00	AAPL	Stock	147.9019	147.9043	147.09	147.315	4886134.0
2021-07-15 14:00:00	AAPL	Stock	147.315	148.01	147.28	147.7957	4549900.0
2021-07-15 14:30:00	AAPL	Stock	147.79	148.0	147.32	147.99	3838796.0
2021-07-15 15:00:00	AAPL	Stock	147.995	148.22	147.91	148.09	4161052.0
2021-07-15 15:30:00	AAPL	Stock	148.0999	148.53	148.06	148.48	8840094.0
2021-07-15 16:00:00	AAPL	Stock	148.48	148.48	148.26	148.35	6136153.0
2021-07-15 16:30:00	AAPL	Stock	148.28	148.42	148.27	148.29	23014.0
2021-07-15 17:00:00	AAPL	Stock	148.3	148.37	148.3	148.34	11175.0
2021-07-15 17:30:00	AAPL	Stock	148.34	148.3501	148.28	148.3	19148.0
2021-07-15 18:00:00	AAPL	Stock	148.3	148.42	148.29	148.37	14372.0
2021-07-15 18:30:00	AAPL	Stock	148.33	148.33	148.19	148.3	26584.0
2021-07-15 19:00:00	AAPL	Stock	148.31	148.33	148.27	148.29	12478.0
2021-07-15 19:30:00	AAPL	Stock	148.29	148.3	148.05	148.07	38490.0
2021-07-15 04:00:00	MSFT	Stock	282.84	283.6	282.53	283.59	3007.0
2021-07-15 04:30:00	MSFT	Stock	283.77	284.25	283.77	284.25	420.0
2021-07-15 05:00:00	MSFT	Stock	284.18	284.18	283.6	283.6	5212.0
2021-07-15 05:30:00	MSFT	Stock	283.82	283.82	283.82	283.82	285.0
2021-07-15 06:00:00	MSFT	Stock	283.8	283.8	282.71	283.13	12809.0
2021-07-15 06:30:00	MSFT	Stock	283.0	283.37	282.7	283.11	6777.0
2021-07-15 07:00:00	MSFT	Stock	283.2	283.2	281.56	281.96	19416.0
2021-07-15 07:30:00	MSFT	Stock	282.24	282.44	282.05	282.17	12079.0
2021-07-15 08:00:00	MSFT	Stock	282.15	283.216	281.92	282.45	16662.0
2021-07-15 08:30:00	MSFT	Stock	282.44	282.57	282.15	282.2	10075.0
2021-07-15 09:00:00	MSFT	Stock	282.17	282.55	282.0	282.0	17631.0
2021-07-15 09:30:00	MSFT	Stock	282.03	282.51	280.86	281.73	2126516.0
2021-07-15 10:00:00	MSFT	Stock	281.76	281.84	280.09	280.45	1641101.0
2021-07-15 10:30:00	MSFT	Stock	280.47	281.71	279.83	280.59	1415067.0
2021-07-15 11:00:00	MSFT	Stock	280.58	281.51	280.22	281.27	964797.0
2021-07-15 11:30:00	MSFT	Stock	281.27	281.61	280.58	280.77	733413.0
2021-07-15 12:00:00	MSFT	Stock	280.755	281.23	280.13	281.22	844467.0
2021-07-15 12:30:00	MSFT	Stock	281.2	281.99	281.17	281.705	675715.0

> showing 50 of 110,414 rows — these rows as CSV

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