PREVIEW / stock_30min / 2023-04-20

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-04-20.parquet
  size:    2.0 MB
  rows:    99,136
  symbols: 1,691

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
2023-04-20 04:00:00	AAPL	Stock	167.0	167.0	166.1	166.32	14611.0
2023-04-20 04:30:00	AAPL	Stock	166.35	166.35	165.86	166.11	16143.0
2023-04-20 05:00:00	AAPL	Stock	166.1	166.1	165.89	165.89	14796.0
2023-04-20 05:30:00	AAPL	Stock	165.89	165.97	165.7	165.72	14438.0
2023-04-20 06:00:00	AAPL	Stock	165.72	165.91	165.7	165.91	8410.0
2023-04-20 06:30:00	AAPL	Stock	165.85	166.1	165.85	166.0	6046.0
2023-04-20 07:00:00	AAPL	Stock	166.15	166.25	165.88	166.16	73279.0
2023-04-20 07:30:00	AAPL	Stock	166.14	166.28	165.93	166.0	32244.0
2023-04-20 08:00:00	AAPL	Stock	166.11	167.211	165.5622	165.98	152609.0
2023-04-20 08:30:00	AAPL	Stock	166.11	166.19	165.85	166.01	101427.0
2023-04-20 09:00:00	AAPL	Stock	166.01	166.15	165.7	166.0	146160.0
2023-04-20 09:30:00	AAPL	Stock	166.09	167.33	165.89	166.815	6036490.0
2023-04-20 10:00:00	AAPL	Stock	166.81	167.4	166.68	167.04	3450117.0
2023-04-20 10:30:00	AAPL	Stock	167.04	167.27	166.66	166.86	2370478.0
2023-04-20 11:00:00	AAPL	Stock	166.87	167.17	166.51	167.14	2227272.0
2023-04-20 11:30:00	AAPL	Stock	167.1424	167.54	166.9	167.28	2290308.0
2023-04-20 12:00:00	AAPL	Stock	167.28	167.49	166.96	167.41	1738709.0
2023-04-20 12:30:00	AAPL	Stock	167.41	167.87	167.38	167.7	1973869.0
2023-04-20 13:00:00	AAPL	Stock	167.695	167.86	167.56	167.6009	1628953.0
2023-04-20 13:30:00	AAPL	Stock	167.61	167.75	167.44	167.47	1415499.0
2023-04-20 14:00:00	AAPL	Stock	167.47	167.5	166.83	166.87	2136382.0
2023-04-20 14:30:00	AAPL	Stock	166.86	166.89	166.2301	166.56	2786441.0
2023-04-20 15:00:00	AAPL	Stock	166.56	166.64	165.56	165.62	3275819.0
2023-04-20 15:30:00	AAPL	Stock	165.625	166.67	165.625	166.65	5066505.0
2023-04-20 16:00:00	AAPL	Stock	166.65	166.78	166.55	166.73	6316496.0
2023-04-20 16:30:00	AAPL	Stock	166.73	166.76	166.58	166.63	57947.0
2023-04-20 17:00:00	AAPL	Stock	166.611	166.65	166.61	166.63	41047.0
2023-04-20 17:30:00	AAPL	Stock	166.62	166.69	166.62	166.66	2402.0
2023-04-20 18:00:00	AAPL	Stock	166.66	166.74	166.61	166.67	34140.0
2023-04-20 18:30:00	AAPL	Stock	166.7	166.77	166.7	166.72	28477.0
2023-04-20 19:00:00	AAPL	Stock	166.74	166.86	166.72	166.86	18815.0
2023-04-20 19:30:00	AAPL	Stock	166.86	166.98	166.7	166.98	26545.0
2023-04-20 04:00:00	MSFT	Stock	286.15	286.15	285.54	285.73	2823.0
2023-04-20 04:30:00	MSFT	Stock	285.6	285.6	284.57	285.01	3258.0
2023-04-20 05:00:00	MSFT	Stock	285.03	285.1	284.76	285.01	1313.0
2023-04-20 05:30:00	MSFT	Stock	285.65	285.65	285.5	285.65	544.0
2023-04-20 06:00:00	MSFT	Stock	285.65	285.65	285.34	285.34	204.0
2023-04-20 06:30:00	MSFT	Stock	285.43	285.7	285.43	285.7	619.0
2023-04-20 07:00:00	MSFT	Stock	286.2	286.39	286.0	286.35	5226.0
2023-04-20 07:30:00	MSFT	Stock	286.13	286.13	285.65	285.65	5722.0
2023-04-20 08:00:00	MSFT	Stock	288.2	288.2	285.09	285.85	34864.0
2023-04-20 08:30:00	MSFT	Stock	286.09	287.0	285.6	286.75	14176.0
2023-04-20 09:00:00	MSFT	Stock	286.55	286.6962	285.1	285.25	50660.0
2023-04-20 09:30:00	MSFT	Stock	285.25	287.24	285.15	287.005	2175684.0
2023-04-20 10:00:00	MSFT	Stock	286.99	287.71	286.3	287.16	1307911.0
2023-04-20 10:30:00	MSFT	Stock	287.18	287.6599	286.68	286.74	755817.0
2023-04-20 11:00:00	MSFT	Stock	286.76	287.4599	286.27	287.09	856246.0
2023-04-20 11:30:00	MSFT	Stock	287.07	287.5	286.89	287.29	585373.0
2023-04-20 12:00:00	MSFT	Stock	287.29	287.82	286.62	287.75	693342.0
2023-04-20 12:30:00	MSFT	Stock	287.745	288.4271	287.58	288.4143	719377.0

> showing 50 of 99,136 rows — these rows as CSV

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