PREVIEW / stock_1hour / 2015-12-30

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-30.parquet
  size:    1.0 MB
  rows:    48,406
  symbols: 3,424

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-12-30 05:00:00	AAPL	Stock	27.1525	27.1525	27.095	27.125	8992.0
2015-12-30 06:00:00	AAPL	Stock	27.175	27.175	27.175	27.175	400.0
2015-12-30 07:00:00	AAPL	Stock	27.15	27.1675	27.1275	27.15	59476.0
2015-12-30 08:00:00	AAPL	Stock	27.14	27.1675	27.0925	27.125	130300.0
2015-12-30 09:00:00	AAPL	Stock	27.125	27.175	26.85	26.8868	14636520.0
2015-12-30 10:00:00	AAPL	Stock	26.8875	26.95	26.795	26.9115	17528872.0
2015-12-30 11:00:00	AAPL	Stock	26.9125	26.985	26.875	26.8875	9383972.0
2015-12-30 12:00:00	AAPL	Stock	26.8868	26.945	26.875	26.925	7203132.0
2015-12-30 13:00:00	AAPL	Stock	26.9238	26.9425	26.875	26.9325	7202972.0
2015-12-30 14:00:00	AAPL	Stock	26.933	26.95	26.8875	26.9225	8347052.0
2015-12-30 15:00:00	AAPL	Stock	26.925	26.975	26.8175	26.83	18349940.0
2015-12-30 16:00:00	AAPL	Stock	26.83	26.95	26.8125	26.8375	4913968.0
2015-12-30 17:00:00	AAPL	Stock	26.8425	26.8525	26.8375	26.8525	23376.0
2015-12-30 18:00:00	AAPL	Stock	26.8425	26.8525	26.8325	26.8525	72920.0
2015-12-30 19:00:00	AAPL	Stock	26.86	26.885	26.8525	26.885	18060.0
2015-12-30 07:00:00	MSFT	Stock	56.46	56.51	56.46	56.51	1095.0
2015-12-30 08:00:00	MSFT	Stock	56.4	56.5	56.4	56.45	2500.0
2015-12-30 09:00:00	MSFT	Stock	56.49	56.6	56.288	56.54	1692333.0
2015-12-30 10:00:00	MSFT	Stock	56.55	56.78	56.5	56.67	2344141.0
2015-12-30 11:00:00	MSFT	Stock	56.67	56.69	56.45	56.46	2146991.0
2015-12-30 12:00:00	MSFT	Stock	56.46	56.67	56.455	56.646	1761429.0
2015-12-30 13:00:00	MSFT	Stock	56.645	56.71	56.555	56.645	1756532.0
2015-12-30 14:00:00	MSFT	Stock	56.64	56.73	56.61	56.65	2003146.0
2015-12-30 15:00:00	MSFT	Stock	56.65	56.72	56.29	56.31	4059755.0
2015-12-30 16:00:00	MSFT	Stock	56.31	56.39	56.31	56.32	3187377.0
2015-12-30 17:00:00	MSFT	Stock	56.36	56.36	56.36	56.36	100.0
2015-12-30 18:00:00	MSFT	Stock	56.36	56.36	56.36	56.36	700.0
2015-12-30 19:00:00	MSFT	Stock	56.47	56.47	56.47	56.47	640.0
2015-12-30 08:00:00	NVDA	Stock	0.844	0.844	0.8375	0.842	1471520.0
2015-12-30 09:00:00	NVDA	Stock	0.847	0.8485	0.8402	0.846	28275760.0
2015-12-30 10:00:00	NVDA	Stock	0.8459	0.847	0.8428	0.8462	26047880.0
2015-12-30 11:00:00	NVDA	Stock	0.8462	0.8465	0.8388	0.8388	23953520.0
2015-12-30 12:00:00	NVDA	Stock	0.839	0.8405	0.8378	0.8405	11854080.0
2015-12-30 13:00:00	NVDA	Stock	0.8405	0.8412	0.8385	0.8394	13035760.0
2015-12-30 14:00:00	NVDA	Stock	0.8395	0.8408	0.8372	0.8378	13306080.0
2015-12-30 15:00:00	NVDA	Stock	0.8376	0.839	0.8345	0.8348	47808440.0
2015-12-30 16:00:00	NVDA	Stock	0.8348	0.8348	0.833	0.833	716160.0
2015-12-30 18:00:00	NVDA	Stock	0.8395	0.8395	0.8332	0.8332	118000.0
2015-12-30 19:00:00	NVDA	Stock	0.8395	0.8395	0.8395	0.8395	4000.0
2015-12-30 04:00:00	AMZN	Stock	34.597	34.597	34.597	34.597	4600.0
2015-12-30 05:00:00	AMZN	Stock	34.5785	34.5785	34.5785	34.5785	2080.0
2015-12-30 08:00:00	AMZN	Stock	34.5845	34.685	34.525	34.549	237820.0
2015-12-30 09:00:00	AMZN	Stock	34.549	34.6495	34.3188	34.361	11085180.0
2015-12-30 10:00:00	AMZN	Stock	34.3715	34.62	34.36	34.5215	8731120.0
2015-12-30 11:00:00	AMZN	Stock	34.5275	34.6	34.475	34.593	5291400.0
2015-12-30 12:00:00	AMZN	Stock	34.6	34.7235	34.5949	34.65	6399120.0
2015-12-30 13:00:00	AMZN	Stock	34.6628	34.7745	34.6305	34.712	4772900.0
2015-12-30 14:00:00	AMZN	Stock	34.7005	34.7495	34.6123	34.6445	8678140.0
2015-12-30 15:00:00	AMZN	Stock	34.6502	34.687	34.4325	34.456	13194300.0
2015-12-30 16:00:00	AMZN	Stock	34.4535	34.5484	34.45	34.468	1573440.0

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

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