PREVIEW / stock_1hour / 2009-10-30

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-10-30.parquet
  size:    918 KB
  rows:    43,948
  symbols: 3,411

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-30 05:00:00	AAPL	Stock	7.0407	7.0407	7.0407	7.0407	2800.0
2009-10-30 06:00:00	AAPL	Stock	7.0407	7.0407	7.0407	7.0407	13468.0
2009-10-30 07:00:00	AAPL	Stock	7.0189	7.0189	6.9907	7.0004	152460.0
2009-10-30 08:00:00	AAPL	Stock	6.995	7.0214	6.9893	6.9893	1286292.0
2009-10-30 09:00:00	AAPL	Stock	6.9868	7.0286	6.9554	6.9839	78044736.0
2009-10-30 10:00:00	AAPL	Stock	6.9854	7.005	6.9364	6.9679	70592172.0
2009-10-30 11:00:00	AAPL	Stock	6.9689	6.9689	6.8107	6.8393	97483988.0
2009-10-30 12:00:00	AAPL	Stock	6.8393	6.8621	6.7204	6.7517	124458432.0
2009-10-30 13:00:00	AAPL	Stock	6.7511	6.8054	6.7425	6.7775	86966236.0
2009-10-30 14:00:00	AAPL	Stock	6.7793	6.8271	6.7679	6.7811	75311180.0
2009-10-30 15:00:00	AAPL	Stock	6.7793	6.7939	6.6452	6.7321	145830916.0
2009-10-30 16:00:00	AAPL	Stock	6.7321	6.8791	6.725	6.7314	21641760.0
2009-10-30 17:00:00	AAPL	Stock	6.76	6.76	6.7257	6.7268	981792.0
2009-10-30 18:00:00	AAPL	Stock	6.7268	6.7379	6.725	6.7375	1184120.0
2009-10-30 19:00:00	AAPL	Stock	6.7407	6.7411	6.7286	6.7332	205520.0
2009-10-30 20:00:00	AAPL	Stock	6.85	6.85	6.85	6.85	3024.0
2009-10-30 07:00:00	MSFT	Stock	28.23	28.23	28.19	28.19	200.0
2009-10-30 08:00:00	MSFT	Stock	28.23	28.25	28.1	28.15	115482.0
2009-10-30 09:00:00	MSFT	Stock	28.16	28.25	28.0	28.16	6568373.0
2009-10-30 10:00:00	MSFT	Stock	28.16	28.4	28.1	28.27	6781158.0
2009-10-30 11:00:00	MSFT	Stock	28.27	28.28	28.0	28.13	7359253.0
2009-10-30 12:00:00	MSFT	Stock	28.13	28.14	27.78	27.9	11279568.0
2009-10-30 13:00:00	MSFT	Stock	27.9	27.98	27.66	27.82	8971830.0
2009-10-30 14:00:00	MSFT	Stock	27.82	27.95	27.69	27.89	7087486.0
2009-10-30 15:00:00	MSFT	Stock	27.88	27.88	27.66	27.73	15540697.0
2009-10-30 16:00:00	MSFT	Stock	27.68	27.987	27.463	27.83	5977524.0
2009-10-30 17:00:00	MSFT	Stock	27.62	27.73	27.53	27.6	4747.0
2009-10-30 18:00:00	MSFT	Stock	27.64	27.73	27.58	27.6	26220.0
2009-10-30 19:00:00	MSFT	Stock	27.67	27.67	27.61	27.63	2900.0
2009-10-30 20:00:00	MSFT	Stock	28.07	28.07	28.07	28.07	55208.0
2009-10-30 08:00:00	NVDA	Stock	0.3138	0.3138	0.3138	0.3138	24800.0
2009-10-30 09:00:00	NVDA	Stock	0.3138	0.3138	0.3055	0.308	43811760.0
2009-10-30 10:00:00	NVDA	Stock	0.3083	0.3108	0.3052	0.3075	62463280.0
2009-10-30 11:00:00	NVDA	Stock	0.3074	0.3078	0.3002	0.302	66172320.0
2009-10-30 12:00:00	NVDA	Stock	0.3022	0.304	0.3	0.3	81798600.0
2009-10-30 13:00:00	NVDA	Stock	0.3	0.3018	0.2985	0.2985	60234360.0
2009-10-30 14:00:00	NVDA	Stock	0.2985	0.3005	0.2975	0.2992	72227720.0
2009-10-30 15:00:00	NVDA	Stock	0.2992	0.302	0.2978	0.299	189289560.0
2009-10-30 16:00:00	NVDA	Stock	0.2992	0.302	0.2975	0.3018	19330000.0
2009-10-30 17:00:00	NVDA	Stock	0.2998	0.2998	0.2978	0.299	136240.0
2009-10-30 18:00:00	NVDA	Stock	0.299	0.299	0.2988	0.299	112920.0
2009-10-30 19:00:00	NVDA	Stock	0.2988	0.2988	0.2988	0.2988	52680.0
2009-10-30 06:00:00	AMZN	Stock	6.1015	6.1015	6.1015	6.1015	2000.0
2009-10-30 07:00:00	AMZN	Stock	6.1015	6.1015	6.1	6.1	21500.0
2009-10-30 08:00:00	AMZN	Stock	6.113	6.113	6.085	6.085	232260.0
2009-10-30 09:00:00	AMZN	Stock	6.085	6.1185	6.056	6.082	25641420.0
2009-10-30 10:00:00	AMZN	Stock	6.0795	6.145	6.077	6.118	30478460.0
2009-10-30 11:00:00	AMZN	Stock	6.1175	6.1335	6.0025	6.0065	30288840.0
2009-10-30 12:00:00	AMZN	Stock	6.0065	6.0355	5.959	5.97	45705360.0
2009-10-30 13:00:00	AMZN	Stock	5.9705	6.0065	5.952	5.958	31574400.0

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

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