PREVIEW / stock_1hour / 2023-07-03

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-07-03.parquet
  size:    984 KB
  rows:    41,286
  symbols: 1,481

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
2023-07-03 04:00:00	AAPL	Stock	193.99	194.25	193.71	193.71	47743.0
2023-07-03 05:00:00	AAPL	Stock	193.72	193.8	193.54	193.62	18651.0
2023-07-03 06:00:00	AAPL	Stock	193.63	193.63	193.0	193.22	15631.0
2023-07-03 07:00:00	AAPL	Stock	193.31	193.65	193.22	193.41	99939.0
2023-07-03 08:00:00	AAPL	Stock	193.43	195.27	193.2	193.53	299836.0
2023-07-03 09:00:00	AAPL	Stock	193.51	193.95	192.8	192.94	6957960.0
2023-07-03 10:00:00	AAPL	Stock	192.93	193.15	191.76	191.979	7409437.0
2023-07-03 11:00:00	AAPL	Stock	191.975	192.5	191.91	192.23	4517702.0
2023-07-03 12:00:00	AAPL	Stock	192.225	192.55	192.01	192.47	4175619.0
2023-07-03 13:00:00	AAPL	Stock	192.46	192.57	192.04	192.45	2762301.0
2023-07-03 14:00:00	AAPL	Stock	192.38	192.52	192.36	192.43	45849.0
2023-07-03 15:00:00	AAPL	Stock	192.43	192.46	192.33	192.41	26279.0
2023-07-03 16:00:00	AAPL	Stock	192.39	192.45	192.38	192.45	8434.0
2023-07-03 04:00:00	MSFT	Stock	340.65	341.21	340.54	340.9	6051.0
2023-07-03 05:00:00	MSFT	Stock	340.77	340.79	340.18	340.5	2151.0
2023-07-03 06:00:00	MSFT	Stock	340.56	340.56	339.05	339.68	3436.0
2023-07-03 07:00:00	MSFT	Stock	339.9	340.05	339.11	339.59	14791.0
2023-07-03 08:00:00	MSFT	Stock	339.86	342.42	339.22	339.89	32469.0
2023-07-03 09:00:00	MSFT	Stock	339.71	340.9	338.16	339.66	2265292.0
2023-07-03 10:00:00	MSFT	Stock	339.69	340.36	336.91	336.95	2090091.0
2023-07-03 11:00:00	MSFT	Stock	336.955	337.462	336.571	336.9068	1544000.0
2023-07-03 12:00:00	MSFT	Stock	336.93	338.33	336.765	337.98	1409853.0
2023-07-03 13:00:00	MSFT	Stock	337.99	338.27	337.48	337.5	1439690.0
2023-07-03 14:00:00	MSFT	Stock	337.6488	337.99	337.6003	337.845	13210.0
2023-07-03 15:00:00	MSFT	Stock	337.85	338.09	337.8	337.97	1027.0
2023-07-03 16:00:00	MSFT	Stock	337.99	338.0	337.98	337.99	1649.0
2023-07-03 04:00:00	NVDA	Stock	42.41	42.768	42.41	42.718	159830.0
2023-07-03 05:00:00	NVDA	Stock	42.722	42.75	42.712	42.747	18680.0
2023-07-03 06:00:00	NVDA	Stock	42.729	42.74	42.555	42.713	222430.0
2023-07-03 07:00:00	NVDA	Stock	42.633	42.68	42.43	42.469	385070.0
2023-07-03 08:00:00	NVDA	Stock	42.515	42.919	42.302	42.55	1158280.0
2023-07-03 09:00:00	NVDA	Stock	42.542	42.898	42.412	42.48	37989140.0
2023-07-03 10:00:00	NVDA	Stock	42.4755	42.823	42.334	42.622	43756540.0
2023-07-03 11:00:00	NVDA	Stock	42.619	42.6595	42.235	42.387	29917600.0
2023-07-03 12:00:00	NVDA	Stock	42.3895	42.437	42.202	42.412	27699940.0
2023-07-03 13:00:00	NVDA	Stock	42.413	42.48	42.335	42.4	8092150.0
2023-07-03 14:00:00	NVDA	Stock	42.388	42.398	42.37	42.371	51220.0
2023-07-03 15:00:00	NVDA	Stock	42.37	42.434	42.362	42.42	145250.0
2023-07-03 16:00:00	NVDA	Stock	42.41	42.415	42.397	42.405	37350.0
2023-07-03 04:00:00	AMZN	Stock	130.11	130.91	130.11	130.5	17248.0
2023-07-03 05:00:00	AMZN	Stock	130.53	130.73	130.5	130.5	7398.0
2023-07-03 06:00:00	AMZN	Stock	130.62	130.66	130.12	130.12	32184.0
2023-07-03 07:00:00	AMZN	Stock	130.3	130.45	130.15	130.22	50421.0
2023-07-03 08:00:00	AMZN	Stock	130.15	130.75	130.15	130.4	111283.0
2023-07-03 09:00:00	AMZN	Stock	130.38	131.42	130.03	131.21	5960565.0
2023-07-03 10:00:00	AMZN	Stock	131.22	131.85	130.53	131.02	6319490.0
2023-07-03 11:00:00	AMZN	Stock	131.03	131.41	130.62	130.7427	3737257.0
2023-07-03 12:00:00	AMZN	Stock	130.74	130.925	130.065	130.25	4548556.0
2023-07-03 13:00:00	AMZN	Stock	130.25	130.45	130.18	130.27	2634673.0
2023-07-03 14:00:00	AMZN	Stock	130.3	130.48	130.22	130.4	283171.0

> showing 50 of 41,286 rows — these rows as CSV

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