PREVIEW / stock_1hour / 2021-06-15

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-06-15.parquet
  size:    1.4 MB
  rows:    65,440
  symbols: 2,954

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-06-15 04:00:00	AAPL	Stock	130.53	130.75	130.53	130.62	19287.0
2021-06-15 05:00:00	AAPL	Stock	130.56	130.66	130.48	130.48	9102.0
2021-06-15 06:00:00	AAPL	Stock	130.48	130.5	130.3	130.5	14099.0
2021-06-15 07:00:00	AAPL	Stock	130.45	130.5	130.24	130.36	111482.0
2021-06-15 08:00:00	AAPL	Stock	130.38	130.5	129.85	129.96	387700.0
2021-06-15 09:00:00	AAPL	Stock	129.97	130.6	129.39	130.1588	11009461.0
2021-06-15 10:00:00	AAPL	Stock	130.155	130.22	129.46	129.625	9992834.0
2021-06-15 11:00:00	AAPL	Stock	129.625	129.97	129.575	129.93	5464659.0
2021-06-15 12:00:00	AAPL	Stock	129.94	130.227	129.8	129.85	4991345.0
2021-06-15 13:00:00	AAPL	Stock	129.85	129.96	129.68	129.9	4124383.0
2021-06-15 14:00:00	AAPL	Stock	129.905	129.92	129.5325	129.715	3804177.0
2021-06-15 15:00:00	AAPL	Stock	129.715	130.0	129.51	129.74	9020776.0
2021-06-15 16:00:00	AAPL	Stock	129.8	129.83	129.64	129.78	6896793.0
2021-06-15 17:00:00	AAPL	Stock	129.77	129.78	129.7	129.7	21978.0
2021-06-15 18:00:00	AAPL	Stock	129.74	129.74	129.65	129.66	33577.0
2021-06-15 19:00:00	AAPL	Stock	129.65	129.75	129.61	129.7	38562.0
2021-06-15 04:00:00	MSFT	Stock	259.96	260.27	259.64	260.0	3907.0
2021-06-15 05:00:00	MSFT	Stock	259.98	259.98	259.95	259.95	579.0
2021-06-15 06:00:00	MSFT	Stock	259.9	260.0	259.89	260.0	4474.0
2021-06-15 07:00:00	MSFT	Stock	260.01	260.37	259.85	260.14	14650.0
2021-06-15 08:00:00	MSFT	Stock	259.91	260.35	259.49	259.65	25737.0
2021-06-15 09:00:00	MSFT	Stock	259.7	260.01	258.41	259.32	1685238.0
2021-06-15 10:00:00	MSFT	Stock	259.33	259.73	258.81	258.92	1841236.0
2021-06-15 11:00:00	MSFT	Stock	258.905	259.51	258.63	259.4445	1356657.0
2021-06-15 12:00:00	MSFT	Stock	259.44	259.59	258.47	258.67	995531.0
2021-06-15 13:00:00	MSFT	Stock	258.69	258.69	258.15	258.36	1147183.0
2021-06-15 14:00:00	MSFT	Stock	258.36	258.5	257.77	258.11	1147671.0
2021-06-15 15:00:00	MSFT	Stock	258.115	258.8	257.68	258.52	2632907.0
2021-06-15 16:00:00	MSFT	Stock	258.36	258.7	258.36	258.52	3428963.0
2021-06-15 17:00:00	MSFT	Stock	258.4	258.54	258.4	258.425	3256.0
2021-06-15 18:00:00	MSFT	Stock	258.51	258.72	258.4	258.52	4659.0
2021-06-15 19:00:00	MSFT	Stock	258.22	258.64	258.12	258.64	7233.0
2021-06-15 04:00:00	NVDA	Stock	18.0388	18.0388	18.0055	18.0055	25040.0
2021-06-15 05:00:00	NVDA	Stock	18.0	18.0	18.0	18.0	4000.0
2021-06-15 06:00:00	NVDA	Stock	17.9975	17.9975	17.9975	17.9975	13440.0
2021-06-15 07:00:00	NVDA	Stock	18.0128	18.0137	17.9375	17.95	237360.0
2021-06-15 08:00:00	NVDA	Stock	18.035	18.035	17.925	17.95	495240.0
2021-06-15 09:00:00	NVDA	Stock	17.9565	18.0188	17.7725	17.9412	29097960.0
2021-06-15 10:00:00	NVDA	Stock	17.9454	18.0	17.8652	17.8945	22172080.0
2021-06-15 11:00:00	NVDA	Stock	17.9004	17.934	17.8028	17.871	16755040.0
2021-06-15 12:00:00	NVDA	Stock	17.8745	17.972	17.8688	17.9175	14999160.0
2021-06-15 13:00:00	NVDA	Stock	17.9172	17.9334	17.8807	17.9188	6945360.0
2021-06-15 14:00:00	NVDA	Stock	17.917	17.9495	17.8378	17.8452	12040160.0
2021-06-15 15:00:00	NVDA	Stock	17.843	17.8561	17.728	17.7885	30103280.0
2021-06-15 16:00:00	NVDA	Stock	17.7885	17.867	17.7628	17.7875	22286160.0
2021-06-15 17:00:00	NVDA	Stock	17.7753	17.785	17.7745	17.785	51360.0
2021-06-15 18:00:00	NVDA	Stock	17.7752	17.785	17.775	17.785	46520.0
2021-06-15 19:00:00	NVDA	Stock	17.7812	17.7863	17.755	17.755	121360.0
2021-06-15 05:00:00	AMZN	Stock	168.766	169.2505	168.766	169.0	23260.0
2021-06-15 06:00:00	AMZN	Stock	168.95	168.95	168.95	168.95	2000.0

> showing 50 of 65,440 rows — these rows as CSV

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