PREVIEW / stock_30min / 2007-05-24

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-05-24.parquet
  size:    1.1 MB
  rows:    62,625
  symbols: 3,012

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
2007-05-24 09:30:00	AAPL	Stock	4.0289	4.0657	4.0125	4.055	95418064.0
2007-05-24 10:00:00	AAPL	Stock	4.055	4.0879	4.0529	4.0704	89127276.0
2007-05-24 10:30:00	AAPL	Stock	4.0704	4.0732	4.0289	4.0349	72476264.0
2007-05-24 11:00:00	AAPL	Stock	4.0354	4.0425	4.0075	4.0186	70652596.0
2007-05-24 11:30:00	AAPL	Stock	4.0186	4.0343	4.01	4.0325	46217080.0
2007-05-24 12:00:00	AAPL	Stock	4.0321	4.0418	4.0054	4.0139	44929416.0
2007-05-24 12:30:00	AAPL	Stock	4.0136	4.0175	3.9789	3.9979	61676048.0
2007-05-24 13:00:00	AAPL	Stock	3.9975	4.0082	3.9839	3.9986	50587348.0
2007-05-24 13:30:00	AAPL	Stock	3.9986	4.0018	3.9768	3.9929	41512240.0
2007-05-24 14:00:00	AAPL	Stock	3.9928	3.9975	3.9561	3.9664	61732916.0
2007-05-24 14:30:00	AAPL	Stock	3.9661	3.9725	3.9429	3.96	71938468.0
2007-05-24 15:00:00	AAPL	Stock	3.9604	3.9657	3.9514	3.9554	54686296.0
2007-05-24 15:30:00	AAPL	Stock	3.9554	3.9621	3.9418	3.9543	92342908.0
2007-05-24 16:00:00	AAPL	Stock	3.9525	3.9532	3.9525	3.9532	10297952.0
2007-05-24 09:30:00	MSFT	Stock	30.54	30.65	30.52	30.62	3770927.0
2007-05-24 10:00:00	MSFT	Stock	30.63	30.8	30.63	30.76	3938125.0
2007-05-24 10:30:00	MSFT	Stock	30.76	30.78	30.46	30.55	5064717.0
2007-05-24 11:00:00	MSFT	Stock	30.55	30.6	30.35	30.39	4351358.0
2007-05-24 11:30:00	MSFT	Stock	30.39	30.45	30.34	30.42	3070287.0
2007-05-24 12:00:00	MSFT	Stock	30.41	30.43	30.28	30.29	2710795.0
2007-05-24 12:30:00	MSFT	Stock	30.29	30.35	30.25	30.34	3166081.0
2007-05-24 13:00:00	MSFT	Stock	30.34	30.39	30.29	30.38	2111213.0
2007-05-24 13:30:00	MSFT	Stock	30.375	30.38	30.26	30.3	2952860.0
2007-05-24 14:00:00	MSFT	Stock	30.305	30.32	30.2	30.268	4027622.0
2007-05-24 14:30:00	MSFT	Stock	30.27	30.29	30.15	30.16	3607789.0
2007-05-24 15:00:00	MSFT	Stock	30.16	30.19	30.08	30.14	6745805.0
2007-05-24 15:30:00	MSFT	Stock	30.14	30.5	29.96	30.18	15236098.0
2007-05-24 16:00:00	MSFT	Stock	30.19	30.19	30.17	30.17	1130535.0
2007-05-24 08:00:00	NVDA	Stock	0.575	0.575	0.5733	0.5733	60000.0
2007-05-24 08:30:00	NVDA	Stock	0.5792	0.5792	0.5792	0.5792	60000.0
2007-05-24 09:00:00	NVDA	Stock	0.575	0.5755	0.5733	0.5755	36000.0
2007-05-24 09:30:00	NVDA	Stock	0.5757	0.5773	0.5655	0.5682	40823460.0
2007-05-24 10:00:00	NVDA	Stock	0.5685	0.5737	0.5655	0.568	55194780.0
2007-05-24 10:30:00	NVDA	Stock	0.568	0.5692	0.5625	0.563	68874360.0
2007-05-24 11:00:00	NVDA	Stock	0.5632	0.5637	0.5557	0.557	76631100.0
2007-05-24 11:30:00	NVDA	Stock	0.5572	0.561	0.5555	0.5608	34023180.0
2007-05-24 12:00:00	NVDA	Stock	0.5608	0.5612	0.5558	0.5558	29455680.0
2007-05-24 12:30:00	NVDA	Stock	0.5558	0.5563	0.553	0.5548	39807660.0
2007-05-24 13:00:00	NVDA	Stock	0.555	0.559	0.5547	0.5568	30813420.0
2007-05-24 13:30:00	NVDA	Stock	0.5567	0.5583	0.555	0.5563	17593860.0
2007-05-24 14:00:00	NVDA	Stock	0.5563	0.5568	0.5548	0.5552	32800560.0
2007-05-24 14:30:00	NVDA	Stock	0.5553	0.5557	0.5518	0.5525	49324200.0
2007-05-24 15:00:00	NVDA	Stock	0.5527	0.5548	0.5517	0.5523	49668900.0
2007-05-24 15:30:00	NVDA	Stock	0.5522	0.5528	0.55	0.5528	62217180.0
2007-05-24 16:00:00	NVDA	Stock	0.5523	0.5533	0.5523	0.5533	12901320.0
2007-05-24 16:30:00	NVDA	Stock	0.5538	0.5538	0.5538	0.5538	12000.0
2007-05-24 17:30:00	NVDA	Stock	0.5538	0.5538	0.5538	0.5538	6000.0
2007-05-24 18:00:00	NVDA	Stock	0.5538	0.5538	0.5538	0.5538	6000.0
2007-05-24 18:30:00	NVDA	Stock	0.5538	0.5538	0.5538	0.5538	6000.0
2007-05-24 07:30:00	AMZN	Stock	3.464	3.4645	3.464	3.4645	14800.0

> showing 50 of 62,625 rows — these rows as CSV

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