PREVIEW / stock_1hour / 2007-09-21

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-09-21.parquet
  size:    774 KB
  rows:    37,970
  symbols: 3,120

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-09-21 09:00:00	AAPL	Stock	5.0407	5.05	5.0221	5.0407	82314904.0
2007-09-21 10:00:00	AAPL	Stock	5.0404	5.1089	5.0371	5.1018	185654364.0
2007-09-21 11:00:00	AAPL	Stock	5.1014	5.1429	5.1011	5.1407	151922232.0
2007-09-21 12:00:00	AAPL	Stock	5.1407	5.1475	5.1329	5.1368	77965804.0
2007-09-21 13:00:00	AAPL	Stock	5.1371	5.1393	5.1164	5.1207	78315832.0
2007-09-21 14:00:00	AAPL	Stock	5.1211	5.1464	5.1189	5.1454	87877468.0
2007-09-21 15:00:00	AAPL	Stock	5.145	5.1661	5.1396	5.1496	176730848.0
2007-09-21 16:00:00	AAPL	Stock	5.1496	5.15	5.1464	5.1482	38254608.0
2007-09-21 09:00:00	MSFT	Stock	28.69	28.72	28.55	28.71	27729055.0
2007-09-21 10:00:00	MSFT	Stock	28.7	28.81	28.67	28.69	8238889.0
2007-09-21 11:00:00	MSFT	Stock	28.68	28.81	28.67	28.74	5705201.0
2007-09-21 12:00:00	MSFT	Stock	28.74	28.76	28.65	28.69	6244490.0
2007-09-21 13:00:00	MSFT	Stock	28.68	28.75	28.62	28.681	6412360.0
2007-09-21 14:00:00	MSFT	Stock	28.69	28.78	28.68	28.72	5281162.0
2007-09-21 15:00:00	MSFT	Stock	28.72	28.74	28.62	28.62	21039386.0
2007-09-21 16:00:00	MSFT	Stock	28.62	28.65	28.62	28.65	21304463.0
2007-09-21 08:00:00	NVDA	Stock	0.861	0.8638	0.861	0.8632	283120.0
2007-09-21 09:00:00	NVDA	Stock	0.8632	0.8682	0.8575	0.86	130083400.0
2007-09-21 10:00:00	NVDA	Stock	0.86	0.8718	0.8582	0.8688	49525880.0
2007-09-21 11:00:00	NVDA	Stock	0.869	0.875	0.8655	0.8685	44207120.0
2007-09-21 12:00:00	NVDA	Stock	0.8685	0.87	0.8645	0.8648	25339240.0
2007-09-21 13:00:00	NVDA	Stock	0.8648	0.8672	0.863	0.8658	34946640.0
2007-09-21 14:00:00	NVDA	Stock	0.8658	0.8678	0.8638	0.8638	35369160.0
2007-09-21 15:00:00	NVDA	Stock	0.8638	0.868	0.861	0.8622	67441000.0
2007-09-21 16:00:00	NVDA	Stock	0.8622	0.8625	0.8608	0.8621	32486880.0
2007-09-21 17:00:00	NVDA	Stock	0.8645	0.8645	0.8645	0.8645	4000.0
2007-09-21 18:00:00	NVDA	Stock	0.862	0.862	0.862	0.862	8000.0
2007-09-21 19:00:00	NVDA	Stock	0.862	0.862	0.862	0.862	32000.0
2007-09-21 08:00:00	AMZN	Stock	4.52	4.52	4.505	4.513	62200.0
2007-09-21 09:00:00	AMZN	Stock	4.517	4.52	4.4825	4.5095	33182400.0
2007-09-21 10:00:00	AMZN	Stock	4.51	4.5295	4.4945	4.52	14669140.0
2007-09-21 11:00:00	AMZN	Stock	4.52	4.571	4.507	4.5665	17213420.0
2007-09-21 12:00:00	AMZN	Stock	4.5665	4.57	4.5475	4.5625	9229400.0
2007-09-21 13:00:00	AMZN	Stock	4.563	4.568	4.5425	4.5432	6625140.0
2007-09-21 14:00:00	AMZN	Stock	4.5435	4.5775	4.5415	4.5675	10383200.0
2007-09-21 15:00:00	AMZN	Stock	4.5675	4.595	4.565	4.565	23340320.0
2007-09-21 16:00:00	AMZN	Stock	4.5675	4.581	4.565	4.5654	1532860.0
2007-09-21 17:00:00	AMZN	Stock	4.5675	4.5675	4.5675	4.5675	22000.0
2007-09-21 18:00:00	AMZN	Stock	4.5675	4.58	4.5675	4.58	60240.0
2007-09-21 19:00:00	AMZN	Stock	4.5655	4.5695	4.5655	4.5655	8040.0
2007-09-21 09:00:00	TLT	Stock	87.58	87.96	87.58	87.84	244300.0
2007-09-21 10:00:00	TLT	Stock	87.84	87.94	87.72	87.85	364700.0
2007-09-21 11:00:00	TLT	Stock	87.82	87.83	87.67	87.77	557200.0
2007-09-21 12:00:00	TLT	Stock	87.81	87.83	87.64	87.79	220900.0
2007-09-21 13:00:00	TLT	Stock	87.79	87.92	87.77	87.92	58000.0
2007-09-21 14:00:00	TLT	Stock	87.92	88.13	87.92	88.01	113600.0
2007-09-21 15:00:00	TLT	Stock	88.0	88.03	87.89	87.93	453300.0
2007-09-21 16:00:00	TLT	Stock	87.93	87.93	87.89	87.89	76400.0
2007-09-21 09:00:00	CL	Stock	35.24	35.24	35.07	35.1	1972400.0
2007-09-21 10:00:00	CL	Stock	35.105	35.18	34.935	35.075	518200.0

> showing 50 of 37,970 rows — these rows as CSV

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