PREVIEW / stock_30min / 2012-06-05

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-06-05.parquet
  size:    1.4 MB
  rows:    75,085
  symbols: 3,513

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-06-05 05:00:00	AAPL	Stock	20.0179	20.0536	20.0179	20.0536	14280.0
2012-06-05 05:30:00	AAPL	Stock	20.0432	20.0432	20.0286	20.0286	30800.0
2012-06-05 06:00:00	AAPL	Stock	20.07	20.07	20.07	20.07	2800.0
2012-06-05 06:30:00	AAPL	Stock	20.0632	20.0632	20.0632	20.0632	2800.0
2012-06-05 07:00:00	AAPL	Stock	20.0475	20.0643	20.02	20.035	164780.0
2012-06-05 07:30:00	AAPL	Stock	20.0304	20.0961	20.0268	20.0961	236880.0
2012-06-05 08:00:00	AAPL	Stock	20.0929	20.1225	20.0629	20.1054	578284.0
2012-06-05 08:30:00	AAPL	Stock	20.0929	20.1536	20.09	20.1407	758128.0
2012-06-05 09:00:00	AAPL	Stock	20.135	20.1429	20.0196	20.0311	1796788.0
2012-06-05 09:30:00	AAPL	Stock	20.0454	20.2275	20.0214	20.1148	63382900.0
2012-06-05 10:00:00	AAPL	Stock	20.1152	20.2311	20.059	20.0857	50768900.0
2012-06-05 10:30:00	AAPL	Stock	20.0843	20.1346	20.0311	20.0929	29154804.0
2012-06-05 11:00:00	AAPL	Stock	20.0929	20.1712	20.0757	20.1143	19876668.0
2012-06-05 11:30:00	AAPL	Stock	20.11	20.1261	20.0107	20.04	20625612.0
2012-06-05 12:00:00	AAPL	Stock	20.046	20.0911	19.9404	19.9852	26300960.0
2012-06-05 12:30:00	AAPL	Stock	19.9871	20.0818	19.9868	20.0282	21578788.0
2012-06-05 13:00:00	AAPL	Stock	20.0271	20.0357	19.9596	20.0186	14339920.0
2012-06-05 13:30:00	AAPL	Stock	20.0193	20.1204	20.0171	20.0936	24488492.0
2012-06-05 14:00:00	AAPL	Stock	20.0975	20.1532	20.0536	20.1336	19924800.0
2012-06-05 14:30:00	AAPL	Stock	20.1325	20.1493	20.0783	20.1357	20700036.0
2012-06-05 15:00:00	AAPL	Stock	20.1354	20.1511	20.0621	20.1035	18707136.0
2012-06-05 15:30:00	AAPL	Stock	20.0989	20.1771	20.0918	20.0957	43887144.0
2012-06-05 16:00:00	AAPL	Stock	20.0957	20.1252	20.0739	20.0964	8461880.0
2012-06-05 16:30:00	AAPL	Stock	20.1089	20.1107	20.0964	20.1	361508.0
2012-06-05 17:00:00	AAPL	Stock	20.0968	20.1071	20.0964	20.1071	49168.0
2012-06-05 17:30:00	AAPL	Stock	20.1071	20.1071	20.0893	20.1067	111776.0
2012-06-05 18:00:00	AAPL	Stock	20.1054	20.1054	20.1036	20.1036	8960.0
2012-06-05 18:30:00	AAPL	Stock	20.1036	20.1071	20.0986	20.1071	32368.0
2012-06-05 19:00:00	AAPL	Stock	20.1075	20.1143	20.1071	20.1143	49980.0
2012-06-05 19:30:00	AAPL	Stock	20.1179	20.1607	20.1179	20.1607	232708.0
2012-06-05 04:30:00	MSFT	Stock	28.5	28.5	28.5	28.5	200.0
2012-06-05 05:00:00	MSFT	Stock	28.5	28.5	28.5	28.5	100.0
2012-06-05 05:30:00	MSFT	Stock	28.5	28.5	28.5	28.5	600.0
2012-06-05 06:30:00	MSFT	Stock	28.54	28.54	28.54	28.54	100.0
2012-06-05 07:30:00	MSFT	Stock	28.49	28.49	28.49	28.49	200.0
2012-06-05 08:00:00	MSFT	Stock	28.49	28.55	28.45	28.54	3745.0
2012-06-05 08:30:00	MSFT	Stock	28.51	28.6	28.5	28.55	7275.0
2012-06-05 09:00:00	MSFT	Stock	28.54	28.55	28.4	28.51	56213.0
2012-06-05 09:30:00	MSFT	Stock	28.54	28.69	28.5	28.56	4516068.0
2012-06-05 10:00:00	MSFT	Stock	28.56	28.75	28.54	28.7	4145951.0
2012-06-05 10:30:00	MSFT	Stock	28.69	28.71	28.54	28.61	2964034.0
2012-06-05 11:00:00	MSFT	Stock	28.62	28.695	28.59	28.62	3067917.0
2012-06-05 11:30:00	MSFT	Stock	28.626	28.69	28.395	28.4	3954046.0
2012-06-05 12:00:00	MSFT	Stock	28.4	28.49	28.39	28.44	3001455.0
2012-06-05 12:30:00	MSFT	Stock	28.45	28.54	28.44	28.53	3033887.0
2012-06-05 13:00:00	MSFT	Stock	28.522	28.55	28.47	28.53	2347957.0
2012-06-05 13:30:00	MSFT	Stock	28.53	28.55	28.48	28.53	2250120.0
2012-06-05 14:00:00	MSFT	Stock	28.53	28.61	28.52	28.6	2299668.0
2012-06-05 14:30:00	MSFT	Stock	28.595	28.61	28.52	28.545	2137724.0
2012-06-05 15:00:00	MSFT	Stock	28.545	28.6	28.45	28.46	3074024.0

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

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