PREVIEW / stock_30min / 2012-09-27

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-09-27.parquet
  size:    1.4 MB
  rows:    76,681
  symbols: 3,472

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
2012-09-27 04:00:00	AAPL	Stock	23.8554	23.8571	23.8536	23.8571	40600.0
2012-09-27 04:30:00	AAPL	Stock	23.8571	23.8571	23.8464	23.8464	21504.0
2012-09-27 05:00:00	AAPL	Stock	23.85	23.85	23.8143	23.8143	50400.0
2012-09-27 05:30:00	AAPL	Stock	23.8143	23.8214	23.8143	23.8214	79744.0
2012-09-27 06:00:00	AAPL	Stock	23.8214	23.8489	23.7679	23.7679	184576.0
2012-09-27 06:30:00	AAPL	Stock	23.7868	23.7921	23.7254	23.7321	349468.0
2012-09-27 07:00:00	AAPL	Stock	23.7264	23.8214	23.6786	23.8107	1071924.0
2012-09-27 07:30:00	AAPL	Stock	23.8068	23.8375	23.7593	23.7786	508340.0
2012-09-27 08:00:00	AAPL	Stock	23.7782	23.8679	23.7782	23.8607	1376172.0
2012-09-27 08:30:00	AAPL	Stock	23.8425	23.8425	23.7493	23.7679	2374064.0
2012-09-27 09:00:00	AAPL	Stock	23.7611	23.7954	23.6793	23.7214	2461872.0
2012-09-27 09:30:00	AAPL	Stock	23.7204	23.7393	23.5839	23.6918	98415968.0
2012-09-27 10:00:00	AAPL	Stock	23.6832	23.8211	23.6607	23.8082	55441960.0
2012-09-27 10:30:00	AAPL	Stock	23.8089	24.0089	23.8087	23.9361	62530216.0
2012-09-27 11:00:00	AAPL	Stock	23.9362	23.9821	23.9018	23.9736	29113560.0
2012-09-27 11:30:00	AAPL	Stock	23.9743	24.1393	23.9539	24.1311	41317976.0
2012-09-27 12:00:00	AAPL	Stock	24.1307	24.2807	24.1286	24.2446	64678040.0
2012-09-27 12:30:00	AAPL	Stock	24.2404	24.2586	24.15	24.2275	34214992.0
2012-09-27 13:00:00	AAPL	Stock	24.2289	24.2536	24.1811	24.2196	17939376.0
2012-09-27 13:30:00	AAPL	Stock	24.2204	24.2964	24.1914	24.2096	28266700.0
2012-09-27 14:00:00	AAPL	Stock	24.2132	24.2495	24.2021	24.2325	14170548.0
2012-09-27 14:30:00	AAPL	Stock	24.2325	24.3632	24.2179	24.2498	39732980.0
2012-09-27 15:00:00	AAPL	Stock	24.2511	24.3143	24.2175	24.2768	34736940.0
2012-09-27 15:30:00	AAPL	Stock	24.2739	24.3396	24.2543	24.3364	44614416.0
2012-09-27 16:00:00	AAPL	Stock	24.3364	24.3486	23.6961	24.3357	6284880.0
2012-09-27 16:30:00	AAPL	Stock	24.3357	24.3725	23.9206	24.3714	614908.0
2012-09-27 17:00:00	AAPL	Stock	24.3732	24.3886	24.3361	24.3664	845684.0
2012-09-27 17:30:00	AAPL	Stock	24.3679	24.3886	24.3643	24.3875	372596.0
2012-09-27 18:00:00	AAPL	Stock	24.3804	24.3832	24.3693	24.3754	158676.0
2012-09-27 18:30:00	AAPL	Stock	24.375	24.3961	24.375	24.3807	229096.0
2012-09-27 19:00:00	AAPL	Stock	24.3857	24.4	24.3754	24.4	219380.0
2012-09-27 19:30:00	AAPL	Stock	24.4057	24.4196	24.4043	24.4161	220192.0
2012-09-27 07:00:00	MSFT	Stock	30.26	30.26	30.25	30.25	691.0
2012-09-27 07:30:00	MSFT	Stock	30.25	30.25	30.18	30.19	3000.0
2012-09-27 08:00:00	MSFT	Stock	30.18	30.22	30.15	30.22	15300.0
2012-09-27 08:30:00	MSFT	Stock	30.22	30.33	30.2	30.23	15384.0
2012-09-27 09:00:00	MSFT	Stock	30.23	30.23	30.11	30.21	53096.0
2012-09-27 09:30:00	MSFT	Stock	30.19	30.4	29.97	30.02	6879510.0
2012-09-27 10:00:00	MSFT	Stock	30.02	30.05	29.89	29.958	5770282.0
2012-09-27 10:30:00	MSFT	Stock	29.96	30.07	29.93	30.005	3530909.0
2012-09-27 11:00:00	MSFT	Stock	30.0	30.05	29.955	29.998	2768840.0
2012-09-27 11:30:00	MSFT	Stock	29.995	30.05	29.95	30.05	2293570.0
2012-09-27 12:00:00	MSFT	Stock	30.05	30.29	30.03	30.25	3930956.0
2012-09-27 12:30:00	MSFT	Stock	30.241	30.28	30.13	30.155	2576158.0
2012-09-27 13:00:00	MSFT	Stock	30.16	30.2	30.12	30.189	1378349.0
2012-09-27 13:30:00	MSFT	Stock	30.18	30.35	30.18	30.285	1811727.0
2012-09-27 14:00:00	MSFT	Stock	30.28	30.34	30.28	30.3	1619503.0
2012-09-27 14:30:00	MSFT	Stock	30.3	30.31	30.24	30.26	1731560.0
2012-09-27 15:00:00	MSFT	Stock	30.26	30.28	30.21	30.258	2093977.0
2012-09-27 15:30:00	MSFT	Stock	30.251	30.3	30.15	30.19	5961745.0

> showing 50 of 76,681 rows — these rows as CSV

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