PREVIEW / stock_1hour / 2008-10-29

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-10-29.parquet
  size:    814 KB
  rows:    41,541
  symbols: 3,323

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
2008-10-29 04:00:00	AAPL	Stock	3.5689	3.5689	3.5689	3.5689	2800.0
2008-10-29 06:00:00	AAPL	Stock	3.5575	3.6179	3.5418	3.6179	53200.0
2008-10-29 07:00:00	AAPL	Stock	3.6071	3.6429	3.5818	3.625	455224.0
2008-10-29 08:00:00	AAPL	Stock	3.6232	3.6357	3.5761	3.5875	5112352.0
2008-10-29 09:00:00	AAPL	Stock	3.5857	3.6929	3.5693	3.6757	222901000.0
2008-10-29 10:00:00	AAPL	Stock	3.6761	3.8129	3.6586	3.7188	371328132.0
2008-10-29 11:00:00	AAPL	Stock	3.7196	3.8	3.7064	3.7943	165559576.0
2008-10-29 12:00:00	AAPL	Stock	3.7936	3.8471	3.7575	3.8193	172927524.0
2008-10-29 13:00:00	AAPL	Stock	3.8193	3.8593	3.8071	3.8332	157156468.0
2008-10-29 14:00:00	AAPL	Stock	3.8343	3.8661	3.7429	3.8254	374566808.0
2008-10-29 15:00:00	AAPL	Stock	3.8261	3.9121	3.7246	3.7343	422439836.0
2008-10-29 16:00:00	AAPL	Stock	3.7346	3.8524	3.6842	3.7411	32790940.0
2008-10-29 17:00:00	AAPL	Stock	3.7379	3.7543	3.7343	3.7393	914760.0
2008-10-29 18:00:00	AAPL	Stock	3.7379	3.7543	3.7343	3.7543	559832.0
2008-10-29 19:00:00	AAPL	Stock	3.7582	3.7582	3.7482	3.7518	643916.0
2008-10-29 20:00:00	AAPL	Stock	3.7386	3.7386	3.7386	3.7386	5656.0
2008-10-29 07:00:00	MSFT	Stock	22.82	22.86	22.82	22.86	2000.0
2008-10-29 08:00:00	MSFT	Stock	23.1	23.2	23.0	23.02	49056.0
2008-10-29 09:00:00	MSFT	Stock	23.02	23.16	22.7	22.865	7785361.0
2008-10-29 10:00:00	MSFT	Stock	22.86	23.3	22.72	22.93	14552419.0
2008-10-29 11:00:00	MSFT	Stock	22.93	23.18	22.8	23.14	10176649.0
2008-10-29 12:00:00	MSFT	Stock	23.14	23.9	23.1	23.74	12303596.0
2008-10-29 13:00:00	MSFT	Stock	23.74	23.84	23.47	23.47	9931455.0
2008-10-29 14:00:00	MSFT	Stock	23.471	23.65	22.88	23.31	17285686.0
2008-10-29 15:00:00	MSFT	Stock	23.3	23.97	22.85	22.98	29658299.0
2008-10-29 16:00:00	MSFT	Stock	22.97	23.78	22.84	23.05	5109740.0
2008-10-29 17:00:00	MSFT	Stock	23.05	23.29	23.02	23.2	65806.0
2008-10-29 18:00:00	MSFT	Stock	23.06	23.19	23.06	23.19	5300.0
2008-10-29 19:00:00	MSFT	Stock	23.17	23.19	22.343	23.14	5611.0
2008-10-29 08:00:00	NVDA	Stock	0.1975	0.1982	0.1962	0.198	212000.0
2008-10-29 09:00:00	NVDA	Stock	0.1945	0.2175	0.1942	0.2112	180541080.0
2008-10-29 10:00:00	NVDA	Stock	0.2112	0.2175	0.2055	0.2069	189236360.0
2008-10-29 11:00:00	NVDA	Stock	0.207	0.21	0.2065	0.2095	68749120.0
2008-10-29 12:00:00	NVDA	Stock	0.2097	0.2152	0.2088	0.2141	56383440.0
2008-10-29 13:00:00	NVDA	Stock	0.2143	0.215	0.2108	0.2108	54077200.0
2008-10-29 14:00:00	NVDA	Stock	0.2108	0.2148	0.2027	0.214	158226200.0
2008-10-29 15:00:00	NVDA	Stock	0.2141	0.22	0.2068	0.207	247902280.0
2008-10-29 16:00:00	NVDA	Stock	0.207	0.219	0.2045	0.2078	19661240.0
2008-10-29 17:00:00	NVDA	Stock	0.208	0.208	0.2078	0.2078	793400.0
2008-10-29 18:00:00	NVDA	Stock	0.208	0.208	0.208	0.208	96000.0
2008-10-29 19:00:00	NVDA	Stock	0.208	0.2128	0.208	0.2128	211880.0
2008-10-29 07:00:00	AMZN	Stock	2.7005	2.755	2.7005	2.7525	42000.0
2008-10-29 08:00:00	AMZN	Stock	2.7625	2.7975	2.7595	2.763	126160.0
2008-10-29 09:00:00	AMZN	Stock	2.7635	2.82	2.726	2.795	30415280.0
2008-10-29 10:00:00	AMZN	Stock	2.793	2.8975	2.764	2.8175	51200240.0
2008-10-29 11:00:00	AMZN	Stock	2.8155	2.8495	2.804	2.8325	24642640.0
2008-10-29 12:00:00	AMZN	Stock	2.832	2.944	2.825	2.899	30626760.0
2008-10-29 13:00:00	AMZN	Stock	2.8985	2.978	2.8945	2.9045	35510320.0
2008-10-29 14:00:00	AMZN	Stock	2.9025	2.9215	2.825	2.874	58543840.0
2008-10-29 15:00:00	AMZN	Stock	2.875	2.9895	2.809	2.835	63054120.0

> showing 50 of 41,541 rows — these rows as CSV

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