PREVIEW / stock_30min / 2022-11-07

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-11-07.parquet
  size:    2.1 MB
  rows:    103,835
  symbols: 2,122

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-11-07 04:00:00	AAPL	Stock	138.0	138.23	135.0	136.93	74892.0
2022-11-07 04:30:00	AAPL	Stock	136.98	136.98	136.69	136.8	12026.0
2022-11-07 05:00:00	AAPL	Stock	136.79	137.15	136.76	137.03	22451.0
2022-11-07 05:30:00	AAPL	Stock	137.01	137.12	136.71	136.89	28696.0
2022-11-07 06:00:00	AAPL	Stock	136.93	137.25	136.6	136.93	25598.0
2022-11-07 06:30:00	AAPL	Stock	136.83	137.08	136.21	136.3	64340.0
2022-11-07 07:00:00	AAPL	Stock	136.39	136.47	135.45	135.47	276577.0
2022-11-07 07:30:00	AAPL	Stock	135.47	136.16	135.47	136.14	138447.0
2022-11-07 08:00:00	AAPL	Stock	136.3102	138.65	135.4515	136.55	766461.0
2022-11-07 08:30:00	AAPL	Stock	136.56	136.99	136.1	136.4	356960.0
2022-11-07 09:00:00	AAPL	Stock	136.42	137.31	136.25	137.11	438431.0
2022-11-07 09:30:00	AAPL	Stock	137.11	138.22	135.671	136.2793	11404455.0
2022-11-07 10:00:00	AAPL	Stock	136.28	137.58	136.072	136.69	6590192.0
2022-11-07 10:30:00	AAPL	Stock	136.7	137.05	136.22	136.985	4655401.0
2022-11-07 11:00:00	AAPL	Stock	137.0	137.7918	136.58	137.6365	5455592.0
2022-11-07 11:30:00	AAPL	Stock	137.63	137.82	136.38	136.42	4168030.0
2022-11-07 12:00:00	AAPL	Stock	136.4221	137.35	136.25	137.3208	3360195.0
2022-11-07 12:30:00	AAPL	Stock	137.325	137.62	137.02	137.3092	2837447.0
2022-11-07 13:00:00	AAPL	Stock	137.305	137.65	136.93	137.1	2956586.0
2022-11-07 13:30:00	AAPL	Stock	137.0999	137.38	136.84	137.3509	2695483.0
2022-11-07 14:00:00	AAPL	Stock	137.35	138.31	137.35	138.26	3613465.0
2022-11-07 14:30:00	AAPL	Stock	138.255	138.84	138.08	138.1601	4400651.0
2022-11-07 15:00:00	AAPL	Stock	138.17	138.88	137.71	138.765	4575376.0
2022-11-07 15:30:00	AAPL	Stock	138.768	139.145	138.61	138.96	6393827.0
2022-11-07 16:00:00	AAPL	Stock	138.92	139.14	138.92	139.12	7150988.0
2022-11-07 16:30:00	AAPL	Stock	139.12	139.14	138.76	138.92	73977.0
2022-11-07 17:00:00	AAPL	Stock	138.95	139.0	138.84	138.95	41459.0
2022-11-07 17:30:00	AAPL	Stock	138.9203	138.9621	138.86	138.8601	12677.0
2022-11-07 18:00:00	AAPL	Stock	138.89	138.98	138.88	138.98	17056.0
2022-11-07 18:30:00	AAPL	Stock	138.96	139.05	138.94	139.04	25117.0
2022-11-07 19:00:00	AAPL	Stock	139.05	139.17	139.02	139.17	25687.0
2022-11-07 19:30:00	AAPL	Stock	139.17	139.56	139.17	139.54	40796.0
2022-11-07 04:00:00	MSFT	Stock	221.85	222.0	221.5	221.81	1418.0
2022-11-07 04:30:00	MSFT	Stock	221.9	221.9	221.36	221.38	2052.0
2022-11-07 05:00:00	MSFT	Stock	221.75	222.18	221.75	222.02	3462.0
2022-11-07 05:30:00	MSFT	Stock	221.71	222.38	221.68	222.38	783.0
2022-11-07 06:00:00	MSFT	Stock	222.45	222.97	222.25	222.95	3661.0
2022-11-07 06:30:00	MSFT	Stock	222.93	223.46	222.01	222.03	7771.0
2022-11-07 07:00:00	MSFT	Stock	222.35	223.1	221.78	222.5	18105.0
2022-11-07 07:30:00	MSFT	Stock	222.68	222.89	222.36	222.36	9342.0
2022-11-07 08:00:00	MSFT	Stock	222.8164	223.1	221.2503	221.45	32115.0
2022-11-07 08:30:00	MSFT	Stock	221.59	221.78	221.13	221.5	22209.0
2022-11-07 09:00:00	MSFT	Stock	221.42	221.99	221.07	221.89	36240.0
2022-11-07 09:30:00	MSFT	Stock	221.89	224.2	221.28	223.95	2478950.0
2022-11-07 10:00:00	MSFT	Stock	224.0	225.87	223.95	224.89	1868907.0
2022-11-07 10:30:00	MSFT	Stock	224.91	226.45	224.58	226.4207	1517074.0
2022-11-07 11:00:00	MSFT	Stock	226.45	226.55	224.78	225.33	1233406.0
2022-11-07 11:30:00	MSFT	Stock	225.3411	225.57	223.38	223.3898	971160.0
2022-11-07 12:00:00	MSFT	Stock	223.39	223.6699	222.8901	223.435	939142.0
2022-11-07 12:30:00	MSFT	Stock	223.44	224.357	223.32	224.357	806412.0

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

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