PREVIEW / stock_30min / 2019-04-29

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-04-29.parquet
  size:    1.7 MB
  rows:    83,724
  symbols: 2,639

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
2019-04-29 04:00:00	AAPL	Stock	51.095	51.12	51.095	51.12	6948.0
2019-04-29 04:30:00	AAPL	Stock	51.135	51.135	51.12	51.12	3348.0
2019-04-29 05:00:00	AAPL	Stock	51.12	51.2	51.12	51.1425	11656.0
2019-04-29 05:30:00	AAPL	Stock	51.1475	51.1475	51.12	51.12	6708.0
2019-04-29 06:00:00	AAPL	Stock	51.13	51.13	51.12	51.12	8848.0
2019-04-29 06:30:00	AAPL	Stock	51.0925	51.0925	50.99	51.0425	28000.0
2019-04-29 07:00:00	AAPL	Stock	51.0	51.07	50.9675	51.045	18272.0
2019-04-29 07:30:00	AAPL	Stock	51.05	51.0625	51.015	51.0625	34624.0
2019-04-29 08:00:00	AAPL	Stock	51.04	51.075	51.0	51.0675	116304.0
2019-04-29 08:30:00	AAPL	Stock	51.075	51.105	51.0125	51.03	119568.0
2019-04-29 09:00:00	AAPL	Stock	51.06	51.1775	51.0338	51.0675	135644.0
2019-04-29 09:30:00	AAPL	Stock	51.1	51.3175	50.965	51.23	11540236.0
2019-04-29 10:00:00	AAPL	Stock	51.2325	51.4925	51.2075	51.3245	8090764.0
2019-04-29 10:30:00	AAPL	Stock	51.3275	51.42	51.2625	51.2625	6401552.0
2019-04-29 11:00:00	AAPL	Stock	51.2625	51.3675	51.2025	51.2435	4103352.0
2019-04-29 11:30:00	AAPL	Stock	51.243	51.2675	51.1912	51.2225	2684112.0
2019-04-29 12:00:00	AAPL	Stock	51.2225	51.256	51.2025	51.2488	2193076.0
2019-04-29 12:30:00	AAPL	Stock	51.2475	51.3	51.245	51.2625	2118120.0
2019-04-29 13:00:00	AAPL	Stock	51.2625	51.2908	51.2275	51.28	1930408.0
2019-04-29 13:30:00	AAPL	Stock	51.28	51.28	51.195	51.2125	2219724.0
2019-04-29 14:00:00	AAPL	Stock	51.215	51.2725	51.1975	51.2495	2908984.0
2019-04-29 14:30:00	AAPL	Stock	51.25	51.3	51.23	51.286	2397580.0
2019-04-29 15:00:00	AAPL	Stock	51.2875	51.295	51.2208	51.24	2829132.0
2019-04-29 15:30:00	AAPL	Stock	51.24	51.31	51.11	51.1525	7756052.0
2019-04-29 16:00:00	AAPL	Stock	51.1525	51.155	50.825	50.925	8243296.0
2019-04-29 16:30:00	AAPL	Stock	50.9375	51.1525	50.88	50.8875	152768.0
2019-04-29 17:00:00	AAPL	Stock	50.8875	50.97	50.8625	50.97	81876.0
2019-04-29 17:30:00	AAPL	Stock	50.965	50.9875	50.85	50.8575	69980.0
2019-04-29 18:00:00	AAPL	Stock	50.85	50.8575	50.75	50.78	176420.0
2019-04-29 18:30:00	AAPL	Stock	50.77	50.85	50.765	50.765	103120.0
2019-04-29 19:00:00	AAPL	Stock	50.8	50.8225	50.7725	50.78	19532.0
2019-04-29 19:30:00	AAPL	Stock	50.77	50.8125	50.7675	50.78	86700.0
2019-04-29 04:00:00	MSFT	Stock	130.5	130.66	130.48	130.53	8050.0
2019-04-29 04:30:00	MSFT	Stock	130.5	130.65	130.4	130.42	3504.0
2019-04-29 05:00:00	MSFT	Stock	130.36	130.36	130.09	130.09	4344.0
2019-04-29 05:30:00	MSFT	Stock	130.29	130.29	130.1	130.1	1396.0
2019-04-29 06:00:00	MSFT	Stock	130.1	130.17	130.1	130.17	3406.0
2019-04-29 06:30:00	MSFT	Stock	130.19	130.19	130.0	130.0	2698.0
2019-04-29 07:00:00	MSFT	Stock	129.95	130.0	129.9	129.96	3668.0
2019-04-29 07:30:00	MSFT	Stock	130.03	130.08	130.0	130.08	3087.0
2019-04-29 08:00:00	MSFT	Stock	130.0	130.19	129.95	130.14	15924.0
2019-04-29 08:30:00	MSFT	Stock	130.12	130.17	129.9	129.94	19795.0
2019-04-29 09:00:00	MSFT	Stock	129.96	130.05	129.88	129.95	25332.0
2019-04-29 09:30:00	MSFT	Stock	129.93	130.18	129.438	129.81	2420650.0
2019-04-29 10:00:00	MSFT	Stock	129.82	129.84	129.35	129.68	929292.0
2019-04-29 10:30:00	MSFT	Stock	129.69	129.935	129.54	129.85	1077484.0
2019-04-29 11:00:00	MSFT	Stock	129.85	129.91	129.52	129.655	883985.0
2019-04-29 11:30:00	MSFT	Stock	129.66	129.73	129.49	129.525	673573.0
2019-04-29 12:00:00	MSFT	Stock	129.525	129.76	129.49	129.73	618034.0
2019-04-29 12:30:00	MSFT	Stock	129.74	129.9	129.73	129.795	456251.0

> showing 50 of 83,724 rows — these rows as CSV

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