PREVIEW / stock_30min / 2021-06-01

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-06-01.parquet
  size:    2.3 MB
  rows:    114,777
  symbols: 2,981

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-06-01 04:00:00	AAPL	Stock	124.65	125.36	124.65	125.2	13946.0
2021-06-01 04:30:00	AAPL	Stock	125.19	125.25	125.04	125.25	12304.0
2021-06-01 05:00:00	AAPL	Stock	125.23	125.27	125.21	125.22	3378.0
2021-06-01 05:30:00	AAPL	Stock	125.25	125.33	125.21	125.27	7677.0
2021-06-01 06:00:00	AAPL	Stock	125.37	125.56	125.3	125.52	5785.0
2021-06-01 06:30:00	AAPL	Stock	125.54	125.55	125.2	125.25	6677.0
2021-06-01 07:00:00	AAPL	Stock	125.25	125.3	125.06	125.18	54317.0
2021-06-01 07:30:00	AAPL	Stock	125.17	125.19	125.07	125.1	30922.0
2021-06-01 08:00:00	AAPL	Stock	125.12	125.28	125.05	125.12	185662.0
2021-06-01 08:30:00	AAPL	Stock	125.11	125.12	125.03	125.12	101741.0
2021-06-01 09:00:00	AAPL	Stock	125.12	125.3	125.03	125.07	250339.0
2021-06-01 09:30:00	AAPL	Stock	125.07	125.35	124.44	124.64	9825819.0
2021-06-01 10:00:00	AAPL	Stock	124.64	124.71	123.94	124.64	6187561.0
2021-06-01 10:30:00	AAPL	Stock	124.6409	124.82	124.25	124.425	5558561.0
2021-06-01 11:00:00	AAPL	Stock	124.42	124.83	124.34	124.68	3701525.0
2021-06-01 11:30:00	AAPL	Stock	124.68	124.81	124.55	124.7199	2692745.0
2021-06-01 12:00:00	AAPL	Stock	124.72	124.74	124.36	124.585	3055308.0
2021-06-01 12:30:00	AAPL	Stock	124.58	124.85	124.545	124.8397	2027588.0
2021-06-01 13:00:00	AAPL	Stock	124.8389	124.84	124.49	124.5675	2031676.0
2021-06-01 13:30:00	AAPL	Stock	124.56	124.6	124.46	124.58	1810000.0
2021-06-01 14:00:00	AAPL	Stock	124.575	124.87	124.53	124.8	1878919.0
2021-06-01 14:30:00	AAPL	Stock	124.81	125.0	124.7521	124.88	2425423.0
2021-06-01 15:00:00	AAPL	Stock	124.875	124.8971	124.59	124.5901	2537165.0
2021-06-01 15:30:00	AAPL	Stock	124.59	124.61	124.2	124.3	5490125.0
2021-06-01 16:00:00	AAPL	Stock	124.27	124.94	124.15	124.23	5139785.0
2021-06-01 16:30:00	AAPL	Stock	124.23	124.28	124.05	124.19	71239.0
2021-06-01 17:00:00	AAPL	Stock	124.2	124.23	124.19	124.2	24500.0
2021-06-01 17:30:00	AAPL	Stock	124.2	124.23	124.18	124.19	25610.0
2021-06-01 18:00:00	AAPL	Stock	124.18	124.19	124.11	124.18	27510.0
2021-06-01 18:30:00	AAPL	Stock	124.18	124.2	124.1	124.12	21264.0
2021-06-01 19:00:00	AAPL	Stock	124.13	124.15	124.07	124.0901	30240.0
2021-06-01 19:30:00	AAPL	Stock	124.1	124.15	124.0	124.06	55228.0
2021-06-01 04:00:00	MSFT	Stock	250.93	251.17	250.83	250.83	2381.0
2021-06-01 04:30:00	MSFT	Stock	250.99	251.35	250.99	251.35	524.0
2021-06-01 05:30:00	MSFT	Stock	251.3	251.3	251.29	251.29	515.0
2021-06-01 06:00:00	MSFT	Stock	251.0	251.0	251.0	251.0	159.0
2021-06-01 06:30:00	MSFT	Stock	250.73	250.73	250.31	250.6	5004.0
2021-06-01 07:00:00	MSFT	Stock	250.46	250.75	250.27	250.75	6997.0
2021-06-01 07:30:00	MSFT	Stock	250.96	250.98	250.5	250.7	6035.0
2021-06-01 08:00:00	MSFT	Stock	250.7477	250.98	249.056	250.81	11533.0
2021-06-01 08:30:00	MSFT	Stock	250.8	250.8	250.26	250.26	12769.0
2021-06-01 09:00:00	MSFT	Stock	250.3	251.4	250.3	251.21	30598.0
2021-06-01 09:30:00	MSFT	Stock	251.21	251.29	249.43	250.0175	2216939.0
2021-06-01 10:00:00	MSFT	Stock	250.01	250.06	247.91	248.64	1430468.0
2021-06-01 10:30:00	MSFT	Stock	248.65	249.13	247.68	247.95	1165876.0
2021-06-01 11:00:00	MSFT	Stock	247.94	248.59	247.67	248.51	833930.0
2021-06-01 11:30:00	MSFT	Stock	248.5	248.63	248.16	248.33	758160.0
2021-06-01 12:00:00	MSFT	Stock	248.335	248.385	247.78	248.22	762583.0
2021-06-01 12:30:00	MSFT	Stock	248.23	248.3	247.85	248.035	567531.0
2021-06-01 13:00:00	MSFT	Stock	248.03	248.03	247.7	247.87	580143.0

> showing 50 of 114,777 rows — these rows as CSV

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