PREVIEW / stock_1hour / 2008-03-06

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-03-06.parquet
  size:    807 KB
  rows:    40,397
  symbols: 3,254

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
2008-03-06 04:00:00	AAPL	Stock	4.4711	4.4711	4.4711	4.4711	11200.0
2008-03-06 05:00:00	AAPL	Stock	4.4786	4.4786	4.4571	4.4571	16800.0
2008-03-06 06:00:00	AAPL	Stock	4.4575	4.4575	4.4571	4.4571	14000.0
2008-03-06 07:00:00	AAPL	Stock	4.4607	4.4821	4.4464	4.4464	745640.0
2008-03-06 08:00:00	AAPL	Stock	4.4518	4.4571	4.4175	4.4339	3040100.0
2008-03-06 09:00:00	AAPL	Stock	4.4318	4.5457	4.4254	4.5321	209394556.0
2008-03-06 10:00:00	AAPL	Stock	4.5293	4.5536	4.4957	4.5489	250902680.0
2008-03-06 11:00:00	AAPL	Stock	4.5489	4.5536	4.5039	4.5167	144553752.0
2008-03-06 12:00:00	AAPL	Stock	4.5175	4.5179	4.4357	4.4454	149817724.0
2008-03-06 13:00:00	AAPL	Stock	4.445	4.4889	4.3889	4.4086	252032312.0
2008-03-06 14:00:00	AAPL	Stock	4.4089	4.4671	4.405	4.4314	176583092.0
2008-03-06 15:00:00	AAPL	Stock	4.4304	4.4325	4.3146	4.3375	264770100.0
2008-03-06 16:00:00	AAPL	Stock	4.3368	4.5171	4.3171	4.3571	20241144.0
2008-03-06 17:00:00	AAPL	Stock	4.3571	4.3618	4.3189	4.3564	1300656.0
2008-03-06 18:00:00	AAPL	Stock	4.3482	4.3607	4.3475	4.3539	399476.0
2008-03-06 19:00:00	AAPL	Stock	4.3543	4.3589	4.3464	4.3564	213080.0
2008-03-06 07:00:00	MSFT	Stock	28.16	28.17	28.16	28.17	2100.0
2008-03-06 08:00:00	MSFT	Stock	28.17	28.17	28.01	28.01	111840.0
2008-03-06 09:00:00	MSFT	Stock	28.01	28.17	27.99	28.0	13231682.0
2008-03-06 10:00:00	MSFT	Stock	28.0	28.005	27.76	27.815	14038829.0
2008-03-06 11:00:00	MSFT	Stock	27.82	27.94	27.71	27.94	12157542.0
2008-03-06 12:00:00	MSFT	Stock	27.94	27.97	27.85	27.92	9226314.0
2008-03-06 13:00:00	MSFT	Stock	27.911	27.95	27.83	27.89	9694915.0
2008-03-06 14:00:00	MSFT	Stock	27.88	27.92	27.8	27.84	10508858.0
2008-03-06 15:00:00	MSFT	Stock	27.84	27.91	27.5	27.58	19134733.0
2008-03-06 16:00:00	MSFT	Stock	27.51	28.0	27.51	27.7	2952502.0
2008-03-06 17:00:00	MSFT	Stock	27.57	27.878	27.57	27.6	75546.0
2008-03-06 18:00:00	MSFT	Stock	27.57	27.62	27.57	27.61	1779.0
2008-03-06 19:00:00	MSFT	Stock	27.61	27.64	27.6	27.62	4907.0
2008-03-06 08:00:00	NVDA	Stock	0.5365	0.5367	0.5232	0.524	376000.0
2008-03-06 09:00:00	NVDA	Stock	0.5262	0.5262	0.5133	0.5135	73722560.0
2008-03-06 10:00:00	NVDA	Stock	0.5133	0.5135	0.5032	0.5099	180059400.0
2008-03-06 11:00:00	NVDA	Stock	0.51	0.51	0.5022	0.5088	132439120.0
2008-03-06 12:00:00	NVDA	Stock	0.5088	0.5088	0.5025	0.5032	76324240.0
2008-03-06 13:00:00	NVDA	Stock	0.5032	0.5048	0.5005	0.502	104672320.0
2008-03-06 14:00:00	NVDA	Stock	0.5018	0.5062	0.5	0.503	121933960.0
2008-03-06 15:00:00	NVDA	Stock	0.5032	0.5038	0.4952	0.496	283428000.0
2008-03-06 16:00:00	NVDA	Stock	0.4963	0.517	0.4875	0.5008	83645880.0
2008-03-06 17:00:00	NVDA	Stock	0.496	0.5008	0.496	0.4968	1988720.0
2008-03-06 18:00:00	NVDA	Stock	0.4963	0.4988	0.496	0.496	312000.0
2008-03-06 19:00:00	NVDA	Stock	0.4955	0.4965	0.493	0.4965	176000.0
2008-03-06 08:00:00	AMZN	Stock	3.24	3.245	3.231	3.233	68000.0
2008-03-06 09:00:00	AMZN	Stock	3.233	3.273	3.2285	3.246	19827340.0
2008-03-06 10:00:00	AMZN	Stock	3.2455	3.2605	3.212	3.2345	23660500.0
2008-03-06 11:00:00	AMZN	Stock	3.2345	3.236	3.1885	3.194	21156360.0
2008-03-06 12:00:00	AMZN	Stock	3.1935	3.1935	3.1405	3.145	20002980.0
2008-03-06 13:00:00	AMZN	Stock	3.145	3.1785	3.137	3.151	17825400.0
2008-03-06 14:00:00	AMZN	Stock	3.15	3.1735	3.141	3.1515	21771220.0
2008-03-06 15:00:00	AMZN	Stock	3.151	3.164	3.125	3.1375	37885780.0
2008-03-06 16:00:00	AMZN	Stock	3.137	3.2566	3.137	3.15	4562040.0

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

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