PREVIEW / stock_30min / 2011-07-13

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-07-13.parquet
  size:    1.4 MB
  rows:    75,027
  symbols: 3,534

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-07-13 04:00:00	AAPL	Stock	12.7129	12.7132	12.6964	12.6964	14000.0
2011-07-13 04:30:00	AAPL	Stock	12.6964	12.7018	12.6964	12.7018	16800.0
2011-07-13 05:00:00	AAPL	Stock	12.7018	12.7018	12.7018	12.7018	2800.0
2011-07-13 05:30:00	AAPL	Stock	12.7125	12.7475	12.7121	12.7475	46200.0
2011-07-13 06:00:00	AAPL	Stock	12.7179	12.7336	12.7179	12.7293	17360.0
2011-07-13 06:30:00	AAPL	Stock	12.7257	12.7429	12.7214	12.725	28000.0
2011-07-13 07:00:00	AAPL	Stock	12.7254	12.7686	12.725	12.7646	257684.0
2011-07-13 07:30:00	AAPL	Stock	12.7707	12.8	12.7654	12.7768	262920.0
2011-07-13 08:00:00	AAPL	Stock	12.7707	12.7839	12.7504	12.7607	1196608.0
2011-07-13 08:30:00	AAPL	Stock	12.7575	12.7768	12.7443	12.7482	643020.0
2011-07-13 09:00:00	AAPL	Stock	12.75	12.7975	12.7361	12.7975	1895796.0
2011-07-13 09:30:00	AAPL	Stock	12.7975	12.8354	12.7582	12.7725	76918100.0
2011-07-13 10:00:00	AAPL	Stock	12.7718	12.8404	12.7707	12.8143	48047496.0
2011-07-13 10:30:00	AAPL	Stock	12.8164	12.8496	12.8143	12.8473	24021760.0
2011-07-13 11:00:00	AAPL	Stock	12.8475	12.8571	12.8286	12.8514	27157508.0
2011-07-13 11:30:00	AAPL	Stock	12.8514	12.8536	12.8268	12.8418	20395592.0
2011-07-13 12:00:00	AAPL	Stock	12.8421	12.8436	12.8179	12.8314	15002848.0
2011-07-13 12:30:00	AAPL	Stock	12.8314	12.8364	12.8071	12.81	11665724.0
2011-07-13 13:00:00	AAPL	Stock	12.8093	12.8279	12.7939	12.8268	18893140.0
2011-07-13 13:30:00	AAPL	Stock	12.8271	12.8311	12.8018	12.8125	10162908.0
2011-07-13 14:00:00	AAPL	Stock	12.8125	12.8279	12.7814	12.7961	18474428.0
2011-07-13 14:30:00	AAPL	Stock	12.7968	12.8264	12.7921	12.8207	13619312.0
2011-07-13 15:00:00	AAPL	Stock	12.8204	12.8268	12.7611	12.7911	39519312.0
2011-07-13 15:30:00	AAPL	Stock	12.7914	12.7964	12.7279	12.7907	49519848.0
2011-07-13 16:00:00	AAPL	Stock	12.7893	12.8076	12.7732	12.7929	9395176.0
2011-07-13 16:30:00	AAPL	Stock	12.7929	12.8036	12.7504	12.8032	454552.0
2011-07-13 17:00:00	AAPL	Stock	12.8	12.8	12.7143	12.7143	849436.0
2011-07-13 17:30:00	AAPL	Stock	12.7143	12.7143	12.6964	12.7136	463008.0
2011-07-13 18:00:00	AAPL	Stock	12.7143	12.7864	12.7129	12.725	381780.0
2011-07-13 18:30:00	AAPL	Stock	12.7354	12.7375	12.7207	12.7375	78652.0
2011-07-13 19:00:00	AAPL	Stock	12.74	12.7464	12.7286	12.7375	124600.0
2011-07-13 19:30:00	AAPL	Stock	12.7382	12.7382	12.72	12.725	172648.0
2011-07-13 06:30:00	MSFT	Stock	26.7	26.7	26.7	26.7	250.0
2011-07-13 07:00:00	MSFT	Stock	26.65	26.65	26.65	26.65	200.0
2011-07-13 07:30:00	MSFT	Stock	26.68	26.68	26.68	26.68	100.0
2011-07-13 08:00:00	MSFT	Stock	26.71	26.72	26.66	26.7	11077.0
2011-07-13 08:30:00	MSFT	Stock	26.68	26.68	24.0	26.61	86789.0
2011-07-13 09:00:00	MSFT	Stock	26.6	26.65	26.57	26.65	8100.0
2011-07-13 09:30:00	MSFT	Stock	26.64	26.75	26.6	26.71	4090949.0
2011-07-13 10:00:00	MSFT	Stock	26.7	26.95	26.7	26.89	4630684.0
2011-07-13 10:30:00	MSFT	Stock	26.89	26.96	26.88	26.91	3348943.0
2011-07-13 11:00:00	MSFT	Stock	26.92	26.939	26.89	26.912	2047957.0
2011-07-13 11:30:00	MSFT	Stock	26.915	26.92	26.84	26.89	1651064.0
2011-07-13 12:00:00	MSFT	Stock	26.89	26.9	26.82	26.855	1282792.0
2011-07-13 12:30:00	MSFT	Stock	26.86	26.88	26.83	26.851	2104797.0
2011-07-13 13:00:00	MSFT	Stock	26.853	26.9	26.83	26.87	1922165.0
2011-07-13 13:30:00	MSFT	Stock	26.87	26.88	26.76	26.77	2130034.0
2011-07-13 14:00:00	MSFT	Stock	26.78	26.85	26.71	26.75	2229684.0
2011-07-13 14:30:00	MSFT	Stock	26.75	26.77	26.69	26.76	2304649.0
2011-07-13 15:00:00	MSFT	Stock	26.76	26.8	26.55	26.64	2954417.0

> showing 50 of 75,027 rows — these rows as CSV

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