PREVIEW / stock_30min / 2022-05-20

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-05-20.parquet
  size:    2.1 MB
  rows:    105,826
  symbols: 2,399

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-05-20 04:00:00	AAPL	Stock	139.02	140.1	138.32	139.36	53034.0
2022-05-20 04:30:00	AAPL	Stock	139.34	139.5	139.3	139.43	22334.0
2022-05-20 05:00:00	AAPL	Stock	139.36	139.6	139.26	139.43	34447.0
2022-05-20 05:30:00	AAPL	Stock	139.45	139.45	139.0	139.23	22876.0
2022-05-20 06:00:00	AAPL	Stock	139.18	139.44	139.17	139.44	6046.0
2022-05-20 06:30:00	AAPL	Stock	139.41	139.46	139.16	139.19	8028.0
2022-05-20 07:00:00	AAPL	Stock	139.17	139.29	138.88	139.21	63715.0
2022-05-20 07:30:00	AAPL	Stock	139.23	139.99	139.23	139.6	95436.0
2022-05-20 08:00:00	AAPL	Stock	139.05	139.99	138.86	139.5	547066.0
2022-05-20 08:30:00	AAPL	Stock	139.49	139.59	138.972	139.2	467120.0
2022-05-20 09:00:00	AAPL	Stock	139.15	139.9	139.01	139.04	427345.0
2022-05-20 09:30:00	AAPL	Stock	139.07	140.3597	138.07	139.86	15499519.0
2022-05-20 10:00:00	AAPL	Stock	139.87	140.7	138.12	138.78	8492333.0
2022-05-20 10:30:00	AAPL	Stock	138.78	138.99	137.06	137.19	5828741.0
2022-05-20 11:00:00	AAPL	Stock	137.2	137.53	136.32	136.9869	6478045.0
2022-05-20 11:30:00	AAPL	Stock	136.9787	137.42	136.75	136.77	5044914.0
2022-05-20 12:00:00	AAPL	Stock	136.78	136.89	135.12	135.29	7612966.0
2022-05-20 12:30:00	AAPL	Stock	135.3	135.47	133.6	134.36	9729819.0
2022-05-20 13:00:00	AAPL	Stock	134.34	134.38	132.81	132.8173	7298973.0
2022-05-20 13:30:00	AAPL	Stock	132.82	134.45	132.61	134.15	7822011.0
2022-05-20 14:00:00	AAPL	Stock	134.15	134.19	133.38	133.98	5556720.0
2022-05-20 14:30:00	AAPL	Stock	133.97	134.94	133.55	134.3647	5720633.0
2022-05-20 15:00:00	AAPL	Stock	134.37	135.4898	133.76	135.47	7029393.0
2022-05-20 15:30:00	AAPL	Stock	135.46	137.89	135.05	137.62	16196819.0
2022-05-20 16:00:00	AAPL	Stock	137.59	137.9	137.05	137.15	9711083.0
2022-05-20 16:30:00	AAPL	Stock	137.11	137.59	137.11	137.29	266680.0
2022-05-20 17:00:00	AAPL	Stock	137.28	137.59	137.16	137.21	1021999.0
2022-05-20 17:30:00	AAPL	Stock	137.24	137.44	137.2	137.36	70033.0
2022-05-20 18:00:00	AAPL	Stock	137.33	137.38	137.24	137.31	43879.0
2022-05-20 18:30:00	AAPL	Stock	137.31	137.38	137.2	137.2	46678.0
2022-05-20 19:00:00	AAPL	Stock	137.23	137.52	137.2	137.52	44033.0
2022-05-20 19:30:00	AAPL	Stock	137.53	137.68	137.53	137.56	67203.0
2022-05-20 04:00:00	MSFT	Stock	256.8	257.56	256.8	257.25	7861.0
2022-05-20 04:30:00	MSFT	Stock	257.88	258.27	257.77	257.77	2422.0
2022-05-20 05:00:00	MSFT	Stock	257.61	258.3	257.61	258.0	1828.0
2022-05-20 05:30:00	MSFT	Stock	257.7	257.7	257.46	257.57	2957.0
2022-05-20 06:00:00	MSFT	Stock	257.5	257.69	257.5	257.69	300.0
2022-05-20 06:30:00	MSFT	Stock	257.73	257.73	257.3	257.3	323.0
2022-05-20 07:00:00	MSFT	Stock	257.47	257.5	256.94	257.4	7552.0
2022-05-20 07:30:00	MSFT	Stock	257.44	258.35	257.2	257.5	11550.0
2022-05-20 08:00:00	MSFT	Stock	257.0	258.28	256.75	257.42	25971.0
2022-05-20 08:30:00	MSFT	Stock	257.2378	257.46	256.3	256.75	11499.0
2022-05-20 09:00:00	MSFT	Stock	256.86	258.0	256.684	257.41	32102.0
2022-05-20 09:30:00	MSFT	Stock	257.41	258.54	255.38	257.37	2875039.0
2022-05-20 10:00:00	MSFT	Stock	257.31	257.83	255.01	256.54	1452117.0
2022-05-20 10:30:00	MSFT	Stock	256.53	256.92	253.32	253.46	1040658.0
2022-05-20 11:00:00	MSFT	Stock	253.46	253.88	252.19	252.98	1293695.0
2022-05-20 11:30:00	MSFT	Stock	252.95	253.59	252.37	252.41	803418.0
2022-05-20 12:00:00	MSFT	Stock	252.38	252.58	250.54	250.83	1149810.0
2022-05-20 12:30:00	MSFT	Stock	250.82	251.2	247.95	249.55	3259526.0

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

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