PREVIEW / stock_1hour / 2022-08-05

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-05.parquet
  size:    1.4 MB
  rows:    62,750
  symbols: 2,242

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
2022-08-05 04:00:00	AAPL	Stock	166.0	166.2	165.5	165.58	6396.0
2022-08-05 05:00:00	AAPL	Stock	165.62	165.7	165.02	165.6	6998.0
2022-08-05 06:00:00	AAPL	Stock	165.39	165.39	165.08	165.27	11234.0
2022-08-05 07:00:00	AAPL	Stock	165.34	165.77	165.2	165.72	30757.0
2022-08-05 08:00:00	AAPL	Stock	165.36	165.79	163.31	163.59	945150.0
2022-08-05 09:00:00	AAPL	Stock	163.56	165.58	162.8	164.74	7547265.0
2022-08-05 10:00:00	AAPL	Stock	164.77	165.85	164.485	164.75	7252787.0
2022-08-05 11:00:00	AAPL	Stock	164.74	164.7985	163.39	164.174	6139741.0
2022-08-05 12:00:00	AAPL	Stock	164.18	165.02	164.09	164.915	4707093.0
2022-08-05 13:00:00	AAPL	Stock	164.91	165.45	164.52	164.7302	4724043.0
2022-08-05 14:00:00	AAPL	Stock	164.73	165.0	164.37	164.66	3670644.0
2022-08-05 15:00:00	AAPL	Stock	164.6586	165.42	164.5	165.34	7615877.0
2022-08-05 16:00:00	AAPL	Stock	165.34	165.42	165.14	165.25	5858744.0
2022-08-05 17:00:00	AAPL	Stock	165.25	165.27	165.2	165.22	17124.0
2022-08-05 18:00:00	AAPL	Stock	165.18	165.21	165.03	165.1	12827.0
2022-08-05 19:00:00	AAPL	Stock	165.1	165.12	164.9	164.9	22496.0
2022-08-05 04:00:00	MSFT	Stock	284.03	284.1	283.85	283.85	1524.0
2022-08-05 05:00:00	MSFT	Stock	283.42	283.99	283.01	283.56	1794.0
2022-08-05 06:00:00	MSFT	Stock	283.98	283.98	283.46	283.46	1934.0
2022-08-05 07:00:00	MSFT	Stock	283.77	283.87	283.18	283.87	4170.0
2022-08-05 08:00:00	MSFT	Stock	283.22	285.11	279.5	280.0	165716.0
2022-08-05 09:00:00	MSFT	Stock	280.0	281.91	278.41	281.4869	1984385.0
2022-08-05 10:00:00	MSFT	Stock	281.51	283.65	281.084	282.136	1671633.0
2022-08-05 11:00:00	MSFT	Stock	282.13	282.1821	279.41	280.13	1633474.0
2022-08-05 12:00:00	MSFT	Stock	280.17	281.62	280.02	281.48	815699.0
2022-08-05 13:00:00	MSFT	Stock	281.47	282.7	281.33	282.04	821862.0
2022-08-05 14:00:00	MSFT	Stock	282.04	282.41	281.2829	281.7501	691145.0
2022-08-05 15:00:00	MSFT	Stock	281.75	283.2	281.42	282.86	1865659.0
2022-08-05 16:00:00	MSFT	Stock	282.85	283.14	282.513	282.75	2869620.0
2022-08-05 17:00:00	MSFT	Stock	282.71	282.8	282.71	282.72	2019.0
2022-08-05 18:00:00	MSFT	Stock	282.74	282.8	282.72	282.8	1322.0
2022-08-05 19:00:00	MSFT	Stock	282.8	282.8	282.7	282.7	2673.0
2022-08-05 04:00:00	NVDA	Stock	19.298	19.298	19.183	19.191	42870.0
2022-08-05 05:00:00	NVDA	Stock	19.17	19.183	19.08	19.111	56280.0
2022-08-05 06:00:00	NVDA	Stock	19.101	19.101	19.09	19.1	25440.0
2022-08-05 07:00:00	NVDA	Stock	19.1	19.188	19.1	19.18	193560.0
2022-08-05 08:00:00	NVDA	Stock	19.148	19.368	18.723	18.77	3870090.0
2022-08-05 09:00:00	NVDA	Stock	18.762	19.01	18.725	18.8627	48181480.0
2022-08-05 10:00:00	NVDA	Stock	18.865	19.2289	18.81	19.048	56759210.0
2022-08-05 11:00:00	NVDA	Stock	19.046	19.054	18.666	18.7625	45915730.0
2022-08-05 12:00:00	NVDA	Stock	18.765	18.952	18.74	18.936	30596040.0
2022-08-05 13:00:00	NVDA	Stock	18.9373	19.08	18.875	18.9182	33182170.0
2022-08-05 14:00:00	NVDA	Stock	18.919	18.977	18.845	18.9015	28262200.0
2022-08-05 15:00:00	NVDA	Stock	18.9014	19.019	18.85	18.989	44042080.0
2022-08-05 16:00:00	NVDA	Stock	18.991	19.003	18.93	18.983	15356280.0
2022-08-05 17:00:00	NVDA	Stock	18.989	18.989	18.9264	18.935	209990.0
2022-08-05 18:00:00	NVDA	Stock	18.926	18.935	18.915	18.927	99650.0
2022-08-05 19:00:00	NVDA	Stock	18.922	18.922	18.875	18.9	80120.0
2022-08-05 04:00:00	AMZN	Stock	142.57	143.0	142.57	142.73	7272.0
2022-08-05 05:00:00	AMZN	Stock	142.72	142.76	142.52	142.65	3705.0

> showing 50 of 62,750 rows — these rows as CSV

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