PREVIEW / stock_1hour / 2016-07-29

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-07-29.parquet
  size:    1.1 MB
  rows:    48,653
  symbols: 3,286

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-29 04:00:00	AAPL	Stock	26.0	26.11	26.0	26.0375	4800.0
2016-07-29 05:00:00	AAPL	Stock	26.015	26.015	26.015	26.015	1600.0
2016-07-29 06:00:00	AAPL	Stock	26.045	26.1125	26.045	26.1125	14016.0
2016-07-29 07:00:00	AAPL	Stock	26.055	26.12	26.05	26.0925	45284.0
2016-07-29 08:00:00	AAPL	Stock	26.065	26.125	26.04	26.0875	293348.0
2016-07-29 09:00:00	AAPL	Stock	26.09	26.1375	25.92	26.0325	21585768.0
2016-07-29 10:00:00	AAPL	Stock	26.0325	26.035	25.9475	25.9852	13809044.0
2016-07-29 11:00:00	AAPL	Stock	25.9875	26.0512	25.9725	26.0175	10535220.0
2016-07-29 12:00:00	AAPL	Stock	26.015	26.0525	26.01	26.0112	7408264.0
2016-07-29 13:00:00	AAPL	Stock	26.0125	26.1	26.0	26.09	9012768.0
2016-07-29 14:00:00	AAPL	Stock	26.09	26.0925	26.02	26.0575	8646640.0
2016-07-29 15:00:00	AAPL	Stock	26.0575	26.0825	26.025	26.0487	17209072.0
2016-07-29 16:00:00	AAPL	Stock	26.0475	26.07	26.0425	26.055	10635824.0
2016-07-29 17:00:00	AAPL	Stock	26.0525	26.06	26.0475	26.06	451184.0
2016-07-29 18:00:00	AAPL	Stock	26.055	26.06	26.0525	26.0575	29208.0
2016-07-29 19:00:00	AAPL	Stock	26.0575	26.075	26.05	26.0625	75200.0
2016-07-29 06:00:00	MSFT	Stock	55.94	56.35	55.94	56.35	1100.0
2016-07-29 07:00:00	MSFT	Stock	56.0	56.01	56.0	56.01	400.0
2016-07-29 08:00:00	MSFT	Stock	56.0	56.0	55.81	55.81	16332.0
2016-07-29 09:00:00	MSFT	Stock	55.86	56.66	55.86	56.5	3572624.0
2016-07-29 10:00:00	MSFT	Stock	56.51	56.67	56.46	56.6	4475484.0
2016-07-29 11:00:00	MSFT	Stock	56.6	56.68	56.485	56.492	2027545.0
2016-07-29 12:00:00	MSFT	Stock	56.495	56.53	56.42	56.495	1891279.0
2016-07-29 13:00:00	MSFT	Stock	56.495	56.525	56.432	56.435	2040262.0
2016-07-29 14:00:00	MSFT	Stock	56.435	56.58	56.431	56.558	2868862.0
2016-07-29 15:00:00	MSFT	Stock	56.55	56.76	56.48	56.69	7640171.0
2016-07-29 16:00:00	MSFT	Stock	56.69	56.7	56.62	56.7	4177170.0
2016-07-29 17:00:00	MSFT	Stock	56.68	56.69	56.68	56.68	71535.0
2016-07-29 18:00:00	MSFT	Stock	56.68	56.7	56.68	56.7	350.0
2016-07-29 19:00:00	MSFT	Stock	56.69	56.69	56.69	56.69	400.0
2016-07-29 06:00:00	NVDA	Stock	1.412	1.412	1.412	1.412	52000.0
2016-07-29 07:00:00	NVDA	Stock	1.418	1.418	1.418	1.418	4000.0
2016-07-29 08:00:00	NVDA	Stock	1.4098	1.415	1.4075	1.41	119440.0
2016-07-29 09:00:00	NVDA	Stock	1.41	1.4148	1.3899	1.392	41086840.0
2016-07-29 10:00:00	NVDA	Stock	1.3918	1.4093	1.3845	1.4085	52208000.0
2016-07-29 11:00:00	NVDA	Stock	1.4082	1.4133	1.4048	1.412	26711400.0
2016-07-29 12:00:00	NVDA	Stock	1.4118	1.4272	1.4108	1.42	103936160.0
2016-07-29 13:00:00	NVDA	Stock	1.4202	1.4288	1.4168	1.4285	44301160.0
2016-07-29 14:00:00	NVDA	Stock	1.4284	1.431	1.4238	1.4273	40593440.0
2016-07-29 15:00:00	NVDA	Stock	1.4273	1.4313	1.4255	1.4275	58363840.0
2016-07-29 16:00:00	NVDA	Stock	1.4275	1.4313	1.4273	1.4313	20090400.0
2016-07-29 17:00:00	NVDA	Stock	1.4275	1.4275	1.4275	1.4275	40000.0
2016-07-29 18:00:00	NVDA	Stock	1.4308	1.4308	1.4308	1.4308	14000.0
2016-07-29 19:00:00	NVDA	Stock	1.4275	1.4275	1.4275	1.4275	38000.0
2016-07-29 04:00:00	AMZN	Stock	38.295	38.295	38.094	38.1	62000.0
2016-07-29 05:00:00	AMZN	Stock	38.125	38.2245	38.065	38.1175	35200.0
2016-07-29 06:00:00	AMZN	Stock	38.22	38.2625	38.2175	38.2555	133000.0
2016-07-29 07:00:00	AMZN	Stock	38.35	38.545	38.2625	38.5	650640.0
2016-07-29 08:00:00	AMZN	Stock	38.5	38.55	38.25	38.3375	2252320.0
2016-07-29 09:00:00	AMZN	Stock	38.348	38.5	37.7575	37.9422	40219080.0

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

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