PREVIEW / stock_30min / 2020-11-13

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-11-13.parquet
  size:    2.0 MB
  rows:    98,601
  symbols: 2,540

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-13 04:00:00	AAPL	Stock	119.8	119.83	119.6	119.63	20261.0
2020-11-13 04:30:00	AAPL	Stock	119.66	120.1	119.65	119.81	18459.0
2020-11-13 05:00:00	AAPL	Stock	119.88	120.09	119.88	119.92	8331.0
2020-11-13 05:30:00	AAPL	Stock	119.99	120.1	119.95	120.0	16480.0
2020-11-13 06:00:00	AAPL	Stock	119.94	120.0	119.79	119.79	5746.0
2020-11-13 06:30:00	AAPL	Stock	119.85	120.05	119.74	119.92	36411.0
2020-11-13 07:00:00	AAPL	Stock	120.02	120.02	119.62	119.93	105406.0
2020-11-13 07:30:00	AAPL	Stock	119.93	119.98	119.65	119.69	66631.0
2020-11-13 08:00:00	AAPL	Stock	119.82	119.97	119.5	119.67	242216.0
2020-11-13 08:30:00	AAPL	Stock	119.67	119.8	119.64	119.67	103197.0
2020-11-13 09:00:00	AAPL	Stock	119.67	119.74	119.3	119.45	170817.0
2020-11-13 09:30:00	AAPL	Stock	119.45	119.672	118.375	118.4	10548868.0
2020-11-13 10:00:00	AAPL	Stock	118.395	118.74	117.93	118.68	7089824.0
2020-11-13 10:30:00	AAPL	Stock	118.69	118.69	117.87	118.04	5597484.0
2020-11-13 11:00:00	AAPL	Stock	118.03	118.5	117.93	118.25	4159384.0
2020-11-13 11:30:00	AAPL	Stock	118.25	118.77	118.0	118.73	3976281.0
2020-11-13 12:00:00	AAPL	Stock	118.73	118.99	118.62	118.78	3620707.0
2020-11-13 12:30:00	AAPL	Stock	118.775	119.05	118.625	118.96	3108595.0
2020-11-13 13:00:00	AAPL	Stock	118.96	119.255	118.92	119.035	3545923.0
2020-11-13 13:30:00	AAPL	Stock	119.034	119.07	118.495	118.59	3451579.0
2020-11-13 14:00:00	AAPL	Stock	118.58	118.737	118.2	118.51	3785327.0
2020-11-13 14:30:00	AAPL	Stock	118.5	118.9	118.47	118.87	3099849.0
2020-11-13 15:00:00	AAPL	Stock	118.87	119.235	118.8	119.17	4372395.0
2020-11-13 15:30:00	AAPL	Stock	119.17	119.57	119.15	119.25	8248230.0
2020-11-13 16:00:00	AAPL	Stock	119.26	119.33	119.24	119.26	5039438.0
2020-11-13 16:30:00	AAPL	Stock	119.26	119.28	119.24	119.27	47118.0
2020-11-13 17:00:00	AAPL	Stock	119.24	119.25	119.1	119.24	45029.0
2020-11-13 17:30:00	AAPL	Stock	119.25	119.26	119.13	119.18	31420.0
2020-11-13 18:00:00	AAPL	Stock	119.16	119.2	119.14	119.16	17038.0
2020-11-13 18:30:00	AAPL	Stock	119.2	119.2	119.1	119.15	23027.0
2020-11-13 19:00:00	AAPL	Stock	119.17	119.18	119.1	119.17	23244.0
2020-11-13 19:30:00	AAPL	Stock	119.15	119.25	119.08	119.25	31239.0
2020-11-13 04:00:00	MSFT	Stock	216.76	216.8	216.75	216.76	1284.0
2020-11-13 04:30:00	MSFT	Stock	216.8	217.0	216.8	216.97	1759.0
2020-11-13 05:00:00	MSFT	Stock	217.35	217.4	217.16	217.16	498.0
2020-11-13 05:30:00	MSFT	Stock	217.09	217.09	216.88	216.88	416.0
2020-11-13 06:00:00	MSFT	Stock	216.83	216.97	216.8	216.9	4308.0
2020-11-13 06:30:00	MSFT	Stock	216.9	216.99	216.9	216.99	805.0
2020-11-13 07:00:00	MSFT	Stock	216.71	216.8	216.65	216.78	7109.0
2020-11-13 07:30:00	MSFT	Stock	216.82	216.94	216.01	216.28	8293.0
2020-11-13 08:00:00	MSFT	Stock	216.4	216.87	215.97	216.7	12375.0
2020-11-13 08:30:00	MSFT	Stock	216.85	216.85	216.45	216.65	5791.0
2020-11-13 09:00:00	MSFT	Stock	216.618	216.89	216.31	216.31	14343.0
2020-11-13 09:30:00	MSFT	Stock	216.32	216.83	215.21	215.345	1771269.0
2020-11-13 10:00:00	MSFT	Stock	215.37	215.46	214.41	215.215	1068766.0
2020-11-13 10:30:00	MSFT	Stock	215.2	215.21	214.16	214.8	911937.0
2020-11-13 11:00:00	MSFT	Stock	214.83	215.47	214.8	215.01	844534.0
2020-11-13 11:30:00	MSFT	Stock	215.01	215.41	214.46	215.23	584159.0
2020-11-13 12:00:00	MSFT	Stock	215.25	215.6	215.075	215.57	663096.0
2020-11-13 12:30:00	MSFT	Stock	215.57	216.13	215.48	216.02	720694.0

> showing 50 of 98,601 rows — these rows as CSV

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