PREVIEW / stock_1hour / 2007-12-17

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-12-17.parquet
  size:    812 KB
  rows:    40,596
  symbols: 3,232

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-12-17 05:00:00	AAPL	Stock	6.7589	6.7589	6.7589	6.7589	8400.0
2007-12-17 06:00:00	AAPL	Stock	6.7568	6.7568	6.7568	6.7568	2800.0
2007-12-17 07:00:00	AAPL	Stock	6.7518	6.7946	6.75	6.7857	386008.0
2007-12-17 08:00:00	AAPL	Stock	6.7839	6.8282	6.7718	6.8089	2555896.0
2007-12-17 09:00:00	AAPL	Stock	6.8121	6.8804	6.8071	6.825	120308524.0
2007-12-17 10:00:00	AAPL	Stock	6.8239	6.8254	6.7286	6.7492	164701572.0
2007-12-17 11:00:00	AAPL	Stock	6.7486	6.7668	6.6468	6.675	144921392.0
2007-12-17 12:00:00	AAPL	Stock	6.675	6.7021	6.6643	6.6939	69741924.0
2007-12-17 13:00:00	AAPL	Stock	6.6939	6.6975	6.535	6.5464	146497904.0
2007-12-17 14:00:00	AAPL	Stock	6.5471	6.6311	6.535	6.5768	151645340.0
2007-12-17 15:00:00	AAPL	Stock	6.5769	6.6429	6.5571	6.5886	198487632.0
2007-12-17 16:00:00	AAPL	Stock	6.5868	6.7996	6.5696	6.5732	23238880.0
2007-12-17 17:00:00	AAPL	Stock	6.575	6.6786	6.5554	6.5561	924056.0
2007-12-17 18:00:00	AAPL	Stock	6.5561	6.5857	6.5561	6.5704	810908.0
2007-12-17 19:00:00	AAPL	Stock	6.5732	6.5857	6.5714	6.5843	463316.0
2007-12-17 08:00:00	MSFT	Stock	35.14	35.31	35.11	35.15	12670.0
2007-12-17 09:00:00	MSFT	Stock	35.14	35.16	34.84	34.96	5949339.0
2007-12-17 10:00:00	MSFT	Stock	34.96	35.05	34.78	35.0	7365531.0
2007-12-17 11:00:00	MSFT	Stock	35.0	35.1	34.95	34.98	8301644.0
2007-12-17 12:00:00	MSFT	Stock	34.98	35.05	34.83	35.0	4085497.0
2007-12-17 13:00:00	MSFT	Stock	35.0	35.0	34.61	34.68	6121473.0
2007-12-17 14:00:00	MSFT	Stock	34.68	35.05	34.47	34.53	6216357.0
2007-12-17 15:00:00	MSFT	Stock	34.53	34.66	34.36	34.39	14332435.0
2007-12-17 16:00:00	MSFT	Stock	34.39	35.31	34.39	34.47	3683253.0
2007-12-17 17:00:00	MSFT	Stock	34.39	34.45	34.39	34.39	2177381.0
2007-12-17 18:00:00	MSFT	Stock	34.4	34.5	34.39	34.45	29196.0
2007-12-17 19:00:00	MSFT	Stock	34.46	34.46	34.43	34.43	1000.0
2007-12-17 08:00:00	NVDA	Stock	0.8768	0.8768	0.8768	0.8768	16320.0
2007-12-17 09:00:00	NVDA	Stock	0.8655	0.8758	0.8655	0.8678	32599040.0
2007-12-17 10:00:00	NVDA	Stock	0.8675	0.8742	0.8598	0.8715	63890960.0
2007-12-17 11:00:00	NVDA	Stock	0.8716	0.8738	0.8642	0.865	50121600.0
2007-12-17 12:00:00	NVDA	Stock	0.865	0.8678	0.8608	0.8645	32471720.0
2007-12-17 13:00:00	NVDA	Stock	0.8645	0.8645	0.8502	0.852	39307800.0
2007-12-17 14:00:00	NVDA	Stock	0.852	0.8545	0.8365	0.8368	72244520.0
2007-12-17 15:00:00	NVDA	Stock	0.8368	0.8422	0.83	0.832	127999240.0
2007-12-17 16:00:00	NVDA	Stock	0.8335	0.8768	0.832	0.8375	74521640.0
2007-12-17 17:00:00	NVDA	Stock	0.832	0.8375	0.832	0.8375	57040.0
2007-12-17 18:00:00	NVDA	Stock	0.8375	0.8375	0.832	0.832	254520.0
2007-12-17 19:00:00	NVDA	Stock	0.8375	0.8375	0.8363	0.8363	16000.0
2007-12-17 08:00:00	AMZN	Stock	4.4495	4.4725	4.425	4.4725	177060.0
2007-12-17 09:00:00	AMZN	Stock	4.4565	4.4575	4.3425	4.3465	23282280.0
2007-12-17 10:00:00	AMZN	Stock	4.3465	4.3755	4.3218	4.3575	28254460.0
2007-12-17 11:00:00	AMZN	Stock	4.3565	4.373	4.3	4.315	20071840.0
2007-12-17 12:00:00	AMZN	Stock	4.315	4.35	4.3055	4.3495	9791080.0
2007-12-17 13:00:00	AMZN	Stock	4.35	4.35	4.2845	4.2915	14179620.0
2007-12-17 14:00:00	AMZN	Stock	4.2915	4.317	4.262	4.2665	15161180.0
2007-12-17 15:00:00	AMZN	Stock	4.2675	4.295	4.2495	4.255	32811200.0
2007-12-17 16:00:00	AMZN	Stock	4.257	4.454	4.2425	4.2545	5845200.0
2007-12-17 17:00:00	AMZN	Stock	4.2535	4.2955	4.2535	4.2955	1410000.0
2007-12-17 18:00:00	AMZN	Stock	4.2625	4.2625	4.246	4.26	13200.0

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

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