PREVIEW / stock_1hour / 2024-03-28

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-03-28.parquet
  size:    1.4 MB
  rows:    60,652
  symbols: 1,064

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
2024-03-28 04:00:00	AAPL	Stock	173.17	173.38	172.7	172.77	9516.0
2024-03-28 05:00:00	AAPL	Stock	172.74	172.8	172.52	172.63	7875.0
2024-03-28 06:00:00	AAPL	Stock	172.72	172.89	172.65	172.75	4903.0
2024-03-28 07:00:00	AAPL	Stock	172.69	172.78	172.4	172.47	21548.0
2024-03-28 08:00:00	AAPL	Stock	172.6457	173.37	172.2	172.49	124600.0
2024-03-28 09:00:00	AAPL	Stock	172.49	172.5399	170.72	171.35	7561996.0
2024-03-28 10:00:00	AAPL	Stock	171.36	171.49	170.51	170.835	8001968.0
2024-03-28 11:00:00	AAPL	Stock	170.835	171.15	170.56	171.11	4462195.0
2024-03-28 12:00:00	AAPL	Stock	171.105	171.35	170.73	171.325	3713973.0
2024-03-28 13:00:00	AAPL	Stock	171.325	171.5	170.89	171.48	3181893.0
2024-03-28 14:00:00	AAPL	Stock	171.485	172.07	171.3	172.065	3701963.0
2024-03-28 15:00:00	AAPL	Stock	172.0641	172.23	171.25	171.48	7958541.0
2024-03-28 16:00:00	AAPL	Stock	171.315	171.48	171.08	171.23	13367842.0
2024-03-28 17:00:00	AAPL	Stock	171.2698	171.39	171.2	171.37	26605.0
2024-03-28 18:00:00	AAPL	Stock	171.3254	171.48	171.19	171.31	17179.0
2024-03-28 19:00:00	AAPL	Stock	171.28	171.3	171.03	171.18	29334.0
2024-03-28 04:00:00	MSFT	Stock	420.98	421.02	420.92	420.99	786.0
2024-03-28 05:00:00	MSFT	Stock	421.05	421.05	420.91	420.95	991.0
2024-03-28 06:00:00	MSFT	Stock	421.27	421.39	421.27	421.39	322.0
2024-03-28 07:00:00	MSFT	Stock	421.38	421.61	421.38	421.61	1597.0
2024-03-28 08:00:00	MSFT	Stock	421.29	422.0	421.04	421.6	15051.0
2024-03-28 09:00:00	MSFT	Stock	421.9	421.9	419.12	420.9	1185910.0
2024-03-28 10:00:00	MSFT	Stock	420.99	421.76	420.43	421.355	1040367.0
2024-03-28 11:00:00	MSFT	Stock	421.31	421.59	420.62	420.92	1026239.0
2024-03-28 12:00:00	MSFT	Stock	420.94	420.97	419.7	420.16	909393.0
2024-03-28 13:00:00	MSFT	Stock	420.14	420.37	419.73	420.2	669322.0
2024-03-28 14:00:00	MSFT	Stock	420.23	421.37	419.965	421.18	636118.0
2024-03-28 15:00:00	MSFT	Stock	421.19	421.87	419.92	420.03	2029773.0
2024-03-28 16:00:00	MSFT	Stock	420.72	421.43	419.67	420.26	7910602.0
2024-03-28 17:00:00	MSFT	Stock	420.25	420.26	419.72	420.0	8103.0
2024-03-28 18:00:00	MSFT	Stock	420.72	420.72	419.95	420.05	3942.0
2024-03-28 19:00:00	MSFT	Stock	420.05	420.2	419.86	419.86	3967.0
2024-03-28 04:00:00	NVDA	Stock	90.101	90.4	89.6	89.7	168510.0
2024-03-28 05:00:00	NVDA	Stock	89.748	89.756	89.45	89.738	94280.0
2024-03-28 06:00:00	NVDA	Stock	89.82	89.86	89.636	89.7	54730.0
2024-03-28 07:00:00	NVDA	Stock	89.774	90.24	89.701	89.945	358020.0
2024-03-28 08:00:00	NVDA	Stock	89.815	90.252	89.48	89.6111	1787190.0
2024-03-28 09:00:00	NVDA	Stock	89.672	91.3	89.193	90.6476	65634210.0
2024-03-28 10:00:00	NVDA	Stock	90.676	91.123	90.012	90.6015	57862950.0
2024-03-28 11:00:00	NVDA	Stock	90.631	90.959	90.294	90.795	34470600.0
2024-03-28 12:00:00	NVDA	Stock	90.8045	90.809	90.415	90.6469	24653960.0
2024-03-28 13:00:00	NVDA	Stock	90.6469	90.753	90.352	90.4	20279480.0
2024-03-28 14:00:00	NVDA	Stock	90.404	90.615	90.18	90.546	27392010.0
2024-03-28 15:00:00	NVDA	Stock	90.5355	90.8	90.188	90.317	43749240.0
2024-03-28 16:00:00	NVDA	Stock	90.27	90.444	90.08	90.204	32358600.0
2024-03-28 17:00:00	NVDA	Stock	90.22	90.268	90.2	90.22	298130.0
2024-03-28 18:00:00	NVDA	Stock	90.222	90.259	90.115	90.144	187920.0
2024-03-28 19:00:00	NVDA	Stock	90.12	90.16	90.09	90.125	279400.0
2024-03-28 04:00:00	AMZN	Stock	179.94	180.14	179.6	179.68	9013.0
2024-03-28 05:00:00	AMZN	Stock	179.66	179.8	179.39	179.5	5344.0

> showing 50 of 60,652 rows — these rows as CSV

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