PREVIEW / stock_1hour / 2015-10-08

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-08.parquet
  size:    1.0 MB
  rows:    47,798
  symbols: 3,423

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-10-08 04:00:00	AAPL	Stock	27.5275	27.5625	27.5125	27.56	36336.0
2015-10-08 05:00:00	AAPL	Stock	27.55	27.58	27.55	27.58	4452.0
2015-10-08 06:00:00	AAPL	Stock	27.6125	27.6125	27.575	27.575	15396.0
2015-10-08 07:00:00	AAPL	Stock	27.6075	27.6725	27.6	27.65	53080.0
2015-10-08 08:00:00	AAPL	Stock	27.635	27.67	27.5775	27.5975	243288.0
2015-10-08 09:00:00	AAPL	Stock	27.5825	27.5975	27.23	27.2525	36249560.0
2015-10-08 10:00:00	AAPL	Stock	27.25	27.295	27.1125	27.245	42503048.0
2015-10-08 11:00:00	AAPL	Stock	27.245	27.275	27.1125	27.23	24939944.0
2015-10-08 12:00:00	AAPL	Stock	27.23	27.2575	27.0525	27.1175	23368260.0
2015-10-08 13:00:00	AAPL	Stock	27.116	27.22	27.105	27.194	15063268.0
2015-10-08 14:00:00	AAPL	Stock	27.1928	27.415	27.135	27.3875	35677816.0
2015-10-08 15:00:00	AAPL	Stock	27.3875	27.535	27.295	27.375	42666112.0
2015-10-08 16:00:00	AAPL	Stock	27.375	27.375	27.262	27.36	10027268.0
2015-10-08 17:00:00	AAPL	Stock	27.3575	27.375	27.3575	27.3625	54644.0
2015-10-08 18:00:00	AAPL	Stock	27.3725	27.3725	27.3525	27.3625	27212.0
2015-10-08 19:00:00	AAPL	Stock	27.3625	27.3625	27.35	27.3625	49432.0
2015-10-08 04:00:00	MSFT	Stock	46.57	46.57	46.55	46.55	300.0
2015-10-08 05:00:00	MSFT	Stock	46.5	46.65	46.5	46.65	20197.0
2015-10-08 06:00:00	MSFT	Stock	46.76	46.76	46.76	46.76	300.0
2015-10-08 08:00:00	MSFT	Stock	46.65	46.65	46.54	46.54	2350.0
2015-10-08 09:00:00	MSFT	Stock	46.67	47.01	46.55	46.98	3606276.0
2015-10-08 10:00:00	MSFT	Stock	46.98	46.988	46.64	46.7	3460202.0
2015-10-08 11:00:00	MSFT	Stock	46.7	46.95	46.5	46.93	3036421.0
2015-10-08 12:00:00	MSFT	Stock	46.935	47.0	46.8	46.89	3043707.0
2015-10-08 13:00:00	MSFT	Stock	46.89	47.0	46.82	46.94	1886885.0
2015-10-08 14:00:00	MSFT	Stock	46.94	47.25	46.83	47.2	5953067.0
2015-10-08 15:00:00	MSFT	Stock	47.2	47.515	47.19	47.45	7981683.0
2015-10-08 16:00:00	MSFT	Stock	47.45	47.5	47.35	47.45	3051903.0
2015-10-08 17:00:00	MSFT	Stock	47.45	47.45	47.37	47.37	788.0
2015-10-08 18:00:00	MSFT	Stock	47.37	47.4	47.37	47.4	1488.0
2015-10-08 19:00:00	MSFT	Stock	47.4	47.45	47.4	47.45	500.0
2015-10-08 08:00:00	NVDA	Stock	0.6412	0.6412	0.6412	0.6412	17960.0
2015-10-08 09:00:00	NVDA	Stock	0.6478	0.65	0.6368	0.6459	44908360.0
2015-10-08 10:00:00	NVDA	Stock	0.6458	0.6494	0.6428	0.6436	48314560.0
2015-10-08 11:00:00	NVDA	Stock	0.6436	0.6448	0.637	0.6415	63455680.0
2015-10-08 12:00:00	NVDA	Stock	0.6415	0.6439	0.637	0.6429	89385480.0
2015-10-08 13:00:00	NVDA	Stock	0.643	0.6488	0.6412	0.6468	39993720.0
2015-10-08 14:00:00	NVDA	Stock	0.6468	0.6534	0.6465	0.6515	45315840.0
2015-10-08 15:00:00	NVDA	Stock	0.6513	0.656	0.6513	0.6545	77892920.0
2015-10-08 16:00:00	NVDA	Stock	0.6543	0.6543	0.647	0.647	14438080.0
2015-10-08 17:00:00	NVDA	Stock	0.6532	0.6532	0.6532	0.6532	20000.0
2015-10-08 19:00:00	NVDA	Stock	0.6543	0.6543	0.6543	0.6543	39000.0
2015-10-08 04:00:00	AMZN	Stock	26.88	26.88	26.88	26.88	2000.0
2015-10-08 06:00:00	AMZN	Stock	27.0295	27.0295	27.0295	27.0295	4000.0
2015-10-08 07:00:00	AMZN	Stock	27.01	27.0445	27.01	27.0445	30000.0
2015-10-08 08:00:00	AMZN	Stock	27.05	27.05	26.981	27.025	210040.0
2015-10-08 09:00:00	AMZN	Stock	27.016	27.029	26.731	26.834	11180480.0
2015-10-08 10:00:00	AMZN	Stock	26.8225	26.847	26.475	26.526	15650760.0
2015-10-08 11:00:00	AMZN	Stock	26.526	26.5875	26.3916	26.4785	8713820.0
2015-10-08 12:00:00	AMZN	Stock	26.492	26.53	25.9945	26.1485	12093740.0

> showing 50 of 47,798 rows — these rows as CSV

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