PREVIEW / stock_1hour / 2017-10-09

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-09.parquet
  size:    1.0 MB
  rows:    47,691
  symbols: 2,930

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-10-09 04:00:00	AAPL	Stock	38.7675	38.7675	38.7575	38.7575	7792.0
2017-10-09 05:00:00	AAPL	Stock	38.8125	38.95	38.8125	38.9	14916.0
2017-10-09 06:00:00	AAPL	Stock	38.9	38.9375	38.9	38.9375	22084.0
2017-10-09 07:00:00	AAPL	Stock	38.9	38.9975	38.8875	38.975	145224.0
2017-10-09 08:00:00	AAPL	Stock	38.95	38.9975	38.9	38.9575	194692.0
2017-10-09 09:00:00	AAPL	Stock	38.9725	39.07	38.8713	39.0518	10213884.0
2017-10-09 10:00:00	AAPL	Stock	39.0538	39.1825	38.965	39.0075	13373176.0
2017-10-09 11:00:00	AAPL	Stock	39.01	39.05	38.9425	39.0175	5883040.0
2017-10-09 12:00:00	AAPL	Stock	39.0198	39.0322	38.9475	39.0125	4624712.0
2017-10-09 13:00:00	AAPL	Stock	39.0102	39.025	38.9782	38.9942	3127568.0
2017-10-09 14:00:00	AAPL	Stock	38.995	39.01	38.94	38.9552	3513616.0
2017-10-09 15:00:00	AAPL	Stock	38.955	38.99	38.9002	38.955	10114340.0
2017-10-09 16:00:00	AAPL	Stock	38.96	38.975	38.9125	38.9175	6140192.0
2017-10-09 17:00:00	AAPL	Stock	38.92	38.96	38.9125	38.9125	18516.0
2017-10-09 18:00:00	AAPL	Stock	38.9325	38.9375	38.9125	38.9325	24884.0
2017-10-09 19:00:00	AAPL	Stock	38.9175	38.9375	38.9125	38.9125	35816.0
2017-10-09 07:00:00	MSFT	Stock	76.0	76.09	76.0	76.09	1200.0
2017-10-09 08:00:00	MSFT	Stock	76.0	76.05	76.0	76.05	550.0
2017-10-09 09:00:00	MSFT	Stock	76.07	76.28	75.86	76.25	1452055.0
2017-10-09 10:00:00	MSFT	Stock	76.25	76.385	76.1	76.176	1063147.0
2017-10-09 11:00:00	MSFT	Stock	76.175	76.35	76.045	76.284	862410.0
2017-10-09 12:00:00	MSFT	Stock	76.29	76.55	76.27	76.54	1060079.0
2017-10-09 13:00:00	MSFT	Stock	76.535	76.55	76.39	76.43	800135.0
2017-10-09 14:00:00	MSFT	Stock	76.425	76.51	76.29	76.29	1010097.0
2017-10-09 15:00:00	MSFT	Stock	76.29	76.35	76.18	76.3	2422966.0
2017-10-09 16:00:00	MSFT	Stock	76.3	76.4	76.26	76.4	1348100.0
2017-10-09 04:00:00	NVDA	Stock	4.5468	4.5468	4.5445	4.5468	20000.0
2017-10-09 05:00:00	NVDA	Stock	4.5488	4.5488	4.5488	4.5488	4000.0
2017-10-09 06:00:00	NVDA	Stock	4.5525	4.5525	4.5478	4.5525	12000.0
2017-10-09 07:00:00	NVDA	Stock	4.5375	4.5522	4.5362	4.546	455600.0
2017-10-09 08:00:00	NVDA	Stock	4.54	4.586	4.54	4.58	1972720.0
2017-10-09 09:00:00	NVDA	Stock	4.5788	4.6218	4.5508	4.6175	98500120.0
2017-10-09 10:00:00	NVDA	Stock	4.6178	4.6412	4.6172	4.6333	103671800.0
2017-10-09 11:00:00	NVDA	Stock	4.6338	4.6663	4.6338	4.6648	82837560.0
2017-10-09 12:00:00	NVDA	Stock	4.6645	4.6682	4.6447	4.6498	37985440.0
2017-10-09 13:00:00	NVDA	Stock	4.6485	4.6663	4.6485	4.6535	28257400.0
2017-10-09 14:00:00	NVDA	Stock	4.6542	4.6635	4.6325	4.6355	46197520.0
2017-10-09 15:00:00	NVDA	Stock	4.635	4.6358	4.6048	4.6345	90316720.0
2017-10-09 16:00:00	NVDA	Stock	4.6347	4.6375	4.6315	4.6315	9347960.0
2017-10-09 17:00:00	NVDA	Stock	4.6295	4.6375	4.6295	4.6362	361680.0
2017-10-09 18:00:00	NVDA	Stock	4.6362	4.6545	4.6362	4.6498	1129280.0
2017-10-09 19:00:00	NVDA	Stock	4.644	4.65	4.6412	4.6462	1250560.0
2017-10-09 05:00:00	AMZN	Stock	49.7445	49.7445	49.637	49.637	5800.0
2017-10-09 07:00:00	AMZN	Stock	49.5655	49.6815	49.545	49.6605	103820.0
2017-10-09 08:00:00	AMZN	Stock	49.67	49.6825	49.6	49.675	81900.0
2017-10-09 09:00:00	AMZN	Stock	49.6925	49.875	49.418	49.8115	9468500.0
2017-10-09 10:00:00	AMZN	Stock	49.804	49.925	49.5	49.642	9185840.0
2017-10-09 11:00:00	AMZN	Stock	49.652	49.7195	49.5	49.6583	5779400.0
2017-10-09 12:00:00	AMZN	Stock	49.6625	49.6952	49.55	49.6025	3628800.0
2017-10-09 13:00:00	AMZN	Stock	49.6	49.637	49.528	49.6168	4284620.0

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

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