PREVIEW / stock_30min / 2022-12-07

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-12-07.parquet
  size:    2.1 MB
  rows:    101,466
  symbols: 2,027

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-07 04:00:00	AAPL	Stock	142.41	142.59	141.61	141.76	26070.0
2022-12-07 04:30:00	AAPL	Stock	141.74	141.88	141.5	141.74	14871.0
2022-12-07 05:00:00	AAPL	Stock	141.74	142.0	141.61	141.61	13682.0
2022-12-07 05:30:00	AAPL	Stock	141.67	141.95	141.67	141.95	9307.0
2022-12-07 06:00:00	AAPL	Stock	141.97	142.11	141.81	141.81	14204.0
2022-12-07 06:30:00	AAPL	Stock	141.75	142.09	141.11	141.35	62256.0
2022-12-07 07:00:00	AAPL	Stock	141.45	141.5	140.72	140.8	102943.0
2022-12-07 07:30:00	AAPL	Stock	140.8	140.82	140.5	140.58	56379.0
2022-12-07 08:00:00	AAPL	Stock	141.354	142.96	140.47	141.5	209631.0
2022-12-07 08:30:00	AAPL	Stock	141.54	141.8	141.32	141.51	148495.0
2022-12-07 09:00:00	AAPL	Stock	141.6	142.43	141.21	142.33	192735.0
2022-12-07 09:30:00	AAPL	Stock	142.19	143.37	140.64	140.8599	8918866.0
2022-12-07 10:00:00	AAPL	Stock	140.86	142.04	140.58	141.89	6062050.0
2022-12-07 10:30:00	AAPL	Stock	141.89	142.23	140.88	141.8801	4536509.0
2022-12-07 11:00:00	AAPL	Stock	141.88	142.16	140.62	140.67	3472879.0
2022-12-07 11:30:00	AAPL	Stock	140.675	141.15	140.6	141.08	2823169.0
2022-12-07 12:00:00	AAPL	Stock	141.08	141.3589	140.71	140.8061	2665492.0
2022-12-07 12:30:00	AAPL	Stock	140.8	141.31	140.69	140.89	2221533.0
2022-12-07 13:00:00	AAPL	Stock	140.89	141.43	140.72	141.359	2404011.0
2022-12-07 13:30:00	AAPL	Stock	141.35	141.4	140.79	140.865	1915109.0
2022-12-07 14:00:00	AAPL	Stock	140.86	141.29	140.63	141.15	2491078.0
2022-12-07 14:30:00	AAPL	Stock	141.145	141.45	140.695	140.745	2383451.0
2022-12-07 15:00:00	AAPL	Stock	140.75	140.9	140.0	140.1952	4954939.0
2022-12-07 15:30:00	AAPL	Stock	140.19	141.15	140.18	140.94	6271036.0
2022-12-07 16:00:00	AAPL	Stock	140.93	141.06	140.92	141.01	9333192.0
2022-12-07 16:30:00	AAPL	Stock	141.01	141.03	140.91	140.95	77486.0
2022-12-07 17:00:00	AAPL	Stock	140.97	141.03	140.94	140.9696	20778.0
2022-12-07 17:30:00	AAPL	Stock	140.96	141.05	140.95	141.02	20910.0
2022-12-07 18:00:00	AAPL	Stock	141.02	141.03	140.95	140.96	6116.0
2022-12-07 18:30:00	AAPL	Stock	141.0	141.0	140.95	140.99	5873.0
2022-12-07 19:00:00	AAPL	Stock	140.98	140.98	140.75	140.75	7920.0
2022-12-07 19:30:00	AAPL	Stock	140.75	140.89	140.68	140.7	15151.0
2022-12-07 04:00:00	MSFT	Stock	245.44	245.44	244.65	244.65	1158.0
2022-12-07 04:30:00	MSFT	Stock	244.5	244.5	243.9	243.9	440.0
2022-12-07 05:00:00	MSFT	Stock	244.3	244.3	244.3	244.3	2377.0
2022-12-07 05:30:00	MSFT	Stock	244.11	244.2	243.82	243.9	4108.0
2022-12-07 06:00:00	MSFT	Stock	244.2	244.2	243.96	243.99	2880.0
2022-12-07 06:30:00	MSFT	Stock	244.02	244.11	243.21	243.27	5915.0
2022-12-07 07:00:00	MSFT	Stock	243.69	243.69	242.24	242.25	5272.0
2022-12-07 07:30:00	MSFT	Stock	242.13	242.75	242.05	242.67	5119.0
2022-12-07 08:00:00	MSFT	Stock	243.51	244.508	242.0102	243.0	13140.0
2022-12-07 08:30:00	MSFT	Stock	242.99	244.0	242.99	244.0	9334.0
2022-12-07 09:00:00	MSFT	Stock	243.76	245.0	242.91	244.99	24156.0
2022-12-07 09:30:00	MSFT	Stock	244.69	245.64	242.69	242.94	1632928.0
2022-12-07 10:00:00	MSFT	Stock	242.93	244.61	242.205	244.58	1129932.0
2022-12-07 10:30:00	MSFT	Stock	244.58	245.89	243.38	245.64	943236.0
2022-12-07 11:00:00	MSFT	Stock	245.65	246.16	243.45	243.6	899457.0
2022-12-07 11:30:00	MSFT	Stock	243.58	244.38	243.29	244.11	530149.0
2022-12-07 12:00:00	MSFT	Stock	244.13	244.575	243.56	244.06	541915.0
2022-12-07 12:30:00	MSFT	Stock	244.08	245.12	243.8	245.02	737924.0

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

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