PREVIEW / stock_1hour / 2016-07-19

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-07-19.parquet
  size:    1.0 MB
  rows:    48,219
  symbols: 3,272

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
2016-07-19 04:00:00	AAPL	Stock	24.8625	24.8625	24.8075	24.8075	13176.0
2016-07-19 05:00:00	AAPL	Stock	24.8	24.8475	24.8	24.8475	1520.0
2016-07-19 06:00:00	AAPL	Stock	24.8475	24.8475	24.8275	24.8275	7120.0
2016-07-19 07:00:00	AAPL	Stock	24.8625	24.88	24.8525	24.8525	31276.0
2016-07-19 08:00:00	AAPL	Stock	24.8525	24.8875	24.85	24.8825	150372.0
2016-07-19 09:00:00	AAPL	Stock	24.88	24.9925	24.835	24.93	14237996.0
2016-07-19 10:00:00	AAPL	Stock	24.9275	25.0	24.9	24.9775	15605192.0
2016-07-19 11:00:00	AAPL	Stock	24.9775	24.995	24.8875	24.905	12525832.0
2016-07-19 12:00:00	AAPL	Stock	24.905	24.96	24.8975	24.955	8128192.0
2016-07-19 13:00:00	AAPL	Stock	24.9538	24.98	24.9375	24.955	7756120.0
2016-07-19 14:00:00	AAPL	Stock	24.9575	24.985	24.945	24.9662	6676364.0
2016-07-19 15:00:00	AAPL	Stock	24.9675	24.9875	24.94	24.9675	13885068.0
2016-07-19 16:00:00	AAPL	Stock	24.97	25.0025	24.95	24.975	8975140.0
2016-07-19 17:00:00	AAPL	Stock	24.97	24.9825	24.955	24.975	32576.0
2016-07-19 18:00:00	AAPL	Stock	24.975	24.985	24.975	24.975	17704.0
2016-07-19 19:00:00	AAPL	Stock	24.985	24.985	24.9775	24.985	15800.0
2016-07-19 05:00:00	MSFT	Stock	53.91	53.91	53.91	53.91	401.0
2016-07-19 06:00:00	MSFT	Stock	53.86	53.86	53.86	53.86	500.0
2016-07-19 07:00:00	MSFT	Stock	53.98	53.98	53.91	53.92	1300.0
2016-07-19 08:00:00	MSFT	Stock	53.91	54.08	53.91	54.0	29057.0
2016-07-19 09:00:00	MSFT	Stock	54.0	54.0	53.375	53.41	5465041.0
2016-07-19 10:00:00	MSFT	Stock	53.41	53.66	53.41	53.56	5454254.0
2016-07-19 11:00:00	MSFT	Stock	53.567	53.62	53.38	53.495	3703798.0
2016-07-19 12:00:00	MSFT	Stock	53.49	53.6	53.45	53.54	3044308.0
2016-07-19 13:00:00	MSFT	Stock	53.545	53.547	53.1	53.145	4899662.0
2016-07-19 14:00:00	MSFT	Stock	53.15	53.24	53.11	53.207	4914437.0
2016-07-19 15:00:00	MSFT	Stock	53.205	53.205	52.93	53.056	13843409.0
2016-07-19 16:00:00	MSFT	Stock	53.055	55.43	52.77	54.65	7418716.0
2016-07-19 17:00:00	MSFT	Stock	54.71	54.95	54.48	54.65	547030.0
2016-07-19 18:00:00	MSFT	Stock	54.62	55.6	54.62	55.3	1064014.0
2016-07-19 19:00:00	MSFT	Stock	55.3	55.38	55.25	55.34	181674.0
2016-07-19 07:00:00	NVDA	Stock	1.3298	1.33	1.3298	1.33	20000.0
2016-07-19 08:00:00	NVDA	Stock	1.325	1.325	1.3243	1.3243	60000.0
2016-07-19 09:00:00	NVDA	Stock	1.3235	1.3305	1.321	1.3271	28371160.0
2016-07-19 10:00:00	NVDA	Stock	1.3273	1.338	1.327	1.3366	52813720.0
2016-07-19 11:00:00	NVDA	Stock	1.337	1.3432	1.3355	1.34	46394120.0
2016-07-19 12:00:00	NVDA	Stock	1.34	1.3408	1.3378	1.3392	28482200.0
2016-07-19 13:00:00	NVDA	Stock	1.3394	1.3395	1.3348	1.3358	27265360.0
2016-07-19 14:00:00	NVDA	Stock	1.3356	1.3379	1.3355	1.3369	28598240.0
2016-07-19 15:00:00	NVDA	Stock	1.337	1.3386	1.336	1.3378	55506800.0
2016-07-19 16:00:00	NVDA	Stock	1.338	1.3392	1.337	1.3392	2144920.0
2016-07-19 17:00:00	NVDA	Stock	1.3383	1.3392	1.3383	1.3392	98400.0
2016-07-19 18:00:00	NVDA	Stock	1.3392	1.3392	1.3392	1.3392	24000.0
2016-07-19 19:00:00	NVDA	Stock	1.3375	1.3375	1.3375	1.3375	11240.0
2016-07-19 04:00:00	AMZN	Stock	36.675	36.675	36.675	36.675	5440.0
2016-07-19 05:00:00	AMZN	Stock	36.68	36.68	36.68	36.68	2000.0
2016-07-19 06:00:00	AMZN	Stock	36.5605	36.5605	36.5605	36.5605	2000.0
2016-07-19 08:00:00	AMZN	Stock	36.7485	36.7485	36.675	36.7295	59040.0
2016-07-19 09:00:00	AMZN	Stock	36.7325	37.051	36.6155	36.9924	12137240.0
2016-07-19 10:00:00	AMZN	Stock	36.9944	37.1135	36.9635	37.097	6308080.0

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

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