PREVIEW / stock_1hour / 2007-10-29

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-29.parquet
  size:    807 KB
  rows:    40,334
  symbols: 3,172

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
2007-10-29 06:00:00	AAPL	Stock	6.6607	6.6607	6.6607	6.6607	8708.0
2007-10-29 07:00:00	AAPL	Stock	6.6607	6.6607	6.6114	6.6554	420000.0
2007-10-29 08:00:00	AAPL	Stock	6.6475	6.6518	6.5982	6.6068	4199356.0
2007-10-29 09:00:00	AAPL	Stock	6.6068	6.6639	6.6036	6.6286	99322440.0
2007-10-29 10:00:00	AAPL	Stock	6.6275	6.6396	6.6	6.6229	111960100.0
2007-10-29 11:00:00	AAPL	Stock	6.6218	6.6336	6.6043	6.6119	68785920.0
2007-10-29 12:00:00	AAPL	Stock	6.6118	6.625	6.5986	6.6204	62219724.0
2007-10-29 13:00:00	AAPL	Stock	6.6204	6.6268	6.6111	6.6252	39457516.0
2007-10-29 14:00:00	AAPL	Stock	6.6246	6.6304	6.6043	6.6167	59905160.0
2007-10-29 15:00:00	AAPL	Stock	6.6161	6.625	6.5964	6.6071	79445604.0
2007-10-29 16:00:00	AAPL	Stock	6.6089	6.6302	6.6046	6.6071	13631072.0
2007-10-29 17:00:00	AAPL	Stock	6.6036	6.6197	6.6011	6.6166	711312.0
2007-10-29 18:00:00	AAPL	Stock	6.6166	6.6166	6.6011	6.6036	288260.0
2007-10-29 19:00:00	AAPL	Stock	6.605	6.6054	6.5964	6.6	201824.0
2007-10-29 05:00:00	MSFT	Stock	35.07	35.18	35.07	35.18	1300.0
2007-10-29 06:00:00	MSFT	Stock	35.18	35.18	35.18	35.18	180.0
2007-10-29 07:00:00	MSFT	Stock	35.2	35.25	35.12	35.2	20900.0
2007-10-29 08:00:00	MSFT	Stock	35.21	35.34	35.15	35.21	107422.0
2007-10-29 09:00:00	MSFT	Stock	35.21	35.26	34.8	35.23	20251797.0
2007-10-29 10:00:00	MSFT	Stock	35.22	35.29	34.75	34.8	21871712.0
2007-10-29 11:00:00	MSFT	Stock	34.8	34.89	34.66	34.81	9580625.0
2007-10-29 12:00:00	MSFT	Stock	34.82	34.84	34.7	34.79	8555556.0
2007-10-29 13:00:00	MSFT	Stock	34.79	34.79	34.62	34.765	12161905.0
2007-10-29 14:00:00	MSFT	Stock	34.76	34.85	34.6	34.63	15164181.0
2007-10-29 15:00:00	MSFT	Stock	34.63	34.68	34.45	34.56	16438621.0
2007-10-29 16:00:00	MSFT	Stock	34.56	35.24	34.52	34.57	10664927.0
2007-10-29 17:00:00	MSFT	Stock	34.56	34.8	34.56	34.6	50880.0
2007-10-29 18:00:00	MSFT	Stock	34.56	34.57	34.55	34.57	5066.0
2007-10-29 19:00:00	MSFT	Stock	34.59	34.59	34.5	34.5	7245.0
2007-10-29 07:00:00	NVDA	Stock	0.85	0.85	0.8375	0.848	872000.0
2007-10-29 08:00:00	NVDA	Stock	0.848	0.8525	0.8345	0.8352	3920640.0
2007-10-29 09:00:00	NVDA	Stock	0.8358	0.8438	0.8268	0.83	120924760.0
2007-10-29 10:00:00	NVDA	Stock	0.8295	0.8398	0.8152	0.8155	147170600.0
2007-10-29 11:00:00	NVDA	Stock	0.8155	0.8302	0.814	0.8298	123645640.0
2007-10-29 12:00:00	NVDA	Stock	0.8295	0.8382	0.8288	0.8315	111094600.0
2007-10-29 13:00:00	NVDA	Stock	0.8315	0.8372	0.8275	0.836	79489120.0
2007-10-29 14:00:00	NVDA	Stock	0.8363	0.8432	0.8342	0.835	86720280.0
2007-10-29 15:00:00	NVDA	Stock	0.8349	0.84	0.8302	0.8398	112299560.0
2007-10-29 16:00:00	NVDA	Stock	0.8398	0.842	0.8317	0.8398	16878200.0
2007-10-29 17:00:00	NVDA	Stock	0.84	0.8445	0.8398	0.8425	282560.0
2007-10-29 18:00:00	NVDA	Stock	0.8212	0.847	0.8212	0.847	463400.0
2007-10-29 19:00:00	NVDA	Stock	0.8462	0.8512	0.8438	0.8512	157120.0
2007-10-29 08:00:00	AMZN	Stock	4.51	4.5375	4.51	4.5135	217280.0
2007-10-29 09:00:00	AMZN	Stock	4.518	4.5225	4.4745	4.4975	20574440.0
2007-10-29 10:00:00	AMZN	Stock	4.5	4.505	4.474	4.496	26189180.0
2007-10-29 11:00:00	AMZN	Stock	4.4945	4.543	4.4925	4.531	18446740.0
2007-10-29 12:00:00	AMZN	Stock	4.5295	4.5475	4.5215	4.5332	13312260.0
2007-10-29 13:00:00	AMZN	Stock	4.5345	4.563	4.5315	4.5625	12948220.0
2007-10-29 14:00:00	AMZN	Stock	4.5625	4.5735	4.527	4.5321	19238900.0
2007-10-29 15:00:00	AMZN	Stock	4.5325	4.5555	4.5	4.505	25180400.0

> showing 50 of 40,334 rows — these rows as CSV

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