PREVIEW / stock_1hour / 2013-03-14

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-03-14.parquet
  size:    983 KB
  rows:    46,019
  symbols: 3,455

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-03-14 04:00:00	AAPL	Stock	15.3464	15.3571	15.3464	15.3571	24640.0
2013-03-14 06:00:00	AAPL	Stock	15.3571	15.3589	15.3329	15.3329	44772.0
2013-03-14 07:00:00	AAPL	Stock	15.3464	15.5214	15.3414	15.4614	1342068.0
2013-03-14 08:00:00	AAPL	Stock	15.4557	15.5236	15.25	15.4468	5030340.0
2013-03-14 09:00:00	AAPL	Stock	15.445	15.5086	15.3982	15.4739	64404844.0
2013-03-14 10:00:00	AAPL	Stock	15.4736	15.5229	15.3732	15.3961	65741172.0
2013-03-14 11:00:00	AAPL	Stock	15.3964	15.4739	15.3929	15.4454	41228768.0
2013-03-14 12:00:00	AAPL	Stock	15.4446	15.4946	15.4286	15.4568	30482144.0
2013-03-14 13:00:00	AAPL	Stock	15.4563	15.4679	15.4032	15.4204	20695276.0
2013-03-14 14:00:00	AAPL	Stock	15.4243	15.4632	15.4127	15.4543	16523528.0
2013-03-14 15:00:00	AAPL	Stock	15.4568	15.4732	15.4254	15.4421	38729152.0
2013-03-14 16:00:00	AAPL	Stock	15.4421	15.4575	15.4254	15.4329	14540960.0
2013-03-14 17:00:00	AAPL	Stock	15.4321	15.4464	15.4196	15.4318	283360.0
2013-03-14 18:00:00	AAPL	Stock	15.4279	15.4318	15.4161	15.4275	138712.0
2013-03-14 19:00:00	AAPL	Stock	15.4204	15.4318	15.4021	15.4021	396648.0
2013-03-14 08:00:00	MSFT	Stock	27.95	28.01	27.85	28.01	7913.0
2013-03-14 09:00:00	MSFT	Stock	28.01	28.07	27.93	27.964	9605615.0
2013-03-14 10:00:00	MSFT	Stock	27.965	28.04	27.945	28.005	9759585.0
2013-03-14 11:00:00	MSFT	Stock	28.0	28.035	27.99	28.01	5737831.0
2013-03-14 12:00:00	MSFT	Stock	28.0	28.15	28.0	28.15	6395737.0
2013-03-14 13:00:00	MSFT	Stock	28.14	28.16	28.04	28.09	5601641.0
2013-03-14 14:00:00	MSFT	Stock	28.096	28.14	28.04	28.14	4282234.0
2013-03-14 15:00:00	MSFT	Stock	28.135	28.15	28.09	28.13	9878497.0
2013-03-14 16:00:00	MSFT	Stock	28.13	28.143	28.019	28.1	3294977.0
2013-03-14 17:00:00	MSFT	Stock	28.135	28.15	28.08	28.08	30311.0
2013-03-14 18:00:00	MSFT	Stock	28.14	28.15	28.09	28.1	5786.0
2013-03-14 19:00:00	MSFT	Stock	28.12	28.16	28.12	28.16	860.0
2013-03-14 08:00:00	NVDA	Stock	0.3185	0.32	0.3185	0.32	80000.0
2013-03-14 09:00:00	NVDA	Stock	0.3193	0.3215	0.3193	0.3195	60318400.0
2013-03-14 10:00:00	NVDA	Stock	0.3196	0.3198	0.3175	0.318	58836880.0
2013-03-14 11:00:00	NVDA	Stock	0.318	0.318	0.3168	0.3175	48011200.0
2013-03-14 12:00:00	NVDA	Stock	0.3176	0.319	0.317	0.3186	54120800.0
2013-03-14 13:00:00	NVDA	Stock	0.3185	0.3193	0.3175	0.3175	31192600.0
2013-03-14 14:00:00	NVDA	Stock	0.3178	0.3184	0.3175	0.3178	34241600.0
2013-03-14 15:00:00	NVDA	Stock	0.3178	0.319	0.3175	0.3186	82091120.0
2013-03-14 16:00:00	NVDA	Stock	0.3188	0.3188	0.3178	0.3185	2606480.0
2013-03-14 17:00:00	NVDA	Stock	0.3188	0.3188	0.3188	0.3188	171160.0
2013-03-14 04:00:00	AMZN	Stock	13.6	13.6	13.5605	13.5605	4000.0
2013-03-14 05:00:00	AMZN	Stock	13.565	13.565	13.55	13.55	16000.0
2013-03-14 06:00:00	AMZN	Stock	13.525	13.525	13.525	13.525	10000.0
2013-03-14 07:00:00	AMZN	Stock	13.5005	13.5005	13.4165	13.4735	129480.0
2013-03-14 08:00:00	AMZN	Stock	13.475	13.5435	13.45	13.45	1232940.0
2013-03-14 09:00:00	AMZN	Stock	13.46	13.5	13.3475	13.373	19145780.0
2013-03-14 10:00:00	AMZN	Stock	13.373	13.4125	13.3	13.3349	19718100.0
2013-03-14 11:00:00	AMZN	Stock	13.336	13.4455	13.333	13.4315	9183120.0
2013-03-14 12:00:00	AMZN	Stock	13.432	13.484	13.406	13.4185	6608720.0
2013-03-14 13:00:00	AMZN	Stock	13.4182	13.435	13.371	13.394	7852280.0
2013-03-14 14:00:00	AMZN	Stock	13.3915	13.401	13.3135	13.3315	7457760.0
2013-03-14 15:00:00	AMZN	Stock	13.3325	13.339	13.1765	13.28	28356360.0
2013-03-14 16:00:00	AMZN	Stock	13.2815	13.4426	13.275	13.3075	4242300.0

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

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