PREVIEW / stock_1hour / 2022-12-19

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-12-19.parquet
  size:    1.4 MB
  rows:    61,917
  symbols: 2,006

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-12-19 04:00:00	AAPL	Stock	136.0	136.0	135.2	135.29	32645.0
2022-12-19 05:00:00	AAPL	Stock	135.32	135.7	135.29	135.62	12416.0
2022-12-19 06:00:00	AAPL	Stock	135.6	135.62	135.35	135.51	18165.0
2022-12-19 07:00:00	AAPL	Stock	135.55	135.62	135.3	135.48	77277.0
2022-12-19 08:00:00	AAPL	Stock	135.39	135.7385	134.51	134.9201	224080.0
2022-12-19 09:00:00	AAPL	Stock	134.9202	135.25	133.0218	133.26	6927759.0
2022-12-19 10:00:00	AAPL	Stock	133.255	133.265	131.77	131.8728	11035152.0
2022-12-19 11:00:00	AAPL	Stock	131.88	132.61	131.4549	132.355	8442747.0
2022-12-19 12:00:00	AAPL	Stock	132.355	133.25	132.34	132.852	6168152.0
2022-12-19 13:00:00	AAPL	Stock	132.855	132.92	132.27	132.3394	4715772.0
2022-12-19 14:00:00	AAPL	Stock	132.33	132.69	132.01	132.18	5644379.0
2022-12-19 15:00:00	AAPL	Stock	132.18	132.6	131.32	132.35	13365403.0
2022-12-19 16:00:00	AAPL	Stock	132.37	132.52	132.2	132.27	11003956.0
2022-12-19 17:00:00	AAPL	Stock	132.27	132.27	131.98	132.1	122043.0
2022-12-19 18:00:00	AAPL	Stock	132.2	132.55	132.14	132.43	61169.0
2022-12-19 19:00:00	AAPL	Stock	132.47	132.59	132.35	132.55	37753.0
2022-12-19 04:00:00	MSFT	Stock	246.82	246.82	245.25	245.38	4583.0
2022-12-19 05:00:00	MSFT	Stock	245.41	246.2	245.4	246.2	3315.0
2022-12-19 06:00:00	MSFT	Stock	246.11	246.4	245.68	245.88	3930.0
2022-12-19 07:00:00	MSFT	Stock	245.95	246.38	245.77	246.29	12349.0
2022-12-19 08:00:00	MSFT	Stock	245.9601	246.39	244.8	245.46	39286.0
2022-12-19 09:00:00	MSFT	Stock	245.4	245.5	241.25	241.6511	2231656.0
2022-12-19 10:00:00	MSFT	Stock	241.66	242.96	240.27	241.265	3019076.0
2022-12-19 11:00:00	MSFT	Stock	241.25	241.26	239.0778	240.83	3284261.0
2022-12-19 12:00:00	MSFT	Stock	240.84	241.37	240.45	240.68	2124724.0
2022-12-19 13:00:00	MSFT	Stock	240.68	240.98	239.36	239.42	1788589.0
2022-12-19 14:00:00	MSFT	Stock	239.42	239.884	238.75	239.39	1969711.0
2022-12-19 15:00:00	MSFT	Stock	239.38	240.92	238.71	240.45	4114497.0
2022-12-19 16:00:00	MSFT	Stock	240.45	241.17	240.2	240.32	4679355.0
2022-12-19 17:00:00	MSFT	Stock	240.28	240.3	240.05	240.2421	9492.0
2022-12-19 18:00:00	MSFT	Stock	240.32	241.5	240.28	241.45	14626.0
2022-12-19 19:00:00	MSFT	Stock	241.27	241.6	241.23	241.36	9904.0
2022-12-19 04:00:00	NVDA	Stock	16.589	16.612	16.558	16.571	59500.0
2022-12-19 05:00:00	NVDA	Stock	16.591	16.615	16.591	16.61	17210.0
2022-12-19 06:00:00	NVDA	Stock	16.613	16.639	16.568	16.571	31490.0
2022-12-19 07:00:00	NVDA	Stock	16.59	16.674	16.57	16.66	141830.0
2022-12-19 08:00:00	NVDA	Stock	16.66	16.695	16.494	16.595	370990.0
2022-12-19 09:00:00	NVDA	Stock	16.607	16.635	16.177	16.2635	34155080.0
2022-12-19 10:00:00	NVDA	Stock	16.2636	16.377	16.172	16.294	49375120.0
2022-12-19 11:00:00	NVDA	Stock	16.298	16.429	16.175	16.2088	45371640.0
2022-12-19 12:00:00	NVDA	Stock	16.2075	16.464	16.2075	16.41	35564450.0
2022-12-19 13:00:00	NVDA	Stock	16.4119	16.4257	16.291	16.301	22800020.0
2022-12-19 14:00:00	NVDA	Stock	16.297	16.328	16.204	16.251	31454690.0
2022-12-19 15:00:00	NVDA	Stock	16.25	16.286	16.145	16.258	50075840.0
2022-12-19 16:00:00	NVDA	Stock	16.259	16.269	16.2271	16.231	25188410.0
2022-12-19 17:00:00	NVDA	Stock	16.227	16.239	16.212	16.23	80020.0
2022-12-19 18:00:00	NVDA	Stock	16.23	16.25	16.23	16.247	155130.0
2022-12-19 19:00:00	NVDA	Stock	16.244	16.254	16.231	16.254	110150.0
2022-12-19 04:00:00	AMZN	Stock	88.04	88.25	88.01	88.07	14415.0
2022-12-19 05:00:00	AMZN	Stock	88.08	88.34	88.03	88.21	10155.0

> showing 50 of 61,917 rows — these rows as CSV

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