PREVIEW / stock_1hour / 2007-07-09

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-07-09.parquet
  size:    769 KB
  rows:    38,017
  symbols: 3,067

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-07-09 09:00:00	AAPL	Stock	4.7279	4.7464	4.6789	4.6993	163812264.0
2007-07-09 10:00:00	AAPL	Stock	4.6986	4.7111	4.6514	4.6518	200257484.0
2007-07-09 11:00:00	AAPL	Stock	4.6511	4.6725	4.6504	4.6616	93756768.0
2007-07-09 12:00:00	AAPL	Stock	4.6621	4.6711	4.6464	4.6629	74780104.0
2007-07-09 13:00:00	AAPL	Stock	4.6632	4.6643	4.6136	4.635	143276112.0
2007-07-09 14:00:00	AAPL	Stock	4.6354	4.6571	4.6161	4.6479	128803696.0
2007-07-09 15:00:00	AAPL	Stock	4.6475	4.6657	4.6411	4.6539	158434640.0
2007-07-09 16:00:00	AAPL	Stock	4.6575	4.6579	4.6539	4.6546	9001328.0
2007-07-09 09:00:00	MSFT	Stock	29.86	29.95	29.84	29.92	3540649.0
2007-07-09 10:00:00	MSFT	Stock	29.92	29.94	29.85	29.9	6438090.0
2007-07-09 11:00:00	MSFT	Stock	29.902	29.92	29.86	29.87	2737323.0
2007-07-09 12:00:00	MSFT	Stock	29.87	29.92	29.83	29.885	4532774.0
2007-07-09 13:00:00	MSFT	Stock	29.885	29.89	29.83	29.85	2292155.0
2007-07-09 14:00:00	MSFT	Stock	29.84	29.93	29.81	29.92	4003521.0
2007-07-09 15:00:00	MSFT	Stock	29.92	29.94	29.85	29.85	6221397.0
2007-07-09 16:00:00	MSFT	Stock	29.87	29.87	29.87	29.87	1306103.0
2007-07-09 07:00:00	NVDA	Stock	0.7333	0.7333	0.7333	0.7333	30000.0
2007-07-09 08:00:00	NVDA	Stock	0.7325	0.7392	0.7325	0.7383	441000.0
2007-07-09 09:00:00	NVDA	Stock	0.7355	0.7398	0.732	0.7363	50760720.0
2007-07-09 10:00:00	NVDA	Stock	0.7362	0.7458	0.7362	0.7398	82539180.0
2007-07-09 11:00:00	NVDA	Stock	0.7397	0.7463	0.7397	0.7447	57131760.0
2007-07-09 12:00:00	NVDA	Stock	0.7445	0.748	0.7427	0.7475	47282760.0
2007-07-09 13:00:00	NVDA	Stock	0.7473	0.752	0.7463	0.751	60039180.0
2007-07-09 14:00:00	NVDA	Stock	0.751	0.7542	0.7491	0.75	77339580.0
2007-07-09 15:00:00	NVDA	Stock	0.75	0.7518	0.7493	0.7513	74145600.0
2007-07-09 16:00:00	NVDA	Stock	0.7512	0.7512	0.7417	0.7495	63946500.0
2007-07-09 17:00:00	NVDA	Stock	0.7507	0.752	0.7295	0.752	826800.0
2007-07-09 18:00:00	NVDA	Stock	0.752	0.752	0.752	0.752	6600.0
2007-07-09 19:00:00	NVDA	Stock	0.7525	0.7525	0.7525	0.7525	18000.0
2007-07-09 08:00:00	AMZN	Stock	3.4935	3.5305	3.466	3.4855	209920.0
2007-07-09 09:00:00	AMZN	Stock	3.476	3.5925	3.451	3.5525	49244440.0
2007-07-09 10:00:00	AMZN	Stock	3.5532	3.589	3.531	3.5625	58802060.0
2007-07-09 11:00:00	AMZN	Stock	3.563	3.5875	3.5575	3.5645	27476480.0
2007-07-09 12:00:00	AMZN	Stock	3.564	3.5685	3.552	3.562	12468300.0
2007-07-09 13:00:00	AMZN	Stock	3.5625	3.6175	3.561	3.6115	50526760.0
2007-07-09 14:00:00	AMZN	Stock	3.612	3.6135	3.568	3.583	33257660.0
2007-07-09 15:00:00	AMZN	Stock	3.583	3.6105	3.57	3.599	48234840.0
2007-07-09 16:00:00	AMZN	Stock	3.5985	3.6035	3.541	3.5965	3217760.0
2007-07-09 17:00:00	AMZN	Stock	3.5985	3.5995	3.4485	3.5995	244720.0
2007-07-09 18:00:00	AMZN	Stock	3.5995	3.605	3.5995	3.605	50000.0
2007-07-09 19:00:00	AMZN	Stock	3.6025	3.609	3.6	3.605	32400.0
2007-07-09 09:00:00	TLT	Stock	83.87	83.93	83.81	83.82	84800.0
2007-07-09 10:00:00	TLT	Stock	83.81	83.9	83.74	83.86	86900.0
2007-07-09 11:00:00	TLT	Stock	83.86	83.86	83.68	83.69	80100.0
2007-07-09 12:00:00	TLT	Stock	83.7	83.77	83.69	83.76	98200.0
2007-07-09 13:00:00	TLT	Stock	83.77	83.78	83.74	83.74	57800.0
2007-07-09 14:00:00	TLT	Stock	83.74	83.76	83.69	83.71	51800.0
2007-07-09 15:00:00	TLT	Stock	83.7	83.74	83.68	83.7	213488.0
2007-07-09 16:00:00	TLT	Stock	83.74	83.78	83.74	83.78	14300.0
2007-07-09 09:00:00	CL	Stock	33.05	33.12	32.96	33.1125	310800.0

> showing 50 of 38,017 rows — these rows as CSV

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