PREVIEW / stock_30min / 2020-10-19

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-10-19.parquet
  size:    1.9 MB
  rows:    97,303
  symbols: 2,508

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
2020-10-19 04:00:00	AAPL	Stock	120.1	120.58	119.8	120.56	62976.0
2020-10-19 04:30:00	AAPL	Stock	120.58	121.05	120.58	120.8	42618.0
2020-10-19 05:00:00	AAPL	Stock	120.8	120.96	120.65	120.65	14213.0
2020-10-19 05:30:00	AAPL	Stock	120.63	120.74	120.5	120.7	23511.0
2020-10-19 06:00:00	AAPL	Stock	120.53	120.53	120.08	120.37	23173.0
2020-10-19 06:30:00	AAPL	Stock	120.32	120.63	120.32	120.6	13968.0
2020-10-19 07:00:00	AAPL	Stock	120.51	120.64	119.9	120.17	288681.0
2020-10-19 07:30:00	AAPL	Stock	120.17	120.27	119.93	120.03	170326.0
2020-10-19 08:00:00	AAPL	Stock	120.05	120.5	119.86	120.04	521649.0
2020-10-19 08:30:00	AAPL	Stock	120.01	120.1	119.78	119.87	270644.0
2020-10-19 09:00:00	AAPL	Stock	119.87	120.27	119.02	119.98	535033.0
2020-10-19 09:30:00	AAPL	Stock	119.96	120.419	119.34	119.545	12229335.0
2020-10-19 10:00:00	AAPL	Stock	119.54	119.585	118.79	119.493	8776247.0
2020-10-19 10:30:00	AAPL	Stock	119.495	119.511	118.17	118.865	9323480.0
2020-10-19 11:00:00	AAPL	Stock	118.865	119.7	118.78	119.12	7621662.0
2020-10-19 11:30:00	AAPL	Stock	119.11	119.51	118.73	118.76	5024166.0
2020-10-19 12:00:00	AAPL	Stock	118.765	118.92	118.4	118.815	5720432.0
2020-10-19 12:30:00	AAPL	Stock	118.8	119.14	118.7	118.77	4249472.0
2020-10-19 13:00:00	AAPL	Stock	118.765	118.97	118.585	118.7	3352801.0
2020-10-19 13:30:00	AAPL	Stock	118.7	118.75	117.6	118.03	6767640.0
2020-10-19 14:00:00	AAPL	Stock	118.02	118.1	117.53	117.83	5429128.0
2020-10-19 14:30:00	AAPL	Stock	117.82	117.83	116.84	116.85	8854605.0
2020-10-19 15:00:00	AAPL	Stock	116.86	116.89	116.16	116.364	9684052.0
2020-10-19 15:30:00	AAPL	Stock	116.35	116.9	115.66	116.0	13825517.0
2020-10-19 16:00:00	AAPL	Stock	116.0	116.31	115.98	116.25	7381107.0
2020-10-19 16:30:00	AAPL	Stock	116.26	116.8	116.26	116.71	243130.0
2020-10-19 17:00:00	AAPL	Stock	116.73	116.9	116.5	116.68	181496.0
2020-10-19 17:30:00	AAPL	Stock	116.7	116.77	116.64	116.75	61426.0
2020-10-19 18:00:00	AAPL	Stock	116.79	116.95	116.64	116.93	129036.0
2020-10-19 18:30:00	AAPL	Stock	116.92	116.92	116.76	116.86	55193.0
2020-10-19 19:00:00	AAPL	Stock	116.86	116.9	116.76	116.83	76762.0
2020-10-19 19:30:00	AAPL	Stock	116.83	117.1	116.82	117.09	158847.0
2020-10-19 04:00:00	MSFT	Stock	220.29	221.25	220.29	220.9	1190.0
2020-10-19 04:30:00	MSFT	Stock	221.33	221.33	221.0	221.0	605.0
2020-10-19 05:00:00	MSFT	Stock	221.02	221.02	221.02	221.02	100.0
2020-10-19 05:30:00	MSFT	Stock	221.32	221.32	221.1	221.1	400.0
2020-10-19 06:00:00	MSFT	Stock	221.1	221.17	220.52	220.8	8530.0
2020-10-19 06:30:00	MSFT	Stock	221.1	221.29	221.1	221.29	1399.0
2020-10-19 07:00:00	MSFT	Stock	221.19	221.38	221.0	221.22	21184.0
2020-10-19 07:30:00	MSFT	Stock	221.13	221.25	221.0	221.24	11791.0
2020-10-19 08:00:00	MSFT	Stock	221.22	221.31	219.12	220.9	28500.0
2020-10-19 08:30:00	MSFT	Stock	221.0	221.0	220.5	220.83	17687.0
2020-10-19 09:00:00	MSFT	Stock	220.85	221.31	220.22	220.53	44723.0
2020-10-19 09:30:00	MSFT	Stock	220.36	222.3	220.1	220.2	2354885.0
2020-10-19 10:00:00	MSFT	Stock	220.22	220.538	219.67	220.21	1327226.0
2020-10-19 10:30:00	MSFT	Stock	220.21	220.22	217.718	218.28	1652080.0
2020-10-19 11:00:00	MSFT	Stock	218.27	218.75	217.34	218.06	1053118.0
2020-10-19 11:30:00	MSFT	Stock	218.056	218.83	217.76	217.97	835613.0
2020-10-19 12:00:00	MSFT	Stock	218.0	218.53	217.2	217.65	1026788.0
2020-10-19 12:30:00	MSFT	Stock	217.62	218.47	217.58	218.11	698800.0

> showing 50 of 97,303 rows — these rows as CSV

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