PREVIEW / stock_30min / 2020-09-02

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-09-02.parquet
  size:    1.9 MB
  rows:    97,720
  symbols: 2,466

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-09-02 04:00:00	AAPL	Stock	136.21	136.77	136.0	136.66	93987.0
2020-09-02 04:30:00	AAPL	Stock	136.66	136.92	136.66	136.92	54502.0
2020-09-02 05:00:00	AAPL	Stock	136.95	137.04	136.8	136.96	75896.0
2020-09-02 05:30:00	AAPL	Stock	136.96	137.11	136.59	137.08	47449.0
2020-09-02 06:00:00	AAPL	Stock	137.02	137.1	136.59	136.65	34079.0
2020-09-02 06:30:00	AAPL	Stock	136.65	136.87	136.05	136.35	78228.0
2020-09-02 07:00:00	AAPL	Stock	136.34	137.03	136.05	136.92	461530.0
2020-09-02 07:30:00	AAPL	Stock	136.92	137.3	136.81	136.85	351910.0
2020-09-02 08:00:00	AAPL	Stock	136.85	137.74	136.05	137.57	924692.0
2020-09-02 08:30:00	AAPL	Stock	137.6	137.99	137.41	137.77	728354.0
2020-09-02 09:00:00	AAPL	Stock	137.75	138.55	137.48	137.51	1524305.0
2020-09-02 09:30:00	AAPL	Stock	137.59	137.98	127.0	128.37	45897900.0
2020-09-02 10:00:00	AAPL	Stock	128.395	132.39	128.25	132.242	20473400.0
2020-09-02 10:30:00	AAPL	Stock	132.262	132.6	130.65	130.86	11319994.0
2020-09-02 11:00:00	AAPL	Stock	130.87	131.27	129.12	129.602	11277889.0
2020-09-02 11:30:00	AAPL	Stock	129.61	130.101	127.1	129.722	14726177.0
2020-09-02 12:00:00	AAPL	Stock	129.74	131.28	129.414	130.968	9433191.0
2020-09-02 12:30:00	AAPL	Stock	130.97	131.2	129.9	130.45	6047158.0
2020-09-02 13:00:00	AAPL	Stock	130.468	131.4	129.7	131.28	6375200.0
2020-09-02 13:30:00	AAPL	Stock	131.27	131.658	130.75	131.02	6343881.0
2020-09-02 14:00:00	AAPL	Stock	131.01	131.18	130.51	131.03	4882660.0
2020-09-02 14:30:00	AAPL	Stock	131.03	131.37	130.3	130.366	4989614.0
2020-09-02 15:00:00	AAPL	Stock	130.38	131.1	130.37	130.72	5811786.0
2020-09-02 15:30:00	AAPL	Stock	130.724	131.8	130.57	131.22	11552438.0
2020-09-02 16:00:00	AAPL	Stock	131.28	132.0	130.401	131.73	9343675.0
2020-09-02 16:30:00	AAPL	Stock	131.66	131.76	131.39	131.39	131091.0
2020-09-02 17:00:00	AAPL	Stock	131.39	131.58	131.0	131.48	176338.0
2020-09-02 17:30:00	AAPL	Stock	131.5	131.72	131.4	131.51	94239.0
2020-09-02 18:00:00	AAPL	Stock	131.53	131.57	131.4	131.53	69278.0
2020-09-02 18:30:00	AAPL	Stock	131.53	131.72	131.47	131.68	85009.0
2020-09-02 19:00:00	AAPL	Stock	131.68	131.97	131.62	131.8	91622.0
2020-09-02 19:30:00	AAPL	Stock	131.8	131.86	131.5	131.54	134439.0
2020-09-02 04:00:00	MSFT	Stock	228.25	228.5	228.02	228.3	1564.0
2020-09-02 04:30:00	MSFT	Stock	228.13	228.53	228.13	228.53	700.0
2020-09-02 05:00:00	MSFT	Stock	228.6	229.03	228.6	228.85	3314.0
2020-09-02 05:30:00	MSFT	Stock	228.85	229.38	228.82	229.37	4688.0
2020-09-02 06:00:00	MSFT	Stock	229.26	229.26	229.16	229.16	498.0
2020-09-02 06:30:00	MSFT	Stock	229.21	229.48	229.21	229.41	1999.0
2020-09-02 07:00:00	MSFT	Stock	229.23	229.23	228.79	228.79	9286.0
2020-09-02 07:30:00	MSFT	Stock	228.79	228.88	228.22	228.63	19869.0
2020-09-02 08:00:00	MSFT	Stock	228.55	229.2	228.22	228.55	56968.0
2020-09-02 08:30:00	MSFT	Stock	228.589	228.699	228.22	228.33	30022.0
2020-09-02 09:00:00	MSFT	Stock	228.31	228.37	227.5	227.63	64235.0
2020-09-02 09:30:00	MSFT	Stock	227.91	231.15	227.35	230.67	4657535.0
2020-09-02 10:00:00	MSFT	Stock	230.69	231.97	229.41	231.34	2836136.0
2020-09-02 10:30:00	MSFT	Stock	231.355	231.4	229.4	230.425	1794933.0
2020-09-02 11:00:00	MSFT	Stock	230.45	230.58	229.28	230.42	1296715.0
2020-09-02 11:30:00	MSFT	Stock	230.38	230.8	228.27	229.0	1530724.0
2020-09-02 12:00:00	MSFT	Stock	229.01	230.2	228.6	229.91	1023887.0
2020-09-02 12:30:00	MSFT	Stock	229.91	231.14	229.73	230.875	948845.0

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

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