PREVIEW / stock_1hour / 2007-11-05

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-11-05.parquet
  size:    866 KB
  rows:    43,800
  symbols: 3,193

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-11-05 04:00:00	AAPL	Stock	6.6804	6.6804	6.6804	6.6804	2800.0
2007-11-05 05:00:00	AAPL	Stock	6.6539	6.6539	6.6518	6.6518	53200.0
2007-11-05 06:00:00	AAPL	Stock	6.645	6.6607	6.6429	6.6429	81200.0
2007-11-05 07:00:00	AAPL	Stock	6.6429	6.6732	6.6429	6.6525	427700.0
2007-11-05 08:00:00	AAPL	Stock	6.6554	6.7096	6.6182	6.6393	4356380.0
2007-11-05 09:00:00	AAPL	Stock	6.64	6.7096	6.58	6.6254	98252504.0
2007-11-05 10:00:00	AAPL	Stock	6.6268	6.7154	6.6157	6.6975	135705108.0
2007-11-05 11:00:00	AAPL	Stock	6.6986	6.7486	6.6771	6.7243	120808520.0
2007-11-05 12:00:00	AAPL	Stock	6.7239	6.7279	6.6786	6.6911	70511084.0
2007-11-05 13:00:00	AAPL	Stock	6.6911	6.7036	6.6411	6.6457	95598468.0
2007-11-05 14:00:00	AAPL	Stock	6.6439	6.6661	6.6	6.6111	120441636.0
2007-11-05 15:00:00	AAPL	Stock	6.6111	6.7046	6.6075	6.6443	140151228.0
2007-11-05 16:00:00	AAPL	Stock	6.6443	6.6722	6.6	6.6464	16076480.0
2007-11-05 17:00:00	AAPL	Stock	6.6464	6.7232	6.635	6.6432	3029152.0
2007-11-05 18:00:00	AAPL	Stock	6.6429	6.6719	6.6357	6.6393	227304.0
2007-11-05 19:00:00	AAPL	Stock	6.6343	6.6382	6.6296	6.6336	243880.0
2007-11-05 04:00:00	MSFT	Stock	36.76	36.79	36.76	36.79	700.0
2007-11-05 05:00:00	MSFT	Stock	36.71	36.71	36.71	36.71	200.0
2007-11-05 07:00:00	MSFT	Stock	36.66	36.79	36.66	36.69	12230.0
2007-11-05 08:00:00	MSFT	Stock	37.06	37.06	36.6	36.75	1197746.0
2007-11-05 09:00:00	MSFT	Stock	36.76	37.06	36.62	36.83	9758816.0
2007-11-05 10:00:00	MSFT	Stock	36.84	37.1	36.653	36.87	14228338.0
2007-11-05 11:00:00	MSFT	Stock	36.87	36.92	36.82	36.83	9035669.0
2007-11-05 12:00:00	MSFT	Stock	36.83	36.85	36.75	36.82	5865253.0
2007-11-05 13:00:00	MSFT	Stock	36.815	36.88	36.77	36.81	6450093.0
2007-11-05 14:00:00	MSFT	Stock	36.81	36.86	36.7	36.74	9194315.0
2007-11-05 15:00:00	MSFT	Stock	36.741	36.92	36.7	36.719	14714403.0
2007-11-05 16:00:00	MSFT	Stock	36.71	36.878	36.645	36.798	5748738.0
2007-11-05 17:00:00	MSFT	Stock	36.73	36.98	36.72	36.79	188943.0
2007-11-05 18:00:00	MSFT	Stock	36.82	36.84	36.73	36.73	10450.0
2007-11-05 19:00:00	MSFT	Stock	36.73	36.73	36.72	36.72	1183.0
2007-11-05 08:00:00	NVDA	Stock	0.905	0.9125	0.9	0.9062	585480.0
2007-11-05 09:00:00	NVDA	Stock	0.9185	0.9308	0.9062	0.9298	59852680.0
2007-11-05 10:00:00	NVDA	Stock	0.9295	0.9405	0.9288	0.9348	66422480.0
2007-11-05 11:00:00	NVDA	Stock	0.9348	0.94	0.9208	0.9245	53790280.0
2007-11-05 12:00:00	NVDA	Stock	0.9248	0.927	0.9168	0.9195	38617920.0
2007-11-05 13:00:00	NVDA	Stock	0.9195	0.9213	0.9068	0.9068	55269520.0
2007-11-05 14:00:00	NVDA	Stock	0.9072	0.9148	0.905	0.9095	54364120.0
2007-11-05 15:00:00	NVDA	Stock	0.9095	0.9278	0.9095	0.9185	83452400.0
2007-11-05 16:00:00	NVDA	Stock	0.9185	0.9225	0.9161	0.9161	32318920.0
2007-11-05 17:00:00	NVDA	Stock	0.9185	0.9373	0.908	0.9213	599080.0
2007-11-05 18:00:00	NVDA	Stock	0.9148	0.921	0.9148	0.9175	206000.0
2007-11-05 19:00:00	NVDA	Stock	0.9175	0.9175	0.9085	0.9085	58000.0
2007-11-05 07:00:00	AMZN	Stock	4.226	4.25	4.226	4.25	11600.0
2007-11-05 08:00:00	AMZN	Stock	4.2375	4.299	4.185	4.2025	425920.0
2007-11-05 09:00:00	AMZN	Stock	4.2055	4.299	4.195	4.2395	20893420.0
2007-11-05 10:00:00	AMZN	Stock	4.238	4.301	4.238	4.2805	22034940.0
2007-11-05 11:00:00	AMZN	Stock	4.2795	4.298	4.2405	4.273	13634140.0
2007-11-05 12:00:00	AMZN	Stock	4.274	4.275	4.2425	4.2572	7250340.0
2007-11-05 13:00:00	AMZN	Stock	4.256	4.2605	4.186	4.19	15241960.0

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

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