PREVIEW / stock_30min / 2019-09-06

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-09-06.parquet
  size:    1.7 MB
  rows:    82,900
  symbols: 2,555

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-06 04:00:00	AAPL	Stock	53.3025	53.3025	53.285	53.2875	1572.0
2019-09-06 04:30:00	AAPL	Stock	53.3375	53.3375	53.3375	53.3375	8740.0
2019-09-06 05:00:00	AAPL	Stock	53.315	53.4975	53.315	53.4975	18344.0
2019-09-06 05:30:00	AAPL	Stock	53.46	53.5175	53.345	53.4125	13596.0
2019-09-06 06:00:00	AAPL	Stock	53.2525	53.35	53.2275	53.325	12920.0
2019-09-06 06:30:00	AAPL	Stock	53.335	53.3675	53.335	53.3675	9708.0
2019-09-06 07:00:00	AAPL	Stock	53.4425	53.4425	53.325	53.425	84652.0
2019-09-06 07:30:00	AAPL	Stock	53.3925	53.4725	53.3875	53.47	76680.0
2019-09-06 08:00:00	AAPL	Stock	53.3502	53.4975	53.35	53.4275	167724.0
2019-09-06 08:30:00	AAPL	Stock	53.4275	53.5675	53.2675	53.4125	210496.0
2019-09-06 09:00:00	AAPL	Stock	53.415	53.55	53.395	53.495	143448.0
2019-09-06 09:30:00	AAPL	Stock	53.495	53.605	53.22	53.265	11561444.0
2019-09-06 10:00:00	AAPL	Stock	53.265	53.335	53.1275	53.2075	5839496.0
2019-09-06 10:30:00	AAPL	Stock	53.21	53.34	53.1425	53.271	4607392.0
2019-09-06 11:00:00	AAPL	Stock	53.27	53.34	53.2375	53.26	2825084.0
2019-09-06 11:30:00	AAPL	Stock	53.2625	53.3	53.1375	53.1725	2680752.0
2019-09-06 12:00:00	AAPL	Stock	53.1725	53.205	53.14	53.195	1830832.0
2019-09-06 12:30:00	AAPL	Stock	53.1975	53.2825	53.1325	53.2775	3001392.0
2019-09-06 13:00:00	AAPL	Stock	53.275	53.39	53.2675	53.375	3168204.0
2019-09-06 13:30:00	AAPL	Stock	53.3725	53.4875	53.3725	53.47	3090040.0
2019-09-06 14:00:00	AAPL	Stock	53.4712	53.4815	53.385	53.4025	2329244.0
2019-09-06 14:30:00	AAPL	Stock	53.4025	53.4475	53.3762	53.4062	2225864.0
2019-09-06 15:00:00	AAPL	Stock	53.4075	53.48	53.365	53.4675	3422556.0
2019-09-06 15:30:00	AAPL	Stock	53.465	53.4975	53.2725	53.3175	8090856.0
2019-09-06 16:00:00	AAPL	Stock	53.305	53.36	53.305	53.32	5898708.0
2019-09-06 16:30:00	AAPL	Stock	53.3125	53.3925	53.3	53.3875	52004.0
2019-09-06 17:00:00	AAPL	Stock	53.35	53.35	53.2775	53.35	26320.0
2019-09-06 17:30:00	AAPL	Stock	53.3625	53.3725	53.35	53.3625	19240.0
2019-09-06 18:00:00	AAPL	Stock	53.3625	53.375	53.3625	53.3625	5820.0
2019-09-06 18:30:00	AAPL	Stock	53.375	53.3975	53.365	53.3975	6792.0
2019-09-06 19:00:00	AAPL	Stock	53.3875	53.3975	53.38	53.38	5240.0
2019-09-06 19:30:00	AAPL	Stock	53.385	53.4375	53.385	53.425	24420.0
2019-09-06 04:00:00	MSFT	Stock	140.3	140.3	140.1	140.1	996.0
2019-09-06 05:00:00	MSFT	Stock	140.3	140.5	140.3	140.5	1204.0
2019-09-06 05:30:00	MSFT	Stock	140.51	140.51	140.15	140.15	1401.0
2019-09-06 06:00:00	MSFT	Stock	140.12	140.12	140.05	140.1	1357.0
2019-09-06 07:00:00	MSFT	Stock	140.3	140.43	140.3	140.34	1618.0
2019-09-06 07:30:00	MSFT	Stock	140.37	140.5	140.35	140.5	6292.0
2019-09-06 08:00:00	MSFT	Stock	140.51	140.55	140.26	140.55	12189.0
2019-09-06 08:30:00	MSFT	Stock	140.39	140.66	139.864	140.01	43476.0
2019-09-06 09:00:00	MSFT	Stock	139.91	140.24	139.91	140.01	19457.0
2019-09-06 09:30:00	MSFT	Stock	140.01	140.18	138.41	139.065	2738924.0
2019-09-06 10:00:00	MSFT	Stock	139.07	139.49	138.895	139.49	1375795.0
2019-09-06 10:30:00	MSFT	Stock	139.5	139.64	139.33	139.41	987035.0
2019-09-06 11:00:00	MSFT	Stock	139.41	139.46	139.07	139.195	971435.0
2019-09-06 11:30:00	MSFT	Stock	139.2	139.25	138.975	139.03	724522.0
2019-09-06 12:00:00	MSFT	Stock	139.02	139.06	138.86	138.97	573850.0
2019-09-06 12:30:00	MSFT	Stock	138.98	139.01	138.2	138.79	1510719.0
2019-09-06 13:00:00	MSFT	Stock	138.8	139.215	138.76	139.2	703389.0
2019-09-06 13:30:00	MSFT	Stock	139.195	139.46	139.19	139.42	743510.0

> showing 50 of 82,900 rows — these rows as CSV

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