PREVIEW / stock_1hour / 2012-07-25

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-07-25.parquet
  size:    915 KB
  rows:    43,581
  symbols: 3,477

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-25 04:00:00	AAPL	Stock	20.3214	20.4429	20.2796	20.4429	503300.0
2012-07-25 05:00:00	AAPL	Stock	20.4607	20.4786	20.4304	20.4307	168952.0
2012-07-25 06:00:00	AAPL	Stock	20.4357	20.4643	20.4196	20.4357	475020.0
2012-07-25 07:00:00	AAPL	Stock	20.4289	20.5714	20.3429	20.4821	5908588.0
2012-07-25 08:00:00	AAPL	Stock	20.5404	20.5464	20.4329	20.5011	12462100.0
2012-07-25 09:00:00	AAPL	Stock	20.5021	20.7429	20.3754	20.5	288738604.0
2012-07-25 10:00:00	AAPL	Stock	20.5018	20.5429	20.3596	20.372	153714344.0
2012-07-25 11:00:00	AAPL	Stock	20.3711	20.5	20.3571	20.4721	87143728.0
2012-07-25 12:00:00	AAPL	Stock	20.4686	20.5714	20.4407	20.538	54604004.0
2012-07-25 13:00:00	AAPL	Stock	20.5382	20.7139	20.5264	20.6868	81479244.0
2012-07-25 14:00:00	AAPL	Stock	20.6896	20.7143	20.6139	20.6254	61883360.0
2012-07-25 15:00:00	AAPL	Stock	20.6214	20.6646	20.5129	20.5346	98615972.0
2012-07-25 16:00:00	AAPL	Stock	20.5346	20.595	20.5232	20.5464	7467376.0
2012-07-25 17:00:00	AAPL	Stock	20.5375	20.5457	20.5311	20.5321	133252.0
2012-07-25 18:00:00	AAPL	Stock	20.5357	20.5629	20.5268	20.5621	173068.0
2012-07-25 19:00:00	AAPL	Stock	20.5639	20.5643	20.5407	20.5464	197624.0
2012-07-25 07:00:00	MSFT	Stock	29.13	29.16	29.13	29.16	242.0
2012-07-25 08:00:00	MSFT	Stock	29.07	29.26	29.07	29.26	19770.0
2012-07-25 09:00:00	MSFT	Stock	29.26	29.33	29.07	29.28	5859373.0
2012-07-25 10:00:00	MSFT	Stock	29.28	29.3	28.98	29.02	7016692.0
2012-07-25 11:00:00	MSFT	Stock	29.02	29.22	29.01	29.085	4804969.0
2012-07-25 12:00:00	MSFT	Stock	29.085	29.12	29.01	29.015	4088390.0
2012-07-25 13:00:00	MSFT	Stock	29.02	29.12	29.01	29.08	4343526.0
2012-07-25 14:00:00	MSFT	Stock	29.09	29.09	29.0	29.04	5418011.0
2012-07-25 15:00:00	MSFT	Stock	29.03	29.04	28.78	28.84	11301036.0
2012-07-25 16:00:00	MSFT	Stock	28.83	29.052	28.812	28.84	1986527.0
2012-07-25 17:00:00	MSFT	Stock	28.86	28.88	28.86	28.88	3746.0
2012-07-25 18:00:00	MSFT	Stock	28.86	28.88	28.86	28.88	3300.0
2012-07-25 19:00:00	MSFT	Stock	28.85	28.85	28.85	28.85	1155.0
2012-07-25 07:00:00	NVDA	Stock	0.3208	0.3208	0.3208	0.3208	54640.0
2012-07-25 08:00:00	NVDA	Stock	0.3155	0.3208	0.315	0.3208	241760.0
2012-07-25 09:00:00	NVDA	Stock	0.3203	0.326	0.3185	0.326	40468080.0
2012-07-25 10:00:00	NVDA	Stock	0.3258	0.3278	0.3223	0.3235	63421160.0
2012-07-25 11:00:00	NVDA	Stock	0.3234	0.3275	0.323	0.3268	40290960.0
2012-07-25 12:00:00	NVDA	Stock	0.3268	0.3275	0.3253	0.3265	26349200.0
2012-07-25 13:00:00	NVDA	Stock	0.3266	0.3285	0.3265	0.3284	33068680.0
2012-07-25 14:00:00	NVDA	Stock	0.3284	0.3305	0.3278	0.329	56590960.0
2012-07-25 15:00:00	NVDA	Stock	0.329	0.3298	0.3258	0.3273	92514560.0
2012-07-25 16:00:00	NVDA	Stock	0.3273	0.3273	0.3263	0.3273	57271560.0
2012-07-25 17:00:00	NVDA	Stock	0.3268	0.3268	0.3268	0.3268	12000.0
2012-07-25 19:00:00	NVDA	Stock	0.3288	0.3288	0.3288	0.3288	40000.0
2012-07-25 06:00:00	AMZN	Stock	11.1	11.1	11.1	11.1	8400.0
2012-07-25 07:00:00	AMZN	Stock	11.1005	11.125	11.095	11.125	55800.0
2012-07-25 08:00:00	AMZN	Stock	11.125	11.125	11.0965	11.124	138580.0
2012-07-25 09:00:00	AMZN	Stock	11.124	11.125	11.005	11.0395	9409060.0
2012-07-25 10:00:00	AMZN	Stock	11.0335	11.0865	10.8575	10.8785	17799560.0
2012-07-25 11:00:00	AMZN	Stock	10.8785	10.949	10.851	10.937	7141200.0
2012-07-25 12:00:00	AMZN	Stock	10.9385	10.959	10.907	10.9125	3424260.0
2012-07-25 13:00:00	AMZN	Stock	10.9165	10.988	10.9085	10.952	6179360.0
2012-07-25 14:00:00	AMZN	Stock	10.951	10.97	10.9205	10.9255	5473280.0

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

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