PREVIEW / stock_30min / 2022-08-26

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-08-26.parquet
  size:    2.1 MB
  rows:    104,122
  symbols: 2,236

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-08-26 04:00:00	AAPL	Stock	170.0	170.0	169.4	169.54	10654.0
2022-08-26 04:30:00	AAPL	Stock	169.51	169.73	169.42	169.57	7011.0
2022-08-26 05:00:00	AAPL	Stock	169.51	169.51	169.41	169.42	7673.0
2022-08-26 05:30:00	AAPL	Stock	169.42	169.44	169.24	169.24	4087.0
2022-08-26 06:00:00	AAPL	Stock	169.36	169.53	169.36	169.53	3112.0
2022-08-26 06:30:00	AAPL	Stock	169.53	169.53	169.45	169.47	2308.0
2022-08-26 07:00:00	AAPL	Stock	169.54	169.77	169.33	169.75	36076.0
2022-08-26 07:30:00	AAPL	Stock	169.71	169.99	169.71	169.86	23221.0
2022-08-26 08:00:00	AAPL	Stock	169.51	169.94	169.35	169.77	90925.0
2022-08-26 08:30:00	AAPL	Stock	169.74	170.47	169.66	170.4532	196197.0
2022-08-26 09:00:00	AAPL	Stock	170.39	171.13	170.35	170.51	266873.0
2022-08-26 09:30:00	AAPL	Stock	170.57	170.6	169.745	170.2924	5096131.0
2022-08-26 10:00:00	AAPL	Stock	170.3	171.05	168.34	168.69	6168580.0
2022-08-26 10:30:00	AAPL	Stock	168.6837	168.6837	167.31	167.6	4211515.0
2022-08-26 11:00:00	AAPL	Stock	167.58	167.6635	166.3718	166.9893	4048421.0
2022-08-26 11:30:00	AAPL	Stock	167.0	167.285	166.7652	166.8427	2577424.0
2022-08-26 12:00:00	AAPL	Stock	166.85	166.86	166.02	166.3385	2329288.0
2022-08-26 12:30:00	AAPL	Stock	166.33	166.35	165.78	166.31	2569369.0
2022-08-26 13:00:00	AAPL	Stock	166.3	166.55	165.03	165.3146	4740497.0
2022-08-26 13:30:00	AAPL	Stock	165.32	165.45	164.73	164.915	3037062.0
2022-08-26 14:00:00	AAPL	Stock	164.91	165.0599	164.62	164.945	2573772.0
2022-08-26 14:30:00	AAPL	Stock	164.945	164.99	164.51	164.68	2274422.0
2022-08-26 15:00:00	AAPL	Stock	164.68	164.96	164.39	164.4718	3409254.0
2022-08-26 15:30:00	AAPL	Stock	164.485	164.53	163.56	163.66	9656801.0
2022-08-26 16:00:00	AAPL	Stock	163.65	163.71	163.0	163.11	12804819.0
2022-08-26 16:30:00	AAPL	Stock	163.1	163.62	162.65	162.73	406345.0
2022-08-26 17:00:00	AAPL	Stock	162.74	163.62	162.56	162.66	116530.0
2022-08-26 17:30:00	AAPL	Stock	162.65	162.8005	162.56	162.59	68723.0
2022-08-26 18:00:00	AAPL	Stock	162.59	162.66	162.5	162.54	30473.0
2022-08-26 18:30:00	AAPL	Stock	162.51	162.61	162.45	162.45	13175.0
2022-08-26 19:00:00	AAPL	Stock	162.45	162.48	162.3	162.37	33311.0
2022-08-26 19:30:00	AAPL	Stock	162.39	162.52	162.31	162.47	34753.0
2022-08-26 04:00:00	MSFT	Stock	278.23	278.23	277.4	277.4	505.0
2022-08-26 04:30:00	MSFT	Stock	277.6	277.7	277.6	277.7	548.0
2022-08-26 05:00:00	MSFT	Stock	277.7	277.7	277.2	277.26	1323.0
2022-08-26 06:00:00	MSFT	Stock	277.0	277.5	277.0	277.4	2251.0
2022-08-26 06:30:00	MSFT	Stock	277.38	277.38	277.38	277.38	300.0
2022-08-26 07:00:00	MSFT	Stock	277.75	277.75	277.25	277.47	12731.0
2022-08-26 07:30:00	MSFT	Stock	277.47	277.78	277.23	277.78	2259.0
2022-08-26 08:00:00	MSFT	Stock	277.5505	278.153	277.2	277.71	13273.0
2022-08-26 08:30:00	MSFT	Stock	277.83	279.2	277.83	279.2	19588.0
2022-08-26 09:00:00	MSFT	Stock	279.3	280.7	278.8	278.9	40589.0
2022-08-26 09:30:00	MSFT	Stock	278.86	279.7	278.37	279.61	921423.0
2022-08-26 10:00:00	MSFT	Stock	279.61	280.34	275.39	276.03	1419566.0
2022-08-26 10:30:00	MSFT	Stock	276.0	276.0	273.72	274.13	1169312.0
2022-08-26 11:00:00	MSFT	Stock	274.07	274.26	271.52	272.52	1114632.0
2022-08-26 11:30:00	MSFT	Stock	272.55	273.0899	271.76	272.33	545161.0
2022-08-26 12:00:00	MSFT	Stock	272.35	272.35	271.15	271.82	522007.0
2022-08-26 12:30:00	MSFT	Stock	271.81	272.77	271.5	272.71	389277.0
2022-08-26 13:00:00	MSFT	Stock	272.7	273.11	272.24	272.735	459857.0

> showing 50 of 104,122 rows — these rows as CSV

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