PREVIEW / stock_1hour / 2021-04-14

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-04-14.parquet
  size:    1.4 MB
  rows:    65,404
  symbols: 2,963

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-04-14 04:00:00	AAPL	Stock	134.88	134.88	134.22	134.67	16590.0
2021-04-14 05:00:00	AAPL	Stock	134.67	134.7	134.59	134.66	11579.0
2021-04-14 06:00:00	AAPL	Stock	134.63	134.8	134.45	134.75	24708.0
2021-04-14 07:00:00	AAPL	Stock	134.76	135.02	134.7	135.0	207033.0
2021-04-14 08:00:00	AAPL	Stock	134.7545	135.3	134.68	134.72	615249.0
2021-04-14 09:00:00	AAPL	Stock	134.74	135.0	133.45	134.02	12347196.0
2021-04-14 10:00:00	AAPL	Stock	134.015	134.03	133.25	133.285	11168709.0
2021-04-14 11:00:00	AAPL	Stock	133.29	133.48	132.57	133.33	9605856.0
2021-04-14 12:00:00	AAPL	Stock	133.3301	133.62	132.98	133.53	6022122.0
2021-04-14 13:00:00	AAPL	Stock	133.53	133.58	132.57	132.6713	4833517.0
2021-04-14 14:00:00	AAPL	Stock	132.69	132.96	131.655	132.29	10950601.0
2021-04-14 15:00:00	AAPL	Stock	132.29	132.65	131.82	132.15	13022685.0
2021-04-14 16:00:00	AAPL	Stock	132.11	132.24	132.0	132.12	6650584.0
2021-04-14 17:00:00	AAPL	Stock	132.15	132.97	132.11	132.35	88998.0
2021-04-14 18:00:00	AAPL	Stock	132.31	132.35	132.2	132.26	61802.0
2021-04-14 19:00:00	AAPL	Stock	132.25	132.34	132.1	132.15	74112.0
2021-04-14 04:00:00	MSFT	Stock	259.03	259.32	259.0	259.32	2776.0
2021-04-14 05:00:00	MSFT	Stock	259.32	259.69	259.1	259.63	4085.0
2021-04-14 06:00:00	MSFT	Stock	259.39	259.5	259.2	259.5	1610.0
2021-04-14 07:00:00	MSFT	Stock	259.32	259.64	259.2	259.45	22727.0
2021-04-14 08:00:00	MSFT	Stock	259.4899	259.77	257.844	258.55	47651.0
2021-04-14 09:00:00	MSFT	Stock	258.57	258.57	256.77	257.98	2023179.0
2021-04-14 10:00:00	MSFT	Stock	257.99	258.83	257.3	257.59	2176734.0
2021-04-14 11:00:00	MSFT	Stock	257.59	257.82	256.16	256.87	1873316.0
2021-04-14 12:00:00	MSFT	Stock	256.8801	256.98	256.2601	256.835	1370310.0
2021-04-14 13:00:00	MSFT	Stock	256.85	256.94	255.7	255.85	1229541.0
2021-04-14 14:00:00	MSFT	Stock	255.845	256.4365	255.16	255.515	1663243.0
2021-04-14 15:00:00	MSFT	Stock	255.51	256.5	255.18	255.81	3162699.0
2021-04-14 16:00:00	MSFT	Stock	255.81	256.1	255.48	255.95	3272824.0
2021-04-14 17:00:00	MSFT	Stock	255.87	255.99	255.81	255.99	4568.0
2021-04-14 18:00:00	MSFT	Stock	255.82	256.13	255.82	255.91	6892.0
2021-04-14 19:00:00	MSFT	Stock	256.0	256.14	255.38	255.38	3913.0
2021-04-14 04:00:00	NVDA	Stock	15.6613	15.6875	15.6528	15.6675	117320.0
2021-04-14 05:00:00	NVDA	Stock	15.65	15.65	15.65	15.65	4000.0
2021-04-14 06:00:00	NVDA	Stock	15.602	15.602	15.581	15.581	25040.0
2021-04-14 07:00:00	NVDA	Stock	15.608	15.6725	15.608	15.6528	249920.0
2021-04-14 08:00:00	NVDA	Stock	15.6312	15.665	15.5952	15.5952	849920.0
2021-04-14 09:00:00	NVDA	Stock	15.6	15.7205	15.475	15.5812	50181320.0
2021-04-14 10:00:00	NVDA	Stock	15.5872	15.6572	15.4028	15.5813	45943960.0
2021-04-14 11:00:00	NVDA	Stock	15.5844	15.6015	15.4463	15.5792	26481080.0
2021-04-14 12:00:00	NVDA	Stock	15.575	15.5995	15.5083	15.5557	13941280.0
2021-04-14 13:00:00	NVDA	Stock	15.5562	15.5797	15.3942	15.415	16404840.0
2021-04-14 14:00:00	NVDA	Stock	15.4095	15.4245	15.289	15.2912	24740160.0
2021-04-14 15:00:00	NVDA	Stock	15.2925	15.3785	15.2275	15.2852	39236200.0
2021-04-14 16:00:00	NVDA	Stock	15.277	15.3245	15.277	15.3125	28532920.0
2021-04-14 17:00:00	NVDA	Stock	15.3125	15.3312	15.3125	15.32	196920.0
2021-04-14 18:00:00	NVDA	Stock	15.3125	15.325	15.3062	15.3062	52360.0
2021-04-14 19:00:00	NVDA	Stock	15.3062	15.3125	15.3	15.3	131760.0
2021-04-14 05:00:00	AMZN	Stock	170.0	170.0	170.0	170.0	2540.0
2021-04-14 07:00:00	AMZN	Stock	170.2505	170.6	170.2505	170.6	17240.0

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

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