PREVIEW / stock_30min / 2022-10-20

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-10-20.parquet
  size:    2.0 MB
  rows:    101,004
  symbols: 2,133

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-10-20 04:00:00	AAPL	Stock	142.49	142.89	142.2	142.74	11966.0
2022-10-20 04:30:00	AAPL	Stock	142.79	142.9	142.79	142.82	1987.0
2022-10-20 05:00:00	AAPL	Stock	142.85	143.01	142.83	142.86	3746.0
2022-10-20 05:30:00	AAPL	Stock	142.93	143.15	142.92	143.0	6912.0
2022-10-20 06:00:00	AAPL	Stock	143.0	143.15	142.8	143.15	5266.0
2022-10-20 06:30:00	AAPL	Stock	143.15	144.11	143.15	143.83	20233.0
2022-10-20 07:00:00	AAPL	Stock	143.74	144.2	143.66	143.86	50595.0
2022-10-20 07:30:00	AAPL	Stock	143.9	143.9	143.41	143.71	18564.0
2022-10-20 08:00:00	AAPL	Stock	143.8501	144.1999	142.59	143.96	155748.0
2022-10-20 08:30:00	AAPL	Stock	143.82	144.48	142.51	142.51	173385.0
2022-10-20 09:00:00	AAPL	Stock	142.5	143.07	142.47	143.02	176568.0
2022-10-20 09:30:00	AAPL	Stock	143.02	145.3	142.91	144.63	8237112.0
2022-10-20 10:00:00	AAPL	Stock	144.63	145.89	144.57	145.49	4941817.0
2022-10-20 10:30:00	AAPL	Stock	145.485	145.7	144.85	145.69	3555013.0
2022-10-20 11:00:00	AAPL	Stock	145.7	145.78	144.83	145.11	2976201.0
2022-10-20 11:30:00	AAPL	Stock	145.115	145.83	145.115	145.38	2893746.0
2022-10-20 12:00:00	AAPL	Stock	145.37	145.41	144.7	144.8602	3286759.0
2022-10-20 12:30:00	AAPL	Stock	144.87	145.05	144.24	144.63	2651553.0
2022-10-20 13:00:00	AAPL	Stock	144.6299	144.69	143.8	144.285	3100330.0
2022-10-20 13:30:00	AAPL	Stock	144.29	144.35	143.33	143.5699	2947345.0
2022-10-20 14:00:00	AAPL	Stock	143.56	143.64	142.83	142.84	2742067.0
2022-10-20 14:30:00	AAPL	Stock	142.84	143.5	142.65	143.305	3008630.0
2022-10-20 15:00:00	AAPL	Stock	143.3	143.71	143.13	143.38	3269631.0
2022-10-20 15:30:00	AAPL	Stock	143.3875	143.78	143.0	143.33	5267256.0
2022-10-20 16:00:00	AAPL	Stock	143.33	143.67	143.0	143.2	6755684.0
2022-10-20 16:30:00	AAPL	Stock	143.32	143.45	143.12	143.35	47865.0
2022-10-20 17:00:00	AAPL	Stock	143.4	143.49	143.18	143.303	16570.0
2022-10-20 17:30:00	AAPL	Stock	143.303	143.34	142.83	142.9777	28336.0
2022-10-20 18:00:00	AAPL	Stock	142.85	142.87	142.45	142.6	29659.0
2022-10-20 18:30:00	AAPL	Stock	142.6	142.6	142.11	142.32	18008.0
2022-10-20 19:00:00	AAPL	Stock	142.43	142.43	142.05	142.1	30760.0
2022-10-20 19:30:00	AAPL	Stock	142.16	142.72	142.16	142.72	22864.0
2022-10-20 04:00:00	MSFT	Stock	234.02	235.05	234.01	235.05	3449.0
2022-10-20 04:30:00	MSFT	Stock	234.58	235.0	234.58	234.8	2216.0
2022-10-20 05:00:00	MSFT	Stock	234.99	234.99	234.99	234.99	490.0
2022-10-20 05:30:00	MSFT	Stock	235.19	235.58	235.19	235.3	3682.0
2022-10-20 06:00:00	MSFT	Stock	235.24	235.58	235.24	235.58	5238.0
2022-10-20 06:30:00	MSFT	Stock	235.8	237.65	235.8	236.8	4132.0
2022-10-20 07:00:00	MSFT	Stock	237.12	237.98	236.92	236.92	10415.0
2022-10-20 07:30:00	MSFT	Stock	236.65	236.65	236.33	236.33	675.0
2022-10-20 08:00:00	MSFT	Stock	237.65	238.94	235.889	238.7	17713.0
2022-10-20 08:30:00	MSFT	Stock	238.03	239.0	235.53	235.53	20676.0
2022-10-20 09:00:00	MSFT	Stock	235.72	236.74	235.72	235.75	10963.0
2022-10-20 09:30:00	MSFT	Stock	235.74	239.36	235.71	238.89	1936741.0
2022-10-20 10:00:00	MSFT	Stock	238.91	241.29	238.54	241.03	1103045.0
2022-10-20 10:30:00	MSFT	Stock	241.04	241.31	239.54	240.4	759503.0
2022-10-20 11:00:00	MSFT	Stock	240.4	240.6	238.87	239.29	611281.0
2022-10-20 11:30:00	MSFT	Stock	239.2799	240.33	239.24	239.65	602210.0
2022-10-20 12:00:00	MSFT	Stock	239.635	239.65	237.35	237.66	967075.0
2022-10-20 12:30:00	MSFT	Stock	237.63	238.05	236.89	237.94	681850.0

> showing 50 of 101,004 rows — these rows as CSV

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