PREVIEW / stock_30min / 2011-06-16

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-16.parquet
  size:    1.4 MB
  rows:    75,382
  symbols: 3,548

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-06-16 04:00:00	AAPL	Stock	11.6886	11.6886	11.6886	11.6886	2800.0
2011-06-16 05:30:00	AAPL	Stock	11.6518	11.6518	11.6518	11.6518	8400.0
2011-06-16 06:00:00	AAPL	Stock	11.6421	11.6421	11.6421	11.6421	2800.0
2011-06-16 06:30:00	AAPL	Stock	11.6179	11.6271	11.6146	11.6271	8400.0
2011-06-16 07:00:00	AAPL	Stock	11.6271	11.6607	11.6271	11.6429	78400.0
2011-06-16 07:30:00	AAPL	Stock	11.6364	11.6561	11.6339	11.6339	53200.0
2011-06-16 08:00:00	AAPL	Stock	11.6389	11.6429	11.6179	11.625	394464.0
2011-06-16 08:30:00	AAPL	Stock	11.6304	11.6964	11.6304	11.6964	1588916.0
2011-06-16 09:00:00	AAPL	Stock	11.7004	11.7071	11.6511	11.6804	1690332.0
2011-06-16 09:30:00	AAPL	Stock	11.6782	11.6957	11.6339	11.6911	50220968.0
2011-06-16 10:00:00	AAPL	Stock	11.69	11.7386	11.65	11.7089	47041204.0
2011-06-16 10:30:00	AAPL	Stock	11.7089	11.7357	11.6964	11.7075	21774088.0
2011-06-16 11:00:00	AAPL	Stock	11.7066	11.7075	11.67	11.6879	20868736.0
2011-06-16 11:30:00	AAPL	Stock	11.6906	11.7025	11.6604	11.6654	13665316.0
2011-06-16 12:00:00	AAPL	Stock	11.6654	11.6821	11.6607	11.6771	10646440.0
2011-06-16 12:30:00	AAPL	Stock	11.6771	11.6907	11.6729	11.6786	7480732.0
2011-06-16 13:00:00	AAPL	Stock	11.6795	11.6814	11.655	11.6586	13955676.0
2011-06-16 13:30:00	AAPL	Stock	11.6582	11.6639	11.5914	11.5939	23184756.0
2011-06-16 14:00:00	AAPL	Stock	11.5946	11.6107	11.4761	11.5121	55897072.0
2011-06-16 14:30:00	AAPL	Stock	11.5125	11.5179	11.3689	11.4329	83373024.0
2011-06-16 15:00:00	AAPL	Stock	11.4329	11.5229	11.4229	11.5204	58631776.0
2011-06-16 15:30:00	AAPL	Stock	11.52	11.6129	11.5168	11.6129	77402948.0
2011-06-16 16:00:00	AAPL	Stock	11.6107	11.6575	11.5818	11.6221	15397004.0
2011-06-16 16:30:00	AAPL	Stock	11.6225	11.6518	11.5741	11.6357	1012900.0
2011-06-16 17:00:00	AAPL	Stock	11.6357	11.6429	11.6118	11.6429	390040.0
2011-06-16 17:30:00	AAPL	Stock	11.6325	11.6375	11.6286	11.6304	137144.0
2011-06-16 18:00:00	AAPL	Stock	11.6375	11.6407	11.6129	11.6289	2704184.0
2011-06-16 18:30:00	AAPL	Stock	11.6293	11.6389	11.6293	11.6389	47488.0
2011-06-16 19:00:00	AAPL	Stock	11.6304	11.6589	11.6304	11.6571	232260.0
2011-06-16 19:30:00	AAPL	Stock	11.6539	11.6607	11.6536	11.6607	139720.0
2011-06-16 07:00:00	MSFT	Stock	23.67	23.67	23.67	23.67	400.0
2011-06-16 07:30:00	MSFT	Stock	23.66	23.66	23.66	23.66	100.0
2011-06-16 08:00:00	MSFT	Stock	23.72	23.74	23.7	23.74	9070.0
2011-06-16 08:30:00	MSFT	Stock	23.74	23.74	23.72	23.72	1600.0
2011-06-16 09:00:00	MSFT	Stock	23.74	23.77	23.74	23.77	15018.0
2011-06-16 09:30:00	MSFT	Stock	23.79	23.92	23.65	23.92	5172981.0
2011-06-16 10:00:00	MSFT	Stock	23.91	23.97	23.82	23.946	4891287.0
2011-06-16 10:30:00	MSFT	Stock	23.945	24.0	23.91	23.96	3435847.0
2011-06-16 11:00:00	MSFT	Stock	23.965	24.03	23.93	24.025	4075528.0
2011-06-16 11:30:00	MSFT	Stock	24.025	24.05	23.975	24.0	2400032.0
2011-06-16 12:00:00	MSFT	Stock	23.995	24.1	23.99	24.088	4489484.0
2011-06-16 12:30:00	MSFT	Stock	24.089	24.1	23.98	24.005	3339976.0
2011-06-16 13:00:00	MSFT	Stock	24.0	24.04	23.98	24.03	1856724.0
2011-06-16 13:30:00	MSFT	Stock	24.03	24.04	23.96	23.981	3220137.0
2011-06-16 14:00:00	MSFT	Stock	23.98	24.03	23.96	24.015	3307983.0
2011-06-16 14:30:00	MSFT	Stock	24.015	24.035	23.92	24.0	6056019.0
2011-06-16 15:00:00	MSFT	Stock	23.995	24.03	23.97	23.98	4637254.0
2011-06-16 15:30:00	MSFT	Stock	23.98	24.05	23.97	23.99	7067843.0
2011-06-16 16:00:00	MSFT	Stock	24.0	24.03	23.969	23.983	2831048.0
2011-06-16 16:30:00	MSFT	Stock	23.982	24.05	23.982	24.0	33950.0

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

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