PREVIEW / stock_30min / 2022-03-24

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-03-24.parquet
  size:    2.2 MB
  rows:    108,688
  symbols: 2,478

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-03-24 04:00:00	AAPL	Stock	170.63	171.4	170.63	171.4	16232.0
2022-03-24 04:30:00	AAPL	Stock	171.53	171.86	171.2	171.45	27175.0
2022-03-24 05:00:00	AAPL	Stock	171.45	171.8	171.45	171.5	9924.0
2022-03-24 05:30:00	AAPL	Stock	171.49	171.65	171.43	171.43	6817.0
2022-03-24 06:00:00	AAPL	Stock	171.31	171.35	171.0	171.0	9751.0
2022-03-24 06:30:00	AAPL	Stock	171.0	171.05	171.0	171.02	2083.0
2022-03-24 07:00:00	AAPL	Stock	170.95	171.62	170.95	171.55	53278.0
2022-03-24 07:30:00	AAPL	Stock	171.55	171.68	170.91	171.18	77038.0
2022-03-24 08:00:00	AAPL	Stock	171.6	171.69	170.635	171.17	308682.0
2022-03-24 08:30:00	AAPL	Stock	171.2	171.45	170.92	171.27	197133.0
2022-03-24 09:00:00	AAPL	Stock	171.28	171.5	171.04	171.2	273475.0
2022-03-24 09:30:00	AAPL	Stock	171.2	172.35	170.72	170.9	9729662.0
2022-03-24 10:00:00	AAPL	Stock	170.8901	171.61	170.33	170.47	5981542.0
2022-03-24 10:30:00	AAPL	Stock	170.44	171.54	170.21	170.76	3988218.0
2022-03-24 11:00:00	AAPL	Stock	170.75	172.03	170.5999	172.0199	4246507.0
2022-03-24 11:30:00	AAPL	Stock	172.015	172.27	171.77	171.8811	3786095.0
2022-03-24 12:00:00	AAPL	Stock	171.88	171.91	171.045	171.17	2694671.0
2022-03-24 12:30:00	AAPL	Stock	171.15	171.475	171.02	171.35	2302393.0
2022-03-24 13:00:00	AAPL	Stock	171.345	172.87	171.28	171.925	8157889.0
2022-03-24 13:30:00	AAPL	Stock	171.915	172.28	171.8	172.1557	2841326.0
2022-03-24 14:00:00	AAPL	Stock	172.16	172.52	171.8	172.189	3636007.0
2022-03-24 14:30:00	AAPL	Stock	172.1855	172.64	172.03	172.57	3913268.0
2022-03-24 15:00:00	AAPL	Stock	172.565	173.42	172.39	173.2395	6321212.0
2022-03-24 15:30:00	AAPL	Stock	173.24	174.14	172.875	174.1	11081759.0
2022-03-24 16:00:00	AAPL	Stock	174.09	174.2	173.91	173.97	8406680.0
2022-03-24 16:30:00	AAPL	Stock	173.97	174.07	173.92	173.9625	132341.0
2022-03-24 17:00:00	AAPL	Stock	173.9761	174.0	173.8	173.98	40895.0
2022-03-24 17:30:00	AAPL	Stock	173.98	173.98	173.7409	173.82	29374.0
2022-03-24 18:00:00	AAPL	Stock	173.8433	173.92	173.7	173.84	23720.0
2022-03-24 18:30:00	AAPL	Stock	173.81	173.81	173.5	173.5	25268.0
2022-03-24 19:00:00	AAPL	Stock	173.48	173.61	173.35	173.53	28583.0
2022-03-24 19:30:00	AAPL	Stock	173.57	173.85	173.5	173.83	27236.0
2022-03-24 04:00:00	MSFT	Stock	299.99	301.23	299.99	301.2	1146.0
2022-03-24 04:30:00	MSFT	Stock	301.57	302.0	301.57	302.0	3911.0
2022-03-24 05:00:00	MSFT	Stock	301.72	301.72	301.65	301.65	1036.0
2022-03-24 05:30:00	MSFT	Stock	301.6	301.69	301.48	301.48	1382.0
2022-03-24 06:00:00	MSFT	Stock	301.25	301.25	301.25	301.25	110.0
2022-03-24 06:30:00	MSFT	Stock	300.94	300.94	300.94	300.94	100.0
2022-03-24 07:00:00	MSFT	Stock	300.9	301.61	300.83	301.24	11714.0
2022-03-24 07:30:00	MSFT	Stock	301.25	301.4	300.51	300.8	6176.0
2022-03-24 08:00:00	MSFT	Stock	300.9	301.58	300.0	300.44	24357.0
2022-03-24 08:30:00	MSFT	Stock	300.6	301.0	299.49	300.95	9408.0
2022-03-24 09:00:00	MSFT	Stock	300.79	301.2	299.27	299.8	44841.0
2022-03-24 09:30:00	MSFT	Stock	299.71	300.41	298.315	299.226	2056408.0
2022-03-24 10:00:00	MSFT	Stock	299.34	300.49	298.5405	298.77	1037107.0
2022-03-24 10:30:00	MSFT	Stock	298.78	300.09	298.35	299.3877	733599.0
2022-03-24 11:00:00	MSFT	Stock	299.39	301.25	299.07	301.081	888871.0
2022-03-24 11:30:00	MSFT	Stock	301.08	301.72	301.03	301.1943	745885.0
2022-03-24 12:00:00	MSFT	Stock	301.18	301.74	300.6	300.87	672613.0
2022-03-24 12:30:00	MSFT	Stock	300.85	301.02	300.2715	300.71	461282.0

> showing 50 of 108,688 rows — these rows as CSV

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