PREVIEW / stock_1hour / 2021-06-01

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-06-01.parquet
  size:    1.4 MB
  rows:    67,503
  symbols: 2,981

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-06-01 04:00:00	AAPL	Stock	124.65	125.36	124.65	125.25	26250.0
2021-06-01 05:00:00	AAPL	Stock	125.23	125.33	125.21	125.27	11055.0
2021-06-01 06:00:00	AAPL	Stock	125.37	125.56	125.2	125.25	12462.0
2021-06-01 07:00:00	AAPL	Stock	125.25	125.3	125.06	125.1	85239.0
2021-06-01 08:00:00	AAPL	Stock	125.12	125.28	125.03	125.12	287403.0
2021-06-01 09:00:00	AAPL	Stock	125.12	125.35	124.44	124.64	10076158.0
2021-06-01 10:00:00	AAPL	Stock	124.64	124.82	123.94	124.425	11746122.0
2021-06-01 11:00:00	AAPL	Stock	124.42	124.83	124.34	124.7199	6394270.0
2021-06-01 12:00:00	AAPL	Stock	124.72	124.85	124.36	124.8397	5082896.0
2021-06-01 13:00:00	AAPL	Stock	124.8389	124.84	124.46	124.58	3841676.0
2021-06-01 14:00:00	AAPL	Stock	124.575	125.0	124.53	124.88	4304342.0
2021-06-01 15:00:00	AAPL	Stock	124.875	124.8971	124.2	124.3	8027290.0
2021-06-01 16:00:00	AAPL	Stock	124.27	124.94	124.05	124.19	5211024.0
2021-06-01 17:00:00	AAPL	Stock	124.2	124.23	124.18	124.19	50110.0
2021-06-01 18:00:00	AAPL	Stock	124.18	124.2	124.1	124.12	48774.0
2021-06-01 19:00:00	AAPL	Stock	124.13	124.15	124.0	124.06	85468.0
2021-06-01 04:00:00	MSFT	Stock	250.93	251.35	250.83	251.35	2905.0
2021-06-01 05:00:00	MSFT	Stock	251.3	251.3	251.29	251.29	515.0
2021-06-01 06:00:00	MSFT	Stock	251.0	251.0	250.31	250.6	5163.0
2021-06-01 07:00:00	MSFT	Stock	250.46	250.98	250.27	250.7	13032.0
2021-06-01 08:00:00	MSFT	Stock	250.7477	250.98	249.056	250.26	24302.0
2021-06-01 09:00:00	MSFT	Stock	250.3	251.4	249.43	250.0175	2247537.0
2021-06-01 10:00:00	MSFT	Stock	250.01	250.06	247.68	247.95	2596344.0
2021-06-01 11:00:00	MSFT	Stock	247.94	248.63	247.67	248.33	1592090.0
2021-06-01 12:00:00	MSFT	Stock	248.335	248.385	247.78	248.035	1330114.0
2021-06-01 13:00:00	MSFT	Stock	248.03	248.28	247.7	248.2686	1102214.0
2021-06-01 14:00:00	MSFT	Stock	248.26	248.4799	248.01	248.43	1416361.0
2021-06-01 15:00:00	MSFT	Stock	248.43	248.44	246.96	247.38	2720974.0
2021-06-01 16:00:00	MSFT	Stock	247.4	247.55	247.22	247.4851	2446893.0
2021-06-01 17:00:00	MSFT	Stock	247.45	247.6	247.4	247.4336	3144.0
2021-06-01 18:00:00	MSFT	Stock	247.45	247.45	247.02	247.26	6308.0
2021-06-01 19:00:00	MSFT	Stock	247.18	247.39	247.0	247.35	6131.0
2021-06-01 04:00:00	NVDA	Stock	16.255	16.3625	16.255	16.3625	308200.0
2021-06-01 05:00:00	NVDA	Stock	16.3562	16.3875	16.3562	16.3748	55160.0
2021-06-01 06:00:00	NVDA	Stock	16.3562	16.3562	16.35	16.3562	75240.0
2021-06-01 07:00:00	NVDA	Stock	16.3375	16.3622	16.3125	16.3375	1278640.0
2021-06-01 08:00:00	NVDA	Stock	16.3263	16.3662	16.2445	16.2775	1772040.0
2021-06-01 09:00:00	NVDA	Stock	16.2868	16.3048	16.0325	16.1083	68385680.0
2021-06-01 10:00:00	NVDA	Stock	16.114	16.1162	15.9032	16.0125	70698720.0
2021-06-01 11:00:00	NVDA	Stock	16.0118	16.1188	15.9821	16.1073	24709200.0
2021-06-01 12:00:00	NVDA	Stock	16.1092	16.1663	16.0755	16.1308	17580200.0
2021-06-01 13:00:00	NVDA	Stock	16.1302	16.1415	16.0638	16.1238	14541480.0
2021-06-01 14:00:00	NVDA	Stock	16.123	16.3881	16.1083	16.3663	47246080.0
2021-06-01 15:00:00	NVDA	Stock	16.3662	16.3688	16.25	16.2648	40561120.0
2021-06-01 16:00:00	NVDA	Stock	16.2645	16.275	16.25	16.265	20126120.0
2021-06-01 17:00:00	NVDA	Stock	16.2665	16.2688	16.225	16.225	313560.0
2021-06-01 18:00:00	NVDA	Stock	16.2252	16.2252	16.205	16.2182	62200.0
2021-06-01 19:00:00	NVDA	Stock	16.2	16.2175	16.158	16.175	406040.0
2021-06-01 04:00:00	AMZN	Stock	161.9005	161.9005	161.9	161.9	15400.0
2021-06-01 05:00:00	AMZN	Stock	162.05	162.05	162.05	162.05	2000.0

> showing 50 of 67,503 rows — these rows as CSV

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