PREVIEW / stock_30min / 2008-08-20

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-08-20.parquet
  size:    1.2 MB
  rows:    67,398
  symbols: 3,303

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
2008-08-20 07:00:00	AAPL	Stock	6.2779	6.2779	6.2232	6.2232	19600.0
2008-08-20 07:30:00	AAPL	Stock	6.2411	6.2536	6.2343	6.2507	59500.0
2008-08-20 08:00:00	AAPL	Stock	6.2507	6.2507	6.225	6.2307	752836.0
2008-08-20 08:30:00	AAPL	Stock	6.2293	6.2411	6.2257	6.2282	681268.0
2008-08-20 09:00:00	AAPL	Stock	6.2286	6.2454	6.2264	6.2421	1596280.0
2008-08-20 09:30:00	AAPL	Stock	6.2411	6.2693	6.2182	6.2629	77869988.0
2008-08-20 10:00:00	AAPL	Stock	6.2629	6.2939	6.2375	6.2593	53852988.0
2008-08-20 10:30:00	AAPL	Stock	6.26	6.3193	6.2584	6.3111	53910052.0
2008-08-20 11:00:00	AAPL	Stock	6.3129	6.3161	6.2839	6.2896	26008556.0
2008-08-20 11:30:00	AAPL	Stock	6.2889	6.29	6.2579	6.2693	24358852.0
2008-08-20 12:00:00	AAPL	Stock	6.2689	6.2807	6.2004	6.2257	41162128.0
2008-08-20 12:30:00	AAPL	Stock	6.2257	6.2571	6.2232	6.2482	25251072.0
2008-08-20 13:00:00	AAPL	Stock	6.2493	6.2825	6.2411	6.2621	28940968.0
2008-08-20 13:30:00	AAPL	Stock	6.2625	6.2671	6.2421	6.2514	18294640.0
2008-08-20 14:00:00	AAPL	Stock	6.2507	6.2539	6.2104	6.23	28753032.0
2008-08-20 14:30:00	AAPL	Stock	6.2289	6.2696	6.2168	6.2668	25787636.0
2008-08-20 15:00:00	AAPL	Stock	6.2668	6.2775	6.2379	6.2514	27249712.0
2008-08-20 15:30:00	AAPL	Stock	6.2504	6.2846	6.2311	6.2818	55288604.0
2008-08-20 16:00:00	AAPL	Stock	6.2804	6.2821	6.1975	6.2804	7074508.0
2008-08-20 16:30:00	AAPL	Stock	6.28	6.2829	6.28	6.28	97384.0
2008-08-20 17:00:00	AAPL	Stock	6.2789	6.2821	6.2789	6.2796	32312.0
2008-08-20 17:30:00	AAPL	Stock	6.2821	6.2821	6.2804	6.2804	63000.0
2008-08-20 18:00:00	AAPL	Stock	6.2789	6.2804	6.2789	6.2804	40040.0
2008-08-20 18:30:00	AAPL	Stock	6.2786	6.2829	6.2786	6.2829	20440.0
2008-08-20 19:00:00	AAPL	Stock	6.2829	6.2829	6.2796	6.2796	11200.0
2008-08-20 19:30:00	AAPL	Stock	6.2846	6.2857	6.2818	6.2821	116200.0
2008-08-20 20:00:00	AAPL	Stock	6.2675	6.2675	6.2675	6.2675	2800.0
2008-08-20 07:30:00	MSFT	Stock	27.46	27.46	27.46	27.46	1610.0
2008-08-20 08:00:00	MSFT	Stock	27.46	27.5	27.46	27.5	4580.0
2008-08-20 08:30:00	MSFT	Stock	27.47	27.53	27.47	27.53	5305.0
2008-08-20 09:00:00	MSFT	Stock	27.5	27.58	27.5	27.5	44054.0
2008-08-20 09:30:00	MSFT	Stock	27.51	27.58	27.28	27.4	3789974.0
2008-08-20 10:00:00	MSFT	Stock	27.4	27.43	27.29	27.4	3308724.0
2008-08-20 10:30:00	MSFT	Stock	27.41	27.55	27.4	27.47	4304331.0
2008-08-20 11:00:00	MSFT	Stock	27.47	27.56	27.45	27.507	2816894.0
2008-08-20 11:30:00	MSFT	Stock	27.5	27.53	27.42	27.5	2091002.0
2008-08-20 12:00:00	MSFT	Stock	27.492	27.51	27.35	27.39	2270880.0
2008-08-20 12:30:00	MSFT	Stock	27.39	27.4	27.36	27.4	1888167.0
2008-08-20 13:00:00	MSFT	Stock	27.39	27.41	27.35	27.39	1286912.0
2008-08-20 13:30:00	MSFT	Stock	27.4	27.43	27.32	27.36	2901186.0
2008-08-20 14:00:00	MSFT	Stock	27.35	27.36	27.225	27.255	2942381.0
2008-08-20 14:30:00	MSFT	Stock	27.25	27.31	27.22	27.3	1877558.0
2008-08-20 15:00:00	MSFT	Stock	27.298	27.34	27.17	27.21	2296254.0
2008-08-20 15:30:00	MSFT	Stock	27.21	27.43	27.19	27.3	5776169.0
2008-08-20 16:00:00	MSFT	Stock	27.29	27.375	27.28	27.35	1757846.0
2008-08-20 16:30:00	MSFT	Stock	27.29	27.29	27.29	27.29	12048.0
2008-08-20 17:30:00	MSFT	Stock	27.31	27.31	27.31	27.31	200.0
2008-08-20 19:30:00	MSFT	Stock	27.3	27.3	27.3	27.3	300.0
2008-08-20 20:00:00	MSFT	Stock	27.49	27.49	27.49	27.49	13400.0
2008-08-20 08:00:00	NVDA	Stock	0.3398	0.34	0.339	0.34	464000.0

> showing 50 of 67,398 rows — these rows as CSV

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