PREVIEW / stock_30min / 2023-04-18

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-04-18.parquet
  size:    2.1 MB
  rows:    101,334
  symbols: 1,716

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-18 04:00:00	AAPL	Stock	165.25	165.62	165.25	165.5	5084.0
2023-04-18 04:30:00	AAPL	Stock	165.51	165.85	165.45	165.76	4606.0
2023-04-18 05:00:00	AAPL	Stock	165.71	166.15	165.66	165.97	7078.0
2023-04-18 05:30:00	AAPL	Stock	166.0	166.27	166.0	166.2	4299.0
2023-04-18 06:00:00	AAPL	Stock	166.1	166.21	166.07	166.2	5938.0
2023-04-18 06:30:00	AAPL	Stock	166.23	166.38	166.06	166.06	19214.0
2023-04-18 07:00:00	AAPL	Stock	166.05	166.38	166.0	166.38	33121.0
2023-04-18 07:30:00	AAPL	Stock	166.39	166.59	166.35	166.37	35640.0
2023-04-18 08:00:00	AAPL	Stock	166.06	166.58	164.63	166.55	132727.0
2023-04-18 08:30:00	AAPL	Stock	166.55	166.7	166.37	166.37	60278.0
2023-04-18 09:00:00	AAPL	Stock	166.36	166.44	165.75	166.04	145762.0
2023-04-18 09:30:00	AAPL	Stock	166.07	167.41	165.84	166.95	7467716.0
2023-04-18 10:00:00	AAPL	Stock	166.94	166.95	165.98	166.23	4105850.0
2023-04-18 10:30:00	AAPL	Stock	166.225	166.27	165.79	165.93	2577697.0
2023-04-18 11:00:00	AAPL	Stock	165.94	166.26	165.87	166.07	2098927.0
2023-04-18 11:30:00	AAPL	Stock	166.08	166.225	165.65	165.71	2055742.0
2023-04-18 12:00:00	AAPL	Stock	165.71	166.2	165.68	166.195	1652059.0
2023-04-18 12:30:00	AAPL	Stock	166.2	166.32	165.68	165.7683	1694332.0
2023-04-18 13:00:00	AAPL	Stock	165.765	166.0372	165.7	165.925	1257973.0
2023-04-18 13:30:00	AAPL	Stock	165.92	166.48	165.86	166.29	1691852.0
2023-04-18 14:00:00	AAPL	Stock	166.2877	166.74	166.05	166.64	2009422.0
2023-04-18 14:30:00	AAPL	Stock	166.64	166.74	166.0	166.3025	1918014.0
2023-04-18 15:00:00	AAPL	Stock	166.31	166.66	166.3092	166.38	1827288.0
2023-04-18 15:30:00	AAPL	Stock	166.37	166.6901	166.05	166.46	4026885.0
2023-04-18 16:00:00	AAPL	Stock	166.45	166.53	166.02	166.37	6823966.0
2023-04-18 16:30:00	AAPL	Stock	166.4	166.49	166.27	166.42	52281.0
2023-04-18 17:00:00	AAPL	Stock	166.46	166.46	166.39	166.45	5300.0
2023-04-18 17:30:00	AAPL	Stock	166.45	166.46	166.35	166.37	15637.0
2023-04-18 18:00:00	AAPL	Stock	166.38	166.38	166.31	166.3456	11355.0
2023-04-18 18:30:00	AAPL	Stock	166.34	166.4	166.34	166.3508	6945.0
2023-04-18 19:00:00	AAPL	Stock	166.37	166.38	166.31	166.33	7395.0
2023-04-18 19:30:00	AAPL	Stock	166.36	166.46	166.33	166.46	12296.0
2023-04-18 04:00:00	MSFT	Stock	288.95	290.69	288.95	290.69	2866.0
2023-04-18 04:30:00	MSFT	Stock	290.29	290.46	290.17	290.45	1567.0
2023-04-18 05:00:00	MSFT	Stock	290.31	290.95	290.1	290.8	3811.0
2023-04-18 05:30:00	MSFT	Stock	290.79	291.38	290.79	290.95	3978.0
2023-04-18 06:00:00	MSFT	Stock	290.9	291.08	290.41	290.41	2884.0
2023-04-18 06:30:00	MSFT	Stock	290.65	290.93	290.4	290.4	3167.0
2023-04-18 07:00:00	MSFT	Stock	290.61	290.64	290.02	290.3	12014.0
2023-04-18 07:30:00	MSFT	Stock	290.43	290.85	290.38	290.38	11278.0
2023-04-18 08:00:00	MSFT	Stock	290.46	290.7485	288.75	290.7485	27946.0
2023-04-18 08:30:00	MSFT	Stock	290.42	290.93	290.42	290.8152	12152.0
2023-04-18 09:00:00	MSFT	Stock	290.86	292.8	290.6	291.54	136722.0
2023-04-18 09:30:00	MSFT	Stock	291.61	291.78	289.21	289.82	2494176.0
2023-04-18 10:00:00	MSFT	Stock	289.81	289.9	287.09	287.42	1449970.0
2023-04-18 10:30:00	MSFT	Stock	287.43	287.9768	287.01	287.7	993681.0
2023-04-18 11:00:00	MSFT	Stock	287.68	288.08	287.42	287.8677	733675.0
2023-04-18 11:30:00	MSFT	Stock	287.89	288.25	287.18	287.35	696476.0
2023-04-18 12:00:00	MSFT	Stock	287.33	288.03	287.25	287.77	653798.0
2023-04-18 12:30:00	MSFT	Stock	287.8	287.91	287.22	287.73	498196.0

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

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