PREVIEW / stock_30min / 2022-01-28

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-01-28.parquet
  size:    2.2 MB
  rows:    110,314
  symbols: 2,646

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-01-28 04:00:00	AAPL	Stock	167.8	167.8	165.75	166.62	77574.0
2022-01-28 04:30:00	AAPL	Stock	166.68	166.75	165.75	165.91	57608.0
2022-01-28 05:00:00	AAPL	Stock	165.99	166.0	165.15	165.6	89759.0
2022-01-28 05:30:00	AAPL	Stock	165.58	165.67	165.02	165.67	43197.0
2022-01-28 06:00:00	AAPL	Stock	165.68	165.76	164.29	165.26	128262.0
2022-01-28 06:30:00	AAPL	Stock	165.35	165.5	164.65	165.4	42665.0
2022-01-28 07:00:00	AAPL	Stock	165.5	165.94	163.7	164.3	407130.0
2022-01-28 07:30:00	AAPL	Stock	164.3	164.3	162.8	163.39	487903.0
2022-01-28 08:00:00	AAPL	Stock	165.4501	165.79	161.86	162.17	1423681.0
2022-01-28 08:30:00	AAPL	Stock	162.25	164.26	162.24	164.0	1401116.0
2022-01-28 09:00:00	AAPL	Stock	163.99	165.7	163.28	165.7	1003564.0
2022-01-28 09:30:00	AAPL	Stock	165.71	166.865	162.8	164.4501	21750768.0
2022-01-28 10:00:00	AAPL	Stock	164.48	166.56	164.01	165.44	13784683.0
2022-01-28 10:30:00	AAPL	Stock	165.45	166.85	164.79	166.84	9147725.0
2022-01-28 11:00:00	AAPL	Stock	166.84	168.62	166.62	167.9	12339754.0
2022-01-28 11:30:00	AAPL	Stock	167.88	168.77	167.3911	168.77	7980411.0
2022-01-28 12:00:00	AAPL	Stock	168.77	169.14	168.0538	168.2358	7613360.0
2022-01-28 12:30:00	AAPL	Stock	168.24	168.8999	167.71	168.12	6444561.0
2022-01-28 13:00:00	AAPL	Stock	168.11	168.8	167.73	168.27	5354625.0
2022-01-28 13:30:00	AAPL	Stock	168.27	168.86	168.06	168.45	4933071.0
2022-01-28 14:00:00	AAPL	Stock	168.44	168.76	166.75	166.945	6825839.0
2022-01-28 14:30:00	AAPL	Stock	166.95	167.9499	166.52	167.835	6239931.0
2022-01-28 15:00:00	AAPL	Stock	167.83	169.2	167.73	168.7102	8141161.0
2022-01-28 15:30:00	AAPL	Stock	168.71	170.35	168.33	170.3499	19634008.0
2022-01-28 16:00:00	AAPL	Stock	170.12	170.33	169.95	170.0	10391350.0
2022-01-28 16:30:00	AAPL	Stock	170.0	170.33	169.97	170.02	282220.0
2022-01-28 17:00:00	AAPL	Stock	170.03	170.33	169.99	170.3	126621.0
2022-01-28 17:30:00	AAPL	Stock	170.33	170.55	170.33	170.35	115873.0
2022-01-28 18:00:00	AAPL	Stock	170.35	170.44	170.34	170.43	37841.0
2022-01-28 18:30:00	AAPL	Stock	170.44	170.53	170.44	170.48	42580.0
2022-01-28 19:00:00	AAPL	Stock	170.47	170.58	170.33	170.46	33618.0
2022-01-28 19:30:00	AAPL	Stock	170.52	170.82	170.48	170.7	105652.0
2022-01-28 04:00:00	MSFT	Stock	301.19	302.2	300.1	302.03	6956.0
2022-01-28 04:30:00	MSFT	Stock	302.0	302.5	301.6	301.6	4687.0
2022-01-28 05:00:00	MSFT	Stock	301.2	301.4	300.2	301.4	14136.0
2022-01-28 05:30:00	MSFT	Stock	300.15	300.23	299.6	299.76	4181.0
2022-01-28 06:00:00	MSFT	Stock	300.17	300.5	298.99	299.75	7899.0
2022-01-28 06:30:00	MSFT	Stock	299.7	299.78	299.3	299.58	1230.0
2022-01-28 07:00:00	MSFT	Stock	299.83	300.38	297.15	297.98	39405.0
2022-01-28 07:30:00	MSFT	Stock	297.97	298.53	295.61	296.84	44456.0
2022-01-28 08:00:00	MSFT	Stock	299.59	300.589	295.55	297.52	75697.0
2022-01-28 08:30:00	MSFT	Stock	297.58	301.34	297.58	300.98	87862.0
2022-01-28 09:00:00	MSFT	Stock	300.67	301.05	299.6022	300.57	93575.0
2022-01-28 09:30:00	MSFT	Stock	300.4	300.8	294.53	295.19	3715095.0
2022-01-28 10:00:00	MSFT	Stock	295.19	300.22	294.45	298.8881	2936569.0
2022-01-28 10:30:00	MSFT	Stock	298.93	302.23	297.315	302.16	2447549.0
2022-01-28 11:00:00	MSFT	Stock	302.16	304.2217	300.96	303.95	2289732.0
2022-01-28 11:30:00	MSFT	Stock	303.99	305.4	303.26	305.1	2288213.0
2022-01-28 12:00:00	MSFT	Stock	305.13	305.25	302.89	303.14	1693702.0
2022-01-28 12:30:00	MSFT	Stock	303.17	303.91	302.22	302.44	1433195.0

> showing 50 of 110,314 rows — these rows as CSV

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