PREVIEW / stock_30min / 2011-03-25

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-25.parquet
  size:    1.4 MB
  rows:    74,357
  symbols: 3,514

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-03-25 04:00:00	AAPL	Stock	12.395	12.4032	12.3886	12.4032	22400.0
2011-03-25 04:30:00	AAPL	Stock	12.3971	12.4	12.3893	12.3893	19600.0
2011-03-25 05:30:00	AAPL	Stock	12.3982	12.3982	12.3982	12.3982	2800.0
2011-03-25 06:00:00	AAPL	Stock	12.3982	12.4368	12.3982	12.4368	28000.0
2011-03-25 06:30:00	AAPL	Stock	12.4343	12.4446	12.4071	12.425	43400.0
2011-03-25 07:00:00	AAPL	Stock	12.4286	12.4289	12.4154	12.4246	201628.0
2011-03-25 07:30:00	AAPL	Stock	12.4171	12.4286	12.4054	12.4143	376264.0
2011-03-25 08:00:00	AAPL	Stock	12.4111	12.4286	12.4111	12.4114	1173004.0
2011-03-25 08:30:00	AAPL	Stock	12.4143	12.4268	12.3929	12.4143	1486184.0
2011-03-25 09:00:00	AAPL	Stock	12.4143	12.4318	12.4043	12.4264	1987972.0
2011-03-25 09:30:00	AAPL	Stock	12.4304	12.5261	12.3936	12.5053	94076108.0
2011-03-25 10:00:00	AAPL	Stock	12.5029	12.5132	12.4621	12.4979	39603340.0
2011-03-25 10:30:00	AAPL	Stock	12.4982	12.5411	12.4936	12.5366	37967552.0
2011-03-25 11:00:00	AAPL	Stock	12.5375	12.5593	12.5204	12.5357	31198356.0
2011-03-25 11:30:00	AAPL	Stock	12.5356	12.5657	12.5304	12.5625	23100840.0
2011-03-25 12:00:00	AAPL	Stock	12.5614	12.5643	12.5414	12.5429	16957948.0
2011-03-25 12:30:00	AAPL	Stock	12.5429	12.5457	12.5214	12.5231	20266232.0
2011-03-25 13:00:00	AAPL	Stock	12.5234	12.5357	12.5096	12.5343	19275200.0
2011-03-25 13:30:00	AAPL	Stock	12.5357	12.5482	12.5171	12.5261	17367420.0
2011-03-25 14:00:00	AAPL	Stock	12.5243	12.53	12.4993	12.5017	19472292.0
2011-03-25 14:30:00	AAPL	Stock	12.5018	12.5257	12.4943	12.5232	18740008.0
2011-03-25 15:00:00	AAPL	Stock	12.5229	12.5371	12.5061	12.5131	24508400.0
2011-03-25 15:30:00	AAPL	Stock	12.5129	12.5736	12.5096	12.5568	60415180.0
2011-03-25 16:00:00	AAPL	Stock	12.555	12.57	12.4182	12.5589	9021096.0
2011-03-25 16:30:00	AAPL	Stock	12.5586	12.5664	12.5089	12.5589	435288.0
2011-03-25 17:00:00	AAPL	Stock	12.565	12.5871	12.555	12.555	1138396.0
2011-03-25 17:30:00	AAPL	Stock	12.5764	12.5814	12.5718	12.575	257936.0
2011-03-25 18:00:00	AAPL	Stock	12.5807	12.5818	12.555	12.5754	118524.0
2011-03-25 18:30:00	AAPL	Stock	12.575	12.5793	12.5736	12.5793	75040.0
2011-03-25 19:00:00	AAPL	Stock	12.5771	12.5818	12.5771	12.5811	103964.0
2011-03-25 19:30:00	AAPL	Stock	12.5811	12.5829	12.5714	12.5821	291648.0
2011-03-25 06:30:00	MSFT	Stock	26.0	26.0	25.95	25.95	480.0
2011-03-25 07:00:00	MSFT	Stock	25.86	25.86	25.86	25.86	100.0
2011-03-25 07:30:00	MSFT	Stock	25.97	25.97	25.86	25.93	700.0
2011-03-25 08:00:00	MSFT	Stock	25.92	25.96	25.89	25.92	10800.0
2011-03-25 08:30:00	MSFT	Stock	25.9	25.92	25.86	25.89	4237.0
2011-03-25 09:00:00	MSFT	Stock	25.89	25.97	25.86	25.97	70132.0
2011-03-25 09:30:00	MSFT	Stock	25.96	25.96	25.71	25.72	5425894.0
2011-03-25 10:00:00	MSFT	Stock	25.72	25.75	25.68	25.718	4356859.0
2011-03-25 10:30:00	MSFT	Stock	25.72	25.76	25.7	25.718	4189787.0
2011-03-25 11:00:00	MSFT	Stock	25.715	25.721	25.65	25.68	4539996.0
2011-03-25 11:30:00	MSFT	Stock	25.68	25.69	25.65	25.67	3411050.0
2011-03-25 12:00:00	MSFT	Stock	25.67	25.7	25.66	25.698	2213160.0
2011-03-25 12:30:00	MSFT	Stock	25.7	25.73	25.68	25.705	2186166.0
2011-03-25 13:00:00	MSFT	Stock	25.7	25.71	25.67	25.69	1412576.0
2011-03-25 13:30:00	MSFT	Stock	25.69	25.71	25.62	25.64	3244966.0
2011-03-25 14:00:00	MSFT	Stock	25.64	25.66	25.59	25.64	4710906.0
2011-03-25 14:30:00	MSFT	Stock	25.64	25.65	25.62	25.639	3192555.0
2011-03-25 15:00:00	MSFT	Stock	25.64	25.64	25.6	25.62	3960112.0
2011-03-25 15:30:00	MSFT	Stock	25.63	25.64	25.59	25.63	10078324.0

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

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