PREVIEW / stock_1hour / 2021-05-24

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-05-24.parquet
  size:    1.4 MB
  rows:    64,305
  symbols: 2,945

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
2021-05-24 04:00:00	AAPL	Stock	125.86	126.08	125.72	125.9	12056.0
2021-05-24 05:00:00	AAPL	Stock	125.9	126.5	125.9	126.5	16938.0
2021-05-24 06:00:00	AAPL	Stock	126.36	126.4	126.16	126.27	11422.0
2021-05-24 07:00:00	AAPL	Stock	126.18	126.35	125.89	126.12	115413.0
2021-05-24 08:00:00	AAPL	Stock	126.1499	126.32	125.9	126.2	320683.0
2021-05-24 09:00:00	AAPL	Stock	126.21	127.04	125.91	126.655	9676370.0
2021-05-24 10:00:00	AAPL	Stock	126.67	127.66	126.66	127.5323	10732762.0
2021-05-24 11:00:00	AAPL	Stock	127.535	127.68	127.38	127.54	6117474.0
2021-05-24 12:00:00	AAPL	Stock	127.5373	127.7802	127.33	127.44	4925351.0
2021-05-24 13:00:00	AAPL	Stock	127.44	127.6899	127.3684	127.6012	3393886.0
2021-05-24 14:00:00	AAPL	Stock	127.61	127.94	127.5905	127.765	4464348.0
2021-05-24 15:00:00	AAPL	Stock	127.77	127.91	127.0	127.11	9570812.0
2021-05-24 16:00:00	AAPL	Stock	127.1	127.17	126.9999	127.08	6861416.0
2021-05-24 17:00:00	AAPL	Stock	127.07	127.1	127.01	127.07	50070.0
2021-05-24 18:00:00	AAPL	Stock	127.07	127.21	127.03	127.2	45566.0
2021-05-24 19:00:00	AAPL	Stock	127.2	127.35	127.18	127.29	66822.0
2021-05-24 04:00:00	MSFT	Stock	246.31	246.75	246.3	246.3	2698.0
2021-05-24 05:00:00	MSFT	Stock	246.52	246.7	246.42	246.5	3673.0
2021-05-24 06:00:00	MSFT	Stock	246.61	246.61	246.5	246.5	335.0
2021-05-24 07:00:00	MSFT	Stock	246.55	246.7	246.08	246.7	15844.0
2021-05-24 08:00:00	MSFT	Stock	246.69	247.0	244.558	246.8	121467.0
2021-05-24 09:00:00	MSFT	Stock	246.85	250.04	246.85	249.64	3021681.0
2021-05-24 10:00:00	MSFT	Stock	249.64	250.6899	249.63	250.42	2257421.0
2021-05-24 11:00:00	MSFT	Stock	250.42	250.86	250.24	250.65	1362864.0
2021-05-24 12:00:00	MSFT	Stock	250.65	251.04	250.05	250.28	1202109.0
2021-05-24 13:00:00	MSFT	Stock	250.2701	250.77	250.0958	250.61	947133.0
2021-05-24 14:00:00	MSFT	Stock	250.6	251.16	250.55	250.955	1194829.0
2021-05-24 15:00:00	MSFT	Stock	250.955	251.0759	250.53	250.85	2742750.0
2021-05-24 16:00:00	MSFT	Stock	250.78	251.0	250.465	251.0	4246218.0
2021-05-24 17:00:00	MSFT	Stock	251.0	251.0	250.8	250.8	3844.0
2021-05-24 18:00:00	MSFT	Stock	250.81	251.05	250.81	250.86	3831.0
2021-05-24 19:00:00	MSFT	Stock	251.04	251.2	251.03	251.06	1583.0
2021-05-24 04:00:00	NVDA	Stock	15.1975	15.1975	15.1542	15.1625	159280.0
2021-05-24 05:00:00	NVDA	Stock	15.1613	15.175	15.1575	15.1625	69280.0
2021-05-24 06:00:00	NVDA	Stock	15.1625	15.175	15.1625	15.17	73960.0
2021-05-24 07:00:00	NVDA	Stock	15.1705	15.1875	15.1528	15.1625	1109760.0
2021-05-24 08:00:00	NVDA	Stock	15.171	15.1875	15.1378	15.1755	2283360.0
2021-05-24 09:00:00	NVDA	Stock	15.1755	15.4425	15.175	15.403	82670560.0
2021-05-24 10:00:00	NVDA	Stock	15.4072	15.6185	15.4	15.5522	82567400.0
2021-05-24 11:00:00	NVDA	Stock	15.552	15.662	15.5488	15.6235	35930400.0
2021-05-24 12:00:00	NVDA	Stock	15.625	15.6675	15.6152	15.6353	20999000.0
2021-05-24 13:00:00	NVDA	Stock	15.6405	15.745	15.6405	15.7238	32865760.0
2021-05-24 14:00:00	NVDA	Stock	15.725	15.744	15.6838	15.6982	33717720.0
2021-05-24 15:00:00	NVDA	Stock	15.6961	15.7122	15.595	15.612	48242320.0
2021-05-24 16:00:00	NVDA	Stock	15.612	15.6742	15.6002	15.6692	17925800.0
2021-05-24 17:00:00	NVDA	Stock	15.6685	15.6698	15.6632	15.6695	130120.0
2021-05-24 18:00:00	NVDA	Stock	15.6682	15.7062	15.666	15.7062	233680.0
2021-05-24 19:00:00	NVDA	Stock	15.706	15.725	15.6882	15.725	749160.0
2021-05-24 05:00:00	AMZN	Stock	160.7085	160.7085	160.6985	160.699	8000.0
2021-05-24 06:00:00	AMZN	Stock	160.725	160.9285	160.725	160.9285	9860.0

> showing 50 of 64,305 rows — these rows as CSV

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