PREVIEW / stock_1hour / 2015-12-09

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-09.parquet
  size:    1.0 MB
  rows:    48,706
  symbols: 3,409

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-09 04:00:00	AAPL	Stock	29.49	29.525	29.465	29.4675	13760.0
2015-12-09 05:00:00	AAPL	Stock	29.45	29.45	29.425	29.425	12880.0
2015-12-09 06:00:00	AAPL	Stock	29.4525	29.475	29.425	29.4275	36580.0
2015-12-09 07:00:00	AAPL	Stock	29.45	29.505	29.4375	29.475	55420.0
2015-12-09 08:00:00	AAPL	Stock	29.485	29.5375	29.4375	29.455	259956.0
2015-12-09 09:00:00	AAPL	Stock	29.455	29.5575	29.24	29.2625	18214836.0
2015-12-09 10:00:00	AAPL	Stock	29.2625	29.38	29.235	29.275	21201820.0
2015-12-09 11:00:00	AAPL	Stock	29.275	29.2925	29.0725	29.125	18697724.0
2015-12-09 12:00:00	AAPL	Stock	29.125	29.1375	28.8475	28.875	24330856.0
2015-12-09 13:00:00	AAPL	Stock	28.8688	28.9575	28.77	28.8762	26381700.0
2015-12-09 14:00:00	AAPL	Stock	28.875	28.92	28.7875	28.79	20470288.0
2015-12-09 15:00:00	AAPL	Stock	28.7875	28.9625	28.775	28.9075	27577956.0
2015-12-09 16:00:00	AAPL	Stock	28.905	28.9075	28.822	28.905	10207220.0
2015-12-09 17:00:00	AAPL	Stock	28.905	28.935	28.9025	28.915	104800.0
2015-12-09 18:00:00	AAPL	Stock	28.92	28.9375	28.9125	28.9125	71356.0
2015-12-09 19:00:00	AAPL	Stock	28.9175	28.95	28.9125	28.95	46236.0
2015-12-09 04:00:00	MSFT	Stock	55.66	55.66	55.52	55.52	300.0
2015-12-09 05:00:00	MSFT	Stock	55.5	55.5	55.45	55.45	417.0
2015-12-09 06:00:00	MSFT	Stock	55.45	55.95	55.45	55.95	682.0
2015-12-09 07:00:00	MSFT	Stock	55.64	55.64	55.63	55.63	400.0
2015-12-09 08:00:00	MSFT	Stock	55.63	55.64	55.56	55.61	10278.0
2015-12-09 09:00:00	MSFT	Stock	55.53	55.74	55.12	55.67	3266929.0
2015-12-09 10:00:00	MSFT	Stock	55.68	55.87	55.575	55.64	4677151.0
2015-12-09 11:00:00	MSFT	Stock	55.65	55.72	55.11	55.31	3796442.0
2015-12-09 12:00:00	MSFT	Stock	55.31	55.44	54.65	54.695	5012276.0
2015-12-09 13:00:00	MSFT	Stock	54.69	54.88	54.56	54.72	4751669.0
2015-12-09 14:00:00	MSFT	Stock	54.72	54.78	54.51	54.58	3678339.0
2015-12-09 15:00:00	MSFT	Stock	54.59	55.13	54.57	54.98	5865205.0
2015-12-09 16:00:00	MSFT	Stock	54.98	55.15	54.97	55.15	2835455.0
2015-12-09 17:00:00	MSFT	Stock	55.15	55.15	55.04	55.14	41291.0
2015-12-09 18:00:00	MSFT	Stock	55.15	55.18	55.13	55.15	1700.0
2015-12-09 19:00:00	MSFT	Stock	55.16	55.27	55.16	55.27	5350.0
2015-12-09 08:00:00	NVDA	Stock	0.8345	0.8345	0.8345	0.8345	36000.0
2015-12-09 09:00:00	NVDA	Stock	0.8363	0.8438	0.8305	0.8314	22999600.0
2015-12-09 10:00:00	NVDA	Stock	0.8318	0.8358	0.829	0.8299	35917160.0
2015-12-09 11:00:00	NVDA	Stock	0.83	0.8302	0.8208	0.821	63322240.0
2015-12-09 12:00:00	NVDA	Stock	0.8208	0.823	0.8092	0.8124	42921440.0
2015-12-09 13:00:00	NVDA	Stock	0.8123	0.8162	0.8108	0.815	41995840.0
2015-12-09 14:00:00	NVDA	Stock	0.815	0.8161	0.8128	0.8138	27644320.0
2015-12-09 15:00:00	NVDA	Stock	0.8138	0.8195	0.8132	0.8178	68271640.0
2015-12-09 16:00:00	NVDA	Stock	0.8178	0.8178	0.8178	0.8178	33928640.0
2015-12-09 04:00:00	AMZN	Stock	33.813	33.813	33.813	33.813	10000.0
2015-12-09 06:00:00	AMZN	Stock	33.775	33.85	33.75	33.825	11420.0
2015-12-09 07:00:00	AMZN	Stock	33.8665	33.8795	33.7845	33.8415	57120.0
2015-12-09 08:00:00	AMZN	Stock	33.8385	34.0	33.77	33.95	177480.0
2015-12-09 09:00:00	AMZN	Stock	33.93	33.95	33.625	33.775	9564040.0
2015-12-09 10:00:00	AMZN	Stock	33.7695	33.8685	33.6895	33.7485	6018200.0
2015-12-09 11:00:00	AMZN	Stock	33.762	33.7642	33.328	33.3382	7786460.0
2015-12-09 12:00:00	AMZN	Stock	33.3347	33.55	33.1	33.1135	16886740.0
2015-12-09 13:00:00	AMZN	Stock	33.1196	33.2165	32.784	33.153	20322840.0

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

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