PREVIEW / stock_1hour / 2010-01-06

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-01-06.parquet
  size:    907 KB
  rows:    43,243
  symbols: 3,442

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
2010-01-06 04:00:00	AAPL	Stock	7.6668	7.675	7.6668	7.675	14000.0
2010-01-06 06:00:00	AAPL	Stock	7.6782	7.6782	7.6782	7.6782	3584.0
2010-01-06 07:00:00	AAPL	Stock	7.6782	7.6782	7.6464	7.6611	152516.0
2010-01-06 08:00:00	AAPL	Stock	7.6607	7.6696	7.6507	7.6679	565348.0
2010-01-06 09:00:00	AAPL	Stock	7.6682	7.6868	7.6346	7.6536	66505656.0
2010-01-06 10:00:00	AAPL	Stock	7.6529	7.6736	7.6457	7.6661	74548236.0
2010-01-06 11:00:00	AAPL	Stock	7.6664	7.6821	7.6168	7.6254	64377152.0
2010-01-06 12:00:00	AAPL	Stock	7.6257	7.6304	7.5857	7.5946	78493996.0
2010-01-06 13:00:00	AAPL	Stock	7.5946	7.6193	7.5432	7.5579	75613832.0
2010-01-06 14:00:00	AAPL	Stock	7.5568	7.6107	7.5446	7.5786	79435608.0
2010-01-06 15:00:00	AAPL	Stock	7.5779	7.5825	7.5268	7.5336	94707368.0
2010-01-06 16:00:00	AAPL	Stock	7.5346	7.617	7.5311	7.5393	8198400.0
2010-01-06 17:00:00	AAPL	Stock	7.5614	7.5614	7.5334	7.5439	478632.0
2010-01-06 18:00:00	AAPL	Stock	7.5446	7.5536	7.5346	7.5525	1491028.0
2010-01-06 19:00:00	AAPL	Stock	7.5507	7.5564	7.55	7.5561	477792.0
2010-01-06 20:00:00	AAPL	Stock	7.6521	7.6521	7.6521	7.6521	5600.0
2010-01-06 07:00:00	MSFT	Stock	30.9	30.9	30.9	30.9	1400.0
2010-01-06 08:00:00	MSFT	Stock	30.97	31.06	30.97	31.06	3526.0
2010-01-06 09:00:00	MSFT	Stock	31.04	31.08	30.88	31.0	5260963.0
2010-01-06 10:00:00	MSFT	Stock	31.0	31.05	30.915	30.96	7776691.0
2010-01-06 11:00:00	MSFT	Stock	30.96	31.0	30.68	30.69	6276466.0
2010-01-06 12:00:00	MSFT	Stock	30.68	30.861	30.52	30.62	7886071.0
2010-01-06 13:00:00	MSFT	Stock	30.62	30.71	30.53	30.54	4933351.0
2010-01-06 14:00:00	MSFT	Stock	30.54	30.83	30.538	30.76	8319574.0
2010-01-06 15:00:00	MSFT	Stock	30.76	30.8	30.56	30.77	10691416.0
2010-01-06 16:00:00	MSFT	Stock	30.77	30.8	30.612	30.73	4687191.0
2010-01-06 17:00:00	MSFT	Stock	30.64	30.77	30.64	30.77	41550.0
2010-01-06 18:00:00	MSFT	Stock	30.72	30.77	30.72	30.77	2364.0
2010-01-06 19:00:00	MSFT	Stock	30.77	30.77	30.65	30.68	6950.0
2010-01-06 20:00:00	MSFT	Stock	30.72	30.72	30.72	30.72	1400.0
2010-01-06 08:00:00	NVDA	Stock	0.469	0.469	0.469	0.469	40000.0
2010-01-06 09:00:00	NVDA	Stock	0.469	0.4692	0.4644	0.4652	43020440.0
2010-01-06 10:00:00	NVDA	Stock	0.465	0.4675	0.4643	0.4674	111116360.0
2010-01-06 11:00:00	NVDA	Stock	0.4675	0.4708	0.4665	0.47	63489240.0
2010-01-06 12:00:00	NVDA	Stock	0.47	0.472	0.4692	0.4718	94767720.0
2010-01-06 13:00:00	NVDA	Stock	0.4718	0.472	0.468	0.469	115716640.0
2010-01-06 14:00:00	NVDA	Stock	0.4691	0.4723	0.469	0.4708	58030920.0
2010-01-06 15:00:00	NVDA	Stock	0.4705	0.473	0.4695	0.4723	135346920.0
2010-01-06 16:00:00	NVDA	Stock	0.4723	0.473	0.4688	0.473	13899360.0
2010-01-06 17:00:00	NVDA	Stock	0.472	0.4723	0.472	0.4723	44000.0
2010-01-06 18:00:00	NVDA	Stock	0.4723	0.473	0.4723	0.473	11000.0
2010-01-06 19:00:00	NVDA	Stock	0.4728	0.4728	0.4725	0.4725	56000.0
2010-01-06 20:00:00	NVDA	Stock	0.47	0.47	0.47	0.47	4432000.0
2010-01-06 08:00:00	AMZN	Stock	6.7275	6.745	6.7275	6.745	81840.0
2010-01-06 09:00:00	AMZN	Stock	6.744	6.755	6.6565	6.672	18963100.0
2010-01-06 10:00:00	AMZN	Stock	6.672	6.71	6.6275	6.6625	27907780.0
2010-01-06 11:00:00	AMZN	Stock	6.6645	6.684	6.626	6.6285	13764800.0
2010-01-06 12:00:00	AMZN	Stock	6.6275	6.6375	6.5925	6.627	19116300.0
2010-01-06 13:00:00	AMZN	Stock	6.626	6.646	6.5825	6.5945	14504400.0
2010-01-06 14:00:00	AMZN	Stock	6.5945	6.6525	6.5835	6.6325	22541340.0

> showing 50 of 43,243 rows — these rows as CSV

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