PREVIEW / stock_1hour / 2022-03-28

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-28.parquet
  size:    1.4 MB
  rows:    64,431
  symbols: 2,508

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-03-28 04:00:00	AAPL	Stock	174.0	174.0	171.34	172.1	249600.0
2022-03-28 05:00:00	AAPL	Stock	172.1	172.1	170.73	171.44	69761.0
2022-03-28 06:00:00	AAPL	Stock	171.5	171.52	171.0	171.33	53203.0
2022-03-28 07:00:00	AAPL	Stock	171.49	173.07	171.45	172.49	463776.0
2022-03-28 08:00:00	AAPL	Stock	172.6701	174.284	171.6	172.16	1007374.0
2022-03-28 09:00:00	AAPL	Stock	172.16	175.005	171.85	174.4818	12763019.0
2022-03-28 10:00:00	AAPL	Stock	174.48	175.0	173.62	174.97	12449371.0
2022-03-28 11:00:00	AAPL	Stock	174.96	175.005	173.1	173.1512	9652583.0
2022-03-28 12:00:00	AAPL	Stock	173.16	174.09	173.08	174.04	6111495.0
2022-03-28 13:00:00	AAPL	Stock	174.05	174.61	173.91	174.425	5803684.0
2022-03-28 14:00:00	AAPL	Stock	174.43	175.06	174.3316	175.0471	7978006.0
2022-03-28 15:00:00	AAPL	Stock	175.045	175.73	174.7439	175.59	15689113.0
2022-03-28 16:00:00	AAPL	Stock	175.59	175.75	175.51	175.6	6463715.0
2022-03-28 17:00:00	AAPL	Stock	175.62	175.63	175.46	175.52	56781.0
2022-03-28 18:00:00	AAPL	Stock	175.48	175.5	175.4	175.44	26690.0
2022-03-28 19:00:00	AAPL	Stock	175.44	175.47	175.25	175.46	70584.0
2022-03-28 04:00:00	MSFT	Stock	304.03	304.03	303.06	303.55	6063.0
2022-03-28 05:00:00	MSFT	Stock	303.49	303.5	302.8	303.3	3123.0
2022-03-28 06:00:00	MSFT	Stock	303.48	303.5	302.99	303.31	3884.0
2022-03-28 07:00:00	MSFT	Stock	303.5	304.48	303.5	304.4	10230.0
2022-03-28 08:00:00	MSFT	Stock	303.81	304.7245	303.57	303.75	38415.0
2022-03-28 09:00:00	MSFT	Stock	303.7	310.5	303.3	310.07	3606759.0
2022-03-28 10:00:00	MSFT	Stock	310.08	310.4	307.07	309.3897	2771151.0
2022-03-28 11:00:00	MSFT	Stock	309.41	309.56	305.46	305.74	1895202.0
2022-03-28 12:00:00	MSFT	Stock	305.7	307.03	305.0401	306.925	1352334.0
2022-03-28 13:00:00	MSFT	Stock	306.94	307.95	306.65	307.615	1210586.0
2022-03-28 14:00:00	MSFT	Stock	307.615	309.65	307.289	309.64	1780852.0
2022-03-28 15:00:00	MSFT	Stock	309.65	310.8	309.02	310.76	4023861.0
2022-03-28 16:00:00	MSFT	Stock	310.75	310.88	310.5	310.7399	4394601.0
2022-03-28 17:00:00	MSFT	Stock	310.69	310.8	310.65	310.73	8290.0
2022-03-28 18:00:00	MSFT	Stock	310.7	310.7	310.32	310.5	10587.0
2022-03-28 19:00:00	MSFT	Stock	310.41	310.75	310.27	310.7	15948.0
2022-03-28 04:00:00	NVDA	Stock	27.598	27.622	27.389	27.622	84330.0
2022-03-28 05:00:00	NVDA	Stock	27.605	27.605	27.466	27.476	135670.0
2022-03-28 06:00:00	NVDA	Stock	27.5	27.647	27.47	27.6	84550.0
2022-03-28 07:00:00	NVDA	Stock	27.642	27.97	27.61	27.955	801950.0
2022-03-28 08:00:00	NVDA	Stock	27.9152	27.9717	27.426	27.85	2135640.0
2022-03-28 09:00:00	NVDA	Stock	27.847	28.208	27.64	28.1295	40579220.0
2022-03-28 10:00:00	NVDA	Stock	28.1328	28.14	27.53	27.842	52905450.0
2022-03-28 11:00:00	NVDA	Stock	27.842	27.921	27.357	27.408	39247860.0
2022-03-28 12:00:00	NVDA	Stock	27.401	27.589	27.206	27.545	32230860.0
2022-03-28 13:00:00	NVDA	Stock	27.542	27.843	27.523	27.752	31726650.0
2022-03-28 14:00:00	NVDA	Stock	27.757	27.978	27.68	27.972	30494650.0
2022-03-28 15:00:00	NVDA	Stock	27.978	28.25	27.898	28.22	62084290.0
2022-03-28 16:00:00	NVDA	Stock	28.219	28.258	28.174	28.23	16829900.0
2022-03-28 17:00:00	NVDA	Stock	28.226	28.239	28.201	28.21	156990.0
2022-03-28 18:00:00	NVDA	Stock	28.223	28.223	28.175	28.195	127540.0
2022-03-28 19:00:00	NVDA	Stock	28.193	28.24	28.181	28.225	258560.0
2022-03-28 07:00:00	AMZN	Stock	164.7625	165.15	164.7625	165.15	10920.0
2022-03-28 08:00:00	AMZN	Stock	164.9927	165.25	164.775	164.9	53880.0

> showing 50 of 64,431 rows — these rows as CSV

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