PREVIEW / stock_1hour / 2015-08-19

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-08-19.parquet
  size:    1.0 MB
  rows:    48,140
  symbols: 3,451

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-19 04:00:00	AAPL	Stock	29.1225	29.1225	29.0	29.0375	33128.0
2015-08-19 05:00:00	AAPL	Stock	29.0375	29.07	29.0375	29.07	7496.0
2015-08-19 06:00:00	AAPL	Stock	29.095	29.125	29.05	29.05	21420.0
2015-08-19 07:00:00	AAPL	Stock	29.06	29.14	29.06	29.125	94692.0
2015-08-19 08:00:00	AAPL	Stock	29.125	29.1425	29.065	29.08	252548.0
2015-08-19 09:00:00	AAPL	Stock	29.095	29.13	28.885	28.8962	25333828.0
2015-08-19 10:00:00	AAPL	Stock	28.895	29.0075	28.7725	28.8175	27952512.0
2015-08-19 11:00:00	AAPL	Stock	28.8175	28.8625	28.67	28.737	25781072.0
2015-08-19 12:00:00	AAPL	Stock	28.7362	28.815	28.68	28.765	15103672.0
2015-08-19 13:00:00	AAPL	Stock	28.765	28.87	28.725	28.8175	18088460.0
2015-08-19 14:00:00	AAPL	Stock	28.82	29.0775	28.7362	28.78	30269248.0
2015-08-19 15:00:00	AAPL	Stock	28.78	28.875	28.7375	28.755	27483260.0
2015-08-19 16:00:00	AAPL	Stock	28.7525	28.7675	28.7125	28.7175	11830136.0
2015-08-19 17:00:00	AAPL	Stock	28.725	28.7525	28.715	28.735	613456.0
2015-08-19 18:00:00	AAPL	Stock	28.735	28.7525	28.7325	28.745	70356.0
2015-08-19 19:00:00	AAPL	Stock	28.745	28.75	28.7025	28.7025	133540.0
2015-08-19 08:00:00	MSFT	Stock	47.2	47.2	47.0	47.13	4900.0
2015-08-19 09:00:00	MSFT	Stock	47.05	47.05	46.495	46.565	3554158.0
2015-08-19 10:00:00	MSFT	Stock	46.56	46.86	46.56	46.59	4463161.0
2015-08-19 11:00:00	MSFT	Stock	46.595	46.66	46.3	46.44	3325491.0
2015-08-19 12:00:00	MSFT	Stock	46.43	46.67	46.38	46.555	2702248.0
2015-08-19 13:00:00	MSFT	Stock	46.56	46.725	46.49	46.64	2472090.0
2015-08-19 14:00:00	MSFT	Stock	46.63	47.08	46.565	46.6	5140903.0
2015-08-19 15:00:00	MSFT	Stock	46.6	46.83	46.52	46.625	6180220.0
2015-08-19 16:00:00	MSFT	Stock	46.61	46.71	46.54	46.65	2088941.0
2015-08-19 17:00:00	MSFT	Stock	46.71	46.71	46.603	46.603	20800.0
2015-08-19 18:00:00	MSFT	Stock	46.653	46.653	46.62	46.62	3300.0
2015-08-19 09:00:00	NVDA	Stock	0.5762	0.577	0.5708	0.5712	19742480.0
2015-08-19 10:00:00	NVDA	Stock	0.5712	0.5738	0.5685	0.5718	48090120.0
2015-08-19 11:00:00	NVDA	Stock	0.572	0.5725	0.5688	0.5696	33836760.0
2015-08-19 12:00:00	NVDA	Stock	0.5695	0.5732	0.5695	0.5721	22691080.0
2015-08-19 13:00:00	NVDA	Stock	0.5722	0.5782	0.572	0.577	29841200.0
2015-08-19 14:00:00	NVDA	Stock	0.5771	0.5826	0.576	0.5761	22921920.0
2015-08-19 15:00:00	NVDA	Stock	0.576	0.5775	0.5748	0.5748	40735120.0
2015-08-19 16:00:00	NVDA	Stock	0.575	0.575	0.5737	0.5737	10365520.0
2015-08-19 04:00:00	AMZN	Stock	26.7385	26.7385	26.721	26.721	6000.0
2015-08-19 07:00:00	AMZN	Stock	26.7	26.7	26.7	26.7	40000.0
2015-08-19 08:00:00	AMZN	Stock	26.675	26.7	26.672	26.7	15700.0
2015-08-19 09:00:00	AMZN	Stock	26.671	26.75	26.45	26.504	5210340.0
2015-08-19 10:00:00	AMZN	Stock	26.517	26.65	26.4925	26.5765	5261780.0
2015-08-19 11:00:00	AMZN	Stock	26.5698	26.6489	26.45	26.491	3998120.0
2015-08-19 12:00:00	AMZN	Stock	26.4875	26.6975	26.475	26.672	4163800.0
2015-08-19 13:00:00	AMZN	Stock	26.674	26.744	26.6365	26.687	2629780.0
2015-08-19 14:00:00	AMZN	Stock	26.6655	26.8625	26.5715	26.572	6382360.0
2015-08-19 15:00:00	AMZN	Stock	26.5715	26.759	26.54	26.646	12753420.0
2015-08-19 16:00:00	AMZN	Stock	26.646	26.7375	26.6115	26.725	2038280.0
2015-08-19 17:00:00	AMZN	Stock	26.6557	26.7	26.6557	26.6605	76320.0
2015-08-19 19:00:00	AMZN	Stock	26.66	26.66	26.66	26.66	2000.0
2015-08-19 05:00:00	GOOGL	Stock	34.4995	34.5005	34.4995	34.5005	46540.0
2015-08-19 06:00:00	GOOGL	Stock	34.6425	34.6425	34.6425	34.6425	2000.0

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

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