PREVIEW / stock_30min / 2009-04-14

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-04-14.parquet
  size:    1.3 MB
  rows:    71,621
  symbols: 3,328

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-14 04:00:00	AAPL	Stock	4.2696	4.2696	4.2696	4.2696	14000.0
2009-04-14 05:30:00	AAPL	Stock	4.3011	4.3011	4.3011	4.3011	2800.0
2009-04-14 06:00:00	AAPL	Stock	4.3129	4.3129	4.3129	4.3129	2800.0
2009-04-14 06:30:00	AAPL	Stock	4.2896	4.2896	4.2896	4.2896	2800.0
2009-04-14 07:00:00	AAPL	Stock	4.2936	4.2936	4.2929	4.2929	11200.0
2009-04-14 07:30:00	AAPL	Stock	4.2857	4.2857	4.2857	4.2857	8400.0
2009-04-14 08:00:00	AAPL	Stock	4.2929	4.3143	4.2857	4.3107	555548.0
2009-04-14 08:30:00	AAPL	Stock	4.3061	4.3061	4.2593	4.2661	720160.0
2009-04-14 09:00:00	AAPL	Stock	4.2657	4.2732	4.2586	4.2704	454720.0
2009-04-14 09:30:00	AAPL	Stock	4.2704	4.2918	4.25	4.2718	60414284.0
2009-04-14 10:00:00	AAPL	Stock	4.2714	4.2718	4.2289	4.2571	48646752.0
2009-04-14 10:30:00	AAPL	Stock	4.2564	4.2675	4.2364	4.2439	28446404.0
2009-04-14 11:00:00	AAPL	Stock	4.2436	4.2561	4.2232	4.2254	24933636.0
2009-04-14 11:30:00	AAPL	Stock	4.2268	4.2482	4.2243	4.2364	17497284.0
2009-04-14 12:00:00	AAPL	Stock	4.2364	4.2489	4.2304	4.2442	15578976.0
2009-04-14 12:30:00	AAPL	Stock	4.2443	4.2457	4.1882	4.1889	33931800.0
2009-04-14 13:00:00	AAPL	Stock	4.1896	4.2121	4.1889	4.2004	31444392.0
2009-04-14 13:30:00	AAPL	Stock	4.1993	4.2025	4.1875	4.2018	21904288.0
2009-04-14 14:00:00	AAPL	Stock	4.2021	4.2096	4.1918	4.2046	30886128.0
2009-04-14 14:30:00	AAPL	Stock	4.2054	4.2246	4.1961	4.2246	25353468.0
2009-04-14 15:00:00	AAPL	Stock	4.2243	4.2361	4.2165	4.2286	34351604.0
2009-04-14 15:30:00	AAPL	Stock	4.2286	4.25	4.2189	4.2257	56215908.0
2009-04-14 16:00:00	AAPL	Stock	4.2257	4.2529	4.1918	4.2129	8605240.0
2009-04-14 16:30:00	AAPL	Stock	4.21	4.2254	4.2	4.2064	327376.0
2009-04-14 17:00:00	AAPL	Stock	4.2068	4.2254	4.1964	4.2025	293160.0
2009-04-14 17:30:00	AAPL	Stock	4.1989	4.2	4.1964	4.1971	69720.0
2009-04-14 18:00:00	AAPL	Stock	4.1971	4.2254	4.1964	4.1964	570976.0
2009-04-14 18:30:00	AAPL	Stock	4.2	4.2	4.1918	4.1996	29400.0
2009-04-14 19:00:00	AAPL	Stock	4.195	4.1964	4.195	4.1964	10528.0
2009-04-14 19:30:00	AAPL	Stock	4.1911	4.1964	4.1893	4.1964	66192.0
2009-04-14 07:00:00	MSFT	Stock	19.5	19.5	19.45	19.45	500.0
2009-04-14 08:00:00	MSFT	Stock	19.5	19.59	19.5	19.59	5980.0
2009-04-14 08:30:00	MSFT	Stock	19.59	19.67	19.56	19.56	13128.0
2009-04-14 09:00:00	MSFT	Stock	19.52	19.56	19.41	19.45	20855.0
2009-04-14 09:30:00	MSFT	Stock	19.44	19.55	19.22	19.53	6788729.0
2009-04-14 10:00:00	MSFT	Stock	19.53	19.54	19.4	19.45	4239328.0
2009-04-14 10:30:00	MSFT	Stock	19.45	19.55	19.44	19.455	3583928.0
2009-04-14 11:00:00	MSFT	Stock	19.45	19.53	19.22	19.22	7126284.0
2009-04-14 11:30:00	MSFT	Stock	19.222	19.252	19.16	19.23	4096284.0
2009-04-14 12:00:00	MSFT	Stock	19.23	19.26	19.08	19.14	3250669.0
2009-04-14 12:30:00	MSFT	Stock	19.145	19.16	19.0	19.052	3119051.0
2009-04-14 13:00:00	MSFT	Stock	19.06	19.1	19.02	19.1	2727183.0
2009-04-14 13:30:00	MSFT	Stock	19.09	19.13	19.06	19.13	2327327.0
2009-04-14 14:00:00	MSFT	Stock	19.13	19.18	19.1	19.17	2415489.0
2009-04-14 14:30:00	MSFT	Stock	19.17	19.26	19.13	19.26	4327906.0
2009-04-14 15:00:00	MSFT	Stock	19.25	19.29	19.18	19.229	3725254.0
2009-04-14 15:30:00	MSFT	Stock	19.228	19.48	19.14	19.33	10693329.0
2009-04-14 16:00:00	MSFT	Stock	19.33	19.49	18.91	19.05	3292069.0
2009-04-14 16:30:00	MSFT	Stock	19.05	19.35	18.98	19.254	85440.0
2009-04-14 17:00:00	MSFT	Stock	19.07	19.35	19.05	19.35	3366.0

> showing 50 of 71,621 rows — these rows as CSV

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