PREVIEW / stock_1hour / 2013-12-04

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-12-04.parquet
  size:    1.0 MB
  rows:    49,319
  symbols: 3,535

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
2013-12-04 04:00:00	AAPL	Stock	20.2771	20.2936	20.2771	20.2936	13524.0
2013-12-04 05:00:00	AAPL	Stock	20.2986	20.2986	20.2986	20.2986	11088.0
2013-12-04 06:00:00	AAPL	Stock	20.3125	20.3125	20.2707	20.2757	122864.0
2013-12-04 07:00:00	AAPL	Stock	20.2757	20.3386	20.2646	20.275	1291584.0
2013-12-04 08:00:00	AAPL	Stock	20.275	20.3382	20.1679	20.2371	3341632.0
2013-12-04 09:00:00	AAPL	Stock	20.2371	20.2371	20.0293	20.0725	63818552.0
2013-12-04 10:00:00	AAPL	Stock	20.0725	20.3282	20.05	20.3022	83582996.0
2013-12-04 11:00:00	AAPL	Stock	20.3014	20.3029	20.1514	20.1557	46509456.0
2013-12-04 12:00:00	AAPL	Stock	20.1557	20.1732	20.0814	20.1657	28519344.0
2013-12-04 13:00:00	AAPL	Stock	20.1661	20.1893	20.0446	20.08	27742344.0
2013-12-04 14:00:00	AAPL	Stock	20.08	20.1736	20.0751	20.1507	24877552.0
2013-12-04 15:00:00	AAPL	Stock	20.1486	20.2418	20.0968	20.1736	58618560.0
2013-12-04 16:00:00	AAPL	Stock	20.1786	20.2281	20.08	20.1786	24314808.0
2013-12-04 17:00:00	AAPL	Stock	20.1786	20.1864	20.1718	20.1786	358484.0
2013-12-04 18:00:00	AAPL	Stock	20.1786	20.1832	20.1664	20.1743	109396.0
2013-12-04 19:00:00	AAPL	Stock	20.1696	20.1786	20.1464	20.1575	308224.0
2013-12-04 05:00:00	MSFT	Stock	38.25	38.27	38.25	38.27	385.0
2013-12-04 07:00:00	MSFT	Stock	38.27	38.27	38.26	38.26	1482.0
2013-12-04 08:00:00	MSFT	Stock	38.24	38.24	38.16	38.22	13986.0
2013-12-04 09:00:00	MSFT	Stock	38.21	38.53	38.12	38.53	5834369.0
2013-12-04 10:00:00	MSFT	Stock	38.52	38.92	38.52	38.86	12264883.0
2013-12-04 11:00:00	MSFT	Stock	38.86	38.92	38.72	38.81	5130783.0
2013-12-04 12:00:00	MSFT	Stock	38.8	38.84	38.73	38.755	3793630.0
2013-12-04 13:00:00	MSFT	Stock	38.755	38.78	38.48	38.5	5404866.0
2013-12-04 14:00:00	MSFT	Stock	38.5	38.75	38.5	38.716	3873728.0
2013-12-04 15:00:00	MSFT	Stock	38.71	38.98	38.67	38.97	9284638.0
2013-12-04 16:00:00	MSFT	Stock	38.965	39.0	38.609	39.0	5948268.0
2013-12-04 17:00:00	MSFT	Stock	39.0	39.0	38.94	38.98	14146.0
2013-12-04 19:00:00	MSFT	Stock	39.0	39.0	38.92	38.99	59917.0
2013-12-04 09:00:00	NVDA	Stock	0.3935	0.396	0.3925	0.3933	29757400.0
2013-12-04 10:00:00	NVDA	Stock	0.3931	0.3938	0.3915	0.3926	41578000.0
2013-12-04 11:00:00	NVDA	Stock	0.3925	0.3948	0.3919	0.3935	34764520.0
2013-12-04 12:00:00	NVDA	Stock	0.3936	0.3942	0.3915	0.3928	36855960.0
2013-12-04 13:00:00	NVDA	Stock	0.3928	0.3942	0.3914	0.3926	25461960.0
2013-12-04 14:00:00	NVDA	Stock	0.3928	0.3968	0.3926	0.3956	57030360.0
2013-12-04 15:00:00	NVDA	Stock	0.3958	0.3998	0.3955	0.399	180005560.0
2013-12-04 16:00:00	NVDA	Stock	0.399	0.3993	0.3978	0.3978	5104120.0
2013-12-04 04:00:00	AMZN	Stock	19.2315	19.2625	19.2315	19.2625	4000.0
2013-12-04 05:00:00	AMZN	Stock	19.275	19.275	19.275	19.275	2000.0
2013-12-04 07:00:00	AMZN	Stock	19.2355	19.2895	19.2025	19.2325	50640.0
2013-12-04 08:00:00	AMZN	Stock	19.2285	19.294	19.1695	19.2745	203140.0
2013-12-04 09:00:00	AMZN	Stock	19.254	19.397	19.1475	19.3268	11299880.0
2013-12-04 10:00:00	AMZN	Stock	19.3295	19.4845	19.3295	19.3705	11535760.0
2013-12-04 11:00:00	AMZN	Stock	19.3715	19.375	19.251	19.3035	4905780.0
2013-12-04 12:00:00	AMZN	Stock	19.308	19.3105	19.209	19.245	3102160.0
2013-12-04 13:00:00	AMZN	Stock	19.2495	19.2885	19.0746	19.144	5342520.0
2013-12-04 14:00:00	AMZN	Stock	19.1484	19.2645	19.142	19.2555	3068880.0
2013-12-04 15:00:00	AMZN	Stock	19.246	19.345	19.2015	19.294	4749080.0
2013-12-04 16:00:00	AMZN	Stock	19.298	19.3505	19.2718	19.2718	261760.0
2013-12-04 17:00:00	AMZN	Stock	19.3035	19.3205	19.303	19.3205	18320.0

> showing 50 of 49,319 rows — these rows as CSV

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