PREVIEW / stock_30min / 2023-04-11

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-04-11.parquet
  size:    2.1 MB
  rows:    100,651
  symbols: 1,754

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-11 04:00:00	AAPL	Stock	162.02	162.65	162.02	162.39	7732.0
2023-04-11 04:30:00	AAPL	Stock	162.28	162.34	162.2	162.33	8211.0
2023-04-11 05:00:00	AAPL	Stock	162.4	162.4	162.2	162.27	1110.0
2023-04-11 05:30:00	AAPL	Stock	162.3	162.52	162.3	162.52	3173.0
2023-04-11 06:00:00	AAPL	Stock	162.71	162.74	162.55	162.55	8607.0
2023-04-11 06:30:00	AAPL	Stock	162.38	162.39	162.18	162.22	6490.0
2023-04-11 07:00:00	AAPL	Stock	162.21	162.35	161.89	161.9	24976.0
2023-04-11 07:30:00	AAPL	Stock	161.88	161.99	161.8	161.9	15727.0
2023-04-11 08:00:00	AAPL	Stock	162.1	162.36	161.57	161.89	71663.0
2023-04-11 08:30:00	AAPL	Stock	161.8	162.0	161.76	161.8	53351.0
2023-04-11 09:00:00	AAPL	Stock	161.8	162.35	161.72	162.35	106543.0
2023-04-11 09:30:00	AAPL	Stock	162.35	162.36	161.08	161.23	5401751.0
2023-04-11 10:00:00	AAPL	Stock	161.225	161.38	160.56	161.15	3879296.0
2023-04-11 10:30:00	AAPL	Stock	161.16	161.2	160.59	160.73	2934408.0
2023-04-11 11:00:00	AAPL	Stock	160.735	161.12	160.62	160.9099	2100616.0
2023-04-11 11:30:00	AAPL	Stock	160.9	161.0	160.51	160.975	1853492.0
2023-04-11 12:00:00	AAPL	Stock	160.979	161.2301	160.893	161.1199	1817095.0
2023-04-11 12:30:00	AAPL	Stock	161.12	161.52	160.84	161.3768	2078947.0
2023-04-11 13:00:00	AAPL	Stock	161.38	161.48	161.07	161.4117	1521329.0
2023-04-11 13:30:00	AAPL	Stock	161.4156	161.81	161.31	161.78	1634839.0
2023-04-11 14:00:00	AAPL	Stock	161.785	161.83	161.5	161.7107	1756232.0
2023-04-11 14:30:00	AAPL	Stock	161.71	161.81	161.49	161.585	1359177.0
2023-04-11 15:00:00	AAPL	Stock	161.595	161.6199	161.2783	161.33	1766807.0
2023-04-11 15:30:00	AAPL	Stock	161.33	161.385	160.55	160.8	5409134.0
2023-04-11 16:00:00	AAPL	Stock	160.8	160.88	160.71	160.83	5485204.0
2023-04-11 16:30:00	AAPL	Stock	160.83	160.87	160.8	160.8	30809.0
2023-04-11 17:00:00	AAPL	Stock	160.81	160.827	160.72	160.72	74075.0
2023-04-11 17:30:00	AAPL	Stock	160.75	160.75	160.65	160.7	7543.0
2023-04-11 18:00:00	AAPL	Stock	160.75	160.86	160.72	160.75	6937.0
2023-04-11 18:30:00	AAPL	Stock	160.78	160.88	160.76	160.8558	4757.0
2023-04-11 19:00:00	AAPL	Stock	160.86	160.88	160.78	160.88	5684.0
2023-04-11 19:30:00	AAPL	Stock	160.9	161.0	160.84	161.0	13852.0
2023-04-11 04:00:00	MSFT	Stock	288.92	289.23	288.46	289.05	6333.0
2023-04-11 04:30:00	MSFT	Stock	289.08	289.12	288.84	289.0	2479.0
2023-04-11 05:00:00	MSFT	Stock	289.2	289.2	288.2	288.2	9196.0
2023-04-11 05:30:00	MSFT	Stock	288.4	288.5	287.8	288.0	13004.0
2023-04-11 06:00:00	MSFT	Stock	288.0	288.25	287.8	287.8	3340.0
2023-04-11 06:30:00	MSFT	Stock	287.94	287.94	285.9	286.5	17368.0
2023-04-11 07:00:00	MSFT	Stock	286.7	286.8	283.85	284.2	60817.0
2023-04-11 07:30:00	MSFT	Stock	284.47	284.94	283.94	284.67	12819.0
2023-04-11 08:00:00	MSFT	Stock	284.55	289.63	283.98	284.6	69784.0
2023-04-11 08:30:00	MSFT	Stock	284.6	285.17	284.08	284.2	56409.0
2023-04-11 09:00:00	MSFT	Stock	284.19	285.96	284.19	285.75	98783.0
2023-04-11 09:30:00	MSFT	Stock	285.72	285.98	282.94	283.985	3902535.0
2023-04-11 10:00:00	MSFT	Stock	283.96	284.1	282.7	283.1	1681063.0
2023-04-11 10:30:00	MSFT	Stock	283.1	283.39	282.43	282.761	1409762.0
2023-04-11 11:00:00	MSFT	Stock	282.76	283.11	282.01	282.63	1518331.0
2023-04-11 11:30:00	MSFT	Stock	282.62	282.81	281.64	282.79	1363906.0
2023-04-11 12:00:00	MSFT	Stock	282.78	283.6684	282.78	283.09	1197446.0
2023-04-11 12:30:00	MSFT	Stock	283.1	283.84	282.84	283.635	838252.0

> showing 50 of 100,651 rows — these rows as CSV

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