PREVIEW / stock_1hour / 2015-09-15

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-09-15.parquet
  size:    1.0 MB
  rows:    48,055
  symbols: 3,461

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-15 04:00:00	AAPL	Stock	29.0	29.0	28.8125	28.875	42384.0
2015-09-15 05:00:00	AAPL	Stock	28.87	28.875	28.8125	28.825	9260.0
2015-09-15 06:00:00	AAPL	Stock	28.8225	28.94	28.8075	28.9	89548.0
2015-09-15 07:00:00	AAPL	Stock	28.915	28.935	28.8425	28.9025	200192.0
2015-09-15 08:00:00	AAPL	Stock	28.9	28.935	28.8325	28.9125	629112.0
2015-09-15 09:00:00	AAPL	Stock	28.9025	28.9925	28.605	28.72	27857236.0
2015-09-15 10:00:00	AAPL	Stock	28.725	29.0225	28.725	28.9875	31458804.0
2015-09-15 11:00:00	AAPL	Stock	28.985	29.035	28.905	28.9362	16518864.0
2015-09-15 12:00:00	AAPL	Stock	28.935	29.0575	28.91	28.9875	16159824.0
2015-09-15 13:00:00	AAPL	Stock	28.9852	29.09	28.9625	29.025	17205776.0
2015-09-15 14:00:00	AAPL	Stock	29.025	29.1125	28.975	29.0925	17863096.0
2015-09-15 15:00:00	AAPL	Stock	29.09	29.1325	28.965	29.0675	28723232.0
2015-09-15 16:00:00	AAPL	Stock	29.07	29.1225	29.0675	29.09	5340568.0
2015-09-15 17:00:00	AAPL	Stock	29.1	29.1225	29.07	29.1	85092.0
2015-09-15 18:00:00	AAPL	Stock	29.1025	29.11	29.075	29.0875	192836.0
2015-09-15 19:00:00	AAPL	Stock	29.0875	29.1	29.0775	29.0975	157048.0
2015-09-15 06:00:00	MSFT	Stock	43.03	43.03	43.03	43.03	300.0
2015-09-15 07:00:00	MSFT	Stock	43.05	43.05	43.05	43.05	225.0
2015-09-15 08:00:00	MSFT	Stock	43.08	43.11	43.08	43.11	1250.0
2015-09-15 09:00:00	MSFT	Stock	43.14	43.77	43.07	43.74	4100559.0
2015-09-15 10:00:00	MSFT	Stock	43.74	43.975	43.62	43.88	4908860.0
2015-09-15 11:00:00	MSFT	Stock	43.89	44.03	43.75	43.78	3163001.0
2015-09-15 12:00:00	MSFT	Stock	43.78	43.97	43.755	43.755	2092491.0
2015-09-15 13:00:00	MSFT	Stock	43.755	43.98	43.73	43.89	1899916.0
2015-09-15 14:00:00	MSFT	Stock	43.895	44.27	43.89	44.24	3383473.0
2015-09-15 15:00:00	MSFT	Stock	44.24	44.29	43.96	43.98	5514540.0
2015-09-15 16:00:00	MSFT	Stock	43.98	44.05	43.97	43.98	2099379.0
2015-09-15 17:00:00	MSFT	Stock	43.98	44.18	43.98	44.15	86790.0
2015-09-15 18:00:00	MSFT	Stock	44.16	44.16	44.14	44.15	3272.0
2015-09-15 19:00:00	MSFT	Stock	44.16	44.18	44.16	44.18	5795.0
2015-09-15 08:00:00	NVDA	Stock	0.5675	0.5675	0.5675	0.5675	36000.0
2015-09-15 09:00:00	NVDA	Stock	0.57	0.571	0.5658	0.5701	28211080.0
2015-09-15 10:00:00	NVDA	Stock	0.5702	0.5762	0.5682	0.575	47087280.0
2015-09-15 11:00:00	NVDA	Stock	0.575	0.5761	0.5735	0.5752	43795880.0
2015-09-15 12:00:00	NVDA	Stock	0.575	0.5765	0.5712	0.5712	28992720.0
2015-09-15 13:00:00	NVDA	Stock	0.5712	0.5745	0.5704	0.574	14058600.0
2015-09-15 14:00:00	NVDA	Stock	0.5739	0.5758	0.5735	0.5748	29912720.0
2015-09-15 15:00:00	NVDA	Stock	0.5748	0.5758	0.5735	0.5735	55505040.0
2015-09-15 16:00:00	NVDA	Stock	0.5735	0.5752	0.5735	0.5735	37083360.0
2015-09-15 08:00:00	AMZN	Stock	26.059	26.134	26.0535	26.134	69360.0
2015-09-15 09:00:00	AMZN	Stock	26.1495	26.1795	25.86	25.9007	6978660.0
2015-09-15 10:00:00	AMZN	Stock	25.907	26.291	25.8955	26.2015	9914900.0
2015-09-15 11:00:00	AMZN	Stock	26.204	26.2918	26.138	26.273	4722840.0
2015-09-15 12:00:00	AMZN	Stock	26.2725	26.375	26.2625	26.317	5063800.0
2015-09-15 13:00:00	AMZN	Stock	26.324	26.396	26.2135	26.2366	7124280.0
2015-09-15 14:00:00	AMZN	Stock	26.237	26.248	26.1375	26.205	7636960.0
2015-09-15 15:00:00	AMZN	Stock	26.209	26.2975	26.101	26.117	13001380.0
2015-09-15 16:00:00	AMZN	Stock	26.1185	26.16	26.107	26.149	248380.0
2015-09-15 17:00:00	AMZN	Stock	26.1485	26.1495	26.1185	26.1495	282640.0
2015-09-15 19:00:00	AMZN	Stock	26.1375	26.1375	26.1375	26.1375	15000.0

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

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