PREVIEW / stock_1hour / 2009-11-03

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-11-03.parquet
  size:    895 KB
  rows:    42,761
  symbols: 3,417

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-11-03 05:00:00	AAPL	Stock	6.715	6.715	6.715	6.715	5600.0
2009-11-03 06:00:00	AAPL	Stock	6.6661	6.6839	6.6607	6.6839	70000.0
2009-11-03 07:00:00	AAPL	Stock	6.6786	6.7104	6.6786	6.6904	127148.0
2009-11-03 08:00:00	AAPL	Stock	6.7	6.7364	6.6896	6.7071	1726788.0
2009-11-03 09:00:00	AAPL	Stock	6.7011	6.7411	6.6761	6.7354	71533448.0
2009-11-03 10:00:00	AAPL	Stock	6.7354	6.7686	6.6975	6.7164	87095680.0
2009-11-03 11:00:00	AAPL	Stock	6.7163	6.7318	6.6893	6.7	42380968.0
2009-11-03 12:00:00	AAPL	Stock	6.6996	6.7318	6.64	6.7111	85650012.0
2009-11-03 13:00:00	AAPL	Stock	6.7114	6.7429	6.6975	6.7368	44999500.0
2009-11-03 14:00:00	AAPL	Stock	6.7382	6.7536	6.7025	6.7175	54896884.0
2009-11-03 15:00:00	AAPL	Stock	6.7157	6.7464	6.7079	6.7396	62513836.0
2009-11-03 16:00:00	AAPL	Stock	6.74	6.75	6.713	6.7464	10162768.0
2009-11-03 17:00:00	AAPL	Stock	6.7611	6.7611	6.7081	6.7457	104664.0
2009-11-03 18:00:00	AAPL	Stock	6.7482	6.7486	6.7411	6.7418	3107244.0
2009-11-03 19:00:00	AAPL	Stock	6.7411	6.7554	6.7411	6.7554	116200.0
2009-11-03 04:00:00	MSFT	Stock	27.79	27.79	27.79	27.79	100.0
2009-11-03 05:00:00	MSFT	Stock	27.59	27.59	27.49	27.49	400.0
2009-11-03 06:00:00	MSFT	Stock	27.49	27.7	27.49	27.7	5170.0
2009-11-03 07:00:00	MSFT	Stock	27.67	27.75	27.67	27.75	2150.0
2009-11-03 08:00:00	MSFT	Stock	27.61	27.88	27.61	27.7	32050.0
2009-11-03 09:00:00	MSFT	Stock	27.79	27.79	27.5	27.61	4007930.0
2009-11-03 10:00:00	MSFT	Stock	27.61	27.655	27.45	27.46	7563339.0
2009-11-03 11:00:00	MSFT	Stock	27.46	27.59	27.43	27.465	6115024.0
2009-11-03 12:00:00	MSFT	Stock	27.465	27.68	27.44	27.56	4973880.0
2009-11-03 13:00:00	MSFT	Stock	27.56	27.66	27.54	27.58	4257042.0
2009-11-03 14:00:00	MSFT	Stock	27.57	27.62	27.46	27.5	5929652.0
2009-11-03 15:00:00	MSFT	Stock	27.5	27.63	27.48	27.56	12051056.0
2009-11-03 16:00:00	MSFT	Stock	27.56	27.757	27.456	27.51	3714127.0
2009-11-03 17:00:00	MSFT	Stock	27.88	27.88	27.5	27.51	4939.0
2009-11-03 18:00:00	MSFT	Stock	27.53	27.53	27.49	27.49	26741.0
2009-11-03 07:00:00	NVDA	Stock	0.29	0.2928	0.29	0.2928	16000.0
2009-11-03 08:00:00	NVDA	Stock	0.294	0.294	0.2912	0.2922	868800.0
2009-11-03 09:00:00	NVDA	Stock	0.2922	0.2945	0.289	0.2938	129745000.0
2009-11-03 10:00:00	NVDA	Stock	0.294	0.2972	0.2912	0.295	183290360.0
2009-11-03 11:00:00	NVDA	Stock	0.295	0.2985	0.295	0.2975	140581840.0
2009-11-03 12:00:00	NVDA	Stock	0.2975	0.3003	0.296	0.2982	68346080.0
2009-11-03 13:00:00	NVDA	Stock	0.2981	0.2995	0.2972	0.2992	51558560.0
2009-11-03 14:00:00	NVDA	Stock	0.299	0.3018	0.298	0.299	113687920.0
2009-11-03 15:00:00	NVDA	Stock	0.299	0.3008	0.2985	0.3002	148802760.0
2009-11-03 16:00:00	NVDA	Stock	0.3002	0.3015	0.2964	0.3002	12293920.0
2009-11-03 17:00:00	NVDA	Stock	0.3018	0.3018	0.3	0.3002	140000.0
2009-11-03 19:00:00	NVDA	Stock	0.3018	0.3018	0.3018	0.3018	4000.0
2009-11-03 04:00:00	AMZN	Stock	5.9	5.9	5.8755	5.8755	6400.0
2009-11-03 05:00:00	AMZN	Stock	5.8755	5.8755	5.8755	5.8755	2600.0
2009-11-03 06:00:00	AMZN	Stock	5.9	5.905	5.9	5.9	42000.0
2009-11-03 07:00:00	AMZN	Stock	5.9	5.9025	5.9	5.9025	8000.0
2009-11-03 08:00:00	AMZN	Stock	5.905	5.91	5.89	5.9	139640.0
2009-11-03 09:00:00	AMZN	Stock	5.9	5.901	5.8635	5.8675	25673380.0
2009-11-03 10:00:00	AMZN	Stock	5.8675	5.919	5.8315	5.885	48577940.0
2009-11-03 11:00:00	AMZN	Stock	5.885	5.9055	5.861	5.873	20359000.0

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

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