PREVIEW / stock_30min / 2020-06-10

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-10.parquet
  size:    2.0 MB
  rows:    100,407
  symbols: 2,432

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-06-10 04:00:00	AAPL	Stock	86.505	86.82	86.505	86.7	38424.0
2020-06-10 04:30:00	AAPL	Stock	86.7375	86.7375	86.6	86.6	5996.0
2020-06-10 05:00:00	AAPL	Stock	86.505	86.505	86.375	86.4675	9388.0
2020-06-10 05:30:00	AAPL	Stock	86.495	86.495	86.4125	86.4125	2460.0
2020-06-10 06:00:00	AAPL	Stock	86.375	86.375	86.0575	86.26	10096.0
2020-06-10 06:30:00	AAPL	Stock	86.1525	86.2625	86.135	86.2625	22236.0
2020-06-10 07:00:00	AAPL	Stock	86.36	86.8725	86.33	86.775	227296.0
2020-06-10 07:30:00	AAPL	Stock	86.775	87.275	86.75	87.175	321296.0
2020-06-10 08:00:00	AAPL	Stock	86.7992	87.25	86.35	87.0	537416.0
2020-06-10 08:30:00	AAPL	Stock	87.025	87.235	87.0	87.1225	202644.0
2020-06-10 09:00:00	AAPL	Stock	87.125	87.175	86.875	86.9925	337416.0
2020-06-10 09:30:00	AAPL	Stock	86.975	87.8175	86.5225	87.6395	26126552.0
2020-06-10 10:00:00	AAPL	Stock	87.645	87.875	87.1575	87.395	13805144.0
2020-06-10 10:30:00	AAPL	Stock	87.3925	87.7	87.2625	87.47	8028908.0
2020-06-10 11:00:00	AAPL	Stock	87.4625	88.21	87.3548	88.0537	12849036.0
2020-06-10 11:30:00	AAPL	Stock	88.055	88.185	87.825	87.98	7064464.0
2020-06-10 12:00:00	AAPL	Stock	88.0015	88.1	87.61	87.9855	6286784.0
2020-06-10 12:30:00	AAPL	Stock	87.9775	88.0725	87.8925	87.9325	3641540.0
2020-06-10 13:00:00	AAPL	Stock	87.9275	88.09	87.8225	87.9025	3934148.0
2020-06-10 13:30:00	AAPL	Stock	87.895	88.025	87.8125	87.9	3527580.0
2020-06-10 14:00:00	AAPL	Stock	87.9	88.6875	87.5625	88.6675	12077132.0
2020-06-10 14:30:00	AAPL	Stock	88.675	88.6925	87.815	88.1312	9885000.0
2020-06-10 15:00:00	AAPL	Stock	88.1275	88.625	87.8475	88.6042	9115656.0
2020-06-10 15:30:00	AAPL	Stock	88.6025	88.6625	88.085	88.1875	11654456.0
2020-06-10 16:00:00	AAPL	Stock	88.21	88.2225	87.785	88.1225	6551116.0
2020-06-10 16:30:00	AAPL	Stock	88.21	88.21	88.0	88.175	94172.0
2020-06-10 17:00:00	AAPL	Stock	88.1775	88.3525	88.175	88.2225	73560.0
2020-06-10 17:30:00	AAPL	Stock	88.2125	88.25	88.2	88.2475	25688.0
2020-06-10 18:00:00	AAPL	Stock	88.25	88.3525	88.0025	88.0025	83420.0
2020-06-10 18:30:00	AAPL	Stock	88.025	88.085	87.845	87.8875	90152.0
2020-06-10 19:00:00	AAPL	Stock	87.92	87.9675	87.6375	87.725	166396.0
2020-06-10 19:30:00	AAPL	Stock	87.75	87.8375	87.6525	87.75	102972.0
2020-06-10 04:00:00	MSFT	Stock	190.41	190.87	190.41	190.87	400.0
2020-06-10 04:30:00	MSFT	Stock	190.76	190.8	190.49	190.49	1667.0
2020-06-10 05:00:00	MSFT	Stock	190.45	190.45	189.04	189.95	2515.0
2020-06-10 06:00:00	MSFT	Stock	189.85	190.0	189.28	189.95	3362.0
2020-06-10 06:30:00	MSFT	Stock	190.15	190.15	190.15	190.15	200.0
2020-06-10 07:00:00	MSFT	Stock	190.31	190.43	189.75	190.0	35751.0
2020-06-10 07:30:00	MSFT	Stock	190.08	190.8	190.08	190.8	20111.0
2020-06-10 08:00:00	MSFT	Stock	190.204	191.38	190.1	191.22	52345.0
2020-06-10 08:30:00	MSFT	Stock	191.22	191.66	191.02	191.49	46115.0
2020-06-10 09:00:00	MSFT	Stock	191.59	191.62	191.0	191.06	46983.0
2020-06-10 09:30:00	MSFT	Stock	191.1	192.8	191.01	192.73	4141623.0
2020-06-10 10:00:00	MSFT	Stock	192.73	193.65	192.21	192.9	3265717.0
2020-06-10 10:30:00	MSFT	Stock	192.91	193.97	192.71	193.43	2036671.0
2020-06-10 11:00:00	MSFT	Stock	193.427	193.97	193.31	193.65	1352204.0
2020-06-10 11:30:00	MSFT	Stock	193.65	193.74	192.98	193.06	1093904.0
2020-06-10 12:00:00	MSFT	Stock	193.08	194.42	192.81	194.357	1707648.0
2020-06-10 12:30:00	MSFT	Stock	194.355	195.26	194.085	194.991	2167608.0
2020-06-10 13:00:00	MSFT	Stock	194.995	196.271	194.89	195.91	2620272.0

> showing 50 of 100,407 rows — these rows as CSV

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