PREVIEW / stock_30min / 2013-01-11

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-01-11.parquet
  size:    1.4 MB
  rows:    75,646
  symbols: 3,464

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-01-11 04:00:00	AAPL	Stock	18.7321	18.7321	18.7321	18.7321	2800.0
2013-01-11 04:30:00	AAPL	Stock	18.7143	18.7143	18.7143	18.7143	2800.0
2013-01-11 05:00:00	AAPL	Stock	18.7054	18.7054	18.7054	18.7054	120400.0
2013-01-11 05:30:00	AAPL	Stock	18.7057	18.7057	18.7054	18.7054	31612.0
2013-01-11 06:00:00	AAPL	Stock	18.6964	18.6964	18.6964	18.6964	28000.0
2013-01-11 06:30:00	AAPL	Stock	18.7214	18.7214	18.6961	18.6961	5600.0
2013-01-11 07:00:00	AAPL	Stock	18.6964	18.7036	18.6429	18.6429	150920.0
2013-01-11 07:30:00	AAPL	Stock	18.6561	18.6839	18.6071	18.6071	211064.0
2013-01-11 08:00:00	AAPL	Stock	18.6225	18.6964	18.5593	18.6143	1468768.0
2013-01-11 08:30:00	AAPL	Stock	18.6125	18.6211	18.5589	18.5846	1168440.0
2013-01-11 09:00:00	AAPL	Stock	18.5807	18.6143	18.5721	18.6071	1156204.0
2013-01-11 09:30:00	AAPL	Stock	18.6071	18.7614	18.5364	18.6434	72548168.0
2013-01-11 10:00:00	AAPL	Stock	18.6457	18.6643	18.545	18.5807	34115452.0
2013-01-11 10:30:00	AAPL	Stock	18.5853	18.6464	18.5718	18.6411	17726660.0
2013-01-11 11:00:00	AAPL	Stock	18.6414	18.6525	18.5771	18.578	14979468.0
2013-01-11 11:30:00	AAPL	Stock	18.5789	18.6204	18.55	18.6161	17177972.0
2013-01-11 12:00:00	AAPL	Stock	18.6204	18.6339	18.5864	18.595	10164308.0
2013-01-11 12:30:00	AAPL	Stock	18.595	18.6186	18.5857	18.6082	9037252.0
2013-01-11 13:00:00	AAPL	Stock	18.6093	18.6202	18.5943	18.6079	8441440.0
2013-01-11 13:30:00	AAPL	Stock	18.6071	18.6996	18.6061	18.6368	30171764.0
2013-01-11 14:00:00	AAPL	Stock	18.6368	18.6754	18.6	18.6714	17243492.0
2013-01-11 14:30:00	AAPL	Stock	18.6746	18.6807	18.61	18.6214	15061956.0
2013-01-11 15:00:00	AAPL	Stock	18.6221	18.6314	18.5596	18.595	24690652.0
2013-01-11 15:30:00	AAPL	Stock	18.5989	18.6011	18.5532	18.5757	42333984.0
2013-01-11 16:00:00	AAPL	Stock	18.5783	18.6179	18.5679	18.5786	25520936.0
2013-01-11 16:30:00	AAPL	Stock	18.5791	18.5948	18.5714	18.5732	704592.0
2013-01-11 17:00:00	AAPL	Stock	18.5764	18.5821	18.5732	18.5732	153412.0
2013-01-11 17:30:00	AAPL	Stock	18.5786	18.5818	18.5739	18.5739	111860.0
2013-01-11 18:00:00	AAPL	Stock	18.575	18.58	18.5739	18.5739	104468.0
2013-01-11 18:30:00	AAPL	Stock	18.5743	18.58	18.5736	18.5796	32340.0
2013-01-11 19:00:00	AAPL	Stock	18.58	18.5839	18.5764	18.5839	142436.0
2013-01-11 19:30:00	AAPL	Stock	18.5893	18.5893	18.5821	18.5893	75740.0
2013-01-11 04:30:00	MSFT	Stock	26.6	26.6	26.6	26.6	100.0
2013-01-11 05:00:00	MSFT	Stock	26.48	26.49	26.47	26.47	2500.0
2013-01-11 05:30:00	MSFT	Stock	26.47	26.47	26.44	26.44	3100.0
2013-01-11 06:30:00	MSFT	Stock	26.47	26.47	26.47	26.47	2200.0
2013-01-11 07:00:00	MSFT	Stock	26.47	26.47	26.45	26.45	1500.0
2013-01-11 07:30:00	MSFT	Stock	26.51	26.57	26.51	26.56	4100.0
2013-01-11 08:00:00	MSFT	Stock	26.46	26.5	26.4	26.49	22439.0
2013-01-11 08:30:00	MSFT	Stock	26.47	26.49	26.46	26.49	6987.0
2013-01-11 09:00:00	MSFT	Stock	26.48	26.49	26.45	26.47	21205.0
2013-01-11 09:30:00	MSFT	Stock	26.49	26.5	26.28	26.325	7868932.0
2013-01-11 10:00:00	MSFT	Stock	26.325	26.42	26.32	26.375	3388432.0
2013-01-11 10:30:00	MSFT	Stock	26.376	26.47	26.35	26.445	5368619.0
2013-01-11 11:00:00	MSFT	Stock	26.445	26.75	26.44	26.7	4844067.0
2013-01-11 11:30:00	MSFT	Stock	26.7	26.706	26.64	26.65	3216969.0
2013-01-11 12:00:00	MSFT	Stock	26.65	26.72	26.64	26.72	2418800.0
2013-01-11 12:30:00	MSFT	Stock	26.72	26.74	26.65	26.726	2564523.0
2013-01-11 13:00:00	MSFT	Stock	26.725	26.77	26.71	26.73	2430560.0
2013-01-11 13:30:00	MSFT	Stock	26.73	26.78	26.72	26.72	2268523.0

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

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