PREVIEW / stock_30min / 2020-11-16

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-11-16.parquet
  size:    2.1 MB
  rows:    105,910
  symbols: 2,561

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-11-16 04:00:00	AAPL	Stock	119.59	119.83	119.59	119.65	15475.0
2020-11-16 04:30:00	AAPL	Stock	119.68	119.78	119.61	119.78	7095.0
2020-11-16 05:00:00	AAPL	Stock	119.72	119.72	119.44	119.6	12931.0
2020-11-16 05:30:00	AAPL	Stock	119.59	119.69	119.44	119.44	6316.0
2020-11-16 06:00:00	AAPL	Stock	119.56	119.75	119.56	119.67	2791.0
2020-11-16 06:30:00	AAPL	Stock	119.72	119.89	118.76	118.76	40073.0
2020-11-16 07:00:00	AAPL	Stock	118.97	119.26	118.21	118.6	229509.0
2020-11-16 07:30:00	AAPL	Stock	118.63	119.29	118.6	118.88	333235.0
2020-11-16 08:00:00	AAPL	Stock	119.05	119.55	118.26	118.93	453462.0
2020-11-16 08:30:00	AAPL	Stock	118.93	118.93	118.6	118.89	201108.0
2020-11-16 09:00:00	AAPL	Stock	118.886	119.16	118.6	118.88	312760.0
2020-11-16 09:30:00	AAPL	Stock	118.85	120.14	118.146	119.949	14194440.0
2020-11-16 10:00:00	AAPL	Stock	119.95	120.72	119.8	120.46	8884205.0
2020-11-16 10:30:00	AAPL	Stock	120.485	120.69	120.13	120.674	5114248.0
2020-11-16 11:00:00	AAPL	Stock	120.68	120.83	120.305	120.479	4696659.0
2020-11-16 11:30:00	AAPL	Stock	120.47	120.8	120.32	120.745	3587273.0
2020-11-16 12:00:00	AAPL	Stock	120.745	120.99	120.44	120.65	4284055.0
2020-11-16 12:30:00	AAPL	Stock	120.645	120.83	120.28	120.43	3266153.0
2020-11-16 13:00:00	AAPL	Stock	120.425	120.59	120.15	120.18	3578264.0
2020-11-16 13:30:00	AAPL	Stock	120.175	120.43	120.0	120.22	3713911.0
2020-11-16 14:00:00	AAPL	Stock	120.22	120.37	120.02	120.31	2798019.0
2020-11-16 14:30:00	AAPL	Stock	120.312	120.32	119.79	119.905	3978014.0
2020-11-16 15:00:00	AAPL	Stock	119.908	120.13	119.64	119.926	4773954.0
2020-11-16 15:30:00	AAPL	Stock	119.924	120.5	119.73	120.35	6716241.0
2020-11-16 16:00:00	AAPL	Stock	120.35	120.47	120.09	120.35	6430443.0
2020-11-16 16:30:00	AAPL	Stock	120.35	120.47	120.18	120.4	587921.0
2020-11-16 17:00:00	AAPL	Stock	120.4	120.43	120.1	120.15	66371.0
2020-11-16 17:30:00	AAPL	Stock	120.18	120.18	119.95	120.06	87204.0
2020-11-16 18:00:00	AAPL	Stock	120.06	120.32	120.0	120.01	81615.0
2020-11-16 18:30:00	AAPL	Stock	120.05	120.1	119.92	119.93	50404.0
2020-11-16 19:00:00	AAPL	Stock	119.93	120.02	119.76	119.77	58851.0
2020-11-16 19:30:00	AAPL	Stock	119.78	119.95	119.75	119.9	85092.0
2020-11-16 04:00:00	MSFT	Stock	216.85	218.0	216.85	217.9	1987.0
2020-11-16 04:30:00	MSFT	Stock	217.89	217.92	217.89	217.92	400.0
2020-11-16 05:00:00	MSFT	Stock	217.82	218.0	217.6	218.0	1020.0
2020-11-16 05:30:00	MSFT	Stock	217.76	217.96	217.67	217.68	2010.0
2020-11-16 06:00:00	MSFT	Stock	217.9	217.92	217.8	217.8	500.0
2020-11-16 06:30:00	MSFT	Stock	217.82	217.82	216.08	216.08	4792.0
2020-11-16 07:00:00	MSFT	Stock	217.75	217.75	213.63	215.0	38821.0
2020-11-16 07:30:00	MSFT	Stock	215.38	216.09	215.0	215.7	23769.0
2020-11-16 08:00:00	MSFT	Stock	215.55	216.92	213.791	214.6	76037.0
2020-11-16 08:30:00	MSFT	Stock	214.6	215.2	214.33	214.9	36755.0
2020-11-16 09:00:00	MSFT	Stock	214.89	216.04	214.08	214.92	100957.0
2020-11-16 09:30:00	MSFT	Stock	214.93	216.933	214.47	216.52	3540878.0
2020-11-16 10:00:00	MSFT	Stock	216.52	217.04	215.64	216.95	1244582.0
2020-11-16 10:30:00	MSFT	Stock	216.995	217.19	216.24	217.18	988627.0
2020-11-16 11:00:00	MSFT	Stock	217.19	217.74	217.0	217.045	869406.0
2020-11-16 11:30:00	MSFT	Stock	217.025	217.2	216.48	216.77	734268.0
2020-11-16 12:00:00	MSFT	Stock	216.78	216.88	216.13	216.59	783124.0
2020-11-16 12:30:00	MSFT	Stock	216.58	216.61	215.85	215.97	597762.0

> showing 50 of 105,910 rows — these rows as CSV

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