PREVIEW / stock_1hour / 2012-06-13

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-06-13.parquet
  size:    919 KB
  rows:    43,932
  symbols: 3,491

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-13 05:00:00	AAPL	Stock	20.5775	20.5775	20.5454	20.5454	16800.0
2012-06-13 07:00:00	AAPL	Stock	20.5893	20.5893	20.5357	20.5714	91000.0
2012-06-13 08:00:00	AAPL	Stock	20.5714	20.5746	20.4821	20.5079	1670396.0
2012-06-13 09:00:00	AAPL	Stock	20.5146	20.6543	20.4736	20.5364	53139744.0
2012-06-13 10:00:00	AAPL	Stock	20.5364	20.66	20.5314	20.65	50840076.0
2012-06-13 11:00:00	AAPL	Stock	20.6489	20.6529	20.5775	20.5932	27434008.0
2012-06-13 12:00:00	AAPL	Stock	20.5893	20.6246	20.5357	20.5911	26563656.0
2012-06-13 13:00:00	AAPL	Stock	20.5902	20.6125	20.5132	20.5357	19356260.0
2012-06-13 14:00:00	AAPL	Stock	20.5296	20.5554	20.415	20.4429	32827256.0
2012-06-13 15:00:00	AAPL	Stock	20.4432	20.4582	20.3707	20.4339	59633252.0
2012-06-13 16:00:00	AAPL	Stock	20.4339	20.5369	20.4004	20.4143	19623576.0
2012-06-13 17:00:00	AAPL	Stock	20.4143	20.4286	20.4143	20.425	79492.0
2012-06-13 18:00:00	AAPL	Stock	20.4232	20.4464	20.4214	20.4264	147224.0
2012-06-13 19:00:00	AAPL	Stock	20.4239	20.4361	20.4236	20.4271	87668.0
2012-06-13 08:00:00	MSFT	Stock	29.34	29.34	29.16	29.21	13023.0
2012-06-13 09:00:00	MSFT	Stock	29.24	29.32	29.15	29.19	3004551.0
2012-06-13 10:00:00	MSFT	Stock	29.18	29.44	29.18	29.428	5204187.0
2012-06-13 11:00:00	MSFT	Stock	29.42	29.425	29.29	29.33	5555667.0
2012-06-13 12:00:00	MSFT	Stock	29.34	29.44	29.24	29.379	3041064.0
2012-06-13 13:00:00	MSFT	Stock	29.38	29.42	29.34	29.36	2539703.0
2012-06-13 14:00:00	MSFT	Stock	29.36	29.375	29.22	29.225	3752107.0
2012-06-13 15:00:00	MSFT	Stock	29.23	29.24	29.05	29.12	7829051.0
2012-06-13 16:00:00	MSFT	Stock	29.13	29.272	29.06	29.076	1737539.0
2012-06-13 17:00:00	MSFT	Stock	29.13	29.13	29.13	29.13	1000.0
2012-06-13 18:00:00	MSFT	Stock	29.13	29.18	29.13	29.18	1530.0
2012-06-13 08:00:00	NVDA	Stock	0.3118	0.312	0.3118	0.3118	187720.0
2012-06-13 09:00:00	NVDA	Stock	0.312	0.3133	0.3088	0.3113	68499200.0
2012-06-13 10:00:00	NVDA	Stock	0.3113	0.3128	0.3103	0.311	110362960.0
2012-06-13 11:00:00	NVDA	Stock	0.3108	0.3118	0.3095	0.311	46059760.0
2012-06-13 12:00:00	NVDA	Stock	0.311	0.3115	0.3093	0.3112	28856640.0
2012-06-13 13:00:00	NVDA	Stock	0.3113	0.3115	0.3088	0.3093	37114560.0
2012-06-13 14:00:00	NVDA	Stock	0.309	0.3095	0.3058	0.3062	51287280.0
2012-06-13 15:00:00	NVDA	Stock	0.3065	0.307	0.303	0.3042	111885600.0
2012-06-13 16:00:00	NVDA	Stock	0.3045	0.305	0.3037	0.3045	24927480.0
2012-06-13 18:00:00	NVDA	Stock	0.305	0.3062	0.305	0.3062	46400.0
2012-06-13 19:00:00	NVDA	Stock	0.3062	0.3062	0.3055	0.3055	84000.0
2012-06-13 05:00:00	AMZN	Stock	10.7925	10.7925	10.792	10.792	8000.0
2012-06-13 08:00:00	AMZN	Stock	10.7875	10.7895	10.753	10.789	76000.0
2012-06-13 09:00:00	AMZN	Stock	10.79	10.8565	10.757	10.806	4994120.0
2012-06-13 10:00:00	AMZN	Stock	10.81	10.869	10.7785	10.869	8297960.0
2012-06-13 11:00:00	AMZN	Stock	10.8685	10.8685	10.814	10.819	5834380.0
2012-06-13 12:00:00	AMZN	Stock	10.816	10.835	10.778	10.824	3902860.0
2012-06-13 13:00:00	AMZN	Stock	10.8285	10.845	10.7763	10.787	3556540.0
2012-06-13 14:00:00	AMZN	Stock	10.7862	10.8135	10.758	10.764	4221460.0
2012-06-13 15:00:00	AMZN	Stock	10.7595	10.772	10.676	10.725	13047060.0
2012-06-13 16:00:00	AMZN	Stock	10.7365	10.8312	10.7136	10.7365	2102920.0
2012-06-13 17:00:00	AMZN	Stock	10.821	10.821	10.821	10.821	2000.0
2012-06-13 19:00:00	AMZN	Stock	10.7575	10.7575	10.745	10.745	4500.0
2012-06-13 05:00:00	META	Stock	27.66	27.66	27.66	27.66	1963.0
2012-06-13 07:00:00	META	Stock	27.49	27.5	27.49	27.5	863.0

> showing 50 of 43,932 rows — these rows as CSV

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