PREVIEW / stock_1hour / 2015-09-24

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-09-24.parquet
  size:    1.0 MB
  rows:    48,456
  symbols: 3,435

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-09-24 04:00:00	AAPL	Stock	28.5075	28.6225	28.4525	28.5825	40264.0
2015-09-24 05:00:00	AAPL	Stock	28.66	28.66	28.5	28.5	16248.0
2015-09-24 06:00:00	AAPL	Stock	28.5	28.5	28.34	28.3675	16908.0
2015-09-24 07:00:00	AAPL	Stock	28.3825	28.3825	28.21	28.28	198064.0
2015-09-24 08:00:00	AAPL	Stock	28.2975	28.47	28.21	28.37	861604.0
2015-09-24 09:00:00	AAPL	Stock	28.3625	28.415	28.18	28.2575	23723596.0
2015-09-24 10:00:00	AAPL	Stock	28.2575	28.34	28.095	28.1325	28582640.0
2015-09-24 11:00:00	AAPL	Stock	28.135	28.31	28.0925	28.2998	20147288.0
2015-09-24 12:00:00	AAPL	Stock	28.2988	28.445	28.2675	28.35	16231368.0
2015-09-24 13:00:00	AAPL	Stock	28.3475	28.4825	28.29	28.425	18342424.0
2015-09-24 14:00:00	AAPL	Stock	28.4252	28.875	28.3925	28.8175	28435612.0
2015-09-24 15:00:00	AAPL	Stock	28.8175	28.83	28.63	28.75	33715444.0
2015-09-24 16:00:00	AAPL	Stock	28.75	28.7975	28.3212	28.7625	17265180.0
2015-09-24 17:00:00	AAPL	Stock	28.755	28.7625	28.6775	28.6875	106044.0
2015-09-24 18:00:00	AAPL	Stock	28.6875	28.8	28.6875	28.8	150020.0
2015-09-24 19:00:00	AAPL	Stock	28.795	28.87	28.775	28.86	253392.0
2015-09-24 06:00:00	MSFT	Stock	43.9	43.9	43.58	43.58	3952.0
2015-09-24 07:00:00	MSFT	Stock	43.5	43.5	43.5	43.5	100.0
2015-09-24 08:00:00	MSFT	Stock	43.45	43.45	43.33	43.4	15725.0
2015-09-24 09:00:00	MSFT	Stock	43.47	43.72	43.3	43.38	3001853.0
2015-09-24 10:00:00	MSFT	Stock	43.38	43.59	43.27	43.41	3494707.0
2015-09-24 11:00:00	MSFT	Stock	43.415	43.605	43.32	43.546	2342053.0
2015-09-24 12:00:00	MSFT	Stock	43.54	43.78	43.52	43.55	1823482.0
2015-09-24 13:00:00	MSFT	Stock	43.544	43.78	43.5	43.68	2066153.0
2015-09-24 14:00:00	MSFT	Stock	43.685	44.13	43.63	44.001	3722453.0
2015-09-24 15:00:00	MSFT	Stock	44.01	44.11	43.78	43.91	5747528.0
2015-09-24 16:00:00	MSFT	Stock	43.91	44.01	43.26	43.95	4398051.0
2015-09-24 17:00:00	MSFT	Stock	43.85	43.85	43.85	43.85	300.0
2015-09-24 18:00:00	MSFT	Stock	43.85	43.85	43.85	43.85	200.0
2015-09-24 09:00:00	NVDA	Stock	0.5678	0.5745	0.5625	0.5668	34655360.0
2015-09-24 10:00:00	NVDA	Stock	0.5665	0.5681	0.5625	0.566	24259920.0
2015-09-24 11:00:00	NVDA	Stock	0.566	0.5754	0.5655	0.5749	40870560.0
2015-09-24 12:00:00	NVDA	Stock	0.5749	0.5795	0.5742	0.5762	36276160.0
2015-09-24 13:00:00	NVDA	Stock	0.576	0.5822	0.5748	0.5802	37599040.0
2015-09-24 14:00:00	NVDA	Stock	0.5804	0.592	0.58	0.5905	68153240.0
2015-09-24 15:00:00	NVDA	Stock	0.5905	0.5908	0.5843	0.586	118603240.0
2015-09-24 16:00:00	NVDA	Stock	0.586	0.586	0.577	0.5855	4676400.0
2015-09-24 19:00:00	NVDA	Stock	0.5868	0.5868	0.5868	0.5868	16000.0
2015-09-24 04:00:00	AMZN	Stock	26.8045	26.8045	26.8045	26.8045	4040.0
2015-09-24 06:00:00	AMZN	Stock	26.7	26.7	26.5215	26.5215	29400.0
2015-09-24 07:00:00	AMZN	Stock	26.55	26.585	26.5	26.55	128140.0
2015-09-24 08:00:00	AMZN	Stock	26.5695	26.6375	26.536	26.593	212520.0
2015-09-24 09:00:00	AMZN	Stock	26.595	26.6395	26.39	26.5055	9120740.0
2015-09-24 10:00:00	AMZN	Stock	26.505	26.55	26.267	26.29	9221180.0
2015-09-24 11:00:00	AMZN	Stock	26.2855	26.4225	26.1435	26.377	11240440.0
2015-09-24 12:00:00	AMZN	Stock	26.384	26.47	26.312	26.385	5610320.0
2015-09-24 13:00:00	AMZN	Stock	26.389	26.435	26.3275	26.381	5519380.0
2015-09-24 14:00:00	AMZN	Stock	26.3685	26.728	26.36	26.6805	9379840.0
2015-09-24 15:00:00	AMZN	Stock	26.6815	26.724	26.5665	26.687	11854480.0
2015-09-24 16:00:00	AMZN	Stock	26.6875	26.722	26.347	26.67	4951640.0

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

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