PREVIEW / stock_1hour / 2007-03-06

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-06.parquet
  size:    709 KB
  rows:    33,127
  symbols: 2,527

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-03-06 06:00:00	AAPL	Stock	3.1136	3.1289	3.1136	3.1289	61320.0
2007-03-06 07:00:00	AAPL	Stock	3.12	3.1364	3.1179	3.1204	1309028.0
2007-03-06 08:00:00	AAPL	Stock	3.1282	3.1321	3.1196	3.1304	3207596.0
2007-03-06 09:00:00	AAPL	Stock	3.13	3.1539	3.1286	3.1389	133718172.0
2007-03-06 10:00:00	AAPL	Stock	3.1386	3.1414	3.1214	3.1257	149491412.0
2007-03-06 11:00:00	AAPL	Stock	3.1254	3.1436	3.1254	3.1411	92906072.0
2007-03-06 12:00:00	AAPL	Stock	3.1407	3.1446	3.1286	3.1329	65329236.0
2007-03-06 13:00:00	AAPL	Stock	3.1325	3.1446	3.1286	3.1411	71614172.0
2007-03-06 14:00:00	AAPL	Stock	3.1411	3.1436	3.1321	3.1368	51272144.0
2007-03-06 15:00:00	AAPL	Stock	3.1368	3.1518	3.1325	3.1496	145043444.0
2007-03-06 16:00:00	AAPL	Stock	3.1475	3.1532	3.1464	3.1507	5457032.0
2007-03-06 17:00:00	AAPL	Stock	3.1518	3.1536	3.1381	3.1529	1185464.0
2007-03-06 18:00:00	AAPL	Stock	3.1521	3.1536	3.1507	3.1536	111692.0
2007-03-06 19:00:00	AAPL	Stock	3.1507	3.1536	3.15	3.1536	372512.0
2007-03-06 06:00:00	MSFT	Stock	27.75	27.76	27.75	27.75	2600.0
2007-03-06 07:00:00	MSFT	Stock	27.79	27.82	27.79	27.8	17540.0
2007-03-06 08:00:00	MSFT	Stock	27.8	27.94	27.77	27.85	79959.0
2007-03-06 09:00:00	MSFT	Stock	27.87	27.94	27.71	27.86	7729117.0
2007-03-06 10:00:00	MSFT	Stock	27.85	27.93	27.65	27.66	8783822.0
2007-03-06 11:00:00	MSFT	Stock	27.67	27.78	27.65	27.71	4530683.0
2007-03-06 12:00:00	MSFT	Stock	27.7	27.76	27.691	27.73	3560672.0
2007-03-06 13:00:00	MSFT	Stock	27.72	27.8	27.71	27.73	4306489.0
2007-03-06 14:00:00	MSFT	Stock	27.74	27.92	27.71	27.77	3537037.0
2007-03-06 15:00:00	MSFT	Stock	27.77	27.88	27.76	27.83	12000722.0
2007-03-06 16:00:00	MSFT	Stock	27.81	27.83	27.8	27.82	1015607.0
2007-03-06 17:00:00	MSFT	Stock	27.82	27.82	27.731	27.82	7900.0
2007-03-06 18:00:00	MSFT	Stock	27.82	27.84	27.82	27.83	6740.0
2007-03-06 19:00:00	MSFT	Stock	27.828	27.87	27.828	27.87	910.0
2007-03-06 08:00:00	NVDA	Stock	0.487	0.49	0.4857	0.49	745800.0
2007-03-06 09:00:00	NVDA	Stock	0.49	0.4958	0.4878	0.4933	79435140.0
2007-03-06 10:00:00	NVDA	Stock	0.4933	0.4992	0.491	0.4983	110834280.0
2007-03-06 11:00:00	NVDA	Stock	0.4982	0.5033	0.4972	0.5033	122689680.0
2007-03-06 12:00:00	NVDA	Stock	0.5035	0.5078	0.503	0.5077	105438240.0
2007-03-06 13:00:00	NVDA	Stock	0.5078	0.5102	0.5067	0.51	103236660.0
2007-03-06 14:00:00	NVDA	Stock	0.5102	0.513	0.51	0.5128	119147820.0
2007-03-06 15:00:00	NVDA	Stock	0.5128	0.5132	0.5068	0.5072	144426120.0
2007-03-06 16:00:00	NVDA	Stock	0.5073	0.5085	0.5073	0.5085	4125660.0
2007-03-06 19:00:00	NVDA	Stock	0.5092	0.5092	0.5092	0.5092	15000.0
2007-03-06 08:00:00	AMZN	Stock	1.9	1.956	1.887	1.887	1200000.0
2007-03-06 09:00:00	AMZN	Stock	1.887	1.891	1.8705	1.8785	17957440.0
2007-03-06 10:00:00	AMZN	Stock	1.8785	1.899	1.8735	1.8875	26610380.0
2007-03-06 11:00:00	AMZN	Stock	1.8875	1.89	1.8809	1.8885	15053080.0
2007-03-06 12:00:00	AMZN	Stock	1.8885	1.933	1.8881	1.923	45643960.0
2007-03-06 13:00:00	AMZN	Stock	1.923	1.9325	1.918	1.919	18827900.0
2007-03-06 14:00:00	AMZN	Stock	1.919	1.9215	1.91	1.9115	41482600.0
2007-03-06 15:00:00	AMZN	Stock	1.9115	1.93	1.911	1.9285	72580740.0
2007-03-06 16:00:00	AMZN	Stock	1.9285	1.935	1.9285	1.935	563540.0
2007-03-06 17:00:00	AMZN	Stock	1.9355	1.9355	1.8925	1.93	934000.0
2007-03-06 18:00:00	AMZN	Stock	1.9325	1.9325	1.93	1.93	93360.0
2007-03-06 19:00:00	AMZN	Stock	1.9325	1.935	1.93	1.935	54000.0

> showing 50 of 33,127 rows — these rows as CSV

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