PREVIEW / stock_30min / 2010-10-22

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-10-22.parquet
  size:    1.4 MB
  rows:    75,578
  symbols: 3,491

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
2010-10-22 05:00:00	AAPL	Stock	10.9643	10.9643	10.9643	10.9643	11200.0
2010-10-22 05:30:00	AAPL	Stock	10.9643	10.9643	10.9643	10.9643	11200.0
2010-10-22 07:00:00	AAPL	Stock	10.9925	11.0161	10.9925	11.0161	60200.0
2010-10-22 07:30:00	AAPL	Stock	11.0154	11.025	11.0089	11.025	120064.0
2010-10-22 08:00:00	AAPL	Stock	11.0214	11.0429	11.0039	11.0243	1117480.0
2010-10-22 08:30:00	AAPL	Stock	11.0239	11.0411	11.0114	11.0357	1564864.0
2010-10-22 09:00:00	AAPL	Stock	11.0357	11.0814	11.0293	11.0425	2871204.0
2010-10-22 09:30:00	AAPL	Stock	11.0396	11.0729	10.9939	11.0136	60914476.0
2010-10-22 10:00:00	AAPL	Stock	11.0139	11.0139	10.9689	10.9964	39634980.0
2010-10-22 10:30:00	AAPL	Stock	10.9964	11.0568	10.9939	11.0405	28531412.0
2010-10-22 11:00:00	AAPL	Stock	11.0393	11.0536	11.0071	11.0159	22985200.0
2010-10-22 11:30:00	AAPL	Stock	11.0168	11.045	11.0071	11.0071	18570580.0
2010-10-22 12:00:00	AAPL	Stock	11.0076	11.0264	11.0036	11.0236	17977764.0
2010-10-22 12:30:00	AAPL	Stock	11.0234	11.0254	11.0007	11.0077	12785864.0
2010-10-22 13:00:00	AAPL	Stock	11.0061	11.0179	10.9964	11.0118	14935340.0
2010-10-22 13:30:00	AAPL	Stock	11.0125	11.0139	10.9821	10.9861	16335228.0
2010-10-22 14:00:00	AAPL	Stock	10.9868	11.0357	10.9821	11.0329	20187804.0
2010-10-22 14:30:00	AAPL	Stock	11.0307	11.0321	11.0093	11.0111	18535160.0
2010-10-22 15:00:00	AAPL	Stock	11.0111	11.0175	10.9868	10.9961	22915536.0
2010-10-22 15:30:00	AAPL	Stock	10.9952	11.0014	10.9393	10.9957	51463132.0
2010-10-22 16:00:00	AAPL	Stock	10.9932	11.0456	10.9736	10.9836	13338584.0
2010-10-22 16:30:00	AAPL	Stock	10.9825	10.9964	10.9811	10.9811	1000804.0
2010-10-22 17:00:00	AAPL	Stock	10.9836	10.9954	10.9793	10.9832	444332.0
2010-10-22 17:30:00	AAPL	Stock	10.985	10.99	10.985	10.9889	183400.0
2010-10-22 18:00:00	AAPL	Stock	10.9821	10.9839	10.9643	10.9643	381808.0
2010-10-22 18:30:00	AAPL	Stock	10.9607	10.9643	10.9471	10.95	770224.0
2010-10-22 19:00:00	AAPL	Stock	10.95	10.9714	10.9482	10.9679	1023736.0
2010-10-22 19:30:00	AAPL	Stock	10.9693	10.9839	10.9693	10.9839	447916.0
2010-10-22 07:00:00	MSFT	Stock	25.55	25.55	25.31	25.31	400.0
2010-10-22 07:30:00	MSFT	Stock	25.53	25.54	25.41	25.49	2425.0
2010-10-22 08:00:00	MSFT	Stock	25.46	25.55	25.4	25.43	45164.0
2010-10-22 08:30:00	MSFT	Stock	25.46	25.52	25.4	25.51	25600.0
2010-10-22 09:00:00	MSFT	Stock	25.51	25.52	25.44	25.51	36350.0
2010-10-22 09:30:00	MSFT	Stock	25.52	25.54	25.31	25.315	3408376.0
2010-10-22 10:00:00	MSFT	Stock	25.315	25.365	25.27	25.365	2718171.0
2010-10-22 10:30:00	MSFT	Stock	25.367	25.38	25.31	25.36	1976537.0
2010-10-22 11:00:00	MSFT	Stock	25.353	25.36	25.3	25.31	1394107.0
2010-10-22 11:30:00	MSFT	Stock	25.32	25.36	25.3	25.327	1147533.0
2010-10-22 12:00:00	MSFT	Stock	25.326	25.41	25.32	25.41	1134192.0
2010-10-22 12:30:00	MSFT	Stock	25.41	25.43	25.39	25.425	944199.0
2010-10-22 13:00:00	MSFT	Stock	25.425	25.43	25.37	25.39	981555.0
2010-10-22 13:30:00	MSFT	Stock	25.39	25.39	25.33	25.33	1067587.0
2010-10-22 14:00:00	MSFT	Stock	25.334	25.35	25.31	25.347	1473396.0
2010-10-22 14:30:00	MSFT	Stock	25.34	25.35	25.3	25.3	1548609.0
2010-10-22 15:00:00	MSFT	Stock	25.302	25.36	25.3	25.355	1589153.0
2010-10-22 15:30:00	MSFT	Stock	25.359	25.39	25.32	25.39	3620416.0
2010-10-22 16:00:00	MSFT	Stock	25.39	25.48	25.35	25.48	1445386.0
2010-10-22 16:30:00	MSFT	Stock	25.47	25.49	25.329	25.46	82837.0
2010-10-22 17:00:00	MSFT	Stock	25.4	25.4	25.39	25.4	32364.0
2010-10-22 17:30:00	MSFT	Stock	25.47	25.5	25.45	25.45	4000.0

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

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