PREVIEW / stock_1hour / 2020-06-04

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-04.parquet
  size:    1.2 MB
  rows:    56,917
  symbols: 2,398

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
2020-06-04 04:00:00	AAPL	Stock	81.2025	81.2025	81.015	81.07	7412.0
2020-06-04 05:00:00	AAPL	Stock	81.025	81.025	80.9025	80.905	4784.0
2020-06-04 06:00:00	AAPL	Stock	80.925	81.0575	80.925	81.0175	19944.0
2020-06-04 07:00:00	AAPL	Stock	81.045	81.1925	81.005	81.1725	75296.0
2020-06-04 08:00:00	AAPL	Stock	81.0278	81.2188	80.8975	81.07	320520.0
2020-06-04 09:00:00	AAPL	Stock	81.025	81.4028	81.025	81.1742	8920584.0
2020-06-04 10:00:00	AAPL	Stock	81.18	81.405	81.1078	81.1675	10527148.0
2020-06-04 11:00:00	AAPL	Stock	81.1675	81.1975	80.7125	81.03	9527824.0
2020-06-04 12:00:00	AAPL	Stock	81.035	81.09	80.6125	80.6275	6387836.0
2020-06-04 13:00:00	AAPL	Stock	80.6262	80.9825	80.61	80.9175	5784524.0
2020-06-04 14:00:00	AAPL	Stock	80.9052	80.9625	80.2175	80.2175	7793148.0
2020-06-04 15:00:00	AAPL	Stock	80.2212	80.59	80.195	80.58	13173040.0
2020-06-04 16:00:00	AAPL	Stock	80.58	80.7375	80.4175	80.68	5636580.0
2020-06-04 17:00:00	AAPL	Stock	80.6625	80.7125	80.4625	80.65	60812.0
2020-06-04 18:00:00	AAPL	Stock	80.65	80.7	80.6	80.6875	24588.0
2020-06-04 19:00:00	AAPL	Stock	80.67	80.67	80.5	80.525	50024.0
2020-06-04 04:00:00	MSFT	Stock	184.6	184.99	184.6	184.99	611.0
2020-06-04 05:00:00	MSFT	Stock	184.56	184.56	184.52	184.52	1177.0
2020-06-04 06:00:00	MSFT	Stock	184.45	184.55	184.3	184.55	9914.0
2020-06-04 07:00:00	MSFT	Stock	184.65	184.97	184.52	184.75	12400.0
2020-06-04 08:00:00	MSFT	Stock	184.74	184.9	184.27	184.5	41304.0
2020-06-04 09:00:00	MSFT	Stock	184.38	185.84	184.03	185.31	2857672.0
2020-06-04 10:00:00	MSFT	Stock	185.31	185.34	184.25	184.37	3450811.0
2020-06-04 11:00:00	MSFT	Stock	184.365	184.48	183.305	183.81	3342472.0
2020-06-04 12:00:00	MSFT	Stock	183.82	183.899	182.88	182.95	2166056.0
2020-06-04 13:00:00	MSFT	Stock	182.94	183.76	182.91	183.575	1872081.0
2020-06-04 14:00:00	MSFT	Stock	183.56	184.109	182.75	182.76	2326159.0
2020-06-04 15:00:00	MSFT	Stock	182.797	183.22	182.3	182.92	4683493.0
2020-06-04 16:00:00	MSFT	Stock	182.92	183.26	182.75	182.98	2945539.0
2020-06-04 17:00:00	MSFT	Stock	183.18	183.18	183.0	183.05	4484.0
2020-06-04 18:00:00	MSFT	Stock	182.98	183.0	182.73	182.98	4604.0
2020-06-04 19:00:00	MSFT	Stock	183.03	183.14	182.75	182.75	12702.0
2020-06-04 04:00:00	NVDA	Stock	8.725	8.725	8.725	8.725	12720.0
2020-06-04 06:00:00	NVDA	Stock	8.7162	8.75	8.7162	8.75	100040.0
2020-06-04 07:00:00	NVDA	Stock	8.721	8.7373	8.721	8.7373	97760.0
2020-06-04 08:00:00	NVDA	Stock	8.725	8.7695	8.7132	8.7275	2505520.0
2020-06-04 09:00:00	NVDA	Stock	8.725	8.8375	8.6775	8.7948	45813360.0
2020-06-04 10:00:00	NVDA	Stock	8.7978	8.9433	8.7788	8.8758	88509960.0
2020-06-04 11:00:00	NVDA	Stock	8.8738	8.8811	8.754	8.8475	63838040.0
2020-06-04 12:00:00	NVDA	Stock	8.8463	8.8508	8.7465	8.7594	38104600.0
2020-06-04 13:00:00	NVDA	Stock	8.7589	8.8345	8.7472	8.819	32083000.0
2020-06-04 14:00:00	NVDA	Stock	8.8186	8.83	8.7082	8.7082	33473800.0
2020-06-04 15:00:00	NVDA	Stock	8.7149	8.7672	8.6972	8.767	63457800.0
2020-06-04 16:00:00	NVDA	Stock	8.7645	8.7665	8.725	8.75	13565880.0
2020-06-04 17:00:00	NVDA	Stock	8.7495	8.765	8.7495	8.7622	211120.0
2020-06-04 18:00:00	NVDA	Stock	8.7645	8.7645	8.7528	8.7632	150000.0
2020-06-04 19:00:00	NVDA	Stock	8.7562	8.7625	8.75	8.756	131640.0
2020-06-04 07:00:00	AMZN	Stock	123.624	123.7445	123.6055	123.7445	21760.0
2020-06-04 08:00:00	AMZN	Stock	123.7245	123.75	123.5314	123.75	39300.0
2020-06-04 09:00:00	AMZN	Stock	123.75	125.377	123.75	124.9407	8216360.0

> showing 50 of 56,917 rows — these rows as CSV

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