PREVIEW / stock_30min / 2022-12-20

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-12-20.parquet
  size:    2.1 MB
  rows:    103,040
  symbols: 2,002

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-12-20 04:00:00	AAPL	Stock	132.24	132.48	131.75	132.08	21255.0
2022-12-20 04:30:00	AAPL	Stock	132.12	132.3	131.79	131.92	9523.0
2022-12-20 05:00:00	AAPL	Stock	132.02	132.19	131.98	132.17	4572.0
2022-12-20 05:30:00	AAPL	Stock	132.18	132.18	131.95	132.09	7154.0
2022-12-20 06:00:00	AAPL	Stock	132.14	132.45	132.12	132.34	7372.0
2022-12-20 06:30:00	AAPL	Stock	132.4	132.43	132.2	132.28	2453.0
2022-12-20 07:00:00	AAPL	Stock	132.28	132.4	132.12	132.14	33328.0
2022-12-20 07:30:00	AAPL	Stock	132.14	132.14	131.65	131.66	30041.0
2022-12-20 08:00:00	AAPL	Stock	132.35	132.7	130.6	131.6525	104551.0
2022-12-20 08:30:00	AAPL	Stock	131.6899	132.1512	131.57	131.84	94988.0
2022-12-20 09:00:00	AAPL	Stock	131.84	131.86	131.25	131.39	141312.0
2022-12-20 09:30:00	AAPL	Stock	131.44	131.63	129.89	131.32	12329755.0
2022-12-20 10:00:00	AAPL	Stock	131.335	133.02	131.19	132.85	7934252.0
2022-12-20 10:30:00	AAPL	Stock	132.858	133.25	132.2315	132.28	4850311.0
2022-12-20 11:00:00	AAPL	Stock	132.26	132.48	130.845	131.0118	4639093.0
2022-12-20 11:30:00	AAPL	Stock	131.02	132.14	131.0	132.0942	4208928.0
2022-12-20 12:00:00	AAPL	Stock	132.1	132.72	132.0101	132.38	3489370.0
2022-12-20 12:30:00	AAPL	Stock	132.39	132.64	132.15	132.515	2616822.0
2022-12-20 13:00:00	AAPL	Stock	132.52	132.68	131.77	132.29	2967847.0
2022-12-20 13:30:00	AAPL	Stock	132.285	132.76	131.9	131.91	2696915.0
2022-12-20 14:00:00	AAPL	Stock	131.91	132.13	131.76	131.93	2988848.0
2022-12-20 14:30:00	AAPL	Stock	131.93	132.05	131.63	131.83	2451281.0
2022-12-20 15:00:00	AAPL	Stock	131.835	132.15	131.52	132.1	3151062.0
2022-12-20 15:30:00	AAPL	Stock	132.1013	132.44	131.97	132.29	5467635.0
2022-12-20 16:00:00	AAPL	Stock	132.29	132.51	132.24	132.4701	7269196.0
2022-12-20 16:30:00	AAPL	Stock	132.47	132.57	132.3	132.54	39582.0
2022-12-20 17:00:00	AAPL	Stock	132.55	132.78	132.55	132.75	27966.0
2022-12-20 17:30:00	AAPL	Stock	132.74	132.79	132.7255	132.79	18302.0
2022-12-20 18:00:00	AAPL	Stock	132.8	133.23	132.77	133.17	66351.0
2022-12-20 18:30:00	AAPL	Stock	133.17	133.25	132.9	133.0	47618.0
2022-12-20 19:00:00	AAPL	Stock	133.02	133.02	132.8601	132.95	18494.0
2022-12-20 19:30:00	AAPL	Stock	132.94	133.06	132.84	133.0	18403.0
2022-12-20 04:00:00	MSFT	Stock	240.45	240.45	239.17	239.27	4804.0
2022-12-20 04:30:00	MSFT	Stock	239.87	240.0	239.38	239.51	6325.0
2022-12-20 05:00:00	MSFT	Stock	239.68	239.68	239.68	239.68	100.0
2022-12-20 05:30:00	MSFT	Stock	239.7	239.7	239.48	239.49	400.0
2022-12-20 06:00:00	MSFT	Stock	239.74	239.9	239.74	239.78	328.0
2022-12-20 06:30:00	MSFT	Stock	239.93	240.08	239.75	239.75	701.0
2022-12-20 07:00:00	MSFT	Stock	239.93	240.02	239.65	239.75	7648.0
2022-12-20 07:30:00	MSFT	Stock	239.72	239.72	238.78	238.78	6645.0
2022-12-20 08:00:00	MSFT	Stock	239.3012	240.02	237.4	238.77	12744.0
2022-12-20 08:30:00	MSFT	Stock	238.77	239.33	238.7	239.03	7675.0
2022-12-20 09:00:00	MSFT	Stock	239.0	239.8	238.52	239.73	24340.0
2022-12-20 09:30:00	MSFT	Stock	239.26	240.85	238.42	240.6202	2333948.0
2022-12-20 10:00:00	MSFT	Stock	240.655	241.65	239.97	241.56	1377513.0
2022-12-20 10:30:00	MSFT	Stock	241.6	242.5	241.14	241.15	1223841.0
2022-12-20 11:00:00	MSFT	Stock	241.17	241.75	239.28	239.59	1161995.0
2022-12-20 11:30:00	MSFT	Stock	239.5717	241.2229	239.5	241.185	1083699.0
2022-12-20 12:00:00	MSFT	Stock	241.22	242.2125	241.14	241.7201	860154.0
2022-12-20 12:30:00	MSFT	Stock	241.75	241.95	240.9273	241.93	733803.0

> showing 50 of 103,040 rows — these rows as CSV

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