PREVIEW / stock_1hour / 2019-12-26

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-12-26.parquet
  size:    1.1 MB
  rows:    49,187
  symbols: 2,450

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
2019-12-26 04:00:00	AAPL	Stock	71.2225	71.2225	71.2225	71.2225	2260.0
2019-12-26 05:00:00	AAPL	Stock	71.2225	71.2225	71.2225	71.2225	400.0
2019-12-26 06:00:00	AAPL	Stock	71.2125	71.2125	71.18	71.18	4292.0
2019-12-26 07:00:00	AAPL	Stock	71.21	71.21	71.1525	71.1825	19608.0
2019-12-26 08:00:00	AAPL	Stock	71.188	71.22	71.1625	71.1625	235524.0
2019-12-26 09:00:00	AAPL	Stock	71.1625	71.4975	71.14	71.4825	8232692.0
2019-12-26 10:00:00	AAPL	Stock	71.4775	71.8578	71.475	71.854	11968172.0
2019-12-26 11:00:00	AAPL	Stock	71.8538	72.1825	71.8538	72.154	14997760.0
2019-12-26 12:00:00	AAPL	Stock	72.155	72.17	71.9875	72.045	8445536.0
2019-12-26 13:00:00	AAPL	Stock	72.0425	72.1538	72.0175	72.1075	5456280.0
2019-12-26 14:00:00	AAPL	Stock	72.115	72.3213	72.1025	72.3	7230988.0
2019-12-26 15:00:00	AAPL	Stock	72.2988	72.495	72.1075	72.4775	14498992.0
2019-12-26 16:00:00	AAPL	Stock	72.4775	72.595	72.46	72.55	7329360.0
2019-12-26 17:00:00	AAPL	Stock	72.5625	72.625	72.4775	72.5975	353044.0
2019-12-26 18:00:00	AAPL	Stock	72.6	72.6725	72.6	72.6325	101564.0
2019-12-26 19:00:00	AAPL	Stock	72.6475	72.72	72.63	72.705	86224.0
2019-12-26 04:00:00	MSFT	Stock	157.56	157.56	157.56	157.56	100.0
2019-12-26 06:00:00	MSFT	Stock	157.73	157.75	157.73	157.75	2736.0
2019-12-26 07:00:00	MSFT	Stock	157.64	157.68	157.57	157.57	1908.0
2019-12-26 08:00:00	MSFT	Stock	157.6	157.7	157.51	157.64	14564.0
2019-12-26 09:00:00	MSFT	Stock	157.62	157.87	157.4	157.766	1085709.0
2019-12-26 10:00:00	MSFT	Stock	157.77	158.14	157.77	158.093	1057917.0
2019-12-26 11:00:00	MSFT	Stock	158.093	158.28	158.025	158.26	914383.0
2019-12-26 12:00:00	MSFT	Stock	158.265	158.41	158.06	158.15	854951.0
2019-12-26 13:00:00	MSFT	Stock	158.15	158.38	158.15	158.365	626188.0
2019-12-26 14:00:00	MSFT	Stock	158.365	158.41	158.25	158.37	737816.0
2019-12-26 15:00:00	MSFT	Stock	158.376	158.73	158.23	158.67	1992092.0
2019-12-26 16:00:00	MSFT	Stock	158.67	158.78	158.61	158.71	5356357.0
2019-12-26 17:00:00	MSFT	Stock	158.72	158.77	158.7	158.71	5211.0
2019-12-26 18:00:00	MSFT	Stock	158.76	158.86	158.73	158.86	2673.0
2019-12-26 19:00:00	MSFT	Stock	158.85	158.88	158.83	158.83	2401.0
2019-12-26 07:00:00	NVDA	Stock	5.9705	5.9895	5.9705	5.9865	49800.0
2019-12-26 08:00:00	NVDA	Stock	5.9891	5.9895	5.98	5.98	415360.0
2019-12-26 09:00:00	NVDA	Stock	5.98	5.9988	5.9508	5.99	31750960.0
2019-12-26 10:00:00	NVDA	Stock	5.9905	6.008	5.9848	5.9995	27771360.0
2019-12-26 11:00:00	NVDA	Stock	6.0	6.0059	5.9833	5.9835	20494800.0
2019-12-26 12:00:00	NVDA	Stock	5.985	5.986	5.95	5.9706	19098560.0
2019-12-26 13:00:00	NVDA	Stock	5.9708	5.9767	5.9588	5.9763	14088000.0
2019-12-26 14:00:00	NVDA	Stock	5.9764	5.9795	5.9615	5.9664	13626280.0
2019-12-26 15:00:00	NVDA	Stock	5.9668	5.9798	5.9558	5.9785	25108720.0
2019-12-26 16:00:00	NVDA	Stock	5.9798	5.9816	5.973	5.9804	14423280.0
2019-12-26 17:00:00	NVDA	Stock	5.9798	5.9812	5.9798	5.9812	56440.0
2019-12-26 19:00:00	NVDA	Stock	5.9842	5.99	5.98	5.9875	337480.0
2019-12-26 07:00:00	AMZN	Stock	89.6505	89.9	89.6505	89.84	38320.0
2019-12-26 08:00:00	AMZN	Stock	89.9	89.975	89.748	89.9625	123280.0
2019-12-26 09:00:00	AMZN	Stock	89.972	90.797	89.972	90.7825	8282360.0
2019-12-26 10:00:00	AMZN	Stock	90.7935	91.235	90.763	91.1061	7238820.0
2019-12-26 11:00:00	AMZN	Stock	91.1096	92.509	91.1	92.372	16674000.0
2019-12-26 12:00:00	AMZN	Stock	92.3678	92.56	92.0698	92.5432	13669100.0
2019-12-26 13:00:00	AMZN	Stock	92.5768	93.2799	92.566	93.1425	13272700.0

> showing 50 of 49,187 rows — these rows as CSV

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