PREVIEW / stock_1hour / 2017-09-15

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-09-15.parquet
  size:    1.1 MB
  rows:    48,674
  symbols: 2,974

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-09-15 05:00:00	AAPL	Stock	39.55	39.57	39.5375	39.57	5600.0
2017-09-15 06:00:00	AAPL	Stock	39.5375	39.5675	39.505	39.5675	25600.0
2017-09-15 07:00:00	AAPL	Stock	39.5275	39.675	39.525	39.63	146976.0
2017-09-15 08:00:00	AAPL	Stock	39.6425	39.675	39.575	39.61	272856.0
2017-09-15 09:00:00	AAPL	Stock	39.6125	39.9725	39.5	39.915	48183744.0
2017-09-15 10:00:00	AAPL	Stock	39.915	40.2425	39.895	40.2	26823044.0
2017-09-15 11:00:00	AAPL	Stock	40.1975	40.2125	40.0528	40.1435	11321420.0
2017-09-15 12:00:00	AAPL	Stock	40.1438	40.1675	39.98	40.02	7803360.0
2017-09-15 13:00:00	AAPL	Stock	40.02	40.025	39.93	39.98	7392980.0
2017-09-15 14:00:00	AAPL	Stock	39.9825	40.02	39.965	40.0078	8386184.0
2017-09-15 15:00:00	AAPL	Stock	40.0075	40.055	39.955	39.97	21772340.0
2017-09-15 16:00:00	AAPL	Stock	39.97	40.025	39.95	39.99	47036820.0
2017-09-15 17:00:00	AAPL	Stock	40.0	40.0225	39.99	40.0075	26700.0
2017-09-15 18:00:00	AAPL	Stock	40.0075	40.0125	39.99	40.0	68172.0
2017-09-15 19:00:00	AAPL	Stock	39.99	40.02	39.99	40.02	54296.0
2017-09-15 05:00:00	MSFT	Stock	74.7	74.7	74.7	74.7	100.0
2017-09-15 06:00:00	MSFT	Stock	74.65	74.65	74.65	74.65	761.0
2017-09-15 07:00:00	MSFT	Stock	74.69	74.75	74.69	74.75	500.0
2017-09-15 08:00:00	MSFT	Stock	74.76	74.9	74.65	74.65	3731.0
2017-09-15 09:00:00	MSFT	Stock	74.87	75.02	74.16	74.16	12135797.0
2017-09-15 10:00:00	MSFT	Stock	74.16	75.335	74.07	75.298	4158338.0
2017-09-15 11:00:00	MSFT	Stock	75.295	75.39	75.16	75.26	2799768.0
2017-09-15 12:00:00	MSFT	Stock	75.265	75.34	75.03	75.06	1316214.0
2017-09-15 13:00:00	MSFT	Stock	75.07	75.14	74.95	75.015	827316.0
2017-09-15 14:00:00	MSFT	Stock	75.02	75.05	74.97	75.01	1268528.0
2017-09-15 15:00:00	MSFT	Stock	75.01	75.38	74.98	75.29	5732274.0
2017-09-15 16:00:00	MSFT	Stock	75.29	75.36	75.2	75.28	8081462.0
2017-09-15 17:00:00	MSFT	Stock	75.29	75.31	75.28	75.31	1530.0
2017-09-15 18:00:00	MSFT	Stock	75.27	75.27	75.27	75.27	1175.0
2017-09-15 19:00:00	MSFT	Stock	75.3	75.31	75.3	75.31	1915.0
2017-09-15 04:00:00	NVDA	Stock	4.2112	4.2112	4.2062	4.2062	65240.0
2017-09-15 05:00:00	NVDA	Stock	4.207	4.2088	4.2062	4.2088	12000.0
2017-09-15 06:00:00	NVDA	Stock	4.2125	4.2965	4.2125	4.2938	965360.0
2017-09-15 07:00:00	NVDA	Stock	4.2938	4.304	4.28	4.288	1725320.0
2017-09-15 08:00:00	NVDA	Stock	4.288	4.3188	4.2815	4.3153	8946120.0
2017-09-15 09:00:00	NVDA	Stock	4.3148	4.4122	4.3072	4.3975	317344960.0
2017-09-15 10:00:00	NVDA	Stock	4.396	4.4732	4.3938	4.462	258240320.0
2017-09-15 11:00:00	NVDA	Stock	4.462	4.4892	4.4518	4.4795	197036720.0
2017-09-15 12:00:00	NVDA	Stock	4.4798	4.4925	4.4665	4.4792	135050560.0
2017-09-15 13:00:00	NVDA	Stock	4.4796	4.4948	4.4725	4.4825	103839560.0
2017-09-15 14:00:00	NVDA	Stock	4.483	4.4992	4.477	4.4922	91760200.0
2017-09-15 15:00:00	NVDA	Stock	4.4922	4.5028	4.4822	4.5025	159409480.0
2017-09-15 16:00:00	NVDA	Stock	4.5025	4.52	4.5	4.5052	21455960.0
2017-09-15 17:00:00	NVDA	Stock	4.5068	4.51	4.5002	4.5088	2730200.0
2017-09-15 18:00:00	NVDA	Stock	4.5063	4.5095	4.5013	4.505	664600.0
2017-09-15 19:00:00	NVDA	Stock	4.505	4.515	4.5025	4.514	640000.0
2017-09-15 07:00:00	AMZN	Stock	49.4565	49.4565	49.45	49.45	14040.0
2017-09-15 08:00:00	AMZN	Stock	49.525	49.5845	49.458	49.458	35060.0
2017-09-15 09:00:00	AMZN	Stock	49.45	49.7345	49.2015	49.2768	22367480.0
2017-09-15 10:00:00	AMZN	Stock	49.289	49.7728	49.2705	49.7286	10223140.0

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

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