PREVIEW / stock_30min / 2022-01-19

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-01-19.parquet
  size:    2.2 MB
  rows:    110,611
  symbols: 2,617

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-19 04:00:00	AAPL	Stock	169.3	169.7	169.3	169.35	24025.0
2022-01-19 04:30:00	AAPL	Stock	169.31	170.1	169.31	170.1	14149.0
2022-01-19 05:00:00	AAPL	Stock	170.16	170.27	170.08	170.27	11046.0
2022-01-19 05:30:00	AAPL	Stock	170.26	170.35	170.15	170.35	2992.0
2022-01-19 06:00:00	AAPL	Stock	170.43	170.5	170.0	170.03	5137.0
2022-01-19 06:30:00	AAPL	Stock	170.09	170.28	170.09	170.25	3106.0
2022-01-19 07:00:00	AAPL	Stock	170.27	170.35	170.08	170.15	26492.0
2022-01-19 07:30:00	AAPL	Stock	170.16	170.25	169.87	170.24	43364.0
2022-01-19 08:00:00	AAPL	Stock	170.3001	170.85	169.95	170.85	304266.0
2022-01-19 08:30:00	AAPL	Stock	170.86	170.88	170.4	170.72	130246.0
2022-01-19 09:00:00	AAPL	Stock	170.76	170.76	169.81	169.9	217762.0
2022-01-19 09:30:00	AAPL	Stock	169.98	170.98	169.28	170.9315	8816337.0
2022-01-19 10:00:00	AAPL	Stock	170.95	171.08	169.79	169.87	5840901.0
2022-01-19 10:30:00	AAPL	Stock	169.89	170.04	168.64	168.895	5800045.0
2022-01-19 11:00:00	AAPL	Stock	168.9	169.2485	167.54	167.78	6879599.0
2022-01-19 11:30:00	AAPL	Stock	167.7917	168.39	167.32	168.33	5353757.0
2022-01-19 12:00:00	AAPL	Stock	168.33	169.62	168.33	169.04	4040216.0
2022-01-19 12:30:00	AAPL	Stock	169.065	169.2892	168.63	169.08	2938230.0
2022-01-19 13:00:00	AAPL	Stock	169.08	169.45	168.76	168.8103	3271357.0
2022-01-19 13:30:00	AAPL	Stock	168.81	169.03	168.37	168.45	2997285.0
2022-01-19 14:00:00	AAPL	Stock	168.44	168.66	167.62	167.65	4129992.0
2022-01-19 14:30:00	AAPL	Stock	167.645	168.24	167.54	167.95	4080672.0
2022-01-19 15:00:00	AAPL	Stock	167.95	168.2699	167.49	167.51	4127068.0
2022-01-19 15:30:00	AAPL	Stock	167.51	167.675	165.94	166.21	10390702.0
2022-01-19 16:00:00	AAPL	Stock	166.23	166.23	165.82	165.85	8894477.0
2022-01-19 16:30:00	AAPL	Stock	165.85	166.23	165.01	165.75	342013.0
2022-01-19 17:00:00	AAPL	Stock	165.74	165.78	165.59	165.63	34756.0
2022-01-19 17:30:00	AAPL	Stock	165.63	165.85	165.57	165.7301	32667.0
2022-01-19 18:00:00	AAPL	Stock	165.75	165.99	165.46	165.5	55267.0
2022-01-19 18:30:00	AAPL	Stock	165.54	165.6899	165.31	165.46	27000.0
2022-01-19 19:00:00	AAPL	Stock	165.46	166.09	165.46	166.04	63005.0
2022-01-19 19:30:00	AAPL	Stock	166.01	166.1	165.51	165.72	49360.0
2022-01-19 04:00:00	MSFT	Stock	302.61	303.5	302.5	303.01	2603.0
2022-01-19 04:30:00	MSFT	Stock	302.66	303.9	302.66	303.9	3385.0
2022-01-19 05:00:00	MSFT	Stock	303.87	304.25	303.78	304.25	1918.0
2022-01-19 05:30:00	MSFT	Stock	304.4	304.6	304.02	304.16	2458.0
2022-01-19 06:00:00	MSFT	Stock	304.63	304.63	304.15	304.3	7483.0
2022-01-19 06:30:00	MSFT	Stock	304.5	304.72	304.35	304.72	2054.0
2022-01-19 07:00:00	MSFT	Stock	304.72	304.88	304.33	304.33	13282.0
2022-01-19 07:30:00	MSFT	Stock	304.63	305.0	304.32	304.99	21390.0
2022-01-19 08:00:00	MSFT	Stock	304.5	306.5	303.406	306.26	47237.0
2022-01-19 08:30:00	MSFT	Stock	306.09	307.0	305.4	306.7	48305.0
2022-01-19 09:00:00	MSFT	Stock	306.65	307.0	305.91	306.2	51386.0
2022-01-19 09:30:00	MSFT	Stock	306.31	313.9	305.3	313.38	5943662.0
2022-01-19 10:00:00	MSFT	Stock	313.38	313.9093	310.41	310.4501	3495659.0
2022-01-19 10:30:00	MSFT	Stock	310.48	310.76	307.32	307.915	2784248.0
2022-01-19 11:00:00	MSFT	Stock	307.9	308.7	306.29	307.23	2041617.0
2022-01-19 11:30:00	MSFT	Stock	307.24	309.35	306.66	308.65	1945221.0
2022-01-19 12:00:00	MSFT	Stock	308.61	311.11	308.61	311.0576	1823350.0
2022-01-19 12:30:00	MSFT	Stock	311.08	311.35	310.1501	311.18	1564202.0

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

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