PREVIEW / stock_30min / 2019-09-13

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-09-13.parquet
  size:    1.7 MB
  rows:    85,451
  symbols: 2,550

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-09-13 04:00:00	AAPL	Stock	55.925	55.94	55.8725	55.8725	9696.0
2019-09-13 04:30:00	AAPL	Stock	55.835	55.8375	55.835	55.8375	4968.0
2019-09-13 05:00:00	AAPL	Stock	55.8375	55.865	55.8375	55.865	5120.0
2019-09-13 05:30:00	AAPL	Stock	55.8525	55.8525	55.7875	55.7875	40820.0
2019-09-13 06:00:00	AAPL	Stock	55.7575	55.7575	55.175	55.3725	108664.0
2019-09-13 06:30:00	AAPL	Stock	55.33	55.4625	55.3025	55.4425	74196.0
2019-09-13 07:00:00	AAPL	Stock	55.4425	55.625	55.3775	55.445	306808.0
2019-09-13 07:30:00	AAPL	Stock	55.4425	55.5625	55.4275	55.4625	184192.0
2019-09-13 08:00:00	AAPL	Stock	55.4775	55.6225	55.3875	55.4388	449908.0
2019-09-13 08:30:00	AAPL	Stock	55.44	55.5	55.0325	55.0575	1357900.0
2019-09-13 09:00:00	AAPL	Stock	55.055	55.125	54.895	54.995	1069528.0
2019-09-13 09:30:00	AAPL	Stock	55.0	55.1975	54.705	54.9525	24092388.0
2019-09-13 10:00:00	AAPL	Stock	54.9575	54.97	54.7078	54.84	10727788.0
2019-09-13 10:30:00	AAPL	Stock	54.8432	54.87	54.5875	54.7125	9397108.0
2019-09-13 11:00:00	AAPL	Stock	54.7175	54.82	54.6625	54.705	5132524.0
2019-09-13 11:30:00	AAPL	Stock	54.7025	54.725	54.55	54.5525	4917508.0
2019-09-13 12:00:00	AAPL	Stock	54.55	54.625	54.3475	54.4725	7991264.0
2019-09-13 12:30:00	AAPL	Stock	54.4712	54.4975	54.27	54.46	7272120.0
2019-09-13 13:00:00	AAPL	Stock	54.46	54.5225	54.365	54.3775	4555656.0
2019-09-13 13:30:00	AAPL	Stock	54.3775	54.4252	54.255	54.304	5204956.0
2019-09-13 14:00:00	AAPL	Stock	54.3025	54.9125	54.3025	54.6775	15896752.0
2019-09-13 14:30:00	AAPL	Stock	54.6762	54.9525	54.675	54.8812	6906348.0
2019-09-13 15:00:00	AAPL	Stock	54.8825	54.885	54.63	54.7625	5015700.0
2019-09-13 15:30:00	AAPL	Stock	54.76	54.81	54.5925	54.7	10799772.0
2019-09-13 16:00:00	AAPL	Stock	54.6875	54.715	54.625	54.6875	7492792.0
2019-09-13 16:30:00	AAPL	Stock	54.655	54.6875	54.655	54.6725	45764.0
2019-09-13 17:00:00	AAPL	Stock	54.655	54.6875	54.635	54.65	103700.0
2019-09-13 17:30:00	AAPL	Stock	54.65	54.665	54.6375	54.65	42072.0
2019-09-13 18:00:00	AAPL	Stock	54.64	54.65	54.64	54.645	21816.0
2019-09-13 18:30:00	AAPL	Stock	54.645	54.65	54.6375	54.64	22112.0
2019-09-13 19:00:00	AAPL	Stock	54.65	54.67	54.64	54.65	22056.0
2019-09-13 19:30:00	AAPL	Stock	54.6575	54.6575	54.6025	54.6125	44192.0
2019-09-13 04:00:00	MSFT	Stock	137.63	137.81	137.63	137.7	3706.0
2019-09-13 04:30:00	MSFT	Stock	137.65	137.81	137.65	137.81	1600.0
2019-09-13 05:00:00	MSFT	Stock	137.7	137.85	137.7	137.85	1718.0
2019-09-13 05:30:00	MSFT	Stock	137.8	137.8	137.8	137.8	100.0
2019-09-13 06:00:00	MSFT	Stock	137.86	137.9	137.86	137.9	1078.0
2019-09-13 06:30:00	MSFT	Stock	137.9	138.33	137.9	138.33	9144.0
2019-09-13 07:00:00	MSFT	Stock	138.13	138.35	138.05	138.25	9176.0
2019-09-13 07:30:00	MSFT	Stock	138.28	138.28	138.05	138.05	12019.0
2019-09-13 08:00:00	MSFT	Stock	138.3	138.4	138.01	138.08	21057.0
2019-09-13 08:30:00	MSFT	Stock	138.14	138.15	137.7	137.75	28832.0
2019-09-13 09:00:00	MSFT	Stock	137.758	137.86	137.29	137.77	35869.0
2019-09-13 09:30:00	MSFT	Stock	137.79	138.0	136.57	137.37	2165206.0
2019-09-13 10:00:00	MSFT	Stock	137.37	137.84	136.98	137.78	1160300.0
2019-09-13 10:30:00	MSFT	Stock	137.78	137.99	137.54	137.76	1179489.0
2019-09-13 11:00:00	MSFT	Stock	137.76	138.06	137.33	137.37	1015361.0
2019-09-13 11:30:00	MSFT	Stock	137.36	137.63	137.215	137.43	785369.0
2019-09-13 12:00:00	MSFT	Stock	137.43	137.68	137.33	137.385	717056.0
2019-09-13 12:30:00	MSFT	Stock	137.38	137.45	137.21	137.28	667268.0

> showing 50 of 85,451 rows — these rows as CSV

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