PREVIEW / stock_30min / 2023-04-21

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-04-21.parquet
  size:    2.0 MB
  rows:    98,318
  symbols: 1,667

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-21 04:00:00	AAPL	Stock	166.68	166.68	166.33	166.34	5807.0
2023-04-21 04:30:00	AAPL	Stock	166.32	166.6	166.32	166.58	2462.0
2023-04-21 05:00:00	AAPL	Stock	166.6	166.6	166.5	166.56	933.0
2023-04-21 05:30:00	AAPL	Stock	166.55	166.66	166.52	166.61	1778.0
2023-04-21 06:00:00	AAPL	Stock	166.57	166.57	166.37	166.38	1311.0
2023-04-21 06:30:00	AAPL	Stock	166.38	166.38	162.99	163.77	213884.0
2023-04-21 07:00:00	AAPL	Stock	163.97	164.49	163.97	164.27	125788.0
2023-04-21 07:30:00	AAPL	Stock	164.33	164.4	163.89	164.0	134683.0
2023-04-21 08:00:00	AAPL	Stock	164.35	166.44	163.8	164.7489	225711.0
2023-04-21 08:30:00	AAPL	Stock	164.66	164.69	164.21	164.62	164566.0
2023-04-21 09:00:00	AAPL	Stock	164.62	165.4	164.41	165.05	452569.0
2023-04-21 09:30:00	AAPL	Stock	165.05	166.4521	164.67	164.9	9990727.0
2023-04-21 10:00:00	AAPL	Stock	164.895	165.68	164.72	165.3798	4133843.0
2023-04-21 10:30:00	AAPL	Stock	165.37	165.46	164.49	165.01	3527280.0
2023-04-21 11:00:00	AAPL	Stock	165.02	165.325	164.71	165.09	2642167.0
2023-04-21 11:30:00	AAPL	Stock	165.1	165.42	164.81	165.22	2147873.0
2023-04-21 12:00:00	AAPL	Stock	165.22	165.24	164.8483	164.9291	1744525.0
2023-04-21 12:30:00	AAPL	Stock	164.925	165.06	164.745	164.9	1508935.0
2023-04-21 13:00:00	AAPL	Stock	164.895	165.21	164.68	164.7975	1819114.0
2023-04-21 13:30:00	AAPL	Stock	164.7999	165.1	164.71	165.075	2033024.0
2023-04-21 14:00:00	AAPL	Stock	165.075	165.365	165.02	165.275	2202349.0
2023-04-21 14:30:00	AAPL	Stock	165.2785	165.36	164.88	165.035	1868799.0
2023-04-21 15:00:00	AAPL	Stock	165.0328	165.065	164.715	164.9575	2140413.0
2023-04-21 15:30:00	AAPL	Stock	164.955	165.06	164.69	165.02	4431428.0
2023-04-21 16:00:00	AAPL	Stock	165.02	165.07	164.97	165.0	5729331.0
2023-04-21 16:30:00	AAPL	Stock	165.0	165.02	164.98	164.98	34618.0
2023-04-21 17:00:00	AAPL	Stock	164.98	165.0	164.98	164.99	9715.0
2023-04-21 17:30:00	AAPL	Stock	164.97	165.02	164.95	164.95	283099.0
2023-04-21 18:00:00	AAPL	Stock	164.9501	165.0	164.95	164.95	5092.0
2023-04-21 18:30:00	AAPL	Stock	164.95	164.98	164.91	164.91	8891.0
2023-04-21 19:00:00	AAPL	Stock	164.9	164.96	164.9	164.94	1083.0
2023-04-21 19:30:00	AAPL	Stock	164.94	165.0	164.9	164.9201	6866.0
2023-04-21 04:00:00	MSFT	Stock	286.48	286.48	286.27	286.4	940.0
2023-04-21 04:30:00	MSFT	Stock	286.2	286.35	286.08	286.35	1990.0
2023-04-21 05:00:00	MSFT	Stock	286.45	286.55	286.3	286.55	1112.0
2023-04-21 05:30:00	MSFT	Stock	286.4	286.7	286.4	286.7	1950.0
2023-04-21 06:30:00	MSFT	Stock	285.86	286.0	285.41	285.41	4892.0
2023-04-21 07:00:00	MSFT	Stock	285.5	285.62	285.02	285.39	6997.0
2023-04-21 07:30:00	MSFT	Stock	285.4	285.62	283.35	283.58	22371.0
2023-04-21 08:00:00	MSFT	Stock	285.66	286.45	283.3	284.76	36882.0
2023-04-21 08:30:00	MSFT	Stock	284.68	285.15	284.29	285.15	21422.0
2023-04-21 09:00:00	MSFT	Stock	285.39	285.53	284.61	285.05	47820.0
2023-04-21 09:30:00	MSFT	Stock	285.08	285.225	283.0608	283.19	2803656.0
2023-04-21 10:00:00	MSFT	Stock	283.18	285.24	283.14	284.815	1361082.0
2023-04-21 10:30:00	MSFT	Stock	284.83	284.9799	283.08	284.15	1138299.0
2023-04-21 11:00:00	MSFT	Stock	284.18	284.99	284.18	284.73	826865.0
2023-04-21 11:30:00	MSFT	Stock	284.73	285.89	284.63	285.62	960718.0
2023-04-21 12:00:00	MSFT	Stock	285.62	285.94	285.17	285.22	574296.0
2023-04-21 12:30:00	MSFT	Stock	285.25	285.38	284.79	285.09	463727.0
2023-04-21 13:00:00	MSFT	Stock	285.07	285.56	284.81	285.11	507462.0

> showing 50 of 98,318 rows — these rows as CSV

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