PREVIEW / stock_30min / 2020-09-04

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-09-04.parquet
  size:    1.9 MB
  rows:    97,321
  symbols: 2,467

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
2020-09-04 04:00:00	AAPL	Stock	116.0	120.98	116.0	119.45	156820.0
2020-09-04 04:30:00	AAPL	Stock	119.55	120.52	119.4	120.3	92264.0
2020-09-04 05:00:00	AAPL	Stock	120.47	120.47	119.0	120.0	61207.0
2020-09-04 05:30:00	AAPL	Stock	119.81	121.4	119.64	121.14	66169.0
2020-09-04 06:00:00	AAPL	Stock	121.11	121.5	119.9	120.3	133005.0
2020-09-04 06:30:00	AAPL	Stock	120.34	120.64	119.95	120.0	58036.0
2020-09-04 07:00:00	AAPL	Stock	120.25	120.27	117.88	118.13	681745.0
2020-09-04 07:30:00	AAPL	Stock	118.17	118.3	117.19	117.75	611454.0
2020-09-04 08:00:00	AAPL	Stock	117.67	119.92	117.18	118.13	1343653.0
2020-09-04 08:30:00	AAPL	Stock	118.05	119.95	117.19	119.15	1684477.0
2020-09-04 09:00:00	AAPL	Stock	119.22	121.34	118.856	120.14	2021943.0
2020-09-04 09:30:00	AAPL	Stock	120.14	123.7	113.68	116.44	48976974.0
2020-09-04 10:00:00	AAPL	Stock	116.46	118.1	113.63	113.861	28858751.0
2020-09-04 10:30:00	AAPL	Stock	113.89	115.45	110.89	115.23	35079472.0
2020-09-04 11:00:00	AAPL	Stock	115.19	115.78	113.35	114.27	17015192.0
2020-09-04 11:30:00	AAPL	Stock	114.255	118.5	114.05	118.5	19011982.0
2020-09-04 12:00:00	AAPL	Stock	118.478	120.42	117.4	120.15	19423445.0
2020-09-04 12:30:00	AAPL	Stock	120.156	120.68	117.58	118.89	15887756.0
2020-09-04 13:00:00	AAPL	Stock	118.9	118.94	116.33	117.477	11724033.0
2020-09-04 13:30:00	AAPL	Stock	117.46	118.64	116.57	118.57	9418962.0
2020-09-04 14:00:00	AAPL	Stock	118.57	119.68	118.08	119.46	8886150.0
2020-09-04 14:30:00	AAPL	Stock	119.5	121.68	118.81	121.51	14422992.0
2020-09-04 15:00:00	AAPL	Stock	121.504	122.7	120.69	122.42	17394505.0
2020-09-04 15:30:00	AAPL	Stock	122.45	122.5	120.43	120.9	19167097.0
2020-09-04 16:00:00	AAPL	Stock	120.905	121.2	117.841	120.45	12592818.0
2020-09-04 16:30:00	AAPL	Stock	120.42	120.96	119.9	120.05	403698.0
2020-09-04 17:00:00	AAPL	Stock	120.07	120.87	120.05	120.85	188728.0
2020-09-04 17:30:00	AAPL	Stock	120.72	120.83	119.66	120.1	201152.0
2020-09-04 18:00:00	AAPL	Stock	120.15	120.25	120.05	120.07	48323.0
2020-09-04 18:30:00	AAPL	Stock	120.1	120.14	119.77	119.8	83421.0
2020-09-04 19:00:00	AAPL	Stock	119.83	119.83	119.5	119.5	62057.0
2020-09-04 19:30:00	AAPL	Stock	119.5	120.06	119.35	120.0	103900.0
2020-09-04 04:00:00	MSFT	Stock	217.4	217.77	216.6	217.5	17242.0
2020-09-04 04:30:00	MSFT	Stock	217.2	218.34	217.2	218.01	6029.0
2020-09-04 05:00:00	MSFT	Stock	218.3	218.3	217.0	217.39	10119.0
2020-09-04 05:30:00	MSFT	Stock	217.37	218.34	217.14	218.06	5859.0
2020-09-04 06:00:00	MSFT	Stock	218.34	218.37	216.91	217.0	14121.0
2020-09-04 06:30:00	MSFT	Stock	217.21	217.5	217.0	217.16	4532.0
2020-09-04 07:00:00	MSFT	Stock	217.04	217.24	214.55	215.22	74896.0
2020-09-04 07:30:00	MSFT	Stock	215.2	216.0	214.5	215.1	56579.0
2020-09-04 08:00:00	MSFT	Stock	216.855	217.07	214.5	215.24	84084.0
2020-09-04 08:30:00	MSFT	Stock	215.25	216.37	214.5	215.04	128920.0
2020-09-04 09:00:00	MSFT	Stock	215.02	216.58	214.92	215.27	96297.0
2020-09-04 09:30:00	MSFT	Stock	215.55	218.3	211.1	213.35	5741712.0
2020-09-04 10:00:00	MSFT	Stock	213.42	214.47	207.0	208.415	5031666.0
2020-09-04 10:30:00	MSFT	Stock	208.43	210.69	205.19	208.24	4668395.0
2020-09-04 11:00:00	MSFT	Stock	208.26	209.14	206.95	208.16	2979982.0
2020-09-04 11:30:00	MSFT	Stock	208.13	211.66	208.02	211.66	2378221.0
2020-09-04 12:00:00	MSFT	Stock	211.64	212.01	209.902	211.405	1914662.0
2020-09-04 12:30:00	MSFT	Stock	211.415	212.73	210.61	211.159	2113852.0

> showing 50 of 97,321 rows — these rows as CSV

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