PREVIEW / stock_1hour / 2007-12-13

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-12-13.parquet
  size:    813 KB
  rows:    40,249
  symbols: 3,218

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-13 05:00:00	AAPL	Stock	6.7746	6.7746	6.75	6.75	8960.0
2007-12-13 07:00:00	AAPL	Stock	6.7589	6.7743	6.7179	6.75	351820.0
2007-12-13 08:00:00	AAPL	Stock	6.75	6.7936	6.7304	6.7857	7201348.0
2007-12-13 09:00:00	AAPL	Stock	6.7857	6.8614	6.7679	6.7843	133247548.0
2007-12-13 10:00:00	AAPL	Stock	6.7839	6.8539	6.7586	6.78	157868844.0
2007-12-13 11:00:00	AAPL	Stock	6.78	6.7971	6.7411	6.7637	107256380.0
2007-12-13 12:00:00	AAPL	Stock	6.7639	6.7718	6.7218	6.7418	81998112.0
2007-12-13 13:00:00	AAPL	Stock	6.7418	6.7696	6.7079	6.7364	80684268.0
2007-12-13 14:00:00	AAPL	Stock	6.7364	6.8104	6.7257	6.7993	116353272.0
2007-12-13 15:00:00	AAPL	Stock	6.7979	6.8571	6.7696	6.8507	169552684.0
2007-12-13 16:00:00	AAPL	Stock	6.8486	6.8571	6.7807	6.85	9874312.0
2007-12-13 17:00:00	AAPL	Stock	6.8493	6.8571	6.8468	6.855	324408.0
2007-12-13 18:00:00	AAPL	Stock	6.855	6.8554	6.8468	6.85	330932.0
2007-12-13 19:00:00	AAPL	Stock	6.85	6.865	6.8436	6.8636	892500.0
2007-12-13 07:00:00	MSFT	Stock	34.5	34.5	34.5	34.5	200.0
2007-12-13 08:00:00	MSFT	Stock	34.4	34.4	34.21	34.38	40650.0
2007-12-13 09:00:00	MSFT	Stock	34.38	35.0	34.28	34.99	8010843.0
2007-12-13 10:00:00	MSFT	Stock	35.0	35.35	34.93	35.01	14497305.0
2007-12-13 11:00:00	MSFT	Stock	35.01	35.35	34.9	35.33	7750962.0
2007-12-13 12:00:00	MSFT	Stock	35.33	35.4	35.21	35.32	6157172.0
2007-12-13 13:00:00	MSFT	Stock	35.32	35.45	35.18	35.224	6489033.0
2007-12-13 14:00:00	MSFT	Stock	35.23	35.32	35.09	35.23	7781495.0
2007-12-13 15:00:00	MSFT	Stock	35.23	35.39	35.18	35.23	16513150.0
2007-12-13 16:00:00	MSFT	Stock	35.23	35.29	35.16	35.22	6558132.0
2007-12-13 17:00:00	MSFT	Stock	35.21	35.245	34.98	35.18	122785.0
2007-12-13 18:00:00	MSFT	Stock	35.17	35.3	35.17	35.3	7328.0
2007-12-13 19:00:00	MSFT	Stock	35.29	35.31	35.29	35.31	2100.0
2007-12-13 08:00:00	NVDA	Stock	0.88	0.88	0.87	0.87	412000.0
2007-12-13 09:00:00	NVDA	Stock	0.875	0.8818	0.8615	0.867	58031000.0
2007-12-13 10:00:00	NVDA	Stock	0.8672	0.869	0.8452	0.8458	85146320.0
2007-12-13 11:00:00	NVDA	Stock	0.8457	0.8572	0.8452	0.8562	52538800.0
2007-12-13 12:00:00	NVDA	Stock	0.8562	0.857	0.837	0.843	76107760.0
2007-12-13 13:00:00	NVDA	Stock	0.8428	0.8562	0.8428	0.854	54310600.0
2007-12-13 14:00:00	NVDA	Stock	0.8538	0.865	0.852	0.8565	52447520.0
2007-12-13 15:00:00	NVDA	Stock	0.856	0.8668	0.8538	0.8612	87389800.0
2007-12-13 16:00:00	NVDA	Stock	0.8608	0.8625	0.8546	0.8625	33975560.0
2007-12-13 17:00:00	NVDA	Stock	0.8612	0.8612	0.8612	0.8612	4000.0
2007-12-13 18:00:00	NVDA	Stock	0.8648	0.8648	0.8648	0.8648	8800.0
2007-12-13 07:00:00	AMZN	Stock	4.501	4.501	4.501	4.501	2000.0
2007-12-13 08:00:00	AMZN	Stock	4.513	4.54	4.513	4.54	55120.0
2007-12-13 09:00:00	AMZN	Stock	4.5365	4.65	4.522	4.61	17337860.0
2007-12-13 10:00:00	AMZN	Stock	4.6105	4.628	4.569	4.574	21056940.0
2007-12-13 11:00:00	AMZN	Stock	4.5735	4.596	4.542	4.5775	15803000.0
2007-12-13 12:00:00	AMZN	Stock	4.5775	4.59	4.549	4.5645	10345680.0
2007-12-13 13:00:00	AMZN	Stock	4.565	4.567	4.5315	4.546	11786080.0
2007-12-13 14:00:00	AMZN	Stock	4.545	4.581	4.5365	4.5564	13395680.0
2007-12-13 15:00:00	AMZN	Stock	4.555	4.644	4.5495	4.6185	27988680.0
2007-12-13 16:00:00	AMZN	Stock	4.62	4.6225	4.58	4.612	1552920.0
2007-12-13 17:00:00	AMZN	Stock	4.6115	4.62	4.6115	4.6185	366000.0
2007-12-13 18:00:00	AMZN	Stock	4.62	4.62	4.62	4.62	2019000.0

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

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