PREVIEW / stock_1hour / 2017-10-19

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-19.parquet
  size:    1.1 MB
  rows:    48,490
  symbols: 2,924

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-19 04:00:00	AAPL	Stock	39.625	39.625	39.2125	39.42	53224.0
2017-10-19 05:00:00	AAPL	Stock	39.3625	39.3725	39.3125	39.3375	34020.0
2017-10-19 06:00:00	AAPL	Stock	39.335	39.3375	39.25	39.2875	139180.0
2017-10-19 07:00:00	AAPL	Stock	39.3175	39.4425	39.265	39.37	664268.0
2017-10-19 08:00:00	AAPL	Stock	39.37	39.425	39.2125	39.2825	979544.0
2017-10-19 09:00:00	AAPL	Stock	39.2825	39.3225	38.9125	38.9825	31300756.0
2017-10-19 10:00:00	AAPL	Stock	38.98	39.0538	38.815	38.9875	25485300.0
2017-10-19 11:00:00	AAPL	Stock	38.9875	39.005	38.8375	38.855	14496136.0
2017-10-19 12:00:00	AAPL	Stock	38.8525	38.9725	38.7625	38.766	16338976.0
2017-10-19 13:00:00	AAPL	Stock	38.7662	38.96	38.755	38.8675	12570380.0
2017-10-19 14:00:00	AAPL	Stock	38.8668	38.8975	38.795	38.8688	9844512.0
2017-10-19 15:00:00	AAPL	Stock	38.87	39.005	38.8675	38.995	21231768.0
2017-10-19 16:00:00	AAPL	Stock	38.995	39.0175	38.8125	39.0025	20995952.0
2017-10-19 17:00:00	AAPL	Stock	39.0025	39.015	38.925	38.94	211148.0
2017-10-19 18:00:00	AAPL	Stock	38.935	38.935	38.8525	38.9	120128.0
2017-10-19 19:00:00	AAPL	Stock	38.89	38.925	38.88	38.9	39660.0
2017-10-19 04:00:00	MSFT	Stock	77.99	77.99	77.25	77.35	6488.0
2017-10-19 06:00:00	MSFT	Stock	77.48	77.48	77.11	77.11	5757.0
2017-10-19 07:00:00	MSFT	Stock	77.3	77.3	77.18	77.18	13927.0
2017-10-19 08:00:00	MSFT	Stock	77.2	77.38	77.18	77.38	15914.0
2017-10-19 09:00:00	MSFT	Stock	77.26	77.85	77.26	77.56	1840066.0
2017-10-19 10:00:00	MSFT	Stock	77.57	77.78	77.38	77.771	2047371.0
2017-10-19 11:00:00	MSFT	Stock	77.77	77.83	77.68	77.73	1359693.0
2017-10-19 12:00:00	MSFT	Stock	77.73	77.767	77.58	77.695	951240.0
2017-10-19 13:00:00	MSFT	Stock	77.694	77.72	77.63	77.66	953264.0
2017-10-19 14:00:00	MSFT	Stock	77.66	77.805	77.63	77.755	1024288.0
2017-10-19 15:00:00	MSFT	Stock	77.755	77.93	77.72	77.92	3387512.0
2017-10-19 16:00:00	MSFT	Stock	77.91	78.05	77.713	78.03	1603393.0
2017-10-19 17:00:00	MSFT	Stock	78.1	78.1	77.91	78.01	2738.0
2017-10-19 18:00:00	MSFT	Stock	78.01	78.06	78.01	78.06	1900.0
2017-10-19 19:00:00	MSFT	Stock	78.03	78.06	78.03	78.06	2822.0
2017-10-19 04:00:00	NVDA	Stock	4.925	4.925	4.85	4.872	128280.0
2017-10-19 05:00:00	NVDA	Stock	4.8863	4.8863	4.8528	4.8562	94680.0
2017-10-19 06:00:00	NVDA	Stock	4.86	4.8625	4.8098	4.8098	470680.0
2017-10-19 07:00:00	NVDA	Stock	4.8223	4.865	4.8188	4.855	1388480.0
2017-10-19 08:00:00	NVDA	Stock	4.8578	4.872	4.81	4.8695	3305920.0
2017-10-19 09:00:00	NVDA	Stock	4.868	4.8867	4.8112	4.8657	109947440.0
2017-10-19 10:00:00	NVDA	Stock	4.8653	4.9322	4.8538	4.9299	141907400.0
2017-10-19 11:00:00	NVDA	Stock	4.9298	4.95	4.9273	4.9368	80515120.0
2017-10-19 12:00:00	NVDA	Stock	4.937	4.9438	4.908	4.9156	40322800.0
2017-10-19 13:00:00	NVDA	Stock	4.915	4.9345	4.915	4.9267	36643840.0
2017-10-19 14:00:00	NVDA	Stock	4.9263	4.935	4.922	4.9278	25098240.0
2017-10-19 15:00:00	NVDA	Stock	4.9285	4.95	4.9198	4.9448	58536120.0
2017-10-19 16:00:00	NVDA	Stock	4.9448	4.947	4.9408	4.942	16073080.0
2017-10-19 17:00:00	NVDA	Stock	4.941	4.9455	4.9388	4.9455	305360.0
2017-10-19 18:00:00	NVDA	Stock	4.9428	4.9438	4.938	4.941	258640.0
2017-10-19 19:00:00	NVDA	Stock	4.9388	4.942	4.93	4.9412	614640.0
2017-10-19 04:00:00	AMZN	Stock	49.75	49.75	49.6	49.6	4000.0
2017-10-19 06:00:00	AMZN	Stock	49.4755	49.4755	49.35	49.3515	12240.0
2017-10-19 07:00:00	AMZN	Stock	49.4	49.4875	49.35	49.45	58840.0

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

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