PREVIEW / stock_30min / 2011-02-14

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-02-14.parquet
  size:    1.4 MB
  rows:    76,274
  symbols: 3,563

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
2011-02-14 04:00:00	AAPL	Stock	12.7436	12.7521	12.7436	12.7518	19600.0
2011-02-14 04:30:00	AAPL	Stock	12.7393	12.7393	12.7393	12.7393	2800.0
2011-02-14 05:00:00	AAPL	Stock	12.7396	12.7425	12.7393	12.7393	19600.0
2011-02-14 06:30:00	AAPL	Stock	12.7393	12.7636	12.7393	12.7636	5600.0
2011-02-14 07:00:00	AAPL	Stock	12.7393	12.7714	12.7232	12.7714	105700.0
2011-02-14 07:30:00	AAPL	Stock	12.7829	12.7996	12.7682	12.7704	388360.0
2011-02-14 08:00:00	AAPL	Stock	12.775	12.7768	12.74	12.75	1084076.0
2011-02-14 08:30:00	AAPL	Stock	12.7482	12.7507	12.7364	12.7482	457800.0
2011-02-14 09:00:00	AAPL	Stock	12.7482	12.7543	12.7382	12.7382	1116416.0
2011-02-14 09:30:00	AAPL	Stock	12.7436	12.8386	12.7396	12.8125	62420652.0
2011-02-14 10:00:00	AAPL	Stock	12.8136	12.8321	12.8054	12.825	30670304.0
2011-02-14 10:30:00	AAPL	Stock	12.8267	12.8325	12.7882	12.8014	26042016.0
2011-02-14 11:00:00	AAPL	Stock	12.8014	12.83	12.8014	12.8082	17685556.0
2011-02-14 11:30:00	AAPL	Stock	12.8082	12.8268	12.8071	12.8261	12580876.0
2011-02-14 12:00:00	AAPL	Stock	12.8268	12.8375	12.8214	12.8229	21198380.0
2011-02-14 12:30:00	AAPL	Stock	12.8243	12.825	12.8143	12.8214	12857320.0
2011-02-14 13:00:00	AAPL	Stock	12.8218	12.825	12.8146	12.821	7769132.0
2011-02-14 13:30:00	AAPL	Stock	12.82	12.8282	12.82	12.8211	8594712.0
2011-02-14 14:00:00	AAPL	Stock	12.8218	12.8243	12.8071	12.81	14131180.0
2011-02-14 14:30:00	AAPL	Stock	12.811	12.8221	12.8075	12.8196	10195668.0
2011-02-14 15:00:00	AAPL	Stock	12.8196	12.8286	12.8153	12.8171	16979592.0
2011-02-14 15:30:00	AAPL	Stock	12.8161	12.8279	12.8107	12.8279	31541804.0
2011-02-14 16:00:00	AAPL	Stock	12.8279	12.8286	12.7395	12.8246	28511644.0
2011-02-14 16:30:00	AAPL	Stock	12.82	12.8204	12.8079	12.8107	464800.0
2011-02-14 17:00:00	AAPL	Stock	12.8107	12.8175	12.8093	12.8146	143948.0
2011-02-14 17:30:00	AAPL	Stock	12.8143	12.8143	12.8107	12.8125	42280.0
2011-02-14 18:00:00	AAPL	Stock	12.8093	12.8279	12.8093	12.8161	71428.0
2011-02-14 18:30:00	AAPL	Stock	12.8146	12.8175	12.8125	12.8146	77224.0
2011-02-14 19:00:00	AAPL	Stock	12.8161	12.8171	12.8132	12.8132	68768.0
2011-02-14 19:30:00	AAPL	Stock	12.8143	12.8179	12.8125	12.8146	153468.0
2011-02-14 06:30:00	MSFT	Stock	27.37	27.37	27.37	27.37	700.0
2011-02-14 07:00:00	MSFT	Stock	27.37	27.37	27.36	27.37	2600.0
2011-02-14 07:30:00	MSFT	Stock	27.4	27.4	27.32	27.33	748.0
2011-02-14 08:00:00	MSFT	Stock	27.34	27.34	27.31	27.32	6730.0
2011-02-14 08:30:00	MSFT	Stock	27.32	27.33	27.31	27.32	5220.0
2011-02-14 09:00:00	MSFT	Stock	27.31	27.37	27.2	27.2	156306.0
2011-02-14 09:30:00	MSFT	Stock	27.205	27.27	26.95	26.99	7749753.0
2011-02-14 10:00:00	MSFT	Stock	26.987	27.08	26.95	27.05	5214430.0
2011-02-14 10:30:00	MSFT	Stock	27.05	27.13	27.03	27.115	4023172.0
2011-02-14 11:00:00	MSFT	Stock	27.11	27.25	27.09	27.15	4025589.0
2011-02-14 11:30:00	MSFT	Stock	27.15	27.19	27.12	27.14	1905708.0
2011-02-14 12:00:00	MSFT	Stock	27.15	27.25	27.14	27.21	2551263.0
2011-02-14 12:30:00	MSFT	Stock	27.21	27.215	27.07	27.089	3332392.0
2011-02-14 13:00:00	MSFT	Stock	27.08	27.19	27.08	27.15	2324918.0
2011-02-14 13:30:00	MSFT	Stock	27.15	27.17	27.12	27.12	1574357.0
2011-02-14 14:00:00	MSFT	Stock	27.125	27.13	27.08	27.105	2779020.0
2011-02-14 14:30:00	MSFT	Stock	27.101	27.12	27.04	27.085	3065598.0
2011-02-14 15:00:00	MSFT	Stock	27.085	27.09	27.02	27.08	5160149.0
2011-02-14 15:30:00	MSFT	Stock	27.075	27.23	27.07	27.23	8421730.0
2011-02-14 16:00:00	MSFT	Stock	27.23	27.27	27.104	27.18	1494651.0

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

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