PREVIEW / stock_1hour / 2021-10-01

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-10-01.parquet
  size:    1.4 MB
  rows:    64,649
  symbols: 2,745

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-10-01 04:00:00	AAPL	Stock	140.72	141.3	140.53	140.59	29808.0
2021-10-01 05:00:00	AAPL	Stock	140.65	140.85	140.64	140.75	46886.0
2021-10-01 06:00:00	AAPL	Stock	140.75	141.34	140.75	141.34	48320.0
2021-10-01 07:00:00	AAPL	Stock	141.2	142.3	141.15	142.0	433479.0
2021-10-01 08:00:00	AAPL	Stock	142.0	142.28	141.21	141.79	902830.0
2021-10-01 09:00:00	AAPL	Stock	141.8	142.04	140.24	140.53	11096296.0
2021-10-01 10:00:00	AAPL	Stock	140.54	140.69	139.1101	140.06	15951953.0
2021-10-01 11:00:00	AAPL	Stock	140.06	140.42	139.5675	140.3144	10365235.0
2021-10-01 12:00:00	AAPL	Stock	140.32	140.81	140.065	140.421	6889757.0
2021-10-01 13:00:00	AAPL	Stock	140.44	141.553	140.295	141.35	6396793.0
2021-10-01 14:00:00	AAPL	Stock	141.36	142.18	141.29	142.06	7515758.0
2021-10-01 15:00:00	AAPL	Stock	142.0537	142.92	141.9	142.64	13902307.0
2021-10-01 16:00:00	AAPL	Stock	142.65	142.65	142.05	142.53	9837466.0
2021-10-01 17:00:00	AAPL	Stock	142.53	142.58	142.49	142.55	37884.0
2021-10-01 18:00:00	AAPL	Stock	142.53	142.56	142.5	142.52	13309.0
2021-10-01 19:00:00	AAPL	Stock	142.55	142.6	142.5	142.58	25721.0
2021-10-01 04:00:00	MSFT	Stock	280.31	280.99	279.64	279.85	12791.0
2021-10-01 05:00:00	MSFT	Stock	280.1	280.48	280.1	280.19	3670.0
2021-10-01 06:00:00	MSFT	Stock	280.25	280.94	280.25	280.89	13926.0
2021-10-01 07:00:00	MSFT	Stock	280.95	283.29	280.8	282.38	77403.0
2021-10-01 08:00:00	MSFT	Stock	282.6006	283.11	280.85	282.11	78162.0
2021-10-01 09:00:00	MSFT	Stock	282.37	284.14	281.29	283.71	2534385.0
2021-10-01 10:00:00	MSFT	Stock	283.72	285.03	282.5666	284.97	3205698.0
2021-10-01 11:00:00	MSFT	Stock	284.96	286.87	284.41	286.3382	2248986.0
2021-10-01 12:00:00	MSFT	Stock	286.32	286.82	285.79	286.12	1495280.0
2021-10-01 13:00:00	MSFT	Stock	286.125	287.475	285.75	287.0621	1599416.0
2021-10-01 14:00:00	MSFT	Stock	287.08	288.43	286.93	288.33	1715766.0
2021-10-01 15:00:00	MSFT	Stock	288.34	289.98	288.0	289.1	4494846.0
2021-10-01 16:00:00	MSFT	Stock	289.1	289.1	288.0	288.34	4806505.0
2021-10-01 17:00:00	MSFT	Stock	288.35	289.1	288.3	288.73	1288823.0
2021-10-01 18:00:00	MSFT	Stock	288.6	288.6	288.44	288.58	6416.0
2021-10-01 19:00:00	MSFT	Stock	288.57	288.6	288.5	288.6	1249.0
2021-10-01 04:00:00	NVDA	Stock	20.5	20.548	20.451	20.451	70370.0
2021-10-01 05:00:00	NVDA	Stock	20.5	20.55	20.498	20.535	15020.0
2021-10-01 06:00:00	NVDA	Stock	20.57	20.689	20.562	20.689	45840.0
2021-10-01 07:00:00	NVDA	Stock	20.687	20.849	20.64	20.768	490310.0
2021-10-01 08:00:00	NVDA	Stock	20.752	20.858	20.665	20.796	701940.0
2021-10-01 09:00:00	NVDA	Stock	20.796	20.859	20.335	20.449	34778290.0
2021-10-01 10:00:00	NVDA	Stock	20.447	20.47	20.203	20.3776	33863950.0
2021-10-01 11:00:00	NVDA	Stock	20.377	20.565	20.283	20.525	24246600.0
2021-10-01 12:00:00	NVDA	Stock	20.5272	20.546	20.3437	20.3935	16357680.0
2021-10-01 13:00:00	NVDA	Stock	20.398	20.54	20.363	20.483	14770580.0
2021-10-01 14:00:00	NVDA	Stock	20.486	20.711	20.482	20.6819	14810620.0
2021-10-01 15:00:00	NVDA	Stock	20.685	20.785	20.645	20.742	28499740.0
2021-10-01 16:00:00	NVDA	Stock	20.74	20.771	20.686	20.752	23152020.0
2021-10-01 17:00:00	NVDA	Stock	20.749	20.749	20.733	20.745	2337920.0
2021-10-01 18:00:00	NVDA	Stock	20.745	20.745	20.734	20.745	24480.0
2021-10-01 19:00:00	NVDA	Stock	20.733	20.735	20.695	20.725	57510.0
2021-10-01 04:00:00	AMZN	Stock	163.703	163.703	163.0055	163.25	9980.0
2021-10-01 05:00:00	AMZN	Stock	163.25	163.25	163.25	163.25	2000.0

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

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