PREVIEW / stock_1hour / 2016-07-28

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-07-28.parquet
  size:    1.0 MB
  rows:    48,397
  symbols: 3,261

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
2016-07-28 04:00:00	AAPL	Stock	25.85	25.875	25.8	25.8025	18492.0
2016-07-28 05:00:00	AAPL	Stock	25.8075	25.8325	25.7775	25.7825	22468.0
2016-07-28 06:00:00	AAPL	Stock	25.7875	25.7875	25.78	25.78	9896.0
2016-07-28 07:00:00	AAPL	Stock	25.765	25.785	25.7025	25.7225	111448.0
2016-07-28 08:00:00	AAPL	Stock	25.7225	25.77	25.675	25.7375	294756.0
2016-07-28 09:00:00	AAPL	Stock	25.745	26.0575	25.705	25.9875	26852516.0
2016-07-28 10:00:00	AAPL	Stock	25.99	26.0375	25.9275	25.9825	26965748.0
2016-07-28 11:00:00	AAPL	Stock	25.9825	25.9975	25.875	25.9648	16298784.0
2016-07-28 12:00:00	AAPL	Stock	25.9625	25.975	25.875	25.8998	10212552.0
2016-07-28 13:00:00	AAPL	Stock	25.9	25.995	25.89	25.995	9885588.0
2016-07-28 14:00:00	AAPL	Stock	25.9962	26.025	25.9875	26.01	11750020.0
2016-07-28 15:00:00	AAPL	Stock	26.01	26.1125	25.9975	26.0825	26247372.0
2016-07-28 16:00:00	AAPL	Stock	26.085	26.125	26.0325	26.125	8668836.0
2016-07-28 17:00:00	AAPL	Stock	26.11	26.145	26.105	26.1275	222764.0
2016-07-28 18:00:00	AAPL	Stock	26.14	26.14	26.1175	26.135	98368.0
2016-07-28 19:00:00	AAPL	Stock	26.125	26.145	26.1175	26.135	115380.0
2016-07-28 07:00:00	MSFT	Stock	56.11	56.11	56.1	56.1	512.0
2016-07-28 08:00:00	MSFT	Stock	56.06	56.06	55.89	55.99	2711.0
2016-07-28 09:00:00	MSFT	Stock	55.92	56.22	55.91	56.065	3550445.0
2016-07-28 10:00:00	MSFT	Stock	56.07	56.15	55.72	55.8	9880548.0
2016-07-28 11:00:00	MSFT	Stock	55.8	55.98	55.77	55.97	3978154.0
2016-07-28 12:00:00	MSFT	Stock	55.965	56.14	55.95	56.095	2450522.0
2016-07-28 13:00:00	MSFT	Stock	56.1	56.3	56.075	56.29	3293046.0
2016-07-28 14:00:00	MSFT	Stock	56.3	56.37	56.22	56.245	2242440.0
2016-07-28 15:00:00	MSFT	Stock	56.24	56.29	56.15	56.21	6715291.0
2016-07-28 16:00:00	MSFT	Stock	56.21	56.25	56.06	56.09	3421449.0
2016-07-28 17:00:00	MSFT	Stock	56.1	56.2	56.1	56.1	4700.0
2016-07-28 18:00:00	MSFT	Stock	56.17	56.19	56.11	56.19	400.0
2016-07-28 19:00:00	MSFT	Stock	56.2	56.2	56.19	56.19	1550.0
2016-07-28 09:00:00	NVDA	Stock	1.4033	1.415	1.3998	1.4055	50448960.0
2016-07-28 10:00:00	NVDA	Stock	1.4055	1.4142	1.4004	1.4043	29588920.0
2016-07-28 11:00:00	NVDA	Stock	1.4043	1.4073	1.4025	1.4065	17457040.0
2016-07-28 12:00:00	NVDA	Stock	1.4065	1.4075	1.4004	1.4026	13386280.0
2016-07-28 13:00:00	NVDA	Stock	1.4025	1.4053	1.4016	1.4038	15109160.0
2016-07-28 14:00:00	NVDA	Stock	1.4038	1.4075	1.4018	1.4045	27720680.0
2016-07-28 15:00:00	NVDA	Stock	1.4048	1.406	1.4026	1.404	39072880.0
2016-07-28 16:00:00	NVDA	Stock	1.4045	1.409	1.402	1.4025	3575800.0
2016-07-28 17:00:00	NVDA	Stock	1.4065	1.4115	1.4038	1.4113	112000.0
2016-07-28 18:00:00	NVDA	Stock	1.4108	1.4108	1.4045	1.4088	840560.0
2016-07-28 19:00:00	NVDA	Stock	1.4088	1.4098	1.4088	1.4098	122240.0
2016-07-28 04:00:00	AMZN	Stock	37.2	37.2	37.1965	37.1965	11280.0
2016-07-28 05:00:00	AMZN	Stock	37.208	37.208	37.208	37.208	10260.0
2016-07-28 06:00:00	AMZN	Stock	37.21	37.275	37.1	37.1	25940.0
2016-07-28 07:00:00	AMZN	Stock	37.1275	37.188	37.0825	37.124	100840.0
2016-07-28 08:00:00	AMZN	Stock	37.15	37.2445	37.0875	37.2005	603920.0
2016-07-28 09:00:00	AMZN	Stock	37.2245	37.3	36.985	37.0815	13036080.0
2016-07-28 10:00:00	AMZN	Stock	37.076	37.2724	37.0678	37.2665	10447800.0
2016-07-28 11:00:00	AMZN	Stock	37.2635	37.491	37.2325	37.37	13910780.0
2016-07-28 12:00:00	AMZN	Stock	37.37	37.4212	37.15	37.163	8284800.0
2016-07-28 13:00:00	AMZN	Stock	37.176	37.2455	37.1276	37.224	7934400.0

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

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