PREVIEW / stock_30min / 2021-04-30

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-04-30.parquet
  size:    2.2 MB
  rows:    110,463
  symbols: 2,984

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-04-30 04:00:00	AAPL	Stock	132.7	133.31	132.7	132.81	18684.0
2021-04-30 04:30:00	AAPL	Stock	132.89	133.01	132.82	133.0	12088.0
2021-04-30 05:00:00	AAPL	Stock	132.95	133.08	132.93	133.0	7523.0
2021-04-30 05:30:00	AAPL	Stock	132.92	132.94	132.66	132.75	12463.0
2021-04-30 06:00:00	AAPL	Stock	132.75	132.75	132.5	132.64	20463.0
2021-04-30 06:30:00	AAPL	Stock	132.64	132.68	131.86	132.25	54375.0
2021-04-30 07:00:00	AAPL	Stock	132.27	132.5	131.96	132.13	151416.0
2021-04-30 07:30:00	AAPL	Stock	132.12	132.25	131.86	132.0	162085.0
2021-04-30 08:00:00	AAPL	Stock	132.3001	132.49	131.69	131.95	392133.0
2021-04-30 08:30:00	AAPL	Stock	131.93	132.03	131.55	131.99	336739.0
2021-04-30 09:00:00	AAPL	Stock	131.99	132.22	131.57	131.83	378766.0
2021-04-30 09:30:00	AAPL	Stock	131.8	132.84	131.36	132.76	11282194.0
2021-04-30 10:00:00	AAPL	Stock	132.75	133.29	132.2	133.29	6926220.0
2021-04-30 10:30:00	AAPL	Stock	133.2801	133.56	133.1299	133.455	6076509.0
2021-04-30 11:00:00	AAPL	Stock	133.46	133.48	133.06	133.12	4789440.0
2021-04-30 11:30:00	AAPL	Stock	133.12	133.222	133.0	133.0301	3804716.0
2021-04-30 12:00:00	AAPL	Stock	133.03	133.18	132.7	133.1	3322251.0
2021-04-30 12:30:00	AAPL	Stock	133.1	133.15	132.28	132.435	4718208.0
2021-04-30 13:00:00	AAPL	Stock	132.43	132.64	132.26	132.283	3962665.0
2021-04-30 13:30:00	AAPL	Stock	132.28	132.38	131.64	131.74	5225668.0
2021-04-30 14:00:00	AAPL	Stock	131.75	131.9	131.49	131.86	4749300.0
2021-04-30 14:30:00	AAPL	Stock	131.86	132.07	131.79	131.86	3633220.0
2021-04-30 15:00:00	AAPL	Stock	131.865	132.14	131.37	131.68	5714433.0
2021-04-30 15:30:00	AAPL	Stock	131.68	131.72	131.065	131.52	11100358.0
2021-04-30 16:00:00	AAPL	Stock	131.52	131.57	131.34	131.35	9211527.0
2021-04-30 16:30:00	AAPL	Stock	131.37	131.57	131.36	131.5	61181.0
2021-04-30 17:00:00	AAPL	Stock	131.46	131.57	131.44	131.57	39793.0
2021-04-30 17:30:00	AAPL	Stock	131.55	131.57	131.51	131.56	31422.0
2021-04-30 18:00:00	AAPL	Stock	131.56	131.56	131.5	131.51	23217.0
2021-04-30 18:30:00	AAPL	Stock	131.5	131.52	131.46	131.4799	12648.0
2021-04-30 19:00:00	AAPL	Stock	131.47	131.48	131.4	131.41	29841.0
2021-04-30 19:30:00	AAPL	Stock	131.43	131.52	131.38	131.52	55113.0
2021-04-30 04:00:00	MSFT	Stock	251.28	251.54	251.2	251.54	1473.0
2021-04-30 05:00:00	MSFT	Stock	251.36	251.36	251.36	251.36	237.0
2021-04-30 05:30:00	MSFT	Stock	251.3	251.3	250.5	250.94	2528.0
2021-04-30 06:00:00	MSFT	Stock	250.98	251.3	250.5	250.56	4475.0
2021-04-30 06:30:00	MSFT	Stock	250.9	250.9	249.5	250.0	15247.0
2021-04-30 07:00:00	MSFT	Stock	250.28	250.4	249.98	249.98	18548.0
2021-04-30 07:30:00	MSFT	Stock	250.06	250.35	250.02	250.2	6141.0
2021-04-30 08:00:00	MSFT	Stock	250.1499	250.585	249.9	250.17	30110.0
2021-04-30 08:30:00	MSFT	Stock	250.0	250.6	249.59	250.35	30166.0
2021-04-30 09:00:00	MSFT	Stock	250.3	250.45	249.45	249.71	77376.0
2021-04-30 09:30:00	MSFT	Stock	249.74	251.45	249.6	250.63	3817094.0
2021-04-30 10:00:00	MSFT	Stock	250.63	252.84	250.51	252.81	1889768.0
2021-04-30 10:30:00	MSFT	Stock	252.8	253.08	251.62	251.63	1484626.0
2021-04-30 11:00:00	MSFT	Stock	251.64	251.75	250.82	250.88	1429028.0
2021-04-30 11:30:00	MSFT	Stock	250.89	251.97	250.72	251.88	958227.0
2021-04-30 12:00:00	MSFT	Stock	251.87	252.18	251.52	251.84	767874.0
2021-04-30 12:30:00	MSFT	Stock	251.88	251.965	251.245	251.39	576792.0
2021-04-30 13:00:00	MSFT	Stock	251.39	251.81	251.35	251.78	533740.0

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

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