PREVIEW / stock_1hour / 2015-11-06

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-11-06.parquet
  size:    1.0 MB
  rows:    48,780
  symbols: 3,419

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-11-06 04:00:00	AAPL	Stock	30.315	30.315	30.25	30.275	16840.0
2015-11-06 05:00:00	AAPL	Stock	30.2725	30.275	30.2725	30.275	3236.0
2015-11-06 06:00:00	AAPL	Stock	30.275	30.3325	30.275	30.3175	33120.0
2015-11-06 07:00:00	AAPL	Stock	30.3175	30.35	30.2975	30.315	45200.0
2015-11-06 08:00:00	AAPL	Stock	30.2975	30.4	30.175	30.3075	1203616.0
2015-11-06 09:00:00	AAPL	Stock	30.3075	30.4525	30.22	30.2525	21392084.0
2015-11-06 10:00:00	AAPL	Stock	30.25	30.4375	30.155	30.369	24747276.0
2015-11-06 11:00:00	AAPL	Stock	30.3725	30.435	30.2765	30.3475	14648280.0
2015-11-06 12:00:00	AAPL	Stock	30.3475	30.3925	30.18	30.2425	14820544.0
2015-11-06 13:00:00	AAPL	Stock	30.2425	30.3	30.2125	30.265	10151928.0
2015-11-06 14:00:00	AAPL	Stock	30.2675	30.3325	30.175	30.2248	14253832.0
2015-11-06 15:00:00	AAPL	Stock	30.2225	30.2775	30.1875	30.265	17196776.0
2015-11-06 16:00:00	AAPL	Stock	30.265	30.3075	30.2475	30.251	5640308.0
2015-11-06 17:00:00	AAPL	Stock	30.255	30.2625	30.2325	30.235	69288.0
2015-11-06 18:00:00	AAPL	Stock	30.24	30.2575	30.2325	30.2575	41068.0
2015-11-06 19:00:00	AAPL	Stock	30.25	30.265	30.24	30.265	51812.0
2015-11-06 07:00:00	MSFT	Stock	54.34	54.34	54.3	54.3	300.0
2015-11-06 08:00:00	MSFT	Stock	54.35	54.42	54.05	54.06	33772.0
2015-11-06 09:00:00	MSFT	Stock	54.07	54.33	53.85	54.27	3309229.0
2015-11-06 10:00:00	MSFT	Stock	54.26	54.86	54.03	54.48	5320581.0
2015-11-06 11:00:00	MSFT	Stock	54.48	54.59	54.26	54.5	3508979.0
2015-11-06 12:00:00	MSFT	Stock	54.5	54.75	54.35	54.75	4168350.0
2015-11-06 13:00:00	MSFT	Stock	54.75	54.94	54.595	54.87	2939285.0
2015-11-06 14:00:00	MSFT	Stock	54.87	54.98	54.564	54.74	3045579.0
2015-11-06 15:00:00	MSFT	Stock	54.744	54.93	54.521	54.91	4635301.0
2015-11-06 16:00:00	MSFT	Stock	54.92	54.93	54.581	54.9	2547976.0
2015-11-06 17:00:00	MSFT	Stock	54.9	54.93	54.9	54.92	2319.0
2015-11-06 18:00:00	MSFT	Stock	54.9	54.9	54.89	54.89	2000.0
2015-11-06 19:00:00	MSFT	Stock	54.89	54.92	54.89	54.92	1339.0
2015-11-06 04:00:00	NVDA	Stock	0.762	0.762	0.762	0.762	8000.0
2015-11-06 05:00:00	NVDA	Stock	0.762	0.765	0.762	0.765	52000.0
2015-11-06 06:00:00	NVDA	Stock	0.7725	0.7725	0.7525	0.7525	124000.0
2015-11-06 07:00:00	NVDA	Stock	0.7593	0.7638	0.7575	0.7638	343880.0
2015-11-06 08:00:00	NVDA	Stock	0.76	0.765	0.745	0.745	15912760.0
2015-11-06 09:00:00	NVDA	Stock	0.7475	0.785	0.7455	0.7815	297231240.0
2015-11-06 10:00:00	NVDA	Stock	0.7815	0.7985	0.7753	0.7925	275647440.0
2015-11-06 11:00:00	NVDA	Stock	0.7925	0.7975	0.7838	0.785	109773680.0
2015-11-06 12:00:00	NVDA	Stock	0.785	0.7978	0.7828	0.795	94540120.0
2015-11-06 13:00:00	NVDA	Stock	0.795	0.7952	0.7869	0.7876	81416960.0
2015-11-06 14:00:00	NVDA	Stock	0.7876	0.791	0.7838	0.7872	87981080.0
2015-11-06 15:00:00	NVDA	Stock	0.7871	0.7923	0.7855	0.7885	188978840.0
2015-11-06 16:00:00	NVDA	Stock	0.7888	0.7902	0.7864	0.79	7145160.0
2015-11-06 17:00:00	NVDA	Stock	0.79	0.79	0.7898	0.7898	31120.0
2015-11-06 18:00:00	NVDA	Stock	0.7892	0.79	0.7892	0.79	61280.0
2015-11-06 19:00:00	NVDA	Stock	0.79	0.79	0.7888	0.7888	60000.0
2015-11-06 04:00:00	AMZN	Stock	32.7465	32.7465	32.7465	32.7465	2080.0
2015-11-06 07:00:00	AMZN	Stock	32.8	32.83	32.75	32.825	33760.0
2015-11-06 08:00:00	AMZN	Stock	32.83	32.9	32.7015	32.755	795980.0
2015-11-06 09:00:00	AMZN	Stock	32.7505	33.045	32.6735	32.799	16985920.0
2015-11-06 10:00:00	AMZN	Stock	32.775	33.113	32.6	32.9858	14052920.0

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

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