PREVIEW / stock_1hour / 2016-08-25

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-25.parquet
  size:    1.0 MB
  rows:    47,977
  symbols: 3,252

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-08-25 04:00:00	AAPL	Stock	27.01	27.01	26.9375	26.9375	5204.0
2016-08-25 05:00:00	AAPL	Stock	26.9575	26.9575	26.9275	26.9275	5168.0
2016-08-25 06:00:00	AAPL	Stock	26.94	26.9425	26.94	26.9425	1800.0
2016-08-25 07:00:00	AAPL	Stock	26.9225	26.925	26.8875	26.925	13892.0
2016-08-25 08:00:00	AAPL	Stock	26.94	26.94	26.885	26.89	233584.0
2016-08-25 09:00:00	AAPL	Stock	26.8925	26.9125	26.6925	26.7025	21529480.0
2016-08-25 10:00:00	AAPL	Stock	26.705	26.8062	26.67	26.8	18060348.0
2016-08-25 11:00:00	AAPL	Stock	26.8	26.8975	26.795	26.8425	11635840.0
2016-08-25 12:00:00	AAPL	Stock	26.8438	26.875	26.795	26.8712	6389316.0
2016-08-25 13:00:00	AAPL	Stock	26.8725	27.0075	26.8275	26.87	8556748.0
2016-08-25 14:00:00	AAPL	Stock	26.8685	26.95	26.8275	26.9135	8782460.0
2016-08-25 15:00:00	AAPL	Stock	26.9148	26.97	26.875	26.8975	12293260.0
2016-08-25 16:00:00	AAPL	Stock	26.8975	26.9	26.8312	26.8925	3479484.0
2016-08-25 17:00:00	AAPL	Stock	26.9	26.91	26.88	26.8875	249012.0
2016-08-25 18:00:00	AAPL	Stock	26.8875	26.9125	26.8875	26.89	6432.0
2016-08-25 19:00:00	AAPL	Stock	26.91	26.91	26.875	26.8975	25676.0
2016-08-25 09:00:00	MSFT	Stock	57.97	58.22	57.78	58.18	1959978.0
2016-08-25 10:00:00	MSFT	Stock	58.18	58.2	57.99	58.09	2213271.0
2016-08-25 11:00:00	MSFT	Stock	58.095	58.27	58.095	58.191	1791467.0
2016-08-25 12:00:00	MSFT	Stock	58.2	58.29	58.142	58.245	1103596.0
2016-08-25 13:00:00	MSFT	Stock	58.25	58.27	57.95	58.14	1281905.0
2016-08-25 14:00:00	MSFT	Stock	58.143	58.265	58.09	58.19	2009316.0
2016-08-25 15:00:00	MSFT	Stock	58.19	58.28	58.15	58.19	3995338.0
2016-08-25 16:00:00	MSFT	Stock	58.175	58.2	58.13	58.15	1846353.0
2016-08-25 17:00:00	MSFT	Stock	58.15	58.17	58.15	58.15	8783.0
2016-08-25 18:00:00	MSFT	Stock	58.17	58.17	58.17	58.17	400.0
2016-08-25 04:00:00	NVDA	Stock	1.5512	1.5512	1.5512	1.5512	10000.0
2016-08-25 05:00:00	NVDA	Stock	1.5412	1.5412	1.537	1.537	28840.0
2016-08-25 06:00:00	NVDA	Stock	1.537	1.537	1.537	1.537	4000.0
2016-08-25 07:00:00	NVDA	Stock	1.5378	1.538	1.5375	1.538	41600.0
2016-08-25 08:00:00	NVDA	Stock	1.5458	1.55	1.5438	1.55	161360.0
2016-08-25 09:00:00	NVDA	Stock	1.5488	1.5498	1.519	1.528	75220040.0
2016-08-25 10:00:00	NVDA	Stock	1.5283	1.5363	1.5235	1.5352	71184360.0
2016-08-25 11:00:00	NVDA	Stock	1.5352	1.5463	1.534	1.541	62506320.0
2016-08-25 12:00:00	NVDA	Stock	1.541	1.5425	1.5376	1.5383	32368960.0
2016-08-25 13:00:00	NVDA	Stock	1.5383	1.5443	1.5378	1.5378	27553520.0
2016-08-25 14:00:00	NVDA	Stock	1.538	1.5438	1.5348	1.5392	34533240.0
2016-08-25 15:00:00	NVDA	Stock	1.539	1.5405	1.5364	1.5383	86835680.0
2016-08-25 16:00:00	NVDA	Stock	1.5383	1.5398	1.5383	1.5383	7280000.0
2016-08-25 17:00:00	NVDA	Stock	1.5395	1.54	1.5383	1.54	164400.0
2016-08-25 18:00:00	NVDA	Stock	1.5438	1.5438	1.5435	1.5438	100000.0
2016-08-25 19:00:00	NVDA	Stock	1.5388	1.5455	1.5388	1.5455	88000.0
2016-08-25 05:00:00	AMZN	Stock	37.8685	37.8685	37.8685	37.8685	4000.0
2016-08-25 07:00:00	AMZN	Stock	37.81	37.81	37.81	37.81	2000.0
2016-08-25 08:00:00	AMZN	Stock	37.81	37.835	37.81	37.835	4000.0
2016-08-25 09:00:00	AMZN	Stock	37.793	37.8465	37.7371	37.7615	4462540.0
2016-08-25 10:00:00	AMZN	Stock	37.7805	37.8815	37.742	37.8595	4674160.0
2016-08-25 11:00:00	AMZN	Stock	37.86	37.9475	37.86	37.9075	2877780.0
2016-08-25 12:00:00	AMZN	Stock	37.908	37.966	37.8782	37.92	1565680.0
2016-08-25 13:00:00	AMZN	Stock	37.9125	37.944	37.851	37.9158	2261400.0

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

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