PREVIEW / stock_1hour / 2008-10-03

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-10-03.parquet
  size:    823 KB
  rows:    40,597
  symbols: 3,325

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-03 07:00:00	AAPL	Stock	3.6679	3.6786	3.6293	3.6293	84952.0
2008-10-03 08:00:00	AAPL	Stock	3.6311	3.6911	3.6107	3.6561	7755944.0
2008-10-03 09:00:00	AAPL	Stock	3.6561	3.8036	3.3804	3.6436	642683468.0
2008-10-03 10:00:00	AAPL	Stock	3.6432	3.75	3.6071	3.7261	319594576.0
2008-10-03 11:00:00	AAPL	Stock	3.7271	3.7464	3.6964	3.7314	132211884.0
2008-10-03 12:00:00	AAPL	Stock	3.7311	3.75	3.6964	3.7475	105823956.0
2008-10-03 13:00:00	AAPL	Stock	3.7471	3.8	3.5071	3.6129	354192356.0
2008-10-03 14:00:00	AAPL	Stock	3.6125	3.6546	3.4036	3.6021	360253740.0
2008-10-03 15:00:00	AAPL	Stock	3.6021	3.6154	3.4082	3.4686	322337904.0
2008-10-03 16:00:00	AAPL	Stock	3.4689	3.7267	3.4475	3.4732	20962256.0
2008-10-03 17:00:00	AAPL	Stock	3.4761	3.4929	3.4646	3.4929	1865360.0
2008-10-03 18:00:00	AAPL	Stock	3.4861	3.6125	3.4786	3.4882	5229980.0
2008-10-03 19:00:00	AAPL	Stock	3.4893	3.4982	3.4857	3.4982	335636.0
2008-10-03 07:00:00	MSFT	Stock	26.3	26.48	26.3	26.47	1400.0
2008-10-03 08:00:00	MSFT	Stock	26.25	26.5	26.05	26.49	135371.0
2008-10-03 09:00:00	MSFT	Stock	26.48	27.0	26.34	26.85	10667994.0
2008-10-03 10:00:00	MSFT	Stock	26.85	26.98	26.77	26.93	12048650.0
2008-10-03 11:00:00	MSFT	Stock	26.93	27.21	26.93	27.08	10699033.0
2008-10-03 12:00:00	MSFT	Stock	27.08	27.42	27.05	27.335	12864497.0
2008-10-03 13:00:00	MSFT	Stock	27.34	27.47	26.36	26.77	25030021.0
2008-10-03 14:00:00	MSFT	Stock	26.79	27.15	26.37	26.91	15734732.0
2008-10-03 15:00:00	MSFT	Stock	26.901	26.91	26.24	26.29	20429645.0
2008-10-03 16:00:00	MSFT	Stock	26.31	26.892	26.25	26.35	5793857.0
2008-10-03 17:00:00	MSFT	Stock	26.32	26.47	26.32	26.33	122650.0
2008-10-03 18:00:00	MSFT	Stock	26.36	26.9	26.35	26.9	1781110.0
2008-10-03 19:00:00	MSFT	Stock	26.4	26.4	26.4	26.4	480.0
2008-10-03 08:00:00	NVDA	Stock	0.2435	0.2435	0.2435	0.2435	19000.0
2008-10-03 09:00:00	NVDA	Stock	0.24	0.2438	0.2345	0.2416	59498400.0
2008-10-03 10:00:00	NVDA	Stock	0.2418	0.2438	0.2372	0.2405	105346680.0
2008-10-03 11:00:00	NVDA	Stock	0.2408	0.2412	0.2358	0.2372	156128120.0
2008-10-03 12:00:00	NVDA	Stock	0.2375	0.2382	0.2355	0.2362	96037520.0
2008-10-03 13:00:00	NVDA	Stock	0.236	0.2372	0.2243	0.232	226380200.0
2008-10-03 14:00:00	NVDA	Stock	0.232	0.2355	0.2268	0.2338	132038880.0
2008-10-03 15:00:00	NVDA	Stock	0.2338	0.2348	0.2252	0.2263	127825120.0
2008-10-03 16:00:00	NVDA	Stock	0.2258	0.2343	0.225	0.2275	2501520.0
2008-10-03 17:00:00	NVDA	Stock	0.23	0.23	0.2298	0.2298	12000.0
2008-10-03 18:00:00	NVDA	Stock	0.226	0.2338	0.226	0.2338	25373400.0
2008-10-03 19:00:00	NVDA	Stock	0.2263	0.2275	0.2263	0.2275	57200.0
2008-10-03 07:00:00	AMZN	Stock	3.3	3.36	3.2005	3.36	28000.0
2008-10-03 08:00:00	AMZN	Stock	3.3875	3.423	3.3875	3.423	76900.0
2008-10-03 09:00:00	AMZN	Stock	3.445	3.5	3.3295	3.335	27345260.0
2008-10-03 10:00:00	AMZN	Stock	3.3405	3.4	3.3325	3.399	28566580.0
2008-10-03 11:00:00	AMZN	Stock	3.4	3.44	3.3755	3.432	18262480.0
2008-10-03 12:00:00	AMZN	Stock	3.4315	3.4935	3.4025	3.49	15565840.0
2008-10-03 13:00:00	AMZN	Stock	3.49	3.5475	3.423	3.465	44597160.0
2008-10-03 14:00:00	AMZN	Stock	3.464	3.467	3.337	3.3985	32455740.0
2008-10-03 15:00:00	AMZN	Stock	3.399	3.414	3.33	3.3425	42705220.0
2008-10-03 16:00:00	AMZN	Stock	3.3425	3.4092	3.3425	3.35	12625420.0
2008-10-03 17:00:00	AMZN	Stock	3.35	3.35	3.33	3.3485	40000.0
2008-10-03 18:00:00	AMZN	Stock	3.335	3.396	3.3325	3.396	500000.0

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

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