PREVIEW / stock_1hour / 2020-04-16

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-04-16.parquet
  size:    1.2 MB
  rows:    55,844
  symbols: 2,389

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-04-16 04:00:00	AAPL	Stock	71.9175	72.1725	71.9175	72.11	50464.0
2020-04-16 05:00:00	AAPL	Stock	71.89	72.0475	71.85	72.025	11572.0
2020-04-16 06:00:00	AAPL	Stock	72.025	72.2525	71.9525	72.15	43112.0
2020-04-16 07:00:00	AAPL	Stock	72.0875	72.125	71.67	71.7375	280076.0
2020-04-16 08:00:00	AAPL	Stock	71.9375	72.2125	71.285	72.015	1027244.0
2020-04-16 09:00:00	AAPL	Stock	72.045	72.25	71.265	71.3025	19055944.0
2020-04-16 10:00:00	AAPL	Stock	71.3075	71.705	70.8825	71.6625	23119964.0
2020-04-16 11:00:00	AAPL	Stock	71.67	71.9725	71.4525	71.7025	15324064.0
2020-04-16 12:00:00	AAPL	Stock	71.6875	71.75	70.5875	70.985	14943748.0
2020-04-16 13:00:00	AAPL	Stock	70.99	71.2475	70.815	70.89	9557556.0
2020-04-16 14:00:00	AAPL	Stock	70.8975	71.2975	70.7113	71.162	12287432.0
2020-04-16 15:00:00	AAPL	Stock	71.154	71.8025	70.95	71.68	20455164.0
2020-04-16 16:00:00	AAPL	Stock	71.6102	72.3	71.4355	72.3	11779820.0
2020-04-16 17:00:00	AAPL	Stock	72.305	73.35	72.25	73.25	880956.0
2020-04-16 18:00:00	AAPL	Stock	73.2725	73.8875	72.785	73.775	803580.0
2020-04-16 19:00:00	AAPL	Stock	73.81	74.2125	73.5925	73.8425	774480.0
2020-04-16 04:00:00	MSFT	Stock	173.66	174.47	173.66	174.11	14956.0
2020-04-16 05:00:00	MSFT	Stock	174.1	174.68	173.5	174.35	38413.0
2020-04-16 06:00:00	MSFT	Stock	174.31	175.0	174.08	174.85	67143.0
2020-04-16 07:00:00	MSFT	Stock	174.85	175.0	173.51	173.82	197946.0
2020-04-16 08:00:00	MSFT	Stock	174.551	174.94	172.3	174.58	183905.0
2020-04-16 09:00:00	MSFT	Stock	174.58	175.38	173.52	173.66	5311518.0
2020-04-16 10:00:00	MSFT	Stock	173.7	175.0	172.9	174.89	5752515.0
2020-04-16 11:00:00	MSFT	Stock	174.9	176.74	174.71	176.47	6175360.0
2020-04-16 12:00:00	MSFT	Stock	176.48	176.66	173.12	174.11	4871188.0
2020-04-16 13:00:00	MSFT	Stock	174.107	175.0	173.77	174.48	2932602.0
2020-04-16 14:00:00	MSFT	Stock	174.48	176.1	173.969	175.47	4201133.0
2020-04-16 15:00:00	MSFT	Stock	175.46	177.28	175.01	177.07	7335140.0
2020-04-16 16:00:00	MSFT	Stock	176.8	179.35	174.116	179.25	6017372.0
2020-04-16 17:00:00	MSFT	Stock	179.14	180.05	179.0	179.65	237477.0
2020-04-16 18:00:00	MSFT	Stock	179.78	181.6	179.11	181.15	130838.0
2020-04-16 19:00:00	MSFT	Stock	181.2	182.62	180.2	181.0	135338.0
2020-04-16 04:00:00	NVDA	Stock	7.1172	7.14	7.1168	7.14	41080.0
2020-04-16 05:00:00	NVDA	Stock	7.1168	7.1378	7.1158	7.1375	85040.0
2020-04-16 06:00:00	NVDA	Stock	7.1375	7.1625	7.1375	7.1625	83120.0
2020-04-16 07:00:00	NVDA	Stock	7.1638	7.175	7.1125	7.1388	1630800.0
2020-04-16 08:00:00	NVDA	Stock	7.1738	7.2125	7.0035	7.175	2395920.0
2020-04-16 09:00:00	NVDA	Stock	7.175	7.3108	7.1638	7.3	94831880.0
2020-04-16 10:00:00	NVDA	Stock	7.2968	7.4073	7.2085	7.3862	111678360.0
2020-04-16 11:00:00	NVDA	Stock	7.3882	7.475	7.3758	7.4464	87303240.0
2020-04-16 12:00:00	NVDA	Stock	7.4458	7.4528	7.2382	7.3155	96939240.0
2020-04-16 13:00:00	NVDA	Stock	7.3145	7.3438	7.2402	7.2585	66680760.0
2020-04-16 14:00:00	NVDA	Stock	7.2575	7.365	7.245	7.333	64686560.0
2020-04-16 15:00:00	NVDA	Stock	7.3328	7.392	7.2728	7.3698	79117920.0
2020-04-16 16:00:00	NVDA	Stock	7.3675	7.4275	7.3252	7.425	26518640.0
2020-04-16 17:00:00	NVDA	Stock	7.4358	7.5	7.4275	7.5	3360720.0
2020-04-16 18:00:00	NVDA	Stock	7.4945	7.58	7.45	7.554	3068000.0
2020-04-16 19:00:00	NVDA	Stock	7.5688	7.5998	7.5628	7.59	1366200.0
2020-04-16 04:00:00	AMZN	Stock	117.05	117.4	116.9445	117.018	25780.0
2020-04-16 05:00:00	AMZN	Stock	116.95	117.05	116.85	116.997	27140.0

> showing 50 of 55,844 rows — these rows as CSV

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