PREVIEW / stock_1hour / 2013-11-15

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-11-15.parquet
  size:    1.0 MB
  rows:    47,190
  symbols: 3,545

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-11-15 04:00:00	AAPL	Stock	18.8571	18.8932	18.8571	18.8932	19600.0
2013-11-15 05:00:00	AAPL	Stock	18.8589	18.8807	18.8457	18.8611	19600.0
2013-11-15 06:00:00	AAPL	Stock	18.8929	18.8929	18.8929	18.8929	30464.0
2013-11-15 07:00:00	AAPL	Stock	18.8929	18.9121	18.8571	18.8571	533120.0
2013-11-15 08:00:00	AAPL	Stock	18.875	18.9036	18.8214	18.8482	1252160.0
2013-11-15 09:00:00	AAPL	Stock	18.8482	18.8626	18.7739	18.8232	51197832.0
2013-11-15 10:00:00	AAPL	Stock	18.8225	18.8961	18.7679	18.7818	53094804.0
2013-11-15 11:00:00	AAPL	Stock	18.783	18.8168	18.7454	18.7529	30408532.0
2013-11-15 12:00:00	AAPL	Stock	18.7567	18.7907	18.7468	18.76	14788004.0
2013-11-15 13:00:00	AAPL	Stock	18.7625	18.7961	18.7557	18.7714	13282612.0
2013-11-15 14:00:00	AAPL	Stock	18.7705	18.7711	18.7346	18.74	37727088.0
2013-11-15 15:00:00	AAPL	Stock	18.7393	18.7643	18.7318	18.7479	49435960.0
2013-11-15 16:00:00	AAPL	Stock	18.7529	18.8186	18.7457	18.7493	50669080.0
2013-11-15 17:00:00	AAPL	Stock	18.7504	18.7521	18.7486	18.7486	128044.0
2013-11-15 18:00:00	AAPL	Stock	18.7496	18.7529	18.7464	18.7464	353248.0
2013-11-15 19:00:00	AAPL	Stock	18.7464	18.7482	18.7411	18.7454	149464.0
2013-11-15 04:00:00	MSFT	Stock	38.05	38.05	38.05	38.05	199.0
2013-11-15 06:00:00	MSFT	Stock	38.0	38.12	38.0	38.12	1510.0
2013-11-15 07:00:00	MSFT	Stock	38.11	38.11	38.01	38.01	200.0
2013-11-15 08:00:00	MSFT	Stock	38.11	38.11	38.03	38.06	13019.0
2013-11-15 09:00:00	MSFT	Stock	38.07	38.07	37.87	37.98	8578286.0
2013-11-15 10:00:00	MSFT	Stock	37.976	38.0	37.87	37.92	5908143.0
2013-11-15 11:00:00	MSFT	Stock	37.92	37.93	37.8	37.82	3559867.0
2013-11-15 12:00:00	MSFT	Stock	37.83	37.84	37.72	37.73	5208050.0
2013-11-15 13:00:00	MSFT	Stock	37.73	37.83	37.72	37.8	5212941.0
2013-11-15 14:00:00	MSFT	Stock	37.81	37.83	37.77	37.8	4828849.0
2013-11-15 15:00:00	MSFT	Stock	37.791	37.88	37.77	37.87	12057852.0
2013-11-15 16:00:00	MSFT	Stock	37.88	37.941	37.787	37.941	4305594.0
2013-11-15 17:00:00	MSFT	Stock	37.9	37.9	37.83	37.87	13650.0
2013-11-15 18:00:00	MSFT	Stock	37.88	37.88	37.85	37.85	450.0
2013-11-15 19:00:00	MSFT	Stock	37.83	37.85	37.83	37.85	306.0
2013-11-15 04:00:00	NVDA	Stock	0.4125	0.4125	0.4125	0.4125	44000.0
2013-11-15 05:00:00	NVDA	Stock	0.425	0.425	0.425	0.425	24000.0
2013-11-15 07:00:00	NVDA	Stock	0.4122	0.4185	0.4122	0.4185	44000.0
2013-11-15 08:00:00	NVDA	Stock	0.4125	0.4125	0.4125	0.4125	175000.0
2013-11-15 09:00:00	NVDA	Stock	0.4075	0.409	0.4003	0.4015	46338400.0
2013-11-15 10:00:00	NVDA	Stock	0.4018	0.4038	0.4008	0.4038	30654040.0
2013-11-15 11:00:00	NVDA	Stock	0.4035	0.4058	0.403	0.4034	24756960.0
2013-11-15 12:00:00	NVDA	Stock	0.4034	0.405	0.4032	0.4039	15992560.0
2013-11-15 13:00:00	NVDA	Stock	0.4038	0.406	0.4038	0.4053	15453920.0
2013-11-15 14:00:00	NVDA	Stock	0.4053	0.4062	0.405	0.4051	14454840.0
2013-11-15 15:00:00	NVDA	Stock	0.4051	0.4062	0.4032	0.4043	77072560.0
2013-11-15 16:00:00	NVDA	Stock	0.4043	0.406	0.4043	0.406	5148040.0
2013-11-15 04:00:00	AMZN	Stock	18.3695	18.3695	18.3555	18.3625	6000.0
2013-11-15 05:00:00	AMZN	Stock	18.3625	18.3625	18.3625	18.3625	2000.0
2013-11-15 06:00:00	AMZN	Stock	18.415	18.415	18.415	18.415	4000.0
2013-11-15 07:00:00	AMZN	Stock	18.4275	18.45	18.41	18.435	159540.0
2013-11-15 08:00:00	AMZN	Stock	18.45	18.45	18.362	18.4	300200.0
2013-11-15 09:00:00	AMZN	Stock	18.4	18.6275	18.3325	18.53	20151940.0
2013-11-15 10:00:00	AMZN	Stock	18.53	18.645	18.387	18.4245	14608760.0

> showing 50 of 47,190 rows — these rows as CSV

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