PREVIEW / stock_30min / 2022-05-27

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-05-27.parquet
  size:    2.1 MB
  rows:    105,794
  symbols: 2,376

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-27 04:00:00	AAPL	Stock	143.99	143.99	143.0	143.81	12159.0
2022-05-27 04:30:00	AAPL	Stock	143.9	144.24	143.87	144.06	14405.0
2022-05-27 05:00:00	AAPL	Stock	144.0	144.0	143.85	143.97	4037.0
2022-05-27 05:30:00	AAPL	Stock	144.05	144.45	144.01	144.4	16603.0
2022-05-27 06:00:00	AAPL	Stock	144.35	144.35	143.98	144.19	11138.0
2022-05-27 06:30:00	AAPL	Stock	144.13	144.29	143.97	144.29	12604.0
2022-05-27 07:00:00	AAPL	Stock	144.18	144.3	143.93	144.02	38009.0
2022-05-27 07:30:00	AAPL	Stock	144.0	144.17	143.65	143.75	28939.0
2022-05-27 08:00:00	AAPL	Stock	144.25	144.45	143.03	144.0999	400838.0
2022-05-27 08:30:00	AAPL	Stock	144.02	145.58	143.81	145.36	608143.0
2022-05-27 09:00:00	AAPL	Stock	145.39	145.65	145.0	145.38	468714.0
2022-05-27 09:30:00	AAPL	Stock	145.39	147.32	145.26	147.06	12274760.0
2022-05-27 10:00:00	AAPL	Stock	147.05	148.66	146.92	147.911	8970463.0
2022-05-27 10:30:00	AAPL	Stock	147.93	148.4566	147.34	147.43	5139301.0
2022-05-27 11:00:00	AAPL	Stock	147.44	148.33	147.25	148.285	4197672.0
2022-05-27 11:30:00	AAPL	Stock	148.295	148.7	148.14	148.5931	4255780.0
2022-05-27 12:00:00	AAPL	Stock	148.6	148.83	147.95	148.16	3846313.0
2022-05-27 12:30:00	AAPL	Stock	148.16	148.43	148.03	148.32	2572131.0
2022-05-27 13:00:00	AAPL	Stock	148.31	148.71	148.26	148.52	2685223.0
2022-05-27 13:30:00	AAPL	Stock	148.53	148.64	148.06	148.295	2512584.0
2022-05-27 14:00:00	AAPL	Stock	148.3	148.65	148.18	148.485	2368721.0
2022-05-27 14:30:00	AAPL	Stock	148.485	148.85	148.36	148.765	2848944.0
2022-05-27 15:00:00	AAPL	Stock	148.765	149.19	148.56	149.03	5305456.0
2022-05-27 15:30:00	AAPL	Stock	149.02	149.68	148.64	149.65	11330578.0
2022-05-27 16:00:00	AAPL	Stock	149.64	149.8	149.48	149.78	11095070.0
2022-05-27 16:30:00	AAPL	Stock	149.71	149.95	149.71	149.93	73341.0
2022-05-27 17:00:00	AAPL	Stock	149.92	149.95	149.64	149.79	160767.0
2022-05-27 17:30:00	AAPL	Stock	149.79	149.86	149.7734	149.85	33261.0
2022-05-27 18:00:00	AAPL	Stock	149.8301	149.9	149.8	149.88	12035.0
2022-05-27 18:30:00	AAPL	Stock	149.87	150.0	149.87	149.99	27141.0
2022-05-27 19:00:00	AAPL	Stock	149.99	150.0	149.97	149.98	31846.0
2022-05-27 19:30:00	AAPL	Stock	149.99	150.0	149.97	150.0	80740.0
2022-05-27 04:00:00	MSFT	Stock	266.08	266.08	266.08	266.08	258.0
2022-05-27 04:30:00	MSFT	Stock	267.3	267.38	266.9	266.98	2500.0
2022-05-27 05:00:00	MSFT	Stock	266.75	266.94	266.55	266.85	3163.0
2022-05-27 05:30:00	MSFT	Stock	266.85	267.89	266.85	267.89	11045.0
2022-05-27 06:00:00	MSFT	Stock	267.77	267.8	267.05	267.05	963.0
2022-05-27 06:30:00	MSFT	Stock	267.1	267.5	267.0	267.5	1814.0
2022-05-27 07:00:00	MSFT	Stock	267.18	267.29	266.6	266.7	4606.0
2022-05-27 07:30:00	MSFT	Stock	266.89	267.0	266.02	266.22	7844.0
2022-05-27 08:00:00	MSFT	Stock	267.0023	267.61	265.236	266.63	25097.0
2022-05-27 08:30:00	MSFT	Stock	266.59	268.6599	266.3	268.2	86954.0
2022-05-27 09:00:00	MSFT	Stock	268.2	268.53	267.16	268.4	42930.0
2022-05-27 09:30:00	MSFT	Stock	268.51	270.95	267.56	270.7788	2495594.0
2022-05-27 10:00:00	MSFT	Stock	270.83	272.28	270.5211	271.78	1564721.0
2022-05-27 10:30:00	MSFT	Stock	271.78	272.21	270.86	271.17	1041540.0
2022-05-27 11:00:00	MSFT	Stock	271.2	271.9499	270.77	271.61	927042.0
2022-05-27 11:30:00	MSFT	Stock	271.64	272.35	271.5579	272.22	739906.0
2022-05-27 12:00:00	MSFT	Stock	272.22	272.44	271.61	271.78	715499.0
2022-05-27 12:30:00	MSFT	Stock	271.79	271.88	271.19	271.625	649737.0

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

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