PREVIEW / stock_1hour / 2019-12-30

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-12-30.parquet
  size:    1.1 MB
  rows:    50,947
  symbols: 2,467

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-30 04:00:00	AAPL	Stock	72.5375	72.5375	72.445	72.445	6760.0
2019-12-30 05:00:00	AAPL	Stock	72.375	72.38	72.35	72.35	5300.0
2019-12-30 06:00:00	AAPL	Stock	72.35	72.3625	72.275	72.3625	10504.0
2019-12-30 07:00:00	AAPL	Stock	72.3875	72.4375	72.35	72.43	101760.0
2019-12-30 08:00:00	AAPL	Stock	72.4	72.4625	72.3125	72.4575	226756.0
2019-12-30 09:00:00	AAPL	Stock	72.4375	72.46	71.585	71.6928	16629152.0
2019-12-30 10:00:00	AAPL	Stock	71.7088	71.9475	71.305	71.9038	18407400.0
2019-12-30 11:00:00	AAPL	Stock	71.904	72.715	71.795	72.6165	21505576.0
2019-12-30 12:00:00	AAPL	Stock	72.6125	72.9725	72.5623	72.87	17113500.0
2019-12-30 13:00:00	AAPL	Stock	72.87	73.1725	72.74	73.1562	12260032.0
2019-12-30 14:00:00	AAPL	Stock	73.15	73.154	72.77	72.8225	11457432.0
2019-12-30 15:00:00	AAPL	Stock	72.8225	73.125	72.7725	72.9118	16806128.0
2019-12-30 16:00:00	AAPL	Stock	72.88	72.925	72.7725	72.8325	6242696.0
2019-12-30 17:00:00	AAPL	Stock	72.855	72.865	72.835	72.8575	37948.0
2019-12-30 18:00:00	AAPL	Stock	72.855	72.875	72.8525	72.875	37092.0
2019-12-30 19:00:00	AAPL	Stock	72.855	72.9375	72.855	72.925	86872.0
2019-12-30 04:00:00	MSFT	Stock	159.1	159.25	158.98	158.98	4330.0
2019-12-30 05:00:00	MSFT	Stock	158.95	158.95	158.86	158.86	1860.0
2019-12-30 06:00:00	MSFT	Stock	158.9	158.9	158.81	158.85	796.0
2019-12-30 07:00:00	MSFT	Stock	158.92	158.96	158.8	158.8	7535.0
2019-12-30 08:00:00	MSFT	Stock	158.9	158.94	158.712	158.897	12495.0
2019-12-30 09:00:00	MSFT	Stock	158.761	159.02	157.07	157.175	2460045.0
2019-12-30 10:00:00	MSFT	Stock	157.17	157.668	156.73	157.61	2383585.0
2019-12-30 11:00:00	MSFT	Stock	157.62	157.93	157.32	157.74	1168291.0
2019-12-30 12:00:00	MSFT	Stock	157.747	158.131	157.63	158.02	1150110.0
2019-12-30 13:00:00	MSFT	Stock	158.01	158.15	157.89	158.06	888427.0
2019-12-30 14:00:00	MSFT	Stock	158.07	158.08	157.76	157.92	898191.0
2019-12-30 15:00:00	MSFT	Stock	157.912	158.01	157.38	157.68	2279562.0
2019-12-30 16:00:00	MSFT	Stock	157.59	157.7	157.32	157.5	2829776.0
2019-12-30 17:00:00	MSFT	Stock	157.56	157.57	157.52	157.57	1538.0
2019-12-30 18:00:00	MSFT	Stock	157.57	157.69	157.53	157.69	7511.0
2019-12-30 19:00:00	MSFT	Stock	157.63	157.7	157.53	157.57	1780.0
2019-12-30 05:00:00	NVDA	Stock	5.9055	5.9078	5.9055	5.9078	22240.0
2019-12-30 06:00:00	NVDA	Stock	5.8865	5.905	5.8843	5.9025	81760.0
2019-12-30 07:00:00	NVDA	Stock	5.9025	5.915	5.9	5.915	79640.0
2019-12-30 08:00:00	NVDA	Stock	5.9162	5.9162	5.9	5.905	694640.0
2019-12-30 09:00:00	NVDA	Stock	5.9072	5.9072	5.808	5.832	43989120.0
2019-12-30 10:00:00	NVDA	Stock	5.8336	5.8352	5.8017	5.8238	30982320.0
2019-12-30 11:00:00	NVDA	Stock	5.8248	5.8299	5.804	5.8265	20298760.0
2019-12-30 12:00:00	NVDA	Stock	5.8259	5.8305	5.8103	5.823	21201520.0
2019-12-30 13:00:00	NVDA	Stock	5.8223	5.828	5.8053	5.8123	12643560.0
2019-12-30 14:00:00	NVDA	Stock	5.8125	5.8137	5.7765	5.7904	24917640.0
2019-12-30 15:00:00	NVDA	Stock	5.79	5.8123	5.787	5.8078	33335920.0
2019-12-30 16:00:00	NVDA	Stock	5.808	5.808	5.8002	5.8025	29806120.0
2019-12-30 17:00:00	NVDA	Stock	5.795	5.797	5.795	5.797	49120.0
2019-12-30 18:00:00	NVDA	Stock	5.7968	5.8	5.7968	5.8	67160.0
2019-12-30 19:00:00	NVDA	Stock	5.7925	5.8013	5.7925	5.8013	112960.0
2019-12-30 04:00:00	AMZN	Stock	93.565	93.565	93.0565	93.2	37920.0
2019-12-30 05:00:00	AMZN	Stock	93.18	93.25	93.153	93.25	22500.0
2019-12-30 06:00:00	AMZN	Stock	93.2635	93.2795	93.2	93.237	21220.0

> showing 50 of 50,947 rows — these rows as CSV

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