PREVIEW / stock_1hour / 2010-10-01

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-10-01.parquet
  size:    924 KB
  rows:    45,077
  symbols: 3,468

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-10-01 06:00:00	AAPL	Stock	10.1964	10.1964	10.1964	10.1964	2800.0
2010-10-01 07:00:00	AAPL	Stock	10.1893	10.1968	10.1539	10.1961	166740.0
2010-10-01 08:00:00	AAPL	Stock	10.1964	10.2204	10.1339	10.2171	2772056.0
2010-10-01 09:00:00	AAPL	Stock	10.2157	10.235	10.1339	10.1822	79586472.0
2010-10-01 10:00:00	AAPL	Stock	10.1832	10.1964	10.0482	10.105	127324624.0
2010-10-01 11:00:00	AAPL	Stock	10.1056	10.1429	10.0818	10.1267	46923296.0
2010-10-01 12:00:00	AAPL	Stock	10.1257	10.1325	10.1036	10.1286	28700616.0
2010-10-01 13:00:00	AAPL	Stock	10.1296	10.1357	10.0907	10.1064	30970184.0
2010-10-01 14:00:00	AAPL	Stock	10.1064	10.1354	10.0814	10.1106	36516844.0
2010-10-01 15:00:00	AAPL	Stock	10.1111	10.1489	10.09	10.09	82807172.0
2010-10-01 16:00:00	AAPL	Stock	10.09	10.2271	10.0843	10.0911	8338456.0
2010-10-01 17:00:00	AAPL	Stock	10.09	10.0989	10.09	10.0946	1239840.0
2010-10-01 18:00:00	AAPL	Stock	10.09	10.0946	10.09	10.0946	219492.0
2010-10-01 19:00:00	AAPL	Stock	10.0961	10.0964	10.09	10.0936	50568.0
2010-10-01 05:00:00	MSFT	Stock	24.7	24.71	24.7	24.71	500.0
2010-10-01 06:00:00	MSFT	Stock	24.7	24.7	24.66	24.66	1170.0
2010-10-01 07:00:00	MSFT	Stock	24.66	24.68	24.66	24.68	600.0
2010-10-01 08:00:00	MSFT	Stock	24.62	24.66	24.49	24.49	33385.0
2010-10-01 09:00:00	MSFT	Stock	24.49	24.82	24.49	24.75	6175369.0
2010-10-01 10:00:00	MSFT	Stock	24.74	24.76	24.38	24.39	12201357.0
2010-10-01 11:00:00	MSFT	Stock	24.39	24.46	24.35	24.44	8536556.0
2010-10-01 12:00:00	MSFT	Stock	24.44	24.5	24.39	24.41	6239740.0
2010-10-01 13:00:00	MSFT	Stock	24.41	24.51	24.39	24.405	6375703.0
2010-10-01 14:00:00	MSFT	Stock	24.405	24.44	24.3	24.31	8318419.0
2010-10-01 15:00:00	MSFT	Stock	24.31	24.39	24.3	24.38	10855094.0
2010-10-01 16:00:00	MSFT	Stock	24.38	24.646	24.33	24.38	2037544.0
2010-10-01 17:00:00	MSFT	Stock	24.49	24.7	24.38	24.38	71477.0
2010-10-01 18:00:00	MSFT	Stock	24.38	24.39	24.36	24.36	45371.0
2010-10-01 19:00:00	MSFT	Stock	24.39	24.4	24.39	24.39	3335.0
2010-10-01 08:00:00	NVDA	Stock	0.292	0.297	0.292	0.2965	808000.0
2010-10-01 09:00:00	NVDA	Stock	0.2962	0.2968	0.2912	0.2955	128936120.0
2010-10-01 10:00:00	NVDA	Stock	0.2955	0.2958	0.2882	0.2885	178780080.0
2010-10-01 11:00:00	NVDA	Stock	0.2885	0.289	0.2838	0.285	217257360.0
2010-10-01 12:00:00	NVDA	Stock	0.285	0.285	0.2815	0.284	107090640.0
2010-10-01 13:00:00	NVDA	Stock	0.284	0.2855	0.2822	0.2838	82711280.0
2010-10-01 14:00:00	NVDA	Stock	0.2838	0.2852	0.2825	0.2832	94024240.0
2010-10-01 15:00:00	NVDA	Stock	0.2835	0.2848	0.283	0.2838	168546320.0
2010-10-01 16:00:00	NVDA	Stock	0.2838	0.287	0.2828	0.2842	2316680.0
2010-10-01 17:00:00	NVDA	Stock	0.292	0.295	0.283	0.2842	334200.0
2010-10-01 19:00:00	NVDA	Stock	0.2842	0.2845	0.2842	0.2842	264400.0
2010-10-01 07:00:00	AMZN	Stock	7.8995	7.8995	7.8995	7.8995	2000.0
2010-10-01 08:00:00	AMZN	Stock	7.8655	7.89	7.853	7.89	263560.0
2010-10-01 09:00:00	AMZN	Stock	7.89	7.89	7.7755	7.7995	22148040.0
2010-10-01 10:00:00	AMZN	Stock	7.8	7.805	7.6305	7.686	50698780.0
2010-10-01 11:00:00	AMZN	Stock	7.683	7.696	7.6305	7.666	24576560.0
2010-10-01 12:00:00	AMZN	Stock	7.6665	7.678	7.619	7.6705	15123380.0
2010-10-01 13:00:00	AMZN	Stock	7.6725	7.6725	7.61	7.6375	14368500.0
2010-10-01 14:00:00	AMZN	Stock	7.638	7.6605	7.6285	7.6415	11516740.0
2010-10-01 15:00:00	AMZN	Stock	7.641	7.7035	7.6385	7.6855	29699500.0
2010-10-01 16:00:00	AMZN	Stock	7.681	7.7856	7.6504	7.6875	1505600.0

> showing 50 of 45,077 rows — these rows as CSV

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