PREVIEW / stock_30min / 2019-08-23

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-23.parquet
  size:    1.7 MB
  rows:    84,750
  symbols: 2,543

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-08-23 04:00:00	AAPL	Stock	53.2875	53.2875	53.2875	53.2875	3868.0
2019-08-23 04:30:00	AAPL	Stock	53.4	53.5425	53.4	53.535	13772.0
2019-08-23 05:00:00	AAPL	Stock	53.5025	53.53	53.5	53.525	9212.0
2019-08-23 05:30:00	AAPL	Stock	53.375	53.42	53.375	53.4	7560.0
2019-08-23 06:00:00	AAPL	Stock	53.4325	53.4425	53.3375	53.3375	6872.0
2019-08-23 06:30:00	AAPL	Stock	53.2575	53.2625	53.14	53.24	20828.0
2019-08-23 07:00:00	AAPL	Stock	53.3075	53.34	53.28	53.2825	21956.0
2019-08-23 07:30:00	AAPL	Stock	53.2875	53.4	53.245	53.3625	47696.0
2019-08-23 08:00:00	AAPL	Stock	53.335	53.425	52.25	52.305	727540.0
2019-08-23 08:30:00	AAPL	Stock	52.305	52.525	52.264	52.4125	576932.0
2019-08-23 09:00:00	AAPL	Stock	52.3875	52.4375	52.175	52.3475	350644.0
2019-08-23 09:30:00	AAPL	Stock	52.3475	52.585	52.25	52.425	12868292.0
2019-08-23 10:00:00	AAPL	Stock	52.4275	52.805	52.34	52.7015	9389220.0
2019-08-23 10:30:00	AAPL	Stock	52.7062	53.0128	52.6375	52.78	7869360.0
2019-08-23 11:00:00	AAPL	Stock	52.785	52.8575	51.0525	51.4305	23113328.0
2019-08-23 11:30:00	AAPL	Stock	51.4375	51.495	50.88	50.9538	12984364.0
2019-08-23 12:00:00	AAPL	Stock	50.9575	51.1925	50.8525	51.04	8885748.0
2019-08-23 12:30:00	AAPL	Stock	51.04	51.1875	50.9238	51.0138	7074560.0
2019-08-23 13:00:00	AAPL	Stock	51.0112	51.0525	50.62	50.6525	8903368.0
2019-08-23 13:30:00	AAPL	Stock	50.6475	50.9325	50.61	50.81	6745772.0
2019-08-23 14:00:00	AAPL	Stock	50.8075	50.8075	50.6275	50.6957	5437584.0
2019-08-23 14:30:00	AAPL	Stock	50.695	50.765	50.4775	50.63	7905016.0
2019-08-23 15:00:00	AAPL	Stock	50.625	50.9095	50.605	50.7675	9179600.0
2019-08-23 15:30:00	AAPL	Stock	50.77	50.89	50.25	50.6575	19438128.0
2019-08-23 16:00:00	AAPL	Stock	50.25	50.8875	50.25	50.775	16823740.0
2019-08-23 16:30:00	AAPL	Stock	50.8075	50.8125	50.625	50.655	166296.0
2019-08-23 17:00:00	AAPL	Stock	50.7	50.7	50.5375	50.565	313388.0
2019-08-23 17:30:00	AAPL	Stock	50.575	50.575	50.325	50.3575	153908.0
2019-08-23 18:00:00	AAPL	Stock	50.375	50.4	50.325	50.3425	61852.0
2019-08-23 18:30:00	AAPL	Stock	50.3425	50.495	50.3425	50.4375	66112.0
2019-08-23 19:00:00	AAPL	Stock	50.4425	50.4675	50.375	50.45	45612.0
2019-08-23 19:30:00	AAPL	Stock	50.375	50.4525	50.375	50.45	50800.0
2019-08-23 04:00:00	MSFT	Stock	138.31	138.48	138.27	138.48	450.0
2019-08-23 04:30:00	MSFT	Stock	138.7	138.7	138.7	138.7	369.0
2019-08-23 05:30:00	MSFT	Stock	138.58	138.68	138.58	138.67	425.0
2019-08-23 06:00:00	MSFT	Stock	138.65	138.65	138.62	138.62	250.0
2019-08-23 06:30:00	MSFT	Stock	138.35	138.35	138.25	138.25	1804.0
2019-08-23 07:00:00	MSFT	Stock	138.26	138.55	138.26	138.27	1206.0
2019-08-23 07:30:00	MSFT	Stock	138.35	138.6	138.29	138.3	8275.0
2019-08-23 08:00:00	MSFT	Stock	138.35	138.592	136.54	136.8	35581.0
2019-08-23 08:30:00	MSFT	Stock	136.92	137.25	136.75	137.01	14894.0
2019-08-23 09:00:00	MSFT	Stock	137.0	137.78	136.75	137.07	118269.0
2019-08-23 09:30:00	MSFT	Stock	137.03	137.61	136.33	136.65	1981676.0
2019-08-23 10:00:00	MSFT	Stock	136.65	137.63	136.39	137.446	1735556.0
2019-08-23 10:30:00	MSFT	Stock	137.47	138.35	137.35	137.85	1500162.0
2019-08-23 11:00:00	MSFT	Stock	137.86	137.99	135.06	135.43	3039755.0
2019-08-23 11:30:00	MSFT	Stock	135.47	135.59	134.3	134.31	2186596.0
2019-08-23 12:00:00	MSFT	Stock	134.32	134.52	133.78	133.83	2197664.0
2019-08-23 12:30:00	MSFT	Stock	133.82	134.37	133.79	134.23	1588910.0
2019-08-23 13:00:00	MSFT	Stock	134.23	134.23	133.13	133.21	2379919.0

> showing 50 of 84,750 rows — these rows as CSV

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