PREVIEW / stock_30min / 2007-12-24

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-12-24.parquet
  size:    785 KB
  rows:    39,889
  symbols: 3,205

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-12-24 04:00:00	AAPL	Stock	6.8757	6.8757	6.8757	6.8757	26600.0
2007-12-24 07:00:00	AAPL	Stock	6.8757	6.9464	6.8757	6.9464	169400.0
2007-12-24 07:30:00	AAPL	Stock	6.9464	6.9464	6.9339	6.9429	83608.0
2007-12-24 08:00:00	AAPL	Stock	6.9429	6.9593	6.9286	6.9557	2212896.0
2007-12-24 08:30:00	AAPL	Stock	6.9525	6.9857	6.9464	6.9786	3864616.0
2007-12-24 09:00:00	AAPL	Stock	6.9786	6.9818	6.9254	6.9646	13595120.0
2007-12-24 09:30:00	AAPL	Stock	6.9654	7.0054	6.9568	7.0039	91841484.0
2007-12-24 10:00:00	AAPL	Stock	7.0025	7.0568	7.0025	7.0429	78092140.0
2007-12-24 10:30:00	AAPL	Stock	7.0425	7.0579	7.0357	7.0564	47696124.0
2007-12-24 11:00:00	AAPL	Stock	7.0564	7.0839	7.0518	7.0707	57364048.0
2007-12-24 11:30:00	AAPL	Stock	7.07	7.0893	7.0668	7.0879	28358736.0
2007-12-24 12:00:00	AAPL	Stock	7.0879	7.1025	7.0721	7.0814	46024580.0
2007-12-24 12:30:00	AAPL	Stock	7.0807	7.1189	7.0804	7.1	83288604.0
2007-12-24 13:00:00	AAPL	Stock	7.1	7.1018	7.052	7.0971	4275124.0
2007-12-24 13:30:00	AAPL	Stock	7.0964	7.1	7.052	7.1	22819916.0
2007-12-24 14:00:00	AAPL	Stock	7.0954	7.0954	7.0911	7.0946	190624.0
2007-12-24 14:30:00	AAPL	Stock	7.0946	7.1	7.0911	7.095	186816.0
2007-12-24 15:00:00	AAPL	Stock	7.0911	7.0982	7.0896	7.0982	75600.0
2007-12-24 15:30:00	AAPL	Stock	7.0975	7.0975	7.0932	7.0932	30744.0
2007-12-24 16:00:00	AAPL	Stock	7.0964	7.1	7.0964	7.1	26852.0
2007-12-24 16:30:00	AAPL	Stock	7.0946	7.0982	7.0929	7.0982	49448.0
2007-12-24 07:30:00	MSFT	Stock	36.07	36.07	36.07	36.07	100.0
2007-12-24 08:00:00	MSFT	Stock	36.19	36.19	36.15	36.15	2086.0
2007-12-24 08:30:00	MSFT	Stock	36.12	36.19	36.1	36.18	7291.0
2007-12-24 09:00:00	MSFT	Stock	36.18	36.2	36.05	36.1	552242.0
2007-12-24 09:30:00	MSFT	Stock	36.11	36.7	36.05	36.62	4674206.0
2007-12-24 10:00:00	MSFT	Stock	36.62	36.66	36.5	36.63	3765154.0
2007-12-24 10:30:00	MSFT	Stock	36.63	36.71	36.56	36.71	2786555.0
2007-12-24 11:00:00	MSFT	Stock	36.71	36.71	36.6	36.66	2473072.0
2007-12-24 11:30:00	MSFT	Stock	36.67	36.69	36.6	36.61	1892728.0
2007-12-24 12:00:00	MSFT	Stock	36.6	36.67	36.55	36.66	2709394.0
2007-12-24 12:30:00	MSFT	Stock	36.665	36.72	36.56	36.62	4764579.0
2007-12-24 13:00:00	MSFT	Stock	36.58	36.68	36.55	36.58	5972242.0
2007-12-24 13:30:00	MSFT	Stock	36.67	36.78	36.57	36.6	21271.0
2007-12-24 15:00:00	MSFT	Stock	36.6	36.6	36.6	36.6	100.0
2007-12-24 15:30:00	MSFT	Stock	36.61	36.61	36.58	36.58	884.0
2007-12-24 16:00:00	MSFT	Stock	36.65	36.74	36.65	36.74	677.0
2007-12-24 08:30:00	NVDA	Stock	0.8798	0.88	0.8798	0.88	12000.0
2007-12-24 09:00:00	NVDA	Stock	0.8812	0.8855	0.879	0.8855	128880.0
2007-12-24 09:30:00	NVDA	Stock	0.8835	0.8892	0.879	0.8852	20947520.0
2007-12-24 10:00:00	NVDA	Stock	0.8852	0.8908	0.8852	0.8883	12088040.0
2007-12-24 10:30:00	NVDA	Stock	0.888	0.8938	0.8855	0.8933	13792840.0
2007-12-24 11:00:00	NVDA	Stock	0.8932	0.8933	0.8885	0.8921	9110440.0
2007-12-24 11:30:00	NVDA	Stock	0.892	0.8938	0.8912	0.893	8887240.0
2007-12-24 12:00:00	NVDA	Stock	0.893	0.8935	0.8898	0.8912	11098040.0
2007-12-24 12:30:00	NVDA	Stock	0.8912	0.8988	0.8912	0.8948	23926480.0
2007-12-24 13:00:00	NVDA	Stock	0.8948	0.897	0.8899	0.8945	3927200.0
2007-12-24 13:30:00	NVDA	Stock	0.8945	0.8945	0.894	0.894	52560.0
2007-12-24 14:30:00	NVDA	Stock	0.8963	0.8975	0.8963	0.8975	17600.0
2007-12-24 15:30:00	NVDA	Stock	0.8945	0.8945	0.8945	0.8945	4000.0

> showing 50 of 39,889 rows — these rows as CSV

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