PREVIEW / stock_30min / 2023-04-03

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-04-03.parquet
  size:    2.1 MB
  rows:    103,413
  symbols: 1,756

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-04-03 04:00:00	AAPL	Stock	164.47	164.47	163.81	163.81	20835.0
2023-04-03 04:30:00	AAPL	Stock	163.85	163.89	163.73	163.75	6745.0
2023-04-03 05:00:00	AAPL	Stock	163.79	163.98	163.79	163.88	8343.0
2023-04-03 05:30:00	AAPL	Stock	163.85	163.9	163.85	163.9	214.0
2023-04-03 06:00:00	AAPL	Stock	163.96	164.01	163.91	163.98	3798.0
2023-04-03 06:30:00	AAPL	Stock	163.91	164.04	163.87	163.95	14490.0
2023-04-03 07:00:00	AAPL	Stock	163.94	164.35	163.94	164.18	32716.0
2023-04-03 07:30:00	AAPL	Stock	164.19	164.23	163.95	164.09	21449.0
2023-04-03 08:00:00	AAPL	Stock	164.0691	164.488	163.35	163.97	155321.0
2023-04-03 08:30:00	AAPL	Stock	163.95	164.2	163.75	164.14	99624.0
2023-04-03 09:00:00	AAPL	Stock	164.14	164.39	163.88	164.28	102562.0
2023-04-03 09:30:00	AAPL	Stock	164.27	165.89	164.21	165.315	7346582.0
2023-04-03 10:00:00	AAPL	Stock	165.315	165.725	165.17	165.36	3632128.0
2023-04-03 10:30:00	AAPL	Stock	165.36	165.63	164.67	164.8	3225419.0
2023-04-03 11:00:00	AAPL	Stock	164.81	164.97	164.32	164.63	2419552.0
2023-04-03 11:30:00	AAPL	Stock	164.64	164.78	164.39	164.53	1562724.0
2023-04-03 12:00:00	AAPL	Stock	164.53	164.789	164.41	164.6	1586057.0
2023-04-03 12:30:00	AAPL	Stock	164.6	164.8	164.48	164.555	1568292.0
2023-04-03 13:00:00	AAPL	Stock	164.55	164.685	164.31	164.55	1701899.0
2023-04-03 13:30:00	AAPL	Stock	164.545	164.8	164.48	164.71	1553536.0
2023-04-03 14:00:00	AAPL	Stock	164.705	164.95	164.48	164.9135	1606762.0
2023-04-03 14:30:00	AAPL	Stock	164.91	165.75	164.9	165.7429	3102898.0
2023-04-03 15:00:00	AAPL	Stock	165.75	165.88	165.62	165.695	3012657.0
2023-04-03 15:30:00	AAPL	Stock	165.69	166.29	165.675	166.1	5842923.0
2023-04-03 16:00:00	AAPL	Stock	166.17	166.31	166.06	166.09	5954420.0
2023-04-03 16:30:00	AAPL	Stock	166.08	166.17	166.01	166.05	41484.0
2023-04-03 17:00:00	AAPL	Stock	166.05	166.17	165.96	165.96	66734.0
2023-04-03 17:30:00	AAPL	Stock	165.96	166.06	165.96	165.99	8963.0
2023-04-03 18:00:00	AAPL	Stock	165.97	166.05	165.97	165.99	5167.0
2023-04-03 18:30:00	AAPL	Stock	165.97	165.99	165.97	165.98	3968.0
2023-04-03 19:00:00	AAPL	Stock	165.98	166.02	165.97	165.99	10510.0
2023-04-03 19:30:00	AAPL	Stock	165.98	166.02	165.95	166.02	14795.0
2023-04-03 04:00:00	MSFT	Stock	287.48	287.48	283.88	285.8	12091.0
2023-04-03 04:30:00	MSFT	Stock	285.66	286.0	285.5	285.64	6603.0
2023-04-03 05:00:00	MSFT	Stock	285.78	286.16	285.78	286.16	2867.0
2023-04-03 05:30:00	MSFT	Stock	285.93	285.93	285.92	285.92	224.0
2023-04-03 06:00:00	MSFT	Stock	285.99	286.3	285.99	286.1	1341.0
2023-04-03 06:30:00	MSFT	Stock	286.3	286.5	286.11	286.2	6041.0
2023-04-03 07:00:00	MSFT	Stock	286.34	286.66	286.14	286.14	10639.0
2023-04-03 07:30:00	MSFT	Stock	286.1	286.2	285.66	286.1	11082.0
2023-04-03 08:00:00	MSFT	Stock	286.35	286.79	284.86	285.03	81896.0
2023-04-03 08:30:00	MSFT	Stock	285.2	285.4	285.02	285.4	54921.0
2023-04-03 09:00:00	MSFT	Stock	285.4	286.68	285.4	286.51	61541.0
2023-04-03 09:30:00	MSFT	Stock	286.52	287.97	285.24	287.05	3015053.0
2023-04-03 10:00:00	MSFT	Stock	287.07	288.27	286.96	287.92	1486814.0
2023-04-03 10:30:00	MSFT	Stock	287.915	288.05	285.77	285.8	1273057.0
2023-04-03 11:00:00	MSFT	Stock	285.81	286.17	285.43	285.82	1188548.0
2023-04-03 11:30:00	MSFT	Stock	285.8	285.985	284.72	285.22	1094843.0
2023-04-03 12:00:00	MSFT	Stock	285.21	285.5	284.605	284.67	985182.0
2023-04-03 12:30:00	MSFT	Stock	284.66	285.0488	284.23	284.42	897621.0

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

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