PREVIEW / stock_1hour / 2013-09-20

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-09-20.parquet
  size:    1.0 MB
  rows:    48,106
  symbols: 3,537

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-09-20 04:00:00	AAPL	Stock	16.8264	16.87	16.8182	16.8257	44800.0
2013-09-20 05:00:00	AAPL	Stock	16.8396	16.8679	16.8396	16.8679	40600.0
2013-09-20 06:00:00	AAPL	Stock	16.8907	16.9375	16.8907	16.9268	48720.0
2013-09-20 07:00:00	AAPL	Stock	16.9225	17.1104	16.8893	17.0807	2295720.0
2013-09-20 08:00:00	AAPL	Stock	17.0807	17.1529	16.9904	17.0936	9920736.0
2013-09-20 09:00:00	AAPL	Stock	17.09	17.1171	16.8811	16.9121	125674612.0
2013-09-20 10:00:00	AAPL	Stock	16.9068	17.0196	16.9018	17.0129	55215916.0
2013-09-20 11:00:00	AAPL	Stock	17.0165	17.0171	16.8932	16.9082	43543024.0
2013-09-20 12:00:00	AAPL	Stock	16.9079	16.9254	16.8489	16.8643	43155616.0
2013-09-20 13:00:00	AAPL	Stock	16.865	16.875	16.7632	16.8071	46651976.0
2013-09-20 14:00:00	AAPL	Stock	16.8043	16.8407	16.7729	16.8271	40293960.0
2013-09-20 15:00:00	AAPL	Stock	16.8271	16.8375	16.6429	16.6779	130471768.0
2013-09-20 16:00:00	AAPL	Stock	16.6779	16.8877	16.6607	16.6643	186309228.0
2013-09-20 17:00:00	AAPL	Stock	16.6607	16.6932	16.6286	16.6536	1429176.0
2013-09-20 18:00:00	AAPL	Stock	16.6607	16.6814	16.6539	16.6789	287644.0
2013-09-20 19:00:00	AAPL	Stock	16.6836	16.6929	16.6693	16.6879	729848.0
2013-09-20 07:00:00	MSFT	Stock	33.5	33.68	33.35	33.51	141000.0
2013-09-20 08:00:00	MSFT	Stock	33.55	33.55	33.2	33.29	257560.0
2013-09-20 09:00:00	MSFT	Stock	33.29	33.54	32.954	33.05	25445103.0
2013-09-20 10:00:00	MSFT	Stock	33.05	33.12	32.91	32.94	9387192.0
2013-09-20 11:00:00	MSFT	Stock	32.94	32.941	32.685	32.73	9210688.0
2013-09-20 12:00:00	MSFT	Stock	32.73	32.87	32.72	32.855	5575964.0
2013-09-20 13:00:00	MSFT	Stock	32.855	32.87	32.7	32.84	5457814.0
2013-09-20 14:00:00	MSFT	Stock	32.84	32.965	32.77	32.865	5551704.0
2013-09-20 15:00:00	MSFT	Stock	32.865	32.965	32.74	32.76	16945475.0
2013-09-20 16:00:00	MSFT	Stock	32.76	32.978	32.691	32.76	22364579.0
2013-09-20 17:00:00	MSFT	Stock	32.7	32.929	32.697	32.7	312650.0
2013-09-20 18:00:00	MSFT	Stock	32.72	32.8	32.7	32.73	39960.0
2013-09-20 19:00:00	MSFT	Stock	32.74	32.75	32.73	32.73	2780.0
2013-09-20 08:00:00	NVDA	Stock	0.3993	0.3993	0.3993	0.3993	16000.0
2013-09-20 09:00:00	NVDA	Stock	0.3993	0.4017	0.399	0.401	68966360.0
2013-09-20 10:00:00	NVDA	Stock	0.4008	0.401	0.3985	0.3988	35170440.0
2013-09-20 11:00:00	NVDA	Stock	0.3986	0.3993	0.3965	0.3965	25789280.0
2013-09-20 12:00:00	NVDA	Stock	0.3968	0.3981	0.3962	0.3978	18168320.0
2013-09-20 13:00:00	NVDA	Stock	0.3976	0.3979	0.3962	0.3969	15818200.0
2013-09-20 14:00:00	NVDA	Stock	0.397	0.3971	0.3959	0.3968	22788040.0
2013-09-20 15:00:00	NVDA	Stock	0.3969	0.3973	0.394	0.395	80051920.0
2013-09-20 16:00:00	NVDA	Stock	0.3948	0.3977	0.3945	0.3946	75308240.0
2013-09-20 17:00:00	NVDA	Stock	0.3945	0.3945	0.3945	0.3945	9200.0
2013-09-20 18:00:00	NVDA	Stock	0.3948	0.3948	0.3948	0.3948	773040.0
2013-09-20 09:00:00	AMZN	Stock	15.615	15.84	15.614	15.8295	22222280.0
2013-09-20 10:00:00	AMZN	Stock	15.826	16.0285	15.815	15.9866	16568200.0
2013-09-20 11:00:00	AMZN	Stock	15.985	15.9905	15.821	15.834	10398460.0
2013-09-20 12:00:00	AMZN	Stock	15.834	15.89	15.74	15.89	7280200.0
2013-09-20 13:00:00	AMZN	Stock	15.89	15.8925	15.768	15.8185	4887280.0
2013-09-20 14:00:00	AMZN	Stock	15.8208	15.862	15.757	15.836	5241280.0
2013-09-20 15:00:00	AMZN	Stock	15.83	15.8592	15.772	15.8185	11056720.0
2013-09-20 16:00:00	AMZN	Stock	15.817	15.8245	15.7905	15.8164	15189520.0
2013-09-20 17:00:00	AMZN	Stock	15.817	15.9201	15.806	15.8085	123140.0
2013-09-20 18:00:00	AMZN	Stock	15.809	15.817	15.809	15.817	66480.0

> showing 50 of 48,106 rows — these rows as CSV

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