PREVIEW / stock_30min / 2023-11-01

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-11-01.parquet
  size:    2.0 MB
  rows:    96,757
  symbols: 1,334

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-11-01 04:00:00	AAPL	Stock	170.6	170.6	170.15	170.15	5748.0
2023-11-01 04:30:00	AAPL	Stock	170.29	170.38	170.1	170.17	7325.0
2023-11-01 05:00:00	AAPL	Stock	170.14	170.15	169.94	169.94	5601.0
2023-11-01 05:30:00	AAPL	Stock	170.13	170.13	169.98	170.0	703.0
2023-11-01 06:00:00	AAPL	Stock	170.1	170.1	169.85	169.85	645.0
2023-11-01 06:30:00	AAPL	Stock	170.0	170.1	170.0	170.03	2573.0
2023-11-01 07:00:00	AAPL	Stock	170.01	170.1	169.81	169.82	9922.0
2023-11-01 07:30:00	AAPL	Stock	169.9	169.9	169.5	169.5	8588.0
2023-11-01 08:00:00	AAPL	Stock	170.1	170.6	169.4504	169.89	30084.0
2023-11-01 08:30:00	AAPL	Stock	169.9	170.8082	169.9	170.6	110993.0
2023-11-01 09:00:00	AAPL	Stock	170.5	171.19	170.14	170.99	57374.0
2023-11-01 09:30:00	AAPL	Stock	171.05	171.54	170.12	171.08	4561815.0
2023-11-01 10:00:00	AAPL	Stock	171.11	171.97	170.78	171.83	3709273.0
2023-11-01 10:30:00	AAPL	Stock	171.83	172.08	171.38	171.4579	3029769.0
2023-11-01 11:00:00	AAPL	Stock	171.46	171.505	171.0	171.43	2161063.0
2023-11-01 11:30:00	AAPL	Stock	171.43	172.0	171.195	171.95	1541075.0
2023-11-01 12:00:00	AAPL	Stock	171.945	171.95	171.61	171.9	1346776.0
2023-11-01 12:30:00	AAPL	Stock	171.91	172.18	171.63	172.035	1481540.0
2023-11-01 13:00:00	AAPL	Stock	172.035	172.38	171.77	172.162	1628293.0
2023-11-01 13:30:00	AAPL	Stock	172.16	172.37	172.02	172.19	1428595.0
2023-11-01 14:00:00	AAPL	Stock	172.2	172.71	171.91	172.61	2658893.0
2023-11-01 14:30:00	AAPL	Stock	172.625	173.27	172.1	173.2	4605955.0
2023-11-01 15:00:00	AAPL	Stock	173.19	174.22	173.18	173.91	4051826.0
2023-11-01 15:30:00	AAPL	Stock	173.91	174.23	173.61	173.91	6085696.0
2023-11-01 16:00:00	AAPL	Stock	173.92	175.01	173.78	173.83	8579107.0
2023-11-01 16:30:00	AAPL	Stock	173.9	174.29	173.9	174.29	199882.0
2023-11-01 17:00:00	AAPL	Stock	174.27	174.7	174.27	174.52	35850.0
2023-11-01 17:30:00	AAPL	Stock	174.52	174.55	173.97	174.45	18389.0
2023-11-01 18:00:00	AAPL	Stock	174.4	174.6	174.36	174.45	13192.0
2023-11-01 18:30:00	AAPL	Stock	174.4498	174.75	174.4	174.71	20905.0
2023-11-01 19:00:00	AAPL	Stock	174.7	175.05	174.7	174.93	21827.0
2023-11-01 19:30:00	AAPL	Stock	174.9	174.98	174.74	174.75	20493.0
2023-11-01 04:00:00	MSFT	Stock	338.0	338.0	337.5	337.5	332.0
2023-11-01 04:30:00	MSFT	Stock	337.52	337.52	337.5	337.5	225.0
2023-11-01 05:00:00	MSFT	Stock	336.99	336.99	336.99	336.99	233.0
2023-11-01 05:30:00	MSFT	Stock	336.69	336.69	336.69	336.69	490.0
2023-11-01 06:00:00	MSFT	Stock	336.59	336.75	336.5	336.72	1165.0
2023-11-01 07:00:00	MSFT	Stock	337.25	337.25	336.85	336.85	2019.0
2023-11-01 07:30:00	MSFT	Stock	336.8	337.0	336.45	336.45	3481.0
2023-11-01 08:00:00	MSFT	Stock	336.8	338.44	336.5	337.45	17458.0
2023-11-01 08:30:00	MSFT	Stock	337.69	339.95	337.69	339.58	44699.0
2023-11-01 09:00:00	MSFT	Stock	339.31	339.88	338.64	339.7	27714.0
2023-11-01 09:30:00	MSFT	Stock	339.79	344.08	339.65	343.3905	2698234.0
2023-11-01 10:00:00	MSFT	Stock	343.4	345.97	342.68	345.47	1985415.0
2023-11-01 10:30:00	MSFT	Stock	345.48	346.51	344.896	345.72	1547460.0
2023-11-01 11:00:00	MSFT	Stock	345.71	346.22	344.65	345.055	906386.0
2023-11-01 11:30:00	MSFT	Stock	345.08	345.45	344.34	345.1	719071.0
2023-11-01 12:00:00	MSFT	Stock	345.1	345.15	344.13	344.17	580486.0
2023-11-01 12:30:00	MSFT	Stock	344.19	344.6623	343.29	343.71	512999.0
2023-11-01 13:00:00	MSFT	Stock	343.71	344.39	343.44	343.98	481000.0

> showing 50 of 96,757 rows — these rows as CSV

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