PREVIEW / stock_30min / 2007-06-14

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-06-14.parquet
  size:    1.1 MB
  rows:    63,275
  symbols: 3,028

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-06-14 09:30:00	AAPL	Stock	4.1857	4.2604	4.1579	4.2475	221092592.0
2007-06-14 10:00:00	AAPL	Stock	4.2475	4.2554	4.2214	4.235	109657156.0
2007-06-14 10:30:00	AAPL	Stock	4.2354	4.2489	4.2171	4.2214	83161736.0
2007-06-14 11:00:00	AAPL	Stock	4.2218	4.24	4.2214	4.2346	53260816.0
2007-06-14 11:30:00	AAPL	Stock	4.2343	4.2443	4.2171	4.2225	50558144.0
2007-06-14 12:00:00	AAPL	Stock	4.2225	4.2329	4.2211	4.2293	28636216.0
2007-06-14 12:30:00	AAPL	Stock	4.2293	4.2471	4.2286	4.2418	36635536.0
2007-06-14 13:00:00	AAPL	Stock	4.2418	4.2661	4.2393	4.25	69661340.0
2007-06-14 13:30:00	AAPL	Stock	4.2504	4.2507	4.2315	4.2464	44246524.0
2007-06-14 14:00:00	AAPL	Stock	4.2461	4.2571	4.2375	4.2525	42288036.0
2007-06-14 14:30:00	AAPL	Stock	4.2532	4.2557	4.2443	4.2489	43313620.0
2007-06-14 15:00:00	AAPL	Stock	4.2489	4.2625	4.2486	4.2536	50545684.0
2007-06-14 15:30:00	AAPL	Stock	4.2536	4.2564	4.2371	4.2454	89203716.0
2007-06-14 16:00:00	AAPL	Stock	4.2457	4.2464	4.2411	4.2411	27281240.0
2007-06-14 09:30:00	MSFT	Stock	30.35	30.56	30.3	30.56	4565545.0
2007-06-14 10:00:00	MSFT	Stock	30.56	30.65	30.54	30.6	5486665.0
2007-06-14 10:30:00	MSFT	Stock	30.6	30.69	30.568	30.62	4115085.0
2007-06-14 11:00:00	MSFT	Stock	30.63	30.65	30.57	30.6	2558114.0
2007-06-14 11:30:00	MSFT	Stock	30.6	30.64	30.57	30.58	2153055.0
2007-06-14 12:00:00	MSFT	Stock	30.58	30.7	30.56	30.65	3516932.0
2007-06-14 12:30:00	MSFT	Stock	30.66	30.66	30.6	30.611	1863098.0
2007-06-14 13:00:00	MSFT	Stock	30.62	30.68	30.6	30.675	2984287.0
2007-06-14 13:30:00	MSFT	Stock	30.67	30.71	30.63	30.67	2168292.0
2007-06-14 14:00:00	MSFT	Stock	30.675	30.69	30.57	30.61	6015070.0
2007-06-14 14:30:00	MSFT	Stock	30.61	30.67	30.59	30.63	2806594.0
2007-06-14 15:00:00	MSFT	Stock	30.63	30.67	30.58	30.6	3567409.0
2007-06-14 15:30:00	MSFT	Stock	30.6	30.7	30.5	30.56	11381480.0
2007-06-14 16:00:00	MSFT	Stock	30.56	30.56	30.52	30.52	1941876.0
2007-06-14 08:00:00	NVDA	Stock	0.62	0.62	0.62	0.62	6000.0
2007-06-14 08:30:00	NVDA	Stock	0.6192	0.62	0.6158	0.6158	142200.0
2007-06-14 09:00:00	NVDA	Stock	0.6202	0.6208	0.617	0.617	234000.0
2007-06-14 09:30:00	NVDA	Stock	0.6167	0.6257	0.6158	0.6253	59889780.0
2007-06-14 10:00:00	NVDA	Stock	0.6252	0.6253	0.6178	0.6202	27151200.0
2007-06-14 10:30:00	NVDA	Stock	0.6203	0.6247	0.6197	0.6222	34905660.0
2007-06-14 11:00:00	NVDA	Stock	0.6222	0.6233	0.6208	0.6232	29727000.0
2007-06-14 11:30:00	NVDA	Stock	0.623	0.6247	0.622	0.6245	23253000.0
2007-06-14 12:00:00	NVDA	Stock	0.6247	0.6282	0.6245	0.6257	38924820.0
2007-06-14 12:30:00	NVDA	Stock	0.6257	0.6315	0.6255	0.6305	54358500.0
2007-06-14 13:00:00	NVDA	Stock	0.6305	0.6328	0.6293	0.6308	24538140.0
2007-06-14 13:30:00	NVDA	Stock	0.6307	0.6325	0.6292	0.6322	20457300.0
2007-06-14 14:00:00	NVDA	Stock	0.6322	0.6322	0.6288	0.6303	25922640.0
2007-06-14 14:30:00	NVDA	Stock	0.6302	0.6322	0.6298	0.6312	25908840.0
2007-06-14 15:00:00	NVDA	Stock	0.631	0.6327	0.631	0.6318	22054620.0
2007-06-14 15:30:00	NVDA	Stock	0.6318	0.6327	0.6292	0.6308	64404960.0
2007-06-14 16:00:00	NVDA	Stock	0.6307	0.6308	0.6266	0.6303	8729700.0
2007-06-14 16:30:00	NVDA	Stock	0.6278	0.6278	0.6278	0.6278	36000.0
2007-06-14 17:00:00	NVDA	Stock	0.6292	0.6292	0.628	0.6292	126000.0
2007-06-14 18:00:00	NVDA	Stock	0.6292	0.6292	0.6292	0.6292	60000.0
2007-06-14 19:30:00	NVDA	Stock	0.6282	0.6282	0.6282	0.6282	72000.0
2007-06-14 07:00:00	AMZN	Stock	3.511	3.5115	3.5105	3.5105	13200.0

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

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