PREVIEW / stock_1hour / 2013-11-06

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-11-06.parquet
  size:    1.0 MB
  rows:    47,353
  symbols: 3,529

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-06 04:00:00	AAPL	Stock	18.75	18.7771	18.7004	18.7004	75600.0
2013-11-06 05:00:00	AAPL	Stock	18.7004	18.7482	18.6964	18.7321	76356.0
2013-11-06 06:00:00	AAPL	Stock	18.7321	18.7875	18.7146	18.785	274120.0
2013-11-06 07:00:00	AAPL	Stock	18.7768	18.7925	18.725	18.725	382928.0
2013-11-06 08:00:00	AAPL	Stock	18.7389	18.7857	18.6571	18.7282	2128644.0
2013-11-06 09:00:00	AAPL	Stock	18.73	18.75	18.625	18.6468	44377172.0
2013-11-06 10:00:00	AAPL	Stock	18.6464	18.7054	18.5107	18.5347	51550072.0
2013-11-06 11:00:00	AAPL	Stock	18.5343	18.6146	18.5071	18.5616	26245744.0
2013-11-06 12:00:00	AAPL	Stock	18.5632	18.5964	18.5232	18.5291	17510668.0
2013-11-06 13:00:00	AAPL	Stock	18.5289	18.5814	18.5196	18.5796	12649728.0
2013-11-06 14:00:00	AAPL	Stock	18.5761	18.6042	18.5529	18.5857	14048524.0
2013-11-06 15:00:00	AAPL	Stock	18.5875	18.6116	18.5711	18.6025	26244792.0
2013-11-06 16:00:00	AAPL	Stock	18.6021	18.6632	18.5446	18.5743	16160620.0
2013-11-06 17:00:00	AAPL	Stock	18.5732	18.6021	18.55	18.5504	1680000.0
2013-11-06 18:00:00	AAPL	Stock	18.6021	18.6021	18.5464	18.5568	86156.0
2013-11-06 19:00:00	AAPL	Stock	18.5482	18.5668	18.5464	18.5464	216524.0
2013-11-06 05:00:00	MSFT	Stock	36.84	36.85	36.75	36.85	1800.0
2013-11-06 06:00:00	MSFT	Stock	36.85	36.9	36.75	36.88	15639.0
2013-11-06 07:00:00	MSFT	Stock	36.86	36.97	36.83	36.91	75022.0
2013-11-06 08:00:00	MSFT	Stock	36.87	36.97	36.53	36.9	388437.0
2013-11-06 09:00:00	MSFT	Stock	36.91	37.77	36.89	37.665	18862821.0
2013-11-06 10:00:00	MSFT	Stock	37.66	37.765	37.43	37.65	15211440.0
2013-11-06 11:00:00	MSFT	Stock	37.66	38.04	37.51	37.985	10435657.0
2013-11-06 12:00:00	MSFT	Stock	37.99	38.082	37.83	37.925	9552211.0
2013-11-06 13:00:00	MSFT	Stock	37.92	37.992	37.85	37.855	4669750.0
2013-11-06 14:00:00	MSFT	Stock	37.85	38.2	37.85	38.11	8184673.0
2013-11-06 15:00:00	MSFT	Stock	38.11	38.22	37.98	38.16	17279943.0
2013-11-06 16:00:00	MSFT	Stock	38.16	38.21	36.582	38.1	3558853.0
2013-11-06 17:00:00	MSFT	Stock	38.1	38.15	38.05	38.07	26458.0
2013-11-06 18:00:00	MSFT	Stock	38.07	38.15	38.04	38.08	23871.0
2013-11-06 19:00:00	MSFT	Stock	38.04	38.1	38.04	38.09	21113.0
2013-11-06 09:00:00	NVDA	Stock	0.37	0.3728	0.3662	0.3708	27105560.0
2013-11-06 10:00:00	NVDA	Stock	0.3708	0.371	0.3674	0.3696	47667120.0
2013-11-06 11:00:00	NVDA	Stock	0.3698	0.3725	0.3685	0.371	26146360.0
2013-11-06 12:00:00	NVDA	Stock	0.3712	0.3718	0.371	0.3715	11535080.0
2013-11-06 13:00:00	NVDA	Stock	0.3714	0.3715	0.3708	0.3711	11967760.0
2013-11-06 14:00:00	NVDA	Stock	0.3713	0.3718	0.3708	0.3715	13587880.0
2013-11-06 15:00:00	NVDA	Stock	0.3716	0.3725	0.371	0.3723	48095640.0
2013-11-06 16:00:00	NVDA	Stock	0.3725	0.3725	0.3705	0.3715	11809080.0
2013-11-06 19:00:00	NVDA	Stock	0.3725	0.3725	0.3725	0.3725	4600.0
2013-11-06 08:00:00	AMZN	Stock	17.94	18.025	17.94	18.019	54580.0
2013-11-06 09:00:00	AMZN	Stock	18.019	18.1435	17.853	18.1	6552680.0
2013-11-06 10:00:00	AMZN	Stock	18.0905	18.1125	17.85	17.8705	9549620.0
2013-11-06 11:00:00	AMZN	Stock	17.865	17.9115	17.7665	17.902	7806420.0
2013-11-06 12:00:00	AMZN	Stock	17.902	17.94	17.8	17.8125	4741900.0
2013-11-06 13:00:00	AMZN	Stock	17.8135	17.8335	17.775	17.8087	2320620.0
2013-11-06 14:00:00	AMZN	Stock	17.8095	17.832	17.725	17.765	4003940.0
2013-11-06 15:00:00	AMZN	Stock	17.761	17.8274	17.725	17.8085	8346760.0
2013-11-06 16:00:00	AMZN	Stock	17.809	17.8875	17.755	17.773	424820.0
2013-11-06 17:00:00	AMZN	Stock	17.785	17.809	17.785	17.809	31060.0

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

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