PREVIEW / stock_1hour / 2021-11-04

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-11-04.parquet
  size:    1.5 MB
  rows:    67,230
  symbols: 2,690

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
2021-11-04 04:00:00	AAPL	Stock	152.0	152.0	151.6	151.65	20441.0
2021-11-04 05:00:00	AAPL	Stock	151.73	151.75	151.62	151.7	10365.0
2021-11-04 06:00:00	AAPL	Stock	151.69	151.75	151.5	151.64	14957.0
2021-11-04 07:00:00	AAPL	Stock	151.67	151.9	151.61	151.82	99655.0
2021-11-04 08:00:00	AAPL	Stock	151.7708	151.9	151.112	151.78	242860.0
2021-11-04 09:00:00	AAPL	Stock	151.79	152.43	151.28	152.075	7468481.0
2021-11-04 10:00:00	AAPL	Stock	152.08	152.1	151.55	151.915	6876121.0
2021-11-04 11:00:00	AAPL	Stock	151.92	151.95	150.84	151.37	6849374.0
2021-11-04 12:00:00	AAPL	Stock	151.37	151.67	151.145	151.22	3636427.0
2021-11-04 13:00:00	AAPL	Stock	151.221	151.57	151.02	151.5301	4201711.0
2021-11-04 14:00:00	AAPL	Stock	151.53	151.55	151.12	151.18	3794269.0
2021-11-04 15:00:00	AAPL	Stock	151.175	151.54	150.64	150.96	7465229.0
2021-11-04 16:00:00	AAPL	Stock	150.96	151.08	150.84	150.98	9499570.0
2021-11-04 17:00:00	AAPL	Stock	151.01	151.03	150.86	150.89	43316.0
2021-11-04 18:00:00	AAPL	Stock	150.92	151.03	150.92	150.99	16211.0
2021-11-04 19:00:00	AAPL	Stock	150.99	151.0	150.89	150.95	33234.0
2021-11-04 04:00:00	MSFT	Stock	335.0	335.92	334.65	334.65	4136.0
2021-11-04 05:00:00	MSFT	Stock	334.75	334.85	334.5	334.5	7922.0
2021-11-04 06:00:00	MSFT	Stock	334.47	334.58	334.01	334.58	13749.0
2021-11-04 07:00:00	MSFT	Stock	334.58	334.6	334.3	334.5	13042.0
2021-11-04 08:00:00	MSFT	Stock	334.5166	334.835	334.0	334.05	26708.0
2021-11-04 09:00:00	MSFT	Stock	334.23	334.28	329.51	333.485	3303865.0
2021-11-04 10:00:00	MSFT	Stock	333.52	336.13	333.21	334.98	2984318.0
2021-11-04 11:00:00	MSFT	Stock	335.0	335.54	334.29	335.45	1654181.0
2021-11-04 12:00:00	MSFT	Stock	335.41	335.68	334.815	335.5	968896.0
2021-11-04 13:00:00	MSFT	Stock	335.5	336.42	335.015	336.25	1312856.0
2021-11-04 14:00:00	MSFT	Stock	336.22	336.2691	335.3201	335.76	1111385.0
2021-11-04 15:00:00	MSFT	Stock	335.75	336.54	335.32	336.46	2400697.0
2021-11-04 16:00:00	MSFT	Stock	336.44	336.71	336.2	336.31	3943333.0
2021-11-04 17:00:00	MSFT	Stock	336.67	336.68	336.38	336.4	2878.0
2021-11-04 18:00:00	MSFT	Stock	336.52	336.97	336.5	336.92	2628.0
2021-11-04 19:00:00	MSFT	Stock	336.92	336.99	336.73	336.73	3308.0
2021-11-04 04:00:00	NVDA	Stock	26.835	26.998	26.76	26.962	254700.0
2021-11-04 05:00:00	NVDA	Stock	26.97	27.203	26.97	27.148	225350.0
2021-11-04 06:00:00	NVDA	Stock	27.139	27.184	27.1	27.16	67560.0
2021-11-04 07:00:00	NVDA	Stock	27.16	27.16	27.098	27.12	343020.0
2021-11-04 08:00:00	NVDA	Stock	27.1001	27.387	27.0	27.245	2153830.0
2021-11-04 09:00:00	NVDA	Stock	27.2303	28.059	27.118	28.034	72011970.0
2021-11-04 10:00:00	NVDA	Stock	28.0365	28.825	28.006	28.663	107760840.0
2021-11-04 11:00:00	NVDA	Stock	28.665	29.475	28.5426	29.4215	110072140.0
2021-11-04 12:00:00	NVDA	Stock	29.4195	29.9268	29.284	29.663	112079760.0
2021-11-04 13:00:00	NVDA	Stock	29.642	30.394	29.5619	30.2945	108070330.0
2021-11-04 14:00:00	NVDA	Stock	30.291	31.364	30.199	30.329	146384860.0
2021-11-04 15:00:00	NVDA	Stock	30.3254	30.482	29.532	29.803	171268730.0
2021-11-04 16:00:00	NVDA	Stock	29.801	29.828	29.514	29.64	21872160.0
2021-11-04 17:00:00	NVDA	Stock	29.62	29.801	29.6	29.73	445530.0
2021-11-04 18:00:00	NVDA	Stock	29.73	29.836	29.71	29.72	450820.0
2021-11-04 19:00:00	NVDA	Stock	29.73	29.74	29.6	29.645	552630.0
2021-11-04 04:00:00	AMZN	Stock	169.45	169.818	169.45	169.8165	47840.0
2021-11-04 07:00:00	AMZN	Stock	169.45	169.4625	169.25	169.4295	33320.0

> showing 50 of 67,230 rows — these rows as CSV

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