PREVIEW / stock_1hour / 2023-01-04

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-01-04.parquet
  size:    1.4 MB
  rows:    61,453
  symbols: 1,959

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-01-04 04:00:00	AAPL	Stock	125.9	126.4	125.66	126.24	72694.0
2023-01-04 05:00:00	AAPL	Stock	126.21	126.68	125.91	126.15	41091.0
2023-01-04 06:00:00	AAPL	Stock	126.13	126.5	126.13	126.3	28950.0
2023-01-04 07:00:00	AAPL	Stock	126.25	126.25	125.53	125.86	119269.0
2023-01-04 08:00:00	AAPL	Stock	126.071	126.66	125.38	126.33	519870.0
2023-01-04 09:00:00	AAPL	Stock	126.28	127.555	125.94	126.66	12634517.0
2023-01-04 10:00:00	AAPL	Stock	126.64	127.34	125.08	126.99	13172313.0
2023-01-04 11:00:00	AAPL	Stock	126.96	128.44	126.5	127.77	9499023.0
2023-01-04 12:00:00	AAPL	Stock	127.77	128.6557	127.23	127.23	5751692.0
2023-01-04 13:00:00	AAPL	Stock	127.235	127.5	126.93	127.191	4441387.0
2023-01-04 14:00:00	AAPL	Stock	127.17	127.87	125.38	126.4734	11372184.0
2023-01-04 15:00:00	AAPL	Stock	126.47	126.85	125.28	126.38	11576465.0
2023-01-04 16:00:00	AAPL	Stock	126.38	126.68	126.15	126.17	7463020.0
2023-01-04 17:00:00	AAPL	Stock	126.18	127.74	126.11	127.54	300172.0
2023-01-04 18:00:00	AAPL	Stock	127.52	127.52	126.36	127.0	141023.0
2023-01-04 19:00:00	AAPL	Stock	127.01	127.08	126.61	126.65	72270.0
2023-01-04 04:00:00	MSFT	Stock	236.98	241.0	234.64	234.8	88279.0
2023-01-04 05:00:00	MSFT	Stock	234.85	235.0	234.01	234.34	24047.0
2023-01-04 06:00:00	MSFT	Stock	234.57	235.0	234.38	235.0	24285.0
2023-01-04 07:00:00	MSFT	Stock	235.0	235.4	232.81	233.34	103420.0
2023-01-04 08:00:00	MSFT	Stock	234.9996	238.982	232.7	232.83	229582.0
2023-01-04 09:00:00	MSFT	Stock	232.86	233.91	228.295	229.01	6357492.0
2023-01-04 10:00:00	MSFT	Stock	228.98	229.47	226.0	227.58	7369583.0
2023-01-04 11:00:00	MSFT	Stock	227.555	229.7999	226.73	228.85	5208744.0
2023-01-04 12:00:00	MSFT	Stock	228.86	229.76	227.96	227.97	2982484.0
2023-01-04 13:00:00	MSFT	Stock	227.97	229.19	227.412	228.57	2355748.0
2023-01-04 14:00:00	MSFT	Stock	228.615	229.43	225.96	228.11	3983442.0
2023-01-04 15:00:00	MSFT	Stock	228.12	229.35	226.54	229.1	5715531.0
2023-01-04 16:00:00	MSFT	Stock	229.1	229.4262	228.76	229.1484	4847377.0
2023-01-04 17:00:00	MSFT	Stock	229.12	229.2	229.01	229.1	16721.0
2023-01-04 18:00:00	MSFT	Stock	229.06	229.1	228.5	228.55	209012.0
2023-01-04 19:00:00	MSFT	Stock	228.51	228.51	228.0	228.0	19042.0
2023-01-04 04:00:00	NVDA	Stock	14.415	14.514	14.308	14.482	111960.0
2023-01-04 05:00:00	NVDA	Stock	14.499	14.521	14.445	14.467	50020.0
2023-01-04 06:00:00	NVDA	Stock	14.518	14.54	14.514	14.53	67150.0
2023-01-04 07:00:00	NVDA	Stock	14.5	14.537	14.475	14.5	348410.0
2023-01-04 08:00:00	NVDA	Stock	14.48	14.615	14.425	14.601	1203480.0
2023-01-04 09:00:00	NVDA	Stock	14.608	14.814	14.454	14.538	65414590.0
2023-01-04 10:00:00	NVDA	Stock	14.523	14.613	14.241	14.406	58991080.0
2023-01-04 11:00:00	NVDA	Stock	14.405	14.779	14.3619	14.669	44839900.0
2023-01-04 12:00:00	NVDA	Stock	14.67	14.768	14.6014	14.649	29848450.0
2023-01-04 13:00:00	NVDA	Stock	14.6485	14.8113	14.62	14.749	29401690.0
2023-01-04 14:00:00	NVDA	Stock	14.753	14.853	14.536	14.77	53834940.0
2023-01-04 15:00:00	NVDA	Stock	14.771	14.83	14.571	14.755	57251380.0
2023-01-04 16:00:00	NVDA	Stock	14.749	14.799	14.7285	14.74	22389020.0
2023-01-04 17:00:00	NVDA	Stock	14.745	14.788	14.74	14.771	228530.0
2023-01-04 18:00:00	NVDA	Stock	14.757	14.757	14.739	14.747	123820.0
2023-01-04 19:00:00	NVDA	Stock	14.747	14.769	14.73	14.759	216770.0
2023-01-04 04:00:00	AMZN	Stock	86.85	87.0	86.4	86.94	42796.0
2023-01-04 05:00:00	AMZN	Stock	86.85	86.94	86.53	86.79	22800.0

> showing 50 of 61,453 rows — these rows as CSV

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