PREVIEW / stock_1hour / 2010-05-12

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-05-12.parquet
  size:    925 KB
  rows:    44,163
  symbols: 3,494

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-05-12 04:00:00	AAPL	Stock	9.1614	9.1786	9.1518	9.1518	21980.0
2010-05-12 05:00:00	AAPL	Stock	9.1607	9.1821	9.1525	9.1821	16744.0
2010-05-12 06:00:00	AAPL	Stock	9.1871	9.1871	9.1871	9.1871	2800.0
2010-05-12 07:00:00	AAPL	Stock	9.1836	9.2429	9.1768	9.2321	1037008.0
2010-05-12 08:00:00	AAPL	Stock	9.2293	9.2482	9.2079	9.2357	5742520.0
2010-05-12 09:00:00	AAPL	Stock	9.2361	9.3493	9.2268	9.3393	114327024.0
2010-05-12 10:00:00	AAPL	Stock	9.3389	9.3882	9.3257	9.3796	121259936.0
2010-05-12 11:00:00	AAPL	Stock	9.3779	9.3975	9.3182	9.3547	98849968.0
2010-05-12 12:00:00	AAPL	Stock	9.3546	9.3836	9.3536	9.3625	48187104.0
2010-05-12 13:00:00	AAPL	Stock	9.3646	9.37	9.3039	9.3153	91253540.0
2010-05-12 14:00:00	AAPL	Stock	9.3136	9.365	9.3	9.3564	74057760.0
2010-05-12 15:00:00	AAPL	Stock	9.3564	9.3707	9.3218	9.36	87953012.0
2010-05-12 16:00:00	AAPL	Stock	9.3604	9.3643	9.1614	9.3489	9029244.0
2010-05-12 17:00:00	AAPL	Stock	9.3489	9.3571	9.3446	9.3571	273168.0
2010-05-12 18:00:00	AAPL	Stock	9.3586	9.3643	9.3525	9.3571	426580.0
2010-05-12 19:00:00	AAPL	Stock	9.3536	9.3643	9.3536	9.3643	292152.0
2010-05-12 07:00:00	MSFT	Stock	28.97	28.99	28.97	28.98	4709.0
2010-05-12 08:00:00	MSFT	Stock	29.01	29.17	28.97	29.16	74038.0
2010-05-12 09:00:00	MSFT	Stock	29.16	29.23	28.92	29.19	4186389.0
2010-05-12 10:00:00	MSFT	Stock	29.198	29.35	29.08	29.3	7831970.0
2010-05-12 11:00:00	MSFT	Stock	29.3	29.38	29.18	29.33	7648753.0
2010-05-12 12:00:00	MSFT	Stock	29.33	29.4	29.2	29.39	3811571.0
2010-05-12 13:00:00	MSFT	Stock	29.382	29.47	29.31	29.37	5961327.0
2010-05-12 14:00:00	MSFT	Stock	29.37	29.5	29.36	29.472	4272097.0
2010-05-12 15:00:00	MSFT	Stock	29.475	29.58	29.42	29.44	10738976.0
2010-05-12 16:00:00	MSFT	Stock	29.44	29.525	28.87	29.41	1788367.0
2010-05-12 17:00:00	MSFT	Stock	29.35	29.44	29.35	29.42	7450.0
2010-05-12 18:00:00	MSFT	Stock	29.35	29.44	28.88	28.88	49974.0
2010-05-12 19:00:00	MSFT	Stock	29.44	29.44	29.35	29.35	5700.0
2010-05-12 08:00:00	NVDA	Stock	0.36	0.3662	0.36	0.3645	1461480.0
2010-05-12 09:00:00	NVDA	Stock	0.3645	0.368	0.3602	0.368	96821320.0
2010-05-12 10:00:00	NVDA	Stock	0.368	0.369	0.3658	0.366	156022640.0
2010-05-12 11:00:00	NVDA	Stock	0.3661	0.3682	0.3658	0.368	118669320.0
2010-05-12 12:00:00	NVDA	Stock	0.368	0.3685	0.367	0.3675	78801280.0
2010-05-12 13:00:00	NVDA	Stock	0.3678	0.3685	0.3662	0.3665	125065000.0
2010-05-12 14:00:00	NVDA	Stock	0.3665	0.368	0.3655	0.3672	139981840.0
2010-05-12 15:00:00	NVDA	Stock	0.3672	0.3682	0.365	0.367	153886440.0
2010-05-12 16:00:00	NVDA	Stock	0.3665	0.367	0.363	0.3665	20695200.0
2010-05-12 17:00:00	NVDA	Stock	0.367	0.368	0.3665	0.3678	488840.0
2010-05-12 18:00:00	NVDA	Stock	0.3678	0.368	0.367	0.368	968000.0
2010-05-12 19:00:00	NVDA	Stock	0.368	0.368	0.368	0.368	130000.0
2010-05-12 08:00:00	AMZN	Stock	6.55	6.5975	6.525	6.5875	283380.0
2010-05-12 09:00:00	AMZN	Stock	6.5875	6.5965	6.484	6.542	11077100.0
2010-05-12 10:00:00	AMZN	Stock	6.5415	6.5825	6.49	6.5265	17470360.0
2010-05-12 11:00:00	AMZN	Stock	6.523	6.55	6.4875	6.5482	15827920.0
2010-05-12 12:00:00	AMZN	Stock	6.5465	6.6395	6.5235	6.6075	15485900.0
2010-05-12 13:00:00	AMZN	Stock	6.6075	6.647	6.601	6.62	10907440.0
2010-05-12 14:00:00	AMZN	Stock	6.6225	6.687	6.606	6.6765	15407380.0
2010-05-12 15:00:00	AMZN	Stock	6.677	6.7065	6.6585	6.691	26015880.0
2010-05-12 16:00:00	AMZN	Stock	6.69	6.7065	6.5282	6.6995	5139560.0

> showing 50 of 44,163 rows — these rows as CSV

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