PREVIEW / stock_1hour / 2021-03-08

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-08.parquet
  size:    1.5 MB
  rows:    69,085
  symbols: 2,886

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-03-08 04:00:00	AAPL	Stock	119.24	119.9	118.52	119.08	75943.0
2021-03-08 05:00:00	AAPL	Stock	119.03	119.59	119.02	119.26	28313.0
2021-03-08 06:00:00	AAPL	Stock	119.37	119.8	119.02	119.42	54980.0
2021-03-08 07:00:00	AAPL	Stock	119.54	120.1	119.31	119.58	356636.0
2021-03-08 08:00:00	AAPL	Stock	119.58	120.97	119.3	120.93	905443.0
2021-03-08 09:00:00	AAPL	Stock	120.9	121.02	118.26	118.47	20004284.0
2021-03-08 10:00:00	AAPL	Stock	118.46	119.48	118.06	118.635	20351433.0
2021-03-08 11:00:00	AAPL	Stock	118.635	119.03	117.63	117.63	17460724.0
2021-03-08 12:00:00	AAPL	Stock	117.64	118.26	117.4	117.73	12699026.0
2021-03-08 13:00:00	AAPL	Stock	117.73	118.25	116.76	116.81	13140448.0
2021-03-08 14:00:00	AAPL	Stock	116.8	117.8199	116.78	117.24	12280592.0
2021-03-08 15:00:00	AAPL	Stock	117.24	117.39	116.21	116.4	21686876.0
2021-03-08 16:00:00	AAPL	Stock	116.36	121.42	116.11	116.5001	11644677.0
2021-03-08 17:00:00	AAPL	Stock	116.54	116.64	116.36	116.5	370744.0
2021-03-08 18:00:00	AAPL	Stock	116.55	117.14	116.5	116.94	318316.0
2021-03-08 19:00:00	AAPL	Stock	116.96	117.0	116.59	116.84	193401.0
2021-03-08 04:00:00	MSFT	Stock	222.48	227.53	222.48	226.6	21945.0
2021-03-08 05:00:00	MSFT	Stock	226.6	227.2	226.3	227.19	21707.0
2021-03-08 06:00:00	MSFT	Stock	227.23	229.72	226.72	229.21	21363.0
2021-03-08 07:00:00	MSFT	Stock	229.21	229.52	228.53	228.89	62464.0
2021-03-08 08:00:00	MSFT	Stock	229.01	231.021	228.63	230.7	110231.0
2021-03-08 09:00:00	MSFT	Stock	230.1459	232.34	229.37	230.145	3716826.0
2021-03-08 10:00:00	MSFT	Stock	230.145	233.365	229.47	231.65	3996956.0
2021-03-08 11:00:00	MSFT	Stock	231.64	232.46	230.22	230.259	2298998.0
2021-03-08 12:00:00	MSFT	Stock	230.26	231.405	229.56	230.31	2153452.0
2021-03-08 13:00:00	MSFT	Stock	230.33	231.27	229.06	229.1594	1874120.0
2021-03-08 14:00:00	MSFT	Stock	229.13	230.17	228.83	229.45	2029182.0
2021-03-08 15:00:00	MSFT	Stock	229.41	229.59	227.13	227.42	4624477.0
2021-03-08 16:00:00	MSFT	Stock	227.39	231.6	227.39	228.5	3419161.0
2021-03-08 17:00:00	MSFT	Stock	228.4	228.4	227.39	228.0	49814.0
2021-03-08 18:00:00	MSFT	Stock	228.1	229.41	228.1	228.2	21477.0
2021-03-08 19:00:00	MSFT	Stock	228.6	228.7	227.95	228.4	9130.0
2021-03-08 04:00:00	NVDA	Stock	12.3715	12.3715	12.1475	12.225	67280.0
2021-03-08 05:00:00	NVDA	Stock	12.275	12.3	12.2	12.2358	74560.0
2021-03-08 06:00:00	NVDA	Stock	12.25	12.284	12.25	12.275	36440.0
2021-03-08 07:00:00	NVDA	Stock	12.294	12.3155	12.2	12.225	178720.0
2021-03-08 08:00:00	NVDA	Stock	12.275	12.4984	12.2	12.4613	899960.0
2021-03-08 09:00:00	NVDA	Stock	12.4993	12.5495	12.19	12.2355	37384040.0
2021-03-08 10:00:00	NVDA	Stock	12.2355	12.3392	12.1148	12.2104	41270240.0
2021-03-08 11:00:00	NVDA	Stock	12.2099	12.2493	11.9595	11.9634	29687520.0
2021-03-08 12:00:00	NVDA	Stock	11.9603	12.0551	11.8282	11.921	43682200.0
2021-03-08 13:00:00	NVDA	Stock	11.924	11.9525	11.7011	11.7219	35527880.0
2021-03-08 14:00:00	NVDA	Stock	11.7188	11.825	11.6803	11.6898	41616840.0
2021-03-08 15:00:00	NVDA	Stock	11.6898	11.709	11.5665	11.5933	72126160.0
2021-03-08 16:00:00	NVDA	Stock	11.5933	11.635	11.566	11.5933	27886080.0
2021-03-08 17:00:00	NVDA	Stock	11.5965	11.6075	11.575	11.5825	491840.0
2021-03-08 18:00:00	NVDA	Stock	11.5925	11.645	11.5805	11.645	740800.0
2021-03-08 19:00:00	NVDA	Stock	11.6375	11.6625	11.6205	11.6438	291480.0
2021-03-08 04:00:00	AMZN	Stock	147.375	147.375	147.375	147.375	2000.0
2021-03-08 05:00:00	AMZN	Stock	148.0	148.0	147.75	147.75	11300.0

> showing 50 of 69,085 rows — these rows as CSV

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