PREVIEW / stock_1hour / 2021-12-16

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-16.parquet
  size:    1.5 MB
  rows:    66,056
  symbols: 2,642

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-12-16 04:00:00	AAPL	Stock	180.55	180.68	180.14	180.57	55938.0
2021-12-16 05:00:00	AAPL	Stock	180.59	180.92	180.52	180.84	26041.0
2021-12-16 06:00:00	AAPL	Stock	180.83	181.25	180.6	180.7	99265.0
2021-12-16 07:00:00	AAPL	Stock	180.64	180.9	180.01	180.18	304727.0
2021-12-16 08:00:00	AAPL	Stock	180.7	180.84	178.852	179.73	976441.0
2021-12-16 09:00:00	AAPL	Stock	179.74	181.14	176.5	176.52	17898629.0
2021-12-16 10:00:00	AAPL	Stock	176.53	176.58	174.53	175.7826	23904651.0
2021-12-16 11:00:00	AAPL	Stock	175.78	175.79	174.24	174.79	12319662.0
2021-12-16 12:00:00	AAPL	Stock	174.78	175.32	173.12	173.1552	13191628.0
2021-12-16 13:00:00	AAPL	Stock	173.15	174.44	173.15	173.595	9115400.0
2021-12-16 14:00:00	AAPL	Stock	173.6	173.79	170.8	171.5909	18262677.0
2021-12-16 15:00:00	AAPL	Stock	171.59	173.33	170.75	172.25	26264298.0
2021-12-16 16:00:00	AAPL	Stock	172.32	172.57	171.7	172.34	10418976.0
2021-12-16 17:00:00	AAPL	Stock	172.35	172.3799	171.48	171.62	196981.0
2021-12-16 18:00:00	AAPL	Stock	171.64	171.88	171.02	171.3	118913.0
2021-12-16 19:00:00	AAPL	Stock	171.3	172.2599	171.25	172.12	94858.0
2021-12-16 04:00:00	MSFT	Stock	336.62	336.88	336.0	336.2	10207.0
2021-12-16 05:00:00	MSFT	Stock	336.0	336.85	336.0	336.85	5963.0
2021-12-16 06:00:00	MSFT	Stock	336.99	337.89	336.7	337.4	12477.0
2021-12-16 07:00:00	MSFT	Stock	337.03	337.2	336.21	336.4	44649.0
2021-12-16 08:00:00	MSFT	Stock	337.12	337.2126	334.64	335.5	77030.0
2021-12-16 09:00:00	MSFT	Stock	335.17	336.76	332.04	332.16	2980231.0
2021-12-16 10:00:00	MSFT	Stock	332.13	332.8	330.57	331.6019	2564521.0
2021-12-16 11:00:00	MSFT	Stock	331.62	331.75	327.69	327.85	2745423.0
2021-12-16 12:00:00	MSFT	Stock	327.83	328.27	325.87	325.96	2532674.0
2021-12-16 13:00:00	MSFT	Stock	325.95	327.9	325.9	327.0499	1686835.0
2021-12-16 14:00:00	MSFT	Stock	327.04	327.43	323.02	324.64	3262555.0
2021-12-16 15:00:00	MSFT	Stock	324.64	326.83	323.77	324.9	4599539.0
2021-12-16 16:00:00	MSFT	Stock	324.98	325.69	324.64	325.25	4588822.0
2021-12-16 17:00:00	MSFT	Stock	325.1	325.28	324.7	324.95	13112.0
2021-12-16 18:00:00	MSFT	Stock	324.9	325.38	324.12	324.4	24729.0
2021-12-16 19:00:00	MSFT	Stock	324.63	325.39	324.47	325.25	16364.0
2021-12-16 04:00:00	NVDA	Stock	30.9	30.98	30.801	30.95	369350.0
2021-12-16 05:00:00	NVDA	Stock	30.96	31.16	30.875	31.14	176260.0
2021-12-16 06:00:00	NVDA	Stock	31.142	31.274	31.09	31.141	302720.0
2021-12-16 07:00:00	NVDA	Stock	31.13	31.179	31.04	31.06	1680220.0
2021-12-16 08:00:00	NVDA	Stock	31.1	31.18	30.5351	31.03	3140730.0
2021-12-16 09:00:00	NVDA	Stock	31.03	31.257	29.703	29.753	92946090.0
2021-12-16 10:00:00	NVDA	Stock	29.765	29.86	29.072	29.189	106000980.0
2021-12-16 11:00:00	NVDA	Stock	29.193	29.2542	28.53	28.574	72817440.0
2021-12-16 12:00:00	NVDA	Stock	28.564	28.698	28.363	28.5603	48883880.0
2021-12-16 13:00:00	NVDA	Stock	28.56	28.866	28.512	28.516	42501470.0
2021-12-16 14:00:00	NVDA	Stock	28.5171	28.661	28.093	28.2887	54158350.0
2021-12-16 15:00:00	NVDA	Stock	28.2935	28.649	28.154	28.385	72577840.0
2021-12-16 16:00:00	NVDA	Stock	28.393	28.517	28.35	28.5	25174410.0
2021-12-16 17:00:00	NVDA	Stock	28.515	28.515	28.214	28.239	487790.0
2021-12-16 18:00:00	NVDA	Stock	28.239	28.367	28.014	28.115	804020.0
2021-12-16 19:00:00	NVDA	Stock	28.12	28.19	28.082	28.181	418760.0
2021-12-16 04:00:00	AMZN	Stock	174.0	174.0	173.95	173.95	9820.0
2021-12-16 06:00:00	AMZN	Stock	174.5	174.689	174.5	174.65	16480.0

> showing 50 of 66,056 rows — these rows as CSV

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