PREVIEW / stock_1hour / 2009-08-24

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-08-24.parquet
  size:    875 KB
  rows:    41,968
  symbols: 3,390

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-24 04:00:00	AAPL	Stock	6.0482	6.0714	6.0482	6.0714	7560.0
2009-08-24 07:00:00	AAPL	Stock	6.0679	6.0761	6.0643	6.0761	202188.0
2009-08-24 08:00:00	AAPL	Stock	6.0718	6.0882	6.0643	6.0814	2411724.0
2009-08-24 09:00:00	AAPL	Stock	6.0821	6.0875	6.025	6.071	95577832.0
2009-08-24 10:00:00	AAPL	Stock	6.07	6.0968	6.0686	6.0849	65483124.0
2009-08-24 11:00:00	AAPL	Stock	6.0854	6.095	6.0661	6.0668	34902252.0
2009-08-24 12:00:00	AAPL	Stock	6.0668	6.0714	6.0546	6.0632	30428552.0
2009-08-24 13:00:00	AAPL	Stock	6.0632	6.065	6.0332	6.0386	44689764.0
2009-08-24 14:00:00	AAPL	Stock	6.0386	6.0607	6.0368	6.05	28546756.0
2009-08-24 15:00:00	AAPL	Stock	6.0496	6.0893	6.0096	6.0429	77913444.0
2009-08-24 16:00:00	AAPL	Stock	6.0393	6.0569	6.0214	6.0232	13663216.0
2009-08-24 17:00:00	AAPL	Stock	6.0214	6.0261	6.0179	6.0229	390656.0
2009-08-24 18:00:00	AAPL	Stock	6.0379	6.0379	6.0179	6.0243	329728.0
2009-08-24 19:00:00	AAPL	Stock	6.0239	6.0239	6.0082	6.0111	235032.0
2009-08-24 04:00:00	MSFT	Stock	24.5	24.5	24.5	24.5	700.0
2009-08-24 08:00:00	MSFT	Stock	24.42	24.5	24.32	24.49	26918.0
2009-08-24 09:00:00	MSFT	Stock	24.46	24.6	24.28	24.53	7812046.0
2009-08-24 10:00:00	MSFT	Stock	24.53	24.68	24.51	24.641	9137289.0
2009-08-24 11:00:00	MSFT	Stock	24.65	24.68	24.6	24.64	4291666.0
2009-08-24 12:00:00	MSFT	Stock	24.64	24.69	24.63	24.65	4671993.0
2009-08-24 13:00:00	MSFT	Stock	24.65	24.67	24.51	24.64	8175120.0
2009-08-24 14:00:00	MSFT	Stock	24.64	24.65	24.5	24.56	4096687.0
2009-08-24 15:00:00	MSFT	Stock	24.56	24.68	24.49	24.66	13576451.0
2009-08-24 16:00:00	MSFT	Stock	24.64	24.67	24.52	24.6	1237821.0
2009-08-24 17:00:00	MSFT	Stock	24.6	24.6	24.6	24.6	1600.0
2009-08-24 18:00:00	MSFT	Stock	24.64	24.64	24.61	24.61	13679.0
2009-08-24 19:00:00	MSFT	Stock	24.6	24.67	24.6	24.65	7915.0
2009-08-24 08:00:00	NVDA	Stock	0.347	0.35	0.3468	0.35	76000.0
2009-08-24 09:00:00	NVDA	Stock	0.3498	0.3498	0.3453	0.3488	59673080.0
2009-08-24 10:00:00	NVDA	Stock	0.3485	0.35	0.345	0.3455	68449200.0
2009-08-24 11:00:00	NVDA	Stock	0.3454	0.3455	0.3419	0.3422	45892680.0
2009-08-24 12:00:00	NVDA	Stock	0.3422	0.345	0.3415	0.342	53621920.0
2009-08-24 13:00:00	NVDA	Stock	0.342	0.342	0.339	0.34	86088800.0
2009-08-24 14:00:00	NVDA	Stock	0.34	0.3413	0.3384	0.339	32795320.0
2009-08-24 15:00:00	NVDA	Stock	0.3388	0.3395	0.3365	0.3385	105529480.0
2009-08-24 16:00:00	NVDA	Stock	0.3385	0.3396	0.3382	0.3385	7717080.0
2009-08-24 18:00:00	NVDA	Stock	0.3393	0.3393	0.3385	0.3385	20000.0
2009-08-24 04:00:00	AMZN	Stock	4.275	4.275	4.275	4.275	2000.0
2009-08-24 08:00:00	AMZN	Stock	4.265	4.274	4.25	4.2635	102580.0
2009-08-24 09:00:00	AMZN	Stock	4.2625	4.2725	4.214	4.225	18616940.0
2009-08-24 10:00:00	AMZN	Stock	4.2253	4.264	4.222	4.2565	14817900.0
2009-08-24 11:00:00	AMZN	Stock	4.258	4.2795	4.254	4.261	9623360.0
2009-08-24 12:00:00	AMZN	Stock	4.2608	4.27	4.2585	4.2625	6762820.0
2009-08-24 13:00:00	AMZN	Stock	4.2635	4.2635	4.236	4.249	13546020.0
2009-08-24 14:00:00	AMZN	Stock	4.2475	4.258	4.238	4.2425	6726100.0
2009-08-24 15:00:00	AMZN	Stock	4.243	4.243	4.212	4.2255	19179640.0
2009-08-24 16:00:00	AMZN	Stock	4.228	4.27	4.2185	4.2325	314920.0
2009-08-24 17:00:00	AMZN	Stock	4.234	4.234	4.225	4.225	10000.0
2009-08-24 19:00:00	AMZN	Stock	4.2245	4.225	4.2245	4.225	4500.0
2009-08-24 08:00:00	TLT	Stock	93.81	93.81	93.49	93.51	12200.0

> showing 50 of 41,968 rows — these rows as CSV

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