PREVIEW / stock_30min / 2008-10-06

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-10-06.parquet
  size:    1.3 MB
  rows:    75,641
  symbols: 3,394

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-10-06 07:00:00	AAPL	Stock	3.3004	3.3304	3.2768	3.2857	329392.0
2008-10-06 07:30:00	AAPL	Stock	3.2861	3.3607	3.2714	3.3429	1006908.0
2008-10-06 08:00:00	AAPL	Stock	3.35	3.3739	3.295	3.3282	4787580.0
2008-10-06 08:30:00	AAPL	Stock	3.3293	3.3557	3.3232	3.3289	3133228.0
2008-10-06 09:00:00	AAPL	Stock	3.3271	3.3429	3.2811	3.2836	9144380.0
2008-10-06 09:30:00	AAPL	Stock	3.2843	3.3696	3.2539	3.3207	200843328.0
2008-10-06 10:00:00	AAPL	Stock	3.3199	3.3571	3.2307	3.25	168882924.0
2008-10-06 10:30:00	AAPL	Stock	3.25	3.2936	3.1264	3.29	202816348.0
2008-10-06 11:00:00	AAPL	Stock	3.2921	3.3211	3.2304	3.2736	135086224.0
2008-10-06 11:30:00	AAPL	Stock	3.275	3.31	3.2468	3.2493	94801364.0
2008-10-06 12:00:00	AAPL	Stock	3.2489	3.2768	3.2183	3.2254	81469976.0
2008-10-06 12:30:00	AAPL	Stock	3.2261	3.2311	3.1468	3.1679	108688944.0
2008-10-06 13:00:00	AAPL	Stock	3.1689	3.2421	3.1489	3.2143	105362544.0
2008-10-06 13:30:00	AAPL	Stock	3.2143	3.2161	3.1429	3.1914	123204900.0
2008-10-06 14:00:00	AAPL	Stock	3.1921	3.2143	3.1546	3.2093	131914636.0
2008-10-06 14:30:00	AAPL	Stock	3.21	3.2529	3.1643	3.2356	140515340.0
2008-10-06 15:00:00	AAPL	Stock	3.2354	3.3971	3.2036	3.3729	248482080.0
2008-10-06 15:30:00	AAPL	Stock	3.373	3.5279	3.3643	3.4896	258355160.0
2008-10-06 16:00:00	AAPL	Stock	3.4671	3.5268	3.2729	3.4786	38645544.0
2008-10-06 16:30:00	AAPL	Stock	3.4793	3.4836	3.2715	3.4729	12881400.0
2008-10-06 17:00:00	AAPL	Stock	3.4732	3.4825	3.4643	3.4679	1060668.0
2008-10-06 17:30:00	AAPL	Stock	3.4693	3.4804	3.4664	3.4804	391440.0
2008-10-06 18:00:00	AAPL	Stock	3.475	3.4804	3.4611	3.4768	314860.0
2008-10-06 18:30:00	AAPL	Stock	3.4718	3.4821	3.4718	3.4782	183484.0
2008-10-06 19:00:00	AAPL	Stock	3.4764	3.4857	3.475	3.4839	134932.0
2008-10-06 19:30:00	AAPL	Stock	3.4871	3.4911	3.4804	3.4893	195916.0
2008-10-06 07:00:00	MSFT	Stock	25.5	25.5	25.5	25.5	2000.0
2008-10-06 07:30:00	MSFT	Stock	25.62	25.79	25.62	25.79	1585.0
2008-10-06 08:00:00	MSFT	Stock	25.67	26.2	25.61	25.7	30570.0
2008-10-06 08:30:00	MSFT	Stock	25.7	25.92	25.69	25.7	15158.0
2008-10-06 09:00:00	MSFT	Stock	25.76	26.0	25.63	25.65	89870.0
2008-10-06 09:30:00	MSFT	Stock	25.63	25.99	25.31	25.47	13303248.0
2008-10-06 10:00:00	MSFT	Stock	25.46	25.6	25.18	25.22	10799005.0
2008-10-06 10:30:00	MSFT	Stock	25.22	25.222	24.6	25.08	11770096.0
2008-10-06 11:00:00	MSFT	Stock	25.08	25.25	24.96	25.05	10379573.0
2008-10-06 11:30:00	MSFT	Stock	25.05	25.11	24.69	24.69	7566881.0
2008-10-06 12:00:00	MSFT	Stock	24.69	24.76	24.5	24.63	6603262.0
2008-10-06 12:30:00	MSFT	Stock	24.615	24.82	24.6	24.6	7609815.0
2008-10-06 13:00:00	MSFT	Stock	24.602	24.83	24.54	24.69	5778548.0
2008-10-06 13:30:00	MSFT	Stock	24.69	24.76	24.5	24.63	6975762.0
2008-10-06 14:00:00	MSFT	Stock	24.63	24.645	24.14	24.33	9995663.0
2008-10-06 14:30:00	MSFT	Stock	24.332	24.62	24.15	24.53	10287166.0
2008-10-06 15:00:00	MSFT	Stock	24.528	25.07	24.28	24.9	15019387.0
2008-10-06 15:30:00	MSFT	Stock	24.89	25.1	24.55	24.93	18224125.0
2008-10-06 16:00:00	MSFT	Stock	24.97	24.98	24.417	24.71	8650840.0
2008-10-06 16:30:00	MSFT	Stock	24.68	24.93	24.58	24.7	1258073.0
2008-10-06 17:00:00	MSFT	Stock	24.7	24.72	24.61	24.63	7300.0
2008-10-06 17:30:00	MSFT	Stock	24.7	24.75	24.67	24.75	8733.0
2008-10-06 18:00:00	MSFT	Stock	24.73	24.73	24.73	24.73	1200.0
2008-10-06 18:30:00	MSFT	Stock	24.71	24.75	24.7	24.7	1113.0

> showing 50 of 75,641 rows — these rows as CSV

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