PREVIEW / stock_1hour / 2013-12-20

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-12-20.parquet
  size:    1.1 MB
  rows:    50,258
  symbols: 3,541

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-20 04:00:00	AAPL	Stock	19.5082	19.5104	19.5075	19.5104	39200.0
2013-12-20 05:00:00	AAPL	Stock	19.5046	19.5154	19.5043	19.5046	25200.0
2013-12-20 06:00:00	AAPL	Stock	19.5164	19.5164	19.4721	19.4721	15400.0
2013-12-20 07:00:00	AAPL	Stock	19.4814	19.4946	19.4536	19.4946	288092.0
2013-12-20 08:00:00	AAPL	Stock	19.4482	19.5286	19.445	19.5179	1071336.0
2013-12-20 09:00:00	AAPL	Stock	19.5179	19.6196	19.4578	19.603	87777676.0
2013-12-20 10:00:00	AAPL	Stock	19.6046	19.7004	19.5746	19.6875	55835192.0
2013-12-20 11:00:00	AAPL	Stock	19.6871	19.6886	19.6261	19.6407	36482992.0
2013-12-20 12:00:00	AAPL	Stock	19.6418	19.6539	19.6093	19.6279	21300804.0
2013-12-20 13:00:00	AAPL	Stock	19.6279	19.6357	19.6086	19.6314	16382156.0
2013-12-20 14:00:00	AAPL	Stock	19.6332	19.6486	19.6304	19.6411	20869632.0
2013-12-20 15:00:00	AAPL	Stock	19.6414	19.6429	19.5686	19.5971	60719232.0
2013-12-20 16:00:00	AAPL	Stock	19.6128	19.6352	19.4749	19.5957	69261248.0
2013-12-20 17:00:00	AAPL	Stock	19.5932	19.5982	19.5786	19.5893	9937284.0
2013-12-20 18:00:00	AAPL	Stock	19.5829	19.6089	19.5829	19.6089	341600.0
2013-12-20 19:00:00	AAPL	Stock	19.6093	19.6393	19.6093	19.6393	549052.0
2013-12-20 08:00:00	MSFT	Stock	36.3	36.4	36.26	36.35	29784.0
2013-12-20 09:00:00	MSFT	Stock	36.36	36.38	36.15	36.286	15975608.0
2013-12-20 10:00:00	MSFT	Stock	36.285	36.61	36.24	36.57	6272179.0
2013-12-20 11:00:00	MSFT	Stock	36.58	36.83	36.5	36.64	4713268.0
2013-12-20 12:00:00	MSFT	Stock	36.64	36.83	36.62	36.67	3710562.0
2013-12-20 13:00:00	MSFT	Stock	36.68	36.73	36.62	36.72	2546550.0
2013-12-20 14:00:00	MSFT	Stock	36.725	36.85	36.68	36.825	4229476.0
2013-12-20 15:00:00	MSFT	Stock	36.83	36.93	36.75	36.78	11984813.0
2013-12-20 16:00:00	MSFT	Stock	36.79	36.86	36.316	36.773	9529938.0
2013-12-20 17:00:00	MSFT	Stock	36.75	36.821	36.6	36.821	1484596.0
2013-12-20 18:00:00	MSFT	Stock	36.79	36.79	36.79	36.79	100.0
2013-12-20 19:00:00	MSFT	Stock	36.84	36.84	36.82	36.82	700.0
2013-12-20 08:00:00	NVDA	Stock	0.3845	0.3845	0.3845	0.3845	591040.0
2013-12-20 09:00:00	NVDA	Stock	0.385	0.3893	0.3842	0.3888	64215400.0
2013-12-20 10:00:00	NVDA	Stock	0.3888	0.3925	0.3888	0.3908	44648080.0
2013-12-20 11:00:00	NVDA	Stock	0.3909	0.3925	0.3908	0.3922	25206240.0
2013-12-20 12:00:00	NVDA	Stock	0.3921	0.3925	0.3908	0.3916	22635440.0
2013-12-20 13:00:00	NVDA	Stock	0.3916	0.392	0.3901	0.391	23863880.0
2013-12-20 14:00:00	NVDA	Stock	0.3913	0.392	0.391	0.3911	21018480.0
2013-12-20 15:00:00	NVDA	Stock	0.3911	0.3922	0.3898	0.3922	88459400.0
2013-12-20 16:00:00	NVDA	Stock	0.392	0.3922	0.3907	0.3918	61058720.0
2013-12-20 17:00:00	NVDA	Stock	0.3918	0.3919	0.3916	0.3918	21628840.0
2013-12-20 04:00:00	AMZN	Stock	19.7615	19.7615	19.74	19.74	10180.0
2013-12-20 05:00:00	AMZN	Stock	19.74	19.74	19.7395	19.7395	4000.0
2013-12-20 07:00:00	AMZN	Stock	19.717	19.717	19.717	19.717	2000.0
2013-12-20 08:00:00	AMZN	Stock	19.74	19.8025	19.74	19.8025	125500.0
2013-12-20 09:00:00	AMZN	Stock	19.803	20.0333	19.789	19.9265	24811820.0
2013-12-20 10:00:00	AMZN	Stock	19.9305	20.0975	19.9085	20.086	15415740.0
2013-12-20 11:00:00	AMZN	Stock	20.0855	20.176	20.0625	20.0948	11247340.0
2013-12-20 12:00:00	AMZN	Stock	20.1025	20.1625	20.079	20.1505	3935380.0
2013-12-20 13:00:00	AMZN	Stock	20.1515	20.2084	20.1314	20.1993	5451380.0
2013-12-20 14:00:00	AMZN	Stock	20.1993	20.236	20.179	20.226	4747120.0
2013-12-20 15:00:00	AMZN	Stock	20.23	20.23	20.1	20.135	18981000.0
2013-12-20 16:00:00	AMZN	Stock	20.11	20.1345	20.0505	20.1102	2462360.0

> showing 50 of 50,258 rows — these rows as CSV

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