PREVIEW / stock_1hour / 2013-05-28

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-28.parquet
  size:    1024 KB
  rows:    47,108
  symbols: 3,533

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-05-28 04:00:00	AAPL	Stock	16.0036	16.0225	16.0	16.0225	28000.0
2013-05-28 05:00:00	AAPL	Stock	16.0036	16.0179	16.0	16.0	37716.0
2013-05-28 06:00:00	AAPL	Stock	15.9946	15.9946	15.9329	15.9486	123088.0
2013-05-28 07:00:00	AAPL	Stock	15.9711	16.0836	15.9711	16.0643	1362928.0
2013-05-28 08:00:00	AAPL	Stock	16.0539	16.1193	15.8929	16.0893	2899848.0
2013-05-28 09:00:00	AAPL	Stock	16.0825	16.1111	15.9414	15.9943	76086108.0
2013-05-28 10:00:00	AAPL	Stock	15.995	16.0532	15.8429	15.91	82841220.0
2013-05-28 11:00:00	AAPL	Stock	15.9072	15.9554	15.8229	15.8321	41392540.0
2013-05-28 12:00:00	AAPL	Stock	15.8322	15.8714	15.7814	15.8082	38110912.0
2013-05-28 13:00:00	AAPL	Stock	15.8085	15.8286	15.7446	15.7733	41214488.0
2013-05-28 14:00:00	AAPL	Stock	15.7721	15.8214	15.7614	15.8121	25157104.0
2013-05-28 15:00:00	AAPL	Stock	15.8157	15.8461	15.7532	15.7659	43469104.0
2013-05-28 16:00:00	AAPL	Stock	15.7657	16.0174	15.7361	15.7411	17407292.0
2013-05-28 17:00:00	AAPL	Stock	15.7429	15.745	15.6961	15.7036	645792.0
2013-05-28 18:00:00	AAPL	Stock	15.7136	15.7179	15.7054	15.7164	148680.0
2013-05-28 19:00:00	AAPL	Stock	15.7164	15.7318	15.7054	15.7143	379316.0
2013-05-28 07:00:00	MSFT	Stock	34.54	34.55	34.5	34.5	1061.0
2013-05-28 08:00:00	MSFT	Stock	34.48	34.64	34.25	34.6	212898.0
2013-05-28 09:00:00	MSFT	Stock	34.56	35.18	34.41	34.93	7846852.0
2013-05-28 10:00:00	MSFT	Stock	34.93	35.02	34.78	34.865	6541035.0
2013-05-28 11:00:00	MSFT	Stock	34.865	34.93	34.76	34.782	4217615.0
2013-05-28 12:00:00	MSFT	Stock	34.785	34.84	34.74	34.785	3168772.0
2013-05-28 13:00:00	MSFT	Stock	34.785	34.83	34.59	34.685	3914056.0
2013-05-28 14:00:00	MSFT	Stock	34.68	34.86	34.66	34.81	4928901.0
2013-05-28 15:00:00	MSFT	Stock	34.81	35.05	34.79	35.02	11116029.0
2013-05-28 16:00:00	MSFT	Stock	35.01	35.04	34.82	35.04	4374190.0
2013-05-28 17:00:00	MSFT	Stock	35.04	35.05	35.02	35.02	7512.0
2013-05-28 18:00:00	MSFT	Stock	35.0	35.0	34.97	34.97	3213.0
2013-05-28 19:00:00	MSFT	Stock	34.98	35.01	34.98	35.01	3747.0
2013-05-28 04:00:00	NVDA	Stock	0.3658	0.3658	0.3658	0.3658	4000.0
2013-05-28 08:00:00	NVDA	Stock	0.3665	0.368	0.3665	0.368	16000.0
2013-05-28 09:00:00	NVDA	Stock	0.368	0.368	0.3618	0.366	31651560.0
2013-05-28 10:00:00	NVDA	Stock	0.366	0.3668	0.3638	0.3658	37978080.0
2013-05-28 11:00:00	NVDA	Stock	0.3658	0.367	0.364	0.3641	41898120.0
2013-05-28 12:00:00	NVDA	Stock	0.364	0.365	0.3638	0.3642	24958400.0
2013-05-28 13:00:00	NVDA	Stock	0.3642	0.365	0.3625	0.3625	29258040.0
2013-05-28 14:00:00	NVDA	Stock	0.3625	0.363	0.3598	0.3605	43429520.0
2013-05-28 15:00:00	NVDA	Stock	0.3606	0.3648	0.3605	0.3635	56426880.0
2013-05-28 16:00:00	NVDA	Stock	0.3632	0.3658	0.3628	0.3633	13181840.0
2013-05-28 04:00:00	AMZN	Stock	13.186	13.186	13.186	13.186	2000.0
2013-05-28 06:00:00	AMZN	Stock	13.237	13.25	13.237	13.25	35220.0
2013-05-28 07:00:00	AMZN	Stock	13.245	13.3	13.245	13.2785	161900.0
2013-05-28 08:00:00	AMZN	Stock	13.2565	13.334	13.085	13.296	183780.0
2013-05-28 09:00:00	AMZN	Stock	13.301	13.5175	13.3	13.5175	17210460.0
2013-05-28 10:00:00	AMZN	Stock	13.5175	13.555	13.4565	13.522	13243660.0
2013-05-28 11:00:00	AMZN	Stock	13.516	13.5373	13.44	13.4424	7397240.0
2013-05-28 12:00:00	AMZN	Stock	13.4412	13.4685	13.4075	13.4645	5269120.0
2013-05-28 13:00:00	AMZN	Stock	13.464	13.4775	13.353	13.3665	6027260.0
2013-05-28 14:00:00	AMZN	Stock	13.3705	13.4105	13.3325	13.397	6378080.0
2013-05-28 15:00:00	AMZN	Stock	13.3975	13.4215	13.36	13.3645	8494940.0

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

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