PREVIEW / stock_1hour / 2009-10-05

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-10-05.parquet
  size:    891 KB
  rows:    42,740
  symbols: 3,385

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
2009-10-05 04:00:00	AAPL	Stock	6.6393	6.6393	6.6393	6.6393	2800.0
2009-10-05 05:00:00	AAPL	Stock	6.6518	6.6518	6.6518	6.6518	2800.0
2009-10-05 07:00:00	AAPL	Stock	6.6511	6.6571	6.6386	6.6571	226072.0
2009-10-05 08:00:00	AAPL	Stock	6.6571	6.6761	6.6539	6.6568	2226840.0
2009-10-05 09:00:00	AAPL	Stock	6.6554	6.6679	6.6097	6.6185	77278852.0
2009-10-05 10:00:00	AAPL	Stock	6.6193	6.6536	6.5811	6.6521	106490048.0
2009-10-05 11:00:00	AAPL	Stock	6.6518	6.6564	6.6236	6.6446	43027040.0
2009-10-05 12:00:00	AAPL	Stock	6.6439	6.6636	6.6336	6.6621	30910068.0
2009-10-05 13:00:00	AAPL	Stock	6.6625	6.6643	6.6457	6.6534	28776944.0
2009-10-05 14:00:00	AAPL	Stock	6.6532	6.6736	6.6368	6.6621	50884848.0
2009-10-05 15:00:00	AAPL	Stock	6.6614	6.6711	6.6357	6.6429	67185636.0
2009-10-05 16:00:00	AAPL	Stock	6.6429	6.6496	6.6399	6.6482	7215656.0
2009-10-05 17:00:00	AAPL	Stock	6.6464	6.6582	6.6029	6.6582	2532628.0
2009-10-05 18:00:00	AAPL	Stock	6.6436	6.6604	6.6436	6.6536	316288.0
2009-10-05 19:00:00	AAPL	Stock	6.6536	6.6571	6.6493	6.6493	154560.0
2009-10-05 08:00:00	MSFT	Stock	24.96	25.19	24.96	25.13	56895.0
2009-10-05 09:00:00	MSFT	Stock	25.13	25.15	24.79	24.81	5665546.0
2009-10-05 10:00:00	MSFT	Stock	24.81	24.86	24.54	24.76	11470805.0
2009-10-05 11:00:00	MSFT	Stock	24.75	24.805	24.63	24.672	6197485.0
2009-10-05 12:00:00	MSFT	Stock	24.68	24.68	24.53	24.55	6900720.0
2009-10-05 13:00:00	MSFT	Stock	24.56	24.62	24.54	24.576	4647983.0
2009-10-05 14:00:00	MSFT	Stock	24.57	24.65	24.52	24.57	6711353.0
2009-10-05 15:00:00	MSFT	Stock	24.57	24.7	24.55	24.65	11476227.0
2009-10-05 16:00:00	MSFT	Stock	24.65	24.66	24.6	24.62	2033260.0
2009-10-05 17:00:00	MSFT	Stock	24.96	24.96	24.56	24.61	471130.0
2009-10-05 18:00:00	MSFT	Stock	24.65	24.65	24.63	24.64	20087.0
2009-10-05 19:00:00	MSFT	Stock	24.64	24.64	24.64	24.64	2785.0
2009-10-05 08:00:00	NVDA	Stock	0.35	0.3518	0.35	0.35	128480.0
2009-10-05 09:00:00	NVDA	Stock	0.3513	0.3518	0.3455	0.3455	101277880.0
2009-10-05 10:00:00	NVDA	Stock	0.3458	0.3478	0.3385	0.3468	159156120.0
2009-10-05 11:00:00	NVDA	Stock	0.3468	0.3475	0.3385	0.3415	138131560.0
2009-10-05 12:00:00	NVDA	Stock	0.3418	0.3448	0.3408	0.344	65819120.0
2009-10-05 13:00:00	NVDA	Stock	0.3442	0.346	0.344	0.3453	45620000.0
2009-10-05 14:00:00	NVDA	Stock	0.3455	0.3455	0.3418	0.3448	84731240.0
2009-10-05 15:00:00	NVDA	Stock	0.3448	0.3462	0.343	0.3445	131649120.0
2009-10-05 16:00:00	NVDA	Stock	0.344	0.3446	0.3433	0.3445	5272240.0
2009-10-05 17:00:00	NVDA	Stock	0.3445	0.3453	0.3438	0.3438	627800.0
2009-10-05 18:00:00	NVDA	Stock	0.3445	0.3445	0.3445	0.3445	53600.0
2009-10-05 19:00:00	NVDA	Stock	0.345	0.345	0.345	0.345	4000.0
2009-10-05 04:00:00	AMZN	Stock	4.5325	4.5325	4.5325	4.5325	2000.0
2009-10-05 07:00:00	AMZN	Stock	4.5945	4.5945	4.5795	4.5795	4000.0
2009-10-05 08:00:00	AMZN	Stock	4.5265	4.541	4.5265	4.5345	46000.0
2009-10-05 09:00:00	AMZN	Stock	4.525	4.5465	4.4755	4.5248	11125640.0
2009-10-05 10:00:00	AMZN	Stock	4.524	4.542	4.455	4.522	18184300.0
2009-10-05 11:00:00	AMZN	Stock	4.523	4.543	4.4825	4.497	13278740.0
2009-10-05 12:00:00	AMZN	Stock	4.499	4.5005	4.4715	4.4885	11325080.0
2009-10-05 13:00:00	AMZN	Stock	4.4885	4.499	4.483	4.484	17111700.0
2009-10-05 14:00:00	AMZN	Stock	4.484	4.487	4.4395	4.445	24455840.0
2009-10-05 15:00:00	AMZN	Stock	4.4455	4.4515	4.4135	4.433	40063780.0
2009-10-05 16:00:00	AMZN	Stock	4.433	4.472	4.431	4.4335	3276360.0

> showing 50 of 42,740 rows — these rows as CSV

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