PREVIEW / stock_30min / 2009-05-27

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-05-27.parquet
  size:    1.3 MB
  rows:    72,503
  symbols: 3,348

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-05-27 05:00:00	AAPL	Stock	4.7236	4.7236	4.7236	4.7236	2800.0
2009-05-27 07:00:00	AAPL	Stock	4.7186	4.7186	4.6804	4.6875	385000.0
2009-05-27 07:30:00	AAPL	Stock	4.6857	4.6968	4.6857	4.6893	145600.0
2009-05-27 08:00:00	AAPL	Stock	4.6929	4.6964	4.6782	4.6871	1174348.0
2009-05-27 08:30:00	AAPL	Stock	4.6875	4.7029	4.6854	4.6904	829108.0
2009-05-27 09:00:00	AAPL	Stock	4.69	4.7054	4.6896	4.7054	1048320.0
2009-05-27 09:30:00	AAPL	Stock	4.7064	4.7561	4.6754	4.7375	110073628.0
2009-05-27 10:00:00	AAPL	Stock	4.7375	4.7932	4.7232	4.7829	77931924.0
2009-05-27 10:30:00	AAPL	Stock	4.7839	4.8207	4.7754	4.8171	72231404.0
2009-05-27 11:00:00	AAPL	Stock	4.8171	4.8173	4.7864	4.8019	42396200.0
2009-05-27 11:30:00	AAPL	Stock	4.802	4.8071	4.7943	4.8011	25025476.0
2009-05-27 12:00:00	AAPL	Stock	4.8014	4.8107	4.7993	4.805	25064508.0
2009-05-27 12:30:00	AAPL	Stock	4.805	4.8143	4.7929	4.7982	28898408.0
2009-05-27 13:00:00	AAPL	Stock	4.7982	4.8054	4.7893	4.7986	20488664.0
2009-05-27 13:30:00	AAPL	Stock	4.7982	4.7987	4.7429	4.7561	49653184.0
2009-05-27 14:00:00	AAPL	Stock	4.7561	4.7568	4.7389	4.7535	34362328.0
2009-05-27 14:30:00	AAPL	Stock	4.7536	4.7779	4.7425	4.7611	34271664.0
2009-05-27 15:00:00	AAPL	Stock	4.7614	4.7764	4.7296	4.7379	44502612.0
2009-05-27 15:30:00	AAPL	Stock	4.7382	4.7554	4.7296	4.7486	59323180.0
2009-05-27 16:00:00	AAPL	Stock	4.7507	4.7764	4.7429	4.7468	9862916.0
2009-05-27 16:30:00	AAPL	Stock	4.7486	4.7539	4.7471	4.7539	5114032.0
2009-05-27 17:00:00	AAPL	Stock	4.7514	4.7593	4.7496	4.7586	274540.0
2009-05-27 17:30:00	AAPL	Stock	4.7586	4.7618	4.7561	4.7611	99820.0
2009-05-27 18:00:00	AAPL	Stock	4.7571	4.7571	4.7529	4.7554	113456.0
2009-05-27 18:30:00	AAPL	Stock	4.7518	4.7518	4.7429	4.7429	230552.0
2009-05-27 19:00:00	AAPL	Stock	4.7429	4.7429	4.7375	4.7393	172872.0
2009-05-27 19:30:00	AAPL	Stock	4.7393	4.7482	4.7393	4.7464	66640.0
2009-05-27 08:00:00	MSFT	Stock	20.34	20.34	20.34	20.34	1100.0
2009-05-27 08:30:00	MSFT	Stock	20.33	20.34	20.3	20.3	1321.0
2009-05-27 09:00:00	MSFT	Stock	20.27	20.3	20.24	20.24	10884.0
2009-05-27 09:30:00	MSFT	Stock	20.24	20.55	20.24	20.46	3119831.0
2009-05-27 10:00:00	MSFT	Stock	20.46	20.54	20.31	20.47	3457076.0
2009-05-27 10:30:00	MSFT	Stock	20.48	20.59	20.42	20.582	2556341.0
2009-05-27 11:00:00	MSFT	Stock	20.58	20.6	20.44	20.489	2811461.0
2009-05-27 11:30:00	MSFT	Stock	20.49	20.51	20.44	20.469	1590779.0
2009-05-27 12:00:00	MSFT	Stock	20.47	20.57	20.46	20.5	1549852.0
2009-05-27 12:30:00	MSFT	Stock	20.5	20.53	20.41	20.442	2833022.0
2009-05-27 13:00:00	MSFT	Stock	20.45	20.51	20.43	20.46	1110619.0
2009-05-27 13:30:00	MSFT	Stock	20.45	20.46	20.21	20.3	3136065.0
2009-05-27 14:00:00	MSFT	Stock	20.3	20.46	20.11	20.16	3462906.0
2009-05-27 14:30:00	MSFT	Stock	20.16	20.3	20.09	20.28	2627786.0
2009-05-27 15:00:00	MSFT	Stock	20.29	20.37	20.1	20.14	3289752.0
2009-05-27 15:30:00	MSFT	Stock	20.14	20.35	20.07	20.11	6815161.0
2009-05-27 16:00:00	MSFT	Stock	20.1	20.34	20.07	20.17	2958565.0
2009-05-27 16:30:00	MSFT	Stock	20.101	20.512	20.101	20.512	960185.0
2009-05-27 17:00:00	MSFT	Stock	20.23	20.23	20.18	20.18	640.0
2009-05-27 17:30:00	MSFT	Stock	20.525	20.525	20.18	20.18	1900.0
2009-05-27 18:00:00	MSFT	Stock	20.18	20.21	20.18	20.21	1560.0
2009-05-27 18:30:00	MSFT	Stock	20.21	20.21	20.18	20.21	2210.0
2009-05-27 19:00:00	MSFT	Stock	20.19	20.22	20.18	20.22	685.0

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

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