PREVIEW / stock_30min / 2022-05-04

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-05-04.parquet
  size:    2.2 MB
  rows:    106,863
  symbols: 2,448

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-04 04:00:00	AAPL	Stock	159.88	159.88	159.6	159.6	5803.0
2022-05-04 04:30:00	AAPL	Stock	159.65	159.65	159.43	159.52	1006.0
2022-05-04 05:00:00	AAPL	Stock	159.38	159.6	159.22	159.6	1436.0
2022-05-04 05:30:00	AAPL	Stock	159.6	159.75	159.47	159.67	2417.0
2022-05-04 06:00:00	AAPL	Stock	159.75	159.85	159.67	159.67	1954.0
2022-05-04 06:30:00	AAPL	Stock	159.63	160.0	159.63	159.94	8167.0
2022-05-04 07:00:00	AAPL	Stock	159.84	160.16	159.69	160.0	36756.0
2022-05-04 07:30:00	AAPL	Stock	160.1	160.16	159.81	159.81	19502.0
2022-05-04 08:00:00	AAPL	Stock	159.9452	160.17	159.51	159.63	120898.0
2022-05-04 08:30:00	AAPL	Stock	159.68	159.82	159.35	159.35	1453741.0
2022-05-04 09:00:00	AAPL	Stock	159.38	159.71	159.25	159.67	83055.0
2022-05-04 09:30:00	AAPL	Stock	159.7	161.32	159.47	160.425	10273830.0
2022-05-04 10:00:00	AAPL	Stock	160.4388	160.812	159.7	160.0	6766270.0
2022-05-04 10:30:00	AAPL	Stock	159.9887	160.54	159.4865	160.19	4515227.0
2022-05-04 11:00:00	AAPL	Stock	160.2	160.2	159.37	159.5362	3633257.0
2022-05-04 11:30:00	AAPL	Stock	159.5411	161.05	159.26	160.7789	4099940.0
2022-05-04 12:00:00	AAPL	Stock	160.77	161.5687	160.31	161.45	3322825.0
2022-05-04 12:30:00	AAPL	Stock	161.45	161.94	161.2125	161.913	3367391.0
2022-05-04 13:00:00	AAPL	Stock	161.92	162.21	161.55	161.87	3942595.0
2022-05-04 13:30:00	AAPL	Stock	161.87	162.92	161.775	162.6	3933274.0
2022-05-04 14:00:00	AAPL	Stock	162.58	163.72	161.13	162.27	8003916.0
2022-05-04 14:30:00	AAPL	Stock	162.27	164.1	159.66	163.835	11374943.0
2022-05-04 15:00:00	AAPL	Stock	163.85	165.01	163.29	164.95	9461536.0
2022-05-04 15:30:00	AAPL	Stock	164.965	166.48	164.89	166.14	13574719.0
2022-05-04 16:00:00	AAPL	Stock	166.12	166.15	160.1493	165.56	6909240.0
2022-05-04 16:30:00	AAPL	Stock	165.6	166.0	165.3966	165.6738	82415.0
2022-05-04 17:00:00	AAPL	Stock	165.6	166.0	165.53	165.8326	85803.0
2022-05-04 17:30:00	AAPL	Stock	165.9123	165.97	165.82	165.92	48942.0
2022-05-04 18:00:00	AAPL	Stock	165.94	166.09	165.85	166.02	59772.0
2022-05-04 18:30:00	AAPL	Stock	166.02	166.03	165.78	165.88	15004.0
2022-05-04 19:00:00	AAPL	Stock	165.83	165.98	165.71	165.7599	13770.0
2022-05-04 19:30:00	AAPL	Stock	165.74	165.83	165.67	165.77	52645.0
2022-05-04 04:00:00	MSFT	Stock	281.77	281.77	281.77	281.77	100.0
2022-05-04 05:00:00	MSFT	Stock	281.93	281.93	281.9	281.9	1739.0
2022-05-04 05:30:00	MSFT	Stock	282.56	282.56	282.1	282.1	554.0
2022-05-04 06:00:00	MSFT	Stock	282.3	282.3	282.3	282.3	100.0
2022-05-04 06:30:00	MSFT	Stock	282.24	282.25	282.1	282.1	608.0
2022-05-04 07:00:00	MSFT	Stock	282.4	282.93	282.1	282.93	2792.0
2022-05-04 07:30:00	MSFT	Stock	282.9	282.9	282.5	282.5	300.0
2022-05-04 08:00:00	MSFT	Stock	282.2601	282.78	281.9	282.0905	15255.0
2022-05-04 08:30:00	MSFT	Stock	281.78	282.1	281.78	282.0999	432381.0
2022-05-04 09:00:00	MSFT	Stock	282.01	282.7	281.81	282.65	21267.0
2022-05-04 09:30:00	MSFT	Stock	282.6	284.21	280.52	280.56	1866817.0
2022-05-04 10:00:00	MSFT	Stock	280.61	281.39	278.75	279.57	1526351.0
2022-05-04 10:30:00	MSFT	Stock	279.61	279.7687	277.735	278.04	1227070.0
2022-05-04 11:00:00	MSFT	Stock	278.02	278.24	276.73	277.26	1044216.0
2022-05-04 11:30:00	MSFT	Stock	277.25	279.62	276.81	279.313	932204.0
2022-05-04 12:00:00	MSFT	Stock	279.315	281.3125	279.0799	281.26	702627.0
2022-05-04 12:30:00	MSFT	Stock	281.3176	282.169	280.83	282.14	848173.0
2022-05-04 13:00:00	MSFT	Stock	282.13	282.67	281.49	282.1	824015.0

> showing 50 of 106,863 rows — these rows as CSV

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