PREVIEW / stock_1hour / 2012-03-08

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-03-08.parquet
  size:    963 KB
  rows:    46,149
  symbols: 3,509

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-03-08 04:00:00	AAPL	Stock	19.0064	19.075	19.0064	19.0696	101864.0
2012-03-08 05:00:00	AAPL	Stock	19.0507	19.0607	19.0357	19.0357	120400.0
2012-03-08 06:00:00	AAPL	Stock	19.0464	19.0589	19.0143	19.0589	181860.0
2012-03-08 07:00:00	AAPL	Stock	19.0639	19.0961	19.0393	19.0618	1266860.0
2012-03-08 08:00:00	AAPL	Stock	19.0614	19.1086	19.0093	19.0229	5194700.0
2012-03-08 09:00:00	AAPL	Stock	19.0296	19.1389	19.0268	19.0647	70455700.0
2012-03-08 10:00:00	AAPL	Stock	19.0696	19.1129	19.0043	19.1057	75430656.0
2012-03-08 11:00:00	AAPL	Stock	19.1054	19.1879	19.0814	19.1806	52570840.0
2012-03-08 12:00:00	AAPL	Stock	19.1809	19.2804	19.1575	19.27	67599196.0
2012-03-08 13:00:00	AAPL	Stock	19.27	19.3457	19.2504	19.3344	56960400.0
2012-03-08 14:00:00	AAPL	Stock	19.3343	19.3846	19.25	19.3349	83876016.0
2012-03-08 15:00:00	AAPL	Stock	19.3347	19.3925	19.3161	19.3482	83968864.0
2012-03-08 16:00:00	AAPL	Stock	19.3571	19.3675	19.1011	19.35	9036748.0
2012-03-08 17:00:00	AAPL	Stock	19.3471	19.3571	19.3396	19.3568	635096.0
2012-03-08 18:00:00	AAPL	Stock	19.355	19.3611	19.3468	19.3607	422828.0
2012-03-08 19:00:00	AAPL	Stock	19.3618	19.3707	19.35	19.3532	1120252.0
2012-03-08 05:00:00	MSFT	Stock	32.05	32.05	32.05	32.05	100.0
2012-03-08 07:00:00	MSFT	Stock	32.15	32.15	32.13	32.13	1375.0
2012-03-08 08:00:00	MSFT	Stock	32.15	32.15	31.91	31.99	45784.0
2012-03-08 09:00:00	MSFT	Stock	31.99	32.15	31.9	32.13	5012299.0
2012-03-08 10:00:00	MSFT	Stock	32.13	32.21	31.92	32.068	8226187.0
2012-03-08 11:00:00	MSFT	Stock	32.07	32.14	32.025	32.09	5702905.0
2012-03-08 12:00:00	MSFT	Stock	32.09	32.15	32.087	32.115	3421378.0
2012-03-08 13:00:00	MSFT	Stock	32.115	32.17	32.09	32.1	2279510.0
2012-03-08 14:00:00	MSFT	Stock	32.1	32.13	32.03	32.13	3384146.0
2012-03-08 15:00:00	MSFT	Stock	32.125	32.17	32.01	32.02	6181646.0
2012-03-08 16:00:00	MSFT	Stock	32.01	32.066	31.99	32.0	2029170.0
2012-03-08 17:00:00	MSFT	Stock	32.01	32.01	32.01	32.01	62518.0
2012-03-08 18:00:00	MSFT	Stock	32.03	32.03	32.01	32.03	3189.0
2012-03-08 19:00:00	MSFT	Stock	32.04	32.04	32.0	32.0	2466.0
2012-03-08 08:00:00	NVDA	Stock	0.3713	0.372	0.3705	0.372	186520.0
2012-03-08 09:00:00	NVDA	Stock	0.3715	0.3745	0.3703	0.3725	33609480.0
2012-03-08 10:00:00	NVDA	Stock	0.3725	0.373	0.3693	0.3708	57419320.0
2012-03-08 11:00:00	NVDA	Stock	0.3709	0.3753	0.3708	0.3713	54305040.0
2012-03-08 12:00:00	NVDA	Stock	0.3711	0.3729	0.371	0.3715	45704360.0
2012-03-08 13:00:00	NVDA	Stock	0.3713	0.3715	0.3695	0.3698	29288400.0
2012-03-08 14:00:00	NVDA	Stock	0.3698	0.3715	0.3695	0.3713	53936720.0
2012-03-08 15:00:00	NVDA	Stock	0.3713	0.3725	0.3708	0.3715	105204800.0
2012-03-08 16:00:00	NVDA	Stock	0.3714	0.3717	0.3695	0.3695	12876080.0
2012-03-08 17:00:00	NVDA	Stock	0.3715	0.3715	0.3715	0.3715	204360.0
2012-03-08 19:00:00	NVDA	Stock	0.3715	0.3715	0.3715	0.3715	8000.0
2012-03-08 05:00:00	AMZN	Stock	9.225	9.2445	9.22	9.2445	26000.0
2012-03-08 06:00:00	AMZN	Stock	9.2475	9.2475	9.2475	9.2475	3000.0
2012-03-08 07:00:00	AMZN	Stock	9.276	9.29	9.276	9.29	14000.0
2012-03-08 08:00:00	AMZN	Stock	9.2545	9.269	9.1565	9.2025	308080.0
2012-03-08 09:00:00	AMZN	Stock	9.2025	9.273	9.198	9.202	9876340.0
2012-03-08 10:00:00	AMZN	Stock	9.208	9.2945	9.19	9.2825	14785020.0
2012-03-08 11:00:00	AMZN	Stock	9.2825	9.318	9.2655	9.314	13029560.0
2012-03-08 12:00:00	AMZN	Stock	9.3115	9.342	9.2985	9.3315	7418120.0
2012-03-08 13:00:00	AMZN	Stock	9.3295	9.3625	9.313	9.3175	8329560.0

> showing 50 of 46,149 rows — these rows as CSV

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