PREVIEW / stock_30min / 2022-05-05

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-05-05.parquet
  size:    2.2 MB
  rows:    107,474
  symbols: 2,415

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-05-05 04:00:00	AAPL	Stock	164.39	165.06	164.39	164.76	10310.0
2022-05-05 04:30:00	AAPL	Stock	164.75	164.75	164.08	164.48	6533.0
2022-05-05 05:00:00	AAPL	Stock	164.6	164.8	164.54	164.74	5879.0
2022-05-05 05:30:00	AAPL	Stock	164.5	164.65	164.5	164.65	1852.0
2022-05-05 06:00:00	AAPL	Stock	164.65	164.93	164.65	164.83	16320.0
2022-05-05 06:30:00	AAPL	Stock	165.0	165.0	164.7	164.7	12298.0
2022-05-05 07:00:00	AAPL	Stock	164.87	165.33	164.7	164.75	55130.0
2022-05-05 07:30:00	AAPL	Stock	164.71	165.15	164.65	164.84	23702.0
2022-05-05 08:00:00	AAPL	Stock	164.8	165.79	164.69	164.82	317905.0
2022-05-05 08:30:00	AAPL	Stock	164.82	164.95	164.3756	164.5512	140754.0
2022-05-05 09:00:00	AAPL	Stock	164.55	164.55	163.17	163.81	416925.0
2022-05-05 09:30:00	AAPL	Stock	163.83	164.08	161.24	161.64	10533307.0
2022-05-05 10:00:00	AAPL	Stock	161.64	161.78	160.01	160.17	7290449.0
2022-05-05 10:30:00	AAPL	Stock	160.16	160.36	159.2	160.19	7698686.0
2022-05-05 11:00:00	AAPL	Stock	160.19	160.35	158.835	159.32	6753867.0
2022-05-05 11:30:00	AAPL	Stock	159.3	160.1	157.71	157.73	7607374.0
2022-05-05 12:00:00	AAPL	Stock	157.73	158.52	157.27	157.8	7632578.0
2022-05-05 12:30:00	AAPL	Stock	157.78	158.14	156.57	157.53	6616452.0
2022-05-05 13:00:00	AAPL	Stock	157.54	158.32	157.164	157.5534	5287796.0
2022-05-05 13:30:00	AAPL	Stock	157.55	158.02	156.47	156.79	4778068.0
2022-05-05 14:00:00	AAPL	Stock	156.79	157.56	156.45	156.475	4727826.0
2022-05-05 14:30:00	AAPL	Stock	156.47	157.2	156.25	156.385	5089516.0
2022-05-05 15:00:00	AAPL	Stock	156.39	156.525	155.02	155.09	8121532.0
2022-05-05 15:30:00	AAPL	Stock	155.09	157.58	154.95	156.81	18385723.0
2022-05-05 16:00:00	AAPL	Stock	156.81	157.87	156.77	157.35	13513682.0
2022-05-05 16:30:00	AAPL	Stock	157.38	157.86	156.77	157.84	255770.0
2022-05-05 17:00:00	AAPL	Stock	157.84	157.9	157.57	157.57	55820.0
2022-05-05 17:30:00	AAPL	Stock	157.5936	157.74	157.4	157.51	53053.0
2022-05-05 18:00:00	AAPL	Stock	157.55	157.56	157.03	157.1	39434.0
2022-05-05 18:30:00	AAPL	Stock	157.14	157.4	157.12	157.33	37323.0
2022-05-05 19:00:00	AAPL	Stock	157.22	157.5	157.2	157.45	48691.0
2022-05-05 19:30:00	AAPL	Stock	157.45	157.96	157.45	157.96	60384.0
2022-05-05 04:00:00	MSFT	Stock	288.98	289.22	288.35	288.6	5915.0
2022-05-05 04:30:00	MSFT	Stock	287.56	287.6	286.91	287.6	1158.0
2022-05-05 05:00:00	MSFT	Stock	287.43	287.43	287.43	287.43	117.0
2022-05-05 06:00:00	MSFT	Stock	287.95	288.39	287.95	288.03	800.0
2022-05-05 06:30:00	MSFT	Stock	288.03	288.1	287.91	287.91	433.0
2022-05-05 07:00:00	MSFT	Stock	287.89	288.45	287.45	287.45	5834.0
2022-05-05 07:30:00	MSFT	Stock	287.4	287.94	287.08	287.75	6598.0
2022-05-05 08:00:00	MSFT	Stock	287.5011	288.35	287.08	287.5	15694.0
2022-05-05 08:30:00	MSFT	Stock	287.49	287.55	287.0	287.2494	7634.0
2022-05-05 09:00:00	MSFT	Stock	287.15	287.15	285.1	285.78	84497.0
2022-05-05 09:30:00	MSFT	Stock	285.78	286.35	282.16	282.42	2469250.0
2022-05-05 10:00:00	MSFT	Stock	282.42	282.5	278.09	278.315	2663103.0
2022-05-05 10:30:00	MSFT	Stock	278.3	278.58	275.8601	277.62	2326812.0
2022-05-05 11:00:00	MSFT	Stock	277.6	277.89	275.53	277.035	1430425.0
2022-05-05 11:30:00	MSFT	Stock	277.01	278.72	276.2	276.2	1547038.0
2022-05-05 12:00:00	MSFT	Stock	276.22	278.3515	275.27	277.68	1537467.0
2022-05-05 12:30:00	MSFT	Stock	277.66	277.8403	275.68	276.92	1324277.0
2022-05-05 13:00:00	MSFT	Stock	276.92	278.23	276.1	276.8075	1383204.0

> showing 50 of 107,474 rows — these rows as CSV

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