PREVIEW / stock_1hour / 2009-08-25

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-08-25.parquet
  size:    877 KB
  rows:    42,176
  symbols: 3,364

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-08-25 06:00:00	AAPL	Stock	6.0182	6.0182	6.0182	6.0182	14000.0
2009-08-25 07:00:00	AAPL	Stock	6.0357	6.0429	6.0357	6.0429	22960.0
2009-08-25 08:00:00	AAPL	Stock	6.0432	6.0804	6.0432	6.0804	2219448.0
2009-08-25 09:00:00	AAPL	Stock	6.0786	6.0893	6.0432	6.0893	49466508.0
2009-08-25 10:00:00	AAPL	Stock	6.0893	6.105	6.0536	6.0707	70318780.0
2009-08-25 11:00:00	AAPL	Stock	6.0704	6.0925	6.0664	6.0882	29665524.0
2009-08-25 12:00:00	AAPL	Stock	6.0889	6.0918	6.0675	6.0696	25318748.0
2009-08-25 13:00:00	AAPL	Stock	6.07	6.0775	6.0536	6.0607	30675092.0
2009-08-25 14:00:00	AAPL	Stock	6.0611	6.0764	6.0536	6.0679	36761312.0
2009-08-25 15:00:00	AAPL	Stock	6.0675	6.075	6.0404	6.05	63693308.0
2009-08-25 16:00:00	AAPL	Stock	6.05	6.0689	6.0479	6.0489	10532452.0
2009-08-25 17:00:00	AAPL	Stock	6.0464	6.0691	6.0411	6.0446	506436.0
2009-08-25 18:00:00	AAPL	Stock	6.0421	6.05	6.0389	6.0446	393512.0
2009-08-25 19:00:00	AAPL	Stock	6.04	6.0464	6.0389	6.0443	117236.0
2009-08-25 07:00:00	MSFT	Stock	24.71	24.75	24.71	24.75	3300.0
2009-08-25 08:00:00	MSFT	Stock	24.66	24.7	24.65	24.66	6430.0
2009-08-25 09:00:00	MSFT	Stock	24.68	24.7	24.5	24.68	4953556.0
2009-08-25 10:00:00	MSFT	Stock	24.68	24.82	24.6	24.63	8020799.0
2009-08-25 11:00:00	MSFT	Stock	24.64	24.74	24.625	24.68	3529922.0
2009-08-25 12:00:00	MSFT	Stock	24.68	24.79	24.64	24.64	4179315.0
2009-08-25 13:00:00	MSFT	Stock	24.64	24.67	24.53	24.59	4976549.0
2009-08-25 14:00:00	MSFT	Stock	24.58	24.61	24.46	24.54	4105195.0
2009-08-25 15:00:00	MSFT	Stock	24.54	24.7	24.525	24.64	9661240.0
2009-08-25 16:00:00	MSFT	Stock	24.64	24.65	24.49	24.61	2678475.0
2009-08-25 17:00:00	MSFT	Stock	24.63	24.644	24.61	24.61	1858.0
2009-08-25 18:00:00	MSFT	Stock	24.61	24.63	24.61	24.61	2300.0
2009-08-25 19:00:00	MSFT	Stock	24.63	24.63	24.6	24.6	9174.0
2009-08-25 20:00:00	MSFT	Stock	24.64	24.69	24.64	24.69	6200.0
2009-08-25 08:00:00	NVDA	Stock	0.3438	0.3438	0.3405	0.3405	8000.0
2009-08-25 09:00:00	NVDA	Stock	0.3408	0.342	0.3345	0.3405	83286480.0
2009-08-25 10:00:00	NVDA	Stock	0.3405	0.3426	0.3362	0.339	81893120.0
2009-08-25 11:00:00	NVDA	Stock	0.339	0.3418	0.3373	0.3408	30849360.0
2009-08-25 12:00:00	NVDA	Stock	0.341	0.345	0.3398	0.3438	85636040.0
2009-08-25 13:00:00	NVDA	Stock	0.3435	0.3445	0.3418	0.3422	34241360.0
2009-08-25 14:00:00	NVDA	Stock	0.3425	0.343	0.3405	0.3408	37473880.0
2009-08-25 15:00:00	NVDA	Stock	0.3408	0.343	0.3402	0.3418	72158800.0
2009-08-25 16:00:00	NVDA	Stock	0.3415	0.3415	0.3405	0.3415	7696640.0
2009-08-25 19:00:00	NVDA	Stock	0.3408	0.3408	0.3408	0.3408	20000.0
2009-08-25 08:00:00	AMZN	Stock	4.225	4.2495	4.225	4.2495	246400.0
2009-08-25 09:00:00	AMZN	Stock	4.2485	4.272	4.1975	4.269	13100760.0
2009-08-25 10:00:00	AMZN	Stock	4.2695	4.317	4.25	4.2595	20295100.0
2009-08-25 11:00:00	AMZN	Stock	4.2595	4.2773	4.2575	4.2695	11324600.0
2009-08-25 12:00:00	AMZN	Stock	4.2695	4.2695	4.2365	4.2405	8830160.0
2009-08-25 13:00:00	AMZN	Stock	4.2405	4.2475	4.227	4.2315	7097120.0
2009-08-25 14:00:00	AMZN	Stock	4.2305	4.239	4.2105	4.22	10189800.0
2009-08-25 15:00:00	AMZN	Stock	4.2195	4.229	4.2056	4.2125	19951740.0
2009-08-25 16:00:00	AMZN	Stock	4.2125	4.245	4.2095	4.2095	4326640.0
2009-08-25 17:00:00	AMZN	Stock	4.21	4.2437	4.21	4.22	387640.0
2009-08-25 19:00:00	AMZN	Stock	4.2105	4.211	4.2105	4.211	11600.0
2009-08-25 20:00:00	AMZN	Stock	4.2675	4.2675	4.2675	4.2675	59920.0

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

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