PREVIEW / stock_30min / 2012-05-04

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-05-04.parquet
  size:    1.4 MB
  rows:    76,574
  symbols: 3,531

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-05-04 04:30:00	AAPL	Stock	20.75	20.75	20.75	20.75	5600.0
2012-05-04 05:00:00	AAPL	Stock	20.7146	20.7146	20.7146	20.7146	2800.0
2012-05-04 06:00:00	AAPL	Stock	20.7182	20.7182	20.7182	20.7182	2800.0
2012-05-04 06:30:00	AAPL	Stock	20.7236	20.75	20.7236	20.75	5600.0
2012-05-04 07:00:00	AAPL	Stock	20.7571	20.7857	20.7232	20.7411	154560.0
2012-05-04 07:30:00	AAPL	Stock	20.7321	20.7386	20.6964	20.7304	164584.0
2012-05-04 08:00:00	AAPL	Stock	20.7307	20.7639	20.7104	20.7143	553560.0
2012-05-04 08:30:00	AAPL	Stock	20.71	20.8164	20.6229	20.6246	4601492.0
2012-05-04 09:00:00	AAPL	Stock	20.6311	20.6536	20.6039	20.6154	2839368.0
2012-05-04 09:30:00	AAPL	Stock	20.61	20.6557	20.4325	20.4718	91868532.0
2012-05-04 10:00:00	AAPL	Stock	20.4707	20.4932	20.3118	20.3611	79701384.0
2012-05-04 10:30:00	AAPL	Stock	20.3625	20.4164	20.2954	20.3925	46117764.0
2012-05-04 11:00:00	AAPL	Stock	20.3929	20.3975	20.3157	20.3425	30382324.0
2012-05-04 11:30:00	AAPL	Stock	20.3443	20.3982	20.3218	20.3779	28257460.0
2012-05-04 12:00:00	AAPL	Stock	20.3779	20.4282	20.3307	20.3559	24822308.0
2012-05-04 12:30:00	AAPL	Stock	20.3557	20.3832	20.3286	20.3586	16057440.0
2012-05-04 13:00:00	AAPL	Stock	20.3593	20.3668	20.3118	20.3254	21417340.0
2012-05-04 13:30:00	AAPL	Stock	20.3271	20.33	20.2732	20.3171	28223300.0
2012-05-04 14:00:00	AAPL	Stock	20.3107	20.3125	20.2643	20.2754	21882168.0
2012-05-04 14:30:00	AAPL	Stock	20.2764	20.2914	20.2057	20.2396	32743256.0
2012-05-04 15:00:00	AAPL	Stock	20.2414	20.2771	20.2289	20.2429	22991304.0
2012-05-04 15:30:00	AAPL	Stock	20.2412	20.2661	20.1846	20.1886	60884320.0
2012-05-04 16:00:00	AAPL	Stock	20.1868	20.2719	20.1761	20.1821	8459136.0
2012-05-04 16:30:00	AAPL	Stock	20.1832	20.2446	20.1793	20.1929	1306144.0
2012-05-04 17:00:00	AAPL	Stock	20.1964	20.1968	20.1861	20.1925	721700.0
2012-05-04 17:30:00	AAPL	Stock	20.1929	20.1929	20.1821	20.1821	206724.0
2012-05-04 18:00:00	AAPL	Stock	20.1829	20.1829	20.1786	20.1789	117320.0
2012-05-04 18:30:00	AAPL	Stock	20.1804	20.1854	20.1786	20.1786	188244.0
2012-05-04 19:00:00	AAPL	Stock	20.1761	20.1882	20.1761	20.1839	59164.0
2012-05-04 19:30:00	AAPL	Stock	20.1875	20.1875	20.1761	20.1786	179116.0
2012-05-04 08:00:00	MSFT	Stock	31.7	31.7	31.68	31.68	1250.0
2012-05-04 08:30:00	MSFT	Stock	31.7	31.7	31.52	31.55	43516.0
2012-05-04 09:00:00	MSFT	Stock	31.55	31.56	31.48	31.48	45919.0
2012-05-04 09:30:00	MSFT	Stock	31.47	31.57	31.34	31.38	6390199.0
2012-05-04 10:00:00	MSFT	Stock	31.38	31.4	31.31	31.349	5043672.0
2012-05-04 10:30:00	MSFT	Stock	31.35	31.41	31.3	31.321	3416539.0
2012-05-04 11:00:00	MSFT	Stock	31.32	31.34	31.15	31.18	4548903.0
2012-05-04 11:30:00	MSFT	Stock	31.18	31.2	31.12	31.19	3172584.0
2012-05-04 12:00:00	MSFT	Stock	31.19	31.2	31.0	31.009	4997330.0
2012-05-04 12:30:00	MSFT	Stock	31.01	31.08	30.92	31.079	5363107.0
2012-05-04 13:00:00	MSFT	Stock	31.08	31.17	30.995	31.02	3683217.0
2012-05-04 13:30:00	MSFT	Stock	31.015	31.07	31.01	31.061	2892158.0
2012-05-04 14:00:00	MSFT	Stock	31.068	31.08	31.03	31.06	2110112.0
2012-05-04 14:30:00	MSFT	Stock	31.06	31.08	30.97	31.005	3409865.0
2012-05-04 15:00:00	MSFT	Stock	31.005	31.05	30.98	31.02	3210436.0
2012-05-04 15:30:00	MSFT	Stock	31.018	31.13	30.97	30.97	6383990.0
2012-05-04 16:00:00	MSFT	Stock	30.98	31.174	30.93	30.96	1981547.0
2012-05-04 16:30:00	MSFT	Stock	30.98	31.307	30.93	30.98	254612.0
2012-05-04 17:00:00	MSFT	Stock	30.98	30.98	30.95	30.95	143070.0
2012-05-04 17:30:00	MSFT	Stock	30.95	30.98	30.9	30.95	3446.0

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

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