PREVIEW / stock_1hour / 2017-07-24

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-07-24.parquet
  size:    1.0 MB
  rows:    48,215
  symbols: 2,978

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-07-24 05:00:00	AAPL	Stock	37.525	37.525	37.525	37.525	400.0
2017-07-24 06:00:00	AAPL	Stock	37.475	37.475	37.475	37.475	2000.0
2017-07-24 07:00:00	AAPL	Stock	37.5	37.5275	37.4875	37.5275	12512.0
2017-07-24 08:00:00	AAPL	Stock	37.5275	37.595	37.52	37.5625	41688.0
2017-07-24 09:00:00	AAPL	Stock	37.58	37.6675	37.475	37.6375	8012428.0
2017-07-24 10:00:00	AAPL	Stock	37.6375	37.8325	37.6275	37.78	12036716.0
2017-07-24 11:00:00	AAPL	Stock	37.78	37.83	37.705	37.82	6027824.0
2017-07-24 12:00:00	AAPL	Stock	37.82	37.9825	37.8175	37.9655	7825424.0
2017-07-24 13:00:00	AAPL	Stock	37.9675	38.0	37.92	37.94	6301408.0
2017-07-24 14:00:00	AAPL	Stock	37.9375	37.96	37.8825	37.955	5450020.0
2017-07-24 15:00:00	AAPL	Stock	37.9562	38.11	37.89	38.0275	19244124.0
2017-07-24 16:00:00	AAPL	Stock	38.0275	38.11	37.925	37.93	11984552.0
2017-07-24 17:00:00	AAPL	Stock	37.93	38.0225	37.92	37.95	297960.0
2017-07-24 18:00:00	AAPL	Stock	37.9625	37.995	37.95	37.9575	40840.0
2017-07-24 19:00:00	AAPL	Stock	37.9675	37.9675	37.9575	37.9675	21536.0
2017-07-24 04:00:00	MSFT	Stock	73.61	73.7	73.6	73.66	1284.0
2017-07-24 05:00:00	MSFT	Stock	73.64	73.65	73.55	73.55	1945.0
2017-07-24 06:00:00	MSFT	Stock	73.55	73.55	73.5	73.5	565.0
2017-07-24 07:00:00	MSFT	Stock	73.51	73.55	73.46	73.47	4630.0
2017-07-24 08:00:00	MSFT	Stock	73.48	73.63	73.42	73.6	11322.0
2017-07-24 09:00:00	MSFT	Stock	73.58	73.65	73.38	73.626	2286030.0
2017-07-24 10:00:00	MSFT	Stock	73.63	73.64	73.13	73.385	3259767.0
2017-07-24 11:00:00	MSFT	Stock	73.385	73.4	73.21	73.295	1733250.0
2017-07-24 12:00:00	MSFT	Stock	73.3	73.41	73.29	73.33	1020115.0
2017-07-24 13:00:00	MSFT	Stock	73.335	73.34	73.17	73.27	1300541.0
2017-07-24 14:00:00	MSFT	Stock	73.275	73.39	73.27	73.38	1586731.0
2017-07-24 15:00:00	MSFT	Stock	73.38	73.75	73.341	73.61	5437093.0
2017-07-24 16:00:00	MSFT	Stock	73.6	73.75	73.32	73.44	3075594.0
2017-07-24 17:00:00	MSFT	Stock	73.6	73.6	73.37	73.49	276999.0
2017-07-24 18:00:00	MSFT	Stock	73.4	73.5	73.4	73.4	6401.0
2017-07-24 19:00:00	MSFT	Stock	73.4	73.43	73.4	73.43	1258.0
2017-07-24 04:00:00	NVDA	Stock	4.1938	4.1938	4.1873	4.1875	52000.0
2017-07-24 05:00:00	NVDA	Stock	4.1875	4.1875	4.1875	4.1875	4000.0
2017-07-24 06:00:00	NVDA	Stock	4.1968	4.1987	4.188	4.1925	61960.0
2017-07-24 07:00:00	NVDA	Stock	4.1938	4.1998	4.1915	4.1975	347520.0
2017-07-24 08:00:00	NVDA	Stock	4.2	4.2125	4.1918	4.2095	1524320.0
2017-07-24 09:00:00	NVDA	Stock	4.2112	4.2195	4.1815	4.2018	93585600.0
2017-07-24 10:00:00	NVDA	Stock	4.2015	4.209	4.168	4.1703	106710880.0
2017-07-24 11:00:00	NVDA	Stock	4.1704	4.175	4.143	4.145	130312720.0
2017-07-24 12:00:00	NVDA	Stock	4.145	4.1725	4.145	4.167	73668880.0
2017-07-24 13:00:00	NVDA	Stock	4.1672	4.1685	4.1478	4.1486	42200800.0
2017-07-24 14:00:00	NVDA	Stock	4.1482	4.162	4.1478	4.1554	41277080.0
2017-07-24 15:00:00	NVDA	Stock	4.1554	4.1697	4.1472	4.1542	98045920.0
2017-07-24 16:00:00	NVDA	Stock	4.1538	4.1575	4.1162	4.1238	20084000.0
2017-07-24 17:00:00	NVDA	Stock	4.1248	4.1538	4.09	4.093	4634920.0
2017-07-24 18:00:00	NVDA	Stock	4.099	4.125	4.0965	4.1188	1587560.0
2017-07-24 19:00:00	NVDA	Stock	4.1212	4.125	4.1145	4.125	547760.0
2017-07-24 04:00:00	AMZN	Stock	51.25	51.25	51.225	51.225	15620.0
2017-07-24 05:00:00	AMZN	Stock	51.25	51.25	51.25	51.25	3980.0
2017-07-24 06:00:00	AMZN	Stock	51.2505	51.2505	51.2	51.2	4000.0

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

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