PREVIEW / stock_1hour / 2008-01-28

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-01-28.parquet
  size:    802 KB
  rows:    40,128
  symbols: 3,264

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-28 06:00:00	AAPL	Stock	4.5714	4.5714	4.5714	4.5714	2800.0
2008-01-28 07:00:00	AAPL	Stock	4.5979	4.62	4.5736	4.6071	528724.0
2008-01-28 08:00:00	AAPL	Stock	4.6071	4.6161	4.5489	4.5725	8125292.0
2008-01-28 09:00:00	AAPL	Stock	4.5714	4.6368	4.5161	4.628	238443044.0
2008-01-28 10:00:00	AAPL	Stock	4.6282	4.7079	4.5575	4.6807	304364144.0
2008-01-28 11:00:00	AAPL	Stock	4.6811	4.7571	4.6657	4.6759	198216900.0
2008-01-28 12:00:00	AAPL	Stock	4.676	4.7007	4.6429	4.6778	108127432.0
2008-01-28 13:00:00	AAPL	Stock	4.6775	4.7036	4.6696	4.6854	124107676.0
2008-01-28 14:00:00	AAPL	Stock	4.6857	4.7121	4.6207	4.6279	178785208.0
2008-01-28 15:00:00	AAPL	Stock	4.6289	4.6429	4.5564	4.6429	265410068.0
2008-01-28 16:00:00	AAPL	Stock	4.6429	4.6755	4.6059	4.6214	48228880.0
2008-01-28 17:00:00	AAPL	Stock	4.6214	4.6357	4.6035	4.6196	718620.0
2008-01-28 18:00:00	AAPL	Stock	4.6179	4.6179	4.6036	4.6043	639380.0
2008-01-28 19:00:00	AAPL	Stock	4.605	4.6225	4.605	4.6175	519624.0
2008-01-28 07:00:00	MSFT	Stock	32.73	33.0	32.73	32.82	5000.0
2008-01-28 08:00:00	MSFT	Stock	32.89	32.95	32.69	32.9	148883.0
2008-01-28 09:00:00	MSFT	Stock	32.91	33.1	32.78	32.96	10047454.0
2008-01-28 10:00:00	MSFT	Stock	32.96	33.02	32.65	32.87	16051543.0
2008-01-28 11:00:00	MSFT	Stock	32.87	32.93	32.72	32.73	9604657.0
2008-01-28 12:00:00	MSFT	Stock	32.74	32.79	32.45	32.55	9367000.0
2008-01-28 13:00:00	MSFT	Stock	32.55	32.7	32.5	32.59	7450647.0
2008-01-28 14:00:00	MSFT	Stock	32.59	32.72	32.55	32.56	9682592.0
2008-01-28 15:00:00	MSFT	Stock	32.569	32.74	32.42	32.72	15309256.0
2008-01-28 16:00:00	MSFT	Stock	32.71	33.01	32.6	32.61	3326832.0
2008-01-28 17:00:00	MSFT	Stock	32.61	32.72	32.61	32.71	47473.0
2008-01-28 18:00:00	MSFT	Stock	32.7	32.71	32.66	32.66	8105.0
2008-01-28 19:00:00	MSFT	Stock	32.67	32.69	32.65	32.66	3406.0
2008-01-28 08:00:00	NVDA	Stock	0.624	0.626	0.6125	0.6125	332000.0
2008-01-28 09:00:00	NVDA	Stock	0.617	0.6278	0.6031	0.613	53688320.0
2008-01-28 10:00:00	NVDA	Stock	0.6128	0.619	0.6038	0.6168	72640760.0
2008-01-28 11:00:00	NVDA	Stock	0.6168	0.619	0.609	0.6093	65883200.0
2008-01-28 12:00:00	NVDA	Stock	0.6094	0.6115	0.6066	0.61	58982760.0
2008-01-28 13:00:00	NVDA	Stock	0.6105	0.6195	0.6098	0.6143	79855120.0
2008-01-28 14:00:00	NVDA	Stock	0.6145	0.62	0.613	0.6142	77710600.0
2008-01-28 15:00:00	NVDA	Stock	0.6143	0.6162	0.6078	0.6162	134164280.0
2008-01-28 16:00:00	NVDA	Stock	0.6158	0.6246	0.6131	0.6162	21918640.0
2008-01-28 17:00:00	NVDA	Stock	0.6125	0.6165	0.61	0.61	95360.0
2008-01-28 18:00:00	NVDA	Stock	0.609	0.609	0.609	0.609	24000.0
2008-01-28 19:00:00	NVDA	Stock	0.6073	0.615	0.6073	0.615	10000.0
2008-01-28 07:00:00	AMZN	Stock	3.88	3.88	3.865	3.865	6000.0
2008-01-28 08:00:00	AMZN	Stock	3.8435	3.865	3.8145	3.824	219140.0
2008-01-28 09:00:00	AMZN	Stock	3.8175	3.87	3.784	3.8295	26324600.0
2008-01-28 10:00:00	AMZN	Stock	3.8295	3.867	3.7905	3.8415	27216040.0
2008-01-28 11:00:00	AMZN	Stock	3.846	3.86	3.81	3.8165	14078140.0
2008-01-28 12:00:00	AMZN	Stock	3.8155	3.819	3.79	3.7955	11787840.0
2008-01-28 13:00:00	AMZN	Stock	3.7965	3.821	3.7805	3.783	12811920.0
2008-01-28 14:00:00	AMZN	Stock	3.783	3.806	3.753	3.7605	20643100.0
2008-01-28 15:00:00	AMZN	Stock	3.76	3.86	3.717	3.7905	48592240.0
2008-01-28 16:00:00	AMZN	Stock	3.7905	3.7992	3.7493	3.776	7115460.0
2008-01-28 17:00:00	AMZN	Stock	3.7555	3.76	3.75	3.751	75500.0

> showing 50 of 40,128 rows — these rows as CSV

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