PREVIEW / stock_30min / 2007-07-19

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-07-19.parquet
  size:    1.1 MB
  rows:    64,485
  symbols: 3,052

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-07-19 09:30:00	AAPL	Stock	5.0107	5.0179	4.9875	5.0068	113491868.0
2007-07-19 10:00:00	AAPL	Stock	5.0061	5.0243	4.9961	5.0154	83143340.0
2007-07-19 10:30:00	AAPL	Stock	5.0161	5.0171	4.9946	5.005	67055128.0
2007-07-19 11:00:00	AAPL	Stock	5.0054	5.0289	5.005	5.0096	73721620.0
2007-07-19 11:30:00	AAPL	Stock	5.0096	5.0128	5.0032	5.0075	41681668.0
2007-07-19 12:00:00	AAPL	Stock	5.0071	5.0204	5.0018	5.0146	36233456.0
2007-07-19 12:30:00	AAPL	Stock	5.015	5.0196	5.0107	5.0154	23910852.0
2007-07-19 13:00:00	AAPL	Stock	5.0157	5.0157	5.0061	5.0136	20011628.0
2007-07-19 13:30:00	AAPL	Stock	5.0132	5.0225	5.0082	5.0179	28428456.0
2007-07-19 14:00:00	AAPL	Stock	5.0179	5.0179	5.0039	5.0104	42494116.0
2007-07-19 14:30:00	AAPL	Stock	5.0104	5.0156	5.0043	5.0096	30092944.0
2007-07-19 15:00:00	AAPL	Stock	5.0093	5.015	5.0032	5.01	39094160.0
2007-07-19 15:30:00	AAPL	Stock	5.0096	5.0193	4.9946	4.9957	61230540.0
2007-07-19 16:00:00	AAPL	Stock	4.995	5.0	4.9946	5.0	19863256.0
2007-07-19 09:30:00	MSFT	Stock	31.05	31.1	30.96	31.05	5951834.0
2007-07-19 10:00:00	MSFT	Stock	31.05	31.11	30.93	31.04	7446748.0
2007-07-19 10:30:00	MSFT	Stock	31.04	31.11	31.01	31.11	4959252.0
2007-07-19 11:00:00	MSFT	Stock	31.105	31.25	31.09	31.235	8559597.0
2007-07-19 11:30:00	MSFT	Stock	31.23	31.45	31.22	31.4	9771659.0
2007-07-19 12:00:00	MSFT	Stock	31.41	31.49	31.31	31.48	7186557.0
2007-07-19 12:30:00	MSFT	Stock	31.49	31.49	31.351	31.47	5546018.0
2007-07-19 13:00:00	MSFT	Stock	31.47	31.54	31.4	31.51	7234258.0
2007-07-19 13:30:00	MSFT	Stock	31.52	31.57	31.46	31.49	6248970.0
2007-07-19 14:00:00	MSFT	Stock	31.49	31.533	31.4	31.51	6445977.0
2007-07-19 14:30:00	MSFT	Stock	31.51	31.56	31.44	31.54	5381679.0
2007-07-19 15:00:00	MSFT	Stock	31.54	31.79	31.53	31.77	13755278.0
2007-07-19 15:30:00	MSFT	Stock	31.76	31.84	31.5	31.51	17150134.0
2007-07-19 16:00:00	MSFT	Stock	31.51	31.55	31.51	31.51	1856372.0
2007-07-19 08:00:00	NVDA	Stock	0.7667	0.7742	0.7667	0.7742	24000.0
2007-07-19 08:30:00	NVDA	Stock	0.7662	0.7733	0.7662	0.7708	78000.0
2007-07-19 09:00:00	NVDA	Stock	0.7708	0.7708	0.7685	0.7695	449340.0
2007-07-19 09:30:00	NVDA	Stock	0.7713	0.7755	0.7667	0.7692	37021860.0
2007-07-19 10:00:00	NVDA	Stock	0.769	0.769	0.7618	0.7642	27656160.0
2007-07-19 10:30:00	NVDA	Stock	0.7645	0.7658	0.755	0.756	31449240.0
2007-07-19 11:00:00	NVDA	Stock	0.756	0.7607	0.7546	0.7557	29514000.0
2007-07-19 11:30:00	NVDA	Stock	0.7555	0.7587	0.7555	0.758	15803220.0
2007-07-19 12:00:00	NVDA	Stock	0.7582	0.7583	0.756	0.7575	18242700.0
2007-07-19 12:30:00	NVDA	Stock	0.7575	0.7612	0.7572	0.7603	18754920.0
2007-07-19 13:00:00	NVDA	Stock	0.7602	0.7628	0.76	0.7612	21687960.0
2007-07-19 13:30:00	NVDA	Stock	0.7612	0.7615	0.758	0.7597	17626920.0
2007-07-19 14:00:00	NVDA	Stock	0.7597	0.7597	0.7557	0.7567	17360640.0
2007-07-19 14:30:00	NVDA	Stock	0.7565	0.7575	0.756	0.757	19836600.0
2007-07-19 15:00:00	NVDA	Stock	0.757	0.7617	0.757	0.7605	32273460.0
2007-07-19 15:30:00	NVDA	Stock	0.7605	0.7632	0.7597	0.7597	42683700.0
2007-07-19 16:00:00	NVDA	Stock	0.76	0.76	0.7567	0.7567	56575860.0
2007-07-19 16:30:00	NVDA	Stock	0.759	0.759	0.759	0.759	215220.0
2007-07-19 17:00:00	NVDA	Stock	0.7552	0.7552	0.7542	0.7542	658020.0
2007-07-19 17:30:00	NVDA	Stock	0.7567	0.7567	0.7525	0.7525	18000.0
2007-07-19 19:30:00	NVDA	Stock	0.7582	0.7582	0.7582	0.7582	18000.0
2007-07-19 07:30:00	AMZN	Stock	3.695	3.7095	3.695	3.7095	52000.0

> showing 50 of 64,485 rows — these rows as CSV

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