PREVIEW / stock_1hour / 2017-04-04

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-04-04.parquet
  size:    1.0 MB
  rows:    48,528
  symbols: 3,051

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
2017-04-04 04:00:00	AAPL	Stock	35.8375	35.8975	35.8275	35.8975	7028.0
2017-04-04 05:00:00	AAPL	Stock	35.8975	35.9025	35.885	35.895	6412.0
2017-04-04 06:00:00	AAPL	Stock	35.8875	35.8875	35.875	35.875	4152.0
2017-04-04 07:00:00	AAPL	Stock	35.875	35.875	35.8	35.8125	44816.0
2017-04-04 08:00:00	AAPL	Stock	35.85	35.85	35.8025	35.825	150496.0
2017-04-04 09:00:00	AAPL	Stock	35.825	35.9875	35.7925	35.9225	10193612.0
2017-04-04 10:00:00	AAPL	Stock	35.92	36.0575	35.855	36.0112	13158188.0
2017-04-04 11:00:00	AAPL	Stock	36.01	36.12	36.0	36.0675	11364496.0
2017-04-04 12:00:00	AAPL	Stock	36.0675	36.1075	36.01	36.035	5206424.0
2017-04-04 13:00:00	AAPL	Stock	36.0362	36.1	36.0075	36.0925	4779384.0
2017-04-04 14:00:00	AAPL	Stock	36.095	36.2225	36.0925	36.1525	10979660.0
2017-04-04 15:00:00	AAPL	Stock	36.15	36.215	36.13	36.19	11861316.0
2017-04-04 16:00:00	AAPL	Stock	36.1925	36.22	36.0483	36.22	3722432.0
2017-04-04 17:00:00	AAPL	Stock	36.195	36.22	36.195	36.2025	7280.0
2017-04-04 18:00:00	AAPL	Stock	36.205	36.2175	36.2025	36.2025	25600.0
2017-04-04 19:00:00	AAPL	Stock	36.2175	36.22	36.2025	36.2175	22184.0
2017-04-04 06:00:00	MSFT	Stock	65.39	65.4	65.39	65.4	3323.0
2017-04-04 07:00:00	MSFT	Stock	65.35	65.35	65.32	65.32	2600.0
2017-04-04 08:00:00	MSFT	Stock	65.26	65.55	65.11	65.25	34040.0
2017-04-04 09:00:00	MSFT	Stock	65.25	65.66	65.25	65.535	1935759.0
2017-04-04 10:00:00	MSFT	Stock	65.535	65.64	65.39	65.51	1638401.0
2017-04-04 11:00:00	MSFT	Stock	65.52	65.75	65.49	65.66	1365851.0
2017-04-04 12:00:00	MSFT	Stock	65.65	65.67	65.531	65.55	1047645.0
2017-04-04 13:00:00	MSFT	Stock	65.555	65.63	65.5	65.59	844622.0
2017-04-04 14:00:00	MSFT	Stock	65.595	65.81	65.59	65.725	1343149.0
2017-04-04 15:00:00	MSFT	Stock	65.72	65.8	65.68	65.73	2228327.0
2017-04-04 16:00:00	MSFT	Stock	65.74	65.74	65.73	65.73	1159925.0
2017-04-04 17:00:00	MSFT	Stock	65.78	65.78	65.77	65.77	1633.0
2017-04-04 19:00:00	MSFT	Stock	65.78	65.8	65.78	65.79	1731.0
2017-04-04 04:00:00	NVDA	Stock	2.6512	2.6512	2.6275	2.6333	412000.0
2017-04-04 05:00:00	NVDA	Stock	2.6375	2.6912	2.6335	2.6485	349680.0
2017-04-04 06:00:00	NVDA	Stock	2.639	2.65	2.6343	2.6423	282720.0
2017-04-04 07:00:00	NVDA	Stock	2.639	2.6402	2.6205	2.6225	2203160.0
2017-04-04 08:00:00	NVDA	Stock	2.6272	2.6402	2.6028	2.6028	7517520.0
2017-04-04 09:00:00	NVDA	Stock	2.6098	2.6105	2.5605	2.583	233475520.0
2017-04-04 10:00:00	NVDA	Stock	2.5825	2.5928	2.5285	2.533	272869040.0
2017-04-04 11:00:00	NVDA	Stock	2.5328	2.5616	2.5312	2.5475	151159560.0
2017-04-04 12:00:00	NVDA	Stock	2.5474	2.5582	2.5395	2.5412	83348000.0
2017-04-04 13:00:00	NVDA	Stock	2.5413	2.5483	2.5233	2.524	91368400.0
2017-04-04 14:00:00	NVDA	Stock	2.5245	2.5315	2.5085	2.509	102177560.0
2017-04-04 15:00:00	NVDA	Stock	2.5093	2.5288	2.5091	2.5195	156000160.0
2017-04-04 16:00:00	NVDA	Stock	2.5245	2.5492	2.515	2.5165	60999080.0
2017-04-04 17:00:00	NVDA	Stock	2.5158	2.5163	2.5	2.502	2223960.0
2017-04-04 18:00:00	NVDA	Stock	2.5025	2.506	2.5	2.5045	894960.0
2017-04-04 19:00:00	NVDA	Stock	2.5048	2.5048	2.4975	2.4978	532360.0
2017-04-04 05:00:00	AMZN	Stock	44.48	44.485	44.48	44.485	6000.0
2017-04-04 06:00:00	AMZN	Stock	44.485	44.5975	44.485	44.5975	17540.0
2017-04-04 07:00:00	AMZN	Stock	44.6245	44.635	44.45	44.45	86840.0
2017-04-04 08:00:00	AMZN	Stock	44.55	44.55	44.45	44.4925	134980.0
2017-04-04 09:00:00	AMZN	Stock	44.514	44.9655	44.475	44.95	15824280.0

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

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