PREVIEW / stock_1hour / 2012-09-25

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-09-25.parquet
  size:    947 KB
  rows:    44,545
  symbols: 3,501

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-09-25 04:00:00	AAPL	Stock	24.5625	24.5893	24.5464	24.5679	485072.0
2012-09-25 05:00:00	AAPL	Stock	24.515	24.5161	24.515	24.5161	16800.0
2012-09-25 06:00:00	AAPL	Stock	24.5357	24.5714	24.5357	24.5714	85400.0
2012-09-25 07:00:00	AAPL	Stock	24.5714	24.5893	24.5143	24.5321	561316.0
2012-09-25 08:00:00	AAPL	Stock	24.5357	24.6568	24.5093	24.6425	2985108.0
2012-09-25 09:00:00	AAPL	Stock	24.6418	24.7421	24.5	24.6129	72336348.0
2012-09-25 10:00:00	AAPL	Stock	24.6171	24.6696	24.5468	24.6275	60500944.0
2012-09-25 11:00:00	AAPL	Stock	24.6254	24.7125	24.625	24.6446	36906128.0
2012-09-25 12:00:00	AAPL	Stock	24.6439	24.6518	24.5225	24.5714	39656876.0
2012-09-25 13:00:00	AAPL	Stock	24.5714	24.5757	24.4829	24.5443	37832480.0
2012-09-25 14:00:00	AAPL	Stock	24.5468	24.5511	24.2507	24.2604	69470184.0
2012-09-25 15:00:00	AAPL	Stock	24.2568	24.2946	24.0357	24.0607	166296004.0
2012-09-25 16:00:00	AAPL	Stock	24.0607	24.6416	24.0219	24.095	15006376.0
2012-09-25 17:00:00	AAPL	Stock	24.1025	24.5108	24.055	24.0893	4401880.0
2012-09-25 18:00:00	AAPL	Stock	24.0896	24.1071	24.0696	24.0954	503468.0
2012-09-25 19:00:00	AAPL	Stock	24.0914	24.1107	24.0821	24.1107	350028.0
2012-09-25 08:00:00	MSFT	Stock	30.88	30.9	30.82	30.9	10599.0
2012-09-25 09:00:00	MSFT	Stock	30.92	31.0	30.69	30.74	3524824.0
2012-09-25 10:00:00	MSFT	Stock	30.735	30.86	30.71	30.765	6245842.0
2012-09-25 11:00:00	MSFT	Stock	30.765	30.92	30.76	30.895	3698607.0
2012-09-25 12:00:00	MSFT	Stock	30.894	30.9	30.69	30.712	4931915.0
2012-09-25 13:00:00	MSFT	Stock	30.71	30.74	30.66	30.728	2511034.0
2012-09-25 14:00:00	MSFT	Stock	30.72	30.76	30.59	30.607	4285588.0
2012-09-25 15:00:00	MSFT	Stock	30.608	30.72	30.36	30.39	17799462.0
2012-09-25 16:00:00	MSFT	Stock	30.395	30.885	30.2	30.37	5572893.0
2012-09-25 17:00:00	MSFT	Stock	30.33	30.599	30.28	30.3	24757.0
2012-09-25 18:00:00	MSFT	Stock	30.3	30.43	30.3	30.43	16546.0
2012-09-25 19:00:00	MSFT	Stock	30.45	30.47	30.41	30.41	8416.0
2012-09-25 08:00:00	NVDA	Stock	0.3438	0.3438	0.3428	0.3438	92000.0
2012-09-25 09:00:00	NVDA	Stock	0.3442	0.3475	0.339	0.3402	64344400.0
2012-09-25 10:00:00	NVDA	Stock	0.3402	0.3455	0.3402	0.3455	90536640.0
2012-09-25 11:00:00	NVDA	Stock	0.3453	0.3458	0.3439	0.3444	69900360.0
2012-09-25 12:00:00	NVDA	Stock	0.3442	0.3445	0.3402	0.3425	40108160.0
2012-09-25 13:00:00	NVDA	Stock	0.3422	0.3428	0.3405	0.3409	24556080.0
2012-09-25 14:00:00	NVDA	Stock	0.341	0.341	0.339	0.339	41352520.0
2012-09-25 15:00:00	NVDA	Stock	0.339	0.3398	0.3348	0.3351	122228800.0
2012-09-25 16:00:00	NVDA	Stock	0.3358	0.3414	0.335	0.3351	7473880.0
2012-09-25 17:00:00	NVDA	Stock	0.3412	0.3412	0.3365	0.3373	403680.0
2012-09-25 18:00:00	NVDA	Stock	0.3373	0.3373	0.3373	0.3373	4000.0
2012-09-25 06:00:00	AMZN	Stock	12.75	12.75	12.75	12.75	14000.0
2012-09-25 07:00:00	AMZN	Stock	12.75	12.75	12.75	12.75	7000.0
2012-09-25 08:00:00	AMZN	Stock	12.76	12.7815	12.76	12.7815	144400.0
2012-09-25 09:00:00	AMZN	Stock	12.79	12.8435	12.696	12.8045	10609160.0
2012-09-25 10:00:00	AMZN	Stock	12.807	12.9195	12.7885	12.8875	10944060.0
2012-09-25 11:00:00	AMZN	Stock	12.886	12.9475	12.8765	12.8785	8002180.0
2012-09-25 12:00:00	AMZN	Stock	12.8795	12.9	12.8265	12.83	5299660.0
2012-09-25 13:00:00	AMZN	Stock	12.829	12.829	12.7615	12.767	8476600.0
2012-09-25 14:00:00	AMZN	Stock	12.765	12.7695	12.6275	12.6305	8297160.0
2012-09-25 15:00:00	AMZN	Stock	12.6337	12.657	12.5515	12.627	20543800.0
2012-09-25 16:00:00	AMZN	Stock	12.622	12.7642	12.6205	12.624	5537520.0

> showing 50 of 44,545 rows — these rows as CSV

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