PREVIEW / stock_30min / 2008-04-01

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-04-01.parquet
  size:    1.2 MB
  rows:    70,851
  symbols: 3,266

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-04-01 05:30:00	AAPL	Stock	5.1575	5.1646	5.1575	5.1646	6916.0
2008-04-01 06:00:00	AAPL	Stock	5.1464	5.1464	5.1464	5.1464	5600.0
2008-04-01 06:30:00	AAPL	Stock	5.1696	5.1696	5.1696	5.1696	3752.0
2008-04-01 07:00:00	AAPL	Stock	5.1911	5.1929	5.1786	5.1786	217560.0
2008-04-01 07:30:00	AAPL	Stock	5.175	5.1954	5.175	5.1946	308616.0
2008-04-01 08:00:00	AAPL	Stock	5.1875	5.2064	5.125	5.1982	3362100.0
2008-04-01 08:30:00	AAPL	Stock	5.1993	5.2232	5.125	5.2161	2796836.0
2008-04-01 09:00:00	AAPL	Stock	5.2161	5.2268	5.2143	5.225	2936472.0
2008-04-01 09:30:00	AAPL	Stock	5.2246	5.2407	5.1979	5.2104	106829940.0
2008-04-01 10:00:00	AAPL	Stock	5.2114	5.2289	5.1968	5.2104	81554676.0
2008-04-01 10:30:00	AAPL	Stock	5.2114	5.2129	5.1782	5.1886	80827040.0
2008-04-01 11:00:00	AAPL	Stock	5.1882	5.2461	5.1861	5.2339	78651160.0
2008-04-01 11:30:00	AAPL	Stock	5.2336	5.2714	5.2325	5.2692	68396160.0
2008-04-01 12:00:00	AAPL	Stock	5.2693	5.2929	5.2671	5.2761	70942592.0
2008-04-01 12:30:00	AAPL	Stock	5.2764	5.285	5.2589	5.2661	41571824.0
2008-04-01 13:00:00	AAPL	Stock	5.2668	5.2932	5.2546	5.2854	43504468.0
2008-04-01 13:30:00	AAPL	Stock	5.2854	5.2857	5.2629	5.2696	43687168.0
2008-04-01 14:00:00	AAPL	Stock	5.2704	5.2714	5.2468	5.2486	61257952.0
2008-04-01 14:30:00	AAPL	Stock	5.2489	5.2982	5.2475	5.2729	95763388.0
2008-04-01 15:00:00	AAPL	Stock	5.2725	5.3025	5.2718	5.2936	61097036.0
2008-04-01 15:30:00	AAPL	Stock	5.2936	5.345	5.2804	5.3432	151249140.0
2008-04-01 16:00:00	AAPL	Stock	5.3407	5.35	5.125	5.3479	19780880.0
2008-04-01 16:30:00	AAPL	Stock	5.3479	5.3496	5.2618	5.3464	687316.0
2008-04-01 17:00:00	AAPL	Stock	5.3464	5.3625	5.2628	5.3489	3058832.0
2008-04-01 17:30:00	AAPL	Stock	5.3518	5.3746	5.3493	5.3675	738612.0
2008-04-01 18:00:00	AAPL	Stock	5.3671	5.3679	5.2661	5.3525	464772.0
2008-04-01 18:30:00	AAPL	Stock	5.3525	5.3571	5.35	5.3543	191072.0
2008-04-01 19:00:00	AAPL	Stock	5.3504	5.3643	5.3504	5.3589	163128.0
2008-04-01 19:30:00	AAPL	Stock	5.3607	5.3643	5.3589	5.3643	289380.0
2008-04-01 07:00:00	MSFT	Stock	28.4	28.5	28.4	28.5	5100.0
2008-04-01 07:30:00	MSFT	Stock	28.5	28.69	28.5	28.61	56097.0
2008-04-01 08:00:00	MSFT	Stock	28.6	28.66	28.38	28.6	69577.0
2008-04-01 08:30:00	MSFT	Stock	28.61	28.67	28.38	28.61	63855.0
2008-04-01 09:00:00	MSFT	Stock	28.38	28.84	28.38	28.82	230820.0
2008-04-01 09:30:00	MSFT	Stock	28.82	28.84	28.63	28.69	4979498.0
2008-04-01 10:00:00	MSFT	Stock	28.7	29.0	28.69	28.98	7088848.0
2008-04-01 10:30:00	MSFT	Stock	28.99	29.23	28.97	29.21	6656834.0
2008-04-01 11:00:00	MSFT	Stock	29.21	29.33	29.21	29.25	6542290.0
2008-04-01 11:30:00	MSFT	Stock	29.26	29.29	29.17	29.23	3134441.0
2008-04-01 12:00:00	MSFT	Stock	29.23	29.3	29.2	29.262	2741846.0
2008-04-01 12:30:00	MSFT	Stock	29.26	29.27	29.15	29.15	2255277.0
2008-04-01 13:00:00	MSFT	Stock	29.15	29.25	29.09	29.21	3042160.0
2008-04-01 13:30:00	MSFT	Stock	29.21	29.29	29.2	29.26	2290146.0
2008-04-01 14:00:00	MSFT	Stock	29.26	29.3	29.2	29.28	2764361.0
2008-04-01 14:30:00	MSFT	Stock	29.27	29.42	29.24	29.38	4540955.0
2008-04-01 15:00:00	MSFT	Stock	29.371	29.44	29.36	29.41	4733186.0
2008-04-01 15:30:00	MSFT	Stock	29.42	29.54	29.31	29.51	9243046.0
2008-04-01 16:00:00	MSFT	Stock	29.51	29.52	28.38	29.47	3870048.0
2008-04-01 16:30:00	MSFT	Stock	29.209	29.49	29.209	29.49	36700.0
2008-04-01 17:00:00	MSFT	Stock	29.49	29.53	29.48	29.5	30833.0

> showing 50 of 70,851 rows — these rows as CSV

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