PREVIEW / stock_1hour / 2007-03-05

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-05.parquet
  size:    770 KB
  rows:    35,856
  symbols: 2,539

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
2007-03-05 04:00:00	AAPL	Stock	3.0	3.0	3.0	3.0	14700.0
2007-03-05 06:00:00	AAPL	Stock	2.9921	3.0357	2.9893	3.0357	272440.0
2007-03-05 07:00:00	AAPL	Stock	3.035	3.0461	3.0214	3.0446	990164.0
2007-03-05 08:00:00	AAPL	Stock	3.04	3.0804	3.0357	3.0714	7194376.0
2007-03-05 09:00:00	AAPL	Stock	3.0732	3.1661	3.0629	3.1182	139960800.0
2007-03-05 10:00:00	AAPL	Stock	3.1186	3.1282	3.0911	3.0993	181737836.0
2007-03-05 11:00:00	AAPL	Stock	3.0989	3.1186	3.0875	3.0875	102453064.0
2007-03-05 12:00:00	AAPL	Stock	3.0875	3.1018	3.0736	3.0782	90336092.0
2007-03-05 13:00:00	AAPL	Stock	3.0779	3.1036	3.0761	3.1021	85779876.0
2007-03-05 14:00:00	AAPL	Stock	3.1025	3.1114	3.0911	3.0989	83707708.0
2007-03-05 15:00:00	AAPL	Stock	3.0989	3.1046	3.0771	3.0814	116568564.0
2007-03-05 16:00:00	AAPL	Stock	3.0811	3.0879	3.0793	3.0879	3567620.0
2007-03-05 17:00:00	AAPL	Stock	3.0857	3.1269	3.065	3.0956	15891736.0
2007-03-05 18:00:00	AAPL	Stock	3.0876	3.1267	3.065	3.0875	2886184.0
2007-03-05 19:00:00	AAPL	Stock	3.0893	3.1025	3.0893	3.0943	267848.0
2007-03-05 04:00:00	MSFT	Stock	27.58	27.59	27.52	27.52	700.0
2007-03-05 05:00:00	MSFT	Stock	27.3	27.3	27.27	27.29	7200.0
2007-03-05 06:00:00	MSFT	Stock	27.27	27.29	27.24	27.24	14600.0
2007-03-05 07:00:00	MSFT	Stock	27.28	27.46	27.28	27.39	13557.0
2007-03-05 08:00:00	MSFT	Stock	27.37	27.76	27.37	27.76	7879166.0
2007-03-05 09:00:00	MSFT	Stock	27.45	27.8	27.41	27.75	9541194.0
2007-03-05 10:00:00	MSFT	Stock	27.75	27.9	27.6	27.77	6477622.0
2007-03-05 11:00:00	MSFT	Stock	27.78	27.91	27.67	27.71	4613484.0
2007-03-05 12:00:00	MSFT	Stock	27.71	27.73	27.61	27.65	4060569.0
2007-03-05 13:00:00	MSFT	Stock	27.64	27.77	27.64	27.74	2768127.0
2007-03-05 14:00:00	MSFT	Stock	27.75	27.8	27.65	27.69	3544713.0
2007-03-05 15:00:00	MSFT	Stock	27.69	27.79	27.52	27.56	12548392.0
2007-03-05 16:00:00	MSFT	Stock	27.54	27.63	27.52	27.63	1180045.0
2007-03-05 17:00:00	MSFT	Stock	27.59	27.9	27.43	27.65	219492.0
2007-03-05 18:00:00	MSFT	Stock	27.788	27.868	27.45	27.59	76210.0
2007-03-05 19:00:00	MSFT	Stock	27.59	27.65	27.59	27.65	2330.0
2007-03-05 07:00:00	NVDA	Stock	0.4955	0.4955	0.4955	0.4955	60000.0
2007-03-05 08:00:00	NVDA	Stock	0.4917	0.4917	0.4833	0.4892	336900.0
2007-03-05 09:00:00	NVDA	Stock	0.4893	0.4942	0.4798	0.4942	86149200.0
2007-03-05 10:00:00	NVDA	Stock	0.4942	0.4972	0.4875	0.491	103143300.0
2007-03-05 11:00:00	NVDA	Stock	0.491	0.493	0.486	0.4862	82374840.0
2007-03-05 12:00:00	NVDA	Stock	0.486	0.488	0.4822	0.483	72859860.0
2007-03-05 13:00:00	NVDA	Stock	0.4828	0.4875	0.4825	0.4873	63411840.0
2007-03-05 14:00:00	NVDA	Stock	0.4873	0.4888	0.4833	0.4848	69170760.0
2007-03-05 15:00:00	NVDA	Stock	0.4848	0.4853	0.4777	0.4792	154022580.0
2007-03-05 16:00:00	NVDA	Stock	0.479	0.4792	0.4778	0.4792	1160580.0
2007-03-05 17:00:00	NVDA	Stock	0.4844	0.495	0.4785	0.481	12699240.0
2007-03-05 18:00:00	NVDA	Stock	0.4905	0.4922	0.4787	0.4815	1046220.0
2007-03-05 19:00:00	NVDA	Stock	0.4827	0.4827	0.4827	0.4827	12720.0
2007-03-05 04:00:00	AMZN	Stock	1.8685	1.8685	1.8675	1.8675	17600.0
2007-03-05 06:00:00	AMZN	Stock	1.8675	1.8675	1.845	1.8455	23940.0
2007-03-05 07:00:00	AMZN	Stock	1.8635	1.8635	1.8635	1.8635	15000.0
2007-03-05 08:00:00	AMZN	Stock	1.8635	1.8655	1.8505	1.855	324600.0
2007-03-05 09:00:00	AMZN	Stock	1.857	1.892	1.856	1.889	22978160.0
2007-03-05 10:00:00	AMZN	Stock	1.892	1.916	1.883	1.8985	31034760.0

> showing 50 of 35,856 rows — these rows as CSV

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