PREVIEW / stock_1hour / 2007-10-01

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-01.parquet
  size:    802 KB
  rows:    39,867
  symbols: 3,135

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-01 07:00:00	AAPL	Stock	5.4643	5.4768	5.4536	5.475	206640.0
2007-10-01 08:00:00	AAPL	Stock	5.4668	5.5254	5.4668	5.5029	5067188.0
2007-10-01 09:00:00	AAPL	Stock	5.5043	5.5311	5.4821	5.4889	95059188.0
2007-10-01 10:00:00	AAPL	Stock	5.4886	5.5036	5.4618	5.4929	126212744.0
2007-10-01 11:00:00	AAPL	Stock	5.4929	5.5654	5.4868	5.5645	154871640.0
2007-10-01 12:00:00	AAPL	Stock	5.565	5.5786	5.5518	5.5736	91808668.0
2007-10-01 13:00:00	AAPL	Stock	5.5739	5.5839	5.5621	5.5707	71229984.0
2007-10-01 14:00:00	AAPL	Stock	5.5711	5.6211	5.5704	5.6132	125392484.0
2007-10-01 15:00:00	AAPL	Stock	5.6129	5.6218	5.5664	5.5857	149724428.0
2007-10-01 16:00:00	AAPL	Stock	5.5864	5.5907	5.4831	5.5843	15321544.0
2007-10-01 17:00:00	AAPL	Stock	5.5846	5.5879	5.5818	5.5846	1140132.0
2007-10-01 18:00:00	AAPL	Stock	5.5846	5.5846	5.5757	5.5768	665672.0
2007-10-01 19:00:00	AAPL	Stock	5.5786	5.5854	5.5757	5.5854	371056.0
2007-10-01 04:00:00	MSFT	Stock	29.5	29.5	29.5	29.5	100.0
2007-10-01 08:00:00	MSFT	Stock	29.54	29.59	29.42	29.44	12025.0
2007-10-01 09:00:00	MSFT	Stock	29.46	29.73	29.41	29.68	5328221.0
2007-10-01 10:00:00	MSFT	Stock	29.69	29.75	29.55	29.56	5775830.0
2007-10-01 11:00:00	MSFT	Stock	29.57	29.61	29.53	29.58	4377257.0
2007-10-01 12:00:00	MSFT	Stock	29.58	29.69	29.58	29.619	4685337.0
2007-10-01 13:00:00	MSFT	Stock	29.61	29.72	29.6	29.71	4774707.0
2007-10-01 14:00:00	MSFT	Stock	29.71	29.77	29.56	29.74	5562291.0
2007-10-01 15:00:00	MSFT	Stock	29.73	29.79	29.72	29.76	9248149.0
2007-10-01 16:00:00	MSFT	Stock	29.77	29.79	29.635	29.704	3839161.0
2007-10-01 17:00:00	MSFT	Stock	29.72	29.75	29.677	29.73	252078.0
2007-10-01 18:00:00	MSFT	Stock	29.74	29.77	29.7	29.71	20660.0
2007-10-01 19:00:00	MSFT	Stock	29.75	29.75	29.71	29.71	250.0
2007-10-01 08:00:00	NVDA	Stock	0.906	0.9125	0.906	0.912	485240.0
2007-10-01 09:00:00	NVDA	Stock	0.912	0.9273	0.906	0.9215	57853480.0
2007-10-01 10:00:00	NVDA	Stock	0.922	0.9275	0.9205	0.927	57171400.0
2007-10-01 11:00:00	NVDA	Stock	0.927	0.9392	0.9268	0.9358	73587960.0
2007-10-01 12:00:00	NVDA	Stock	0.936	0.9388	0.9302	0.9385	36640520.0
2007-10-01 13:00:00	NVDA	Stock	0.9388	0.9428	0.9365	0.9385	35956760.0
2007-10-01 14:00:00	NVDA	Stock	0.9385	0.9462	0.9365	0.9462	41810600.0
2007-10-01 15:00:00	NVDA	Stock	0.946	0.9488	0.9378	0.9443	75839040.0
2007-10-01 16:00:00	NVDA	Stock	0.944	0.9443	0.9232	0.94	9612560.0
2007-10-01 17:00:00	NVDA	Stock	0.9443	0.9443	0.934	0.9443	3820000.0
2007-10-01 19:00:00	NVDA	Stock	0.9405	0.9472	0.9405	0.9472	34000.0
2007-10-01 07:00:00	AMZN	Stock	4.6675	4.6675	4.645	4.6575	30300.0
2007-10-01 08:00:00	AMZN	Stock	4.6575	4.6725	4.65	4.67	139660.0
2007-10-01 09:00:00	AMZN	Stock	4.67	4.705	4.655	4.655	13038880.0
2007-10-01 10:00:00	AMZN	Stock	4.654	4.668	4.6415	4.6576	16793000.0
2007-10-01 11:00:00	AMZN	Stock	4.6575	4.67	4.643	4.6665	13742000.0
2007-10-01 12:00:00	AMZN	Stock	4.6665	4.6665	4.6461	4.6614	10875380.0
2007-10-01 13:00:00	AMZN	Stock	4.662	4.668	4.6595	4.667	14348200.0
2007-10-01 14:00:00	AMZN	Stock	4.6675	4.6705	4.661	4.663	14589420.0
2007-10-01 15:00:00	AMZN	Stock	4.6635	4.67	4.656	4.669	18742920.0
2007-10-01 16:00:00	AMZN	Stock	4.669	4.672	4.6575	4.6642	1673720.0
2007-10-01 17:00:00	AMZN	Stock	4.6705	4.6705	4.6695	4.6695	2167180.0
2007-10-01 18:00:00	AMZN	Stock	4.6745	4.6885	4.6745	4.6775	16560.0
2007-10-01 19:00:00	AMZN	Stock	4.6655	4.6655	4.6655	4.6655	4000.0

> showing 50 of 39,867 rows — these rows as CSV

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