PREVIEW / stock_1hour / 2015-05-07

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-05-07.parquet
  size:    1.0 MB
  rows:    48,981
  symbols: 3,510

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-07 04:00:00	AAPL	Stock	31.995	31.995	30.925	30.9725	56584.0
2015-05-07 05:00:00	AAPL	Stock	30.9575	30.9725	30.815	30.875	55460.0
2015-05-07 06:00:00	AAPL	Stock	31.0	31.045	30.85	30.915	118608.0
2015-05-07 07:00:00	AAPL	Stock	30.935	31.1475	30.91	31.1475	301012.0
2015-05-07 08:00:00	AAPL	Stock	31.1475	31.225	30.91	31.1275	824828.0
2015-05-07 09:00:00	AAPL	Stock	31.1225	31.36	31.005	31.1675	28740920.0
2015-05-07 10:00:00	AAPL	Stock	31.165	31.4	31.0875	31.295	32193848.0
2015-05-07 11:00:00	AAPL	Stock	31.295	31.3575	31.23	31.295	16616052.0
2015-05-07 12:00:00	AAPL	Stock	31.29	31.52	31.268	31.4775	17563276.0
2015-05-07 13:00:00	AAPL	Stock	31.4825	31.515	31.3175	31.3302	17756440.0
2015-05-07 14:00:00	AAPL	Stock	31.3325	31.4825	31.3325	31.4475	13260972.0
2015-05-07 15:00:00	AAPL	Stock	31.445	31.465	31.285	31.3125	23392716.0
2015-05-07 16:00:00	AAPL	Stock	31.315	31.344	31.3	31.31	6253880.0
2015-05-07 17:00:00	AAPL	Stock	31.3075	31.3275	31.3	31.3175	110232.0
2015-05-07 18:00:00	AAPL	Stock	31.32	31.335	31.3175	31.33	89624.0
2015-05-07 19:00:00	AAPL	Stock	31.33	31.355	31.325	31.335	83572.0
2015-05-07 04:00:00	MSFT	Stock	46.13	46.13	46.13	46.13	100.0
2015-05-07 05:00:00	MSFT	Stock	46.0	46.0	45.69	45.86	5289.0
2015-05-07 06:00:00	MSFT	Stock	45.89	46.11	45.89	45.98	5477.0
2015-05-07 07:00:00	MSFT	Stock	46.0	46.14	45.98	46.14	4500.0
2015-05-07 08:00:00	MSFT	Stock	46.1	46.28	46.0	46.03	9395.0
2015-05-07 09:00:00	MSFT	Stock	46.07	46.85	46.07	46.67	4248788.0
2015-05-07 10:00:00	MSFT	Stock	46.66	46.94	46.625	46.83	4874944.0
2015-05-07 11:00:00	MSFT	Stock	46.84	46.94	46.7	46.81	2687180.0
2015-05-07 12:00:00	MSFT	Stock	46.81	47.085	46.78	46.94	2750868.0
2015-05-07 13:00:00	MSFT	Stock	46.94	46.97	46.745	46.785	3178513.0
2015-05-07 14:00:00	MSFT	Stock	46.79	47.0	46.79	46.975	2867384.0
2015-05-07 15:00:00	MSFT	Stock	46.97	46.99	46.67	46.7	6468650.0
2015-05-07 16:00:00	MSFT	Stock	46.7	46.839	46.68	46.68	1935163.0
2015-05-07 17:00:00	MSFT	Stock	46.71	46.71	46.7	46.7	1411.0
2015-05-07 18:00:00	MSFT	Stock	46.7	46.7	46.66	46.66	1400.0
2015-05-07 08:00:00	NVDA	Stock	0.5538	0.5565	0.5538	0.5565	11600.0
2015-05-07 09:00:00	NVDA	Stock	0.5498	0.5575	0.5485	0.5522	30150000.0
2015-05-07 10:00:00	NVDA	Stock	0.5525	0.5578	0.552	0.5545	75556400.0
2015-05-07 11:00:00	NVDA	Stock	0.5545	0.5561	0.5525	0.555	52375240.0
2015-05-07 12:00:00	NVDA	Stock	0.5549	0.5602	0.5532	0.56	71599160.0
2015-05-07 13:00:00	NVDA	Stock	0.5598	0.5608	0.5575	0.5582	39524240.0
2015-05-07 14:00:00	NVDA	Stock	0.5582	0.5618	0.5582	0.56	55551920.0
2015-05-07 15:00:00	NVDA	Stock	0.56	0.564	0.5595	0.5625	148105520.0
2015-05-07 16:00:00	NVDA	Stock	0.5622	0.5688	0.525	0.5575	30705120.0
2015-05-07 17:00:00	NVDA	Stock	0.555	0.5575	0.55	0.555	7272000.0
2015-05-07 18:00:00	NVDA	Stock	0.555	0.5575	0.5542	0.5542	343320.0
2015-05-07 19:00:00	NVDA	Stock	0.5542	0.5542	0.5512	0.5512	244000.0
2015-05-07 07:00:00	AMZN	Stock	20.842	21.1805	20.842	21.172	236720.0
2015-05-07 08:00:00	AMZN	Stock	21.19	21.275	21.132	21.192	281540.0
2015-05-07 09:00:00	AMZN	Stock	21.1575	21.411	21.1575	21.264	11297600.0
2015-05-07 10:00:00	AMZN	Stock	21.252	21.3255	21.1425	21.2685	6867060.0
2015-05-07 11:00:00	AMZN	Stock	21.269	21.368	21.241	21.2945	6592500.0
2015-05-07 12:00:00	AMZN	Stock	21.2995	21.375	21.2815	21.3705	4768100.0
2015-05-07 13:00:00	AMZN	Stock	21.374	21.4	21.3136	21.3345	4048560.0

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

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