PREVIEW / stock_1hour / 2016-07-01

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-07-01.parquet
  size:    1.0 MB
  rows:    47,854
  symbols: 3,251

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-01 04:00:00	AAPL	Stock	23.8475	23.9	23.825	23.845	7600.0
2016-07-01 05:00:00	AAPL	Stock	23.7875	23.7875	23.7875	23.7875	3112.0
2016-07-01 06:00:00	AAPL	Stock	23.7875	23.79	23.7875	23.79	2552.0
2016-07-01 07:00:00	AAPL	Stock	23.8225	23.875	23.8225	23.875	39624.0
2016-07-01 08:00:00	AAPL	Stock	23.79	23.9	23.79	23.89	155404.0
2016-07-01 09:00:00	AAPL	Stock	23.8875	23.97	23.8325	23.9325	12842544.0
2016-07-01 10:00:00	AAPL	Stock	23.935	24.0875	23.93	24.0825	18549976.0
2016-07-01 11:00:00	AAPL	Stock	24.08	24.1162	24.0075	24.061	15394488.0
2016-07-01 12:00:00	AAPL	Stock	24.06	24.0775	24.02	24.035	7887388.0
2016-07-01 13:00:00	AAPL	Stock	24.0338	24.055	23.96	23.975	8281040.0
2016-07-01 14:00:00	AAPL	Stock	23.975	23.995	23.945	23.9762	7528752.0
2016-07-01 15:00:00	AAPL	Stock	23.9762	24.0375	23.9725	23.975	16354676.0
2016-07-01 16:00:00	AAPL	Stock	23.9775	23.9975	23.9625	23.9925	6496620.0
2016-07-01 17:00:00	AAPL	Stock	23.985	23.9975	23.975	23.9875	57476.0
2016-07-01 18:00:00	AAPL	Stock	23.9825	23.9875	23.97	23.9875	152660.0
2016-07-01 19:00:00	AAPL	Stock	23.9875	23.995	23.975	23.99	14648.0
2016-07-01 04:00:00	MSFT	Stock	51.19	51.19	51.19	51.19	1100.0
2016-07-01 07:00:00	MSFT	Stock	51.16	51.21	51.16	51.21	2500.0
2016-07-01 08:00:00	MSFT	Stock	51.21	51.22	51.21	51.21	1300.0
2016-07-01 09:00:00	MSFT	Stock	51.2	51.57	51.07	51.49	2346841.0
2016-07-01 10:00:00	MSFT	Stock	51.5	51.72	51.445	51.625	2935480.0
2016-07-01 11:00:00	MSFT	Stock	51.62	51.7	51.48	51.55	2734518.0
2016-07-01 12:00:00	MSFT	Stock	51.55	51.57	51.41	51.435	1696431.0
2016-07-01 13:00:00	MSFT	Stock	51.435	51.46	51.2	51.225	2119486.0
2016-07-01 14:00:00	MSFT	Stock	51.23	51.315	51.1	51.21	1922943.0
2016-07-01 15:00:00	MSFT	Stock	51.215	51.34	51.16	51.16	4216307.0
2016-07-01 16:00:00	MSFT	Stock	51.16	51.436	51.13	51.24	1980288.0
2016-07-01 17:00:00	MSFT	Stock	51.16	51.16	51.16	51.16	144.0
2016-07-01 18:00:00	MSFT	Stock	51.16	51.16	51.16	51.16	244.0
2016-07-01 19:00:00	MSFT	Stock	51.16	51.16	51.16	51.16	360.0
2016-07-01 08:00:00	NVDA	Stock	1.1748	1.1748	1.1748	1.1748	9240.0
2016-07-01 09:00:00	NVDA	Stock	1.1752	1.184	1.1645	1.1825	29202960.0
2016-07-01 10:00:00	NVDA	Stock	1.1825	1.184	1.1662	1.1698	36552280.0
2016-07-01 11:00:00	NVDA	Stock	1.1695	1.1708	1.1642	1.1675	27518000.0
2016-07-01 12:00:00	NVDA	Stock	1.1675	1.1708	1.1666	1.1682	19385440.0
2016-07-01 13:00:00	NVDA	Stock	1.168	1.1708	1.1638	1.1658	22538720.0
2016-07-01 14:00:00	NVDA	Stock	1.1658	1.1668	1.1625	1.1662	23137600.0
2016-07-01 15:00:00	NVDA	Stock	1.1662	1.168	1.163	1.166	37267200.0
2016-07-01 16:00:00	NVDA	Stock	1.1665	1.169	1.1665	1.167	13136200.0
2016-07-01 17:00:00	NVDA	Stock	1.1665	1.1665	1.1665	1.1665	8000.0
2016-07-01 18:00:00	NVDA	Stock	1.1665	1.1665	1.1665	1.1665	4000.0
2016-07-01 04:00:00	AMZN	Stock	35.726	35.726	35.726	35.726	4540.0
2016-07-01 07:00:00	AMZN	Stock	35.775	35.86	35.775	35.86	15940.0
2016-07-01 08:00:00	AMZN	Stock	35.823	35.881	35.823	35.8305	373780.0
2016-07-01 09:00:00	AMZN	Stock	35.8255	36.175	35.7775	36.175	9225660.0
2016-07-01 10:00:00	AMZN	Stock	36.175	36.4	36.1725	36.335	9108400.0
2016-07-01 11:00:00	AMZN	Stock	36.33	36.3385	36.2075	36.2725	5893820.0
2016-07-01 12:00:00	AMZN	Stock	36.2845	36.305	36.185	36.2715	4586340.0
2016-07-01 13:00:00	AMZN	Stock	36.2675	36.303	36.2355	36.2395	4318920.0
2016-07-01 14:00:00	AMZN	Stock	36.255	36.2605	36.156	36.255	4043140.0

> showing 50 of 47,854 rows — these rows as CSV

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