PREVIEW / stock_1hour / 2015-08-05

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-08-05.parquet
  size:    1.0 MB
  rows:    48,733
  symbols: 3,482

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-08-05 04:00:00	AAPL	Stock	28.625	28.625	28.4675	28.5	89240.0
2015-08-05 05:00:00	AAPL	Stock	28.4975	28.535	28.47	28.535	31908.0
2015-08-05 06:00:00	AAPL	Stock	28.5075	28.5075	28.2	28.275	882116.0
2015-08-05 07:00:00	AAPL	Stock	28.3	29.3775	28.3	28.4625	688840.0
2015-08-05 08:00:00	AAPL	Stock	28.465	28.545	28.3	28.395	2843300.0
2015-08-05 09:00:00	AAPL	Stock	28.405	28.985	28.025	28.98	96810540.0
2015-08-05 10:00:00	AAPL	Stock	28.97	29.2825	28.6325	29.28	81227892.0
2015-08-05 11:00:00	AAPL	Stock	29.28	29.36	29.0625	29.1662	47668896.0
2015-08-05 12:00:00	AAPL	Stock	29.165	29.19	29.035	29.16	30770948.0
2015-08-05 13:00:00	AAPL	Stock	29.1575	29.16	28.655	28.7425	42378556.0
2015-08-05 14:00:00	AAPL	Stock	28.7438	28.9475	28.68	28.9325	29584776.0
2015-08-05 15:00:00	AAPL	Stock	28.935	28.96	28.83	28.8475	32844492.0
2015-08-05 16:00:00	AAPL	Stock	28.85	29.138	28.5125	28.825	7179848.0
2015-08-05 17:00:00	AAPL	Stock	28.8425	28.8425	28.7775	28.8125	105444.0
2015-08-05 18:00:00	AAPL	Stock	28.8025	28.875	28.8025	28.8575	91668.0
2015-08-05 19:00:00	AAPL	Stock	28.85	28.925	28.85	28.925	114380.0
2015-08-05 04:00:00	MSFT	Stock	47.54	47.54	47.54	47.54	532.0
2015-08-05 06:00:00	MSFT	Stock	47.69	47.69	47.69	47.69	100.0
2015-08-05 07:00:00	MSFT	Stock	47.74	48.05	47.74	47.9	4763.0
2015-08-05 08:00:00	MSFT	Stock	47.9	47.97	47.87	47.88	45007.0
2015-08-05 09:00:00	MSFT	Stock	47.84	48.41	47.82	48.02	4186659.0
2015-08-05 10:00:00	MSFT	Stock	48.01	48.2	47.65	47.68	4600287.0
2015-08-05 11:00:00	MSFT	Stock	47.67	48.0	47.64	47.92	2465373.0
2015-08-05 12:00:00	MSFT	Stock	47.921	48.08	47.76	47.91	2239649.0
2015-08-05 13:00:00	MSFT	Stock	47.92	47.95	47.7	47.86	1872445.0
2015-08-05 14:00:00	MSFT	Stock	47.85	47.93	47.73	47.75	1978787.0
2015-08-05 15:00:00	MSFT	Stock	47.75	47.84	47.54	47.59	5385791.0
2015-08-05 16:00:00	MSFT	Stock	47.58	47.913	47.5	47.5	2818334.0
2015-08-05 17:00:00	MSFT	Stock	47.57	47.75	47.57	47.67	3769.0
2015-08-05 18:00:00	MSFT	Stock	47.67	47.67	47.67	47.67	100.0
2015-08-05 08:00:00	NVDA	Stock	0.5122	0.5122	0.5122	0.5122	20000.0
2015-08-05 09:00:00	NVDA	Stock	0.5128	0.5222	0.5128	0.518	45228520.0
2015-08-05 10:00:00	NVDA	Stock	0.518	0.5202	0.5165	0.5168	33600720.0
2015-08-05 11:00:00	NVDA	Stock	0.5165	0.5195	0.516	0.5168	20016080.0
2015-08-05 12:00:00	NVDA	Stock	0.5165	0.5168	0.5135	0.516	20021760.0
2015-08-05 13:00:00	NVDA	Stock	0.516	0.518	0.5134	0.5161	23070040.0
2015-08-05 14:00:00	NVDA	Stock	0.516	0.517	0.5142	0.5148	27388040.0
2015-08-05 15:00:00	NVDA	Stock	0.5148	0.516	0.514	0.5145	48116520.0
2015-08-05 16:00:00	NVDA	Stock	0.5145	0.5145	0.5145	0.5145	1519560.0
2015-08-05 17:00:00	NVDA	Stock	0.5155	0.5162	0.5155	0.5162	40000.0
2015-08-05 18:00:00	NVDA	Stock	0.5162	0.5162	0.5162	0.5162	20000.0
2015-08-05 08:00:00	AMZN	Stock	26.653	26.875	26.653	26.875	307200.0
2015-08-05 09:00:00	AMZN	Stock	26.829	26.95	26.706	26.848	8397100.0
2015-08-05 10:00:00	AMZN	Stock	26.849	26.937	26.7926	26.8642	8600100.0
2015-08-05 11:00:00	AMZN	Stock	26.8725	26.957	26.8185	26.884	6917720.0
2015-08-05 12:00:00	AMZN	Stock	26.8695	26.904	26.79	26.8635	8006620.0
2015-08-05 13:00:00	AMZN	Stock	26.858	26.91	26.813	26.8499	4281700.0
2015-08-05 14:00:00	AMZN	Stock	26.847	26.944	26.83	26.87	5231140.0
2015-08-05 15:00:00	AMZN	Stock	26.87	26.9175	26.8	26.8505	10632000.0
2015-08-05 16:00:00	AMZN	Stock	26.8505	26.8505	26.8395	26.8395	1488780.0

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

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