PREVIEW / stock_1hour / 2015-05-22

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-05-22.parquet
  size:    1.0 MB
  rows:    48,225
  symbols: 3,493

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-05-22 04:00:00	AAPL	Stock	32.8775	32.9575	32.87	32.9575	21560.0
2015-05-22 05:00:00	AAPL	Stock	32.9	32.955	32.9	32.9375	36600.0
2015-05-22 06:00:00	AAPL	Stock	32.9325	32.9375	32.8975	32.8975	12552.0
2015-05-22 07:00:00	AAPL	Stock	32.9	32.975	32.8975	32.9725	236268.0
2015-05-22 08:00:00	AAPL	Stock	32.97	33.0375	32.9	32.935	940164.0
2015-05-22 09:00:00	AAPL	Stock	32.935	33.1225	32.85	33.09	34105172.0
2015-05-22 10:00:00	AAPL	Stock	33.09	33.225	33.0725	33.1975	34644772.0
2015-05-22 11:00:00	AAPL	Stock	33.1975	33.2175	33.0325	33.1075	21492244.0
2015-05-22 12:00:00	AAPL	Stock	33.11	33.14	33.0885	33.095	10200420.0
2015-05-22 13:00:00	AAPL	Stock	33.0975	33.2425	33.085	33.1975	20701800.0
2015-05-22 14:00:00	AAPL	Stock	33.1952	33.2025	33.1202	33.199	13073520.0
2015-05-22 15:00:00	AAPL	Stock	33.1992	33.2375	33.135	33.1425	27143536.0
2015-05-22 16:00:00	AAPL	Stock	33.135	33.1875	33.116	33.1702	9097436.0
2015-05-22 17:00:00	AAPL	Stock	33.1675	33.195	33.155	33.1875	229216.0
2015-05-22 18:00:00	AAPL	Stock	33.1925	33.2075	33.1875	33.19	154336.0
2015-05-22 19:00:00	AAPL	Stock	33.195	33.2	33.1875	33.1925	95668.0
2015-05-22 06:00:00	MSFT	Stock	47.42	47.42	47.42	47.42	500.0
2015-05-22 07:00:00	MSFT	Stock	47.41	47.44	47.4	47.4	4100.0
2015-05-22 08:00:00	MSFT	Stock	47.42	47.449	47.2	47.35	8520.0
2015-05-22 09:00:00	MSFT	Stock	47.37	47.37	47.11	47.11	2967951.0
2015-05-22 10:00:00	MSFT	Stock	47.12	47.2	47.075	47.16	2132075.0
2015-05-22 11:00:00	MSFT	Stock	47.16	47.16	46.95	46.985	2560259.0
2015-05-22 12:00:00	MSFT	Stock	46.985	47.12	46.97	47.07	1694406.0
2015-05-22 13:00:00	MSFT	Stock	47.065	47.2	47.01	47.08	3391432.0
2015-05-22 14:00:00	MSFT	Stock	47.09	47.09	46.89	46.975	2772891.0
2015-05-22 15:00:00	MSFT	Stock	46.975	47.09	46.82	46.9	5996900.0
2015-05-22 16:00:00	MSFT	Stock	46.9	46.92	46.85	46.9	3163983.0
2015-05-22 17:00:00	MSFT	Stock	46.9	46.92	46.9	46.92	4200.0
2015-05-22 18:00:00	MSFT	Stock	46.9	46.91	46.87	46.87	6858.0
2015-05-22 19:00:00	MSFT	Stock	46.86	46.86	46.849	46.85	1450.0
2015-05-22 09:00:00	NVDA	Stock	0.5235	0.5254	0.5202	0.5247	34728240.0
2015-05-22 10:00:00	NVDA	Stock	0.5247	0.525	0.5225	0.5234	24926080.0
2015-05-22 11:00:00	NVDA	Stock	0.5234	0.5235	0.5215	0.5232	20040960.0
2015-05-22 12:00:00	NVDA	Stock	0.523	0.5238	0.5218	0.522	19243680.0
2015-05-22 13:00:00	NVDA	Stock	0.522	0.5238	0.5213	0.5221	19571040.0
2015-05-22 14:00:00	NVDA	Stock	0.5222	0.5225	0.5205	0.5218	22025840.0
2015-05-22 15:00:00	NVDA	Stock	0.5218	0.5226	0.521	0.5214	52623240.0
2015-05-22 16:00:00	NVDA	Stock	0.5215	0.5215	0.5215	0.5215	12543280.0
2015-05-22 18:00:00	NVDA	Stock	0.5247	0.5247	0.5247	0.5247	20000.0
2015-05-22 05:00:00	AMZN	Stock	21.655	21.655	21.655	21.655	6000.0
2015-05-22 06:00:00	AMZN	Stock	21.655	21.655	21.65	21.65	13440.0
2015-05-22 08:00:00	AMZN	Stock	21.64	21.665	21.5475	21.5745	94400.0
2015-05-22 09:00:00	AMZN	Stock	21.583	21.622	21.516	21.549	5696980.0
2015-05-22 10:00:00	AMZN	Stock	21.5485	21.599	21.47	21.5185	6036540.0
2015-05-22 11:00:00	AMZN	Stock	21.523	21.5494	21.4625	21.4765	4383080.0
2015-05-22 12:00:00	AMZN	Stock	21.4875	21.5	21.4575	21.493	2821280.0
2015-05-22 13:00:00	AMZN	Stock	21.49	21.519	21.48	21.4925	2797300.0
2015-05-22 14:00:00	AMZN	Stock	21.4898	21.4975	21.408	21.446	4906820.0
2015-05-22 15:00:00	AMZN	Stock	21.4385	21.4715	21.3805	21.381	8537780.0
2015-05-22 16:00:00	AMZN	Stock	21.3815	21.3845	21.3795	21.3845	187260.0

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

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