PREVIEW / stock_30min / 2013-05-15

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-15.parquet
  size:    1.5 MB
  rows:    79,601
  symbols: 3,517

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
2013-05-15 04:00:00	AAPL	Stock	15.7857	15.7857	15.7857	15.7857	5600.0
2013-05-15 04:30:00	AAPL	Stock	15.7857	15.7857	15.7857	15.7857	2800.0
2013-05-15 05:30:00	AAPL	Stock	15.7879	15.7879	15.7857	15.7857	8400.0
2013-05-15 06:00:00	AAPL	Stock	15.7864	15.7968	15.7864	15.7968	8064.0
2013-05-15 06:30:00	AAPL	Stock	15.8018	15.8161	15.7957	15.7957	11956.0
2013-05-15 07:00:00	AAPL	Stock	15.8129	15.8129	15.75	15.7857	155764.0
2013-05-15 07:30:00	AAPL	Stock	15.7964	15.8225	15.7964	15.8071	131600.0
2013-05-15 08:00:00	AAPL	Stock	15.8036	15.8379	15.75	15.8221	602980.0
2013-05-15 08:30:00	AAPL	Stock	15.8218	15.8225	15.7411	15.7411	828688.0
2013-05-15 09:00:00	AAPL	Stock	15.7386	15.75	15.6764	15.6786	2153620.0
2013-05-15 09:30:00	AAPL	Stock	15.6843	15.75	15.5182	15.5307	106072652.0
2013-05-15 10:00:00	AAPL	Stock	15.5282	15.6054	15.4821	15.5264	61356260.0
2013-05-15 10:30:00	AAPL	Stock	15.5261	15.5743	15.4779	15.5118	33667144.0
2013-05-15 11:00:00	AAPL	Stock	15.5125	15.5571	15.4468	15.4604	39851812.0
2013-05-15 11:30:00	AAPL	Stock	15.4607	15.4989	15.4111	15.4257	32346104.0
2013-05-15 12:00:00	AAPL	Stock	15.425	15.4255	15.3254	15.3589	55285076.0
2013-05-15 12:30:00	AAPL	Stock	15.3589	15.4089	15.3543	15.3807	24049284.0
2013-05-15 13:00:00	AAPL	Stock	15.3789	15.3804	15.2225	15.2817	59315732.0
2013-05-15 13:30:00	AAPL	Stock	15.2811	15.2911	15.1979	15.2075	28014140.0
2013-05-15 14:00:00	AAPL	Stock	15.2068	15.2814	15.1896	15.2161	38011512.0
2013-05-15 14:30:00	AAPL	Stock	15.2143	15.2318	15.1429	15.1693	42369292.0
2013-05-15 15:00:00	AAPL	Stock	15.1636	15.1964	15.0843	15.1964	61996620.0
2013-05-15 15:30:00	AAPL	Stock	15.195	15.3571	15.1946	15.3204	98569884.0
2013-05-15 16:00:00	AAPL	Stock	15.3204	15.5249	15.2929	15.2971	45089184.0
2013-05-15 16:30:00	AAPL	Stock	15.3	15.5815	15.2743	15.3268	2671172.0
2013-05-15 17:00:00	AAPL	Stock	15.3214	15.3286	15.2679	15.3107	395920.0
2013-05-15 17:30:00	AAPL	Stock	15.295	15.3957	15.2871	15.3214	420700.0
2013-05-15 18:00:00	AAPL	Stock	15.3196	15.3196	15.3036	15.3089	113792.0
2013-05-15 18:30:00	AAPL	Stock	15.3071	15.3071	15.2679	15.2768	160076.0
2013-05-15 19:00:00	AAPL	Stock	15.2679	15.2804	15.2679	15.2732	108836.0
2013-05-15 19:30:00	AAPL	Stock	15.2804	15.2821	15.2696	15.275	113764.0
2013-05-15 04:00:00	MSFT	Stock	33.45	33.45	33.45	33.45	100.0
2013-05-15 04:30:00	MSFT	Stock	33.45	33.45	33.45	33.45	400.0
2013-05-15 06:00:00	MSFT	Stock	33.43	33.43	33.43	33.43	400.0
2013-05-15 07:30:00	MSFT	Stock	33.4	33.4	33.4	33.4	1300.0
2013-05-15 08:00:00	MSFT	Stock	33.45	33.53	33.45	33.52	15411.0
2013-05-15 08:30:00	MSFT	Stock	33.47	33.49	33.42	33.49	2796.0
2013-05-15 09:00:00	MSFT	Stock	33.49	33.5	33.43	33.46	16181.0
2013-05-15 09:30:00	MSFT	Stock	33.46	33.76	33.43	33.73	4715338.0
2013-05-15 10:00:00	MSFT	Stock	33.72	33.76	33.615	33.66	3342337.0
2013-05-15 10:30:00	MSFT	Stock	33.66	33.74	33.64	33.69	2894999.0
2013-05-15 11:00:00	MSFT	Stock	33.69	33.77	33.67	33.69	2656433.0
2013-05-15 11:30:00	MSFT	Stock	33.68	33.73	33.64	33.665	2137566.0
2013-05-15 12:00:00	MSFT	Stock	33.67	33.74	33.66	33.685	2265017.0
2013-05-15 12:30:00	MSFT	Stock	33.69	33.73	33.655	33.71	2529382.0
2013-05-15 13:00:00	MSFT	Stock	33.71	33.74	33.66	33.66	1852300.0
2013-05-15 13:30:00	MSFT	Stock	33.664	33.69	33.64	33.65	2162726.0
2013-05-15 14:00:00	MSFT	Stock	33.65	33.71	33.583	33.61	2520244.0
2013-05-15 14:30:00	MSFT	Stock	33.61	33.7	33.61	33.675	2445736.0
2013-05-15 15:00:00	MSFT	Stock	33.675	33.81	33.62	33.77	3344457.0

> showing 50 of 79,601 rows — these rows as CSV

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