PREVIEW / stock_1hour / 2005-07-27

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-07-27.parquet
  size:    554 KB
  rows:    26,274
  symbols: 2,042

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
2005-07-27 07:00:00	AAPL	Stock	1.5564	1.5564	1.5564	1.5564	14000.0
2005-07-27 08:00:00	AAPL	Stock	1.5561	1.5607	1.5561	1.5607	230748.0
2005-07-27 09:00:00	AAPL	Stock	1.5607	1.5668	1.5368	1.54	36304044.0
2005-07-27 10:00:00	AAPL	Stock	1.54	1.5529	1.5239	1.5439	65378404.0
2005-07-27 11:00:00	AAPL	Stock	1.5439	1.5489	1.5439	1.5461	20416676.0
2005-07-27 12:00:00	AAPL	Stock	1.5464	1.5529	1.5446	1.55	29866424.0
2005-07-27 13:00:00	AAPL	Stock	1.5504	1.5582	1.5475	1.5546	24856832.0
2005-07-27 14:00:00	AAPL	Stock	1.555	1.5739	1.5536	1.5689	53909072.0
2005-07-27 15:00:00	AAPL	Stock	1.5689	1.5718	1.5661	1.5711	46644108.0
2005-07-27 16:00:00	AAPL	Stock	1.5711	1.5711	1.5571	1.5711	523936.0
2005-07-27 17:00:00	AAPL	Stock	1.5679	1.57	1.5679	1.5693	91560.0
2005-07-27 18:00:00	AAPL	Stock	1.5693	1.5693	1.5693	1.5693	2800.0
2005-07-27 07:00:00	MSFT	Stock	25.6	25.6	25.6	25.6	300.0
2005-07-27 08:00:00	MSFT	Stock	25.59	25.61	25.55	25.61	36964.0
2005-07-27 09:00:00	MSFT	Stock	25.6	25.63	25.53	25.56	7495211.0
2005-07-27 10:00:00	MSFT	Stock	25.57	25.76	25.54	25.7	11031862.0
2005-07-27 11:00:00	MSFT	Stock	25.7	25.74	25.61	25.64	5927868.0
2005-07-27 12:00:00	MSFT	Stock	25.64	25.7	25.62	25.67	5082158.0
2005-07-27 13:00:00	MSFT	Stock	25.67	25.75	25.6	25.65	6498452.0
2005-07-27 14:00:00	MSFT	Stock	25.65	25.76	25.64	25.74	7757893.0
2005-07-27 15:00:00	MSFT	Stock	25.75	25.8	25.68	25.72	12510113.0
2005-07-27 16:00:00	MSFT	Stock	25.72	25.76	25.7	25.72	258852.0
2005-07-27 17:00:00	MSFT	Stock	25.71	25.71	25.7	25.7	6800.0
2005-07-27 18:00:00	MSFT	Stock	25.72	25.72	25.65	25.65	51146.0
2005-07-27 08:00:00	NVDA	Stock	0.2212	0.2223	0.2212	0.2223	144000.0
2005-07-27 09:00:00	NVDA	Stock	0.2212	0.2218	0.2192	0.22	62757360.0
2005-07-27 10:00:00	NVDA	Stock	0.22	0.2222	0.2176	0.2217	183972000.0
2005-07-27 11:00:00	NVDA	Stock	0.2217	0.2228	0.2217	0.2226	64902720.0
2005-07-27 12:00:00	NVDA	Stock	0.2226	0.2254	0.2225	0.2241	101321640.0
2005-07-27 13:00:00	NVDA	Stock	0.2241	0.2247	0.2231	0.2243	51725880.0
2005-07-27 14:00:00	NVDA	Stock	0.2242	0.2265	0.2242	0.2261	130165440.0
2005-07-27 15:00:00	NVDA	Stock	0.2261	0.2263	0.2242	0.2255	169904040.0
2005-07-27 16:00:00	NVDA	Stock	0.2253	0.2257	0.2247	0.2247	1301160.0
2005-07-27 17:00:00	NVDA	Stock	0.2255	0.2257	0.2255	0.2257	336000.0
2005-07-27 18:00:00	NVDA	Stock	0.2279	0.2279	0.2279	0.2279	240000.0
2005-07-27 07:00:00	AMZN	Stock	2.1	2.1	2.06	2.065	770980.0
2005-07-27 08:00:00	AMZN	Stock	2.065	2.1045	2.055	2.0985	21562600.0
2005-07-27 09:00:00	AMZN	Stock	2.099	2.132	2.092	2.1025	205438560.0
2005-07-27 10:00:00	AMZN	Stock	2.102	2.131	2.096	2.123	186656200.0
2005-07-27 11:00:00	AMZN	Stock	2.1235	2.1265	2.1115	2.1185	61049740.0
2005-07-27 12:00:00	AMZN	Stock	2.1185	2.1275	2.113	2.12	51803980.0
2005-07-27 13:00:00	AMZN	Stock	2.12	2.1245	2.1185	2.1235	42620900.0
2005-07-27 14:00:00	AMZN	Stock	2.1235	2.162	2.1226	2.1605	166790400.0
2005-07-27 15:00:00	AMZN	Stock	2.161	2.187	2.157	2.1825	173467240.0
2005-07-27 16:00:00	AMZN	Stock	2.1815	2.183	2.1625	2.18	5713820.0
2005-07-27 17:00:00	AMZN	Stock	2.1775	2.186	2.1705	2.1755	370500.0
2005-07-27 18:00:00	AMZN	Stock	2.177	2.1785	2.1755	2.1785	73500.0
2005-07-27 08:00:00	CL	Stock	25.88	25.88	25.88	25.88	200.0
2005-07-27 09:00:00	CL	Stock	26.025	26.26	26.025	26.24	1075000.0
2005-07-27 10:00:00	CL	Stock	26.25	26.28	26.025	26.09	1293200.0

> showing 50 of 26,274 rows — these rows as CSV

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