PREVIEW / stock_30min / 2012-12-24

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-12-24.parquet
  size:    892 KB
  rows:    42,994
  symbols: 3,456

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-12-24 04:00:00	AAPL	Stock	18.5393	18.5818	18.5393	18.5818	58800.0
2012-12-24 05:00:00	AAPL	Stock	18.6064	18.6064	18.6064	18.6064	2800.0
2012-12-24 05:30:00	AAPL	Stock	18.6064	18.6064	18.6064	18.6064	78260.0
2012-12-24 06:00:00	AAPL	Stock	18.625	18.625	18.625	18.625	2800.0
2012-12-24 07:00:00	AAPL	Stock	18.625	18.6554	18.5714	18.6161	172032.0
2012-12-24 07:30:00	AAPL	Stock	18.6168	18.6429	18.5789	18.6071	174412.0
2012-12-24 08:00:00	AAPL	Stock	18.6225	18.7579	18.5475	18.7393	1373120.0
2012-12-24 08:30:00	AAPL	Stock	18.7507	18.7714	18.6882	18.6996	1130584.0
2012-12-24 09:00:00	AAPL	Stock	18.6964	18.7025	18.5768	18.5768	1956584.0
2012-12-24 09:30:00	AAPL	Stock	18.5839	18.7232	18.5539	18.6746	47109524.0
2012-12-24 10:00:00	AAPL	Stock	18.6782	18.6946	18.6268	18.6389	22024352.0
2012-12-24 10:30:00	AAPL	Stock	18.6371	18.6714	18.5818	18.591	18635736.0
2012-12-24 11:00:00	AAPL	Stock	18.5961	18.6114	18.5254	18.5839	21936292.0
2012-12-24 11:30:00	AAPL	Stock	18.5806	18.6071	18.5639	18.5815	15327312.0
2012-12-24 12:00:00	AAPL	Stock	18.5855	18.6261	18.57	18.5814	16667392.0
2012-12-24 12:30:00	AAPL	Stock	18.5832	18.5893	18.5425	18.5782	22466612.0
2012-12-24 13:00:00	AAPL	Stock	18.57	18.6149	18.5546	18.5625	4285400.0
2012-12-24 13:30:00	AAPL	Stock	18.5643	18.5711	18.5585	18.5585	93940.0
2012-12-24 14:00:00	AAPL	Stock	18.5707	18.5875	18.5625	18.57	69412.0
2012-12-24 14:30:00	AAPL	Stock	18.5625	18.5714	18.5625	18.5714	66892.0
2012-12-24 15:00:00	AAPL	Stock	18.5714	18.5739	18.5664	18.5682	72100.0
2012-12-24 15:30:00	AAPL	Stock	18.5732	18.575	18.5629	18.5714	35448.0
2012-12-24 16:00:00	AAPL	Stock	18.5732	18.5732	18.5732	18.5732	2800.0
2012-12-24 16:30:00	AAPL	Stock	18.5607	18.5679	18.55	18.55	44548.0
2012-12-24 06:30:00	MSFT	Stock	27.35	27.35	27.2	27.2	600.0
2012-12-24 07:00:00	MSFT	Stock	27.16	27.2	27.16	27.2	1100.0
2012-12-24 07:30:00	MSFT	Stock	27.21	27.26	27.2	27.25	7825.0
2012-12-24 08:00:00	MSFT	Stock	27.27	27.3	27.21	27.3	16345.0
2012-12-24 08:30:00	MSFT	Stock	27.29	27.3	27.17	27.19	19083.0
2012-12-24 09:00:00	MSFT	Stock	27.19	27.23	27.19	27.21	36586.0
2012-12-24 09:30:00	MSFT	Stock	27.2	27.25	27.07	27.07	4365236.0
2012-12-24 10:00:00	MSFT	Stock	27.07	27.14	27.02	27.085	2370674.0
2012-12-24 10:30:00	MSFT	Stock	27.08	27.14	27.01	27.06	3162349.0
2012-12-24 11:00:00	MSFT	Stock	27.06	27.1	27.02	27.07	1841063.0
2012-12-24 11:30:00	MSFT	Stock	27.07	27.08	27.03	27.03	1506150.0
2012-12-24 12:00:00	MSFT	Stock	27.03	27.05	27.0	27.01	1409603.0
2012-12-24 12:30:00	MSFT	Stock	27.01	27.07	27.0	27.07	3247910.0
2012-12-24 13:00:00	MSFT	Stock	27.06	27.09	27.04	27.08	1723977.0
2012-12-24 13:30:00	MSFT	Stock	27.02	27.03	27.02	27.03	500.0
2012-12-24 14:00:00	MSFT	Stock	27.03	27.03	27.02	27.02	1240.0
2012-12-24 14:30:00	MSFT	Stock	27.08	27.08	27.04	27.04	3435.0
2012-12-24 15:00:00	MSFT	Stock	27.02	27.02	27.0	27.0	1344.0
2012-12-24 16:00:00	MSFT	Stock	27.05	27.05	27.0	27.05	4007.0
2012-12-24 16:30:00	MSFT	Stock	27.05	27.05	27.05	27.05	1000.0
2012-12-24 07:00:00	NVDA	Stock	0.3088	0.3088	0.3088	0.3088	4000.0
2012-12-24 09:30:00	NVDA	Stock	0.3085	0.3093	0.306	0.3074	23238320.0
2012-12-24 10:00:00	NVDA	Stock	0.3073	0.3095	0.307	0.3073	11175120.0
2012-12-24 10:30:00	NVDA	Stock	0.3075	0.3083	0.3061	0.3066	18081600.0
2012-12-24 11:00:00	NVDA	Stock	0.3068	0.307	0.3062	0.3069	9409840.0
2012-12-24 11:30:00	NVDA	Stock	0.3069	0.3073	0.3062	0.3062	15282360.0

> showing 50 of 42,994 rows — these rows as CSV

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