PREVIEW / stock_30min / 2009-04-09

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-04-09.parquet
  size:    1.3 MB
  rows:    72,548
  symbols: 3,364

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
2009-04-09 07:30:00	AAPL	Stock	4.1643	4.1643	4.1643	4.1643	2800.0
2009-04-09 08:00:00	AAPL	Stock	4.1779	4.2357	4.1779	4.2232	1536864.0
2009-04-09 08:30:00	AAPL	Stock	4.2232	4.245	4.2214	4.2429	1630216.0
2009-04-09 09:00:00	AAPL	Stock	4.2443	4.2443	4.2243	4.2321	1991584.0
2009-04-09 09:30:00	AAPL	Stock	4.2318	4.2671	4.2129	4.2586	85055684.0
2009-04-09 10:00:00	AAPL	Stock	4.2589	4.2771	4.2482	4.2679	50144948.0
2009-04-09 10:30:00	AAPL	Stock	4.2679	4.2814	4.2575	4.2661	37021376.0
2009-04-09 11:00:00	AAPL	Stock	4.2664	4.2739	4.2518	4.2554	28225540.0
2009-04-09 11:30:00	AAPL	Stock	4.2554	4.2668	4.25	4.265	28137844.0
2009-04-09 12:00:00	AAPL	Stock	4.2643	4.2661	4.2518	4.26	21535612.0
2009-04-09 12:30:00	AAPL	Stock	4.26	4.2721	4.2589	4.2632	20921208.0
2009-04-09 13:00:00	AAPL	Stock	4.2632	4.275	4.2625	4.2686	21355152.0
2009-04-09 13:30:00	AAPL	Stock	4.2689	4.2782	4.2643	4.2771	20699448.0
2009-04-09 14:00:00	AAPL	Stock	4.2771	4.2821	4.2668	4.2754	24721088.0
2009-04-09 14:30:00	AAPL	Stock	4.2754	4.2857	4.2729	4.2793	38529764.0
2009-04-09 15:00:00	AAPL	Stock	4.2793	4.2857	4.2714	4.2839	37384032.0
2009-04-09 15:30:00	AAPL	Stock	4.2839	4.2857	4.2607	4.2729	81122804.0
2009-04-09 16:00:00	AAPL	Stock	4.2714	4.28	4.2659	4.2704	11610788.0
2009-04-09 16:30:00	AAPL	Stock	4.2704	4.2714	4.2667	4.2667	4338712.0
2009-04-09 17:00:00	AAPL	Stock	4.2732	4.2743	4.2693	4.2739	218876.0
2009-04-09 17:30:00	AAPL	Stock	4.27	4.2779	4.27	4.2779	186284.0
2009-04-09 18:00:00	AAPL	Stock	4.2704	4.2768	4.2704	4.2768	685720.0
2009-04-09 18:30:00	AAPL	Stock	4.2775	4.2775	4.2732	4.2754	34972.0
2009-04-09 19:00:00	AAPL	Stock	4.2754	4.2754	4.275	4.275	23800.0
2009-04-09 19:30:00	AAPL	Stock	4.275	4.2754	4.2714	4.2754	47404.0
2009-04-09 07:30:00	MSFT	Stock	19.36	19.36	19.36	19.36	250.0
2009-04-09 08:00:00	MSFT	Stock	19.3	19.45	19.3	19.38	19659.0
2009-04-09 08:30:00	MSFT	Stock	19.37	19.62	19.37	19.57	38972.0
2009-04-09 09:00:00	MSFT	Stock	19.57	19.58	19.38	19.42	58213.0
2009-04-09 09:30:00	MSFT	Stock	19.44	19.69	19.25	19.67	6434523.0
2009-04-09 10:00:00	MSFT	Stock	19.66	19.7	19.55	19.57	4609615.0
2009-04-09 10:30:00	MSFT	Stock	19.57	19.6	19.38	19.39	5210775.0
2009-04-09 11:00:00	MSFT	Stock	19.4	19.478	19.25	19.28	2923817.0
2009-04-09 11:30:00	MSFT	Stock	19.285	19.39	19.22	19.39	2951094.0
2009-04-09 12:00:00	MSFT	Stock	19.39	19.43	19.35	19.43	1555652.0
2009-04-09 12:30:00	MSFT	Stock	19.43	19.45	19.37	19.402	1633572.0
2009-04-09 13:00:00	MSFT	Stock	19.402	19.54	19.4	19.5	2488440.0
2009-04-09 13:30:00	MSFT	Stock	19.5	19.57	19.45	19.55	1757688.0
2009-04-09 14:00:00	MSFT	Stock	19.55	19.56	19.44	19.5	1960821.0
2009-04-09 14:30:00	MSFT	Stock	19.5	19.59	19.49	19.535	2511978.0
2009-04-09 15:00:00	MSFT	Stock	19.54	19.61	19.52	19.56	4692436.0
2009-04-09 15:30:00	MSFT	Stock	19.56	19.68	19.51	19.67	10842153.0
2009-04-09 16:00:00	MSFT	Stock	19.67	19.68	19.354	19.63	2055569.0
2009-04-09 16:30:00	MSFT	Stock	19.65	19.65	19.502	19.65	989864.0
2009-04-09 17:00:00	MSFT	Stock	19.62	19.64	19.62	19.62	2334.0
2009-04-09 17:30:00	MSFT	Stock	19.64	19.65	19.6	19.6	1996.0
2009-04-09 18:00:00	MSFT	Stock	19.65	19.65	19.59	19.6	125526.0
2009-04-09 18:30:00	MSFT	Stock	19.65	19.68	19.6	19.66	5500.0
2009-04-09 19:00:00	MSFT	Stock	19.66	19.68	19.66	19.68	1724.0
2009-04-09 19:30:00	MSFT	Stock	19.68	19.68	19.57	19.64	1600.0

> showing 50 of 72,548 rows — these rows as CSV

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