PREVIEW / stock_1hour / 2007-11-26

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-11-26.parquet
  size:    809 KB
  rows:    40,220
  symbols: 3,213

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-11-26 04:00:00	AAPL	Stock	6.1993	6.1993	6.1993	6.1993	2800.0
2007-11-26 05:00:00	AAPL	Stock	6.21	6.21	6.21	6.21	2800.0
2007-11-26 06:00:00	AAPL	Stock	6.2189	6.2304	6.2143	6.2143	25200.0
2007-11-26 07:00:00	AAPL	Stock	6.2143	6.2143	6.1786	6.1889	1546608.0
2007-11-26 08:00:00	AAPL	Stock	6.1893	6.2232	6.1607	6.1893	10057460.0
2007-11-26 09:00:00	AAPL	Stock	6.1918	6.3036	6.1264	6.3036	200342548.0
2007-11-26 10:00:00	AAPL	Stock	6.3036	6.31	6.2336	6.2436	210615300.0
2007-11-26 11:00:00	AAPL	Stock	6.2436	6.2654	6.1932	6.2486	184348472.0
2007-11-26 12:00:00	AAPL	Stock	6.2486	6.3071	6.2475	6.2978	123395440.0
2007-11-26 13:00:00	AAPL	Stock	6.2968	6.3311	6.2679	6.2825	156411304.0
2007-11-26 14:00:00	AAPL	Stock	6.2821	6.3007	6.2393	6.2611	139531252.0
2007-11-26 15:00:00	AAPL	Stock	6.2618	6.265	6.1554	6.1634	237853224.0
2007-11-26 16:00:00	AAPL	Stock	6.1607	6.2539	6.1596	6.1621	39794944.0
2007-11-26 17:00:00	AAPL	Stock	6.1764	6.2802	6.1629	6.175	989688.0
2007-11-26 18:00:00	AAPL	Stock	6.175	6.1821	6.1618	6.1779	429128.0
2007-11-26 19:00:00	AAPL	Stock	6.1782	6.1821	6.1739	6.1786	418768.0
2007-11-26 07:00:00	MSFT	Stock	34.2	34.2	34.15	34.2	700.0
2007-11-26 08:00:00	MSFT	Stock	34.23	34.23	34.11	34.11	14048.0
2007-11-26 09:00:00	MSFT	Stock	34.15	34.35	33.96	34.35	7593012.0
2007-11-26 10:00:00	MSFT	Stock	34.35	34.37	33.86	33.88	9655133.0
2007-11-26 11:00:00	MSFT	Stock	33.88	34.06	33.72	33.77	8061033.0
2007-11-26 12:00:00	MSFT	Stock	33.77	33.86	33.67	33.75	7082713.0
2007-11-26 13:00:00	MSFT	Stock	33.75	33.82	33.63	33.67	8273978.0
2007-11-26 14:00:00	MSFT	Stock	33.67	33.75	33.42	33.47	12363297.0
2007-11-26 15:00:00	MSFT	Stock	33.46	33.5	32.93	32.99	25361786.0
2007-11-26 16:00:00	MSFT	Stock	32.98	33.648	32.94	33.03	3630706.0
2007-11-26 17:00:00	MSFT	Stock	33.0	33.735	33.0	33.01	11735.0
2007-11-26 18:00:00	MSFT	Stock	33.02	33.02	32.97	33.0	7377.0
2007-11-26 19:00:00	MSFT	Stock	33.0	33.03	33.0	33.02	8800.0
2007-11-26 08:00:00	NVDA	Stock	0.7612	0.77	0.7612	0.765	132000.0
2007-11-26 09:00:00	NVDA	Stock	0.7675	0.7698	0.752	0.7695	42898040.0
2007-11-26 10:00:00	NVDA	Stock	0.77	0.7705	0.7548	0.7553	43748240.0
2007-11-26 11:00:00	NVDA	Stock	0.7553	0.7605	0.7506	0.7513	44194720.0
2007-11-26 12:00:00	NVDA	Stock	0.7513	0.764	0.7513	0.7628	26902560.0
2007-11-26 13:00:00	NVDA	Stock	0.7625	0.7683	0.757	0.758	35716680.0
2007-11-26 14:00:00	NVDA	Stock	0.758	0.76	0.7473	0.749	46658080.0
2007-11-26 15:00:00	NVDA	Stock	0.7488	0.7492	0.7365	0.739	125187960.0
2007-11-26 16:00:00	NVDA	Stock	0.738	0.7535	0.7375	0.7393	20457320.0
2007-11-26 17:00:00	NVDA	Stock	0.754	0.754	0.754	0.754	24000.0
2007-11-26 18:00:00	NVDA	Stock	0.7388	0.7388	0.737	0.738	32320.0
2007-11-26 19:00:00	NVDA	Stock	0.7315	0.735	0.727	0.727	165600.0
2007-11-26 04:00:00	AMZN	Stock	4.068	4.068	4.068	4.068	4000.0
2007-11-26 08:00:00	AMZN	Stock	4.1	4.123	4.0925	4.115	627240.0
2007-11-26 09:00:00	AMZN	Stock	4.1165	4.1805	4.1	4.1765	24981920.0
2007-11-26 10:00:00	AMZN	Stock	4.1765	4.2245	4.155	4.159	30657380.0
2007-11-26 11:00:00	AMZN	Stock	4.161	4.1905	4.112	4.1375	26027080.0
2007-11-26 12:00:00	AMZN	Stock	4.139	4.195	4.1385	4.1805	14985340.0
2007-11-26 13:00:00	AMZN	Stock	4.182	4.205	4.1535	4.167	21247420.0
2007-11-26 14:00:00	AMZN	Stock	4.168	4.1815	4.132	4.138	16442440.0
2007-11-26 15:00:00	AMZN	Stock	4.1365	4.14	4.057	4.069	30969440.0

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

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