PREVIEW / stock_1hour / 2015-12-21

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-21.parquet
  size:    1.0 MB
  rows:    49,277
  symbols: 3,418

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
2015-12-21 04:00:00	AAPL	Stock	26.875	26.97	26.7575	26.9	82348.0
2015-12-21 05:00:00	AAPL	Stock	26.9	26.9375	26.9	26.9375	47780.0
2015-12-21 06:00:00	AAPL	Stock	26.9	26.9	26.8425	26.86	57000.0
2015-12-21 07:00:00	AAPL	Stock	26.865	26.89	26.7725	26.8125	173148.0
2015-12-21 08:00:00	AAPL	Stock	26.8025	26.8975	26.75	26.825	881192.0
2015-12-21 09:00:00	AAPL	Stock	26.8225	26.8525	26.54	26.585	25952948.0
2015-12-21 10:00:00	AAPL	Stock	26.585	26.7175	26.3925	26.4825	27802320.0
2015-12-21 11:00:00	AAPL	Stock	26.485	26.6425	26.4038	26.6305	22839344.0
2015-12-21 12:00:00	AAPL	Stock	26.63	26.8125	26.6202	26.76	22434000.0
2015-12-21 13:00:00	AAPL	Stock	26.7575	26.835	26.715	26.77	14284520.0
2015-12-21 14:00:00	AAPL	Stock	26.7675	26.8025	26.565	26.6075	14225480.0
2015-12-21 15:00:00	AAPL	Stock	26.605	26.8375	26.53	26.83	24874708.0
2015-12-21 16:00:00	AAPL	Stock	26.8325	26.87	26.795	26.8475	9095408.0
2015-12-21 17:00:00	AAPL	Stock	26.8475	26.895	26.8475	26.855	129164.0
2015-12-21 18:00:00	AAPL	Stock	26.8875	26.9125	26.8625	26.875	40284.0
2015-12-21 19:00:00	AAPL	Stock	26.89	26.9075	26.8875	26.9075	51008.0
2015-12-21 04:00:00	MSFT	Stock	54.83	54.83	54.82	54.83	9638.0
2015-12-21 05:00:00	MSFT	Stock	54.84	54.85	54.72	54.72	7724.0
2015-12-21 06:00:00	MSFT	Stock	54.69	54.75	54.6	54.6	16254.0
2015-12-21 07:00:00	MSFT	Stock	54.6	54.6	54.42	54.54	36819.0
2015-12-21 08:00:00	MSFT	Stock	54.64	54.79	54.42	54.79	62962.0
2015-12-21 09:00:00	MSFT	Stock	54.79	55.35	54.71	54.99	5705144.0
2015-12-21 10:00:00	MSFT	Stock	54.995	55.02	54.46	54.55	5311433.0
2015-12-21 11:00:00	MSFT	Stock	54.55	54.65	54.226	54.276	4219336.0
2015-12-21 12:00:00	MSFT	Stock	54.28	54.61	54.27	54.54	3767471.0
2015-12-21 13:00:00	MSFT	Stock	54.55	54.7	54.45	54.68	2149275.0
2015-12-21 14:00:00	MSFT	Stock	54.69	54.77	54.45	54.56	2735139.0
2015-12-21 15:00:00	MSFT	Stock	54.55	54.85	54.4	54.82	7954105.0
2015-12-21 16:00:00	MSFT	Stock	54.83	55.05	54.65	54.93	3215924.0
2015-12-21 17:00:00	MSFT	Stock	54.93	55.06	54.93	55.06	12400.0
2015-12-21 18:00:00	MSFT	Stock	55.0	55.0	55.0	55.0	500.0
2015-12-21 19:00:00	MSFT	Stock	54.95	55.0	54.93	55.0	622.0
2015-12-21 07:00:00	NVDA	Stock	0.8125	0.8125	0.8125	0.8125	8000.0
2015-12-21 09:00:00	NVDA	Stock	0.8072	0.815	0.8035	0.812	22966520.0
2015-12-21 10:00:00	NVDA	Stock	0.812	0.8128	0.8078	0.808	36143400.0
2015-12-21 11:00:00	NVDA	Stock	0.808	0.8092	0.805	0.8062	19891600.0
2015-12-21 12:00:00	NVDA	Stock	0.8065	0.8098	0.8055	0.8095	12421400.0
2015-12-21 13:00:00	NVDA	Stock	0.8094	0.8151	0.807	0.815	43954080.0
2015-12-21 14:00:00	NVDA	Stock	0.8148	0.8169	0.8128	0.815	18032120.0
2015-12-21 15:00:00	NVDA	Stock	0.815	0.8232	0.8128	0.8224	75580680.0
2015-12-21 16:00:00	NVDA	Stock	0.8224	0.8232	0.8224	0.8224	35993400.0
2015-12-21 17:00:00	NVDA	Stock	0.823	0.823	0.823	0.823	4000.0
2015-12-21 04:00:00	AMZN	Stock	33.552	33.552	33.552	33.552	2000.0
2015-12-21 05:00:00	AMZN	Stock	33.55	33.5995	33.55	33.55	10100.0
2015-12-21 06:00:00	AMZN	Stock	33.4655	33.4655	33.4655	33.4655	4000.0
2015-12-21 07:00:00	AMZN	Stock	33.4505	33.4505	33.35	33.35	67220.0
2015-12-21 08:00:00	AMZN	Stock	33.4	33.4	33.265	33.362	493560.0
2015-12-21 09:00:00	AMZN	Stock	33.358	33.44	33.2258	33.25	8661340.0
2015-12-21 10:00:00	AMZN	Stock	33.2665	33.495	33.2145	33.3514	9409120.0
2015-12-21 11:00:00	AMZN	Stock	33.3325	33.3535	33.075	33.1855	9156560.0

> showing 50 of 49,277 rows — these rows as CSV

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