PREVIEW / stock_30min / 2012-04-05

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-04-05.parquet
  size:    1.4 MB
  rows:    73,495
  symbols: 3,484

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-04-05 04:00:00	AAPL	Stock	22.3136	22.35	22.3136	22.3214	53200.0
2012-04-05 05:00:00	AAPL	Stock	22.2996	22.3286	22.2996	22.3	123200.0
2012-04-05 05:30:00	AAPL	Stock	22.3036	22.3036	22.25	22.25	59920.0
2012-04-05 06:00:00	AAPL	Stock	22.2168	22.2168	22.1436	22.1911	161728.0
2012-04-05 06:30:00	AAPL	Stock	22.2139	22.2604	22.2139	22.2286	28756.0
2012-04-05 07:00:00	AAPL	Stock	22.2464	22.3125	22.2464	22.2964	254072.0
2012-04-05 07:30:00	AAPL	Stock	22.29	22.2954	22.2536	22.2857	383236.0
2012-04-05 08:00:00	AAPL	Stock	22.2786	22.3054	22.2161	22.2857	2225216.0
2012-04-05 08:30:00	AAPL	Stock	22.2857	22.4186	22.2857	22.3964	6352444.0
2012-04-05 09:00:00	AAPL	Stock	22.4	22.4039	22.3364	22.4039	2756432.0
2012-04-05 09:30:00	AAPL	Stock	22.3946	22.4011	22.2643	22.2854	73569916.0
2012-04-05 10:00:00	AAPL	Stock	22.2846	22.325	22.2796	22.2986	33364856.0
2012-04-05 10:30:00	AAPL	Stock	22.2993	22.4086	22.2968	22.4086	43741376.0
2012-04-05 11:00:00	AAPL	Stock	22.4068	22.4961	22.3936	22.4736	60305700.0
2012-04-05 11:30:00	AAPL	Stock	22.4764	22.5311	22.4471	22.5304	30818480.0
2012-04-05 12:00:00	AAPL	Stock	22.5298	22.6104	22.5143	22.6086	66843224.0
2012-04-05 12:30:00	AAPL	Stock	22.6086	22.6664	22.5429	22.5561	68290124.0
2012-04-05 13:00:00	AAPL	Stock	22.5572	22.6011	22.5111	22.5871	42296212.0
2012-04-05 13:30:00	AAPL	Stock	22.5811	22.5954	22.5254	22.5486	28128268.0
2012-04-05 14:00:00	AAPL	Stock	22.5482	22.5868	22.5289	22.5655	19810056.0
2012-04-05 14:30:00	AAPL	Stock	22.5657	22.5982	22.5454	22.5811	24797920.0
2012-04-05 15:00:00	AAPL	Stock	22.5811	22.6204	22.5286	22.6107	39428760.0
2012-04-05 15:30:00	AAPL	Stock	22.6107	22.635	22.5961	22.6311	71272908.0
2012-04-05 16:00:00	AAPL	Stock	22.6314	22.6425	22.302	22.6375	12749016.0
2012-04-05 16:30:00	AAPL	Stock	22.6357	22.6389	22.63	22.6321	521136.0
2012-04-05 17:00:00	AAPL	Stock	22.6314	22.6375	22.6261	22.6304	247800.0
2012-04-05 17:30:00	AAPL	Stock	22.6304	22.6357	22.625	22.625	261044.0
2012-04-05 18:00:00	AAPL	Stock	22.6296	22.6371	22.6268	22.6371	220220.0
2012-04-05 18:30:00	AAPL	Stock	22.6368	22.6486	22.6339	22.6411	520464.0
2012-04-05 19:00:00	AAPL	Stock	22.6393	22.6429	22.6375	22.6425	143220.0
2012-04-05 19:30:00	AAPL	Stock	22.6425	22.655	22.6382	22.655	112252.0
2012-04-05 06:30:00	MSFT	Stock	31.27	31.27	31.1	31.1	200.0
2012-04-05 08:00:00	MSFT	Stock	31.25	31.25	31.14	31.14	8416.0
2012-04-05 08:30:00	MSFT	Stock	31.17	31.25	31.15	31.25	4751.0
2012-04-05 09:00:00	MSFT	Stock	31.3	31.3	31.09	31.16	5065.0
2012-04-05 09:30:00	MSFT	Stock	31.15	31.29	31.05	31.247	2348647.0
2012-04-05 10:00:00	MSFT	Stock	31.245	31.34	31.24	31.29	2552716.0
2012-04-05 10:30:00	MSFT	Stock	31.282	31.558	31.28	31.55	3346113.0
2012-04-05 11:00:00	MSFT	Stock	31.56	31.56	31.47	31.475	2540619.0
2012-04-05 11:30:00	MSFT	Stock	31.47	31.58	31.41	31.57	2244385.0
2012-04-05 12:00:00	MSFT	Stock	31.57	31.63	31.53	31.55	1699420.0
2012-04-05 12:30:00	MSFT	Stock	31.55	31.6	31.54	31.595	1396676.0
2012-04-05 13:00:00	MSFT	Stock	31.6	31.63	31.52	31.538	1567794.0
2012-04-05 13:30:00	MSFT	Stock	31.53	31.56	31.49	31.52	1515497.0
2012-04-05 14:00:00	MSFT	Stock	31.525	31.54	31.41	31.44	1672064.0
2012-04-05 14:30:00	MSFT	Stock	31.44	31.52	31.43	31.45	1879875.0
2012-04-05 15:00:00	MSFT	Stock	31.442	31.53	31.43	31.52	4483776.0
2012-04-05 15:30:00	MSFT	Stock	31.512	31.56	31.46	31.508	5693947.0
2012-04-05 16:00:00	MSFT	Stock	31.51	31.555	31.39	31.45	4242599.0
2012-04-05 16:30:00	MSFT	Stock	31.43	31.54	31.43	31.5	1800.0

> showing 50 of 73,495 rows — these rows as CSV

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