PREVIEW / stock_1hour / 2013-06-19

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-06-19.parquet
  size:    977 KB
  rows:    45,782
  symbols: 3,518

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-06-19 06:00:00	AAPL	Stock	15.4325	15.4325	15.4279	15.4279	5600.0
2013-06-19 07:00:00	AAPL	Stock	15.4221	15.4221	15.3929	15.4029	170156.0
2013-06-19 08:00:00	AAPL	Stock	15.4036	15.4154	15.3929	15.4071	249368.0
2013-06-19 09:00:00	AAPL	Stock	15.4089	15.4164	15.3146	15.3241	33354328.0
2013-06-19 10:00:00	AAPL	Stock	15.3254	15.3371	15.2689	15.2916	44111256.0
2013-06-19 11:00:00	AAPL	Stock	15.2943	15.3118	15.2321	15.2511	28016072.0
2013-06-19 12:00:00	AAPL	Stock	15.2507	15.2993	15.2471	15.2671	16475032.0
2013-06-19 13:00:00	AAPL	Stock	15.2679	15.2786	15.2411	15.2496	15957564.0
2013-06-19 14:00:00	AAPL	Stock	15.2529	15.2945	15.1661	15.1789	59269448.0
2013-06-19 15:00:00	AAPL	Stock	15.1782	15.2243	15.1071	15.1073	68068112.0
2013-06-19 16:00:00	AAPL	Stock	15.1073	15.3177	15.1068	15.1304	25047764.0
2013-06-19 17:00:00	AAPL	Stock	15.1254	15.2406	15.1071	15.1196	351960.0
2013-06-19 18:00:00	AAPL	Stock	15.1214	15.1214	15.1075	15.1139	108892.0
2013-06-19 19:00:00	AAPL	Stock	15.11	15.1211	15.11	15.1168	62020.0
2013-06-19 06:00:00	MSFT	Stock	35.02	35.02	35.02	35.02	100.0
2013-06-19 08:00:00	MSFT	Stock	34.94	34.96	34.86	34.88	2620.0
2013-06-19 09:00:00	MSFT	Stock	34.92	35.02	34.77	34.86	2519429.0
2013-06-19 10:00:00	MSFT	Stock	34.855	35.09	34.83	34.93	3307689.0
2013-06-19 11:00:00	MSFT	Stock	34.94	35.01	34.88	34.96	3069531.0
2013-06-19 12:00:00	MSFT	Stock	34.96	35.03	34.96	34.995	1855532.0
2013-06-19 13:00:00	MSFT	Stock	34.993	35.0	34.95	34.98	1742061.0
2013-06-19 14:00:00	MSFT	Stock	34.98	35.01	34.61	34.7	7384968.0
2013-06-19 15:00:00	MSFT	Stock	34.7	34.9	34.6	34.6	7683920.0
2013-06-19 16:00:00	MSFT	Stock	34.59	35.034	34.41	34.59	2740479.0
2013-06-19 17:00:00	MSFT	Stock	34.6	34.848	34.51	34.59	65300.0
2013-06-19 18:00:00	MSFT	Stock	34.54	34.62	34.54	34.62	2000.0
2013-06-19 19:00:00	MSFT	Stock	34.62	34.62	34.62	34.62	2200.0
2013-06-19 08:00:00	NVDA	Stock	0.361	0.3612	0.361	0.3612	84000.0
2013-06-19 09:00:00	NVDA	Stock	0.362	0.3698	0.362	0.3695	125619960.0
2013-06-19 10:00:00	NVDA	Stock	0.3695	0.3788	0.3695	0.3785	176394920.0
2013-06-19 11:00:00	NVDA	Stock	0.3785	0.387	0.3778	0.38	278837360.0
2013-06-19 12:00:00	NVDA	Stock	0.3798	0.3808	0.375	0.3758	133676560.0
2013-06-19 13:00:00	NVDA	Stock	0.3758	0.3766	0.3728	0.3742	85170200.0
2013-06-19 14:00:00	NVDA	Stock	0.3743	0.377	0.3695	0.3705	149458320.0
2013-06-19 15:00:00	NVDA	Stock	0.3705	0.3758	0.3692	0.371	183651520.0
2013-06-19 16:00:00	NVDA	Stock	0.3713	0.3757	0.36	0.373	9119760.0
2013-06-19 17:00:00	NVDA	Stock	0.3738	0.375	0.3738	0.375	36040.0
2013-06-19 18:00:00	NVDA	Stock	0.375	0.375	0.375	0.375	35960.0
2013-06-19 19:00:00	NVDA	Stock	0.375	0.375	0.3733	0.375	109360.0
2013-06-19 05:00:00	AMZN	Stock	14.0655	14.09	14.0655	14.09	8000.0
2013-06-19 07:00:00	AMZN	Stock	14.0815	14.0815	14.0815	14.0815	2000.0
2013-06-19 08:00:00	AMZN	Stock	14.077	14.096	14.05	14.066	102300.0
2013-06-19 09:00:00	AMZN	Stock	14.067	14.1575	14.05	14.148	7459260.0
2013-06-19 10:00:00	AMZN	Stock	14.148	14.167	14.1062	14.138	12855800.0
2013-06-19 11:00:00	AMZN	Stock	14.14	14.1605	14.0645	14.0745	4029920.0
2013-06-19 12:00:00	AMZN	Stock	14.0704	14.0895	14.0345	14.0508	3675920.0
2013-06-19 13:00:00	AMZN	Stock	14.0455	14.0725	13.9925	14.013	3911660.0
2013-06-19 14:00:00	AMZN	Stock	14.016	14.1165	13.933	13.947	10686720.0
2013-06-19 15:00:00	AMZN	Stock	13.9345	14.0175	13.8935	13.9095	11957780.0
2013-06-19 16:00:00	AMZN	Stock	13.9095	14.0655	13.908	13.93	1796000.0

> showing 50 of 45,782 rows — these rows as CSV

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