PREVIEW / stock_30min / 2012-07-10

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-07-10.parquet
  size:    1.4 MB
  rows:    74,612
  symbols: 3,505

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-07-10 04:00:00	AAPL	Stock	21.8775	21.8789	21.8775	21.8775	19600.0
2012-07-10 05:00:00	AAPL	Stock	21.9657	21.975	21.965	21.975	33600.0
2012-07-10 05:30:00	AAPL	Stock	21.975	22.0321	21.975	22.0321	19572.0
2012-07-10 06:00:00	AAPL	Stock	21.9893	21.9893	21.9821	21.9893	120876.0
2012-07-10 07:00:00	AAPL	Stock	22.0139	22.0393	21.9625	21.9829	1034600.0
2012-07-10 07:30:00	AAPL	Stock	21.9821	22.0214	21.9725	22.0089	681240.0
2012-07-10 08:00:00	AAPL	Stock	22.0039	22.0739	21.9682	22.0429	4514104.0
2012-07-10 08:30:00	AAPL	Stock	22.0429	22.0518	22.0089	22.0357	2131976.0
2012-07-10 09:00:00	AAPL	Stock	22.0346	22.0836	22.0346	22.0682	3428292.0
2012-07-10 09:30:00	AAPL	Stock	22.0689	22.1382	22.0286	22.063	86299948.0
2012-07-10 10:00:00	AAPL	Stock	22.0671	22.0996	21.9554	22.0393	58088296.0
2012-07-10 10:30:00	AAPL	Stock	22.0386	22.0661	21.9468	21.9671	35481544.0
2012-07-10 11:00:00	AAPL	Stock	21.9675	21.9789	21.8571	21.96	46854080.0
2012-07-10 11:30:00	AAPL	Stock	21.9596	21.9839	21.9296	21.9525	18552380.0
2012-07-10 12:00:00	AAPL	Stock	21.9546	21.9571	21.8839	21.9325	17354204.0
2012-07-10 12:30:00	AAPL	Stock	21.9254	21.9907	21.9216	21.9479	15216964.0
2012-07-10 13:00:00	AAPL	Stock	21.9493	21.9961	21.9196	21.9239	17906448.0
2012-07-10 13:30:00	AAPL	Stock	21.9227	21.9582	21.9021	21.9321	17572828.0
2012-07-10 14:00:00	AAPL	Stock	21.9304	21.9336	21.8036	21.8071	26803532.0
2012-07-10 14:30:00	AAPL	Stock	21.8056	21.8393	21.6821	21.7146	54582976.0
2012-07-10 15:00:00	AAPL	Stock	21.7143	21.7946	21.6364	21.6522	37970408.0
2012-07-10 15:30:00	AAPL	Stock	21.6511	21.7561	21.6182	21.7196	48651484.0
2012-07-10 16:00:00	AAPL	Stock	21.7196	21.9167	21.685	21.7143	9306164.0
2012-07-10 16:30:00	AAPL	Stock	21.7154	21.987	21.6607	21.7136	571816.0
2012-07-10 17:00:00	AAPL	Stock	21.7218	21.7218	21.6964	21.7021	785456.0
2012-07-10 17:30:00	AAPL	Stock	21.7018	21.7114	21.6857	21.6857	108584.0
2012-07-10 18:00:00	AAPL	Stock	21.6954	21.6964	21.65	21.65	349384.0
2012-07-10 18:30:00	AAPL	Stock	21.6571	21.6664	21.645	21.6532	81032.0
2012-07-10 19:00:00	AAPL	Stock	21.6536	21.6536	21.6393	21.6536	150528.0
2012-07-10 19:30:00	AAPL	Stock	21.6625	21.6671	21.6482	21.6571	193872.0
2012-07-10 07:30:00	MSFT	Stock	30.14	30.15	30.14	30.15	1300.0
2012-07-10 08:00:00	MSFT	Stock	30.06	30.15	29.97	30.15	2117.0
2012-07-10 08:30:00	MSFT	Stock	30.1	30.2	30.09	30.13	29453.0
2012-07-10 09:00:00	MSFT	Stock	30.15	30.21	30.05	30.07	43607.0
2012-07-10 09:30:00	MSFT	Stock	30.08	30.22	30.06	30.15	3969193.0
2012-07-10 10:00:00	MSFT	Stock	30.16	30.17	29.94	29.985	3161085.0
2012-07-10 10:30:00	MSFT	Stock	29.98	29.99	29.78	29.825	2730069.0
2012-07-10 11:00:00	MSFT	Stock	29.82	29.83	29.61	29.765	2996276.0
2012-07-10 11:30:00	MSFT	Stock	29.77	29.79	29.72	29.74	1949546.0
2012-07-10 12:00:00	MSFT	Stock	29.74	29.765	29.66	29.71	1652186.0
2012-07-10 12:30:00	MSFT	Stock	29.7	29.8	29.69	29.767	1184303.0
2012-07-10 13:00:00	MSFT	Stock	29.76	29.77	29.68	29.695	951131.0
2012-07-10 13:30:00	MSFT	Stock	29.695	29.74	29.66	29.715	1466898.0
2012-07-10 14:00:00	MSFT	Stock	29.715	29.74	29.62	29.63	1382357.0
2012-07-10 14:30:00	MSFT	Stock	29.64	29.64	29.52	29.56	2074158.0
2012-07-10 15:00:00	MSFT	Stock	29.551	29.67	29.52	29.52	2322926.0
2012-07-10 15:30:00	MSFT	Stock	29.52	29.77	29.51	29.74	7963730.0
2012-07-10 16:00:00	MSFT	Stock	29.74	30.05	29.575	29.668	2239898.0
2012-07-10 16:30:00	MSFT	Stock	29.535	29.8	29.535	29.8	149433.0
2012-07-10 17:00:00	MSFT	Stock	29.74	29.75	29.74	29.75	165380.0

> showing 50 of 74,612 rows — these rows as CSV

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