PREVIEW / stock_1hour / 2008-01-29

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-01-29.parquet
  size:    812 KB
  rows:    41,024
  symbols: 3,262

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-01-29 04:00:00	AAPL	Stock	4.6518	4.6518	4.6518	4.6518	2800.0
2008-01-29 05:00:00	AAPL	Stock	4.6661	4.6789	4.6661	4.6789	28000.0
2008-01-29 06:00:00	AAPL	Stock	4.6929	4.7079	4.6929	4.7054	159768.0
2008-01-29 07:00:00	AAPL	Stock	4.7054	4.71	4.6625	4.6711	674940.0
2008-01-29 08:00:00	AAPL	Stock	4.7071	4.7071	4.6439	4.675	5516028.0
2008-01-29 09:00:00	AAPL	Stock	4.6707	4.7425	4.6429	4.6957	174268024.0
2008-01-29 10:00:00	AAPL	Stock	4.6954	4.7371	4.6643	4.6921	216944308.0
2008-01-29 11:00:00	AAPL	Stock	4.6921	4.7161	4.6739	4.6871	117287856.0
2008-01-29 12:00:00	AAPL	Stock	4.6864	4.6882	4.6264	4.6389	119941808.0
2008-01-29 13:00:00	AAPL	Stock	4.6389	4.6693	4.625	4.6432	104265924.0
2008-01-29 14:00:00	AAPL	Stock	4.6429	4.6839	4.6089	4.6736	150747968.0
2008-01-29 15:00:00	AAPL	Stock	4.6732	4.7143	4.6732	4.6964	177149924.0
2008-01-29 16:00:00	AAPL	Stock	4.6969	4.7071	4.6643	4.6754	21848400.0
2008-01-29 17:00:00	AAPL	Stock	4.6754	4.6979	4.6702	4.6786	10768016.0
2008-01-29 18:00:00	AAPL	Stock	4.6786	4.6979	4.6786	4.6804	136612.0
2008-01-29 19:00:00	AAPL	Stock	4.6821	4.6854	4.6746	4.6807	313516.0
2008-01-29 07:00:00	MSFT	Stock	32.72	32.9	32.72	32.9	1500.0
2008-01-29 08:00:00	MSFT	Stock	32.8	32.89	32.74	32.8	50816.0
2008-01-29 09:00:00	MSFT	Stock	32.82	32.89	32.49	32.508	8255673.0
2008-01-29 10:00:00	MSFT	Stock	32.51	32.84	32.42	32.6	11748658.0
2008-01-29 11:00:00	MSFT	Stock	32.59	32.7	32.56	32.65	5997056.0
2008-01-29 12:00:00	MSFT	Stock	32.65	32.655	32.45	32.495	5226822.0
2008-01-29 13:00:00	MSFT	Stock	32.49	32.57	32.43	32.46	5756699.0
2008-01-29 14:00:00	MSFT	Stock	32.46	32.67	32.4	32.557	8152417.0
2008-01-29 15:00:00	MSFT	Stock	32.56	32.73	32.35	32.62	16578943.0
2008-01-29 16:00:00	MSFT	Stock	32.62	32.71	32.51	32.56	6299945.0
2008-01-29 17:00:00	MSFT	Stock	32.56	32.6	32.52	32.52	54353.0
2008-01-29 18:00:00	MSFT	Stock	32.55	32.6	32.5	32.51	12024.0
2008-01-29 19:00:00	MSFT	Stock	32.52	32.54	32.46	32.46	8441.0
2008-01-29 08:00:00	NVDA	Stock	0.6238	0.6238	0.6238	0.6238	41000.0
2008-01-29 09:00:00	NVDA	Stock	0.6248	0.631	0.616	0.6165	51799520.0
2008-01-29 10:00:00	NVDA	Stock	0.6168	0.6248	0.611	0.624	74277120.0
2008-01-29 11:00:00	NVDA	Stock	0.6238	0.6372	0.6238	0.635	64417040.0
2008-01-29 12:00:00	NVDA	Stock	0.6348	0.6348	0.6268	0.633	50409880.0
2008-01-29 13:00:00	NVDA	Stock	0.633	0.6345	0.63	0.6313	30063240.0
2008-01-29 14:00:00	NVDA	Stock	0.6313	0.6362	0.629	0.6355	36112440.0
2008-01-29 15:00:00	NVDA	Stock	0.635	0.6378	0.6332	0.6348	67305840.0
2008-01-29 16:00:00	NVDA	Stock	0.6348	0.6353	0.6287	0.6353	56954160.0
2008-01-29 17:00:00	NVDA	Stock	0.6329	0.6378	0.6329	0.6378	177320.0
2008-01-29 18:00:00	NVDA	Stock	0.6289	0.6395	0.6289	0.6378	205440.0
2008-01-29 19:00:00	NVDA	Stock	0.6378	0.6378	0.6353	0.6378	40200.0
2008-01-29 07:00:00	AMZN	Stock	3.8005	3.801	3.8005	3.801	8800.0
2008-01-29 08:00:00	AMZN	Stock	3.825	3.825	3.795	3.8	137000.0
2008-01-29 09:00:00	AMZN	Stock	3.8	3.8	3.6625	3.672	31028620.0
2008-01-29 10:00:00	AMZN	Stock	3.6705	3.718	3.65	3.676	33937560.0
2008-01-29 11:00:00	AMZN	Stock	3.676	3.7025	3.666	3.6815	17699920.0
2008-01-29 12:00:00	AMZN	Stock	3.6815	3.682	3.603	3.625	27339500.0
2008-01-29 13:00:00	AMZN	Stock	3.6245	3.696	3.612	3.674	19972500.0
2008-01-29 14:00:00	AMZN	Stock	3.6755	3.691	3.657	3.6845	23345040.0
2008-01-29 15:00:00	AMZN	Stock	3.684	3.721	3.675	3.7	36933860.0

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

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