PREVIEW / stock_30min / 2007-09-24

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-09-24.parquet
  size:    1.2 MB
  rows:    67,361
  symbols: 3,124

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-09-24 05:30:00	AAPL	Stock	5.1493	5.1582	5.1493	5.1582	27776.0
2007-09-24 07:00:00	AAPL	Stock	5.1729	5.1929	5.1696	5.1857	851144.0
2007-09-24 07:30:00	AAPL	Stock	5.1889	5.2196	5.1889	5.2125	4669980.0
2007-09-24 08:00:00	AAPL	Stock	5.2136	5.2575	5.2071	5.25	11611488.0
2007-09-24 08:30:00	AAPL	Stock	5.25	5.2554	5.2321	5.2479	5072732.0
2007-09-24 09:00:00	AAPL	Stock	5.2464	5.2507	5.235	5.2396	6927172.0
2007-09-24 09:30:00	AAPL	Stock	5.2404	5.3304	5.2375	5.2961	252217308.0
2007-09-24 10:00:00	AAPL	Stock	5.2964	5.3393	5.2821	5.3382	124180364.0
2007-09-24 10:30:00	AAPL	Stock	5.3382	5.3518	5.3036	5.343	87008936.0
2007-09-24 11:00:00	AAPL	Stock	5.3432	5.3443	5.3068	5.3218	72292024.0
2007-09-24 11:30:00	AAPL	Stock	5.3217	5.325	5.3057	5.3129	33689376.0
2007-09-24 12:00:00	AAPL	Stock	5.3132	5.3268	5.3093	5.3221	28968800.0
2007-09-24 12:30:00	AAPL	Stock	5.3221	5.3268	5.3093	5.3121	26131980.0
2007-09-24 13:00:00	AAPL	Stock	5.3121	5.3161	5.2914	5.2965	45800244.0
2007-09-24 13:30:00	AAPL	Stock	5.2965	5.2979	5.2625	5.2722	75223512.0
2007-09-24 14:00:00	AAPL	Stock	5.2721	5.2911	5.2636	5.2714	51706312.0
2007-09-24 14:30:00	AAPL	Stock	5.2718	5.2846	5.2496	5.2814	66678024.0
2007-09-24 15:00:00	AAPL	Stock	5.2804	5.3068	5.2636	5.3021	61303368.0
2007-09-24 15:30:00	AAPL	Stock	5.3021	5.3036	5.2804	5.3014	64848784.0
2007-09-24 16:00:00	AAPL	Stock	5.3014	5.3198	5.2891	5.2971	27759452.0
2007-09-24 16:30:00	AAPL	Stock	5.2989	5.3	5.2818	5.2932	1154328.0
2007-09-24 17:00:00	AAPL	Stock	5.2929	5.2961	5.2874	5.2921	445032.0
2007-09-24 17:30:00	AAPL	Stock	5.2893	5.2957	5.2871	5.2929	637896.0
2007-09-24 18:00:00	AAPL	Stock	5.2929	5.2929	5.2639	5.2643	1357468.0
2007-09-24 18:30:00	AAPL	Stock	5.2639	5.2725	5.2639	5.2646	831012.0
2007-09-24 19:00:00	AAPL	Stock	5.2661	5.2714	5.2646	5.2679	248304.0
2007-09-24 19:30:00	AAPL	Stock	5.2707	5.2725	5.2679	5.2696	529480.0
2007-09-24 06:30:00	MSFT	Stock	28.67	28.67	28.67	28.67	2000.0
2007-09-24 07:00:00	MSFT	Stock	28.7	28.71	28.7	28.7	40140.0
2007-09-24 07:30:00	MSFT	Stock	28.8	28.87	28.8	28.87	6500.0
2007-09-24 08:00:00	MSFT	Stock	28.86	28.91	28.65	28.89	68905.0
2007-09-24 08:30:00	MSFT	Stock	28.89	28.92	28.88	28.9	147740.0
2007-09-24 09:00:00	MSFT	Stock	28.9	28.93	28.81	28.81	294311.0
2007-09-24 09:30:00	MSFT	Stock	28.82	29.13	28.8	29.01	12568850.0
2007-09-24 10:00:00	MSFT	Stock	29.02	29.5	29.0	29.49	11681327.0
2007-09-24 10:30:00	MSFT	Stock	29.49	29.49	29.39	29.45	9851168.0
2007-09-24 11:00:00	MSFT	Stock	29.45	29.59	29.421	29.53	7481543.0
2007-09-24 11:30:00	MSFT	Stock	29.53	29.61	29.5	29.6	5808503.0
2007-09-24 12:00:00	MSFT	Stock	29.6	29.6	29.51	29.53	4075512.0
2007-09-24 12:30:00	MSFT	Stock	29.53	29.56	29.45	29.53	4163954.0
2007-09-24 13:00:00	MSFT	Stock	29.53	29.53	29.37	29.38	3667557.0
2007-09-24 13:30:00	MSFT	Stock	29.38	29.38	29.3	29.34	5307838.0
2007-09-24 14:00:00	MSFT	Stock	29.34	29.4	29.33	29.34	4166554.0
2007-09-24 14:30:00	MSFT	Stock	29.34	29.47	29.32	29.38	7050059.0
2007-09-24 15:00:00	MSFT	Stock	29.38	29.4	29.27	29.29	5740303.0
2007-09-24 15:30:00	MSFT	Stock	29.29	29.3	29.05	29.08	14846939.0
2007-09-24 16:00:00	MSFT	Stock	29.084	29.52	29.01	29.15	5489948.0
2007-09-24 16:30:00	MSFT	Stock	29.15	29.36	29.08	29.08	2723106.0
2007-09-24 17:00:00	MSFT	Stock	29.08	29.207	29.08	29.207	51808.0
2007-09-24 17:30:00	MSFT	Stock	29.09	29.2	29.07	29.15	17025.0

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

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