PREVIEW / stock_1hour / 2014-09-26

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-09-26.parquet
  size:    1.0 MB
  rows:    47,918
  symbols: 3,557

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
2014-09-26 04:00:00	AAPL	Stock	24.6875	24.6875	24.4675	24.52	37368.0
2014-09-26 05:00:00	AAPL	Stock	24.5175	24.69	24.4925	24.6775	51004.0
2014-09-26 06:00:00	AAPL	Stock	24.675	24.675	24.5775	24.5925	75728.0
2014-09-26 07:00:00	AAPL	Stock	24.5925	24.7675	24.5675	24.6375	491548.0
2014-09-26 08:00:00	AAPL	Stock	24.66	24.775	24.575	24.6875	1850528.0
2014-09-26 09:00:00	AAPL	Stock	24.6875	24.9025	24.5975	24.8825	43966676.0
2014-09-26 10:00:00	AAPL	Stock	24.885	24.9975	24.8575	24.93	42900948.0
2014-09-26 11:00:00	AAPL	Stock	24.9242	24.9425	24.8125	24.885	26115768.0
2014-09-26 12:00:00	AAPL	Stock	24.8838	24.965	24.88	24.95	15726200.0
2014-09-26 13:00:00	AAPL	Stock	24.9513	25.0125	24.94	25.0125	19002244.0
2014-09-26 14:00:00	AAPL	Stock	25.01	25.1475	25.01	25.1162	32885248.0
2014-09-26 15:00:00	AAPL	Stock	25.1162	25.185	25.1075	25.1825	44198128.0
2014-09-26 16:00:00	AAPL	Stock	25.17	25.1875	24.4675	25.1575	10536944.0
2014-09-26 17:00:00	AAPL	Stock	25.1575	25.1875	25.1575	25.175	99336.0
2014-09-26 18:00:00	AAPL	Stock	25.175	25.1875	25.1575	25.1575	169576.0
2014-09-26 19:00:00	AAPL	Stock	25.1575	25.175	25.1525	25.175	151624.0
2014-09-26 05:00:00	MSFT	Stock	46.06	46.06	46.06	46.06	100.0
2014-09-26 06:00:00	MSFT	Stock	46.2	46.23	46.2	46.23	876.0
2014-09-26 07:00:00	MSFT	Stock	46.2	46.35	46.2	46.2	1067.0
2014-09-26 08:00:00	MSFT	Stock	46.2	46.25	46.04	46.23	509875.0
2014-09-26 09:00:00	MSFT	Stock	46.14	46.29	45.76	46.155	4202447.0
2014-09-26 10:00:00	MSFT	Stock	46.15	46.31	46.11	46.26	2732851.0
2014-09-26 11:00:00	MSFT	Stock	46.233	46.31	46.08	46.114	2661976.0
2014-09-26 12:00:00	MSFT	Stock	46.12	46.15	46.02	46.13	2140586.0
2014-09-26 13:00:00	MSFT	Stock	46.13	46.22	46.1	46.2	1912272.0
2014-09-26 14:00:00	MSFT	Stock	46.2	46.62	46.19	46.52	3155450.0
2014-09-26 15:00:00	MSFT	Stock	46.515	46.53	46.39	46.4	5991036.0
2014-09-26 16:00:00	MSFT	Stock	46.41	46.445	46.15	46.41	3027774.0
2014-09-26 17:00:00	MSFT	Stock	46.44	46.44	46.4	46.4	3155.0
2014-09-26 18:00:00	MSFT	Stock	46.32	46.41	46.32	46.41	26871.0
2014-09-26 19:00:00	MSFT	Stock	46.43	46.43	46.43	46.43	500.0
2014-09-26 09:00:00	NVDA	Stock	0.461	0.4668	0.461	0.465	19755360.0
2014-09-26 10:00:00	NVDA	Stock	0.4652	0.4665	0.4638	0.466	42236320.0
2014-09-26 11:00:00	NVDA	Stock	0.4662	0.4668	0.4655	0.4658	15586080.0
2014-09-26 12:00:00	NVDA	Stock	0.466	0.4673	0.4658	0.466	14285280.0
2014-09-26 13:00:00	NVDA	Stock	0.466	0.4665	0.4635	0.4639	16985080.0
2014-09-26 14:00:00	NVDA	Stock	0.464	0.4655	0.4635	0.4655	31198600.0
2014-09-26 15:00:00	NVDA	Stock	0.4655	0.4658	0.4622	0.4635	84749200.0
2014-09-26 16:00:00	NVDA	Stock	0.4636	0.4652	0.4636	0.4636	1832640.0
2014-09-26 05:00:00	AMZN	Stock	16.0965	16.0965	16.0965	16.0965	56000.0
2014-09-26 08:00:00	AMZN	Stock	16.0965	16.1935	16.0965	16.1255	44300.0
2014-09-26 09:00:00	AMZN	Stock	16.1905	16.1905	16.005	16.0348	7435180.0
2014-09-26 10:00:00	AMZN	Stock	16.038	16.082	15.9	15.9435	17025900.0
2014-09-26 11:00:00	AMZN	Stock	15.951	15.969	15.882	15.9095	9280920.0
2014-09-26 12:00:00	AMZN	Stock	15.921	16.0544	15.9125	16.0518	6490820.0
2014-09-26 13:00:00	AMZN	Stock	16.0512	16.075	16.0085	16.0452	4366500.0
2014-09-26 14:00:00	AMZN	Stock	16.0495	16.171	16.047	16.158	6855960.0
2014-09-26 15:00:00	AMZN	Stock	16.157	16.1748	16.079	16.159	12809660.0
2014-09-26 16:00:00	AMZN	Stock	16.1605	16.1638	16.0289	16.1605	562420.0
2014-09-26 17:00:00	AMZN	Stock	16.1605	16.169	16.1025	16.1025	57400.0

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

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