PREVIEW / stock_30min / 2007-05-23

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-05-23.parquet
  size:    1.1 MB
  rows:    63,572
  symbols: 3,013

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-23 09:30:00	AAPL	Stock	4.0721	4.1029	4.0686	4.095	97150340.0
2007-05-23 10:00:00	AAPL	Stock	4.095	4.1029	4.0879	4.0971	68453280.0
2007-05-23 10:30:00	AAPL	Stock	4.0971	4.1071	4.0893	4.1029	59994172.0
2007-05-23 11:00:00	AAPL	Stock	4.1032	4.1036	4.0836	4.0954	54378464.0
2007-05-23 11:30:00	AAPL	Stock	4.0957	4.1036	4.0893	4.0968	24535560.0
2007-05-23 12:00:00	AAPL	Stock	4.0968	4.1	4.0704	4.0843	77202384.0
2007-05-23 12:30:00	AAPL	Stock	4.0843	4.0946	4.0821	4.0889	30723868.0
2007-05-23 13:00:00	AAPL	Stock	4.0893	4.0914	4.0714	4.0814	33461736.0
2007-05-23 13:30:00	AAPL	Stock	4.0811	4.0904	4.0357	4.0418	75270916.0
2007-05-23 14:00:00	AAPL	Stock	4.0421	4.0496	4.0211	4.0379	116645676.0
2007-05-23 14:30:00	AAPL	Stock	4.0379	4.0643	4.0268	4.0597	75945100.0
2007-05-23 15:00:00	AAPL	Stock	4.06	4.0621	4.0404	4.05	55431880.0
2007-05-23 15:30:00	AAPL	Stock	4.05	4.055	4.0289	4.0318	69087424.0
2007-05-23 16:00:00	AAPL	Stock	4.0318	4.0321	4.0318	4.0318	4940572.0
2007-05-23 09:30:00	MSFT	Stock	30.84	30.84	30.61	30.655	4253604.0
2007-05-23 10:00:00	MSFT	Stock	30.641	30.71	30.61	30.61	3131217.0
2007-05-23 10:30:00	MSFT	Stock	30.618	30.65	30.59	30.6	3398516.0
2007-05-23 11:00:00	MSFT	Stock	30.6	30.67	30.57	30.662	3208588.0
2007-05-23 11:30:00	MSFT	Stock	30.66	30.74	30.64	30.71	2334829.0
2007-05-23 12:00:00	MSFT	Stock	30.7	30.72	30.65	30.71	1143944.0
2007-05-23 12:30:00	MSFT	Stock	30.71	30.79	30.7	30.77	1607091.0
2007-05-23 13:00:00	MSFT	Stock	30.77	30.79	30.76	30.79	1067376.0
2007-05-23 13:30:00	MSFT	Stock	30.78	30.79	30.73	30.77	4350699.0
2007-05-23 14:00:00	MSFT	Stock	30.77	30.83	30.69	30.74	5262222.0
2007-05-23 14:30:00	MSFT	Stock	30.74	30.82	30.72	30.78	2704002.0
2007-05-23 15:00:00	MSFT	Stock	30.79	30.81	30.74	30.79	2154338.0
2007-05-23 15:30:00	MSFT	Stock	30.79	30.8	30.58	30.58	7606672.0
2007-05-23 16:00:00	MSFT	Stock	30.58	30.58	30.58	30.58	1235108.0
2007-05-23 09:00:00	NVDA	Stock	0.5883	0.5913	0.5872	0.5913	414180.0
2007-05-23 09:30:00	NVDA	Stock	0.589	0.5925	0.5877	0.5898	39088140.0
2007-05-23 10:00:00	NVDA	Stock	0.5899	0.5908	0.5847	0.5858	34706280.0
2007-05-23 10:30:00	NVDA	Stock	0.5857	0.5867	0.5835	0.5838	27968160.0
2007-05-23 11:00:00	NVDA	Stock	0.5838	0.5857	0.5833	0.5855	12948420.0
2007-05-23 11:30:00	NVDA	Stock	0.5855	0.5865	0.5838	0.585	18149040.0
2007-05-23 12:00:00	NVDA	Stock	0.585	0.5853	0.5803	0.5817	30619260.0
2007-05-23 12:30:00	NVDA	Stock	0.5815	0.5823	0.5797	0.58	30021120.0
2007-05-23 13:00:00	NVDA	Stock	0.58	0.5808	0.5792	0.58	25191660.0
2007-05-23 13:30:00	NVDA	Stock	0.58	0.58	0.5767	0.577	27424620.0
2007-05-23 14:00:00	NVDA	Stock	0.5772	0.5775	0.5713	0.5715	62660700.0
2007-05-23 14:30:00	NVDA	Stock	0.5717	0.5757	0.5715	0.5747	36028860.0
2007-05-23 15:00:00	NVDA	Stock	0.5745	0.5752	0.5723	0.575	28684620.0
2007-05-23 15:30:00	NVDA	Stock	0.575	0.5763	0.5728	0.573	55308900.0
2007-05-23 16:00:00	NVDA	Stock	0.5733	0.5733	0.573	0.5732	409560.0
2007-05-23 16:30:00	NVDA	Stock	0.5732	0.5732	0.5718	0.5718	813180.0
2007-05-23 17:30:00	NVDA	Stock	0.572	0.5733	0.572	0.5733	72000.0
2007-05-23 18:00:00	NVDA	Stock	0.5738	0.5738	0.5738	0.5738	42000.0
2007-05-23 06:00:00	AMZN	Stock	3.45	3.45	3.45	3.45	2000.0
2007-05-23 07:30:00	AMZN	Stock	3.4475	3.4475	3.4475	3.4475	4000.0
2007-05-23 08:00:00	AMZN	Stock	3.4535	3.468	3.4535	3.4605	504580.0
2007-05-23 08:30:00	AMZN	Stock	3.4605	3.4675	3.46	3.4675	855780.0

> showing 50 of 63,572 rows — these rows as CSV

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