PREVIEW / stock_1hour / 2021-06-30

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-06-30.parquet
  size:    1.5 MB
  rows:    67,362
  symbols: 2,961

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-30 04:00:00	AAPL	Stock	136.49	136.5	136.11	136.13	15431.0
2021-06-30 05:00:00	AAPL	Stock	136.11	136.11	135.5	135.84	38581.0
2021-06-30 06:00:00	AAPL	Stock	135.88	135.97	135.8	135.8	6039.0
2021-06-30 07:00:00	AAPL	Stock	135.85	136.25	135.75	136.11	89880.0
2021-06-30 08:00:00	AAPL	Stock	136.1201	136.33	135.9696	136.12	193680.0
2021-06-30 09:00:00	AAPL	Stock	136.12	137.02	135.81	136.2	8743999.0
2021-06-30 10:00:00	AAPL	Stock	136.19	137.14	136.17	136.99	7715006.0
2021-06-30 11:00:00	AAPL	Stock	137.0	137.19	136.635	136.7	5266905.0
2021-06-30 12:00:00	AAPL	Stock	136.7	136.93	136.47	136.7093	4381641.0
2021-06-30 13:00:00	AAPL	Stock	136.705	137.05	136.6775	136.985	3446835.0
2021-06-30 14:00:00	AAPL	Stock	136.99	137.04	136.725	136.92	3630953.0
2021-06-30 15:00:00	AAPL	Stock	136.915	137.41	136.85	136.92	11752837.0
2021-06-30 16:00:00	AAPL	Stock	136.92	137.2	136.9	136.93	9730258.0
2021-06-30 17:00:00	AAPL	Stock	136.93	137.05	136.92	137.02	27901.0
2021-06-30 18:00:00	AAPL	Stock	137.02	137.08	137.0	137.08	13800.0
2021-06-30 19:00:00	AAPL	Stock	137.08	137.2	137.01	137.1	45392.0
2021-06-30 04:00:00	MSFT	Stock	271.4	271.4	270.8	270.8	10147.0
2021-06-30 05:00:00	MSFT	Stock	270.51	270.7	270.2	270.7	4915.0
2021-06-30 06:00:00	MSFT	Stock	270.74	270.95	270.74	270.85	4048.0
2021-06-30 07:00:00	MSFT	Stock	270.79	271.16	270.75	270.9	7522.0
2021-06-30 08:00:00	MSFT	Stock	270.8792	272.078	270.6	270.9	24806.0
2021-06-30 09:00:00	MSFT	Stock	270.92	271.04	269.92	270.22	2133930.0
2021-06-30 10:00:00	MSFT	Stock	270.21	271.2885	270.07	271.09	1684737.0
2021-06-30 11:00:00	MSFT	Stock	271.09	271.3598	270.23	270.27	1287528.0
2021-06-30 12:00:00	MSFT	Stock	270.28	270.6	269.6043	270.26	1195524.0
2021-06-30 13:00:00	MSFT	Stock	270.25	270.61	270.17	270.47	813635.0
2021-06-30 14:00:00	MSFT	Stock	270.46	270.64	270.17	270.365	1009109.0
2021-06-30 15:00:00	MSFT	Stock	270.365	271.28	270.25	270.85	3259361.0
2021-06-30 16:00:00	MSFT	Stock	270.9	271.13	270.9	271.07	4373022.0
2021-06-30 17:00:00	MSFT	Stock	270.92	270.98	270.84	270.98	2308.0
2021-06-30 18:00:00	MSFT	Stock	270.9	270.91	270.9	270.91	300.0
2021-06-30 19:00:00	MSFT	Stock	270.9999	271.01	270.97	271.01	1581.0
2021-06-30 04:00:00	NVDA	Stock	20.0662	20.0662	19.9833	19.9833	74040.0
2021-06-30 05:00:00	NVDA	Stock	19.912	19.9143	19.905	19.9143	28000.0
2021-06-30 06:00:00	NVDA	Stock	19.925	19.95	19.925	19.9493	42600.0
2021-06-30 07:00:00	NVDA	Stock	19.9615	19.995	19.94	19.975	263240.0
2021-06-30 08:00:00	NVDA	Stock	19.9525	19.9929	19.9402	19.954	532720.0
2021-06-30 09:00:00	NVDA	Stock	19.947	20.1625	19.94	19.9878	42075000.0
2021-06-30 10:00:00	NVDA	Stock	19.9931	20.025	19.9128	19.9838	30091080.0
2021-06-30 11:00:00	NVDA	Stock	19.984	19.9933	19.8785	19.92	20303720.0
2021-06-30 12:00:00	NVDA	Stock	19.9227	19.9797	19.8638	19.9308	14258640.0
2021-06-30 13:00:00	NVDA	Stock	19.9302	20.0167	19.9265	19.9849	14407560.0
2021-06-30 14:00:00	NVDA	Stock	19.9875	20.041	19.9305	20.037	15215440.0
2021-06-30 15:00:00	NVDA	Stock	20.039	20.1388	19.998	20.0025	50185320.0
2021-06-30 16:00:00	NVDA	Stock	20.0025	20.0168	19.9753	20.002	24512200.0
2021-06-30 17:00:00	NVDA	Stock	20.0038	20.0038	19.9875	19.9985	212560.0
2021-06-30 18:00:00	NVDA	Stock	19.996	20.0	19.996	20.0	62840.0
2021-06-30 19:00:00	NVDA	Stock	19.9875	20.0028	19.9755	19.9755	99920.0
2021-06-30 04:00:00	AMZN	Stock	171.9	171.9	171.6	171.6	8000.0
2021-06-30 07:00:00	AMZN	Stock	171.9005	172.3185	171.9005	172.3185	16660.0

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

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