PREVIEW / stock_1hour / 2022-02-14

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-02-14.parquet
  size:    1.4 MB
  rows:    65,074
  symbols: 2,551

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
2022-02-14 04:00:00	AAPL	Stock	168.2	168.2	165.25	166.0	97112.0
2022-02-14 05:00:00	AAPL	Stock	165.88	166.6	165.62	166.39	32709.0
2022-02-14 06:00:00	AAPL	Stock	166.22	166.75	165.87	166.49	65392.0
2022-02-14 07:00:00	AAPL	Stock	166.49	168.4	166.0	168.01	377211.0
2022-02-14 08:00:00	AAPL	Stock	166.22	168.45	165.92	167.51	670364.0
2022-02-14 09:00:00	AAPL	Stock	167.55	169.0	166.86	168.435	8624918.0
2022-02-14 10:00:00	AAPL	Stock	168.42	168.75	167.57	167.885	9383127.0
2022-02-14 11:00:00	AAPL	Stock	167.89	169.2	167.78	168.875	6856291.0
2022-02-14 12:00:00	AAPL	Stock	168.88	169.48	168.72	169.28	4629796.0
2022-02-14 13:00:00	AAPL	Stock	169.28	169.58	166.87	166.89	6038238.0
2022-02-14 14:00:00	AAPL	Stock	166.9	168.56	166.56	168.16	7814768.0
2022-02-14 15:00:00	AAPL	Stock	168.16	169.39	167.72	169.13	14352185.0
2022-02-14 16:00:00	AAPL	Stock	168.88	168.95	168.66	168.75	15361604.0
2022-02-14 17:00:00	AAPL	Stock	168.78	168.88	168.6	168.65	18196.0
2022-02-14 18:00:00	AAPL	Stock	168.7	169.1	168.7	169.0	39523.0
2022-02-14 19:00:00	AAPL	Stock	169.14	169.19	168.63	168.87	43340.0
2022-02-14 04:00:00	MSFT	Stock	291.2	291.91	290.0	290.37	17833.0
2022-02-14 05:00:00	MSFT	Stock	290.02	291.8	289.76	291.7	9066.0
2022-02-14 06:00:00	MSFT	Stock	291.52	292.19	291.11	292.19	17760.0
2022-02-14 07:00:00	MSFT	Stock	291.85	294.85	290.5	294.33	76039.0
2022-02-14 08:00:00	MSFT	Stock	290.6001	294.94	290.5001	293.15	92173.0
2022-02-14 09:00:00	MSFT	Stock	293.17	295.88	292.55	294.6	3161510.0
2022-02-14 10:00:00	MSFT	Stock	294.58	295.12	292.04	293.925	3701228.0
2022-02-14 11:00:00	MSFT	Stock	293.93	296.76	293.76	295.705	2403200.0
2022-02-14 12:00:00	MSFT	Stock	295.64	296.52	295.2	295.8066	1455198.0
2022-02-14 13:00:00	MSFT	Stock	295.8101	296.64	292.09	292.41	2317480.0
2022-02-14 14:00:00	MSFT	Stock	292.37	295.08	291.35	294.23	2860675.0
2022-02-14 15:00:00	MSFT	Stock	294.2648	295.64	293.23	294.98	3402281.0
2022-02-14 16:00:00	MSFT	Stock	294.97	295.35	294.8	295.1	2977670.0
2022-02-14 17:00:00	MSFT	Stock	295.05	295.19	294.81	294.812	15932.0
2022-02-14 18:00:00	MSFT	Stock	295.0	296.02	294.98	295.9	9151.0
2022-02-14 19:00:00	MSFT	Stock	295.9	296.1	294.8	295.2	5672.0
2022-02-14 04:00:00	NVDA	Stock	23.334	23.6	23.0	23.25	402520.0
2022-02-14 05:00:00	NVDA	Stock	23.251	23.41	23.145	23.315	261710.0
2022-02-14 06:00:00	NVDA	Stock	23.32	23.502	23.25	23.455	156490.0
2022-02-14 07:00:00	NVDA	Stock	23.448	24.003	23.268	23.895	1899330.0
2022-02-14 08:00:00	NVDA	Stock	23.65	24.15	23.259	23.8	2962480.0
2022-02-14 09:00:00	NVDA	Stock	23.8	24.7145	23.755	24.58	52713670.0
2022-02-14 10:00:00	NVDA	Stock	24.573	24.672	24.19	24.574	54475840.0
2022-02-14 11:00:00	NVDA	Stock	24.575	24.875	24.5019	24.733	34335460.0
2022-02-14 12:00:00	NVDA	Stock	24.732	24.864	24.588	24.616	25986570.0
2022-02-14 13:00:00	NVDA	Stock	24.616	24.637	23.865	23.865	34846110.0
2022-02-14 14:00:00	NVDA	Stock	23.864	24.314	23.772	24.2381	45920220.0
2022-02-14 15:00:00	NVDA	Stock	24.2325	24.372	24.025	24.262	48657640.0
2022-02-14 16:00:00	NVDA	Stock	24.267	24.325	24.176	24.267	21164570.0
2022-02-14 17:00:00	NVDA	Stock	24.266	24.3	24.245	24.3	88690.0
2022-02-14 18:00:00	NVDA	Stock	24.3	24.388	24.3	24.375	380960.0
2022-02-14 19:00:00	NVDA	Stock	24.375	24.4	24.25	24.305	427310.0
2022-02-14 04:00:00	AMZN	Stock	151.0	151.0	151.0	151.0	30000.0
2022-02-14 05:00:00	AMZN	Stock	150.66	151.45	150.66	151.45	13000.0

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

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