PREVIEW / stock_30min / 2012-07-17

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-07-17.parquet
  size:    1.4 MB
  rows:    73,776
  symbols: 3,490

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-07-17 04:00:00	AAPL	Stock	21.7682	21.7682	21.7682	21.7682	2800.0
2012-07-17 04:30:00	AAPL	Stock	21.8029	21.8029	21.8	21.8	5600.0
2012-07-17 05:30:00	AAPL	Stock	21.8	21.8	21.8	21.8	2800.0
2012-07-17 06:00:00	AAPL	Stock	21.7964	21.8036	21.7964	21.8036	23100.0
2012-07-17 06:30:00	AAPL	Stock	21.7857	21.7918	21.7857	21.7911	11200.0
2012-07-17 07:00:00	AAPL	Stock	21.7718	21.7825	21.7525	21.7643	290388.0
2012-07-17 07:30:00	AAPL	Stock	21.7643	21.8036	21.7643	21.8036	163996.0
2012-07-17 08:00:00	AAPL	Stock	21.7979	21.7979	21.7679	21.7714	842632.0
2012-07-17 08:30:00	AAPL	Stock	21.7704	21.8343	21.7575	21.8279	1345708.0
2012-07-17 09:00:00	AAPL	Stock	21.8268	21.83	21.8057	21.8175	1369228.0
2012-07-17 09:30:00	AAPL	Stock	21.8139	21.8393	21.6989	21.7404	46686864.0
2012-07-17 10:00:00	AAPL	Stock	21.7396	21.7396	21.5814	21.6568	41561072.0
2012-07-17 10:30:00	AAPL	Stock	21.6518	21.6531	21.5411	21.595	26970944.0
2012-07-17 11:00:00	AAPL	Stock	21.59	21.6614	21.5864	21.6313	15517880.0
2012-07-17 11:30:00	AAPL	Stock	21.6293	21.7414	21.6023	21.74	21905380.0
2012-07-17 12:00:00	AAPL	Stock	21.7336	21.765	21.7171	21.7554	14772548.0
2012-07-17 12:30:00	AAPL	Stock	21.7593	21.7789	21.7018	21.7071	14479416.0
2012-07-17 13:00:00	AAPL	Stock	21.7071	21.765	21.7	21.7375	11934692.0
2012-07-17 13:30:00	AAPL	Stock	21.7357	21.7725	21.6829	21.6889	14071708.0
2012-07-17 14:00:00	AAPL	Stock	21.6857	21.7411	21.6821	21.73	11228812.0
2012-07-17 14:30:00	AAPL	Stock	21.7291	21.7571	21.7043	21.7172	11827200.0
2012-07-17 15:00:00	AAPL	Stock	21.7132	21.7261	21.6518	21.655	16886912.0
2012-07-17 15:30:00	AAPL	Stock	21.6525	21.6914	21.6132	21.6754	34376748.0
2012-07-17 16:00:00	AAPL	Stock	21.6746	21.7054	21.6457	21.6971	4867744.0
2012-07-17 16:30:00	AAPL	Stock	21.6764	21.6975	21.6504	21.6839	370608.0
2012-07-17 17:00:00	AAPL	Stock	21.6839	21.6875	21.6764	21.6764	20132.0
2012-07-17 17:30:00	AAPL	Stock	21.6821	21.6875	21.6786	21.6868	97440.0
2012-07-17 18:00:00	AAPL	Stock	21.6843	21.6843	21.6821	21.6821	18200.0
2012-07-17 18:30:00	AAPL	Stock	21.6857	21.6857	21.6796	21.6821	25060.0
2012-07-17 19:00:00	AAPL	Stock	21.6825	21.6875	21.6821	21.6825	56868.0
2012-07-17 19:30:00	AAPL	Stock	21.6896	21.6929	21.6843	21.6929	99484.0
2012-07-17 07:30:00	MSFT	Stock	29.5	29.5	29.5	29.5	200.0
2012-07-17 08:00:00	MSFT	Stock	29.5	29.6	29.5	29.6	4595.0
2012-07-17 08:30:00	MSFT	Stock	29.6	29.61	29.5	29.59	18700.0
2012-07-17 09:00:00	MSFT	Stock	29.6	29.72	29.44	29.68	46304.0
2012-07-17 09:30:00	MSFT	Stock	29.65	29.86	29.51	29.63	2544495.0
2012-07-17 10:00:00	MSFT	Stock	29.63	29.63	29.41	29.465	2450115.0
2012-07-17 10:30:00	MSFT	Stock	29.46	29.46	29.2	29.215	4576435.0
2012-07-17 11:00:00	MSFT	Stock	29.225	29.32	29.2	29.28	2164427.0
2012-07-17 11:30:00	MSFT	Stock	29.28	29.38	29.26	29.33	2625382.0
2012-07-17 12:00:00	MSFT	Stock	29.33	29.66	29.33	29.626	2749591.0
2012-07-17 12:30:00	MSFT	Stock	29.62	29.68	29.525	29.54	1278189.0
2012-07-17 13:00:00	MSFT	Stock	29.54	29.68	29.52	29.63	1212082.0
2012-07-17 13:30:00	MSFT	Stock	29.63	29.66	29.56	29.565	1403476.0
2012-07-17 14:00:00	MSFT	Stock	29.56	29.69	29.55	29.68	1493098.0
2012-07-17 14:30:00	MSFT	Stock	29.67	29.74	29.6	29.71	2176545.0
2012-07-17 15:00:00	MSFT	Stock	29.705	29.72	29.58	29.58	2036432.0
2012-07-17 15:30:00	MSFT	Stock	29.58	29.67	29.53	29.66	4699150.0
2012-07-17 16:00:00	MSFT	Stock	29.66	29.8	29.34	29.75	1323970.0
2012-07-17 16:30:00	MSFT	Stock	29.66	29.76	29.321	29.71	124246.0

> showing 50 of 73,776 rows — these rows as CSV

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