PREVIEW / stock_1hour / 2009-10-13

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-10-13.parquet
  size:    880 KB
  rows:    42,453
  symbols: 3,400

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-10-13 05:00:00	AAPL	Stock	6.7946	6.7946	6.7946	6.7946	5600.0
2009-10-13 06:00:00	AAPL	Stock	6.8036	6.8218	6.8036	6.8214	36820.0
2009-10-13 07:00:00	AAPL	Stock	6.8214	6.8511	6.8214	6.8321	120456.0
2009-10-13 08:00:00	AAPL	Stock	6.8218	6.8293	6.8079	6.8107	396704.0
2009-10-13 09:00:00	AAPL	Stock	6.8093	6.8275	6.7804	6.805	43241884.0
2009-10-13 10:00:00	AAPL	Stock	6.8054	6.8118	6.7771	6.7875	53754904.0
2009-10-13 11:00:00	AAPL	Stock	6.7875	6.8146	6.7807	6.805	35345688.0
2009-10-13 12:00:00	AAPL	Stock	6.8044	6.8111	6.7879	6.7956	20833092.0
2009-10-13 13:00:00	AAPL	Stock	6.7957	6.7986	6.7764	6.7854	24514504.0
2009-10-13 14:00:00	AAPL	Stock	6.785	6.7946	6.775	6.7878	34568800.0
2009-10-13 15:00:00	AAPL	Stock	6.7871	6.8032	6.7804	6.7854	54914888.0
2009-10-13 16:00:00	AAPL	Stock	6.7854	6.8468	6.7821	6.8264	18080048.0
2009-10-13 17:00:00	AAPL	Stock	6.8271	6.8511	6.8214	6.85	1587404.0
2009-10-13 18:00:00	AAPL	Stock	6.85	6.8554	6.7864	6.8482	1026284.0
2009-10-13 19:00:00	AAPL	Stock	6.845	6.8536	6.8375	6.8464	670488.0
2009-10-13 07:00:00	MSFT	Stock	25.77	25.77	25.77	25.77	100.0
2009-10-13 08:00:00	MSFT	Stock	25.72	25.78	25.7	25.7	2900.0
2009-10-13 09:00:00	MSFT	Stock	25.6	25.76	25.54	25.6	3626993.0
2009-10-13 10:00:00	MSFT	Stock	25.603	25.61	25.52	25.59	4023689.0
2009-10-13 11:00:00	MSFT	Stock	25.58	25.94	25.57	25.92	4313041.0
2009-10-13 12:00:00	MSFT	Stock	25.93	25.93	25.8	25.851	3969391.0
2009-10-13 13:00:00	MSFT	Stock	25.86	25.92	25.83	25.9	3362005.0
2009-10-13 14:00:00	MSFT	Stock	25.89	25.89	25.75	25.82	3530380.0
2009-10-13 15:00:00	MSFT	Stock	25.82	25.89	25.77	25.82	7623481.0
2009-10-13 16:00:00	MSFT	Stock	25.82	26.17	25.65	26.12	5336908.0
2009-10-13 17:00:00	MSFT	Stock	26.14	26.17	25.839	26.14	64835.0
2009-10-13 18:00:00	MSFT	Stock	26.14	26.15	26.11	26.14	5983.0
2009-10-13 19:00:00	MSFT	Stock	26.14	26.15	26.12	26.15	5837.0
2009-10-13 20:00:00	MSFT	Stock	25.72	25.87	25.72	25.87	249600.0
2009-10-13 08:00:00	NVDA	Stock	0.3502	0.3515	0.3502	0.3515	52000.0
2009-10-13 09:00:00	NVDA	Stock	0.352	0.355	0.3505	0.3508	55144440.0
2009-10-13 10:00:00	NVDA	Stock	0.3505	0.3505	0.3458	0.348	127010520.0
2009-10-13 11:00:00	NVDA	Stock	0.3478	0.3562	0.3462	0.3542	86167080.0
2009-10-13 12:00:00	NVDA	Stock	0.3541	0.3551	0.3513	0.3528	55067160.0
2009-10-13 13:00:00	NVDA	Stock	0.3528	0.353	0.3495	0.3498	56563480.0
2009-10-13 14:00:00	NVDA	Stock	0.3498	0.3498	0.347	0.3481	77492160.0
2009-10-13 15:00:00	NVDA	Stock	0.348	0.35	0.3478	0.3488	96518800.0
2009-10-13 16:00:00	NVDA	Stock	0.349	0.3648	0.3472	0.3602	24203640.0
2009-10-13 17:00:00	NVDA	Stock	0.36	0.3648	0.359	0.3648	3874360.0
2009-10-13 18:00:00	NVDA	Stock	0.3648	0.3648	0.3605	0.3632	771840.0
2009-10-13 19:00:00	NVDA	Stock	0.3628	0.3628	0.3612	0.362	433120.0
2009-10-13 08:00:00	AMZN	Stock	4.665	4.665	4.665	4.665	4000.0
2009-10-13 09:00:00	AMZN	Stock	4.667	4.732	4.667	4.723	13439560.0
2009-10-13 10:00:00	AMZN	Stock	4.723	4.743	4.704	4.7385	17159440.0
2009-10-13 11:00:00	AMZN	Stock	4.7385	4.7625	4.7298	4.7475	14784640.0
2009-10-13 12:00:00	AMZN	Stock	4.748	4.7535	4.7255	4.732	7009160.0
2009-10-13 13:00:00	AMZN	Stock	4.7325	4.7425	4.7205	4.727	8264560.0
2009-10-13 14:00:00	AMZN	Stock	4.727	4.744	4.717	4.7355	7968940.0
2009-10-13 15:00:00	AMZN	Stock	4.736	4.752	4.7285	4.7415	19294880.0
2009-10-13 16:00:00	AMZN	Stock	4.7425	4.7755	4.7338	4.763	2824500.0

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

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